How do I integrate Phorest with Xero or QuickBooks?

This article will show you how to connect your Phorest financial data with your Xero or QuickBooks Online account.

Note: This feature is currently not available in Australia.

Setting up the Integration

Go to Manager Integrations

mceclip0.png

Next, choose either Xero or QuickBooks, then click Manage Integration to begin the setup. The setup configuration will open in your internet browser.

Only QuickBooks Online is supported. QuickBooks Desktop is not supported.

Letting Your Accountant or Bookkeeper Complete the Setup

If you would prefer that your accountant or bookkeeper complete the setup on your behalf, you can click the Copy Link button and share the link with them, along with the link to this help article (https://support.phorest.com/hc/en-us/articles/7555464310546).

mceclip1.png

Note: You may need to restart Phorest to see this button.

Choose the business setup type that applies to your Xero or QuickBooks configuration.

mceclip0.png

If you're unsure which option to choose, please check with your accountant/bookkeeper.

The integration will prompt you to log into your Xero or QuickBooks account, then connect with Phorest and verify the connection. This will take a few minutes to complete. Please do not close this window while the connection is being verified.

mceclip3.png

Once you have successfully connected, you will enter the Mapping Flow. In this flow, you determine where the data gets synced to in Xero/Quickbooks.

Mapping your Service Categories and Sales Totals

Start by mapping your Service Categories as well as your different sales totals. Each of the totals pulled from Phorest will be listed in bold with a dropdown beside each total.

mceclip1.png

When you click on a dropdown, you will be presented with a list of your chart of accounts in Xero/Quickbooks.

From the dropdowns, select which account you would like to send each grouping of your financial totals. This process is called Mapping.

If you're unsure of some of the Phorest totals, you can use the Finance report in Phorest (ManagerReportsFinance tab) to get a better understanding of each total. Change the date range of the report to the last 12 months to make sure all relevant totals are displayed. The names of the totals listed in the Accounting Integration will match the total names on the Finance report.

Note: It is important to map all fields that are relevant to your account, even if that field does not have a red asteriskbeside it. If data exists in the sync and it is not mapped to a relevant field, the sync will fail.

Mapping your Other Accounts

Next, map your other accounts.

Ideally, you or your accountant/bookkeeper will have set up custom accounts in Xero/Quickbooks to manage things like Refunds, Giftcard Sales etc., separately from overall Product or Service sales (e.g. Giftcards should be sent to a liability account).

mceclip2.png

Note: It is important to map all fields that are relevant to your account, even if that field does not have a red asterisk beside it. If data exists in the sync and it is not mapped to a relevant field, the sync will fail.


Initial Sync & Data Sync Schedule

 Initial Data Sync

Once you've mapped all fields and completed the setup process, the integration will instantly attempt to sync the financial totals from the previous day to your Xero or QuickBooks account to verify the setup was successful.

This process can take a few minutes, so please be patient. Once the process is complete, you will see a Success message on-screen. We recommend that you check your Xero or QuickBooks account after this to verify the data has synced.

Financial data prior to the initial data sync will not be synced.

 Continuous Data Sync

Once your sync is set up and verified, your Phorest data will sync to your Xero or QuickBooks account automatically at 1 am every night. Your Phorest software does not need to be open for this to happen.


Managing the Integration

You can manage the integration at any point, including mapping to new accounts in QuickBooks, adding new Phorest components, or switching off the integration if you choose by going to Manager > Integrations > Select the Xero or QuickBooks > Manage Integration.

mceclip0.png

Was this article helpful?
9 out of 10 found this helpful