Customer and vendor reports
The customer and vendor reports show who owes what, for how long, and every movement on their accounts. The two sets mirror each other.
Open Reports›Customers for receivables, or Reports›Vendors for payables.
Balances and statements
| Report | What it shows |
|---|---|
| Balances | What each customer owes you, or what you owe each vendor, on a date, less unused credits. |
| Balance Summary | The opening balance, invoiced or billed, received or paid, and closing balance for each one over a period. |
| Statement, Statement (Dr / Cr) | Every transaction on one account with a running balance; the Dr / Cr version shows debit and credit columns. Send it to the customer or check it against the vendor's statement. |
| Trial Balance | Opening Dr / Cr, the period's debits and credits, and closing Dr / Cr for each one. |
| Balances (Dr / Cr) | Each closing balance on a date, in debit and credit columns. |
| Ledger | The postings of every customer or vendor for a period, with opening, running and closing balances. |
| Opening Balances | Each opening balance with the amount paid against it and what is still outstanding. |
Aging and credits
- AR / AP Aging Summary: each one's unpaid amount split by how long it has been overdue.
- AR / AP Aging Details: every unpaid invoice or bill and opening balance, with its due date, days overdue and aging bucket. Use it to chase payments.
- Customer Credits / Vendor Credits Available: credit notes, vendor credits and excess payments held as credit, used and unused.
- Refund History: refunds paid to customers, or received from vendors.
Post-dated cheques
- PDC Register: every cheque received or issued in the period, with its number, date, bank, amount and status.
- Pending PDCs by Maturity: cheques not yet cleared, with the days to their date, to plan deposits and bank balances.
- PDC Summary: pending, cleared, bounced and cancelled cheques for each customer or vendor.
- Bounced Cheques, with the reason.
Purchases (vendors)
Purchases by Vendor, Purchases by Item, Bill Details (with paid, balance and days overdue), Vendor Credit Details, and Payments Made.
Can't find what you need? Write to info@exlerithub.com or chat with us on WhatsApp.