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 relevant VAT period depends on the tax-point rules and any accounting scheme you use. Check receipts against the client ledger and VAT invoices inside the firm’s approved system. 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.
As checked on 12 November 2026, the UK standard rate is 20%. A UK-established practice generally must register if taxable turnover exceeds £90,000 in the previous 12 months or is expected to exceed £90,000 in the next 30 days alone. 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 a wholly standard-rated VAT-inclusive fee note in full, the receipt in your business (office) account is the gross amount: the net fee plus VAT. 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.
For ordinary VAT accounting, start with the basic tax point for the service, usually when the work is complete. An earlier VAT invoice or payment, or a VAT invoice issued within 14 days of the basic tax point, can change it under HMRC’s tax-point rules. HMRC’s guidance on solicitors’ client accounts treats a transfer of fees to the office account as receipt of payment. Check the bill and allocation, then apply the relevant tax-point rules.
The workflow, start to finish
Check statement narratives and payment references before using an external service. Use only firm-approved office-account statements and accounting exports without confidential client or matter information. Keep client or trust-account statements, invoices, approvals and the client ledger in the firm’s approved systems. In the working spreadsheet, use a payment-level reference that does not identify the client or disclose the matter.
- 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 internally. Use the approved client ledger, bill or VAT invoice and both sides of any client-to-office transfer. Keep unmatched rows open for review.
- Classify the taxable amount and establish the VAT period. Separate fees, true disbursements, taxable recharges, reversals and client money. Confirm whether ordinary VAT accounting, the Cash Accounting Scheme or another scheme applies.
- Calculate and reconcile. Apply the correct fraction only to qualifying VAT-inclusive amounts, total by the applicable VAT accounting period 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 | Court fee reimbursed | +255.00 | Review against HMRC disbursement conditions |
| 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.1.1 to be met. Many solicitor costs described commercially as disbursements remain taxable recharges, so retain the third-party invoice and review each item. Confirm that the client received the third-party supply, was responsible for paying for it and authorised you to pay as agent. Show the exact amount separately and check all the other conditions in section 25.1.1.
- 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.
- Using the bank posting date as the VAT date. If you use the VAT Cash Accounting Scheme, account for VAT on eligible sales in the period you receive payment, using HMRC’s rules for the payment method. For card payments, use the sales voucher date and reconcile gross receipts, fees and net payouts. If an agent collects payment on your behalf, use the period when the agent collects it and the taxable amount collected before the agent’s deductions. For fees withdrawn from a client account, use the withdrawal date under HMRC’s client-account guidance. Under ordinary VAT accounting, reconcile receipts against the tax points in your VAT records.
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 SRA-regulated firms in England and Wales, keep the client-account reconciliation in the firm’s approved system. Check SRA Accounts Rules 4.3 and 8.3 for transfers to pay costs and for the separate client-account reconciliation. See SRA confidentiality guidance before using a third-party service.
BankStatementLab deletes source files immediately as soon as extraction succeeds. Extracted results have separate retention settings. 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
With an active Starter, Pro or Business plan, use BankStatementLab reconciliation to compare processed office-account statements with a firm-approved accounting export for the same account and currency. Approve reviewed pairs and export Excel, CSV or PDF with the unresolved items. Determine the tax point, VAT rate and treatment of client money in your approved records.
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. Check the VAT invoice for the rate and taxable amount. Use the applicable tax-point and accounting-scheme rules to decide which VAT period includes it. 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 inside your firm’s approved system to the client ledger, bill or VAT invoice and both sides of any client-to-office transfer. Use only a non-identifying payment-level reference in the working spreadsheet. 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?
As checked on 12 November 2026, a UK-established practice generally must register if taxable turnover exceeds £90,000 in the previous 12 months or is expected to exceed £90,000 in the next 30 days alone. Separate 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. Use the applicable tax-point and accounting-scheme rules to decide which VAT period includes each amount. Recover the billing and client-ledger records in your firm’s approved system and use bank receipts as a reconciliation source. Seek professional help if records are incomplete.
Complete the reconciliation
Use the approved office-account statement as a completeness check. Extract the rows, match receipts to the underlying records in your approved system, and confirm tax treatment and timing. Reconcile the calculated control total to the VAT account before relying on the one-sixth calculation.
Create an account to extract approved office-account statements
Related articles
Save hours every week
Turn your bank statements (PDF) into Excel, CSV or OFX, without manual retyping.