Save hours every week
Turn your bank statements (PDF) into Excel, CSV or OFX, without manual retyping.
For a UK solicitor, a bank statement can be a useful source 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 the VAT rate and registration rules 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 usually does not provide 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 land in the same feed. Not all of it carries output VAT.
- The PDF needs a checked working table. A PDF may contain text or a scan, but its visual rows are not necessarily structured spreadsheet cells. Extract or transcribe the relevant rows, then validate them before calculating.
- 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.
A checked spreadsheet makes the calculation easier to review alongside the invoices and client ledger.
The method: extract, match, classify, then calculate
The bank statement supplies the receipt population to reconcile. 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.
For that qualifying gross amount:
- 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.
HMRC distinguishes money received into a client account from payment for the solicitor’s own supply. A later transfer to the office account may matter for the tax point; do not exclude it solely because its description says client-account transfer. Check the bill, allocation and timing under the applicable rules.
The workflow, start to finish
- 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.
- Convert the PDFs to a spreadsheet so each receipt becomes a real row with Date, Description, and Amount. Prefer a compatible structured export from the bank when available; otherwise check the extracted columns against every page.
- 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.
- 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.
- 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 all extracted tables, 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
The following hypothetical quarter includes fee receipts and other credits to an office 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, review the illustrative receipt population and the proposed classifications:
| Date | Description | Amount (gross) | Type |
|---|---|---|---|
| Apr 08 | Client fee — conveyancing completion | +3,600.00 | Fee income |
| Apr 19 | Transfer between own office accounts | +2,500.00 | Own-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. For this example, the transfer is between the firm’s own office accounts, the court fee has been verified against all disbursement conditions, and the supplier credit belongs in a separate input-tax review. They are excluded from this fee-receipt subtotal on that evidence. Only the five matched standard-rated fee receipts enter the calculation:
| 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. A visible formula makes this arithmetic easier to review, provided the underlying classification is correct.
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. Recheck the rate and taxable amount before reusing the formula.
- 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 missing statement can leave the receipt control incomplete. Reconcile the full period to invoices and the VAT account; it does not automatically mean output VAT was omitted from the return.
- Trusting a scrambled export. Any extraction can shift amounts onto the wrong row or omit transactions. Compare every relevant table with the statement before calculating; equal balances can conceal offsetting omissions.
- 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, source and result retention depend on the processing route and deletion settings. Do not assume that a successful extraction immediately deletes its source PDF. Check the current settings and processor terms when documenting your assessment. Retain your own bank-issued statement and VAT evidence for the applicable legal period.
Compare bank movements with your books
For a bank-to-books check before the VAT review, BankStatementLab reconciliation compares processed statements with exported office-account entries. Approve reviewed pairs and export Excel, CSV or PDF with the unresolved items. This comparison does not determine the tax point, VAT rate or treatment of client money.
Frequently asked questions
How do I calculate the VAT element from a gross fee receipt?
If—and only if—the full receipt is consideration for a standard-rated UK supply at 20%, the VAT-inclusive fraction is 20/120, or one-sixth. Use the VAT invoice and accounting scheme to confirm the taxable amount and tax point; a bank credit may combine fees, disbursements, reversals or client money and cannot establish those facts by itself.
How do I separate fee income from client-account money on my statement?
Match each credit to the client ledger, bill or VAT invoice and both sides of any client-to-office transfer. The bank narrative alone does not establish whether a receipt is taxable consideration, client money, a reversal or a disbursement. Unmatched credits should remain exceptions for review, not be forced into fee income.
Do I charge VAT on recharged disbursements like court fees?
Only payments meeting all of HMRC’s disbursement conditions may be excluded from the value of your supply. Many costs solicitors call disbursements are taxable recharges. Keep the third-party invoice and client authority, apply HMRC Notice 700 section 25, and obtain advice for ambiguous items.
When do I have to register for VAT as a self-employed solicitor?
At 31 July 2026 the UK registration threshold is £90,000 of taxable turnover over the previous 12 months, and registration can also be required if you expect to exceed it in the next 30 days. Other rules apply to non-established businesses. Check GOV.UK for the effective date and facts before relying on the figure.
Do US attorneys need to reconstruct output VAT this way?
The United States has no federal VAT. State and local sales-tax treatment of legal services varies, so a US attorney should check the rules for the relevant jurisdiction rather than applying the UK one-sixth method. This article addresses UK VAT only.
Can I reconstruct output VAT if my only record is the bank statement?
A statement can help reconstruct a control total, but it normally cannot determine the VAT return by itself. HMRC requires records of supplies and VAT invoices, and the correct tax point depends on the accounting scheme. Recover the billing and client-ledger records and use bank receipts as a reconciliation source; seek professional help if records are incomplete.
Complete the reconciliation
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
Save hours every week
Turn your bank statements (PDF) into Excel, CSV or OFX, without manual retyping.