Skip to main content

FAQs - Accounting Integrations

Frequently asked questions about accounting integrations, including Xero, MYOB Business, Business Central, QuickBooks, and Sage 50

Teresa Bui avatar
Written by Teresa Bui
Updated this week

General Questions

When does data sync from the accounting partner to Uptick?

Data from your accounting partner syncs to Uptick on a set schedule, typically overnight. However, you can trigger a manual sync at any time. Records created in Uptick are pushed to your accounting partner immediately upon dispatch or by clicking "Create new" in the Integration section.

You can perform two types of manual syncs:

  • Bulk Sync: Navigate to Control Panel > Accounting and click Run full sync. This is best done during off-peak hours as it can affect system performance.

  • Individual Sync: Open the specific record (e.g., invoice, billing card) and click the sync icon (πŸ”—) in the Integration section.

Can I connect multiple accounting organizations to Uptick?

Yes, you can connect multiple accounting organizations to a single Uptick workspace. One must be set as the default, while others can be manually selected on specific billing cards to ensure correct syncing.

How do I resolve token or authorization errors?

Occasionally, the accounting partner integration may not work as intended. Common alerts include error messages related to token expiry, invalid grants, or authorization failures.

To resolve this:

  1. Ensure you are signed in to your accounting partner's platform.

  2. In Uptick, navigate to Control Panel > Accounting.

  3. Click the dropdown arrow next to the Edit button for the integration and select Disconnect.

  4. Follow the steps in the Accounting Integrations in Uptick guide to reconnect the integration.

What should I do if a record needs to be deleted after it has synced?

If a record (like an invoice) was created in Uptick and has already synced to your accounting partner:

  1. First, delete or void the corresponding record in the accounting partner's system.

  2. Open the record in Uptick and click Detach in the Integration section.

  3. Then you can either delete it or mark it as inactive.

Which tax codes are supported?

Uptick supports GST, Standard VAT, Reduced Rate VAT, Zero-Rated, and Tax Exempt codes across all standard integrations.

However, there are some exceptions:

  • Reverse Charge VAT (Standard and Reduced): Supported only in Xero and must be enabled in your Xero account settings.

  • Reduced Rate VAT (Ireland): You must create two custom tax rates in Xero named "Sales Reduced Rate" and "VAT on Purchases for resale 13.5%" (case-sensitive).

  • Reverse Charge Zero-Rated: Supported only for Business Central and Sage 50.

Why is 0% tax shown on an invoice? (US only)

For users in the United States, Uptick sends the billing address to your connected accounting system, which then determines the correct tax rate based on the location. Uptick itself does not calculate tax rates, so invoices will show either "TAX" or "EXEMPT".


Xero

Why isn't a billing card or supplier appearing in Uptick after syncing from Xero?

Due to a limitation in Xero's API, Uptick can only sync contacts that have at least one invoice (for billing cards) or one bill (for suppliers) raised against them.

To resolve this, create a $0 invoice or bill for the contact in Xero and then run the sync again in Uptick.

Why am I seeing an "invalid_grant" error?

This error means the authentication token connecting Uptick and Xero has expired and failed to refresh automatically. While the token should refresh automatically, it can sometimes fail.

How to fix it:

The quickest fix is to disconnect and reconnect the Xero integration. This is safe and will not create duplicates if you authorize the same Xero company.

  1. Navigate to Control Panel > Accounting.

  2. Click the dropdown arrow next to the Edit button and select Disconnect.

  3. Follow the prompts to reconnect your Xero account.

Good to know: Xero refresh tokens are valid for 30 days. If you receive an invalid_grant error, it's likely the token has expired and failed to refresh automatically. Reconnecting the integration establishes a new, valid token.

How do I fix an "archived contact" error?

This error occurs when trying to push an invoice to a contact that has been archived in Xero. Archived contacts in Xero cannot have new transactions created against them.

How to fix it:

  1. Un-archive the Contact in Xero:

    • Log in to your Xero account.

    • Go to Contacts and find the archived contact. You may need to filter your view to show archived contacts.

    • Restore or un-archive the contact.

  2. Sync the Billing Card in Uptick:

    • After un-archiving the contact in Xero, navigate to the corresponding Billing Card in Uptick.

    • Click the sync icon (πŸ”—) in the Integration section to update its status.

  3. Retry Pushing the Invoice:

    • You can now attempt to push the invoice from Uptick to Xero again.

Why can't I use more than two tracking categories with Xero?

Xero's platform has a limit of two active tracking categories at a time. This is a limitation of Xero's platform and applies to all integrations, including Uptick.

Can I include an online payment link in an invoice email?

Yes, this feature is available exclusively for Xero users. Please contact the Uptick support team for a quote to add this functionality to your email templates.


MYOB Business

Which MYOB versions does Uptick support?

Uptick's integration is fully compatible with MYOB Business, which includes the formerly separate AccountRight and Essentials products. In 2021, MYOB merged AccountRight and Essentials into a single product called MYOB Business.

Which MYOB invoice layouts are supported?

Uptick integrates only with MYOB's Service invoice layout, not the Item layout.

