Uploading OFX, QBO and QFX Formats for a Bank Reconciliation

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

Learn how to import bank statement transactions using an OFX (Microsoft Money), QBO (Quickbooks) or QFX (Quicken) file.

Note: The above formats are the file formats we recommend using to import bank statement transactions. However, if you can't get those formats and need to import a CSV, Excel or QIF file, please go to the article Uploading CSV, Excel and QIF Formats for a Bank Reconciliation.

Download your bank statement transactions file from your online banking website

On your online banking website, select Microsoft Money (OFX), Quickbooks (QBO) or Quicken (QFX) 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. You do not need to open this file at this time.

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

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 on Choose File, select the file that you downloaded from your online banking, and then click on Upload.

  4. Once the file has been uploaded you will see them appear below.

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