Quickbooks

The following guides you through the steps required to transfer data between GP Billing and QuickBooks.

You will need a copy of the [Quickbooks.xlsm] or [Quickbooks – SinglePatientAccount.xlsm] spreadsheets and Microsoft Excel 2010 or above.

Please note that to match sales receipts to existing accounts in Quickbooks, customer names must be the same in GP Billing as they are in Quickbooks.

Product codes must also match to income codes in GP Billing or can be imported when bringing in the sales receipts.

We recommend you contact support@gpbilling.co.uk for assistance in configuring this export/import and obtaining the Quickbooks spreadsheet.

Accounts

In GP Billing, click the icon on the blue bar at the top of the application.

Select [Account] from the options.

Click the [Search] button to return all active accounts.

Use the filter line to select the accounts you want to export such as [Third Party], you can also set the Last Modified Date as a filter.

Click the [Export] button to run the extract.

Click [Save As] and choose [Excel Workbook (*.xlsx)]

Save this file in the defined location.

In the Quickbooks spreadsheet, click the [Import] button.

Click the [Customers] button, this will generate the spreadsheet in the required format for import into Quickbooks.

In Quickbooks, click the icon and select the [Import data] option from the [Tools] menu.

Select [Customers] and [Browse] for the spreadsheet generated by the Quickbooks spreadsheet.

All data fields should map automatically so click [Next].

Quickbooks will not import duplicate customers, click [Import] to start the import process.

Transactions

In GP Billing, open the [Reports] dashboard and select the [Transactions] report.

Set the date period for the export and tick the [Income Code] checkbox then click [Refresh].

Use the filter option to limit the extract to [Payments].

Click the [Export] button to run the extract.

Click [Save As] and choose [Excel Workbook (*.xlsx)]

Save this file in the defined location.

In the Quickbooks spreadsheet, click the [Import] button.

Click the [Sales Receipts] button, this will generate the CSV files in the required format for import into Quickbooks.

In Quickbooks, click the icon and select the [Import data] option from the [Tools] menu.

Select [Sales Receipts] button and [Browse] for the CSV files generated by the Quickbooks spreadsheet.

The invoice date should be in YYYY-M-D format.

The Item amount is Exclusive of tax.

Click [Next] and map your VAT codes.

Click [Next] and [Import] to perform the import.