Quickbooks Integration Details

Summary

We have a document export hub which can handle exporting out customers, invoices and payments. This produces CSV files and adheres to Quickbooks template formats for importing.

You will need the Document Export module in order to export transactions from Platinum. Please Contact your Platinum dealer or our sales team on 0116 230 1500 or by using our website sales contact page for more information.

Configuration

Go to " " Reports & Settings Maintenance Options System Administrator Module Settings" Document Exports Data Export Settings"

• Select the [Quickbooks] tab.
• At "Enabled" select 'Yes'.

Once this option has been enabled, each time you use the export option those transactions are flagged as having been exported. This ensures only new transactions are included in subsequent export files thus avoiding duplicating data.

• You have three settings to specify the reports which are to be used in each case.
  • The "Customer Report" is required to output the customers for whom transactions have been identified. The standard report code is '~XC'.
  • The "Transaction report" is mandatory, and is used to output the transactions i.e. invoices and credits. The standard report code is '~XT' to output a single line per item on the document.
  • The "Payment report" is optional, and required only if you want to export payments from Platinum to Quickbooks. Most customers should deal with payments entirely within Quickbooks, but the option is here if required. The standard report code is '~XP'

The standard reports may be replaced by customised reports to meet the requirements of the customer. Please Contact your Platinum dealer or our support team on 0116 230 1500 or by using our website support contact page for advice as a customised report may be chargeable

.

To put the Document Export - Hub option on a custom menu, the program to specify is 'SXPDX99'.

Customer Settings

If have already created a customer within Quickbooks, you should create the Platinum account to match the same name. Quickbooks does not utilise account codes and matches on the Name field within Platinum.

If the name does not match, then Quickbooks will create a new customer record with that name.

Linking Sales Centres to Quickbooks Nominal Codes

• If you use report '~XT' you should ensure your Sales Centres in Platinum link to Nominal Codes that reflect the Nominal Codes you are using in Quickbooks.