Cashflow Statement Template

Q1. How do I create a new Cashflow Statement template?

• Go to Settings > Templates > Reports > Accounting Tab, then click New Template (Cashflow Statement).

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

Q2. What settings can I customize in my Cashflow Statement template?

• The Cashflow Statement 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 Cashflow Statement 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. Requires at least two periods.

Q4. How do I add or delete columns in the Cashflow Statement 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 a Year-to-Date column.

  • 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 Cashflow Statement template?

• The Cashflow Statement template contains rows for Cash Summary, Operating Activities, Investing Activities, and Financing Activities.

  • Group Rows: Represent each major activity category. You can only edit the group name.

  • Text Rows: Allow you to insert custom text and can be added to both the group and child levels.

Q6. How do I add or delete rows in the Cashflow Statement template?

• To add a Text Row, hover and select +Text Row (available for both group and child levels).

• Note: It is not possible to group rows in the Cashflow Statement template.

Q7. Can I rename group-level rows in the Cashflow Statement 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 Cashflow Statement 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. How do I add a group within a group row?

• This is not possible in the Cashflow Statement template.

Q14. How do I duplicate a Cashflow Statement template?

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

Q15. What happens when I update a Cashflow Statement template?

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