Cash Balance Template

Q1. How do I create a new Cash Balance template?

• Go to Settings > Templates > Reports > Additional Tab, then click New Template (Cash Balance).

• Alternatively, in Reports > Cash Balance, click the template selector (top right) and choose New Template.

Q2. What settings can I customize in my Cash Balance template?

• The Cash Balance template has three tabs: General, PDF, and Actions.

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

  • Actions: Perform specific functions on a selected column.

Q3. What columns are supported in the Cash Balance template?

• The Cash Balance template supports the following columns:

  • Comparative Periods: Choose periods by comparison type (day/month/quarter/year) and display order.

  • Adjustable:

    • Account Code (locked)

    • Account Name (locked)

    • Account Type

    • Status

    • Account Currency

    • Balance

    • Balance (PHP)

    • Note: Account Code and Account Name are locked. This means you cannot hide or re-arrange them. (PHP) pertains to the org’s default currency.

Q4. How do I select/hide/arrange columns in the Cash Balance template?

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

Q5. What is the decorator function in Template Style for?

• Turning on decorators for Template styles adds a horizontal line on top of the report.

Q6. What is the uppercase function in Fonts for?

• Turning on uppercase converts all text in the report to uppercase.

Q7. Can I add a logo to my Cash Balance 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

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

Q9. How do I duplicate a Cash Balance template?

• Go to Settings > Templates > Reports, hover over the template, click the three-dot icon, and select Duplicate.

Q10. What happens when I update a Cash Balance template?

• Changes apply automatically. For previously downloaded reports, redownload them to apply updates.