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

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

DataDear gives you the option to download the Balance Sheet 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 Balance Sheet - 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.

    • Tracking Categories - Choose any tracking categories. You can choose multiple tracking categories and up to 1 option per category.

    • Select Standard Layout if applicable. This applies only to instances where custom report layouts under the Xero ‘Old’ reporting module were created.

    • Select the Report Layout if you want a Balance Sheet report format as opposed to a table with data.

    • 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 Balance Sheet Report