Uploading CSV, Excel and QIF Formats for a Bank Reconciliation

Last Updated: Jan 08, 2015 07:20PM PST

Learn how to import bank statement transactions using a CSV, Excel or QIF file.

Note: It is recommended that if possible, you an OFX, QBO, and QFX file instead of the above file formats. To do so, please refer to the article Uploading OFX, QBO and QFX Formats for a Bank Reconciliation.

Download your bank statement transactions file from your online banking website

On your online banking website, select CSV, Excel (XLS) or QIF as the file format to download. Save this file in a location on your computer where you can easily find it and use a name that identifies the file clearly.

If you are given a choice for the date range of transactions, we recommend that you download one month of transactions at a time.

Before you import a CSV or Excel file, you should open it up in a spreadsheet editor (like Microsoft Excel). You'll want to make note of two things:

  1. The date format
  2. Whether there are column headings or not

In the above example, the file has a date format of YYYY-MM-DD and there are column headings on the first row.

Upload your bank statement transactions file

  1. Go to the Banking page.

  2. Click on the link Click here to import a CSV, Excel or QIF file.

  3. Select the Account, Currency, Date Format (the same one found in the spreadsheet you previously opened up), and choose whether the Column Headings are On The First Row or Not Provided (again, this is what you previously found out by opening up the spreadsheet).

    Click on Choose File, select the file that you downloaded from your online banking, and then click on Upload.

  4. Now you need to match the column headings found in the uploaded file to ones in Kashoo. The names on the top of the table are the ones found in your uploaded file, while the names found in the Field row are the Kashoo names.

    Below is a list of headings and when they should be used:

    Kashoo Column Heading

    When to select

    Ignore This Column

    When a column either doesn't fit into any of the other column headings or if the information isn't relevant

    ID

    The unique number your bank assigns to each transaction

    Date

    Date that the transaction was processed by your bank

    Amount

    Amount of the transaction. Use this in cases where both deposits (showing as a positive number) is in the same column as withdrawals (showing as a negative)

    Deposits

    When a column only contains deposits

    Withdrawals

    When a column only contains withdrawals

    Charges

    When a column only contains fees

    Payments

    When a column only contains payments

    Currency Code

    When a column only contains the currency that the transaction was made in

    Description

    When a column only contains the description of the transaction

    Check #

    When a column only contains the check number related to a specific transaction

    Balance

    When a column only contains the balance after each transaction

    Amount Reversed

    When a column only contains transactions that are reversed, such as bounced checks or purchase returns

  5. When you are done matching, click on Save then Import All. You will see a list of the imported Bank Statement Transactions and their status. Synchronized means the import was successful.

Next step - performing a reconciliation

You are now ready to reconcile your transactions. Please see our article to learn how:

Sign Up For Kashoo!


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

Contact Us

Webinars

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

Register

Watch a Video

Education

Learn the fundamentals of accounting with Kashoo-U.

https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete