Accounting Insights
Real accounting issues encountered by UK businesses and their accountants — each one explained with the correct treatment, common mistakes, and how modern software should handle it.
We add new topics as we encounter them in practice. Every entry is based on a real case.
Topics on this page
Inter-Account Transfers Tagged as Sales of Assets
One of the most common bank reconciliation errors — and one that silently distorts your P&L and overstates losses.
What happened
A UK company operated both a main GBP current account and a trading/brokerage account. Periodically, funds were moved between the two — money sent to the broker to fund positions, and returned when positions were closed. In QuickFile, each of these bank movements was tagged to the category Sales of Assets.
The result: the P&L showed a £31,238 loss under Sales of Assets — a figure with no basis in economic reality. No asset had been sold. No income had been earned or lost. The money had simply moved between two accounts belonging to the same company.
Why it's wrong
A transfer between two bank accounts belonging to the same legal entity is balance-sheet neutral. It is not income, it is not expenditure, and it has no P&L impact. The correct entries:
Both accounts live on the balance sheet as assets. Nothing touches the P&L. Total assets remain unchanged.
Why it happens
Most bank reconciliation tools ask you to "tag" every transaction against a nominal code. When a bookkeeper sees a large outgoing payment to a broker, Sales of Assets can seem like the closest available category. It isn't. The correct approach is to tag it as a bank transfer to the trading account — which systems treat separately from P&L categorisation.
The tax implication
If filed as-is, this error could overstate losses (reducing Corporation Tax liability) or misstate the trading position — both of which carry risk in an HMRC enquiry. The correct position is that these transfers have zero tax impact.
Cross-Currency Bank Reconciliation
The problem every major UK accounting platform ignores — and how it should actually work.
The problem
A UK company maintains accounts in multiple currencies — GBP, CZK, EUR, USD. When money moves between them (for example, £15,692 sent from GBP to fund CZK operations), both sides appear in your system as separate transactions in different currencies. Every major UK platform either refuses to suggest a match across currencies, or floods the screen with false candidates requiring a calculator and currency table to resolve.
"My foreign bank feed never matches what is in QuickBooks." — QuickBooks UK community, thread unresolved since 2019
"The workaround is clunky and overly complicated — and easily results in an unbalanced clearing account." — Xero product ideas forum
"Even though this program offers Multiple Currency options, the proper support for this feature is seriously lacking." — FreeAgent, Capterra
Why same-currency ratio matching fails
Most systems match transfer candidates by checking amounts are within ~20% of each other. For GBP→CZK, the koruna trades at ~28–31 CZK per GBP. A ratio check of 20% filters out every valid match — £15,692 and CZK 469,629 differ by a factor of ~30, not 0.20.
How Countee solves it
When Countee detects two candidate transactions in different currencies, it fetches the official exchange rate for that exact calendar date from the Czech National Bank — an authoritative source publishing daily fixing rates for all major currencies including GBP, EUR, USD, CZK and PLN. This works for any historical date.
- Convert the GBP amount to CZK using the CNB rate for the transaction date
- Accept candidates within ±10% of the converted amount
- Eliminate candidates that are a better match for another transaction — each candidate assigned to at most one counterpart
- Sort by closest date first, then by conversion accuracy
Result for £15,692.07 on 29 Jan 2025 (CNB rate 30.000 = CZK 470,762 expected): exactly two candidates shown — CZK 469,629 (0.2% deviation) and CZK 442,176 (6.1%). Amounts of CZK 99,329, 106,446, 107,442 automatically excluded.
Opening Balances Imported from a Trial Balance
What they represent, what they are not, and what happens when they carry a historical error forward.
What an opening balance is
When migrating between accounting systems, you import a trial balance: a snapshot of every account's balance at the cutover date. These opening balances represent the accumulated result of all historical transactions. You don't re-enter every invoice — you carry forward the net position in a single opening journal entry, with total debits equalling total credits.
When an opening balance carries a wrong figure
If an account was systematically miscategorised in the previous system, the trial balance carries that error forward. In the case described above, QuickFile's trial balance showed a credit of £31,238 under Sales of Assets — the accumulated net of inter-account transfers incorrectly tagged over months. Importing without correction means the error persists from day one of the new system.
Correct approach
Before migrating, review every P&L account in the trial balance with an unexpected balance. Ask: does this figure represent genuine income or expenditure, or is it a classification error? If the latter, correct it before export or adjust the opening journal after import. In Countee, opening balance journals can be edited at line level without disturbing the rest of the entry, provided the journal remains balanced.
QF Import Suspense — What It Is and When to Clear It
A temporary balancing account that should always end at zero. If it doesn't, something needs investigation.
Why it exists
When importing historical bank transactions, each entry needs two sides in double-entry. The bank account side is clear. But the other side — the income, expense, or balance sheet account — isn't always cleanly importable. Rather than leave journal entries unbalanced, the import process uses a QF Import Suspense account as a temporary offset. Every transaction balances immediately, but the suspense account accumulates a balance that needs to be reconciled.
What a healthy suspense account looks like
Once reconciliation is complete — every imported transaction matched to its correct ledger counterpart — the QF Import Suspense balance should be exactly zero. A non-zero balance means some transactions have been imported but not fully reconciled on both sides.
When to investigate vs when to write off
A residual balance under £5 is almost always rounding from currency conversions and can be written off to miscellaneous expense. A large balance — hundreds or thousands — means a genuine unreconciled position. Common causes: transactions that couldn't be mapped to any nominal code, or movements that imported against a P&L account but should have been inter-account transfers.
Trading Accounts vs P&L Accounts
Where a transaction is posted determines whether it affects your tax liability. Getting this wrong is surprisingly common.
The fundamental split
Balance sheet accounts
Assets, liabilities, equity. Record what you own and what you owe. No P&L or tax impact.
P&L accounts
Income, cost of sales, expenses. Record what you earned and spent. Directly affects taxable profit.
Brokerage and trading accounts
A trading account — IC Broker, Revolut Trading, a securities portfolio — is an asset on the balance sheet. Money held with a broker is money you own. Moving funds into or out of a broker account does not create income or expenditure. The P&L impact comes only when you realise a gain or loss: when you sell a security for more or less than you paid. At that point, only the difference is posted to Investment Gains or Investment Losses — not the gross proceeds.
Common misclassification patterns
- Posting full sale proceeds to income instead of just the gain
- Tagging broker deposits as expenses and withdrawals as income
- Using Sales of Assets for all movements, netting to a false profit or loss
- Treating director loan repayments as income when funds return to the company
FX Gains and Losses on Multi-Currency Transactions
When does a currency movement create taxable income — and when is it just a transfer?
Transfer vs FX event
Moving £10,000 to EUR at €1.15 gives you €11,500. No tax event — you've changed the form of an asset you already owned. Six months later, converting €11,500 back at €1.10 gives you £10,454. The £454 difference is a taxable FX gain.
What the major platforms get wrong
Xero's unrealised FX revaluation produces large P&L swings that don't reflect actual converted amounts. QuickBooks rounds exchange rates to insufficient decimal places, creating systematic errors per transaction that accumulate across a year. Sage has documented bugs where home and foreign currency balances cannot simultaneously be correct. One analysis estimated this consumes 50–80 hours per month for businesses with 500+ foreign currency transactions.
Realised vs unrealised
A realised FX gain/loss occurs when you actually convert currency — taxable in the year it occurs. An unrealised gain/loss occurs when revaluing foreign currency balances at period-end rates. Under FRS 102, unrealised differences on monetary items must be recognised in P&L — but this creates reported profit volatility that doesn't correspond to cash received.
Bank Reconciliation — What It Actually Means
Not just matching numbers — understanding why the process exists and what it catches.
The definition
Bank reconciliation confirms that the balance in your accounting records matches — or can be fully explained against — the actual bank statement. It is not optional: unreconciled accounts are unreliable accounts, and VAT returns or statutory accounts based on them are at risk.
What it catches
Missing transactions
A payment that cleared the bank but was never recorded in the accounting system
Duplicate entries
The same transaction recorded twice — common after manual imports
Timing differences
BACS payments recorded when sent but clearing days later
Fraud
Unauthorised payments on the bank statement not in the expected records
How often to reconcile
For VAT-registered businesses: weekly is standard, monthly is the minimum. Annual reconciliation — completing twelve months in one session — means errors compound, fraud goes undetected, and VAT returns may be based on incorrect figures.
Dormant vs Active Company Accounts Filing
A dormant company still has filing obligations — and Companies House penalties are automatic.
What makes a company dormant
For Companies House purposes: no significant accounting transactions during the period — meaning nothing other than the payment of minimum share capital on incorporation, filing fees, or penalty charges. HMRC uses a slightly different test for Corporation Tax dormancy and these must be assessed separately.
Filing obligations — dormant company
Dormant Company Accounts (AA01)
Simplified balance sheet confirming no significant transactions. For micro-entities under FRS 105, filed in inline XBRL format.
Confirmation Statement (CS01)
Annual confirmation of registered details — required regardless of trading status.
Transitioning from dormant to active
Notify HMRC within three months of the start of business activity. First active accounts will include comparative figures for the dormant period — typically showing only share capital on the balance sheet. Countee supports direct filing of both dormant (AA01/FRS 105) and active (FRS 102 Section 1A abridged) accounts to Companies House via the official XBRL API.
Encountered an issue not covered here?
These articles grow from real cases. If you're dealing with something that isn't documented clearly anywhere, get in touch — we may have already solved it, and it will likely become the next entry on this page.
Try demo