The AP/AR Comparison Report shows accounts receivable and accounts payable aging totals side by side.
What this report is for
Use AR/AP Comparison to compare current receivable balances against payable balances by aging bucket.
This report is read-only. It does not record payments, change invoice statuses, create vendor payments, or update due dates.
Screen path
Dashboard > Finance > Reports > AR/AP Comparison
The screen title is AP/AR Comparison Report.
Report layout
The report loads automatically when opened.
Columns are:
| Column | What it shows |
|---|---|
Current |
Current AR or AP balance. |
1-30 Days |
Balance in the 1-30 day aging bucket. |
31-60 Days |
Balance in the 31-60 day aging bucket. |
61-90 Days |
Balance in the 61-90 day aging bucket. |
91+ Days |
Balance in the 91+ day aging bucket. |
Total |
Total AR or AP balance. |
Rows are:
| Row | What it shows |
|---|---|
Accounts Receivable (AR) |
AR aging totals. |
Accounts Payable (AP) |
AP aging totals. |
Running Gap |
AR minus AP, calculated cumulatively across the aging buckets. |
Use Refresh to reload the report. Use Close to return to the Financial Reports menu.
Running gap
The running gap helps show whether receivables cover payables as each aging bucket is included.
A positive gap means AR is greater than AP through that point in the aging sequence. A negative gap means AP is greater than AR through that point.
What happens behind the scenes
Opening the report reads the same AR aging and AP aging summary data used by their canonical reports.
AR aging is based on current open customer invoice balances, adjusted for payments, discounts, returns, and available unapplied credits in the aging logic.
AP aging is based on submitted or partially paid vendor invoices that are not deleted, less vendor payments.
The report uses current aging buckets. It is not an as-of historical aging report.
Troubleshooting
The report fails to load
Likely cause: Either the AR aging or AP aging source report failed.
Safe fix: Open AR Aging Report Overview and AP Aging Report Overview separately to identify which source is failing.
Contact support if: Both source reports load but AR/AP Comparison still fails.
The running gap is negative
Likely cause: Accounts payable exceeds accounts receivable through the displayed aging buckets.
Safe fix: Review customer collections, open vendor invoices, due dates, and payment plans. Do not alter due dates or balances just to improve the comparison.
Contact support if: The underlying AR or AP totals appear wrong.
Totals differ from the General Ledger
Likely cause: AR/AP Comparison uses open aging data, while the General Ledger uses posted journal entry lines.
Safe fix: Reconcile the detailed aging reports to the GL before making any adjustment.
Contact support if: The same invoice population still does not reconcile.