Built from inside practice. Built by Mr H Hammad FCCA, ACA, ICAEW Chartered Accountant with over 20 years in practice.
ProductFor ClientsClient PortalResourcesWhy BalansixPricingSupportBook a demoLogin
BalansixBanking

Why can’t I find the bank transaction I want to match?

Troubleshoot a missing bank match in Balansix by checking account, date, posting status, reconciliation locks and whether the item belongs to settlement matching.

Banking
Short answerWhat to checkWhy it happensStepsFAQs

Short answer

A missing match usually means the transaction is in a different bank account or period, has not been posted yet, is already allocated or reconciled, or should be handled through customer/supplier settlement rather than ordinary bank coding.

What to check first

Work through these before changing the accounting recordConfirm you are in the correct client and bank account.Check the statement date and accounting period filters.Confirm the imported row has been posted where posting is required before matching.Check whether the transaction is already reconciled or allocated.For invoice payments and receipts, check the customer/supplier settlement workflow rather than a generic bank match.

Why this happens

Balansix keeps bank coding, settlement allocation and reconciliation as related but distinct controls. That prevents a bank line from being used twice or matched in a way that bypasses the customer/supplier subledger.

Steps to resolve it

  1. Clear restrictive grid filters and search by amount or description.
  2. Check the bank row status and whether it is still awaiting coding or review.
  3. Open the relevant customer or supplier where the bank line represents payment of an invoice or opening balance.
  4. If the item is already reconciled, review the reconciliation before attempting to change the match.
  5. If the row is in a locked period, follow the authorised correction or reopen workflow rather than forcing a new match.

What to avoid

Keep the audit trail intact. Do not create a duplicate bank transaction simply because the expected match is not visible. First establish whether the original row already exists, is filtered out, or is locked by a completed workflow.

Frequently asked questions

Can a reconciled bank line be matched again?

No. A bank line that has already been allocated or reconciled should not be reused. Review the existing reconciliation or authorised correction route.

Why can I see the amount in the bank but not in supplier matching?

The bank row may not yet be posted or available for settlement, may be in another account or period, or may already be allocated.

Should opening balance payments be matched differently?

Yes. Payments and receipts against brought-forward supplier/customer balances should use the opening subledger settlement workflow so the control balance clears correctly.

Still need help?

Contact Balansix Support with the client, module, period, what you expected and what happened. Avoid sending passwords or unrelated client secrets.