AR/AP Reports
Manage cash flow with comprehensive accounts receivable and accounts payable reporting.
AR/AP Report Categories
AR/AP REPORTING OVERVIEW
═══════════════════════════════════════════════════════════════════════════════
┌─────────────────────────────────────────────────────────────────────────────┐
│ ACCOUNTS RECEIVABLE │
├─────────────────────────────────────────────────────────────────────────────┤
│ • AR Aging Summary Customer balances by aging bucket │
│ • AR Aging Detail Invoice-level aging │
│ • Open Invoices Unpaid invoices list │
│ • Customer Balance Total due by customer │
│ • Payment History Customer payment patterns │
│ • DSO Analysis Days Sales Outstanding │
└─────────────────────────────────────────────────────────────────────────────┘
┌─────────────────────────────────────────────────────────────────────────────┐
│ ACCOUNTS PAYABLE │
├─────────────────────────────────────────────────────────────────────────────┤
│ • AP Aging Summary Vendor balances by aging bucket │
│ • AP Aging Detail Bill-level aging │
│ • Open Bills Unpaid bills list │
│ • Vendor Balance Total due to vendors │
│ • Payment Schedule Upcoming payment obligations │
│ • DPO Analysis Days Payable Outstanding │
└─────────────────────────────────────────────────────────────────────────────┘
AR Aging Report
Overview
Track customer receivables by age to prioritize collections efforts.
Navigation: Reports → Customers → A/R Aging
AR Aging Summary
ACCOUNTS RECEIVABLE AGING SUMMARY
═══════════════════════════════════════════════════════════════════════════════
As of: December 31, 2024
┌─────────────────────────────────────────────────────────────────────────────┐
│ Customer │ Current │ 1-30 Days│31-60 Days│61-90 Days│ 90+ Days │
├────────────────────┼──────────┼──────────┼──────────┼──────────┼───────────┤
│ Acme Corporation │ $45,000 │ $28,000 │ $5,000 │ $0 │ $0 │
│ Global Industries │ $32,000 │ $15,000 │ $12,000 │ $8,000 │ $0 │
│ TechStart Inc │ $28,500 │ $0 │ $0 │ $0 │ $15,000 │
│ MegaCorp Ltd │ $22,000 │ $18,000 │ $4,500 │ $0 │ $0 │
│ Premier Solutions │ $18,000 │ $12,000 │ $8,000 │ $6,000 │ $4,500 │
│ ... │ ... │ ... │ ... │ ... │ ... │
├────────────────────┼──────────┼──────────┼──────────┼──────────┼───────────┤
│ TOTAL │ $425,000 │ $245,000 │ $128,000 │ $89,000 │ $65,000 │
│ % of Total │ 44.6% │ 25.7% │ 13.4% │ 9.3% │ 6.8% │
└────────────────────┴──────────┴──────────┴──────────┴──────────┴───────────┘
Total AR: $952,000
Aging Distribution:
Current ████████████████████████████████████████████▌ 44.6%
1-30 Days █████████████████████████▌ 25.7%
31-60 Days █████████████▌ 13.4%
61-90 Days █████████▌ 9.3%
90+ Days ██████▌ 6.8%
Collection Priority:
🔴 HIGH: $65,000 (90+ days) - 3 customers
🟡 MEDIUM: $89,000 (61-90 days) - 5 customers
🟢 NORMAL: $373,000 (0-60 days) - 42 customers
SuiteQL Query
-- AR Aging by Customer
SELECT
c.companyname AS customer,
SUM(CASE WHEN SYSDATE - t.duedate <= 0 THEN t.foreignamountunpaid ELSE 0 END) AS current_amt,
SUM(CASE WHEN SYSDATE - t.duedate BETWEEN 1 AND 30 THEN t.foreignamountunpaid ELSE 0 END) AS days_1_30,
SUM(CASE WHEN SYSDATE - t.duedate BETWEEN 31 AND 60 THEN t.foreignamountunpaid ELSE 0 END) AS days_31_60,
SUM(CASE WHEN SYSDATE - t.duedate BETWEEN 61 AND 90 THEN t.foreignamountunpaid ELSE 0 END) AS days_61_90,
SUM(CASE WHEN SYSDATE - t.duedate > 90 THEN t.foreignamountunpaid ELSE 0 END) AS days_90_plus,
SUM(t.foreignamountunpaid) AS total_ar
FROM
transaction t
JOIN
customer c ON t.entity = c.id
WHERE
t.type = 'CustInvc'
AND t.foreignamountunpaid > 0
GROUP BY
c.id, c.companyname
ORDER BY
total_ar DESC
AP Aging Report
Overview
Track vendor payables by age to manage cash flow and payment timing.
Navigation: Reports → Vendors → A/P Aging
AP Aging Summary
ACCOUNTS PAYABLE AGING SUMMARY
═══════════════════════════════════════════════════════════════════════════════
As of: December 31, 2024
┌─────────────────────────────────────────────────────────────────────────────┐
│ Vendor │ Current │ 1-30 Days│31-60 Days│61-90 Days│ 90+ Days │
├─────────────────────┼──────────┼──────────┼──────────┼──────────┼──────────┤
│ Tech Distributors │ $85,000 │ $42,000 │ $0 │ $0 │ $0 │
│ Component Supply Co │ $62,000 │ $28,000 │ $15,000 │ $0 │ $0 │
│ Office Essentials │ $18,500 │ $8,000 │ $4,500 │ $0 │ $0 │
│ Shipping Partners │ $12,000 │ $6,500 │ $0 │ $0 │ $0 │
│ Utilities Corp │ $4,200 │ $4,200 │ $4,200 │ $0 │ $0 │
│ ... │ ... │ ... │ ... │ ... │ ... │
├─────────────────────┼──────────┼──────────┼──────────┼──────────┼──────────┤
│ TOTAL │ $285,000 │ $142,000 │ $58,000 │ $12,000 │ $8,000 │
│ % of Total │ 56.4% │ 28.1% │ 11.5% │ 2.4% │ 1.6% │
└─────────────────────┴──────────┴──────────┴──────────┴──────────┴──────────┘
Total AP: $505,000
Payment Priority:
Due This Week: $125,000 (8 bills)
Due Next Week: $98,000 (12 bills)
Early Pay Discounts Available: $45,000 (save $900 if paid within 10 days)
Open Invoices Report
Overview
List all unpaid customer invoices with payment status.
Navigation: Reports → Customers → Open Invoices
OPEN INVOICES REPORT
═══════════════════════════════════════════════════════════════════════════════
┌──────────┬────────────────────┬────────────┬────────────┬───────────┬────────┐
│ Invoice │ Customer │ Date │ Due Date │ Amount │ Status │
├──────────┼────────────────────┼────────────┼────────────┼───────────┼────────┤
│ INV-1234 │ Acme Corporation │ 11/15/2024 │ 12/15/2024 │ $28,500 │ Open │
│ INV-1238 │ Global Industries │ 11/20/2024 │ 12/20/2024 │ $15,200 │ Open │
│ INV-1245 │ TechStart Inc │ 09/01/2024 │ 10/01/2024 │ $15,000 │ 90+ Day│
│ INV-1251 │ MegaCorp Ltd │ 12/01/2024 │ 12/31/2024 │ $22,800 │ Current│
│ INV-1256 │ Premier Solutions │ 10/15/2024 │ 11/14/2024 │ $4,500 │ 60 Day │
│ ... │ ... │ ... │ ... │ ... │ ... │
└──────────┴────────────────────┴────────────┴────────────┴───────────┴────────┘
DSO (Days Sales Outstanding)
Overview
Measure average collection period for receivables.
DSO ANALYSIS
═══════════════════════════════════════════════════════════════════════════════
Formula: DSO = (Accounts Receivable / Total Credit Sales) × Number of Days
┌─────────────────────────────────────────────────────────────────────────────┐
│ Current DSO Calculation (Last 12 Months) │
├─────────────────────────────────────────────────────────────────────────────┤
│ │
│ Accounts Receivable (Current): $952,000 │
│ Total Credit Sales (12 months): $8,450,000 │
│ Days in Period: 365 │
│ ───────────────────────────────────────────── │
│ DSO = ($952,000 / $8,450,000) × 365 = 41.1 days │
│ │
└─────────────────────────────────────────────────────────────────────────────┘
DSO Trend:
┌─────────────────────────────────────────────────────────────────────────────┐
│ │
│ 50 days ┼ │
│ │ ╱──╲ │
│ 45 days ┼ ╱ ╲ ╱╲ │
│ │ ╱ ╲ ╱ ╲ │
│ 40 days ┼ ╲──────╱ ╲────── │
│ │ │
│ 35 days ┼───────────────────────────────────────────────────────────── │
│ │ Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec │
│ │
│ Target DSO: 35 days │
│ Current: 41.1 days (18% above target) │
│ │
└─────────────────────────────────────────────────────────────────────────────┘
DSO by Customer Segment:
Enterprise: 38 days (best performers)
Mid-Market: 42 days (average)
Small Business: 52 days (needs attention)
Payment History
Overview
Track customer payment patterns and identify trends.
CUSTOMER PAYMENT HISTORY
═══════════════════════════════════════════════════════════════════════════════
Customer: Acme Corporation
Period: Last 12 Months
┌──────────┬────────────┬───────────┬────────────┬─────────────┬──────────────┐
│ Invoice │ Amount │ Due Date │ Paid Date │ Days to Pay │ Status │
├──────────┼────────────┼───────────┼────────────┼─────────────┼──────────────┤
│ INV-1012 │ $24,500 │ 01/15/24 │ 01/12/24 │ -3 │ Early │
│ INV-1045 │ $18,200 │ 02/20/24 │ 02/25/24 │ 5 │ Late (5d) │
│ INV-1078 │ $32,100 │ 03/18/24 │ 03/18/24 │ 0 │ On Time │
│ INV-1112 │ $28,500 │ 04/22/24 │ 04/20/24 │ -2 │ Early │
│ INV-1156 │ $22,800 │ 05/15/24 │ 05/28/24 │ 13 │ Late (13d) │
│ ... │ ... │ ... │ ... │ ... │ ... │
├──────────┴────────────┴───────────┴────────────┴─────────────┴──────────────┤
│ SUMMARY │
│ Average Days to Pay: 4.2 days past due │
│ On Time %: 67% │
│ Early %: 25% │
│ Late %: 8% │
└─────────────────────────────────────────────────────────────────────────────┘
Cash Flow Projection
AR/AP Combined View
CASH FLOW PROJECTION (Next 30 Days)
═══════════════════════════════════════════════════════════════════════════════
┌─────────────────────────────────────────────────────────────────────────────┐
│ Week │ AR Expected │ AP Due │ Net Cash │ Running │ │
├──────────────┼─────────────┼────────────┼────────────┼────────────┼─────────┤
│ Week 1 │ $125,000 │ $85,000 │ +$40,000 │ $40,000 │ ▲ │
│ Week 2 │ $98,000 │ $142,000 │ -$44,000 │ -$4,000 │ ▼ │
│ Week 3 │ $156,000 │ $68,000 │ +$88,000 │ +$84,000 │ ▲ │
│ Week 4 │ $112,000 │ $95,000 │ +$17,000 │ +$101,000 │ ▲ │
├──────────────┼─────────────┼────────────┼────────────┼────────────┼─────────┤
│ TOTAL │ $491,000 │ $390,000 │ +$101,000 │ │ │
└──────────────┴─────────────┴────────────┴────────────┴────────────┴─────────┘
Cash Position:
Current Cash: $485,000
Projected 30-Day: $586,000
Change: +$101,000 (+20.8%)
Next Steps
| Goal | Go To |
|---|---|
| Tax compliance | Tax Reports → |
| Build custom reports | Custom Reports → |