Reconcile Your Solicitor VAT From Bank Statements

For a UK solicitor, a bank statement can be a useful control account for VAT reconciliation, but it cannot by itself establish the output VAT due. A credit may include standard-rated fees, exempt or outside-scope amounts, a reversal, client money or a transfer; the tax point also depends on the VAT accounting scheme. Match receipts to the client ledger and VAT invoices first. Only then may the one-sixth fraction be appropriate for a wholly standard-rated, VAT-inclusive amount at 20%.

Scope: UK VAT only

This guide addresses UK VAT. The United States has no federal VAT, and state sales-tax rules should be checked separately. EU member states also have their own rates and rules, so the UK fraction and HMRC guidance should not be exported to an EU practice.

At 31 July 2026, the UK standard rate is 20% and the registration threshold is £90,000 of taxable turnover, subject to the forward-looking registration rule and other exceptions. Verify both on GOV.UK’s VAT threshold page for the period at issue.

If you need the mechanics of turning a supported statement PDF into a reviewed spreadsheet, start with Bank Statements to Excel & CSV: A Lawyer’s Guide. This article assumes you have a checked table and focuses on reconciling output VAT.

The specific problem: gross fees in, no VAT column out

When a client pays your fee note, the money that hits your business (office) account is the gross amount — your net fee plus the VAT you charged. Your bank does not itemise it. The statement line reads “£4,800.00 received,” not “£4,000 fee + £800 VAT.” Multiply that across dozens of receipts in a quarter and you have a real reconciliation problem:

• The VAT may be embedded, but not every receipt is wholly standard-rated. The statement never provides the invoice-level breakdown.
• Fee income is mixed with everything else. Transfers from your client account, money on account of costs, recharged disbursements, and the occasional supplier credit all lands in the same feed. Not all of it carries output VAT.
• You cannot total what you cannot sort. A PDF is a picture of a table. You cannot filter it to “fee receipts only,” you cannot add a VAT column, and you certainly cannot SUM it.
• Classification errors distort the control total. A missing fee receipt can understate the reconciliation; client money or a reversal classified as fees can overstate it.

The fix is not to re-read the PDF line by line with a highlighter. It is to get the receipts into columns you can compute.

The method: extract, match, classify, then calculate

The bank feed is the starting population. The invoice and client-ledger records determine VAT treatment.

The VAT fraction that does the work

If a matched receipt is wholly VAT-inclusive consideration for a standard-rated supply at 20%, do not take 20% of the gross. The VAT fraction is 20/120, or 1/6.

So for any gross fee receipt:

• VAT element = gross ÷ 6
• Net fee = gross × 5 ÷ 6 (or simply gross − VAT)

A qualifying £6,000 gross amount contains £1,000 of VAT and £5,000 net. Do not apply that arithmetic until the VAT invoice confirms the rate and taxable amount.

The workflow, start to finish

1. Download the quarter’s statements from your business (office) account — the account fee income is paid into. Cover the full VAT period with no gaps.
2. Convert the PDFs to a spreadsheet so each receipt becomes a real row with Date, Description, and Amount. This is where a purpose-built converter earns its place: it reads the messy statement layout and gives you clean, sortable columns instead of scrambled text.
3. Match every credit. Link it to the client ledger, bill or VAT invoice and both sides of any transfer. Leave unmatched rows in an exception queue.
4. Classify the taxable amount and tax point. Separate fees, true disbursements, taxable recharges, reversals and client money. Confirm whether standard, cash or another accounting scheme applies.
5. Calculate and reconcile. Apply the correct fraction only to qualifying VAT-inclusive amounts, total by tax point and compare the result with the VAT account and return working papers.

Extraction removes retyping, but it is not infallible. BankStatementLab exports Excel, CSV or JSON; compare row counts, dates, signs, amounts and balances with the original statement before using the data in a tax calculation. Product output does not classify VAT.

For the generic mechanics of extracting and checking statement columns, How to Convert a Bank Statement PDF to Excel covers the conversion itself; here we stay on VAT reconciliation.

A worked example: reconstructing one quarter’s output VAT

This is the part you came for. Below is a single VAT quarter from a self-employed solicitor’s business account, converted from PDF. The credits are the gross fee receipts that landed in the account. We have added a VAT element (1/6) column and a Net column, and we have flagged which lines are fee income and which are not.

First, the full feed as it comes out of the converter — including the entries that must be excluded from output VAT:

Date	Description	Amount (gross)	Type
Apr 08	Client fee — conveyancing completion	+3,600.00	Fee income
Apr 19	Transfer from client account (on account of costs)	+2,500.00	Client-account transfer (exclude)
Apr 24	Client fee — probate matter	+1,800.00	Fee income
May 06	Client fee — commercial contract	+4,800.00	Fee income
May 15	Recharged court fee (disbursement)	+255.00	Disbursement recharge (review)
May 28	Client fee — litigation costs	+2,400.00	Fee income
Jun 11	Supplier credit	+90.00	Not income (exclude)
Jun 20	Client fee — retainer settled	+6,000.00	Fee income

