Skip to main content

Xero - Troubleshooting & Known Issues

Information on troubleshooting and resolving known issues & error messages in the Xero integration.

Updated over 3 weeks ago

Use this page to diagnose issues between Auxo Workshop and Xero. For quick answers, see Xero FAQ.

🧭 How this guide works

Each section keeps things simple with What you’ll see → Why this happens → How to fix it → How to avoid it.


🚨 Plan limits stopping invoices/bills

What you’ll see

“Unable to upload invoice {invoice number} to Xero. You have reached the limit of invoices you can approve.”

Why this happens

Your Xero plan has monthly caps on invoices/bills (common on Starter/Early plans).
Typical caps:

  • 20 invoices (Accounts Receivable)

  • 5 bills (Accounts Payable)

📝 Note: The invoice date (not the creation date) is used to determine which month an invoice was entered.

If you exceed these limits, you may see an error notification in Auxo Workshop shortly after generating a transaction that exceeds these limits stating:

"Unable to upload invoice {invoice number} to Xero. You have reached the limit of invoices you can approve."

How to fix it

How to avoid it

  • Confirm your plan before go‑live.

  • Monitor usage during the month.

Other Xero Limits

According to resources in the Xero community forum at central.xero.com and within the developer documentation, Xero recommends staying within the following limits for optimal performance:

  • ~1,000 sales invoices (≈10 lines each)

  • ~1,000 purchase bills (≈10 lines each)

  • ~2,000 account transactions

  • ~2,000 bank statement lines

  • ~1,000 lines per statement


👤 Contact errors (archived or merged)

What you’ll see

“Unable to upload customer to Xero. The specified contact details matched an archived contact…”

Why this happens

The contact linked to the Auxo customer is archived (or was merged) in Xero.

How to fix it

  1. In Xero, restore the archived contact (or re‑merge so the active contact is the one Auxo updates).

  2. Make a small edit to the contact in Xero or Auxo and save.

  3. If an invoice failed previously, repost it (see Repost an invoice to Xero).

How to avoid it

  • Avoid archiving/merging contacts linked to Auxo.

  • If merging, ensure the destination contact is the one linked to Auxo.


🔢 Duplicate invoice numbers

What you’ll see

An error that the invoice number is already in use in Xero.

Why this happens

An invoice created in Auxo Workshop has the same number as an existing invoice in Xero.

How to fix it

  • Auxo Workshop can’t renumber an issued invoice. Resolve the conflict in Xero per your policies.

  • Adjust Auxo Workshop Next Invoice Number and (optionally) an Invoice Prefix so future invoices don’t collide.

How to avoid it

  • Before go‑live, set a unique Invoice Prefix and a Next Invoice Number that won’t overlap with existing Xero invoices.

  • If you also create invoices directly in Xero, keep sequences separate to avoid collisions.


🧾 Paid/Unpaid status doesn’t match

What you’ll see

An invoice is Paid in Xero but Unpaid in Auxo Workshop (or amounts differ), or vice‑versa.

Why this happens

  • The invoice total was changed in Xero after it was posted from Auxo Workshop.

  • A payment was moved between invoices in Xero (including reallocating a prepayment to a different invoice). This is not supported by the integration and causes mismatches.

How to fix it

  • If totals were changed in Xero: make the correction in Auxo Workshop and Save. Saving posts the updated totals to Xero.

  • If a payment or prepayment was moved in Xero: do not reallocate. Instead:

    • Remove the payment entirely in Auxo Workshop or Xero.

    • Re-enter the payment in the correct system (Auxo or Xero) against the correct invoice.

  • Optionally, attempt a resync: make a small non‑financial change to the Auxo Workshop invoice (e.g., tweak a line description) and Save.

How to avoid it

  • Don’t edit Auxo Workshop–created invoices directly in Xero (e.g., adding lines that change the total).

  • Don’t move or reallocate payments or prepayments between invoices in Xero — delete and re‑apply to the correct invoice instead.


