Skip to Content
Financial Reports

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
Accounting & Finance
Partner Ledger & Aged Receivable/Payable
Partner Ledger & Aged Receivable/Payable

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 all
Partner Ledger & Aged Receivable/Payable
Partner Ledger & Aged Receivable/Payable
Preview

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.

Reading the Profit and Loss Report
Reading the Profit and Loss Report
Preview

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

  1. Revenue – all income accounts.
  2. Less Cost of Revenue – direct costs of what you sold.
  3. = Gross Profit
  4. Less Operating Expenses – overhead, salaries, rent, etc.
  5. = Operating Income (or Loss)
  6. Plus Other Income / Less Other Expenses – non-operating items (interest, one-off gains/losses).
  7. = 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.

General Ledger & Trial Balance
General Ledger & Trial Balance
Preview

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.

This documentation is updated continuously. Some features described here may be renamed, deprecated, or still being finalized.