Knowledgebase: Cart32: Version 7.0
A Guide to the QuickBooks Plugin
Posted by - NA - on 11 August 2010 09:12 AM
The Cart32 Quickbooks plugin allows you export data from Cart32 into QuickBooks via IIF files.|
Use Export to Quickbooks This yes or no option specifies whether or not the plugin is enabled. You will normally want this to be set to yes.
QuickBooks Code This is entered in when the plugin is first activated. It is not the code that is emailed to you, but the code that is generated after the emailed code is entered into the window presented when you click the link in "If you have ordered this add-on then click here to get your QuickBooks code. If not, then leave the QuickBooks code field blank".
Append QuickBooks file at time of order This yes or no option controls whether or not an IIF file is created/updated as each order is placed. If this is set to no, then you will have to manually select the orders to export from the Orders -> Show Orders (Secure) tab.
File LocationThis is the location the IIF files are written to. It needs to be a local file path on the server. Example: c:\inetpub\vhosts\MySite\orders\quickbooks. If you are unsure what to put here, ontact your hosting provider for more information.
File Name This is the name of the file. It should end in .iif,and should be something you will be able to remember and recognize easily. CLIENTCODE_quickbooks_orders.iif is a good example.
Export File Type This one will need some explaining. There are five (5) options, but only three (3) actual file types. Each of these types correspond transaction types within Quickbooks. For additional information on what is included with each type of transaction, please refer to your QuickBooks documentation.
There are two additional options available , but they simply use a combination of other file types.
These two represent the most accurate options from an accounting stand point, if you are using real time credit card processing and accept other methods of payment as well.
Bank Account Name This one is used only if a Deposit type of file is being created,and is the name of the bank account (as specified in Quickbooks) that the funds are deposited into.
Deposit Name This is the name of the deposit, it will show up in journal entries and is something of a "memo field"
Deposit Category This is the default category / account for deposits if AccountingCategory is not specified in the form code of individual items. Leave blank if you want the part number to be the category.
Invoice Category This is the default category / account for invoices if AccountingCategory is not specified in the form code of individual items. Leave blank if you want the part number to be the category.
Tax Account The name of the account used to hold taxes payable.
Tax Agency The name of the tax agency taxes are paid to. Needs to match Quickbooks.
Sales Tax Item The Sales Tax Item tells QuickBooks how much sales tax to compute for a given sale. This will need to match the one setup in QuickBooks if it is used.
Append Options to Item Name when importing This will cause the cart to add the options top the item names, so that they show up as unique items based on what option was chosen.
Only export approved orders 'time of order' export This will cause only approved orders to be exported. This is useful for when you want to exclude failed credit card orders from getting into QuickBooks.
Things to take note of
The items must already exist in QuickBooks and the names and accounting categories must also match. Otherwise, the item will get imported as a new bank account, because that is what QuickBooks defaults to on new accounts.
When you are first getting this setup, make a backup of your company files before you do your first import. You may have to make adjustments and it will be much easier to just restore from a backup than to try to fix accounts that didn't quite match up.