When it comes to running a trial balance report for multiple locations, the repetitive nature of the work can be both tedious and time-consuming. Luckily, there’s a much more efficient solution that allows you to generate a comprehensive 24-month trial balance report with just a a few clicks. In this blog post, we will guide you through the process of setting up and running this report, saving you valuable time and sparing your fingers from excessive clicking.

Step 1: Setting up Account Groups

To begin, navigate to Reports > Setup > Account Groups. You’ll want to create three account groups to streamline the report generation process:

• TB-Accounts Group: This account group serves as a check to ensure that all accounts are included in the report. If no accounts have been left out, the total line will show as zero.

• TB-Balance Sheet Accounts Group: Assuming your balance sheet accounts fall within the range of 10000 through 39999, you’ll want to create this account group. Adjust the range if necessary to include assets, liabilities, and net income accounts. Remember to note the calculation method of “End of Period” for this group.

• TB-Income Statement Accounts Group: For income statement accounts falling within the range of 40000 through 99999, create this account group. Pay attention to the calculation method of “For Period” for accurate reporting.

Step 2: Building the Report

Proceed to Reports > All > Financial Reports. Name your report and select the “accounts” structure. Once you’ve done that, you can add the TB-Accounts group to the “rows” tab, which will ensure that all accounts are included in the report.

You’ll also want to update the first column — in the “columns” tab — to display the account number and name. Then, add two additional columns: Current Year-to-Date and Current Year (one prior period). Expand each of the two period columns by month to provide a comprehensive view of the 24-month trial balance.

Next, select the prompt checkbox that appears next to date and location to enable customization options when running the report.

Finally, save your configuration and click the preview button to view the report. You can also export it to Excel for further analysis and/or data manipulation.

Effortless Financial Reporting At Your Fingertips

By following these simple steps, you can generate a 24-month trial balance report with ease, saving time and effort compared to running the report multiple times for each location. Embrace the efficiency and accuracy of this streamlined approach, allowing you to focus on analyzing the financial data rather than getting lost in repetitive tasks. Upgrade your financial reporting process today with 24-month trial balance reports today and unlock the full potential of Intacct’s reporting capabilities.