XBert Type: Standard
Accounting Software: Xero, QuickBooks Online
Country Restriction: United Kingdom only
Risk Type: Tax Risk
Business Function: General Ledger
Overview
This XBert checks whether a balance-sheet VAT control account is sitting on the wrong side at month-end. A VAT control account should sit on a predictable side: a VAT liability (money you owe HMRC) normally sits in credit, and a VAT-asset or repayment account normally sits in debit. When an account has carried a balance on the opposite side across several month-ends in a row, your VAT position may be mis-stated, and catching it early protects both your VAT return and your balance sheet.
What it does
It identifies the balance-sheet VAT control accounts and checks the side each one is sitting on at month-end. When a control account sits on the opposite side to its normal classification - a liability in debit or an asset in credit - and has done so across consecutive month-ends, it surfaces the inverted balance so you can see how long it has persisted and how large it is in pounds. A balance that flips for a single month is treated differently from one that keeps appearing, because persistence is the signal that something has been mis-posted rather than a one-off timing quirk.
How it works
XBert reads the trial balance across recent month-ends and identifies the balance-sheet VAT control accounts. It raises a flag when an account meets all of these conditions:
the account is sitting on the opposite side to its classification - a VAT liability in debit, or a VAT-asset or repayment account in credit;
the inverted balance is material rather than a trivial amount; and
it has persisted across consecutive month-ends rather than appearing only once.
A wrong-way-round control account usually means a transaction has been mis-posted or a fixing journal was never cleaned up. It can also be entirely legitimate if you are genuinely in a VAT repayment position, which is why the flag is a prompt to confirm the cause before adjusting, not an instruction to reverse the balance.
Example/Use Case
Priya keeps the books for Harborne Joinery Ltd. While clearing a VAT return query she posted a manual journal to the VAT control account to "fix" a one-off difference, but pushed it to the wrong side. The account, normally a credit liability, slipped into a debit balance. Nobody noticed because the figure was small and the return still looked roughly right. Over the next three quarters more journals and reconciliations were posted on top, and the inverted balance quietly grew to over £4,000. At year-end the accountant, Tom, spotted the control account was the wrong way round and had to trace back nearly nine months of postings to find the original error. What would have been a two-minute correction at the time became a half-day of forensic work, and the prior VAT returns had to be reviewed for accuracy.
Accounting software
This XBert runs on trial balance data from Xero and QuickBooks Online.
Which countries it supports
This XBert applies to the United Kingdom only. It uses VAT control-account conventions and HMRC rules specific to the UK.
Processes
This sits within your General Ledger process and helps keep your VAT control accounts, VAT return and balance sheet accurate. An inverted control account often means VAT has been posted to the wrong side or account, so the figure carried to your VAT return is over- or under-stated; under Making Tax Digital that can lead to an under- or over-payment to HMRC, and corrections, penalties or interest if the error is material. To resolve it:
Select RESOLVE NOW to open the company in the Xero General Ledger and review the recent transactions and journals posted to the VAT control account.
Confirm whether the balance is genuinely correct - if you are in a VAT repayment position, the inverted balance may be valid, and you can file this XBert.
Otherwise, identify the mis-posting or the uncleaned fixing journal that put the account on the wrong side.
Post a correcting journal to return the account to its normal side.
Check whether any affected VAT return needs amending, and follow HMRC's process for correcting it if the period has already been filed.
Once corrected, mark the XBert as resolved.