---
title: "Accounting Reports"
space: "ERPNext"
url: "https://www.prilk.com/docs/erpnext/accounting-reports"
updated: "2026-05-15"
---

## 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.