QIF (Quicken, MYOB, MS Money)
Class supports the industry-standard QIF format (developed by Quicken). This format is widely available as a download option on most online Banking Systems.
If Class does not support the specific Bank Account type you wish to load then you should ask the account holder to provide you with the generic QIF format.
Prerequisites
- Ensure the Fund is Active
- At the Fund Level, go to the Feeds > Feeds Console screen, open the feed account and ensure the following:
- Bank Account is Active
- Code has been entered and is unique
- Cash Product Type is Bank Account
- BSB Number has been entered correctly
- Account Number has been entered correctly
- Product has been selected if not automatically assigned
- Manually Imported is selected
QIF format
- QIF American Date - mm-dd-yyyy, mm-dd-yy
- QIF British Date - dd-mm-yyyy, dd-mm-yy
Where to download the QIF file from?
Most of the bank's internet banking websites have multiple format options for exporting transactional data. When looking for this specific file type, you should see reference to MYOB, Quicken or MS Money and to the date being in the format of MM-DD-YYYY such as the NAB's internet banking website below (as opposed to DD-MM-YYYY or 'Local Date'):
Example file
You should use the Notepad software on your computer to view the contents of this file
Importing QIF file to Class
Navigate to Transactions > Load Data File
- Select "Category" as "Banks"
- Select "Source" as "* All Banks*"
- Select "Format" on either QIF American format or QIF British format
- Select the remaining information as appropriate
- Click on "Choose File" button and chose the file to upload
- Click on "Load File"
