Go to Settings > Templates > Reports > Accounting Tab, then click New Template (Ledger).
Alternatively, in Reports > Ledger, click the template selector (top right) and choose New Template.
The Ledger template has three tabs: General and PDF.
General: Edit template name, baseline period, header, and footer.
PDF: Customize layout, header, and footer for PDF version of the report.
Note: PDF preview and export are only supported for up to 8 columns.
The Ledger template supports the following columns:
Comparative Periods: Choose periods by comparison type (day/month/quarter/year) and display order.
Adjustable:
Date (locked)
Transaction (locked)
Description (locked)
Contact
Debit (PHP)
Credit (PHP)
Transaction Reference
Account
Account Type
Tracking Tags
Currency
Credit (Source)
Debit (Source)
Nano Classifiers
Capsule
Contact Group
Contact Relationship
Note: Date, Transaction, and Description are locked. This means you cannot hide or re-arrange them. (PHP) pertains to the org’s default currency.
To add comparative columns, click Compare (beside the baseline period date).
To show or hide columns:
Click the column icon at the top right of the template.
In the panel, you’ll see two lists: Hidden Columns and Selected Columns.
To show a column, move it from Hidden Columns to Selected Columns.
To hide a column, hover over it in the Selected Columns list and click the hide icon.
To arrange columns:
Click the column icon at the top right of the template.
In the Selected Columns list, hover over a row and drag it to your preferred position.
Go to Settings > Templates > Reports, hover over the template, click the three-dot icon, and select Duplicate.
Changes apply automatically. For previously downloaded reports, redownload them to apply updates.
