Financial Reports
Frappe Books provides four built-in financial reports that help you analyze your company’s financial performance and accounting records. Each report is generated using the General Ledger entries created whenever a transactional entry is recorded.
These reports allow you to review financial data, apply filters, and export information for further analysis or reporting.
Tip
All financial reports are generated directly from General Ledger entries, ensuring that report values always reflect your recorded transactions.
Available Financial Reports
Frappe Books includes the following financial reports:
| Report | Purpose |
|---|---|
| General Ledger | Displays all ledger transactions recorded for accounts. |
| Profit and Loss | Summarizes income, expenses, and net profit or loss. |
| Balance Sheet | Shows the company’s assets, liabilities, and equity. |
| Trial Balance | Displays debit and credit balances of all ledger accounts. |
Report Sections
Each financial report consists of two main sections:
| Section | Description |
|---|---|
| Filter Section | Allows you to apply filters such as date range before generating the report. |
| Report Section | Displays the generated report based on the selected filters. |
Using Filters
After selecting a filter such as a date range, simply click outside the filter field to regenerate the report with the updated values.
General Ledger Pagination
The General Ledger report includes pagination controls at the bottom of the report, allowing you to navigate through large sets of ledger entries efficiently.
Export Reports
All financial reports can be exported for further analysis or sharing.
- Open the required financial report.
- Apply any necessary filters.
- Click the Export button.
- Select the desired file location.
- Choose the export format.
| Export Format | Purpose |
|---|---|
| CSV | Open and analyze data in spreadsheet applications. |
| JSON | Use report data for integrations or further processing. |
Exported CSV files can be opened using spreadsheet applications such as LibreOffice Calc, Google Sheets, or Microsoft Excel.
Available Reports
- General Ledger
- Profit and Loss
- Balance Sheet
- Trial Balance
Best Practices
- Apply appropriate date filters before reviewing reports.
- Export reports in CSV format for detailed spreadsheet analysis.
- Use the General Ledger report to verify accounting transactions.
- Review Profit and Loss and Balance Sheet reports regularly to monitor business performance.
