Quiff allows you to easily preview and convert transaction files for use in QuickBooks and other financial management programs. Typically, these files are downloaded from your bank over the internet, but your bank may not offer a format supported by your financial management program. Quiff may be able to convert it to a suitable format. Export formats are determined by the version of Quiff used:
Use the Open File... button to select the file to be converted. You may also drag your data file on the Quiff window to import the data. Supported import formats are determined by the version of Quiff used.
After processing, you will immediately see a preview of the data, similar to how you might see it in your financial management program. The preview does not allow editing, changes should be performed in your financial program after it has been imported.
The following changes may be made to the data to prepare it for conversion:
You may delete a transaction (or range of transactions) by right-clicking on it as shown. Your source file is not changed. This option was introduced in Quiff 5.
Use the Save As… button to export the transactions. You will be prompted to select a location to save the converted file. If you have not provided all the required information for the chosen format, you will be presented with the Options window.
For instructions on how to import the converted transactions, see your financial program's documentation.
NOTE: Importing the same transactions more than once into your financial program, regardless of format, may result in duplicate transactions!
The Options window
lets you adjust important settings for your conversion.
Depending on the selected format, you may have to supply additional information, as discussed in the following sections.
Click Save to use your latest settings. For items such as accounts, Quiff will remember up to 10 previous entries.
The term Destination Account refers a checking, savings or credit card account in which a transaction occurred. This is set using the Options button.
NOTE: When importing the file into your financial program, a new account may be created if the specified account does not exist. If this happens unintentionally, you may be able to move the transactions by renaming/merging the new account with an existing account. See your financial program’s documentation for help with merging accounts.
The term Category
refers to the income/expense account assigned to a
NOTE: After importing your converted transactions, new categories may be created if they do not already exist in your financial program. In all cases, you can assign your transactions to the appropriate income and expense categories as required.
Some versions of Quiff allow delimited
text files such as CSV to be imported.
This window is divided into two areas:
TIP: To quickly and accurately assign columns,
drag column names from a header row to the Register before
checking Ignore Header .
The following fields must be assigned a source column for data:
The remaining fields are optional.
If something is not right and you want to start over, right-click on the Register and select Reset.
If you are satisfied with how your data appears in the Register, click OK to complete the import.
All of Quiff's supported import formats follow defined standards. However, how closely the standards are followed can vary widely depending on the source of your original files. Where possible, Quiff makes allowances for common variations such as number and date formats, but may report an error if the format's underlying structure is invalid. If you encounter such an error in a document, try these steps to isolate the problem:
If you have exhausted these options, contact your file's source for support first. If you do find an issue determined to be related to Quiff, contact support to submit a problem file for examination.