Can I import a trial balance from the bookkeeping APIs for a period longer or shorter than a year?

Article ID: 2802
Last updated: 18 Apr, 2024

Currently, the function to read information from third party APIs for Xero, FreeAgent and QuickBooks online only records a client’s financial year end date so it is only possible to obtain a trial balance for a full financial year. 

Where a period exists, there are two possible solutions available to users:

  1. Temporarily amend the accounting period dates (in TaxCalc and the third party) to display as a 12 month period.
    1. This is purely for the purpose of the import and the dates can be amended back after the import is complete. Please note in TaxCalc, this will be complete on the window where you initially open the accounting period by using the Edit Period button
  2. Utilise the import from CSV function to proceed.
    1. This will require an export of the trial balance in CSV format with the appropriate data and to manually import the data by mapping the CSV data to TaxCalc. More information on how to import a trial balance in CSV format can be found by clicking on the link for How do I import a Trial Balance?
Article ID: 2802
Last updated: 18 Apr, 2024
Revision: 3
Views: 1202
This article was:  


Also read
item How do I import a Trial Balance using a CSV?
item Import Trial Balances from Xero/FreeAgent/Quickbooks and Export Journals or Adjustments Back

Also listed in
folder Accounts Production -> General Use