Now isolate the fee income and apply the VAT fraction. Only the five genuine fee receipts go into the VAT reconstruction:

Date	Fee receipt (gross)	VAT element (1/6)	Net (5/6)
Apr 08	3,600.00	600.00	3,000.00
Apr 24	1,800.00	300.00	1,500.00
May 06	4,800.00	800.00	4,000.00
May 28	2,400.00	400.00	2,000.00
Jun 20	6,000.00	1,000.00	5,000.00
Total	18,600.00	3,100.00	15,500.00

In this deliberately simplified illustration, the five rows have already been matched to standard-rated VAT invoices. They produce a bank-receipt control subtotal of £3,100. That is not automatically Box 1 of the VAT return: timing differences, credit notes, other accounts and the accounting scheme must still be reconciled to the VAT account.

Note what you did not do: you did not take 20% of £18,600 (that would give £3,720, which is wrong). You took one-sixth. That single distinction is the most common VAT-fraction error, and doing it on a spreadsheet with a visible formula makes it obvious rather than easy to fluff.

The calculation covers only this sample population. Input tax requires valid evidence and separate eligibility analysis; it cannot be derived merely by applying a fraction to outgoing bank payments. See HMRC’s VAT recordkeeping rules before building the expense side.

Traps that distort a solicitor’s output VAT

The arithmetic is easy. Getting the right receipts into it is where solicitors slip.

• Confusing client and office account movements. Match transfers to the client ledger and bill. The bank transfer date does not universally determine the VAT tax point, and client money should not be treated as fee income merely because it moved between accounts.
• Taking 20% of the gross. As above — the fraction on a VAT-inclusive amount is 1/6, not 1/5. Build the formula once and it protects you every quarter.
• Mishandling disbursements. HMRC requires all conditions in VAT Notice 700 section 25 to be met. Many solicitor costs described commercially as disbursements remain taxable recharges, so retain the third-party invoice and review each item.
• Missing a receipt. A gap in your statements is a gap in your output VAT. Download the complete period so no banked fee escapes the total.
• Trusting a scrambled export. Generic PDF tools often shift amounts onto the wrong row, which quietly corrupts a VAT total. Always eyeball the converted figures against the statement before you sum the VAT column.
• Mixing cash-basis and invoice timing. When output VAT falls due depends on your VAT accounting scheme (for example, standard invoice accounting versus cash accounting). Reconstructing from bank receipts maps naturally to a cash basis; if you account on invoices, treat the bank total as a cross-check against your raised fee notes, not necessarily the return figure itself.

Confidentiality and retention

A solicitor’s statement may reveal client names, matter values and account details. Assess confidentiality, access controls, processor terms and your retention duties before uploading it anywhere.

For BankStatementLab, a successfully processed source file is deleted after extraction; a failed source may be retained for troubleshooting for up to 14 days. Extracted data in a signed-in account remains until the user deletes it manually unless optional auto-deletion is enabled. Auto-deletion is disabled by default; when enabled, it can be set from 1 to 30 days and starts at 14 days. These lifecycle details matter when documenting your assessment. Retain your own bank-issued statement and VAT evidence for the applicable legal period.

Frequently asked questions

How do I calculate the VAT element from a gross fee receipt?

If the full receipt is consideration for a standard-rated UK supply at 20%, the VAT-inclusive fraction is one-sixth. Confirm the VAT invoice, taxable amount and tax point first; a bank credit alone cannot establish them.

How do I separate fee income from client-account money on my statement?

Match every credit to the client ledger, bill or VAT invoice and both sides of any transfer. Leave unmatched credits as exceptions. The bank narrative does not establish VAT treatment.

Do I charge VAT on recharged disbursements like court fees?

Only a payment meeting all HMRC conditions can be excluded as a disbursement. Other recharges form part of the solicitor’s taxable supply. Keep the evidence required by Notice 700 and obtain advice for ambiguous items.

When do I have to register for VAT as a self-employed solicitor?

At 31 July 2026, registration is generally required when taxable turnover exceeds £90,000 over the previous 12 months or is expected to exceed it in the next 30 days. Check the current GOV.UK rule and exceptions for your facts.

Do US attorneys need to reconstruct output VAT this way?

The US has no federal VAT. State and local treatment of legal services varies, so a US attorney should check the relevant jurisdiction instead of applying the UK one-sixth method.

Can I reconstruct output VAT if my only record is the bank statement?

A statement can produce a control total, but it normally cannot determine the return without invoices, the VAT account, client-ledger records and the applicable tax points. Recover those records and seek professional help when the source trail is incomplete.

The bottom line

Use the bank statement as a completeness check: extract it, match each receipt to the underlying records, classify tax treatment and timing, then reconcile the calculated control total to the VAT account. The one-sixth formula is arithmetic—not a substitute for that evidence.

Extract statement rows for your reconciliation workbook

Related articles

• Bank Statements to Excel & CSV: A Lawyer’s Guide
• Generate a Profit & Loss Statement from Your Bank Statement
• How to Prepare Bank Statements for Your Accountant
• Bookkeeping From Bank Statements When You Have No Invoices