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
1. Go to the Banking page
2. Select the Account field and choose the bank or credit card account you wish to reconcile. Also choose the Statement Date. The statement date is the date that you want to reconcile your books up until.
3. Click the Show File Upload option
4. Click on the link Click here to import a CSV, Excel or QIF file.
5. 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).
6. Click on Choose File, select the file that you downloaded from your online banking, and then click on Upload.
7. 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:
8. 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: