Knowledgebase Support HMRC Useful links
Knowledgebase home
Tax Return Production
Accounts Production
Practice Management
VAT Filer
Anti-Money Laundering
Support home
Video Training Guides

Hot Topics
SimpleStep Guides
Release Notes
Known Issues

HMRC Status
Useful Links
MTD for Agents MTD for Businesses What is MTD
Agent Services Account
MTD for Income Tax
Digital Record Keeping
Quarterly Updates
Step-by-step Guide
HMRC's MTD Timeline
TaxCalc's MTD Journey

TaxCalc integration with Xero

Article ID: 2801
Last updated: 13 Nov, 2018

TaxCalc has started the integration process with Xero to allow for seamless transition of data. This will mean a trial balance can be imported directly in to a specified year-end into the Accounts Production module. Please note: this functionality is available from version 6.3.041 or higher.

More information on how the functionality works can be found in our video below.

Alternatively, please see our step by step instructions on how to use this functionality in TaxCalc below.

Step 1: Start the import procedure

Launch Accounts Production.

Open your client and the accounting period.

Select Posting from the left-hand menu.

Select Import Trial Balance from the left-hand menu.

Step 2: Select Import Method

Select Xero from the drop down for Import via third party API.

Step 3: Authentication

In order to gain authentication with the third party API, enter your credentials in the authentication window to login, this will allow TaxCalc permission to access and import the trial balance.

Successful authentication will proceed through to the next step requesting to allow access to Xero.

Select Allow access for 30 minutes.

The next screen will confirm the name of the Xero client and the period dates for which the trial balance will be imported for.

Click on Continue.

Step 4: Xero Period Status

If the selected period in Xero has not been locked, changes to the period are possible after the import. If your client does not take advantage of this option, tick the box to not show the warning message again.

Click on OK.

TaxCalc will now attempt to import the trial balance for your client.

Click on Continue.

Step 5: Create Xero Import Map

This screen will only appear on first import; you will be presented with two options.

A default set of mappings based on the Xero chart of accounts is available, TaxCalc has mapped as many account codes as possible but some codes may need to be defined manually (which can be applied on the code mapping screen).

Should you wish to import the trial balance using an existing map, select from previously created CSV maps and other clients Xero import maps.

Click on Continue.

Step 6: Trial Balance Summary – Code Mapping

The Trial Balance Summary lists all of the unique codes within the import that has been identified and mapped by default along with any codes that has not been mapped by TaxCalc.

Using the magnifying glass within the ‘To Account’ column, select the corresponding TaxCalc account code to map any unmapped codes or to amend an account code that is predefined by TaxCalc.

Use the filter options to show only the outstanding rows to be mapped by selecting ‘Unmapped codes’Please note: Any un-mapped values will NOT be imported.

Select Change Import Map should you wish to apply an alternative import map from   previously created CSV map or another clients Xero import map. You will be provided with the options to override or update.

Click on Continue.

Step 7: Review Data to be Imported

Review the data for the final time that is about to be imported.

Click on Continue.

Article ID: 2801
Last updated: 13 Nov, 2018
Revision: 4
Views: 1014
This article was:  

Also read
item How do I import a Trial Balance using third party APIs?

Also listed in
folder Accounts Production -> General Use