Kash is King - The Official Kashoo Blog

Accounting, business and technology insights for those who are blazing their own trail to success.

What is a Trial Balance Import?

Posted by Kashoo Team on November 4, 2013 at 2:16 PM

If you are coming from an existing accounting software or taking the leap out of the shoebox accounting method, the trial balance import is the recommended way to get started with Kashoo. In fact, one of the first things a new Kashoo customer usually does is import their trial balance. But for the small business owner who isn't an accountant, this often begs the question: exactly what is a trial balance import?

A trial balance is a compilation of your ledgers into debit and credit columns, or more simply, it's a list of the balances in all of your accounts. Your financial statements (balance sheets, profit and loss statements) are prepared from your trial balance.

This information will be your starting balance in Kashoo. The trial balance import allows you to easily move from your old accounting software to Kashoo without bringing any baggage. A fresh, clean start with fresh, clean accounting software, if you will. (But note! Like all other accounting data, you'll want to hold on to your old data in case you or a government body need a review of the past. In fact, if you feel strongly about important all of your historical data into Kashoo, there are certainly ways to do that!)

Importing Your Trial Balance Using a Spreadsheet

The easiest way to import your trial balance into Kashoo is to set it up in a spreadsheet and then export it as a CSV file. If you are an Excel user, download the ready-made template we've built. Or, if you are going to create your own using Google Docs or some other program you can use the following format...

The column headers from left to right should be labeled as follows:

First Column: Account #

- The number of the given account (eg., 1000, 1001, 1002, etc.)

Second Column: Account Name

- The classification of the account (e.g. Office Supplies, Meals & Entertainment, etc)

Third Column: Account Type

- Either Income or Expense

Fourth Column: Description

- This is where you can put any notes relating to the account

Fifth Column: Debit

- The debit balance for the given account

Sixth Column: Credit

- The credit balance for the given account


Importing your Trial Balance into Kashoo is Simple

1. From the left hand menu, select Data Import under the SETUP heading.

Data Import

2. From this screen click on the link labeled Import trial balance near the bottom of the page

Import Link

3. You can customize the list name by entering it into the name field; otherwise, Kashoo will automatically generate it for you.

4. In the Date Field select the last day of your fiscal year or the last day of the reporting period (eg., the last day of your first quarter).

5. Indicate whether your import file has headings or no headings in the Column Headings field.

Import Account Balances

Uploading Process

After you have imported your Account Balances into Kashoo there are a few more steps you will need to complete.

1. Once you have configured all of the settings, choose your file and click Upload.

2. Verify that the Kashoo fields agree with the column headings of the trial balance import file that you uploaded.

3. Click Save.

Save Imported Trial Balance

4. If there are no problems with the import you will see a green bar indicating that everything has been saved. At the bottom of the page you will see a list of the imported values.

5. If everything looks good click Import All. You will then be asked to confirm the import. Click Yes to continue.

Import Completed

And that's that! While importing your trail balance may seem tedious, there couldn't be a more valuable first step in setting up your accounting software. As always, our support team is here to help. Contact us at answers@kashoo.com or on Twitter at @KashooOnline.

Topics: Accounting Basics, Kashoo News