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:
- The date format
- 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
Go to the
Click on the link
Click here to import a CSV, Excel or QIF file.
Date Format(the same one found in the spreadsheet you previously opened up), and choose whether the
Column Headingsare On The First Row or Not Provided (again, this is what you previously found out by opening up the spreadsheet).
Choose File, select the file that you downloaded from your online banking, and then click on
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
The unique number your bank assigns to each transaction
Date that the transaction was processed by your bank
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)
When a column only contains deposits
When a column only contains withdrawals
When a column only contains fees
When a column only contains payments
When a column only contains the currency that the transaction was made in
When a column only contains the description of the transaction
When a column only contains the check number related to a specific transaction
When a column only contains the balance after each transaction
When a column only contains transactions that are reversed, such as bounced checks or purchase returns
When you are done matching, click on
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: