Importing a Trial Balance

Last Updated: Jan 08, 2015 08:13PM PST

Learn how to import your trial balance into Kashoo by uploading a spreadsheet. This allows you to import your chart of accounts and opening balances so that you will not have to manually enter each one into your account.

Spreadsheet (Excel or CSV)

In order to successfully be able to import your trial balance into Kashoo using an excel document, please refer to the following instructions below. To help you out, we have a template already made for you which you download by clicking here.

Your headers should be in the order of:

  • First Column - Account Number (The number of that particular account, ex. 1000, 1001,1002).
  • Second Column - Account Name (Classification of Account, ex. Office Supplies, Operating Profit).
  • Third Column - Account Type (Income/Expense).
  • Fourth Column - Description (Put in any side notes to yourself).
  • Fifth Column - Debit (All debit balances).
  • Sixth Column - Credit (All credit balances).

Importing your Trial Balance

To import you Trial Balance simply:

1. Go to the Data Import page, which is located in the Setup menu.

2. Click on the Import trial balance link at the bottom of the page.

3. Upload your file:

  • If you'd like to customize the List Name you can, otherwise it will automatically be generated for you.
  • In the Date field select the date of the trial balance report you're importing.
  • Indicate whether your import file has headings or no headings in the Column Headings field.
  • Select Choose File, choose a file, and then click Upload.

4. Verify the Kashoo fields agree with the column headings of the import file you uploaded. Click Save.

5. You will see a list of what you will import at the bottom of the page. Now click Import All.

6. You will be asked to confirm that you want to import your trial balance. Click Yes to continue.

7. Once you confirm that you want to import your trial balance, you will notice that the status of what you imported will show as Synchronized and a green bar will appear again that says done.

8. If you go to the Adjustments page you will see the details of your imported trial balance.

Sign Up For Kashoo!

By clicking "Start Your Free 14 Day Trial" you agree to the Terms of Service and Privacy Policy.

Contact Us


New to Kashoo? Join a webinar to learn all the basics.


Watch a Video


Learn the fundamentals of accounting with Kashoo-U.
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found