Accounting Reports
ERPNext provides several built-in accounting reports. Run from Reports → Accounting.
Profit & Loss
Profit and Loss Statement shows revenue, expenses and profit for a chosen period — the main "how did we do" report.
| Setting | What |
|---|---|
| Period | Yearly / Quarterly / Monthly / Weekly |
| From / To Date | Date range |
| Periodicity | Columns by Year, Quarter, Month |
| Filter by Cost Center / Project | Departmental P&Ls |
Output: Income → Expenses → Net Profit, with drill-down to General Ledger.
Common uses: "Monthly P&L year-to-date", "Q over Q growth", "Department profitability".
Balance Sheet
Balance Sheet shows what you own, owe, and the equity at a point in time.
Assets = Liabilities + Equity. The two totals must match — if they don't, there's a posting error.
Run as-of any date. Compare period-end snapshots side-by-side via Periodicity.
Common uses: Year-end statutory reporting, bank financing applications, ratio analysis (current ratio, debt level).
General Ledger
General Ledger is the audit trail — every individual posting that hit a chosen account, between two dates.
| Setting | What |
|---|---|
| From / To Date | Period |
| Account | One account, or leave blank for all |
| Party | Filter to one Customer / Supplier |
| Voucher Type | Filter to Sales Invoice / Payment Entry / Journal Entry / etc. |
| Group By | Voucher / Account / Party |
Drill-down to each individual transaction. Use when investigating "why is this account balance what it is".
VAT Return (BTW-aangifte)
On NL-localised sites, VAT Return mirrors the boxes on the Belastingdienst aangifte form for the period.
| Box | What |
|---|---|
| 1a, 1b | High-rate (21%) sales BTW |
| 1c | Low-rate (9%) sales |
| 1d | Zero-rated / exempt |
| 1e | Reverse charge sales (intra-EU B2B) |
| 2a | Reverse charge purchases received |
| 3a-c | Sales to EU countries |
| 4a, 4b | Purchases from EU countries |
| 5a-c | Totals, input BTW, net owed/refundable |
Submit through the Mijn Belastingdienst Zakelijk portal — ERPNext doesn't submit directly. Keep the PDF for audit.
Receivables Overview
Accounts Receivable shows who owes you money, by age bucket.
| Column | What |
|---|---|
| Customer | Name |
| Total Outstanding | Sum of unpaid invoices |
| 0-30 days | Within terms |
| 30-60 / 60-90 / 90+ days | Increasingly overdue |
Use for collections — chase the right customers, prioritise by amount and age. Total must match Debiteuren on the Balance Sheet.
Payables Overview
Accounts Payable is the mirror — what you owe suppliers, by age.
Use for payment planning — what to pay this week, what to defer. Generate SEPA payment batches against this list.
Trial Balance
Trial Balance shows opening and closing balances for every account plus the period's debit/credit activity. The auditor's favourite report — verifies that debits = credits across the entire ledger.
Cash Flow
Cash Flow Statement shows operating, investing and financing cash movements. Less commonly used in SMB but required for some statutory reporting.
Custom reports
For numbers ERPNext doesn't ship out-of-the-box, build a Report Builder report or ask Prilk support for a Custom Query Report.
Exporting and scheduling
All reports export to CSV / XLSX / PDF via Menu → Export. Schedule via Set → Auto Email Report:
- Monthly P&L to management
- Weekly Receivables aging to the credit controller
- Quarterly Trial Balance to the auditor
Tip — before relying on the numbers
The reports are only meaningful if your books are fully reconciled — bank reconciled, all invoices Submitted, payments allocated. Close the books properly before sharing reports externally.