This feature is available in the Professional, Premium and Enterprise subscriptions of One Stop Order Processing.

This solution uses One Stop Order Processing and Quickbooks (All versions except Simple Start).

You can import your Import your orders into Quickbooks as a series of Invoices, into a selected account. You can either import all individual customers and individual products into Quickbooks or import all customers as a single customer (Sales) and for a single product (Goods). The total invoice cost and VAT is split into the relevant accounts.

Use the Quickbooks Desktop section if you are using Quickbooks Desktop

View->Add->Accounts->Quickbooks Self-Employed

menu option to add the required view.

Then tick the required orders and click on the Export option, shown below:



This will create a file 

C:\OSOP\

folder

for example, 

C:\OSOP\QuickbooksOnlineOrders.csv

You can now import these orders into QuickBooks. 

1 Logon to Quickbooks and select the settings icon:

2 Select the Import data option.



3 Select Invoices.



4 Select the exported file (e.g. C:\OSOP\QuickbooksOnlineOrders.csv). Make sure you tick 

Add new contacts that don't already exist in Quickbooks

and

Add new products/services that don't already exist in Quickbooks

And click on Next.

5 Select the date format as D/M/YYY and select your tax model, either Exclusive of tax or Inclusive of tax. Click on Next.



6 Map the tax code to the QUICKBOOKS VAT CODES and click on Next.



7 Your orders will now be imported into Quickbooks.

QuickBooks Desktop Setup

The following instructions explain how to set this up.

1 You will need to add the QuickBooks view. If using v38 and above you can add this view by clicking the menu option View->Add -> Accounts -> And then choosing either QuickBooks Desktop or QuickBooks Self-Employed.

If you are using V38 or before then you can use the following method to add the view-

If the QuickBooks view isn't available you can Import the view from the installation directory (e.g. C:\OSOP\Main). For information on how to import views click here.

There are 5 choices of views to import:

The grouped invoices are useful if you have a lot of orders (e.g. from Ebay). They are imported into Quickbooks as a single invoice with the day's total order values (and VAT). Each invoice will have a unique sequential order number. As the views are configurable you can group the orders by any field.

2 Click on the Export Orders button () and select the Quickbooks link. This will create the file C:\OSOP\QuickBooks.iif. If this is the correct file location go to step 3.

If you want to change the filename or other setup select the QuickBooks view and select the View->Change Export Options Menu.

This will display the Export orders details dialog, shown below.



Click on the OK button.

3 Start Quickbooks.

4 Below is a description of where the order information is imported into. You either need to make sure that the accounts (And items) exist in QuickBooks or amend the default values, shown below, to match your setup.

Fields used for QuickBooks versions up to 2007 (using the imported QuickBooksUpTo2007-SingleInvoices.mev or QuickBooksUpTo2007-GroupedByDayInvoices.mev views)

Fields used for QuickBooks versions 2008 onwards (using the imported QuickBooks2008-SingleInvoices.mev or QuickBooks2008-GroupedByDayInvoices.mev views)

If you need to change any of the values (or add in your own rules or macros) you should customize the current view and change the default values assigned to the Fields shown above. For information on how to change values in views click here.

5 select the File->Utilities->Import->IIF Files Import menu option.

6 Select the C:\OSOP\Quickbooks.iif file.

7 The should then be imported


Additional Information

Using with QuickBooks 2008 and having previously upgraded your Company file(s) from a previous version
If you are using Quickbooks 2008 and have upgraded your Company file(s) from a previous version of Quickbooks you may not be able to import the VAT into your existing account. New QuickBooks company accounts should not have this problem. If you get an error "cannot associate an item with VAT liability" you should allocate the VAT to a different (new) VAT Liability account. You should then consult your accountant to see if it is better to move all VAT transactions over to use this new VAT Liability account (change the value of the SPL-ACCNT2 Field) or create a General Ledger entry to move the VAT between the old VAT account and new VAT account. This will enable the VAT 100 (return) to show the correct figures.