Taxi Driver reconciliation
Reconciliation Report: GB Accounts Taxi Driver 2027-04-05 (Apr27) Excel 2007. Every figure below comes from a scenario driven through the shipped workbooks and read back out of the recalculated sheets.
<!-- SPDX-License-Identifier: LicenseRef-PolyForm-Internal-Use-1.0.0 -->
<!-- Copyright (C) 2006-2026 DIY Accounting Limited -->
Owner-driver taxi with steady daily fares, fuel, road tax and insurance, and a vehicle purchase. Owns the vehicle, so no car hire or rental.
Trade: Owner-driver private hire and taxi services
Summary
- Status: RECONCILES
- Featured scenario: taxi-scenario-basic (Basic taxi driver)
- Year end: 2027-04-05
- Checks: 88 passed, 0 warnings, 0 failed
- Reconciliation runs published: 8
Plausibility review: pass
The indicators align with the headline apart from a turnover difference of £500.00 between the headline and indicators, which is not a blocker under the rubric. All other checks (profit bridge residue zero, correct tax charging, no VAT where unregistered) hold.
- Turnover 36,045.00 (indicators): Differs from headline's 36,545.00 by 500.00; not a factor-of-ten mismatch but warrants note as it may reflect workbook adjustments [note]
Every run
| Year end | Period | Scenario | Status |
|---|---|---|---|
| 2027-04-05 | Apr27 | taxi-scenario-basic | RECONCILES |
| 2027-04-05 | Apr27 | taxi-scenario-sp-sixty | RECONCILES |
| 2026-04-05 | Apr26 | taxi-scenario-basic | RECONCILES |
| 2025-04-05 | Apr25 | taxi-scenario-basic | RECONCILES |
| 2024-04-05 | Apr24 | taxi-scenario-basic | RECONCILES |
| 2023-04-05 | Apr23 | taxi-scenario-basic | RECONCILES |
| 2022-04-05 | Apr22 | taxi-scenario-basic | RECONCILES |
| 2021-04-05 | Apr21 | taxi-scenario-basic | RECONCILES |
Reconciliation checks
| Check | Expected | Actual | Diff | Result |
|---|---|---|---|---|
| Total Sales | 36045 | 36045 | 0 | PASS |
| Other business income | 500 | 500 | 0 | PASS |
| P&L: Net = Gross - General Expenses | 28565 | 28565 | 0 | PASS |
| P&L: Cost of Sales = vehicle cost lines | 6100 | 6100 | 0 | PASS |
| P&L: Gross = Turnover - Cost of Sales | 29945 | 29945 | 0 | PASS |
| P&L: Capital Allowances / Mileage Allowance mutually exclusive | 0 | 0 | 0 | PASS |
| P&L: General expense lines sum = Total | 1380 | 1380 | 0 | PASS |
| VitalTax: Q1 turnover = P&L Q1 turnover | 9045 | 9045 | 0 | PASS |
| VitalTax: Q1 other income = P&L Q1 other income | 0 | 0 | 0 | PASS |
| VitalTax: Q1 total allowable expenses = P&L Q1 Cost of Sales + Total Expenses | 3079.999999999996 | 3080 | +4.092726157978177e-12 | PASS |
| VitalTax: Q2 turnover = P&L Q2 turnover | 9000 | 9000 | 0 | PASS |
| VitalTax: Q2 other income = P&L Q2 other income | 500 | 500 | 0 | PASS |
| VitalTax: Q2 total allowable expenses = P&L Q2 Cost of Sales + Total Expenses | 1299.9999999999989 | 1300 | +1.1368683772161603e-12 | PASS |
| VitalTax: Q3 turnover = P&L Q3 turnover | 9000 | 9000 | 0 | PASS |
| VitalTax: Q3 other income = P&L Q3 other income | 0 | 0 | 0 | PASS |
| VitalTax: Q3 total allowable expenses = P&L Q3 Cost of Sales + Total Expenses | 1299.9999999999989 | 1300 | +1.1368683772161603e-12 | PASS |
| VitalTax: Q4 turnover = P&L Q4 turnover | 9000 | 9000 | 0 | PASS |
| VitalTax: Q4 other income = P&L Q4 other income | 0 | 0 | 0 | PASS |
| VitalTax: Q4 total allowable expenses = P&L Q4 Cost of Sales + Total Expenses | 1799.9999999999989 | 1800 | +1.1368683772161603e-12 | PASS |
| VitalTax: annual turnover = P&L annual turnover | 36045 | 36045 | 0 | PASS |
| VitalTax: annual other income = P&L annual other income | 500 | 500 | 0 | PASS |
| VitalTax: annual total allowable expenses = P&L Cost of Sales + Total Expenses | 7480 | 7480 | 0 | PASS |
| Purchases: cash journal total = general expenses + vehicle running costs + capitalised vehicles | 14360 | 14360 | 0 | PASS |
| P&L: the comparison figure = running costs plus the schedule's allowances | 6100 | 6100 | 0 | PASS |
| P&L: the route follows the comparison | PASS | |||
| SA103S: Turnover = P&L Sales | 36045 | 36045 | 0 | PASS |
| SA103S: Net profit (pre-capital-allowance) = P&L Net + Capital Allowances | 29685 | 29685 | 0 | PASS |
| SA103S: Other business income (box 30) = P&L other income | 500 | 500 | 0 | PASS |
| Fixed Assets: New asset cost recorded | 8000 | 8000 | 0 | PASS |
| Fixed Assets: written-down value = cost less the allowance | 6880 | 6880 | 0 | PASS |
| Fixed Assets: WDA claimed = cost x Admin WDA rate | 1120 | 1120 | 0 | PASS |
| Fixed Assets: Schedule capital allowance total = P&L Capital Allowances | 1120 | 1120 | 0 | PASS |
| Admin: Personal Allowance = tax data | 12570 | 12570 | 0 | PASS |
| Admin: Personal Allowance Taper Threshold = tax data | 100000 | 100000 | 0 | PASS |
| Admin: Basic Rate = tax data | 0.2 | 0.2 | 0 | PASS |
| Admin: Higher Rate = tax data | 0.4 | 0.4 | 0 | PASS |
| Admin: Additional Rate = tax data | 0.45 | 0.45 | 0 | PASS |
| Admin: Basic Band End = tax data | 37700 | 37700 | 0 | PASS |
| Admin: Higher Band Start = tax data | 37701 | 37701 | 0 | PASS |
| Admin: Higher Band End = tax data | 125140 | 125140 | 0 | PASS |
| Admin: NI Class 2 Weekly Rate = tax data | 3.65 | 3.65 | 0 | PASS |
| Admin: NI Class 2 Small Profits Threshold = tax data | 7105 | 7105 | 0 | PASS |
| Admin: NI Class 4 Lower Rate = tax data | 0.06 | 0.06 | 0 | PASS |
| Admin: NI Class 4 Lower Limit = tax data | 12570 | 12570 | 0 | PASS |
| Admin: NI Class 4 Upper Rate = tax data | 0.02 | 0.02 | 0 | PASS |
| Admin: NI Class 4 Upper Limit = tax data | 50270 | 50270 | 0 | PASS |
| Admin: AIA Rate = tax data | 1 | 1 | 0 | PASS |
| Admin: WDA Rate = tax data | 0.14 | 0.14 | 0 | PASS |
| Admin: Mileage Higher Rate Limit = tax data | 10000 | 10000 | 0 | PASS |
| Admin: Mileage Higher Rate Pence = tax data | 0.45 | 0.45 | 0 | PASS |
| Admin: Mileage Lower Rate Start = tax data | 10001 | 10001 | 0 | PASS |
| Admin: Mileage Lower Rate Pence = tax data | 0.25 | 0.25 | 0 | PASS |
| Admin: VAT Registration Threshold = tax data | 90000 | 90000 | 0 | PASS |
| Income Tax | 3299 | 3299 | 0 | PASS |
| NI Class 4 (lower) | 989.6999999999999 | 989.7 | +1.1368683772161603e-13 | PASS |
| Total Tax + NI | 4288.7 | 4288.7 | 0 | PASS |
| Tax: first payment on account is half the liability | 2144.35 | 2144.35 | 0 | PASS |
| Tax: second payment on account is half the liability | 2144.35 | 2144.35 | 0 | PASS |
| Tax: Personal allowance after taper | 12570 | 12570 | 0 | PASS |
| Tax: sheet applies the basic rate to the lower band | 0.2 | 0.2 | 0 | PASS |
| Tax: sheet applies the higher rate above the band | 0.4 | 0.4 | 0 | PASS |
| Tax: sheet applies the additional rate above the higher band | 0.45 | 0.45 | 0 | PASS |
| Tax: sheet splits the basic and higher bands at the basic band end | 37700 | 37700 | 0 | PASS |
| Tax: sheet splits the higher and additional bands at the higher band end | 125140 | 125140 | 0 | PASS |
| Tax at basic rate | 3299 | 3299 | 0 | PASS |
| Tax at higher rate | 0 | 0 | 0 | PASS |
| Tax at additional rate | 0 | 0 | 0 | PASS |
| Tax: Taxable = Profit - Allowance | 16495 | 16495 | 0 | PASS |
| Tax: IT = Basic + Higher + Additional | 3299 | 3299 | 0 | PASS |
| Tax: Total = IT + NI | 4288.7 | 4288.7 | 0 | PASS |
| SA103S: Profit for tax = Draft Tax E5 | 29065 | 29065 | 0 | PASS |
| Forecast: months of actual trade = P&L months with turnover | 12 | 12 | 0 | PASS |
| Forecast: months of actual trade = the fixture's | 12 | 12 | 0 | PASS |
| Forecast: turnover = the traded months plus the year spread over the rest | 36045 | 36045 | 0 | PASS |
| Forecast: cost of sales = the traded months plus the year spread over the rest | 6099.999999999993 | 6100 | +7.275957614183426e-12 | PASS |
| Forecast: general expenses = the traded months plus the year spread over the rest | 1380 | 1380 | 0 | PASS |
| Forecast: other business income = P&L other business income | 500 | 500 | 0 | PASS |
| Forecast: turnover = P&L turnover | 36045 | 36045 | 0 | PASS |
| Forecast: cost of sales = P&L cost of sales | 6099.999999999993 | 6100 | +7.275957614183426e-12 | PASS |
| Forecast: general expenses = P&L general expenses | 1380 | 1380 | 0 | PASS |
| Forecast: profit = turnover + other income - cost of sales - expenses | 29065 | 29065 | 0 | PASS |
| Forecast: personal allowance after taper | 12570 | 12570 | 0 | PASS |
| Forecast: tax at standard rate | 3299 | 3299 | 0 | PASS |
| Forecast: tax at higher rate | 0 | 0 | 0 | PASS |
| Forecast: tax at additional rate | 0 | 0 | 0 | PASS |
| Forecast: National Insurance | 989.6999999999999 | 989.7 | +1.1368683772161603e-13 | PASS |
| Forecast: tax and NI liability | 4288.7 | 4288.7 | 0 | PASS |
| Accounting profit to tax profit bridge closes to zero | 0 | 0 | 0 | PASS |
Input transactions
Business details
| Item | Value |
|---|---|
| Name | Basic Taxi Driver |
| Description | Owner-driver private hire and taxi services |
| Address | 17 Station Road |
| Town | Derby |
| Postcode | DE1 2GH |
| Phone | 01332 555 0300 |
| Utr | 5566778899 |
Month by month
| Month | Sales entries | Sales total | Purchases entries | Purchases total |
|---|---|---|---|---|
| Apr | 16 | 3,045.00 | 5 | 2,200.00 |
| May | 15 | 3,000.00 | 1 | 300.00 |
| Jun | 15 | 3,000.00 | 2 | 8,300.00 |
| Jul | 15 | 3,000.00 | 2 | 420.00 |
| Aug | 15 | 3,000.00 | 1 | 300.00 |
| Sep | 16 | 3,500.00 | 1 | 300.00 |
| Oct | 15 | 3,000.00 | 2 | 420.00 |
| Nov | 15 | 3,000.00 | 1 | 300.00 |
| Dec | 15 | 3,000.00 | 1 | 300.00 |
| Jan | 15 | 3,000.00 | 3 | 920.00 |
| Feb | 15 | 3,000.00 | 1 | 300.00 |
| Mar | 15 | 3,000.00 | 1 | 300.00 |
| Year | 182 | 36,545.00 | 21 | 14,360.00 |
Every entry
Sales journal: 182 entries, 36,545.00
Apr
| Date | Amount |
|---|---|
| 2025-04-07 | 200.00 |
| 2025-04-08 | 220.00 |
| 2025-04-09 | 180.00 |
| 2025-04-10 | 210.00 |
| 2025-04-11 | 190.00 |
| 2025-04-14 | 200.00 |
| 2025-04-15 | 220.00 |
| 2025-04-16 | 180.00 |
| 2025-04-17 | 200.00 |
| 2025-04-18 | 200.00 |
| 2025-04-21 | 200.00 |
| 2025-04-22 | 200.00 |
| 2025-04-23 | 200.00 |
| 2025-04-24 | 200.00 |
| 2025-04-25 | 200.00 |
| 2025-04-07 | 45.00 |
May
| Date | Amount |
|---|---|
| 2025-05-05 | 200.00 |
| 2025-05-06 | 200.00 |
| 2025-05-07 | 200.00 |
| 2025-05-08 | 200.00 |
| 2025-05-09 | 200.00 |
| 2025-05-12 | 200.00 |
| 2025-05-13 | 200.00 |
| 2025-05-14 | 200.00 |
| 2025-05-15 | 200.00 |
| 2025-05-16 | 200.00 |
| 2025-05-19 | 200.00 |
| 2025-05-20 | 200.00 |
| 2025-05-21 | 200.00 |
| 2025-05-22 | 200.00 |
| 2025-05-23 | 200.00 |
Jun
| Date | Amount |
|---|---|
| 2025-06-02 | 200.00 |
| 2025-06-03 | 200.00 |
| 2025-06-04 | 200.00 |
| 2025-06-05 | 200.00 |
| 2025-06-06 | 200.00 |
| 2025-06-09 | 200.00 |
| 2025-06-10 | 200.00 |
| 2025-06-11 | 200.00 |
| 2025-06-12 | 200.00 |
| 2025-06-13 | 200.00 |
| 2025-06-16 | 200.00 |
| 2025-06-17 | 200.00 |
| 2025-06-18 | 200.00 |
| 2025-06-19 | 200.00 |
| 2025-06-20 | 200.00 |
Jul
| Date | Amount |
|---|---|
| 2025-07-07 | 200.00 |
| 2025-07-08 | 200.00 |
| 2025-07-09 | 200.00 |
| 2025-07-10 | 200.00 |
| 2025-07-11 | 200.00 |
| 2025-07-14 | 200.00 |
| 2025-07-15 | 200.00 |
| 2025-07-16 | 200.00 |
| 2025-07-17 | 200.00 |
| 2025-07-18 | 200.00 |
| 2025-07-21 | 200.00 |
| 2025-07-22 | 200.00 |
| 2025-07-23 | 200.00 |
| 2025-07-24 | 200.00 |
| 2025-07-25 | 200.00 |
Aug
| Date | Amount |
|---|---|
| 2025-08-04 | 200.00 |
| 2025-08-05 | 200.00 |
| 2025-08-06 | 200.00 |
| 2025-08-07 | 200.00 |
| 2025-08-08 | 200.00 |
| 2025-08-11 | 200.00 |
| 2025-08-12 | 200.00 |
| 2025-08-13 | 200.00 |
| 2025-08-14 | 200.00 |
| 2025-08-15 | 200.00 |
| 2025-08-18 | 200.00 |
| 2025-08-19 | 200.00 |
| 2025-08-20 | 200.00 |
| 2025-08-21 | 200.00 |
| 2025-08-22 | 200.00 |
Sep
| Date | Customer | Account | Amount |
|---|---|---|---|
| 2025-09-01 | 200.00 | ||
| 2025-09-02 | 200.00 | ||
| 2025-09-03 | 200.00 | ||
| 2025-09-04 | 200.00 | ||
| 2025-09-05 | 200.00 | ||
| 2025-09-08 | 200.00 | ||
| 2025-09-09 | 200.00 | ||
| 2025-09-10 | 200.00 | ||
| 2025-09-11 | 200.00 | ||
| 2025-09-12 | 200.00 | ||
| 2025-09-15 | 200.00 | ||
| 2025-09-16 | 200.00 | ||
| 2025-09-17 | 200.00 | ||
| 2025-09-18 | 200.00 | ||
| 2025-09-19 | 200.00 | ||
| 2025-09-15 | Start-up grant | 4001 | 500.00 |
Oct
| Date | Amount |
|---|---|
| 2025-10-06 | 200.00 |
| 2025-10-07 | 200.00 |
| 2025-10-08 | 200.00 |
| 2025-10-09 | 200.00 |
| 2025-10-10 | 200.00 |
| 2025-10-13 | 200.00 |
| 2025-10-14 | 200.00 |
| 2025-10-15 | 200.00 |
| 2025-10-16 | 200.00 |
| 2025-10-17 | 200.00 |
| 2025-10-20 | 200.00 |
| 2025-10-21 | 200.00 |
| 2025-10-22 | 200.00 |
| 2025-10-23 | 200.00 |
| 2025-10-24 | 200.00 |
Nov
| Date | Amount |
|---|---|
| 2025-11-03 | 200.00 |
| 2025-11-04 | 200.00 |
| 2025-11-05 | 200.00 |
| 2025-11-06 | 200.00 |
| 2025-11-07 | 200.00 |
| 2025-11-10 | 200.00 |
| 2025-11-11 | 200.00 |
| 2025-11-12 | 200.00 |
| 2025-11-13 | 200.00 |
| 2025-11-14 | 200.00 |
| 2025-11-17 | 200.00 |
| 2025-11-18 | 200.00 |
| 2025-11-19 | 200.00 |
| 2025-11-20 | 200.00 |
| 2025-11-21 | 200.00 |
Dec
| Date | Amount |
|---|---|
| 2025-12-01 | 200.00 |
| 2025-12-02 | 200.00 |
| 2025-12-03 | 200.00 |
| 2025-12-04 | 200.00 |
| 2025-12-05 | 200.00 |
| 2025-12-08 | 200.00 |
| 2025-12-09 | 200.00 |
| 2025-12-10 | 200.00 |
| 2025-12-11 | 200.00 |
| 2025-12-12 | 200.00 |
| 2025-12-15 | 200.00 |
| 2025-12-16 | 200.00 |
| 2025-12-17 | 200.00 |
| 2025-12-18 | 200.00 |
| 2025-12-19 | 200.00 |
Jan
| Date | Amount |
|---|---|
| 2026-01-05 | 200.00 |
| 2026-01-06 | 200.00 |
| 2026-01-07 | 200.00 |
| 2026-01-08 | 200.00 |
| 2026-01-09 | 200.00 |
| 2026-01-12 | 200.00 |
| 2026-01-13 | 200.00 |
| 2026-01-14 | 200.00 |
| 2026-01-15 | 200.00 |
| 2026-01-16 | 200.00 |
| 2026-01-19 | 200.00 |
| 2026-01-20 | 200.00 |
| 2026-01-21 | 200.00 |
| 2026-01-22 | 200.00 |
| 2026-01-23 | 200.00 |
Feb
| Date | Amount |
|---|---|
| 2026-02-02 | 200.00 |
| 2026-02-03 | 200.00 |
| 2026-02-04 | 200.00 |
| 2026-02-05 | 200.00 |
| 2026-02-06 | 200.00 |
| 2026-02-09 | 200.00 |
| 2026-02-10 | 200.00 |
| 2026-02-11 | 200.00 |
| 2026-02-12 | 200.00 |
| 2026-02-13 | 200.00 |
| 2026-02-16 | 200.00 |
| 2026-02-17 | 200.00 |
| 2026-02-18 | 200.00 |
| 2026-02-19 | 200.00 |
| 2026-02-20 | 200.00 |
Mar
| Date | Amount |
|---|---|
| 2026-03-02 | 200.00 |
| 2026-03-03 | 200.00 |
| 2026-03-04 | 200.00 |
| 2026-03-05 | 200.00 |
| 2026-03-06 | 200.00 |
| 2026-03-09 | 200.00 |
| 2026-03-10 | 200.00 |
| 2026-03-11 | 200.00 |
| 2026-03-12 | 200.00 |
| 2026-03-13 | 200.00 |
| 2026-03-16 | 200.00 |
| 2026-03-17 | 200.00 |
| 2026-03-18 | 200.00 |
| 2026-03-19 | 200.00 |
| 2026-03-20 | 200.00 |
Purchase journal: 21 entries, 14,360.00
Apr
| Date | Supplier | Account | Description | Code | Amount |
|---|---|---|---|---|---|
| 2025-04-06 | DVLA | 5400 | Vehicle excise duty | t | 180.00 |
| 2025-04-08 | Council | 5900 | Private hire licence | l | 400.00 |
| 2025-04-10 | Insurance Co | 5400 | Hire and reward insurance | t | 1,200.00 |
| 2025-04-15 | Shell | 5100 | Fuel | d | 300.00 |
| 2025-04-20 | Vodafone | 5700 | Mobile telephone | g | 120.00 |
May
| Date | Supplier | Account | Description | Code | Amount |
|---|---|---|---|---|---|
| 2025-05-15 | Shell | 5100 | Fuel | d | 300.00 |
Jun
| Date | Supplier | Account | Description | Code | Amount | Reference |
|---|---|---|---|---|---|---|
| 2025-06-01 | Car Dealer | 7000 | Taxi vehicle | f | 8,000.00 | VEH-0601 |
| 2025-06-15 | Shell | 5100 | Fuel | d | 300.00 |
Jul
| Date | Supplier | Account | Description | Code | Amount |
|---|---|---|---|---|---|
| 2025-07-10 | Vodafone | 5700 | Mobile telephone | g | 120.00 |
| 2025-07-15 | Shell | 5100 | Fuel | d | 300.00 |
Aug
| Date | Supplier | Account | Description | Code | Amount |
|---|---|---|---|---|---|
| 2025-08-15 | Shell | 5100 | Fuel | d | 300.00 |
Sep
| Date | Supplier | Account | Description | Code | Amount |
|---|---|---|---|---|---|
| 2025-09-15 | Shell | 5100 | Fuel | d | 300.00 |
Oct
| Date | Supplier | Account | Description | Code | Amount |
|---|---|---|---|---|---|
| 2025-10-10 | Vodafone | 5700 | Mobile telephone | g | 120.00 |
| 2025-10-15 | Shell | 5100 | Fuel | d | 300.00 |
Nov
| Date | Supplier | Account | Description | Code | Amount |
|---|---|---|---|---|---|
| 2025-11-15 | Shell | 5100 | Fuel | d | 300.00 |
Dec
| Date | Supplier | Account | Description | Code | Amount |
|---|---|---|---|---|---|
| 2025-12-15 | Shell | 5100 | Fuel | d | 300.00 |
Jan
| Date | Supplier | Account | Description | Code | Amount |
|---|---|---|---|---|---|
| 2026-01-10 | Vodafone | 5700 | Mobile telephone | g | 120.00 |
| 2026-01-15 | Shell | 5100 | Fuel | d | 300.00 |
| 2026-01-20 | Accountant | 5900 | Accountancy fees | l | 500.00 |
Feb
| Date | Supplier | Account | Description | Code | Amount |
|---|---|---|---|---|---|
| 2026-02-15 | Shell | 5100 | Fuel | d | 300.00 |
Mar
| Date | Supplier | Account | Description | Code | Amount |
|---|---|---|---|---|---|
| 2026-03-15 | Shell | 5100 | Fuel | d | 300.00 |
Screenshots
Accounting statements
Accounting profit to tax profit bridge
| Line | Cell | Amount |
|---|---|---|
| Net profit per the profit and loss account | Profit & Loss Acc!B23 | 28,565 |
| Add capital allowances charged in cost of sales | Profit & Loss Acc!B10 | 1,120 |
| Add other business income (box 10) | SE Short!O38 | 0 |
| Less net loss for the year (box 22) | SE Short!O71 | 0 |
| Less annual investment allowance (box 23) | SE Short!D80 | 0 |
| Less small-balance allowance (box 24) | SE Short!D85 | 0 |
| Less other capital allowances (box 25) | SE Short!O80 | -1,120 |
| Add balancing charges (box 26) | SE Short!O85 | 0 |
| Add goods and services for own use (box 27) | SE Short!D94 | 0 |
| Add other business income (box 30) | SE Short!O99 | 500 |
| Less loss brought forward (box 29) | SE Short!O94 | 0 |
| Tax profit the bridge computes | 29,065 | |
| Tax profit the sheet carries | Draft Tax calculation!E5 | 29,065 |
| Residue | 0 |
Business Details
| Amount | |
|---|---|
| Business Name | Basic Taxi Driver |
| Description of business | Owner-driver private hire and taxi services |
| Postcode | DE1 2GH |
| UTR | 5566778899 |
| Losses brought forward (box 29) | — |
| Goods and services for own use (box 27) | — |
Profit & Loss Account
| Amount | |
|---|---|
| Turnover (Total Fares) | 36,045 |
| Fuel | 3,600 |
| Car Hire / Rental | 0 |
| Repairs & Servicing | 0 |
| Road Tax & Insurance | 1,380 |
| Capital Allowances | 1,120 |
| Mileage Allowance | 0 |
| Cost of Sales (vehicle costs) | 6,100 |
| Gross Profit | 29,945 |
| Employee Costs | 0 |
| Premises Costs | 0 |
| General Admin | 480 |
| Advertising | 0 |
| Legal & Professional | 900 |
| Interest & Bank Charges | 0 |
| Bank Charges | 0 |
| Other Expenses | 0 |
| Total General Expenses | 1,380 |
| Net Profit | 28,565 |
| Any Other Business Income | 500 |
| Running costs plus capital allowances | 6,100 |
| Route the sheet takes | — |
Monthly Takings
| Amount | |
|---|---|
| Apr | 3,045 |
| May | 3,000 |
| Jun | 3,000 |
| Jul | 3,000 |
| Aug | 3,000 |
| Sep | 3,000 |
| Oct | 3,000 |
| Nov | 3,000 |
| Dec | 3,000 |
| Jan | 3,000 |
| Feb | 3,000 |
| Mar | 3,000 |
Monthly Vehicle Costs
| Amount | |
|---|---|
| Apr | 1,773.33 |
| May | 393.33 |
| Jun | 393.33 |
| Jul | 393.33 |
| Aug | 393.33 |
| Sep | 393.33 |
| Oct | 393.33 |
| Nov | 393.33 |
| Dec | 393.33 |
| Jan | 393.33 |
| Feb | 393.33 |
| Mar | 393.33 |
Monthly Running Costs
| Amount | |
|---|---|
| Apr | 520 |
| May | 0 |
| Jun | 0 |
| Jul | 120 |
| Aug | 0 |
| Sep | 0 |
| Oct | 120 |
| Nov | 0 |
| Dec | 0 |
| Jan | 620 |
| Feb | 0 |
| Mar | 0 |
Monthly Other Income
| Amount | |
|---|---|
| Apr | 0 |
| May | 0 |
| Jun | 0 |
| Jul | 0 |
| Aug | 0 |
| Sep | 500 |
| Oct | 0 |
| Nov | 0 |
| Dec | 0 |
| Jan | 0 |
| Feb | 0 |
| Mar | 0 |
Quarterly Summary
| Amount | |
|---|---|
| Q1 Turnover | 9,045 |
| Q2 Turnover | 9,000 |
| Q3 Turnover | 9,000 |
| Q4 Turnover | 9,000 |
| Annual Turnover | 36,045 |
| Q1 Other income | 0 |
| Q2 Other income | 500 |
| Q3 Other income | 0 |
| Q4 Other income | 0 |
| Annual Other income | 500 |
| Q1 Total Allowable Expenses | 3,080 |
| Q2 Total Allowable Expenses | 1,300 |
| Q3 Total Allowable Expenses | 1,300 |
| Q4 Total Allowable Expenses | 1,800 |
| Annual Total Allowable Expenses | 7,480 |
Wages Forecast
| Amount | |
|---|---|
| Months of actual trade | 12 |
| Forecast Sales Turnover | 36,045 |
| Forecast Investment Grants | 500 |
| Forecast Cost of Sales | 6,100 |
| Forecast General Expenses | 1,380 |
| Forecast Profit before Tax | 29,065 |
| Profit before Tax | 29,065 |
| Personal Allowance | 12,570 |
| Profit after Allowance | 16,495 |
| Tax at standard rate | 3,299 |
| Tax at higher rate | 0 |
| Tax at additional rate | 0 |
| National Insurance | 989.7 |
| Forecast Tax & NI Liability | 4,288.7 |
Purchase Analysis
| Amount | |
|---|---|
| Business miles for the year | 0 |
| Mileage claimed for the year | 0 |
| Vehicle running costs for the year | 4,980 |
| Vehicle purchases capitalised | 8,000 |
Fixed Assets
| Amount | |
|---|---|
| New Asset Cost (Vehicle under £12,000) | 8,000 |
| Total Annual Investment Allowance | 0 |
| Total Writing Down Allowance | 1,120 |
| Total Capital Allowance on Disposal | 0 |
| Total Balancing Charge | 0 |
| Written-down value carried forward | 6,880 |
Admin (Generator Injected)
| Amount | |
|---|---|
| Personal Allowance | 12,570 |
| Personal Allowance Taper Threshold | 100,000 |
| Basic Rate | 0.2 |
| Higher Rate | 0.4 |
| Additional Rate | 0.45 |
| Basic Band End | 37,700 |
| Higher Band Start | 37,701 |
| Higher Band End | 125,140 |
| NI Class 2 Weekly Rate | 3.65 |
| NI Class 2 Small Profits Threshold | 7,105 |
| NI Class 4 Lower Rate | 0.06 |
| NI Class 4 Lower Limit | 12,570 |
| NI Class 4 Upper Rate | 0.02 |
| NI Class 4 Upper Limit | 50,270 |
| Annual Investment Allowance Rate | 1 |
| Writing Down Allowance Rate | 0.14 |
| Mileage Higher Rate Limit | 10,000 |
| Mileage Higher Rate Pence | 0.45 |
| Mileage Lower Rate Start | 10,001 |
| Mileage Lower Rate Pence | 0.25 |
| VAT Registration Threshold | 90,000 |
Cell values behind these statements
Business Details
| Cell | DIY Label | Value | diya-gl mapping |
|---|---|---|---|
| C5 | Business Name | Basic Taxi Driver | entityInformation.organizationIdentifier |
| C8 | Description of business | Owner-driver private hire and taxi services | entityInformation.organizationDescription |
| C17 | Postcode | DE1 2GH | entityInformation.organizationPostcode |
| O5 | UTR | 5566778899 | entityInformation.taxRegistrationNumber |
Profit & Loss Acc
| Cell | DIY Label | Value | diya-gl mapping |
|---|---|---|---|
| B5 | Turnover (Total Fares) | 36045 | gl-cor:amount (salesTurnover) |
| B6 | Fuel | 3600 | accounts.purchases.5100 (fuel) |
| B7 | Car Hire / Rental | 0 | accounts.purchases.5200 (carHire) |
| B8 | Repairs & Servicing | 0 | accounts.purchases.5300 (repairs) |
| B9 | Road Tax & Insurance | 1380 | accounts.purchases.5400 (taxIns) |
| B10 | Capital Allowances | 1120 | tax.capitalAllowances |
| B11 | Mileage Allowance | 0 | tax.mileage (allowance) |
| B12 | Cost of Sales (vehicle costs) | 6100 | gl-cor:amount (costOfSales) |
| B13 | Gross Profit | 29945 | gl-cor:amount (grossProfit) |
| B14 | Employee Costs | 0 | accounts.purchases.5500 |
| B15 | Premises Costs | 0 | accounts.purchases.5600 |
| B16 | General Admin | 480 | accounts.purchases.5700 |
| B17 | Advertising | 0 | accounts.purchases.5800 |
| B18 | Legal & Professional | 900 | accounts.purchases.5900 |
| B19 | Interest & Bank Charges | 0 | accounts.purchases.6000 |
| B20 | Bank Charges | 0 | accounts.purchases.6100 |
| B21 | Other Expenses | 0 | accounts.purchases.6200 |
| B22 | Total General Expenses | 1380 | gl-cor:amount (totalGeneral) |
| B23 | Net Profit | 28565 | gl-cor:amount (netProfit) |
| B24 | Any Other Business Income | 500 | gl-cor:amount (otherIncome) |
| J1 | Running costs plus capital allowances | 6100 | accounts.purchases (vehicleCostsCompared) |
| C5 | Apr | 3045 | gl-cor:amount (monthlyTakings.apr) |
| D5 | May | 3000 | gl-cor:amount (monthlyTakings.may) |
| E5 | Jun | 3000 | gl-cor:amount (monthlyTakings.jun) |
| F5 | Jul | 3000 | gl-cor:amount (monthlyTakings.jul) |
| G5 | Aug | 3000 | gl-cor:amount (monthlyTakings.aug) |
| H5 | Sep | 3000 | gl-cor:amount (monthlyTakings.sep) |
| I5 | Oct | 3000 | gl-cor:amount (monthlyTakings.oct) |
| J5 | Nov | 3000 | gl-cor:amount (monthlyTakings.nov) |
| K5 | Dec | 3000 | gl-cor:amount (monthlyTakings.dec) |
| L5 | Jan | 3000 | gl-cor:amount (monthlyTakings.jan) |
| M5 | Feb | 3000 | gl-cor:amount (monthlyTakings.feb) |
| N5 | Mar | 3000 | gl-cor:amount (monthlyTakings.mar) |
| C12 | Apr | 1773.33333333333 | gl-cor:amount (monthlyVehicleCosts.apr) |
| D12 | May | 393.333333333333 | gl-cor:amount (monthlyVehicleCosts.may) |
| E12 | Jun | 393.333333333333 | gl-cor:amount (monthlyVehicleCosts.jun) |
| F12 | Jul | 393.333333333333 | gl-cor:amount (monthlyVehicleCosts.jul) |
| G12 | Aug | 393.333333333333 | gl-cor:amount (monthlyVehicleCosts.aug) |
| H12 | Sep | 393.333333333333 | gl-cor:amount (monthlyVehicleCosts.sep) |
| I12 | Oct | 393.333333333333 | gl-cor:amount (monthlyVehicleCosts.oct) |
| J12 | Nov | 393.333333333333 | gl-cor:amount (monthlyVehicleCosts.nov) |
| K12 | Dec | 393.333333333333 | gl-cor:amount (monthlyVehicleCosts.dec) |
| L12 | Jan | 393.333333333333 | gl-cor:amount (monthlyVehicleCosts.jan) |
| M12 | Feb | 393.333333333333 | gl-cor:amount (monthlyVehicleCosts.feb) |
| N12 | Mar | 393.333333333333 | gl-cor:amount (monthlyVehicleCosts.mar) |
| C22 | Apr | 520 | gl-cor:amount (monthlyRunningCosts.apr) |
| D22 | May | 0 | gl-cor:amount (monthlyRunningCosts.may) |
| E22 | Jun | 0 | gl-cor:amount (monthlyRunningCosts.jun) |
| F22 | Jul | 120 | gl-cor:amount (monthlyRunningCosts.jul) |
| G22 | Aug | 0 | gl-cor:amount (monthlyRunningCosts.aug) |
| H22 | Sep | 0 | gl-cor:amount (monthlyRunningCosts.sep) |
| I22 | Oct | 120 | gl-cor:amount (monthlyRunningCosts.oct) |
| J22 | Nov | 0 | gl-cor:amount (monthlyRunningCosts.nov) |
| K22 | Dec | 0 | gl-cor:amount (monthlyRunningCosts.dec) |
| L22 | Jan | 620 | gl-cor:amount (monthlyRunningCosts.jan) |
| M22 | Feb | 0 | gl-cor:amount (monthlyRunningCosts.feb) |
| N22 | Mar | 0 | gl-cor:amount (monthlyRunningCosts.mar) |
| C24 | Apr | 0 | gl-cor:amount (monthlyOtherIncome.apr) |
| D24 | May | 0 | gl-cor:amount (monthlyOtherIncome.may) |
| E24 | Jun | 0 | gl-cor:amount (monthlyOtherIncome.jun) |
| F24 | Jul | 0 | gl-cor:amount (monthlyOtherIncome.jul) |
| G24 | Aug | 0 | gl-cor:amount (monthlyOtherIncome.aug) |
| H24 | Sep | 500 | gl-cor:amount (monthlyOtherIncome.sep) |
| I24 | Oct | 0 | gl-cor:amount (monthlyOtherIncome.oct) |
| J24 | Nov | 0 | gl-cor:amount (monthlyOtherIncome.nov) |
| K24 | Dec | 0 | gl-cor:amount (monthlyOtherIncome.dec) |
| L24 | Jan | 0 | gl-cor:amount (monthlyOtherIncome.jan) |
| M24 | Feb | 0 | gl-cor:amount (monthlyOtherIncome.feb) |
| N24 | Mar | 0 | gl-cor:amount (monthlyOtherIncome.mar) |
VitalTax
| Cell | DIY Label | Value | diya-gl mapping |
|---|---|---|---|
| C5 | Q1 Turnover | 9045 | gl-cor:amount (vitalTax.q1Turnover) |
| D5 | Q2 Turnover | 9000 | gl-cor:amount (vitalTax.q2Turnover) |
| E5 | Q3 Turnover | 9000 | gl-cor:amount (vitalTax.q3Turnover) |
| F5 | Q4 Turnover | 9000 | gl-cor:amount (vitalTax.q4Turnover) |
| G5 | Annual Turnover | 36045 | gl-cor:amount (vitalTax.annualTurnover) |
| C6 | Q1 Other income | 0 | gl-cor:amount (vitalTax.q1OtherIncome) |
| D6 | Q2 Other income | 500 | gl-cor:amount (vitalTax.q2OtherIncome) |
| E6 | Q3 Other income | 0 | gl-cor:amount (vitalTax.q3OtherIncome) |
| F6 | Q4 Other income | 0 | gl-cor:amount (vitalTax.q4OtherIncome) |
| G6 | Annual Other income | 500 | gl-cor:amount (vitalTax.annualOtherIncome) |
| C29 | Q1 Total Allowable Expenses | 3080 | gl-cor:amount (vitalTax.q1Expenses) |
| D29 | Q2 Total Allowable Expenses | 1300 | gl-cor:amount (vitalTax.q2Expenses) |
| E29 | Q3 Total Allowable Expenses | 1300 | gl-cor:amount (vitalTax.q3Expenses) |
| F29 | Q4 Total Allowable Expenses | 1800 | gl-cor:amount (vitalTax.q4Expenses) |
| G29 | Annual Total Allowable Expenses | 7480 | gl-cor:amount (vitalTax.annualExpenses) |
SE Short
| Cell | DIY Label | Value | diya-gl mapping |
|---|---|---|---|
| D38 | Turnover (box 9) | 36045 | gl-cor:amount (sa103s.turnover) |
| D71 | Net profit/loss (box 21) | 29685 | gl-cor:amount (sa103s.netProfit) |
| O71 | Net loss (box 22) | 0 | gl-cor:amount (sa103s.netLoss) |
| D80 | Annual investment allowance (box 23) | 0 | tax.capitalAllowances.aia (sa103s) |
| D85 | Small-balance allowance (box 24) | 0 | tax.capitalAllowances.smallPool (sa103s) |
| O80 | Other capital allowances (box 25) | 1120 | tax.capitalAllowances.wda (sa103s) |
| O85 | Balancing charges (box 26) | 0 | tax.capitalAllowances.balancingCharge (sa103s) |
| D94 | Goods and services for own use (box 27) | 0 | gl-cor:amount (sa103s.ownUse) |
| D99 | Net business profit (box 28) | 28565 | gl-cor:amount (sa103s.taxableProfit) |
| O94 | Loss brought forward (box 29) | 0 | gl-cor:amount (sa103s.lossBroughtForward) |
| O99 | Other business income (box 30) | 500 | gl-cor:amount (sa103s.otherBusinessIncome) |
| D106 | Net profit for tax calc (box 31) | 29065 | gl-cor:amount (sa103s.profitForTax) |
Draft Tax calculation
| Cell | DIY Label | Value | diya-gl mapping |
|---|---|---|---|
| E5 | Profit from Self Employment | 29065 | gl-cor:amount (profitSE) |
| E6 | Less: Personal Allowance | 12570 | tax.incomeTax.personalAllowance |
| E7 | Taxable Income | 16495 | gl-cor:amount (taxableIncome) |
| D8 | Basic rate the sheet applies | 0.2 | tax.incomeTax.basicRate (applied) |
| C9 | Basic band ceiling the sheet applies | 37700 | tax.incomeTax.basicRateLimit (applied) |
| D9 | Higher rate the sheet applies | 0.4 | tax.incomeTax.higherRate (applied) |
| C10 | Additional rate threshold the sheet applies | 125140 | tax.incomeTax.higherRateThreshold (applied) |
| D10 | Additional rate the sheet applies | 0.45 | tax.incomeTax.additionalRate (applied) |
| E8 | Tax at Basic Rate | 3299 | tax.incomeTax.basicRate |
| E9 | Tax at Higher Rate | 0 | tax.incomeTax.higherRate |
| E10 | Tax at Additional Rate | 0 | tax.incomeTax.additionalRate |
| E11 | Total Income Tax | 3299 | tax.incomeTax (total) |
| E14 | NI Class 4 (lower band) | 989.7 | tax.nationalInsurance.class4MainRate |
| E15 | NI Class 4 (upper band) | 0 | tax.nationalInsurance.class4UpperRate |
| E17 | Total Tax + NI | 4288.7 | gl-cor:taxAmount (totalTaxNI) |
| E25 | First payment on account (31 January) | 2144.35 | gl-cor:taxAmount (paymentOnAccount1) |
| E26 | Second payment on account (31 July) | 2144.35 | gl-cor:taxAmount (paymentOnAccount2) |
Wages Forecast
| Cell | DIY Label | Value | diya-gl mapping |
|---|---|---|---|
| C19 | Months of actual trade | 12 | gl-cor:amount (forecast.monthsTraded) |
| C20 | Forecast Sales Turnover | 36045 | gl-cor:amount (forecast.turnover) |
| C22 | Forecast Investment Grants | 500 | gl-cor:amount (forecast.otherIncome) |
| C24 | Forecast Cost of Sales | 6100 | gl-cor:amount (forecast.costOfSales) |
| C28 | Forecast General Expenses | 1380 | gl-cor:amount (forecast.expenses) |
| C30 | Forecast Profit before Tax | 29065 | gl-cor:amount (forecast.profit) |
| C34 | Profit before Tax | 29065 | gl-cor:amount (forecast.taxableProfit) |
| C35 | Personal Allowance | 12570 | tax.incomeTax.personalAllowance |
| C36 | Profit after Allowance | 16495 | gl-cor:amount (forecast.taxableIncome) |
| C37 | Tax at standard rate | 3299 | tax.incomeTax.basicRate |
| C38 | Tax at higher rate | 0 | tax.incomeTax.higherRate |
| C39 | Tax at additional rate | 0 | tax.incomeTax.additionalRate |
| C40 | National Insurance | 989.7 | tax.nationalInsurance.class4 |
| C41 | Forecast Tax & NI Liability | 4288.7 | gl-cor:taxAmount (forecast.totalTaxNI) |
PurchasesMar
| Cell | DIY Label | Value | diya-gl mapping |
|---|---|---|---|
| A1 | Business miles for the year | 0 | gl-bus:measurableQuantity (miles) |
| A2 | Mileage claimed for the year | 0 | tax.mileage (claim) |
| I2 | Vehicle running costs for the year | 4980 | accounts.purchases (vehicleRunningCosts) |
| T1 | Vehicle purchases capitalised | 8000 | fixedAssets (purchased, year total) |
Fixed Assets
| Cell | DIY Label | Value | diya-gl mapping |
|---|---|---|---|
| D47 | New Asset Cost (Vehicle under £12,000) | 8000 | fixedAssets[0].cost |
| I1 | Total Annual Investment Allowance | 0 | tax.capitalAllowances.aia (schedule) |
| J1 | Total Writing Down Allowance | 1120 | tax.capitalAllowances.wda (schedule) |
| P1 | Total Capital Allowance on Disposal | 0 | tax.capitalAllowances.disposals (schedule) |
| Q1 | Total Balancing Charge | 0 | tax.capitalAllowances.balancingCharge (schedule) |
| K1 | Written-down value carried forward | 6880 | fixedAssets (writtenDownValue) |
Admin
| Cell | DIY Label | Value | diya-gl mapping |
|---|---|---|---|
| N4 | Personal Allowance | 12570 | tax.incomeTax.personalAllowance |
| N5 | Personal Allowance Taper Threshold | 100000 | tax.incomeTax.personalAllowanceTaperThreshold |
| N6 | Basic Rate | 0.2 | tax.incomeTax.basicRate |
| N7 | Higher Rate | 0.4 | tax.incomeTax.higherRate |
| N8 | Additional Rate | 0.45 | tax.incomeTax.additionalRate |
| M11 | Basic Band End | 37700 | tax.incomeTax.basicRateLimit |
| N12 | Higher Band Start | 37701 | tax.incomeTax.basicRateLimit (+1) |
| N13 | Higher Band End | 125140 | tax.incomeTax.additionalRateThreshold |
| L16 | NI Class 2 Weekly Rate | 3.65 | tax.nationalInsurance.class2WeeklyRate |
| N16 | NI Class 2 Small Profits Threshold | 7105 | tax.nationalInsurance.class2SmallProfitsThreshold |
| L20 | NI Class 4 Lower Rate | 0.06 | tax.nationalInsurance.class4MainRate |
| N20 | NI Class 4 Lower Limit | 12570 | tax.nationalInsurance.class4LowerProfits |
| L23 | NI Class 4 Upper Rate | 0.02 | tax.nationalInsurance.class4UpperRate |
| N23 | NI Class 4 Upper Limit | 50270 | tax.nationalInsurance.class4UpperProfits |
| G4 | Annual Investment Allowance Rate | 1 | tax.capitalAllowances.annualInvestmentAllowance |
| G5 | Writing Down Allowance Rate | 0.14 | tax.capitalAllowances.mainRateWDA |
| F21 | Mileage Higher Rate Limit | 10000 | tax.mileage.higherRateLimit |
| G21 | Mileage Higher Rate Pence | 0.45 | tax.mileage.carFirst10000 |
| F22 | Mileage Lower Rate Start | 10001 | tax.mileage.lowerRateStart |
| G22 | Mileage Lower Rate Pence | 0.25 | tax.mileage.carOver10000 |
| F26 | VAT Registration Threshold | 90000 | tax.vat.registrationThreshold |
Tax review
Self Assessment (SA103S)
| Amount | |
|---|---|
| Turnover (box 9) | 36,045 |
| Other business income (box 10) | — |
| Net profit/loss (box 21) | 29,685 |
| Net loss (box 22) | 0 |
| Annual investment allowance (box 23) | 0 |
| Small-balance allowance (box 24) | 0 |
| Other capital allowances (box 25) | 1,120 |
| Balancing charges (box 26) | 0 |
| Goods and services for own use (box 27) | 0 |
| Net business profit (box 28) | 28,565 |
| Loss brought forward (box 29) | 0 |
| Other business income (box 30) | 500 |
| Net profit for tax calc (box 31) | 29,065 |
Draft Tax Calculation
| Amount | |
|---|---|
| Profit from Self Employment | 29,065 |
| Less: Personal Allowance | 12,570 |
| Taxable Income | 16,495 |
| Basic rate the sheet applies | 0.2 |
| Basic band ceiling the sheet applies | 37,700 |
| Higher rate the sheet applies | 0.4 |
| Additional rate threshold the sheet applies | 125,140 |
| Additional rate the sheet applies | 0.45 |
| Tax at Basic Rate | 3,299 |
| Tax at Higher Rate | 0 |
| Tax at Additional Rate | 0 |
| Total Income Tax | 3,299 |
| NI Class 4 (lower band) | 989.7 |
| NI Class 4 (upper band) | 0 |
| Total Tax + NI | 4,288.7 |
| First payment on account (31 January) | 2,144.35 |
| Second payment on account (31 July) | 2,144.35 |