This article covers connecting your Xero account to Uptick and configuring settings including sync settings and tracking categories.
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.
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)
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.