AW Export QIF Manual

Overview

This module allows you to export the sales from your shop to a Quicken Interchange Format (QIF) file.

QIF files can then be imported to range of accountancy applications including the Open Source package GnuCash.

Installation

After downloading the zip file, unzip the contents and then upload/copy the "awexportqif" folder to the modules directory of your shop.

Alternatively under Back Office >> Modules you can select Add New Module and then select the "awexportqif.zip" file.

After whichever installation method you use go to Back Office >> Modules.

Locate the new module in the list, scrolling down if necessary. The module will be listed as AW Export QIF under the Export section.

In the row for the module, click Install.

Your module is now ready for you to configure and use.

Configuration

After installation in the modules tab of your back office you will notice AW Export QIF appears under the Export section. Clicking on >> Configuration will take you to the screen for this application.

The bottom half of the screen contains a form name "Setup" which allows you to set your preferences.

The options are as follows :-

Use Account Receivable?

If this option is selected invoices will be posted to an Account Receivable category against the sale items category and then payment type will be applied to this account.

If this option is not selected the payment type will be directly applied to the sale items category.

Payment Category

This gives you the option of having the payments types category being by either payment type then currency (eg Payments:PayPal:PoundsSterling) or the other way round. (Payments:PoundSterling:PayPal)

This means you can group by either payment or currency.

Product Category

Similar to the above, this gives you the option of having the ales types category being by either (default) product category then currency (eg Sales:Widgets:PoundSterling, Sales:Widgets:Euro, Sales:Thingy:PoundSterling, Sales:Thingy:Euro) or the other way round. (Sales:PoundSterling:Widgets, Sales:PoundSterling:Thingy, Sales:Euro:Widgets, Sales:Euro:Thingy etc)

This means you can group by either product category or currency.

Don't use currency in category.

If you are only outputting one currency type then selecting this option will stop the currency type appearing in the category. This is aimed at shops that only use one currency. This option is only active when a currency is selected in the Export Shop Sales for Accounts form.

When this option is active the Product Category and Payment Category options are not available.

Output Date Format

This option allows you to select which format of date you would like to be outputted in your QIF file.

Default Category

This allows you to specify a default category for products that no longer have default category. (This can happen if you delete a products default category)

Once you have set the options you require select Update to store these options.

Creating QIF

The top half of the screen allows you to create the QIF within your required parameters.

Select the required start and finish dates together with the currency (or All for all currencies) and select Download QIF.

Your web browser will start to download the file and ask if you wish to save it :-

A file name will be suggested based on you shop name and the parameters chosen.

When the file is fully downloaded you may import it into your chosen accounting package. This will probably be via a wizard which will allow you to align the categories and accounts created from this module to those in your accounts package. Please see your accounts package documentationm for further details on how it handles QIF imports.