What does "Error 401 Unauthorized" mean?

This error indicates that the authentication credentials are invalid or have insufficient permissions. Try reconnecting the integration using an MYOB user account with higher permissions.

How do I fix "Error 400 – Duplicate Card ID"?

This error means a billing card with the same Card ID (Reference in Uptick) already exists in MYOB. To resolve it, update the Reference field in Uptick or the Card ID in MYOB to ensure they are unique, then sync again.

How do I fix "Error 400 - StringLengthExceeded"?

This error occurs when a field on the Uptick Billing Card, such as Attention (Contact Person) or Reference (Contact ID), exceeds MYOB's character limit. The error will display in the Integration section of the Billing Card, specifying which field is affected. Shorten the content in the specified field and retry the sync.


QuickBooks Online

Which QuickBooks plan is recommended?

A QuickBooks Plus subscription is strongly recommended for full compatibility. Lower-tier plans may have limitations, such as the inability to sync products, which affects invoicing and purchase orders.

Why is product sync required for QuickBooks?

Unlike other integrations that use account codes per line item, QuickBooks requires a Product/Service for each line. When pushing products to QuickBooks, you must provide income, expense, and inventory account codes. The inventory code is configured using a Product custom field in Uptick with the key asset_account_code.

How do I fix the "Incompatible invoice numbering configuration" error?

This error occurs when custom transaction numbers are enabled in QuickBooks, conflicting with Uptick's numbering. To resolve this:

  1. Navigate to Settings > Accounts & Settings > Sales > Sales form content in QuickBooks.

  2. Turn off Custom transaction numbers and save the changes.

How do I configure QuickBooks to track classes for invoicing?

  1. Click on the cog icon, then Account and settings.

  2. Click Advanced > Categories.

  3. Change the Assign classes selection to One to entire transaction.

What does the "Invalid Line TaxCode" error mean?

This error typically happens if you have custom tax rates in QuickBooks named "Tax" or "Non". To fix this, rename or deactivate these custom rates in QuickBooks and then try pushing the invoice from Uptick again.


Business Central

How do Business Central dimensions relate to tracking categories in Uptick?

In Business Central, dimensions are used to classify and analyze financial data (e.g., by department, project, or region). In Uptick, these are referred to as tracking categories.


Sage 50

Is the Sage 50 integration available outside the UK?

No, the Sage 50 integration is only available to customers in the United Kingdom.

How does the Sage 50 integration work?

The Sage 50 integration connects to Uptick via our partner, HyperExt, and requires additional software to be installed on a local on-premises computer. There is an ongoing fee for this integration.

To begin the setup process and receive pricing details, please contact our support team at [email protected]. Once provided with a URL and API Key, follow the connection steps outlined in the Accounting Integrations in Uptick article.

Is the customer's tax code stored in Uptick?

Yes, the default tax code for a customer is stored on their Uptick Billing Card. This ensures that invoices generated in Uptick automatically use the correct tax type for that customer.

Are there any additional costs for the Sage 50 integration?

The Sage 50 integration includes an ongoing fee. Reach out to [email protected] for pricing details.


Quickbooks Desktop

Do I need to switch to single-user mode when integrating QuickBooks Desktop with Uptick?

No, you can stay in Multi-User mode when integrating with Uptick. Unlike some other software solutions, Uptick does not require you to switch to single-user mode. However, you must be signed in as the Admin on the computer that is used for QuickBooks Desktop the most.

Does QuickBooks Desktop need to be running at all times for the integration to work?

No, QuickBooks Desktop (QBD) does not need to be running at all times. However, the Web Connector itself must remain open and running.

While we recommend keeping QBD open for significantly faster sync times, closing it will not result in an error.

How should I configure the "Every_Min" field in the Web Connector?

CRITICAL: NEVER set any value in the "Every_Min" field. Only tick the "Auto-Run" checkbox.

If you ever see a number in the "Every_Min" window, the connection will never run smoothly. If this happens, please contact [email protected] to reset the integration.

I'm seeing an error when attempting to open the config file. What should I do?

This error is likely due to a previous unsuccesful attempt to connect QBD with WebConnected.

Solution: Follow the steps in this article to remove Uptick as an app from the Web Connector. After removal, you can re-open the config file and move forward with the connection steps.

The integration was connected, but why does the status say "Not connected" now?

If all steps were followed correctly and you had a successful connection before, this means the Web Connector is currently turned off.

Important: There is no error when the connector is offβ€”it simply shows as "Not connected." Check that your Web Connector application is running and the Auto-Run setting is enabled.

I'm getting an error stating that a required element cannot be found in QuickBooks. What does this mean?

This issue is likely due to having both a Sales Tax Code and a Sales Tax Item with the same key value in your QuickBooks Desktop file.

Solution: Review your QuickBooks Desktop setup and ensure that Sales Tax Codes and Sales Tax Items have unique identifiers. Update any duplicate key values to resolve the sync error.

Are there any additional costs for the Quickbooks Desktop integration?

The Sage 50 integration includes an ongoing fee. Reach out to [email protected] for pricing details.


Related Articles

Did this answer your question?