Xero Integration

Aleks Petrovic

Updated March 17, 2022 06:22

This article covers connecting your Xero account to Uptick and configuring settings including sync settings and tracking categories.

Terminology

Different accounting partners use differing terms and don't always match up with terms in Uptick. This table will help you understand how to match Uptick terms against those in Xero.

Uptick Name	Xero Name	Notes
Billing Card	Contact	Must have at least 1 accounts receivable invoice
Invoice	Invoice	Must be an accounts receivable invoice
Supplier	Contact	Must have at least 1 accounts payable invoice
Purchase Order Bill	Invoice	Must be an accounts payable invoice
Tracking category	Tracking category	N/A

Connecting Xero to Uptick

To connect your Xero account with Uptick:

Click Control Panel > Accounting.
Click the Xero icon. This will take you to the Xero Log-in page.
Enter login credentials for a user that has access to your entire Xero company.
Finalise the integration by clicking Allow access. This will redirect you back to Uptick.

Sync settings - general details

Name: This comes from your company details set up with your accounting partner.

Accounting partner: Detected automatically after the sign-in process.

Unique ID: Generated by the accounting partner.

Tracking Categories: This is a Xero feature. Uptick grabs the tracking categories from Xero automatically and these settings cannot be changed from the Uptick side. You can go to Xero's support page to learn more about tracking categories.

Local Invoice PDF Generation: Enable this to have Uptick generate your Invoice PDFs instead of the Accounting Partner.

Default income account and default expense account: These are selectable from a drop-down list and are picked up automatically after the sign-in process. Products with account codes set against them will override the default settings and need to have appropriate account codes set up or else invoices and purchase cannot be processed.

Suspense Account: This is an optional field where you can input an account code nominated for revenue reconciliation.

Sync settings - partner syncs

Sync options available for billing cards, invoices and suppliers	Sync options for purchase orders
off, update only, create and update	off, update only

Below is an outline of the sync options and what they mean:

Off	Data will not be retrieved from the accounting partner and information from Uptick will not sync to the accounting partner (you can still create or update records manually)
Create and Update	Data will be retrieved from the accounting partner and new records created in Uptick will also be synced to the accounting partner.
Update only	Data will be retrieved from the accounting partner but new records will not sync to the accounting partner.

It is recommended that your sync settings should be as shown in the screenshot above in order to get full functionality out of your accounting integration.

Billing Cards

Make sure that billing cards are connected to your accounting partner or it won't invoice successfully. You can can either view the billing card against a client, or go to Billing > Billing Cards then click on Change columns and check that Partner UID is a visible column. Any empty spaces in that column indicates a billing card that is not connected to an accounting partner. This also applies to People > Suppliers if you want check that your suppliers are connected.

Linking your products to the chart of accounts

Uptick becomes a powerful accounting tool when integrated with your Xero account. Your Products will automatically link to your Chart of Accounts when you define the Account code on the Uptick Product. More on how to setup your products here.

Xero uses the Account code to identify your Products for billing purposes. To learn more about Xero and your Chart of Accounts, click here. If left untouched, the default account codes used will be 200 (Income) and 300 (Expense)

Tracking Categories

Uptick uses the same terminology for Tracking Categories as Xero. These can bet set against Products and Cost Centres and will appear as a drop-down list to select from the Tracking category field.