What Data can I Import into Kashoo?

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

Learn what kind of data you can import into Kashoo.

You can import the following data into Kashoo:

  1. Trial Balance (Chart of accounts and opening balances)
  2. Contacts (Customer and Vendors)
  3. Payroll

What about my transactional data, like invoices and bills?

If you have transactional data that you would like to import, you can upload bank transactions by using Kashoo’s bank statement reconciliation tool. Please read the article Performing a Bank Reconciliation to find out how to import transactions into Kashoo using the Banking page.

You can import transactions via an automatic bank feed (which can pull in up to 90 days worth of data), or a file (QBO, OFX, QFX, CSV, Excel, or QIF).

You are also able to manually create a CSV or Excel file to import, just follow the formatting instructions found in the article Uploading CSV, Excel and QIF Formats for a Bank Reconciliation. Basically, you would create a file with 4 columns (date, description, deposit and withdrawal) and import it.

Note: Using the bank reconciliation feature to import transactions into Kashoo still requires you to assign each transaction to an income, expense (or other) account.

What about historical data from past years?

If you are looking to simply have the summarized data of years past, then this is a fairly easy thing to do. What you would need is a profit and loss report from each of the years that you want to enter into Kashoo.

You would then create an adjustment for each year of profit and loss data that you have.

For example, let’s take a very simple Profit and Loss Report:

Profit and Loss 2010
Sales Income 10000
Advertising & Marketing Expense -5000
Net income 5000

To translate that into an adjustment, go to the Adjustments Page and do the following:

Line 1 - Sales Income Credit: 10,000

Line 2 - Advertising & Marketing Expense Debit: 5,000

Line 3 - Retained Earnings (this is your Net Income) Debit: 5,000

Note: To balance your adjustment, if you had net income, debit Retained Earnings, if you had a net loss, then credit Retained Earnings. You can do this for as many years as you like.

This is what a profit and loss report comparing 2010 through to 2011 looks like:

To create a report like that, you go to the Profit and Loss page from the Reports menu, and then for Choose your report format, chooseThis Year vs Last Year.

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