Receivables-Payables (report)
The Receivables-Payables report shows a summary of outstanding accounts receivable (AR) and accounts payable (AP) balances and compares them to the general ledger (G/L). You can select a posting date and currency to tailor the report.
The report displays a side-by-side comparison of customer and vendor balances versus their respective G/L control accounts. This helps confirm consistency and highlight reconciliation issues.
Use cases
Reconcile subledger balances for accounts receivable (AR) and accounts payable (AP) with their respective general ledger (G/L) control accounts. This report is especially useful during financial close or when investigating discrepancies between subledger and ledger data.
Controllers and finance teams can use the report to:
- Reconcile AR and AP subledger balances with their respective G/L control accounts during financial close.
- Identify discrepancies between subledger and ledger balances.
- Confirm consistency and highlight reconciliation issues.
- Quickly verify if AR and AP subledgers match their respective control accounts in the G/L.
Auditors can use the report to:
- Verify that customer and vendor balances align with the G/L.
- Investigate mismatches that could indicate posting errors or timing issues.
Try the report
Try the report here: Receivables-Payables
Tip
Tip:
If you hold down the CTRL key while you select the report link, the report opens on a new browser tab. In this way, you can stay on the current page while you explore the report on the other browser tab.
Related information
Built-in key finance reports
Ad-hoc analysis on finance data
Financial analytics overview