As part of the year-end closing or ongoing balance checks of open-item accounts 311/325 within the accounting period, we use the "Payment Status as of Date" reports, which can be found in the received invoices/other payables and issued invoices/other receivables modules.
This check relates to the reconciliation of accounts linked to the payables ledgers (321/325) or receivables ledgers (311/315). Any discrepancies may arise from inaccurate data migration from another software system, or from postings made to open-item accounts across the accounting records without physically matching them to a payment in the form of a bank transaction, cash transaction, or mutual offset.
ℹ️ This output is launched from the invoices module and works with the payment status of the document. Do not confuse it with the accounting output Receivables/Payables Overdue, which can be found in Accounting under Accounting Outputs and which categorizes documents by number of days overdue, or with the balance, where settlement is determined by the matching symbol.
Contents:
The "Payment Status as of Date" Output
The output can be found in the invoices module, within the document list, under the "···" symbol (more options).
Before generating the output, it is necessary to select:
whether it should work only with data from the specific module in which the output is being launched, or whether it should also include other modules.
a specific date as of which the output is to be generated.
and finally, whether the calculation should use the posting date or the issue date of the documents.
Documents Included in the "Payment Status as of Date" Output
The output includes unpaid or partially paid documents in the selected modules as of the specified date.
Print Reports
Below the overview, there is a "Print" button, which contains the following print reports.
Payment Status as of Date (by Company)
This is a report sorted by business partner with a summary of included documents. All documents are included (including foreign-currency documents), with values shown in the home currency only.
Payment Status as of Date (by User Sort Order)
This report outputs documents in the order set by the user in the module — for example, sorted by internal document number in ascending or descending order. All documents are included (including foreign-currency documents), with values shown in the home currency only.
Payment Status as of Date in Currency
This report outputs documents with the currency broken out and documents summarized per currency.
Receivables and Payables Inventory
This output is used during the year-end closing to reconcile the status of receivables and payables with the counterparty.
Totals
Below the overview there is also a "Totals" button, which displays the total outstanding amount (the amount your customers have not yet paid).
The totals view shows a breakdown of the net base amount of the included documents as well as the VAT rate and VAT amount for those documents.
General Checks of Accounting Outputs
When generating the "Payment Status as of Date" output, we should verify:
whether all documents have been posted
that they do not carry the "exclude from balance" flag
that documents do not have a payment status of "manual"
If a document carries the value "paid manually", this flag is also reflected in the "Payment Status as of Date" output. "Paid manually" should be used primarily by companies that do not maintain full accounting records in the application — i.e., without a cash register or bank module. "Paid manually" ensures that the document visually appears as paid in the invoices module, meaning it will not be included in the "Payment Status as of Date" output and will not be offered for inclusion in a payment order.
A complication may arise, however, when a document marked as paid in this way does not clear the balance of the account it is posted to — which in a standard payment would occur via the entry 321/221 (211) or 221 (211)/311.
During the year-end closing, the account balances are then compared across the following accounting outputs:
Trial balance
Payment Status as of Date
Balance (unpaid)
For more information on this topic in cases of differing balances, please refer to the attached documentation "Checking Differing Balances".