Use the Posted Payment Register to review accounting lines for payments that have been transferred and posted to general ledger. Because it presents amounts that have been charged to liability accounts, this report is valid only for an accrual ledger. You can submit the Posted Payment Register for one payment journal entry batch or all payment journal entry batches.
The Posted Payment Register is primarily a reconciliation tool. Use this report along with the Posted Invoice Register and the Accounts Payable Trial Balance Report to reconcile balances between Payables and your general ledger. To make the output easier to read, each of these reports can be generated for a single liability account. For example, if you are using Automatic Offsets and the liability for your invoices is allocated across multiple balancing segments, then you can use the Liability Account parameter to limit your reports to a single balancing organization. See: Automatic Offsets.
You can generate the report in summary or in detail. When generated in detail, the report displays payments that relieve liability accounts and that have had their accounting information transferred to the general ledger. Also included is the supplier and amount information for each payment listed. Payables displays the payment amount in the entered currency and the liability amount relieved in the accounted currency. In detail mode, the report also displays the payment document and disbursement type for each batch of payments. It provides a report total and subtotals for each payment document and bank account.
When generated in summary, the report lists totals for each liability account and does not include any payment detail.
The report always sorts first by liability account. If the report is submitted in detail, it then sorts in the following order:
The report sorts using the Order By parameter, either Journal Entry Batch or Bank Account. The default value is Bank Account, and you can change the parameter value to Journal Entry Batch only if the report includes journal entry batch names (the Include Journal Entry Batch parameter is Yes).
The report then sorts by payment number, payment date, and supplier name.
Prerequisite
To ensure that the general ledger information for the journal entry batches appears on this report, you must enable the Import Journal References option for the Payables source in the Journal Sources window. See: Defining Journal Sources
To review information for parameters used in multiple reports, such as Ledger Currency, see: Common Report Parameters.
From/To Accounting Date. Inclusive accounting date range for payments in the report.
Bank Account Name. If you want to limit the report to payments paid from a single bank account, enter the bank account name.
Liability Account. Enter the liability account for which you want to submit this report. Leave the field blank to submit this report for all liability accounts.
Include Journal Entry Batch. Enter Yes if you want the report to include the names of all journal entry batches in which the payment transactions were transferred. Note that if you choose to include this information the report will take longer to generate.
Journal Entry Batch. Enter the journal entry batch name for which you want to submit this report. Leave the field blank to submit this report for all payment journal entry batches.
Order By. This parameter is used to sort reports that are generated in detail. The default value is Bank Account. You can select the Journal Entry Batch option only if you first enter Yes for the Include Journal Entry Batch parameter.
Bank Account. Sort the report by:
1) liability account
2) bank account
3) journal entry batch name (only if you enter Yes for the Include Journal Entry Batch parameter.)
4) payment currency
Journal Entry Batch. Sort the report by:
1) liability account
2) journal entry batch name
3) bank account
4) payment currency
Summarize Report.
Yes. List totals for each liability account and do not include payment detail.
No. Include payment detail.
Payment Number. Payment document number.
Payment Date. Date of payment.
Payment Amount. Amount of the payment in the transaction currency.
Liability Relieved. The amount of liability relieved by the payment, displayed in the accounted currency.