Everybody knows that the Trial Balance report is the sum of debits and credits for every account of your business. In a nutshell, this Trial Balance report allows you to identify discrepancies in your account totals, produce financial statements, and ensure that your accounts are balanced for any given time period. To enhance this report, we added a new Net Movement feature. Now this report shows the account balances based on the selected date range, account information (code, name, type), and net movement.

How can I create a Trial Balance Net Movement Report?

To get accounting report data from Xero, you first need to be logged into Xero. Then, you need to select Add-ons -> G-Accon for Xero -> Get Accounting Reports -> Trial Balance Net Movement.

Click the Trial Balance Net Movement option from the drop down menu. G-Accon for Xero gives you the ability to set up the Balance Date for your data either manually or by setting your data to update dynamically.

Trial Balance Net Movement Report

Select the Trial Balance Net Movement option from the drop down menu. G-Accon for Xero provides you with the ability to set up the Date Range for your data manually or you can refresh your data dynamically. For your convenience, there are repopulated values such as This Month, This Quarter, This Year, Last Month, and more.

Trial Balance Net Movement

You also can use the pop-up calendar or load the value from your Google Spreadsheet cell.

In order to switch to dynamic Data Rage you need to click on the button “Switch to Dynamic Date”. You have the ability to set up the Balance Date dynamically. The report data will be calculated based on the selected Date Range.

The report data will now be calculated based on the selected Balance Date.

There are various required and optional attributes for the Trial Balance Net Movement report:

  1. Balance Date (Date format should be DD, MM, YYYY). You can select the static or dynamic date range to generate the report
  2. Compare To (Previous Day, Previous Month, Previous Year)
  3. To Compare with (from 1 to 24) previous periods 
  4. Sort Previous Periods (Ascending/Descending)
  5. Cash Basis (False/True)
  6. Column Title. You can pick which columns you want to include.

Xero provides Optional features that might be useful for your business.

Change Pull Settings

Change Pull Settings allows you to perform the following operations:

  1. Create a new Google Sheet
  2. Display Report Title
  3. Create Deep Link to Xero
  4. Display only account codes
  5. Display only account names
  6. Keep Original Formatting
  7. Remove total/summary rows
  8. Retrieve headers
  9. Create a Data Table around pulled data
  10. Freeze Data Table Header
  11. Exclude Auto Refresh
  12. Display report summaries
  13. Remove entry diving rows
  14. Show “Account Type” column

You can also provide the start cell – for example, A11. You can also provide the name of the template in Template Name field – for example, Template #1.

The Multi-Currency Converter allows you to view all of your reports in multi-currency, convert back to your base currency, and share your reports with your customers, clients, and management.

How can I schedule an automatic refresh?

To schedule the auto refresh, you can create a workflow through the option Create Workflow and schedule both the auto refresh and notification processes. Automatic workflow allows users to create different workflows, include specific templates, set up different schedules for various workflows, and notify the customers, clients, and other team members using different automatic notifications within the same spreadsheet. See the Automation process for further explanation.

To execute the process, click on the “Execute” button. The Trial Balance Net Movement details will be populated in the Google Sheet.

Executed Trial Balance Net Movement report