How do I use the Trial Balance - Multiple Periods report?

Learn how to use the DataDear report ‘Trial Balance - Multiple Periods’ which can be used to compare the Trial Balance across different periods.

DataDear gives you the option to download the Trial Balance report in multiple periods which will help you analyse and understand how a business is evolving over time. There are few basic steps required to select the dates and reporting periods.

:bulb: This report can be used for both single organisations and for a group of organisations / companies and works for Xero and QuickBooks Online.

Choosing the Data / Report

  1. Open Excel, click on the DataDear tab and login using your email and password.

  2. Select the Organisation or the Group from the drop-down list.

  3. In the Report drop-down, select the Trial Balance - Multiple Periods report.

  4. Configure the report Conditions in the parameters window manually or using dynamic values from another sheet.

    • Month and Year - Select the month and year. The Trial Balance will be calculated as at the end of the selected month.

    • Period - Choose a reporting period between year (Year to Date) and month (For the Month).

    • Period as rows - The results will show the different comparative periods as rows instead of columns. (Useful to create other reports or pivot tables).

    • Full COA details - The report will contain additional data including the reporting codes and the organisation name - can be particularly useful for completing reporting packs.

    • Payments only - Only show the report based on Payments only.

  5. Configure the Comparative Periods.

    • Period - Choose if you wish to compare between Previous Months, Previous Quarters or Previous Years .

    • Total Periods - Number of comparative periods to compare backwards plus the current reporting period. 1 means only current period with no comparative periods.

    • Choose between Left to right* or Right to Left display order of the comparative periods.

  6. Click on the New Sheet or Current Sheet to generate the report. The comparative periods will be used to create the intervals backwards from the selected date based on the number of periods selected.

  7. Choose between having this report as a table (default) or as Raw Data .

  8. These parameters can be saved as a Preset so it will be faster to retrieve the same parameters in the future.

:bulb: The report contains 2 additional columns (Type and Reporting Code) which can be used to group and filter the data.

Sample Trial Balance Report