💸 Discount added in Xero causes payment sync failure

What you’ll see

You have an invoice in Xero showing a discounted total (possibly $0), but in Auxo Workshop the invoice still shows the original amount. If you try to create a payment in Auxo Workshop for this invoice, the payment will not sync to Xero. You may also eventually see an error message:

"Unable to upload payment of $xx.xx for the invoice {Invoice Number} to Xero. Payments can only be made against Authorised documents Payment amount exceeds the amount outstanding on this document."

E.g.

Why this happens


Adding a discount directly in Xero changes the invoice total, so the amount Auxo Workshop tries to post as a payment exceeds the outstanding balance in Xero. Xero rejects the payment silently because the invoice is already considered paid or partially paid.

How to fix it

  • Remove the discount in Xero so the invoice total matches Auxo Workshop.

  • Delete the payment in Auxo Workshop that failed to sync.

  • Once the invoice totals match, re-enter the payment in Auxo Workshop so it can post successfully to Xero.

How to avoid it

  • Do not edit invoice totals in Xero (including adding discounts). All changes should be made in Auxo Workshop.


💳 Deposits/prepayments not matching

What you’ll see

A deposit/prepayment removed in Auxo Workshop still appears in Xero.

Why this happens

Certain prepayments aren’t removed automatically in Xero due to integration limitations.

How to fix it

  • Remove the prepayment manually in Xero to match Auxo Workshop.

How to avoid it

  • Double‑check deposits before deletion in Auxo Workshop; if removal is required, update both systems.


📦 COGS journal doesn’t look right

What you’ll see

The COGS (Cost of Goods Sold) journal amount in Xero doesn’t match what you expected for a given invoice.

Why this happens

COGS is posted to Xero at invoice time based on Average Cost in Auxo Workshop. If costs are out of date, or items were archived, the journal may differ from expectations.

How to fix it

  • In Xero, open the manual journal and note the invoice reference in the Narration and the item in the Description.

  • In Auxo Workshop, correct the item’s Average Cost if needed.

  • Repost the invoice from Auxo Workshop so the updated journal is sent (see Repost an invoice to Xero).

How to avoid it

  • Keep part costs current in Auxo Workshop.

  • Be aware that archived parts won’t contribute to COGS on that invoice.


🧾 Purchase Orders → Bills (including freight)

What you’ll see

A supplier bill in Xero doesn’t match the Auxo Workshop purchase order; freight appears differently than expected.

Why this happens

Auxo Workshop creates a bill in Xero when a purchase order is finalised. Freight entered on the PO is included on the Xero bill. Changes made after finalising a PO in Auxo Workshop do not update the existing Xero bill.

How to fix it

  • Check mapping first: confirm GL mappings for Stock on Hand, Work in Progress (WIP), and Freight in Xero Setup – 2. Account Mapping.

  • Choose an approach that fits your process, for example:

    • Create an adjustment PO in Auxo Workshop for the difference (posts an additional bill), or

    • Handle the correction in Xero according to your accounting practices.

📝Note: Edits to Bills made in Xero do not flow back to Auxo Workshop

How to avoid it

  • Before finalising a PO, confirm quantities, freight, and mapping reflect how you want the bill coded in Xero.


🔐 Connection issues

What you’ll see

Errors about expired tokens or failed connection.

Why this happens

Authorisation with Xero has expired or permissions changed.

How to fix it

  • Re‑connect to Xero (see Xero Setup – Activate & Connect).

How to avoid it

  • Re‑connect promptly when prompted.

  • Avoid removing the app inside Xero unless you intend to reset.


🔁 Repost an invoice to Xero

  1. In Auxo Workshop, open the invoice.

  2. Make a tiny non‑financial edit (e.g., add a full stop to a line description).

  3. Click Save to trigger re‑posting to Xero.

  4. Confirm the update appeared in Xero (invoice or journal, as relevant).


📚 Related articles


​

Did this answer your question?