Email to friend
Multiple emails allowed. Separate with commas



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

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?