AR vs AP
The AR vs AP dashboard puts accounts receivable and accounts payable side by side to compare what's owed to you against what you owe. It covers aging balances, overdue exposure, and income vs. expenses in a single view. Use this dashboard to monitor the balance between incoming and outgoing cash, track overdue items on both sides, and identify the customers and vendors with the largest outstanding amounts.
The top row compares AR and AP through aging charts and gauges. The aging charts break down outstanding balances by period (1 to 30 days, 31 to 60 days, 61 to 90 days, 91+ days), while the gauges show how much of total invoices are overdue on each side. The bottom row highlights the top 10 customers and vendors by amount due, with an Income and Expenses chart in the center for broader financial context.
How to use this dashboard
- Compare AR and AP aging side by side to see if overdue receivables and payables are balanced or skewed.
- Monitor overdue exposure using the gauges to see what proportion of total invoices are past due.
- Identify top overdue accounts on both the customer and vendor side for follow up.
- Review income vs. expenses to add broader financial context to the AR/AP picture.
Key performance indicators (KPIs)
Key performance indicators (KPIs) are displayed at the top of the dashboard. They give you an at a glance summary of the current cost situation and update based on the filters you apply.
| KPI | What it measures |
|---|---|
| Receivable Invoice Total | Total value of all customer invoices. |
| Receivable Due Amount | Total overdue amount owed by customers. |
| Payable Invoice Total | Total value of all vendor invoices. |
| Payable Due Amount HC | Total overdue amount owed to vendors in home currency. |
Visual components
| View | Type | What it shows |
|---|---|---|
| Aging Receivable | Vertical Bar | Shows outstanding customer invoices by aging period (1 to 30 days, 31 to 60 days, 61 to 90 days, 91+ days). |
| Receivable Overdue vs Total | Gauge | Shows how much of total receivables are overdue, with the needle indicating the due amount relative to the invoice total. |
| Payable Overdue vs Total | Gauge | Shows how much of total payables are overdue, with the needle indicating the due amount relative to the invoice total. |
| Aging Payable | Vertical Bar | Shows outstanding vendor invoices by aging period (1 to 30 days, 31 to 60 days, 61 to 90 days, 91+ days). |
| Top 10 Customer AR Due | Stacked Bar | Ranks the 10 customers with the highest overdue balances, broken down by aging period. |
| Income and Expenses | Vertical Bar | Compares revenue, expenses, and other income and expenses side by side. |
| Top 10 Vendors AP Due | Stacked Bar | Ranks the 10 vendors with the highest outstanding payables, broken down by aging period. |
Filters
Use the filtering panel at the top of the dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
- Customer
- Vendor