← How-to Guides

How-to Guide · 07

Resolving Reconciliation and Subledger Errors

Both errors happen for the same underlying reason — a Xero transaction that was voided or edited after RecHound had already matched it. Here's how to identify and clear each one.

Error Type

Reconciliation Error

What it means

This transaction was reconciled against another transaction in the past, but the original transaction it was reconciled with has since been voided or edited in Xero (common with invoice edits, bank transaction corrections, or manual journal fixes). The red transaction you see is the reversal of the reconciled transaction. The goal is to unreconcile the original transaction, which will remove the red line and also the previously reconciled line, leaving only the new, updated transaction in your transaction listing.

How to fix it

1

View the reconciled transaction

Open the Transaction listing, select Advanced on the top right of the table and turn on "Show Reconciled".

2

Find the stale match

Find the row with the same description, amount, and date as the flagged transaction, now showing a blue Reconciled status instead of an error. This is the old, voided transaction.

3

Open the reconciliation group

Click the "Reconciled" status — this jumps you to the Reconciled tab with that specific reconciliation group already open.

4

Unreconcile the stale match

Select the line(s) in that group and click Unreconcile to release the stale match.

5

Confirm the error has cleared

Go back to the Transaction listing tab. The transaction that was previously flagged should no longer appear, and you should just be left with the new, updated transaction as a normal unreconciled line.

6

Reconcile the new transaction

Reconcile it properly against whatever it should now net against — use Auto-match if a match is found, or select the lines manually and click Reconcile.

Why it matters

Until this is fixed, the unidentified/reconciled balance on the workpaper is misleading — the system thinks a transaction is reconciled when the underlying Xero transaction it was matched to no longer exists.

Error Type

Subledger Error

What it means

This transaction previously had supporting detail (a subledger) attached to it, but the underlying transaction it was linked to has since been voided or edited in Xero. The current, live transaction hasn't inherited that supporting detail, so it's flagged as a Subledger Error.

How to fix it (current process)

1

Open Transaction Support

Open the Transaction Support tab for this workpaper.

2

Find the outdated support group

Locate the support group that matches the flagged transaction's description, amount, and date — it will still reference the old, voided transaction rather than the current one.

3

Remove the outdated line

Select the outdated line within that support group and click Remove to detach it.

4

Attach the new transaction to your support if required

Return to the Transaction listing tab. Select the current (previously flagged) transaction and either Create Support or Add to Existing Support, attaching it to the correct supporting detail.

5

Continue the workpaper

Continue with the workpaper as normal.

Note: unlike reconciliation errors, there's currently no toggle that surfaces the old linked transaction directly in the listing for you to click through — you'll need to locate it manually in the Transaction Support tab, per the gap noted above.