Q1. How do I create a new Profit & Loss template?
Go to Settings > Templates > Reports > Accounting Tab, then click New Template (Profit & Loss).
Alternatively, in Reports > Profit & Loss, click the template selector (top right) and choose New Template.
Q2. What settings can I customize in my Profit & Loss template?
Profit & Loss template has three tabs: General, PDF, and Actions.
General: Edit template name, baseline period, header, sorting, 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.
Actions: Perform specific functions on a selected column or row.
Q3. What columns are supported in the Profit & Loss template?
Comparative Periods: Choose date range, comparison type (day/month/quarter/year), and display order.
Variance: Show changes between two columns (amount or %). Multiple allowed.
Year-to-Date: Show totals from start of year to selected period. Multiple allowed.
Account Code: Display Chart of Account codes. Only one allowed.
Q4. How do I add or delete columns in the Profit & Loss template?
By default, only the baseline period column is shown.
To add columns:
Click Compare to add additional period columns.
Hover over a column line to add Year-to-Date or Account Code columns.
Hover over a column line and add Variance once at least two comparison periods are available.
To delete a column, click the column, then under Actions, select Delete Column.
Q5. What are the different types of rows in the Profit & Loss template?
Accounts that are included in the Profit & Loss template are grouped into Group-level Rows (bold texts) and Child-level Rows.
Group-level Rows represent a group of accounts where you can:
Rename the group.
Show or hide group totals.
Hide the group if all child rows are hidden.
Set account criteria to define which accounts are included.
Set negative balance rules.
Child-level Rows represent individual account rows where you can:
Create new account groups.
Set negative balance rules.
Group selected accounts together by choosing Create New Account Group (accounts below will be grouped under it).
Text Rows allow you to insert custom text and can be added to both group and child levels.
Q6. How do I add or delete rows in the Profit & Loss template?
To add a Group Row, hover over a row line and click +Account Group. Enter the group name and account criteria.
To add a Text Row, hover and select Add Text Row (available for both group and child levels).
Q7. Can I rename group-level rows in the Profit & Loss template?
Yes, click on the group row and rename accordingly.
Q8. What is the decorator function in Template Style for?
Turning on decorators for Template styles adds a horizontal line on top of the report.
Q9. What is the uppercase function in Fonts for?
Turning on uppercase converts all text in the report to uppercase.
Q10. Can I add a logo to my Profit and Loss Template?
Yes, go to Template Settings > PDF > Add a logo
Logo file should only be up to 1mb with min width: 120px and min height: 60px
Q11. Can I change the display currency?
Yes, to change the display currency, click the base currency.
The report will be converted from base currency to display currency at the exchange rate on report date. If there're multiple periods, all periods will be converted at the same exchange rate.
Q12. What is the dynamic string in the PDF Date Title for?
You can use the dynamic string for dates to configure your date title according to your preferred format.
Q13. Can I add another group within a group row?
Yes, you can add sub-groups within a group row.
Q14. My account is not appearing in my Profit & Loss template, what do I do?
Check your Chart of Accounts to ensure the account type is included in the Profit & Loss report.
Q15. What is the Negative Balance rule and how do I use it?
The Negative Balance rule defines what happens when an account amount falls below zero. Rules can be applied at both the Group-level Row and Child-level Row.
Group Row Rules
Choose conditions such as “if accounts are negative” or “if the entire group is negative.”
Move negative balances to another group or convert them to positive values.
Child Row Rules
When an individual account is negative, you can move it to a selected group.
Note: Account-level (child row) rules take precedence over group-level rules. Check for conflicts when both are applied.
Q16. How do I combine accounts into one row or one group?
You can combine multiple accounts into a single group row or group.
To select multiple accounts:
Press Cmd/Ctrl + Left Click: Select specific accounts individually.
Press Shift + Left Click: Select a range of accounts.
Then from the action tab, choose to combine into a single row or a group.
Q17. How do I split combined accounts in Profit and Loss Template?
You can split a combined account row or group by selecting the row and from the action tab, select split accounts or remove group.
Q18. How do I hide an account row with zero balance?
Yes. Select the row and check Hide Row if Zero Balance.
Q19. How do I duplicate a Profit & Loss template?
Go to Settings > Templates > Reports, hover over the template, click the three-dot icon, and select Duplicate.
Q20. What happens when I update a Profit & Loss template?
Changes apply automatically. For previously downloaded reports, redownload them to apply updates.
Q21. Can I have more than one template for different situations?
Yes, you can create multiple Profit & Loss Templates to cover different report situations.
Q22. If I add a new account to my COA, will it automatically show up in my template?
Yes, any new account added to your COA will automatically appear in your Profit & Loss template based on the criteria you’ve set for your groups.