Edit

Share via

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

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.

Built-in key finance reports
Ad-hoc analysis on finance data
Financial analytics overview

Find free e-learning modules for Business Central here