Knowledge Base
Accountancy Practices
and Tax Advisors
Limited Companies
Individuals Making Tax Digital
TaxCalc Client Hub
TaxCalc Accounts Production
TaxCalc Tax Return Production
TaxCalc VAT Filer

TaxCalc CloudConnect
TaxCalc AML Identity Checking

TaxCalc Events
TaxCalc Limited Company


TaxCalc Partnership
TaxCalc Individual


TaxCalc Trust
For Accountancy Practices and Tax Advisors

For Individuals, Businesses, Trusts and Partnerships

How do I import a trial balance?

Article ID: 1250
Last updated: 17 Dec, 2015

You can save time when importing trial balances into Accounts Production by creating a CSV (comma-separated values) file from your bookkeeping software. This is quicker than manually entering the data.

Step 1: Create a CSV file of the trial balance to be imported

From your bookkeeping software, create a CSV file (spreadsheet) to include:

  • at least two columns
  • account codes and/or descriptions
  • the debit and credit figures:
    • in two separate columns, or
    • in one column – with credits denoted by brackets or a negative sign.

Example trial balance with separate debit and credit columns

Source account   Description Debit Credit
5001 Sales 2000.00
8001 Bank account 2000.00

Example trial balance with one column

Source account Description Value
5001 Sales (2000.00)
8001 Bank account 2000.00

Headings in the first row are optional and the columns can be in any order.

Step 2: 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 3: Create the import map

The first time you use the wizard, it will display a welcome screen. Click on Continue to move to the next step.

Click on Browse... and select the CSV file that you created in your bookkeeping software.

Select Create a new import map.

Click on Continue.

If multiple clients are using the same bookkeeping software, you can reuse an existing import map for other clients.

Step 4: Name the import map

Enter a name and description for the import map. TaxCalc will use these when applying an existing map to other clients or in future periods.

Click on Continue.

Step 5: Import map settings

Complete the Import Trial Balance screen using the details from your CSV file.

If you've used headings in the CSV file, tick The first row contains column headings.

Select the correct column for the account code – this is mandatory. This column can be alphanumeric.

Select the correct columns for account description and narrative if they appear in the CSV file.

Click on Single column if the debits and credits are in one column. Select Parentheses, (1,000.00) or Hyphen, -1,000.00 to show which figures are credits. For Amount, select the column that lists the figures.

Click on Two columns if the debits and credits are in separate columns. State which column contains debit values and which contains credit values.

Click on Continue.​

Step 6: Map CSV entries to the account codes

Click on the first data row. Headings will only appear if they're in CSV file.

Click on the magnifying glass in the To Account column.

Select the corresponding TaxCalc account code.

Repeat this process until you've mapped all the rows.

Click on Continue.

Review the data to be imported.

Click on Continue.

Click on Finish to import the trial balance.

NOTE: If you need to make any adjustments, you'll need to finish the import process and create a new posting batch with the amended figures. However, if the imported figures don't balance, you'll need to create a balancing post.

Article ID: 1250
Last updated: 17 Dec, 2015
Revision: 5
Views: 3815
This article was:  

VAT will be charged to purchases in accordance with the prevailing rules. Copyright © 2017 Acorah Software Products Limited. All Rights Reserved.
TaxCalc, SimpleStep and TaxCalc CloudConnect are registered trademarks of Acorah Software Products Limited. Unauthorised use of these marks is strictly prohibited.
Microsoft, Internet Explorer, Outlook and Windows are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Apple, Mac, Mac OS, OS X and Safari are trademarks of Apple Inc., registered in the U.S. and other countries.
Linux is the registered trademark of Linus Torvalds in the U.S. and other countries.
Our registered office is: 4 King Street Lane, Winnersh, Wokingham, RG41 5AS . Registered number 03948264 (England and Wales). VAT number: 855 5726 91.