Skip to main content

Settlement processing error on Link My Books

Written by Ruth Buan
Updated this week

What this error means

You may see one of the following errors when sending a settlement:

  • "Page Data No Longer Valid"

  • "Debit Credit Balance Error"

  • "Document Total Too Small"

  • "Settlement Incorrect Status"

  • "String length specified does not match the supported length"

  • "This settlement is not ready to be sent"

  • "This settlement could not be processed. It will be retried automatically."

These errors occur when the settlement is not in a valid state for processing or when the settlement data no longer matches the system state.


Why this happens

Common reasons include:

  • The settlement page was left open for a long time and the data expired

  • The settlement totals do not meet accounting validation rules

  • The settlement is not in the correct status to be sent

  • A temporary system condition occurred during processing

  • A data discrepancy between the sales channel's payout data and what Link My Books has calculated (see below)


How to resolve it

Try sending the settlement again.

Steps:

  1. Refresh the Settlements page in Link My Books

  2. Re-open the settlement

  3. Click Send to Xero / QuickBooks again

If the error persists, wait a few minutes and try again.


Partially sent settlements

⚠️ What is a partially sent settlement? This is when only some parts of a settlement have been posted to Xero or QuickBooks — for example, the sales invoice was created but the payout journal or bill was not. The settlement may show a mix of "Sent" and "Ready to Send" or "Error" statuses on different tabs.

Why this happens:

  • A connection timeout occurred partway through sending (e.g. the Xero or QuickBooks API timed out after the first part was posted)

  • A rate limit was hit during a batch send, causing later parts to fail

  • The settlement was sent manually and the browser was closed before all parts finished

Why autopost won't fix it:

Autopost only picks up settlements that are fully in a "Ready to Send" state. If part of the settlement has already been sent, autopost will skip it — it does not attempt to send the remaining parts.

How to resolve it:

  1. Open the settlement and check which tabs show as Sent and which show as Ready to Send or Error

  2. Check your accounting software (Xero or QuickBooks) to confirm which entries were actually created

  3. If entries were partially created, use the Rollback feature to remove the partial entries, then resend the full settlement

  4. If you are unable to rollback or resend, contact support — our team can manually push the remaining parts or rollback on your behalf

Tip: If you frequently see partial sends, try reconnecting your accounting software in Settings → Account Settings before your next batch. This refreshes the API connection and reduces the chance of timeouts.


Amazon settlement errors requiring a V2 flat file

In rare cases, an Amazon settlement may fail repeatedly because the settlement data from Amazon contains an error that our system cannot process. This is different from a connection or mapping issue — it means the underlying payout data needs investigation.

When this happens, our support team may ask you to provide a V2 flat file. Here's how to get it:

  1. Go to Amazon Seller Central → Reports → Payments → All Statements

  2. Find the settlement covering the affected date range

  3. Click "Request Report" (or "Download" if already available)

  4. Once generated, download the file and send it to our support team along with the settlement ID

Our team will use this file to identify and correct the data discrepancy. This typically resolves within 1–2 business days.


Settlement failed due to a data discrepancy

⚠️ Persistent "Failed" status that won't resolve with retries: If a settlement keeps failing even after refreshing and retrying, this may be caused by a data discrepancy — where the payout total from your sales channel doesn't match the calculated total from the individual transactions. This requires our Tech team to investigate and make a data adjustment.

This is most common with Square, WooCommerce, and Shopify (other payment gateways) settlements, where third-party payment processor data can occasionally be incomplete or misaligned.

What to do:

  1. Don't keep retrying — if it has failed 2-3 times, contact support instead

  2. Export a Transaction Report CSV from your sales channel or payment processor (e.g. Square Dashboard > Transactions > Export) covering the payout period

  3. Send the CSV to our support team along with the settlement ID and the error message

Our Tech team will use the transaction-level data to identify where the discrepancy sits and make the necessary correction. This usually resolves within 1-2 business days.


Settlement won't open or shows a blank error

In some cases you may find that a settlement won't open at all, or it shows an error with no visible error message. This is different from the named errors listed above.

⚠️ If you cannot open a settlement or see a blank/empty error message: This typically means the settlement data needs to be reprocessed on our end. Standard troubleshooting steps (refreshing, retrying) will not resolve this — please contact our support team straight away.

What to include when contacting support:

  • The sales channel and month of the affected settlement (e.g. "Shopify Payments, February 2026")

  • Whether the settlement appears on your dashboard but won't open, or whether it opens but shows a blank error

  • A screenshot if possible

Our team can investigate and reprocess the settlement for you, which typically resolves the issue within a few minutes.


When to contact Link My Books support

Contact Link My Books support if:

  • the settlement continues to fail after retrying

  • the same error appears multiple times

  • the settlement cannot be sent even after refreshing the page

  • the settlement won't open or shows a blank error (see above)

  • the settlement is partially sent — some parts posted but others did not (see above)

  • you suspect a data discrepancy (see above)

Please include:

  • the settlement ID

  • the exact error message shown (or note that no message was displayed)

  • the events or steps that led to the error

  • a screenshot if possible

  • a Transaction Report CSV from the sales channel if the settlement keeps failing (see data discrepancy section above)

This helps our team investigate what happened during the settlement process.

If you have any questions about this article or feedback on how we could make it better please reach out to the support team via the blue chat icon on the bottom right of the page or via email to [email protected].

Did this answer your question?