Financial Reports
This course covers Quickenerp's Financial Reports engine: the Balance Sheet, Profit & Loss, Cash Flow Statement, Executive Summary, General Ledger, Trial Balance, Partner Ledger, Aged Receivable/Payable, and Tax Report — how each one is built, what every line means, and how to configure them for your fiscal year and reporting needs.
| Responsible | System |
|---|---|
| Last Update | 07/21/2026 |
| Completion Time | 3 days 18 hours |
| Members | 1 |
Who Owes You, Who You Owe
Partner Ledger
Go to Accounting > Reporting > Partner Ledger. Every transaction for one or more selected customers/vendors — invoices, payments, credit notes — with a running balance. This is the report you send a customer when they ask "what's my current balance and history with you."
Aged Receivable
Go to Accounting > Reporting > Aged Receivable. Outstanding customer invoices bucketed by how overdue they are:
- Not Due / Current
- 1–30 days overdue
- 31–60 days overdue
- 61–90 days overdue
- 90+ days overdue
This is the standard collections tool — work the far-right (most overdue) buckets first, and watch for customers who consistently drift further right over time.
Aged Payable
The mirror image for vendor bills you owe — same aging buckets, used for cash-outflow planning: which bills are due soon, and which are already overdue on your side.
Reconciling to the Balance Sheet
The total of Aged Receivable should tie to the Balance Sheet's Receivables line, and Aged Payable to Payables — if they don't match, something was posted directly to the receivable/payable account outside the normal invoice/bill workflow and needs investigating.
Financial Reports Overview
View allWho Owes You, Who You Owe
Partner Ledger
Go to Accounting > Reporting > Partner Ledger. Every transaction for one or more selected customers/vendors — invoices, payments, credit notes — with a running balance. This is the report you send a customer when they ask "what's my current balance and history with you."
Aged Receivable
Go to Accounting > Reporting > Aged Receivable. Outstanding customer invoices bucketed by how overdue they are:
- Not Due / Current
- 1–30 days overdue
- 31–60 days overdue
- 61–90 days overdue
- 90+ days overdue
This is the standard collections tool — work the far-right (most overdue) buckets first, and watch for customers who consistently drift further right over time.
Aged Payable
The mirror image for vendor bills you owe — same aging buckets, used for cash-outflow planning: which bills are due soon, and which are already overdue on your side.
Reconciling to the Balance Sheet
The total of Aged Receivable should tie to the Balance Sheet's Receivables line, and Aged Payable to Payables — if they don't match, something was posted directly to the receivable/payable account outside the normal invoice/bill workflow and needs investigating.
Revenue, Costs, and Net Profit Over a Period
Go to Accounting > Reporting > Profit and Loss. Unlike the Balance Sheet, this report always covers a date range (default: this fiscal year to date).
The Waterfall
- Revenue – all income accounts.
- Less Cost of Revenue – direct costs of what you sold.
- = Gross Profit
- Less Operating Expenses – overhead, salaries, rent, etc.
- = Operating Income (or Loss)
- Plus Other Income / Less Other Expenses – non-operating items (interest, one-off gains/losses).
- = Net Profit
This Net Profit figure — scoped to the current fiscal year — is exactly what the Balance Sheet's "Net Income (Current Year)" line pulls in live.
Comparing Periods
Use the comparison filter to add columns for prior months/quarters/years side by side — the fastest way to spot a cost that's crept up or a revenue line that's slipping, rather than staring at one period in isolation.
Budgets on the P&L
If budgets are configured (see the Budgets course), enable "Show Budgets" to add a Budget column and variance alongside Actuals directly on this report.
The Detail Behind Every Summary Report
General Ledger
Go to Accounting > Reporting > General Ledger. Lists every journal item, grouped by account, for the selected period — the complete, unabridged audit trail. Use this when a summary report's number needs full line-by-line justification (for an auditor, or your own sanity check).
- Filter by account, journal, or partner.
- Each line shows date, journal, reference/description, debit, credit, and running balance.
- Click through to the originating invoice/bill/journal entry.
Trial Balance
Go to Accounting > Reporting > Trial Balance. One row per account: opening balance, total debit movement, total credit movement, and closing balance for the period.
- The classic checkpoint before closing a period: total debits must equal total credits across every account.
- Often exported to hand to an external accountant/auditor as the starting point for their own workpapers.
When to Use Which
Trial Balance answers "what's the balance of every account" at a glance; General Ledger answers "show me every transaction that built up to that balance" for one or a few accounts. Start with Trial Balance to spot which account looks wrong, then drill into General Ledger for that specific account.