DIY Accounting Spreadsheets

Excel bookkeeping and accounting software for UK small businesses

Self Employed reconciliation

Reconciliation Report: GB Accounts Self Employed 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.

SE-scoped extract from Precision Code Ltd master data. Sales + purchases + bank + payroll, with VAT.

Trade: IT consultancy and software development

Summary

Plausibility review: pass

Indicators are consistent with the headline: VAT-registered with all four quarters carrying VAT, turnover net of the 15,000 disposals at the headline scale, capital allowances explaining the lower taxable profit, tax charged on the profit plus grants, and a zero-residue bridge. Only minor items worth a glance.

  • SA103S net profit 183,429.68 vs profit before tax 171,773.02 (Turnover/profit indicator and self assessment indicator): The two profit figures differ by 11,656.66 with no stated bridging item; worth a glance though the deterministic checks and the zero-residue bridge pass. [note]
  • Personal allowance 1,813.49 (Income tax indicator): Unusually small tapered allowance for income of ~121.5k (full taper would normally exhaust it); plausible but worth a look. [note]

Read back by anthropic.claude-opus-5, 2026-09-06. The arithmetic checks below run first and decide the status.

Every run

Year endPeriodScenarioStatus
2027-04-05Apr27se-brickwork-pro-nonvatRECONCILES
2027-04-05Apr27se-brickwork-pro-vatRECONCILES
2027-04-05Apr27se-scenario-advancedRECONCILES
2026-04-05Apr26se-scenario-advancedRECONCILES
2025-04-05Apr25se-scenario-advancedRECONCILES
2024-04-05Apr24se-scenario-advancedRECONCILES
2023-04-05Apr23se-scenario-advancedRECONCILES
2022-04-05Apr22se-scenario-advancedRECONCILES
2021-04-05Apr21se-scenario-advancedRECONCILES

Reconciliation checks

CheckExpectedActualDiffResult
Sales.xlsx Apr: VAT rate charged (H2)20200PASS
Purchases.xlsx Apr: VAT rate charged (H2)20200PASS
Sales.xlsx May: VAT rate charged (H2)20200PASS
Purchases.xlsx May: VAT rate charged (H2)20200PASS
Sales.xlsx Jun: VAT rate charged (H2)20200PASS
Purchases.xlsx Jun: VAT rate charged (H2)20200PASS
Sales.xlsx Jul: VAT rate charged (H2)20200PASS
Purchases.xlsx Jul: VAT rate charged (H2)20200PASS
Sales.xlsx Aug: VAT rate charged (H2)20200PASS
Purchases.xlsx Aug: VAT rate charged (H2)20200PASS
Sales.xlsx Sep: VAT rate charged (H2)20200PASS
Purchases.xlsx Sep: VAT rate charged (H2)20200PASS
Sales.xlsx Oct: VAT rate charged (H2)20200PASS
Purchases.xlsx Oct: VAT rate charged (H2)20200PASS
Sales.xlsx Nov: VAT rate charged (H2)20200PASS
Purchases.xlsx Nov: VAT rate charged (H2)20200PASS
Sales.xlsx Dec: VAT rate charged (H2)20200PASS
Purchases.xlsx Dec: VAT rate charged (H2)20200PASS
Sales.xlsx Jan: VAT rate charged (H2)20200PASS
Purchases.xlsx Jan: VAT rate charged (H2)20200PASS
Sales.xlsx Feb: VAT rate charged (H2)20200PASS
Purchases.xlsx Feb: VAT rate charged (H2)20200PASS
Sales.xlsx Mar: VAT rate charged (H2)20200PASS
Purchases.xlsx Mar: VAT rate charged (H2)20200PASS
Total Sales3392003392000PASS
P&L: Gross = Turnover + Grants - CoS321146.6666666666321146.666666666-6.402842700481415e-10PASS
P&L: Operating = Gross - Admin171773.016666666171773.0166666660PASS
P&L: PBT = Operating171773.016666666171773.0166666660PASS
P&L: Admin lines sum = Total149373.64999999994149373.65+5.820766091346741e-11PASS
VitalTax: annual product sales = P&L Products A+B+C3355003355000PASS
VitalTax: annual direct costs = P&L Materials + Other Direct Costs13470134700PASS
Motor Expenses6434.256434.250PASS
Legal & Professional692569250PASS
Purchases: business miles pooled for the year136513650PASS
Purchases: mileage claimed = those miles at the tax year's approved rates614.25614.250PASS
P&L: Motor Expenses = motoring paid for + the mileage claimed6434.256434.250PASS
Stock: opening count10000100000PASS
Stock: count at the year end600060000PASS
P&L: materials = stock purchases net + the year's stock movement945094500PASS
Opening Debtors total10800108000PASS
Closing Debtors total790079000PASS
Opening Creditors total222022200PASS
Closing Creditors total171017100PASS
Income Tax40339.809999999640339.8099999998+2.0372681319713593e-10PASS
NI Class 4 (lower)226222620PASS
Total Tax + NI, less the CIS already deducted44026.6703333329244026.6703333331+1.8189894035458565e-10PASS
Tax: Personal allowance after taper1813.49166666700331813.49166666687-1.3324097380973399e-10PASS
Tax at additional rate000PASS
Tax: sheet splits the basic and higher bands at the basic band end37700377000PASS
Tax: sheet splits the higher and additional bands at the higher band end1251401251400PASS
Tax: sheet applies the additional rate above the higher band0.450.450PASS
Tax: Taxable = Profit - Allowance119699.52499999912119699.524999999-1.1641532182693481e-10PASS
Tax: IT = Basic + Higher + Additional40339.809999999840339.80999999980PASS
Tax: Total = IT + CIS deduction line + NI44026.6703333331344026.6703333331-2.9103830456733704e-11PASS
SA103S: Turnover = P&L Sales3392003392000PASS
SA103S: total expenses = cost of sales + admin expenses less depreciation155770.3166666667155770.316666667+2.9103830456733704e-10PASS
SA103S: net profit = turnover + other business income - total expenses183429.683333333183429.6833333330PASS
SA103S: net loss = total expenses - turnover - other business income000PASS
SA103S: Profit for tax = Income Tax E5121513.016666666121513.0166666660PASS
SA103S: Capital allowances (AIA/FYA) = Schedule Q152500525000PASS
Forecast: months of actual trade = P&L months with turnover12120PASS
Forecast: turnover = P&L turnover3392003392000PASS
Forecast: investment grants = P&L investment grants2083.333333333332083.333333333330PASS
Forecast: cost of sales = P&L cost of sales20136.666666666720136.66666666670PASS
Forecast: general expenses = P&L administrative expenses149373.65149373.650PASS
Forecast: interest received = P&L interest received000PASS
Forecast: profit before tax = P&L profit before tax171773.016666666171773.0166666660PASS
Forecast: depreciation added back = P&L disposal loss + depreciation13912139120PASS
Forecast: capital allowances = the fixed asset schedule64000640000PASS
Forecast: taxable profit = profit + depreciation - capital allowances121685.016666666121685.0166666660PASS
Forecast: personal allowance after taper1727.49166666700331727.49166666687-1.3324097380973399e-10PASS
Forecast: tax at standard rate754075400PASS
Forecast: tax at higher rate32903.00999999959532903.0099999998+2.0372681319713593e-10PASS
Forecast: tax at additional rate000PASS
Forecast: National Insurance3690.300333333323690.30033333333+1.000444171950221e-11PASS
Forecast: tax and NI liability44133.3103333329144133.3103333331+1.8917489796876907e-10PASS
SA103F box 15 turnover (D55) = the profit and loss account3392003392000PASS
SA103F box 16 other business income (O55) = the profit and loss account000PASS
SA103F box 17 goods bought for resale (D66) = the profit and loss account13470134700PASS
SA103F box 18 subcontractor payments (D70) = the profit and loss account6666.666666666676666.666666666670PASS
SA103F box 19 wages, salaries and staff costs (D74) = the profit and loss account92735.733333333392735.73333333330PASS
SA103F box 20 car, van and travel expenses (D78) = the profit and loss account7984.257984.250PASS
SA103F box 21 rent, rates, power and insurance (D82) = the profit and loss account13200132000PASS
SA103F box 22 repairs and maintenance (D86) = the profit and loss account9509500PASS
SA103F box 23 phone, stationery and office costs (D90) = the profit and loss account303530350PASS
SA103F box 24 advertising and entertainment (D94) = the profit and loss account380038000PASS
SA103F box 25 interest on bank and other loans (D98) = the profit and loss account000PASS
SA103F box 26 bank, credit card and finance charges (D102) = the profit and loss account390039000PASS
SA103F box 27 irrecoverable debts written off (D106) = the profit and loss account-300-3000PASS
SA103F box 28 accountancy, legal and professional fees (D110) = the profit and loss account692569250PASS
SA103F box 29 depreciation and loss on sale of assets (D114) = the profit and loss account13912139120PASS
SA103F box 30 other business expenses (D118) = the profit and loss account3231.666666666663231.666666666660PASS
SA103F box 31 total expenses (D122) = the profit and loss account169510.3166666667169510.316666667+2.9103830456733704e-10PASS
SA103F box 44 disallowable depreciation (O114) = the profit and loss account13740137400PASS
SA103F box 46 total disallowable expenses (O122) = the profit and loss account13740137400PASS
SA103F box 75 other business income (O204) = the profit and loss account2083.333333333332083.333333333330PASS
SA103F box 57 total capital allowances (O154) = boxes 49 to 5664000640000PASS
SA103F box 47 net profit (D129) = boxes 15 and 16 less box 31169689.683333333169689.6833333330PASS
SA103F box 61 total additions to net profit (D174) = boxes 46, 59 and 6013740137400PASS
SA103F box 63 total deductions from net profit (O169) = boxes 57 and 6264000640000PASS
SA103F box 64 net business profit for tax purposes (O174) = box 47 or box 48, plus box 61, less box 63119429.683333333119429.6833333330PASS
SA103F box 73 adjusted profit (O194) = box 64119429.683333333119429.6833333330PASS
SA103F box 76 total taxable profits (O210) = box 73 less box 74 plus box 75121513.01666666633121513.016666666-3.346940502524376e-10PASS
SA103F box 49 annual investment allowance (D139) = Schedule Q152500525000PASS
SA103F box 50 capital allowances at 18% (D144) = Schedule R1336033600PASS
SA103F box 55 100% and other enhanced capital allowances (O144) = Schedule S1 while the small pool balance is under £1,000000PASS
SA103F box 56 allowances on sale or cessation (O149) = Schedule Y1814081400PASS
SA103F box 59 balancing charge (O160) = Schedule Z1000PASS
SA103F box 50 capital allowances at 18% (D144) = the scenario's opening tax written-down values at the year's writing down rate3360.00000000000053360-4.547473508864641e-13PASS
SA103F box 51 capital allowances at 6% (D147) is nil000PASS
SA103F box 15 turnover: full return (D55) = short return (D38)3392003392000PASS
SA103F box 16 other business income: full return (O55) = short return (O38)000PASS
SA103F box 19 wages, salaries and staff costs: full return (D74) = short return (D55)92735.733333333392735.73333333330PASS
SA103F box 20 car, van and travel expenses: full return (D78) = short return (D51)7984.257984.250PASS
SA103F box 21 rent, rates, power and insurance: full return (D82) = short return (D60)13200132000PASS
SA103F box 22 repairs and maintenance: full return (D86) = short return (D64)9509500PASS
SA103F box 23 phone, stationery and office costs: full return (D90) = short return (O55)303530350PASS
SA103F box 28 accountancy, legal and professional fees: full return (D110) = short return (O46)692569250PASS
SA103F box 48 net loss: full return (O129) = short return (O71)000PASS
SA103F box 49 annual investment allowance: full return (D139) = short return (D80)52500525000PASS
SA103F box 55 100% and other enhanced capital allowances: full return (O144) = short return (D85)000PASS
SA103F box 59 balancing charge: full return (O160) = short return (O85)000PASS
SA103F box 60 goods and services for own use: full return (D169) = short return (D94)000PASS
SA103F box 64 net business profit for tax purposes: full return (O174) = short return (D99)119429.683333333119429.6833333330PASS
SA103F box 65 net business loss for tax purposes: full return (O179) = short return (O106)000PASS
SA103F box 74 loss brought forward set against this year: full return (O199) = short return (O94)000PASS
SA103F box 75 other business income: full return (O204) = short return (O99)2083.333333333332083.333333333330PASS
SA103F box 76 total taxable profits: full return (O210) = short return (D106)121513.016666666121513.0166666660PASS
SA103F box 81 contractor deductions taken off: full return (D231) = short return (O124)000PASS
SA103F box 31 total expenses (D122) = the short return's total expenses with box 46 disallowable depreciation added back169510.316666667169510.3166666670PASS
SA103F box 47 net profit (D129) = the short return's net profit less box 46 disallowable depreciation169689.683333333169689.6833333330PASS
SA103F box 57 total capital allowances (O154) = the short return's allowance boxes 23, 24 and 2564000640000PASS
SA103F: the period the return covers starts on the Admin tax year start (Q2 = B4)46118461180PASS
SA103F: the period the return covers ends on the Admin tax year end (V2 = B17)46482464820PASS
SA103F: the writing down allowance rate the return prints (G141) = the Admin rate (G5)0.140.140PASS
SA103F: the Class 4 threshold the return prints (J280) = the Admin Class 4 lower limit (N20)12570125700PASS
SA103F: the online filing deadline banner (G1) names 31 January the year after the tax year endsCOPY DETAILS TO HMRC FORM Submit HMRC RETURN ONLINE by 31st January 2028COPY DETAILS TO HMRC FORM Submit HMRC RETURN ONLINE by 31st January 2028PASS
Fixed assets: Schedule new-asset additions = Purchases.xlsx fixed asset total52500525000PASS
Fixed assets: Schedule disposals = Sales.xlsx fixed asset sales total12500125000PASS
Fixed assets: Schedule new-asset additions (FAreconciliation E11) = scenario fa-coded net total52500525000PASS
Fixed assets: Schedule disposals (FAreconciliation K11) = scenario fs-coded net total12500125000PASS
Fixed assets: closing NBV = cost less disposals, less depreciation carried forward less depreciation on disposals48990489900PASS
Fixed assets: Schedule total cost = existing assets plus assets bought in the year85500855000PASS
P&L: Depreciation (row 34, summed) = Schedule I113740137400PASS
P&L: Loss on disposal (row 33, summed) = Schedule -(V1-W1+X1)172171.99999999999966-3.410605131648481e-13PASS
HP: first agreement monthly payment = the amount financed with charges over its term7507500PASS
HP: first agreement capital and interest split sums to the monthly payment7507500PASS
HP: second agreement monthly payment computes4054050PASS
HP: second agreement capital and interest split sums to the monthly payment4054050PASS
HP: long term creditors = the agreements' amounts financed20000200000PASS
P&L: HP interest and charges reach the finance line (B31)390039000PASS
Bank.xlsx closing balance (Mar!A2)181215.43181215.430PASS
Cash.xlsx closing balance (Mar!A2)4804800PASS
P&L apr col C5 = Sales.xlsx a-coded net25333.3325333.3333333333+0.0033333332976326346PASS
P&L apr col C6 = Sales.xlsx b-coded net180018000PASS
P&L apr col C7 = Sales.xlsx c-coded net000PASS
P&L apr col C8 = Sales.xlsx d-coded net7007000PASS
P&L apr col C11 = Sales.xlsx g-coded net000PASS
P&L apr col C29 = -(Sales.xlsx o-coded net)000PASS
P&L may col D5 = Sales.xlsx a-coded net25633.3325633.3333333333+0.0033333332976326346PASS
P&L may col D6 = Sales.xlsx b-coded net8008000PASS
P&L may col D7 = Sales.xlsx c-coded net100010000PASS
P&L may col D8 = Sales.xlsx d-coded net000PASS
P&L may col D11 = Sales.xlsx g-coded net000PASS
P&L may col D29 = -(Sales.xlsx o-coded net)000PASS
P&L jun col E5 = Sales.xlsx a-coded net26533.3326533.3333333333+0.0033333332976326346PASS
P&L jun col E6 = Sales.xlsx b-coded net8008000PASS
P&L jun col E7 = Sales.xlsx c-coded net200020000PASS
P&L jun col E8 = Sales.xlsx d-coded net000PASS
P&L jun col E11 = Sales.xlsx g-coded net000PASS
P&L jun col E29 = -(Sales.xlsx o-coded net)000PASS
P&L jul col F5 = Sales.xlsx a-coded net25633.3325633.3333333333+0.0033333332976326346PASS
P&L jul col F6 = Sales.xlsx b-coded net180018000PASS
P&L jul col F7 = Sales.xlsx c-coded net000PASS
P&L jul col F8 = Sales.xlsx d-coded net7007000PASS
P&L jul col F11 = Sales.xlsx g-coded net000PASS
P&L jul col F29 = -(Sales.xlsx o-coded net)000PASS
P&L aug col G5 = Sales.xlsx a-coded net27133.3327133.3333333333+0.0033333332976326346PASS
P&L aug col G6 = Sales.xlsx b-coded net8008000PASS
P&L aug col G7 = Sales.xlsx c-coded net000PASS
P&L aug col G8 = Sales.xlsx d-coded net000PASS
P&L aug col G11 = Sales.xlsx g-coded net2083.332083.33333333333+0.0033333333299196966PASS
P&L aug col G29 = -(Sales.xlsx o-coded net)000PASS
P&L sep col H5 = Sales.xlsx a-coded net25033.3325033.3333333333+0.0033333332976326346PASS
P&L sep col H6 = Sales.xlsx b-coded net8008000PASS
P&L sep col H7 = Sales.xlsx c-coded net180018000PASS
P&L sep col H8 = Sales.xlsx d-coded net5005000PASS
P&L sep col H11 = Sales.xlsx g-coded net000PASS
P&L sep col H29 = -(Sales.xlsx o-coded net)000PASS
P&L oct col I5 = Sales.xlsx a-coded net27133.3327133.3333333333+0.0033333332976326346PASS
P&L oct col I6 = Sales.xlsx b-coded net180018000PASS
P&L oct col I7 = Sales.xlsx c-coded net000PASS
P&L oct col I8 = Sales.xlsx d-coded net7007000PASS
P&L oct col I11 = Sales.xlsx g-coded net000PASS
P&L oct col I29 = -(Sales.xlsx o-coded net)000PASS
P&L nov col J5 = Sales.xlsx a-coded net25633.3325633.3333333333+0.0033333332976326346PASS
P&L nov col J6 = Sales.xlsx b-coded net8008000PASS
P&L nov col J7 = Sales.xlsx c-coded net300030000PASS
P&L nov col J8 = Sales.xlsx d-coded net000PASS
P&L nov col J11 = Sales.xlsx g-coded net000PASS
P&L nov col J29 = -(Sales.xlsx o-coded net)000PASS
P&L dec col K5 = Sales.xlsx a-coded net26533.3326533.3333333333+0.0033333332976326346PASS
P&L dec col K6 = Sales.xlsx b-coded net8008000PASS
P&L dec col K7 = Sales.xlsx c-coded net000PASS
P&L dec col K8 = Sales.xlsx d-coded net000PASS
P&L dec col K11 = Sales.xlsx g-coded net000PASS
P&L dec col K29 = -(Sales.xlsx o-coded net)000PASS
P&L jan col L5 = Sales.xlsx a-coded net25633.3325633.3333333333+0.0033333332976326346PASS
P&L jan col L6 = Sales.xlsx b-coded net180018000PASS
P&L jan col L7 = Sales.xlsx c-coded net100010000PASS
P&L jan col L8 = Sales.xlsx d-coded net110011000PASS
P&L jan col L11 = Sales.xlsx g-coded net000PASS
P&L jan col L29 = -(Sales.xlsx o-coded net)000PASS
P&L feb col M5 = Sales.xlsx a-coded net26333.3326333.3333333333+0.0033333332976326346PASS
P&L feb col M6 = Sales.xlsx b-coded net8008000PASS
P&L feb col M7 = Sales.xlsx c-coded net150015000PASS
P&L feb col M8 = Sales.xlsx d-coded net000PASS
P&L feb col M11 = Sales.xlsx g-coded net000PASS
P&L feb col M29 = -(Sales.xlsx o-coded net)000PASS
P&L mar col N5 = Sales.xlsx a-coded net25033.3325033.3333333333+0.0033333332976326346PASS
P&L mar col N6 = Sales.xlsx b-coded net8008000PASS
P&L mar col N7 = Sales.xlsx c-coded net000PASS
P&L mar col N8 = Sales.xlsx d-coded net000PASS
P&L mar col N11 = Sales.xlsx g-coded net000PASS
P&L mar col N29 = -(Sales.xlsx o-coded net)-300-3000PASS
P&L apr col C15 = Purchases.xlsx c-coded net000PASS
P&L apr col C16 = Purchases.xlsx o-coded net237.5237.50PASS
P&L apr col C22 = Purchases.xlsx p-coded net100010000PASS
P&L apr col C23 = Purchases.xlsx m-coded net1001000PASS
P&L apr col C24 = Purchases.xlsx g-coded net262.5262.50PASS
P&L apr col C25 = Purchases.xlsx v-coded net508.25508.250PASS
P&L apr col C26 = Purchases.xlsx h-coded net76.6776.6666666666667-0.00333333333330188PASS
P&L apr col C27 = Purchases.xlsx a-coded net000PASS
P&L apr col C28 = Purchases.xlsx l-coded net2502500PASS
P&L apr col C32 = Purchases.xlsx y-coded net1330.831330.83333333333+0.0033333333301470702PASS
P&L may col D15 = Purchases.xlsx c-coded net000PASS
P&L may col D16 = Purchases.xlsx o-coded net407.5407.50PASS
P&L may col D22 = Purchases.xlsx p-coded net100010000PASS
P&L may col D23 = Purchases.xlsx m-coded net000PASS
P&L may col D24 = Purchases.xlsx g-coded net277.5277.50PASS
P&L may col D25 = Purchases.xlsx v-coded net5645640PASS
P&L may col D26 = Purchases.xlsx h-coded net126.67126.666666666667-0.003333333333003452PASS
P&L may col D27 = Purchases.xlsx a-coded net5005000PASS
P&L may col D28 = Purchases.xlsx l-coded net2502500PASS
P&L may col D32 = Purchases.xlsx y-coded net95.8395.8333333333333+0.00333333333330188PASS
P&L jun col E15 = Purchases.xlsx c-coded net4166.674166.66666666667-0.003333333330374444PASS
P&L jun col E16 = Purchases.xlsx o-coded net237.5237.50PASS
P&L jun col E22 = Purchases.xlsx p-coded net130013000PASS
P&L jun col E23 = Purchases.xlsx m-coded net000PASS
P&L jun col E24 = Purchases.xlsx g-coded net192.5192.50PASS
P&L jun col E25 = Purchases.xlsx v-coded net5605600PASS
P&L jun col E26 = Purchases.xlsx h-coded net226.67226.666666666667-0.003333333332989241PASS
P&L jun col E27 = Purchases.xlsx a-coded net000PASS
P&L jun col E28 = Purchases.xlsx l-coded net458.33458.333333333333+0.003333333332989241PASS
P&L jun col E32 = Purchases.xlsx y-coded net120.83120.833333333333+0.003333333333003452PASS
P&L jul col F15 = Purchases.xlsx c-coded net000PASS
P&L jul col F16 = Purchases.xlsx o-coded net607.5607.50PASS
P&L jul col F22 = Purchases.xlsx p-coded net100010000PASS
P&L jul col F23 = Purchases.xlsx m-coded net1501500PASS
P&L jul col F24 = Purchases.xlsx g-coded net382.5382.50PASS
P&L jul col F25 = Purchases.xlsx v-coded net490.25490.250PASS
P&L jul col F26 = Purchases.xlsx h-coded net76.6776.6666666666667-0.00333333333330188PASS
P&L jul col F27 = Purchases.xlsx a-coded net4004000PASS
P&L jul col F28 = Purchases.xlsx l-coded net275027500PASS
P&L jul col F32 = Purchases.xlsx y-coded net95.8395.8333333333333+0.00333333333330188PASS
P&L aug col G15 = Purchases.xlsx c-coded net000PASS
P&L aug col G16 = Purchases.xlsx o-coded net237.5237.50PASS
P&L aug col G22 = Purchases.xlsx p-coded net100010000PASS
P&L aug col G23 = Purchases.xlsx m-coded net2002000PASS
P&L aug col G24 = Purchases.xlsx g-coded net112.5112.50PASS
P&L aug col G25 = Purchases.xlsx v-coded net508.25508.250PASS
P&L aug col G26 = Purchases.xlsx h-coded net116.67116.666666666667-0.003333333333003452PASS
P&L aug col G27 = Purchases.xlsx a-coded net000PASS
P&L aug col G28 = Purchases.xlsx l-coded net2502500PASS
P&L aug col G32 = Purchases.xlsx y-coded net135.83135.833333333333+0.003333333332989241PASS
P&L sep col H15 = Purchases.xlsx c-coded net000PASS
P&L sep col H16 = Purchases.xlsx o-coded net507.5507.50PASS
P&L sep col H22 = Purchases.xlsx p-coded net125012500PASS
P&L sep col H23 = Purchases.xlsx m-coded net000PASS
P&L sep col H24 = Purchases.xlsx g-coded net202.5202.50PASS
P&L sep col H25 = Purchases.xlsx v-coded net6026020PASS
P&L sep col H26 = Purchases.xlsx h-coded net76.6776.6666666666667-0.00333333333330188PASS
P&L sep col H27 = Purchases.xlsx a-coded net000PASS
P&L sep col H28 = Purchases.xlsx l-coded net1223.331223.33333333333+0.0033333333301470702PASS
P&L sep col H32 = Purchases.xlsx y-coded net95.8395.8333333333333+0.00333333333330188PASS
P&L oct col I15 = Purchases.xlsx c-coded net000PASS
P&L oct col I16 = Purchases.xlsx o-coded net237.5237.50PASS
P&L oct col I22 = Purchases.xlsx p-coded net100010000PASS
P&L oct col I23 = Purchases.xlsx m-coded net80800PASS
P&L oct col I24 = Purchases.xlsx g-coded net262.5262.50PASS
P&L oct col I25 = Purchases.xlsx v-coded net512.75512.750PASS
P&L oct col I26 = Purchases.xlsx h-coded net176.67176.666666666667-0.003333333332989241PASS
P&L oct col I27 = Purchases.xlsx a-coded net250025000PASS
P&L oct col I28 = Purchases.xlsx l-coded net2502500PASS
P&L oct col I32 = Purchases.xlsx y-coded net425.83425.833333333333+0.003333333332989241PASS
P&L nov col J15 = Purchases.xlsx c-coded net250025000PASS
P&L nov col J16 = Purchases.xlsx o-coded net207.5207.50PASS
P&L nov col J22 = Purchases.xlsx p-coded net100010000PASS
P&L nov col J23 = Purchases.xlsx m-coded net000PASS
P&L nov col J24 = Purchases.xlsx g-coded net337.5337.50PASS
P&L nov col J25 = Purchases.xlsx v-coded net5515510PASS
P&L nov col J26 = Purchases.xlsx h-coded net136.67136.666666666667-0.003333333332989241PASS
P&L nov col J27 = Purchases.xlsx a-coded net000PASS
P&L nov col J28 = Purchases.xlsx l-coded net2502500PASS
P&L nov col J32 = Purchases.xlsx y-coded net95.8395.8333333333333+0.00333333333330188PASS
P&L dec col K15 = Purchases.xlsx c-coded net000PASS
P&L dec col K16 = Purchases.xlsx o-coded net237.5237.50PASS
P&L dec col K22 = Purchases.xlsx p-coded net135013500PASS
P&L dec col K23 = Purchases.xlsx m-coded net000PASS
P&L dec col K24 = Purchases.xlsx g-coded net212.5212.50PASS
P&L dec col K25 = Purchases.xlsx v-coded net519.5519.50PASS
P&L dec col K26 = Purchases.xlsx h-coded net76.6776.6666666666667-0.00333333333330188PASS
P&L dec col K27 = Purchases.xlsx a-coded net000PASS
P&L dec col K28 = Purchases.xlsx l-coded net389.17389.166666666667-0.003333333332989241PASS
P&L dec col K32 = Purchases.xlsx y-coded net532.5532.50PASS
P&L jan col L15 = Purchases.xlsx c-coded net000PASS
P&L jan col L16 = Purchases.xlsx o-coded net357.5357.50PASS
P&L jan col L22 = Purchases.xlsx p-coded net100010000PASS
P&L jan col L23 = Purchases.xlsx m-coded net1201200PASS
P&L jan col L24 = Purchases.xlsx g-coded net427.5427.50PASS
P&L jan col L25 = Purchases.xlsx v-coded net538.25538.250PASS
P&L jan col L26 = Purchases.xlsx h-coded net76.6776.6666666666667-0.00333333333330188PASS
P&L jan col L27 = Purchases.xlsx a-coded net4004000PASS
P&L jan col L28 = Purchases.xlsx l-coded net2502500PASS
P&L jan col L32 = Purchases.xlsx y-coded net95.8395.8333333333333+0.00333333333330188PASS
P&L feb col M15 = Purchases.xlsx c-coded net000PASS
P&L feb col M16 = Purchases.xlsx o-coded net537.5537.50PASS
P&L feb col M22 = Purchases.xlsx p-coded net100010000PASS
P&L feb col M23 = Purchases.xlsx m-coded net3003000PASS
P&L feb col M24 = Purchases.xlsx g-coded net112.5112.50PASS
P&L feb col M25 = Purchases.xlsx v-coded net501.5501.50PASS
P&L feb col M26 = Purchases.xlsx h-coded net306.67306.666666666667-0.003333333332989241PASS
P&L feb col M27 = Purchases.xlsx a-coded net000PASS
P&L feb col M28 = Purchases.xlsx l-coded net2502500PASS
P&L feb col M32 = Purchases.xlsx y-coded net110.83110.833333333333+0.003333333333003452PASS
P&L mar col N15 = Purchases.xlsx c-coded net000PASS
P&L mar col N16 = Purchases.xlsx o-coded net207.5207.50PASS
P&L mar col N22 = Purchases.xlsx p-coded net130013000PASS
P&L mar col N23 = Purchases.xlsx m-coded net000PASS
P&L mar col N24 = Purchases.xlsx g-coded net252.5252.50PASS
P&L mar col N25 = Purchases.xlsx v-coded net578.5578.50PASS
P&L mar col N26 = Purchases.xlsx h-coded net76.6776.6666666666667-0.00333333333330188PASS
P&L mar col N27 = Purchases.xlsx a-coded net000PASS
P&L mar col N28 = Purchases.xlsx l-coded net354.17354.166666666667-0.003333333332989241PASS
P&L mar col N32 = Purchases.xlsx y-coded net95.8395.8333333333333+0.00333333333330188PASS
Purchases.xlsx Apr: CIS tax withheld reaches the certificates column (AD1)000PASS
Purchases.xlsx Apr: the month's expense analysis balances (A1)000PASS
Purchases.xlsx May: CIS tax withheld reaches the certificates column (AD1)000PASS
Purchases.xlsx May: the month's expense analysis balances (A1)000PASS
Purchases.xlsx Jun: CIS tax withheld reaches the certificates column (AD1)100010000PASS
Purchases.xlsx Jun: the month's expense analysis balances (A1)000PASS
Purchases.xlsx Jul: CIS tax withheld reaches the certificates column (AD1)000PASS
Purchases.xlsx Jul: the month's expense analysis balances (A1)000PASS
Purchases.xlsx Aug: CIS tax withheld reaches the certificates column (AD1)000PASS
Purchases.xlsx Aug: the month's expense analysis balances (A1)000PASS
Purchases.xlsx Sep: CIS tax withheld reaches the certificates column (AD1)000PASS
Purchases.xlsx Sep: the month's expense analysis balances (A1)000PASS
Purchases.xlsx Oct: CIS tax withheld reaches the certificates column (AD1)000PASS
Purchases.xlsx Oct: the month's expense analysis balances (A1)000PASS
Purchases.xlsx Nov: CIS tax withheld reaches the certificates column (AD1)6006000PASS
Purchases.xlsx Nov: the month's expense analysis balances (A1)000PASS
Purchases.xlsx Dec: CIS tax withheld reaches the certificates column (AD1)000PASS
Purchases.xlsx Dec: the month's expense analysis balances (A1)000PASS
Purchases.xlsx Jan: CIS tax withheld reaches the certificates column (AD1)000PASS
Purchases.xlsx Jan: the month's expense analysis balances (A1)000PASS
Purchases.xlsx Feb: CIS tax withheld reaches the certificates column (AD1)000PASS
Purchases.xlsx Feb: the month's expense analysis balances (A1)000PASS
Purchases.xlsx Mar: CIS tax withheld reaches the certificates column (AD1)000PASS
Purchases.xlsx Mar: the month's expense analysis balances (A1)000PASS
Sales.xlsx Apr: CIS suffered reaches the sub-contractor column (W1)000PASS
Sales.xlsx Apr: CIS suffered for the year to date (X1)000PASS
Sales.xlsx May: CIS suffered reaches the sub-contractor column (W1)000PASS
Sales.xlsx May: CIS suffered for the year to date (X1)000PASS
Sales.xlsx Jun: CIS suffered reaches the sub-contractor column (W1)000PASS
Sales.xlsx Jun: CIS suffered for the year to date (X1)000PASS
Sales.xlsx Jul: CIS suffered reaches the sub-contractor column (W1)000PASS
Sales.xlsx Jul: CIS suffered for the year to date (X1)000PASS
Sales.xlsx Aug: CIS suffered reaches the sub-contractor column (W1)000PASS
Sales.xlsx Aug: CIS suffered for the year to date (X1)000PASS
Sales.xlsx Sep: CIS suffered reaches the sub-contractor column (W1)000PASS
Sales.xlsx Sep: CIS suffered for the year to date (X1)000PASS
Sales.xlsx Oct: CIS suffered reaches the sub-contractor column (W1)000PASS
Sales.xlsx Oct: CIS suffered for the year to date (X1)000PASS
Sales.xlsx Nov: CIS suffered reaches the sub-contractor column (W1)000PASS
Sales.xlsx Nov: CIS suffered for the year to date (X1)000PASS
Sales.xlsx Dec: CIS suffered reaches the sub-contractor column (W1)000PASS
Sales.xlsx Dec: CIS suffered for the year to date (X1)000PASS
Sales.xlsx Jan: CIS suffered reaches the sub-contractor column (W1)000PASS
Sales.xlsx Jan: CIS suffered for the year to date (X1)000PASS
Sales.xlsx Feb: CIS suffered reaches the sub-contractor column (W1)000PASS
Sales.xlsx Feb: CIS suffered for the year to date (X1)000PASS
Sales.xlsx Mar: CIS suffered reaches the sub-contractor column (W1)000PASS
Sales.xlsx Mar: CIS suffered for the year to date (X1)000PASS
Tax: CIS deducted (E12) = the year's CIS suffered on the sales journal000PASS
SA103F box 81 contractor deductions taken off (D231) = the year's CIS suffered on the sales journal000PASS
Wagesinterface apr C4 gross pay674867480PASS
Wagesinterface apr D4 income tax8008000PASS
Wagesinterface apr E4 employee NI2962960PASS
Wagesinterface apr H4 employer NI577.2577.20PASS
Payslips!Payment apr D4 NI due873.2873.20PASS
Payslips!Payment apr E4 income tax due8008000PASS
Payslips!Payment apr I4 total amount payable1673.21673.20PASS
Payslips!Payment D4 NI due is the apr tab's own873.2873.20PASS
Payslips!Payment E4 income tax due is the apr tab's own8008000PASS
Payslips!Payment I4 total payable is the apr tab's own1673.21673.20PASS
Wagesinterface may C5 gross pay674867480PASS
Wagesinterface may D5 income tax8008000PASS
Wagesinterface may E5 employee NI2962960PASS
Wagesinterface may H5 employer NI577.2577.20PASS
Payslips!Payment may D5 NI due873.2873.20PASS
Payslips!Payment may E5 income tax due8008000PASS
Payslips!Payment may I5 total amount payable1673.21673.20PASS
Payslips!Payment D5 NI due is the may tab's own873.2873.20PASS
Payslips!Payment E5 income tax due is the may tab's own8008000PASS
Payslips!Payment I5 total payable is the may tab's own1673.21673.20PASS
Wagesinterface jun C6 gross pay674867480PASS
Wagesinterface jun D6 income tax8008000PASS
Wagesinterface jun E6 employee NI2962960PASS
Wagesinterface jun H6 employer NI577.2577.20PASS
Payslips!Payment jun D6 NI due873.2873.20PASS
Payslips!Payment jun E6 income tax due8008000PASS
Payslips!Payment jun I6 total amount payable1673.21673.20PASS
Payslips!Payment D6 NI due is the jun tab's own873.2873.20PASS
Payslips!Payment E6 income tax due is the jun tab's own8008000PASS
Payslips!Payment I6 total payable is the jun tab's own1673.21673.20PASS
Wagesinterface jul C7 gross pay674867480PASS
Wagesinterface jul D7 income tax8008000PASS
Wagesinterface jul E7 employee NI2962960PASS
Wagesinterface jul H7 employer NI577.2577.20PASS
Payslips!Payment jul D7 NI due873.2873.20PASS
Payslips!Payment jul E7 income tax due8008000PASS
Payslips!Payment jul I7 total amount payable1673.21673.20PASS
Payslips!Payment D7 NI due is the jul tab's own873.2873.20PASS
Payslips!Payment E7 income tax due is the jul tab's own8008000PASS
Payslips!Payment I7 total payable is the jul tab's own1673.21673.20PASS
Wagesinterface aug C8 gross pay674867480PASS
Wagesinterface aug D8 income tax8008000PASS
Wagesinterface aug E8 employee NI2962960PASS
Wagesinterface aug H8 employer NI577.2577.20PASS
Payslips!Payment aug D8 NI due873.2873.20PASS
Payslips!Payment aug E8 income tax due8008000PASS
Payslips!Payment aug I8 total amount payable1673.21673.20PASS
Payslips!Payment D8 NI due is the aug tab's own873.2873.20PASS
Payslips!Payment E8 income tax due is the aug tab's own8008000PASS
Payslips!Payment I8 total payable is the aug tab's own1673.21673.20PASS
Wagesinterface sep C9 gross pay674867480PASS
Wagesinterface sep D9 income tax8008000PASS
Wagesinterface sep E9 employee NI2962960PASS
Wagesinterface sep H9 employer NI577.2577.20PASS
Payslips!Payment sep D9 NI due873.2873.20PASS
Payslips!Payment sep E9 income tax due8008000PASS
Payslips!Payment sep I9 total amount payable1673.21673.20PASS
Payslips!Payment D9 NI due is the sep tab's own873.2873.20PASS
Payslips!Payment E9 income tax due is the sep tab's own8008000PASS
Payslips!Payment I9 total payable is the sep tab's own1673.21673.20PASS
Wagesinterface oct C10 gross pay674867480PASS
Wagesinterface oct D10 income tax8008000PASS
Wagesinterface oct E10 employee NI2962960PASS
Wagesinterface oct H10 employer NI577.2577.20PASS
Payslips!Payment oct D10 NI due873.2873.20PASS
Payslips!Payment oct E10 income tax due8008000PASS
Payslips!Payment oct I10 total amount payable1673.21673.20PASS
Payslips!Payment D10 NI due is the oct tab's own873.2873.20PASS
Payslips!Payment E10 income tax due is the oct tab's own8008000PASS
Payslips!Payment I10 total payable is the oct tab's own1673.21673.20PASS
Wagesinterface nov C11 gross pay674867480PASS
Wagesinterface nov D11 income tax8008000PASS
Wagesinterface nov E11 employee NI2962960PASS
Wagesinterface nov H11 employer NI577.2577.20PASS
Payslips!Payment nov D11 NI due873.2873.20PASS
Payslips!Payment nov E11 income tax due8008000PASS
Payslips!Payment nov I11 total amount payable1673.21673.20PASS
Payslips!Payment D11 NI due is the nov tab's own873.2873.20PASS
Payslips!Payment E11 income tax due is the nov tab's own8008000PASS
Payslips!Payment I11 total payable is the nov tab's own1673.21673.20PASS
Wagesinterface dec C12 gross pay674867480PASS
Wagesinterface dec D12 income tax8008000PASS
Wagesinterface dec E12 employee NI2962960PASS
Wagesinterface dec H12 employer NI577.2577.20PASS
Payslips!Payment dec D12 NI due873.2873.20PASS
Payslips!Payment dec E12 income tax due8008000PASS
Payslips!Payment dec I12 total amount payable1673.21673.20PASS
Payslips!Payment D12 NI due is the dec tab's own873.2873.20PASS
Payslips!Payment E12 income tax due is the dec tab's own8008000PASS
Payslips!Payment I12 total payable is the dec tab's own1673.21673.20PASS
Wagesinterface jan C13 gross pay674867480PASS
Wagesinterface jan D13 income tax8008000PASS
Wagesinterface jan E13 employee NI2962960PASS
Wagesinterface jan H13 employer NI577.2577.20PASS
Payslips!Payment jan D13 NI due873.2873.20PASS
Payslips!Payment jan E13 income tax due8008000PASS
Payslips!Payment jan I13 total amount payable1673.21673.20PASS
Payslips!Payment D13 NI due is the jan tab's own873.2873.20PASS
Payslips!Payment E13 income tax due is the jan tab's own8008000PASS
Payslips!Payment I13 total payable is the jan tab's own1673.21673.20PASS
Wagesinterface feb C14 gross pay674867480PASS
Wagesinterface feb D14 income tax8008000PASS
Wagesinterface feb E14 employee NI2962960PASS
Wagesinterface feb H14 employer NI577.2577.20PASS
Payslips!Payment feb D14 NI due873.2873.20PASS
Payslips!Payment feb E14 income tax due8008000PASS
Payslips!Payment feb I14 total amount payable1673.21673.20PASS
Payslips!Payment D14 NI due is the feb tab's own873.2873.20PASS
Payslips!Payment E14 income tax due is the feb tab's own8008000PASS
Payslips!Payment I14 total payable is the feb tab's own1673.21673.20PASS
Wagesinterface mar C15 gross pay674867480PASS
Wagesinterface mar D15 income tax8008000PASS
Wagesinterface mar E15 employee NI2962960PASS
Wagesinterface mar H15 employer NI577.2577.20PASS
Payslips!Payment mar D15 NI due873.2873.20PASS
Payslips!Payment mar E15 income tax due8008000PASS
Payslips!Payment mar I15 total amount payable1673.21673.20PASS
Payslips!Payment D15 NI due is the mar tab's own873.2873.20PASS
Payslips!Payment E15 income tax due is the mar tab's own8008000PASS
Payslips!Payment I15 total payable is the mar tab's own1673.21673.20PASS
Payslips print: the page reads the May tabMayMayPASS
Payslips print: the block the page reads is a monthly payrollMONTHLY PAYROLLMONTHLY PAYROLLPASS
Payslips print: the period printed is payroll month 2220PASS
Payslips print: the period ends the day the scenario paid that month's wages46173461730PASS
Payslips print: the page's join to the employee's line carries their payroll number110PASS
Payslips print: gross pay is the pay the scenario recorded350035000PASS
Payslips print: income tax is the tax the scenario recorded5305300PASS
Payslips print: national insurance is the employee NI the scenario recorded2002000PASS
Payslips print: net pay is the net pay the scenario recorded277027700PASS
Payslips print: gross pay to date is every month printed so far700070000PASS
Payslips print: income tax to date is every month printed so far106010600PASS
Payslips print: national insurance to date is every month printed so far4004000PASS
Payslips print: net pay to date is every month printed so far554055400PASS
Payslips print: the payment date is the day the scenario paid that month's wages46173461730PASS
P&L: Wages & Salaries (B21) = Purchases w-coded net + payroll gross + employer NI92735.7333333333292735.7333333333-2.9103830456733704e-11PASS
Payslips!Jul F51 employee nameAlice JohnsonAlice JohnsonPASS
Payslips!Jul M51 gross pay350035000PASS
Payslips!Jul N51 income tax5305300PASS
Payslips!Jul O51 employee NI2002000PASS
Payslips!Jul R51 net pay277027700PASS
Payslips!Jul T51 employer NI382.5382.50PASS
Payslips!Jul S51 referencePAY-EMP001-2025-07PAY-EMP001-2025-07PASS
Payslips!Jul F52 employee nameBob WilliamsBob WilliamsPASS
Payslips!Jul M52 gross pay220022000PASS
Payslips!Jul N52 income tax2702700PASS
Payslips!Jul O52 employee NI96960PASS
Payslips!Jul R52 net pay183418340PASS
Payslips!Jul T52 employer NI187.5187.50PASS
Payslips!Jul S52 referencePAY-EMP002-2025-07PAY-EMP002-2025-07PASS
Payslips!Jul F53 employee nameCarol SmithCarol SmithPASS
Payslips!Jul M53 gross pay104810480PASS
Payslips!Jul N53 income tax000PASS
Payslips!Jul O53 employee NI000PASS
Payslips!Jul R53 net pay104810480PASS
Payslips!Jul T53 employer NI7.27.20PASS
Payslips!Jul S53 referencePAY-EMP003-2025-07PAY-EMP003-2025-07PASS
Payslips!Jul M49 wages paid date46234462340PASS
Payslips!Aug F51 employee nameAlice JohnsonAlice JohnsonPASS
Payslips!Aug M51 gross pay350035000PASS
Payslips!Aug N51 income tax5305300PASS
Payslips!Aug O51 employee NI2002000PASS
Payslips!Aug R51 net pay277027700PASS
Payslips!Aug T51 employer NI382.5382.50PASS
Payslips!Aug S51 referencePAY-EMP001-2025-08PAY-EMP001-2025-08PASS
Payslips!Aug F52 employee nameBob WilliamsBob WilliamsPASS
Payslips!Aug M52 gross pay220022000PASS
Payslips!Aug N52 income tax2702700PASS
Payslips!Aug O52 employee NI96960PASS
Payslips!Aug R52 net pay183418340PASS
Payslips!Aug T52 employer NI187.5187.50PASS
Payslips!Aug S52 referencePAY-EMP002-2025-08PAY-EMP002-2025-08PASS
Payslips!Aug F53 employee nameCarol SmithCarol SmithPASS
Payslips!Aug M53 gross pay104810480PASS
Payslips!Aug N53 income tax000PASS
Payslips!Aug O53 employee NI000PASS
Payslips!Aug R53 net pay104810480PASS
Payslips!Aug T53 employer NI7.27.20PASS
Payslips!Aug S53 referencePAY-EMP003-2025-08PAY-EMP003-2025-08PASS
Payslips!Aug M49 wages paid date46265462650PASS
Payslips!Jul F11 weekly employee line (every employee here pays monthly)PASS
Payslips!Jul F12 weekly employee line (every employee here pays monthly)PASS
Payslips!Jul F13 weekly employee line (every employee here pays monthly)PASS
Payslips!Jul F14 weekly employee line (every employee here pays monthly)PASS
Payslips!Jul F15 weekly employee line (every employee here pays monthly)PASS
Payslips!Jul T41 period total (no weekly employer NI to bring forward)000PASS
Payslips!Aug H11 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug I11 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug J11 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug L11 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug M11 brought forward from Jul (no weekly cycle carried over)PASS
Payslips!Aug H12 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug I12 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug J12 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug L12 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug K12 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug M12 brought forward from Jul (no weekly cycle carried over)PASS
Payslips!Aug H13 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug I13 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug J13 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug L13 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug K13 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug M13 brought forward from Jul (no weekly cycle carried over)PASS
Payslips!Aug H14 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug I14 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug J14 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug L14 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug K14 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug M14 brought forward from Jul (no weekly cycle carried over)PASS
Payslips!Aug H15 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug I15 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug J15 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug L15 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug K15 brought forward from Jul (no weekly cycle carried over)000PASS
Payslips!Aug M15 brought forward from Jul (no weekly cycle carried over)PASS
VAT Q1: box 3 total (G13) = box 1 (G9) + EU acquisitions (G11)16920169200PASS
VAT Q1: box 5 net due (G17) = box 3 (G13) - box 4 (G15)10926.510926.50PASS
VAT Q1: payment due date (G7) falls after the quarter end (G5)110PASS
VAT Q1: box 1/3 output VAT (G9) = scenario sales VAT for the quarter16919.99999999999316920+7.275957614183426e-12PASS
VAT Q1: box 4 input VAT (G15) = scenario purchases VAT for the quarter5993.55993.50PASS
VAT Q1: box 7 net purchases (G23) = scenario purchases net for the quarter30149.74999999999630149.75+3.637978807091713e-12PASS
VAT Q2: box 3 total (G13) = box 1 (G9) + EU acquisitions (G11)17256.666666666717256.66666666670PASS
VAT Q2: box 5 net due (G17) = box 3 (G13) - box 4 (G15)12805.166666666712805.16666666670PASS
VAT Q2: payment due date (G7) falls after the quarter end (G5)110PASS
VAT Q2: box 1/3 output VAT (G9) = scenario sales VAT for the quarter17256.66666666665717256.6666666667+4.3655745685100555e-11PASS
VAT Q2: box 4 input VAT (G15) = scenario purchases VAT for the quarter4451.54451.50PASS
VAT Q2: box 7 net purchases (G23) = scenario purchases net for the quarter22388223880PASS
VAT Q3: box 3 total (G13) = box 1 (G9) + EU acquisitions (G11)19780197800PASS
VAT Q3: box 5 net due (G17) = box 3 (G13) - box 4 (G15)99139913.00000000001+9.094947017729282e-12PASS
VAT Q3: payment due date (G7) falls after the quarter end (G5)110PASS
VAT Q3: box 1/3 output VAT (G9) = scenario sales VAT for the quarter19779.99999999999319780+7.275957614183426e-12PASS
VAT Q3: box 4 input VAT (G15) = scenario purchases VAT for the quarter9867.0000000000029867-1.8189894035458565e-12PASS
VAT Q3: box 7 net purchases (G23) = scenario purchases net for the quarter49508.2499999999949508.25+7.275957614183426e-12PASS
VAT Q4: box 3 total (G13) = box 1 (G9) + EU acquisitions (G11)16860168600PASS
VAT Q4: box 5 net due (G17) = box 3 (G13) - box 4 (G15)14775.6666666666714775.6666666667+3.092281986027956e-11PASS
VAT Q4: payment due date (G7) falls after the quarter end (G5)110PASS
VAT Q4: box 1/3 output VAT (G9) = scenario sales VAT for the quarter16859.99999999999316860+7.275957614183426e-12PASS
VAT Q4: box 4 input VAT (G15) = scenario purchases VAT for the quarter2084.33333333333352084.33333333333-3.637978807091713e-12PASS
VAT Q4: box 7 net purchases (G23) = scenario purchases net for the quarter10549.91666666666610549.9166666667+3.456079866737127e-11PASS
VAT Q5: box 3 total (G13) = box 1 (G9) + EU acquisitions (G11)110011000PASS
VAT Q5: box 5 net due (G17) = box 3 (G13) - box 4 (G15)9209200PASS
VAT Q5: payment due date (G7) falls after the quarter end (G5)110PASS
VAT Q5: box 1/3 output VAT (G9) = scenario sales VAT for the quarter110011000PASS
VAT Q5: box 4 input VAT (G15) = scenario purchases VAT for the quarter1801800PASS
VAT Q5: box 7 net purchases (G23) = scenario purchases net for the quarter9009000PASS
Vatinterface D6: Apr sales net = Sales.xlsx Apr27833.333333333327833.33333333330PASS
Vatinterface F6: Apr output VAT = Sales.xlsx Apr5566.666666666675566.666666666670PASS
Vatinterface H6: Apr purchases net = Purchases.xlsx Apr4265.754265.750PASS
Vatinterface J6: Apr input VAT = Purchases.xlsx Apr845.5845.50PASS
Vatinterface D7: May sales net = Sales.xlsx May27433.333333333327433.33333333330PASS
Vatinterface F7: May output VAT = Sales.xlsx May5486.666666666675486.666666666670PASS
Vatinterface H7: May purchases net = Purchases.xlsx May5321.55321.50PASS
Vatinterface J7: May input VAT = Purchases.xlsx May1053.51053.50PASS
Vatinterface D8: Jun sales net = Sales.xlsx Jun29333.333333333329333.33333333330PASS
Vatinterface F8: Jun output VAT = Sales.xlsx Jun5866.666666666675866.666666666670PASS
Vatinterface H8: Jun purchases net = Purchases.xlsx Jun20562.520562.50PASS
Vatinterface J8: Jun input VAT = Purchases.xlsx Jun4094.54094.50PASS
Vatinterface D9: Jul sales net = Sales.xlsx Jul28133.333333333328133.33333333330PASS
Vatinterface F9: Jul output VAT = Sales.xlsx Jul5626.666666666675626.666666666670PASS
Vatinterface H9: Jul purchases net = Purchases.xlsx Jul7552.757552.750PASS
Vatinterface J9: Jul input VAT = Purchases.xlsx Jul1506.51506.50PASS
Vatinterface D10: Aug sales net = Sales.xlsx Aug30016.666666666730016.66666666670PASS
Vatinterface F10: Aug output VAT = Sales.xlsx Aug6003.333333333336003.333333333330PASS
Vatinterface H10: Aug purchases net = Purchases.xlsx Aug3677.416666666673677.416666666670PASS
Vatinterface J10: Aug input VAT = Purchases.xlsx Aug727.833333333333727.8333333333330PASS
Vatinterface D11: Sep sales net = Sales.xlsx Sep28133.333333333328133.33333333330PASS
Vatinterface F11: Sep output VAT = Sales.xlsx Sep5626.666666666675626.666666666670PASS
Vatinterface H11: Sep purchases net = Purchases.xlsx Sep11157.833333333311157.83333333330PASS
Vatinterface J11: Sep input VAT = Purchases.xlsx Sep2217.166666666672217.166666666670PASS
Vatinterface D12: Oct sales net = Sales.xlsx Oct42133.333333333342133.33333333330PASS
Vatinterface F12: Oct output VAT = Sales.xlsx Oct8426.666666666678426.666666666670PASS
Vatinterface H12: Oct purchases net = Purchases.xlsx Oct35845.2535845.250PASS
Vatinterface J12: Oct input VAT = Purchases.xlsx Oct7160.57160.50PASS
Vatinterface D13: Nov sales net = Sales.xlsx Nov29433.333333333329433.33333333330PASS
Vatinterface F13: Nov output VAT = Sales.xlsx Nov5886.666666666675886.666666666670PASS
Vatinterface H13: Nov purchases net = Purchases.xlsx Nov5778.55778.50PASS
Vatinterface J13: Nov input VAT = Purchases.xlsx Nov1139.51139.50PASS
Vatinterface D14: Dec sales net = Sales.xlsx Dec27333.333333333327333.33333333330PASS
Vatinterface F14: Dec output VAT = Sales.xlsx Dec5466.666666666675466.666666666670PASS
Vatinterface H14: Dec purchases net = Purchases.xlsx Dec7884.57884.50PASS
Vatinterface J14: Dec input VAT = Purchases.xlsx Dec156715670PASS
Vatinterface D15: Jan sales net = Sales.xlsx Jan29533.333333333329533.33333333330PASS
Vatinterface F15: Jan output VAT = Sales.xlsx Jan5906.666666666675906.666666666670PASS
Vatinterface H15: Jan purchases net = Purchases.xlsx Jan3765.753765.750PASS
Vatinterface J15: Jan input VAT = Purchases.xlsx Jan745.5745.50PASS
Vatinterface D16: Feb sales net = Sales.xlsx Feb28633.333333333328633.33333333330PASS
Vatinterface F16: Feb output VAT = Sales.xlsx Feb5726.666666666675726.666666666670PASS
Vatinterface H16: Feb purchases net = Purchases.xlsx Feb366936690PASS
Vatinterface J16: Feb input VAT = Purchases.xlsx Feb727.5727.50PASS
Vatinterface D17: Mar sales net = Sales.xlsx Mar26133.333333333326133.33333333330PASS
Vatinterface F17: Mar output VAT = Sales.xlsx Mar5226.666666666675226.666666666670PASS
Vatinterface H17: Mar purchases net = Purchases.xlsx Mar3115.166666666673115.166666666670PASS
Vatinterface J17: Mar input VAT = Purchases.xlsx Mar611.333333333333611.3333333333330PASS
Vatinterface D4: 02Y1 sales net = the straddling sales entered for that period400040000PASS
Vatinterface F4: 02Y1 output VAT = the straddling sales entered for that period8008000PASS
Vatinterface H4: 02Y1 purchases net = the straddling purchases entered for that period6006000PASS
Vatinterface J4: 02Y1 input VAT = the straddling purchases entered for that period1201200PASS
Vatinterface D5: 03Y1 sales net = the straddling sales entered for that period200020000PASS
Vatinterface F5: 03Y1 output VAT = the straddling sales entered for that period4004000PASS
Vatinterface H5: 03Y1 purchases net = the straddling purchases entered for that period100010000PASS
Vatinterface J5: 03Y1 input VAT = the straddling purchases entered for that period2002000PASS
Vatinterface D18: 04Y2 sales net = the straddling sales entered for that period300030000PASS
Vatinterface F18: 04Y2 output VAT = the straddling sales entered for that period6006000PASS
Vatinterface H18: 04Y2 purchases net = the straddling purchases entered for that period2002000PASS
Vatinterface J18: 04Y2 input VAT = the straddling purchases entered for that period40400PASS
Vatinterface D19: 05Y2 sales net = the straddling sales entered for that period150015000PASS
Vatinterface F19: 05Y2 output VAT = the straddling sales entered for that period3003000PASS
Vatinterface H19: 05Y2 purchases net = the straddling purchases entered for that period3003000PASS
Vatinterface J19: 05Y2 input VAT = the straddling purchases entered for that period60600PASS
Vatinterface D20: 06Y2 sales net = the straddling sales entered for that period100010000PASS
Vatinterface F20: 06Y2 output VAT = the straddling sales entered for that period2002000PASS
Vatinterface H20: 06Y2 purchases net = the straddling purchases entered for that period4004000PASS
Vatinterface J20: 06Y2 input VAT = the straddling purchases entered for that period80800PASS
VAT Q1: quarter end date is one of the Vatinterface periods110PASS
Vatinterface E8: quarter sales net = its three period rows84599.999999999984599.99999999990PASS
Vatinterface G8: quarter output VAT = its three period rows16920.00000000000716920-7.275957614183426e-12PASS
Vatinterface I8: quarter purchases net = its three period rows30149.7530149.750PASS
Vatinterface K8: quarter input VAT = its three period rows5993.55993.50PASS
VAT Q1: box 1 (G9) = Vatinterface quarter VAT due (G8)16920169200PASS
VAT Q1: box 4 (G15) = Vatinterface quarter VAT reclaimed (K8)5993.55993.50PASS
VAT Q1: box 7 (G23) = Vatinterface quarter purchases net (I8)30149.7530149.750PASS
VAT Q1: box 6 (G21) = Vatinterface quarter sales net of VAT84599.999999999984599.99999999990PASS
VAT Q1: payment due date (G7) = Vatinterface final date for payment (C8)46234462340PASS
VAT Q2: quarter end date is one of the Vatinterface periods110PASS
Vatinterface E11: quarter sales net = its three period rows86283.333333333386283.33333333330PASS
Vatinterface G11: quarter output VAT = its three period rows17256.6666666666717256.6666666667+2.9103830456733704e-11PASS
Vatinterface I11: quarter purchases net = its three period rows22387.9999999999722388+2.9103830456733704e-11PASS
Vatinterface K11: quarter input VAT = its three period rows4451.5000000000044451.5-3.637978807091713e-12PASS
VAT Q2: box 1 (G9) = Vatinterface quarter VAT due (G11)17256.666666666717256.66666666670PASS
VAT Q2: box 4 (G15) = Vatinterface quarter VAT reclaimed (K11)4451.54451.50PASS
VAT Q2: box 7 (G23) = Vatinterface quarter purchases net (I11)22388223880PASS
VAT Q2: box 6 (G21) = Vatinterface quarter sales net of VAT86283.333333333386283.33333333330PASS
VAT Q2: payment due date (G7) = Vatinterface final date for payment (C11)46326463260PASS
VAT Q3: quarter end date is one of the Vatinterface periods110PASS
Vatinterface E14: quarter sales net = its three period rows98899.999999999998899.99999999990PASS
Vatinterface G14: quarter output VAT = its three period rows19780.00000000000719780-7.275957614183426e-12PASS
Vatinterface I14: quarter purchases net = its three period rows49508.2549508.250PASS
Vatinterface K14: quarter input VAT = its three period rows986798670PASS
VAT Q3: box 1 (G9) = Vatinterface quarter VAT due (G14)19780197800PASS
VAT Q3: box 4 (G15) = Vatinterface quarter VAT reclaimed (K14)986798670PASS
VAT Q3: box 7 (G23) = Vatinterface quarter purchases net (I14)49508.2549508.250PASS
VAT Q3: box 6 (G21) = Vatinterface quarter sales net of VAT98899.999999999998899.99999999990PASS
VAT Q3: payment due date (G7) = Vatinterface final date for payment (C14)46418464180PASS
VAT Q4: quarter end date is one of the Vatinterface periods110PASS
Vatinterface E17: quarter sales net = its three period rows84299.999999999984299.99999999990PASS
Vatinterface G17: quarter output VAT = its three period rows16860.00000000000716860-7.275957614183426e-12PASS
Vatinterface I17: quarter purchases net = its three period rows10549.9166666666710549.9166666667+3.092281986027956e-11PASS
Vatinterface K17: quarter input VAT = its three period rows2084.3333333333332084.33333333333-3.183231456205249e-12PASS
VAT Q4: box 1 (G9) = Vatinterface quarter VAT due (G17)16860168600PASS
VAT Q4: box 4 (G15) = Vatinterface quarter VAT reclaimed (K17)2084.333333333332084.333333333330PASS
VAT Q4: box 7 (G23) = Vatinterface quarter purchases net (I17)10549.916666666710549.91666666670PASS
VAT Q4: box 6 (G21) = Vatinterface quarter sales net of VAT84299.999999999984299.99999999990PASS
VAT Q4: payment due date (G7) = Vatinterface final date for payment (C17)46507465070PASS
VAT Q5: quarter end date is one of the Vatinterface periods110PASS
Vatinterface E20: quarter sales net = its three period rows550055000PASS
Vatinterface G20: quarter output VAT = its three period rows110011000PASS
Vatinterface I20: quarter purchases net = its three period rows9009000PASS
Vatinterface K20: quarter input VAT = its three period rows1801800PASS
VAT Q5: box 1 (G9) = Vatinterface quarter VAT due (G20)110011000PASS
VAT Q5: box 4 (G15) = Vatinterface quarter VAT reclaimed (K20)1801800PASS
VAT Q5: box 7 (G23) = Vatinterface quarter purchases net (I20)9009000PASS
VAT Q5: box 6 (G21) = Vatinterface quarter sales net of VAT550055000PASS
VAT Q5: payment due date (G7) = Vatinterface final date for payment (C20)46599465990PASS
VAT: the five returns end on five different periods550PASS
VAT: Q2 ends a quarter after Q1330PASS
VAT: Q3 ends a quarter after Q2330PASS
VAT: Q4 ends a quarter after Q3330PASS
VAT: Q5 ends a quarter after Q4330PASS
VAT: Q1-Q4 cover every month of the accounting year12120PASS
VAT: Q5 ends on the last period the Vatinterface carries20200PASS
VAT: periods more than one of the five returns declares000PASS
VAT: output VAT declared on more than one of the five returns000PASS
Admin: Personal Allowance = tax data12570125700PASS
Admin: Personal Allowance Taper Threshold = tax data1000001000000PASS
Admin: Basic Rate = tax data0.20.20PASS
Admin: Higher Rate = tax data0.40.40PASS
Admin: Additional Rate = tax data0.450.450PASS
Admin: Basic Band End = tax data37700377000PASS
Admin: Higher Band Start = tax data37701377010PASS
Admin: Higher Band End = tax data1251401251400PASS
Admin: NI Class 2 Weekly Rate = tax data3.653.650PASS
Admin: NI Class 2 Small Profits Threshold = tax data710571050PASS
Admin: NI Class 4 Lower Rate = tax data0.060.060PASS
Admin: NI Class 4 Lower Limit = tax data12570125700PASS
Admin: NI Class 4 Upper Rate = tax data0.020.020PASS
Admin: NI Class 4 Upper Limit = tax data50270502700PASS
Admin: AIA Rate = tax data110PASS
Admin: WDA Rate = tax data0.140.140PASS
Admin: Mileage Higher Rate Limit = tax data10000100000PASS
Admin: Mileage Higher Rate Pence = tax data0.450.450PASS
Admin: Mileage Lower Rate Start = tax data10001100010PASS
Admin: Mileage Lower Rate Pence = tax data0.250.250PASS
Admin: VAT Registration Threshold = tax data90000900000PASS
Admin: VAT Standard Rate = tax data0.20.20PASS
Admin: Amounts Payable By date (B21) = 31 January the year after the tax year ends46783467830PASS
Payslips calendar: the payroll year starts on the accounts tax year start (B2 = Admin B4)46118461180PASS
Payslips calendar: the year the calendar runs to (I1) = the accounts tax year end (Admin B17)46482464820PASS
Payslips calendar: the tax year the payslips print (N1) = the tax year the package was generated for2026-272026-27PASS
Payslips calendar row 2: the date runs on unbroken from the tax year start46118461180PASS
Payslips calendar row 2: the month name is its payroll month counted from the tax year startAprAprPASS
Payslips calendar row 33: the date runs on unbroken from the tax year start46149461490PASS
Payslips calendar row 33: the month name is its payroll month counted from the tax year startMayMayPASS
Payslips calendar row 64: the date runs on unbroken from the tax year start46180461800PASS
Payslips calendar row 64: the month name is its payroll month counted from the tax year startJunJunPASS
Payslips calendar row 95: the date runs on unbroken from the tax year start46211462110PASS
Payslips calendar row 95: the month name is its payroll month counted from the tax year startJulJulPASS
Payslips calendar row 126: the date runs on unbroken from the tax year start46242462420PASS
Payslips calendar row 126: the month name is its payroll month counted from the tax year startAugAugPASS
Payslips calendar row 157: the date runs on unbroken from the tax year start46273462730PASS
Payslips calendar row 157: the month name is its payroll month counted from the tax year startSepSepPASS
Payslips calendar row 188: the date runs on unbroken from the tax year start46304463040PASS
Payslips calendar row 188: the month name is its payroll month counted from the tax year startOctOctPASS
Payslips calendar row 219: the date runs on unbroken from the tax year start46335463350PASS
Payslips calendar row 219: the month name is its payroll month counted from the tax year startNovNovPASS
Payslips calendar row 250: the date runs on unbroken from the tax year start46366463660PASS
Payslips calendar row 250: the month name is its payroll month counted from the tax year startDecDecPASS
Payslips calendar row 281: the date runs on unbroken from the tax year start46397463970PASS
Payslips calendar row 281: the month name is its payroll month counted from the tax year startJanJanPASS
Payslips calendar row 312: the date runs on unbroken from the tax year start46428464280PASS
Payslips calendar row 312: the month name is its payroll month counted from the tax year startFebFebPASS
Payslips calendar row 343: the date runs on unbroken from the tax year start46459464590PASS
Payslips calendar row 343: the month name is its payroll month counted from the tax year startMarMarPASS
Payslips calendar row 366: the date runs on unbroken from the tax year start46482464820PASS
Payslips calendar row 366: the month name is its payroll month counted from the tax year startMarMarPASS
Payslips calendar row 381: the date runs on unbroken from the tax year start46497464970PASS
Payslips calendar row 381: the month name is its payroll month counted from the tax year startMarMarPASS
Payslips!Payment B4 tax month 1 ends on the last day of Apr46142461420PASS
Payslips!Payment C4 tax month 1 is due on the 19th after it46161461610PASS
Payslips!Payment B5 tax month 2 ends on the last day of May46173461730PASS
Payslips!Payment C5 tax month 2 is due on the 19th after it46192461920PASS
Payslips!Payment B6 tax month 3 ends on the last day of Jun46203462030PASS
Payslips!Payment C6 tax month 3 is due on the 19th after it46222462220PASS
Payslips!Payment B7 tax month 4 ends on the last day of Jul46234462340PASS
Payslips!Payment C7 tax month 4 is due on the 19th after it46253462530PASS
Payslips!Payment B8 tax month 5 ends on the last day of Aug46265462650PASS
Payslips!Payment C8 tax month 5 is due on the 19th after it46284462840PASS
Payslips!Payment B9 tax month 6 ends on the last day of Sep46295462950PASS
Payslips!Payment C9 tax month 6 is due on the 19th after it46314463140PASS
Payslips!Payment B10 tax month 7 ends on the last day of Oct46326463260PASS
Payslips!Payment C10 tax month 7 is due on the 19th after it46345463450PASS
Payslips!Payment B11 tax month 8 ends on the last day of Nov46356463560PASS
Payslips!Payment C11 tax month 8 is due on the 19th after it46375463750PASS
Payslips!Payment B12 tax month 9 ends on the last day of Dec46387463870PASS
Payslips!Payment C12 tax month 9 is due on the 19th after it46406464060PASS
Payslips!Payment B13 tax month 10 ends on the last day of Jan46418464180PASS
Payslips!Payment C13 tax month 10 is due on the 19th after it46437464370PASS
Payslips!Payment B14 tax month 11 ends on the last day of Feb46446464460PASS
Payslips!Payment C14 tax month 11 is due on the 19th after it46465464650PASS
Payslips!Payment B15 tax month 12 ends on the last day of Mar46477464770PASS
Payslips!Payment C15 tax month 12 is due on the 19th after it46496464960PASS
Accounting profit to tax profit bridge closes to zero0-1.4551915228366852e-11-1.4551915228366852e-11PASS
Category netting: Sales Product A (sales a) net reaches Profit & Loss Account!B5 with no residue000PASS
Category netting: Sales Product B (sales b) net reaches Profit & Loss Account!B6 with no residue000PASS
Category netting: Sales Product C (sales c) net reaches Profit & Loss Account!B7 with no residue000PASS
Category netting: Other Income (sales d) net reaches Profit & Loss Account!B8 with no residue000PASS
Category netting: Investment Grants received (sales g) net reaches Profit & Loss Account!B11 with no residue03.637978807091713e-12+3.637978807091713e-12PASS
Category netting: Bad Debts written off (sales o) net reaches Profit & Loss Account!B29 negated with no residue000PASS
Category netting: Sub contractors (purchases c) net reaches Profit & Loss Account!B15 with no residue0-2.7284841053187847e-12-2.7284841053187847e-12PASS
Category netting: Other Direct Cost of Sales (purchases o) net reaches Profit & Loss Account!B16 with no residue000PASS
Category netting: Premises Rent Rates Power (purchases p) net reaches Profit & Loss Account!B22 with no residue000PASS
Category netting: Repairs & Maintenance (purchases m) net reaches Profit & Loss Account!B23 with no residue000PASS
Category netting: General Administrative Expenses (purchases g) net reaches Profit & Loss Account!B24 with no residue000PASS
Category netting: Motor Expenses (purchases v) net reaches Profit & Loss Account!B25 with no residue000PASS
Category netting: Travel Hotel & Subsistence (purchases h) net reaches Profit & Loss Account!B26 with no residue02.2737367544323206e-13+2.2737367544323206e-13PASS
Category netting: Advertising & Promotion (purchases a) net reaches Profit & Loss Account!B27 with no residue000PASS
Category netting: Legal & Professional Fees (purchases l) net reaches Profit & Loss Account!B28 with no residue000PASS
Category netting: Other Expenses (purchases y) net reaches Profit & Loss Account!B32 with no residue06.821210263296962e-12+6.821210263296962e-12PASS
Category netting: Purchases after stock adjustment, less the year's stock movement (purchases s) net reaches Profit & Loss Account!B14 less the stock movement with no residue000PASS
Category netting: Capitalised fixed asset spend (purchases fa) net reaches Fixedassets.xlsx!FAreconciliation!E11 with no residue000PASS
Category netting: Fixed asset disposal proceeds (sales fs) net reaches Fixedassets.xlsx!FAreconciliation!K11 with no residue000PASS
Salesinvoice Product Details: VAT Rate = the tax year's standard rate20200PASS
Salesinvoice: line VAT = price x quantity x the tax year's standard rate2402400PASS
Salesinvoice: net total = the invoice's one line120012000PASS
Salesinvoice: carriage charge lands on the invoice37.537.50PASS
Salesinvoice: VAT total = line VAT plus carriage VAT at the tax year's standard rate247.5247.50PASS
Salesinvoice: amount payable = net plus carriage plus VAT148514850PASS

Input transactions

Business details

ItemValue
NamePrecision Code Trading
DescriptionIT consultancy and software development
Address123 High Street
TownManchester
PostcodeM1 1AA
Phone0161 555 0100
Utr1234567890
Vat number123456789
NinoAB123456C

Month by month

MonthSales entriesSales totalPurchases entriesPurchases totalBank entriesBank total
Apr933,400.00315,111.251682,240.20
May932,920.00346,375.001147,070.20
Jun935,200.003424,657.001563,000.20
Jul933,760.00349,059.251250,185.20
Aug1036,020.00324,405.251164,753.37
Sep1033,760.003413,375.001354,011.20
Oct1150,560.003543,005.7514107,385.20
Nov935,320.00316,918.001162,026.70
Dec832,800.00339,451.501246,142.20
Jan1135,440.00334,511.251256,065.20
Feb934,360.00334,396.501058,002.70
Mar831,360.00313,726.501344,222.20
Year112424,900.00395134,992.25150735,104.57

Every entry

Sales journal: 112 entries, 424,900.00
Apr
DateCustomerAccountDescriptionCodeAmountReference
2025-04-01Beta Systems4001Software licence renewalb1,200.00INV-1301
2025-04-03FreshField Ltd4001Software monitoring licenceb360.00INV-2601
2025-04-05CloudNine Ltd4001SaaS licence feeb600.00INV-1401
2025-04-08Cedar Systems4000Managed servicesa480.00INV-2401
2025-04-10Pinnacle Group4000Monthly support contracta720.00INV-2201
2025-04-15Acme Corp4000IT consultancy servicesa25,000.00INV-1001
2025-04-18TechStart Ltd4000IT consultancy retainera2,400.00INV-1101
2025-04-20DataFlow Inc4000Ad-hoc consultancy projecta1,800.00INV-1201
2025-04-28Horizon Analytics4003Data analytics commissiond840.00INV-2701
May
DateCustomerAccountDescriptionCodeAmountReference
2025-05-03FreshField Ltd4001Software monitoring licenceb360.00INV-2602
2025-05-05CloudNine Ltd4001SaaS licence feeb600.00INV-1402
2025-05-08Cedar Systems4000Managed servicesa480.00INV-2402
2025-05-10Pinnacle Group4000Monthly support contracta720.00INV-2202
2025-05-12QuickFix IT4000IT support consultancya960.00INV-2001
2025-05-15Acme Corp4000IT consultancy servicesa25,000.00INV-1002
2025-05-16Summit Training4002Technical training deliveryc1,200.00INV-2801
2025-05-18TechStart Ltd4000IT consultancy retainera2,400.00INV-1102
2025-05-25Oakridge Partners4000Quarterly consulting engagementa1,200.00INV-2501
Jun
DateCustomerAccountDescriptionCodeAmountReference
2025-06-03FreshField Ltd4001Software monitoring licenceb360.00INV-2603
2025-06-05CloudNine Ltd4001SaaS licence feeb600.00INV-1403
2025-06-08Cedar Systems4000Managed servicesa480.00INV-2403
2025-06-10Pinnacle Group4000Monthly support contracta720.00INV-2203
2025-06-15Acme Corp4000IT consultancy servicesa25,000.00INV-1003
2025-06-18TechStart Ltd4000IT consultancy retainera2,400.00INV-1103
2025-06-20DataFlow Inc4000Ad-hoc consultancy projecta1,800.00INV-1202
2025-06-20Gamma Ltd4002Advanced DevOps training coursec2,400.00INV-1501
2025-06-22WidgetWorks4000Project consultancya1,440.00INV-2101
Jul
DateCustomerAccountDescriptionCodeAmountReference
2025-07-01Beta Systems4001Software licence renewalb1,200.00INV-1302
2025-07-03FreshField Ltd4001Software monitoring licenceb360.00INV-2604
2025-07-05CloudNine Ltd4001SaaS licence feeb600.00INV-1404
2025-07-08Cedar Systems4000Managed servicesa480.00INV-2404
2025-07-10Pinnacle Group4000Monthly support contracta720.00INV-2204
2025-07-14NorthStar Digital4000Project deliverya2,160.00INV-2301
2025-07-15Acme Corp4000IT consultancy servicesa25,000.00INV-1004
2025-07-18TechStart Ltd4000IT consultancy retainera2,400.00INV-1104
2025-07-28Horizon Analytics4003Data analytics commissiond840.00INV-2702
Aug
DateCustomerAccountDescriptionCodeAmountReference
2025-08-01Innovate UK4004Small business innovation grantg2,500.00INV-1701
2025-08-03FreshField Ltd4001Software monitoring licenceb360.00INV-2605
2025-08-05CloudNine Ltd4001SaaS licence feeb600.00INV-1405
2025-08-08Cedar Systems4000Managed servicesa480.00INV-2405
2025-08-10Pinnacle Group4000Monthly support contracta720.00INV-2205
2025-08-12QuickFix IT4000IT support consultancya960.00INV-2002
2025-08-15Acme Corp4000IT consultancy servicesa25,000.00INV-1005
2025-08-18TechStart Ltd4000IT consultancy retainera2,400.00INV-1105
2025-08-20DataFlow Inc4000Ad-hoc consultancy projecta1,800.00INV-1203
2025-08-25Oakridge Partners4000Quarterly consulting engagementa1,200.00INV-2502
Sep
DateCustomerAccountDescriptionCodeAmountReference
2025-09-03FreshField Ltd4001Software monitoring licenceb360.00INV-2606
2025-09-05CloudNine Ltd4001SaaS licence feeb600.00INV-1406
2025-09-08Cedar Systems4000Managed servicesa480.00INV-2406
2025-09-10Pinnacle Group4000Monthly support contracta720.00INV-2206
2025-09-15Acme Corp4000IT consultancy servicesa25,000.00INV-1006
2025-09-16Summit Training4002Technical training deliveryc1,200.00INV-2802
2025-09-18TechStart Ltd4000IT consultancy retainera2,400.00INV-1106
2025-09-20StartupHub4002Agile methodology workshopc960.00INV-1504
2025-09-22WidgetWorks4000Project consultancya1,440.00INV-2102
2025-09-25Epsilon Partners4003Client referral commissiond600.00INV-1601
Oct
DateCustomerAccountDescriptionCodeAmountReference
2025-10-01Beta Systems4001Software licence renewalb1,200.00INV-1303
2025-10-03FreshField Ltd4001Software monitoring licenceb360.00INV-2607
2025-10-05CloudNine Ltd4001SaaS licence feeb600.00INV-1407
2025-10-08Cedar Systems4000Managed servicesa480.00INV-2407
2025-10-10Private buyer4006Disposal of company vanfs15,000.00INV-1901
2025-10-10Pinnacle Group4000Monthly support contracta720.00INV-2207
2025-10-14NorthStar Digital4000Project deliverya2,160.00INV-2302
2025-10-15Acme Corp4000IT consultancy servicesa25,000.00INV-1007
2025-10-18TechStart Ltd4000IT consultancy retainera2,400.00INV-1107
2025-10-20DataFlow Inc4000Ad-hoc consultancy projecta1,800.00INV-1204
2025-10-28Horizon Analytics4003Data analytics commissiond840.00INV-2703
Nov
DateCustomerAccountDescriptionCodeAmountReference
2025-11-03FreshField Ltd4001Software monitoring licenceb360.00INV-2608
2025-11-05CloudNine Ltd4001SaaS licence feeb600.00INV-1408
2025-11-08Cedar Systems4000Managed servicesa480.00INV-2408
2025-11-10Pinnacle Group4000Monthly support contracta720.00INV-2208
2025-11-12QuickFix IT4000IT support consultancya960.00INV-2003
2025-11-15Acme Corp4000IT consultancy servicesa25,000.00INV-1008
2025-11-18TechStart Ltd4000IT consultancy retainera2,400.00INV-1108
2025-11-20Delta PLC4002Cloud architecture workshopc3,600.00INV-1502
2025-11-25Oakridge Partners4000Quarterly consulting engagementa1,200.00INV-2503
Dec
DateCustomerAccountDescriptionCodeAmountReference
2025-12-03FreshField Ltd4001Software monitoring licenceb360.00INV-2609
2025-12-05CloudNine Ltd4001SaaS licence feeb600.00INV-1409
2025-12-08Cedar Systems4000Managed servicesa480.00INV-2409
2025-12-10Pinnacle Group4000Monthly support contracta720.00INV-2209
2025-12-15Acme Corp4000IT consultancy servicesa25,000.00INV-1009
2025-12-18TechStart Ltd4000IT consultancy retainera2,400.00INV-1109
2025-12-20DataFlow Inc4000Ad-hoc consultancy projecta1,800.00INV-1205
2025-12-22WidgetWorks4000Project consultancya1,440.00INV-2103
Jan
DateCustomerAccountDescriptionCodeAmountReference
2026-01-01Beta Systems4001Software licence renewalb1,200.00INV-1304
2026-01-03FreshField Ltd4001Software monitoring licenceb360.00INV-2610
2026-01-05CloudNine Ltd4001SaaS licence feeb600.00INV-1410
2026-01-08Cedar Systems4000Managed servicesa480.00INV-2410
2026-01-10Pinnacle Group4000Monthly support contracta720.00INV-2210
2026-01-14NorthStar Digital4000Project deliverya2,160.00INV-2303
2026-01-15Acme Corp4000IT consultancy servicesa25,000.00INV-1010
2026-01-16Summit Training4002Technical training deliveryc1,200.00INV-2803
2026-01-18TechStart Ltd4000IT consultancy retainera2,400.00INV-1110
2026-01-25Lambda Corp4003Client referral commissiond480.00INV-1602
2026-01-28Horizon Analytics4003Data analytics commissiond840.00INV-2704
Feb
DateCustomerAccountDescriptionCodeAmountReference
2026-02-03FreshField Ltd4001Software monitoring licenceb360.00INV-2611
2026-02-05CloudNine Ltd4001SaaS licence feeb600.00INV-1411
2026-02-08Cedar Systems4000Managed servicesa480.00INV-2411
2026-02-10Pinnacle Group4000Monthly support contracta720.00INV-2211
2026-02-15Acme Corp4000IT consultancy servicesa25,000.00INV-1011
2026-02-18TechStart Ltd4000IT consultancy retainera2,400.00INV-1111
2026-02-20DataFlow Inc4000Ad-hoc consultancy projecta1,800.00INV-1206
2026-02-20MegaCorp4002Security awareness trainingc1,800.00INV-1503
2026-02-25Oakridge Partners4000Quarterly consulting engagementa1,200.00INV-2504
Mar
DateCustomerAccountDescriptionCodeAmountReference
2026-03-03FreshField Ltd4001Software monitoring licenceb360.00INV-2612
2026-03-05CloudNine Ltd4001SaaS licence feeb600.00INV-1412
2026-03-08Cedar Systems4000Managed servicesa480.00INV-2412
2026-03-10Pinnacle Group4000Monthly support contracta720.00INV-2212
2026-03-15Acme Corp4000IT consultancy servicesa25,000.00INV-1012
2026-03-18TechStart Ltd4000IT consultancy retainera2,400.00INV-1112
2026-03-22WidgetWorks4000Project consultancya1,440.00INV-2104
2026-03-31Zeta Corp4005Bad debt written offo360.00CN-1801
Purchase journal: 395 entries, 134,992.25
Apr
DateSupplierAccountDescriptionCodeAmountMileage
2025-04-01WorkSpace Ltd5200Monthly office rentp1,200.00
2025-04-01Microsoft5501Microsoft 365 subscriptiong30.00
2025-04-01Slack5501Slack team subscriptiong15.00
2025-04-01GitHub5002GitHub Team subscriptiono45.00
2025-04-01Hiscox5700Professional indemnity insurancey1,440.00
2025-04-01Cloudflare5002CDN and DNS serviceso24.00
2025-04-01Zoom5501Video conferencing subscriptiong18.00
2025-04-03AWS5002Cloud hosting chargeso180.00
2025-04-03Argos5401Miscellaneous office itemsy22.00
2025-04-05Ryman5401Stationery suppliesy24.00
2025-04-05BP5601Fuel for company vehiclev180.00
2025-04-05DigitalOcean5002Cloud VPS hostingo36.00
2025-04-08National Rail5600Train ticket client meetingh48.00
2025-04-10Amazon5401Office suppliesy36.00
2025-04-10Xerox5701Printer lease paymentg180.00
2025-04-10TechParts5000Hardware components for resales600.00
2025-04-12NCP5601Parking chargesv18.00
2025-04-14Toolstation5401Assorted fixings and partsy42.00
2025-04-14Uber5600Taxi to client siteh24.00
2025-04-14Costa Coffee5600Client meeting refreshmentsh12.00
2025-04-15Shell5601Fuel for company vehiclev150.00
2025-04-15Royal Mail5501Postageg12.00
2025-04-18Jet5601Fuel for company vehiclev96.00
2025-04-20BT Business5501Telephone line rentalg60.00
2025-04-20Office Maintenance Ltd5400Premises maintenance and repairsm120.00
2025-04-21Greggs5600Working lunchh8.00
2025-04-22Screwfix5401Miscellaneous suppliesy18.00
2025-04-25Wilko5401Cleaning and kitchen suppliesy15.00
2025-04-25Mileage claim5601Business mileage to Manchesterv38.2585.00
2025-04-28Shell5601Additional fuel purchasev120.00
2025-04-30Smith & Co5800Monthly accountancy retainerl300.00
May
DateSupplierAccountDescriptionCodeAmountReferenceMileage
2025-05-01WorkSpace Ltd5200Monthly office rentp1,200.00
2025-05-01Microsoft5501Microsoft 365 subscriptiong30.00
2025-05-01Slack5501Slack team subscriptiong15.00
2025-05-01GitHub5002GitHub Team subscriptiono45.00
2025-05-01Cloudflare5002CDN and DNS serviceso24.00
2025-05-01Zoom5501Video conferencing subscriptiong18.00
2025-05-03AWS5002Cloud hosting chargeso180.00
2025-05-03Argos5401Miscellaneous office itemsy22.00
2025-05-05Ryman5401Stationery suppliesy24.00
2025-05-05BP5601Fuel for company vehiclev180.00
2025-05-06Trainline5600Advance train ticketh60.00
2025-05-08National Rail5600Train ticket client meetingh48.00
2025-05-08Hilti5301Power tool hireo240.00
2025-05-10Amazon5401Office suppliesy36.00
2025-05-10Google Ads5500PPC advertising campaigna600.00
2025-05-12NCP5601Parking chargesv18.00
2025-05-14Uber5600Taxi to client siteh24.00
2025-05-14Costa Coffee5600Client meeting refreshmentsh12.00
2025-05-15Shell5601Fuel for company vehiclev150.00
2025-05-15Royal Mail5501Postageg12.00
2025-05-15ComponentsDirect5000Electronic componentss480.00
2025-05-15Dell5900New laptop for developmentfa1,800.00PUR-FA-001
2025-05-16WHSmith5501Magazines and stationeryg18.00
2025-05-18Jet5601Fuel for company vehiclev96.00
2025-05-20BT Business5501Telephone line rentalg60.00
2025-05-20ParcelForce5300Equipment deliveryg180.00
2025-05-20CableCo5000Cabling and connectorss240.00
2025-05-21Greggs5600Working lunchh8.00
2025-05-22Screwfix5401Miscellaneous suppliesy18.00
2025-05-22Halfords5601Vehicle maintenance suppliesv48.00
2025-05-25Wilko5401Cleaning and kitchen suppliesy15.00
2025-05-25Mileage claim5601Business mileage to Birminghamv54.00120.00
2025-05-28Shell5601Additional fuel purchasev120.00
2025-05-31Smith & Co5800Monthly accountancy retainerl300.00
Jun
DateSupplierAccountDescriptionCodeAmountReferenceCis deductionMileage
2025-06-01WorkSpace Ltd5200Monthly office rentp1,200.00
2025-06-01Microsoft5501Microsoft 365 subscriptiong30.00
2025-06-01Slack5501Slack team subscriptiong15.00
2025-06-01GitHub5002GitHub Team subscriptiono45.00
2025-06-01Cloudflare5002CDN and DNS serviceso24.00
2025-06-01Zoom5501Video conferencing subscriptiong18.00
2025-06-03AWS5002Cloud hosting chargeso180.00
2025-06-03Argos5401Miscellaneous office itemsy22.00
2025-06-05Ryman5401Stationery suppliesy24.00
2025-06-05BP5601Fuel for company vehiclev180.00
2025-06-05DigitalOcean5002Cloud VPS hostingo36.00
2025-06-08National Rail5600Train ticket client meetingh48.00
2025-06-10Amazon5401Office suppliesy36.00
2025-06-10Vistaprint5501Business cards and flyersg96.00
2025-06-12NCP5601Parking chargesv18.00
2025-06-14Toolstation5401Assorted fixings and partsy30.00
2025-06-14Uber5600Taxi to client siteh24.00
2025-06-14Costa Coffee5600Client meeting refreshmentsh12.00
2025-06-15Shell5601Fuel for company vehiclev150.00
2025-06-15Royal Mail5501Postageg12.00
2025-06-15BuildTech Solutions5001Sub-contractor network installationc5,000.00PUR-CIS-0011,000.00
2025-06-18Premier Inn5600Hotel for London client meetingh180.00
2025-06-18ElectroParts5000Specialist electronic componentss360.00
2025-06-18Jet5601Fuel for company vehiclev96.00
2025-06-20BT Business5501Telephone line rentalg60.00
2025-06-21Greggs5600Working lunchh8.00
2025-06-22Screwfix5401Miscellaneous suppliesy18.00
2025-06-25EnergySupply5201Quarterly utility billp360.00
2025-06-25Wilko5401Cleaning and kitchen suppliesy15.00
2025-06-25Mileage claim5601Business mileage to Londonv90.00200.00
2025-06-28Shell5601Additional fuel purchasev120.00
2025-06-30Smith & Co5800Monthly accountancy retainerl300.00
2025-06-30Directors loan5803Directors loan interestl250.00PUR-INT-001
2025-06-01Precision Tooling Supplies5900Test rig bought under HP-2025-01fa15,600.00PUR-FA-004
Jul
DateSupplierAccountDescriptionCodeAmountReferenceMileage
2025-07-01WorkSpace Ltd5200Monthly office rentp1,200.00
2025-07-01Microsoft5501Microsoft 365 subscriptiong30.00
2025-07-01Slack5501Slack team subscriptiong15.00
2025-07-01GitHub5002GitHub Team subscriptiono45.00
2025-07-01J. Smith Consulting5802Goodwill amortisationl3,000.00
2025-07-01Cloudflare5002CDN and DNS serviceso24.00
2025-07-01Zoom5501Video conferencing subscriptiong18.00
2025-07-03AWS5002Cloud hosting chargeso180.00
2025-07-03Argos5401Miscellaneous office itemsy22.00
2025-07-05Ryman5401Stationery suppliesy24.00
2025-07-05LinkedIn5500Sponsored content campaigna480.00
2025-07-05BP5601Fuel for company vehiclev180.00
2025-07-08National Rail5600Train ticket client meetingh48.00
2025-07-10Amazon5401Office suppliesy36.00
2025-07-10Xerox5701Printer lease paymentg180.00
2025-07-10TechParts5000Hardware components for resales720.00
2025-07-12NCP5601Parking chargesv18.00
2025-07-12ToolHire5301Equipment hire for installationo480.00
2025-07-14Uber5600Taxi to client siteh24.00
2025-07-14Costa Coffee5600Client meeting refreshmentsh12.00
2025-07-15Shell5601Fuel for company vehiclev150.00
2025-07-15Royal Mail5501Postageg12.00
2025-07-15IKEA5900Office furniturefa1,200.00PUR-FA-003
2025-07-16WHSmith5501Magazines and stationeryg24.00
2025-07-18Jet5601Fuel for company vehiclev96.00
2025-07-20BT Business5501Telephone line rentalg60.00
2025-07-20DHL5300International courierg120.00
2025-07-20Office Maintenance Ltd5400Premises maintenance and repairsm180.00
2025-07-21Greggs5600Working lunchh8.00
2025-07-22Screwfix5401Miscellaneous suppliesy18.00
2025-07-25Wilko5401Cleaning and kitchen suppliesy15.00
2025-07-25Mileage claim5601Business mileage to Leedsv20.2545.00
2025-07-28Shell5601Additional fuel purchasev120.00
2025-07-31Smith & Co5800Monthly accountancy retainerl300.00
Aug
DateSupplierAccountDescriptionCodeAmountMileage
2025-08-01WorkSpace Ltd5200Monthly office rentp1,200.00
2025-08-01Microsoft5501Microsoft 365 subscriptiong30.00
2025-08-01Slack5501Slack team subscriptiong15.00
2025-08-01GitHub5002GitHub Team subscriptiono45.00
2025-08-01Cloudflare5002CDN and DNS serviceso24.00
2025-08-01Zoom5501Video conferencing subscriptiong18.00
2025-08-03AWS5002Cloud hosting chargeso180.00
2025-08-03Argos5401Miscellaneous office itemsy22.00
2025-08-05Ryman5401Stationery suppliesy24.00
2025-08-05BP5601Fuel for company vehiclev180.00
2025-08-05DigitalOcean5002Cloud VPS hostingo36.00
2025-08-06Trainline5600Advance train ticketh48.00
2025-08-08National Rail5600Train ticket client meetingh48.00
2025-08-10Amazon5401Office suppliesy36.00
2025-08-12NCP5601Parking chargesv18.00
2025-08-14Toolstation5401Assorted fixings and partsy48.00
2025-08-14Uber5600Taxi to client siteh24.00
2025-08-14Costa Coffee5600Client meeting refreshmentsh12.00
2025-08-15Shell5601Fuel for company vehiclev150.00
2025-08-15Royal Mail5501Postageg12.00
2025-08-15ComponentsDirect5000Electronic componentss360.00
2025-08-18PC Repair Shop5400Laptop screen repairm240.00
2025-08-18Jet5601Fuel for company vehiclev96.00
2025-08-20BT Business5501Telephone line rentalg60.00
2025-08-20Casual worker5101Temporary labourw800.00
2025-08-20CableCo5000Cabling and connectorss180.00
2025-08-21Greggs5600Working lunchh8.00
2025-08-22Screwfix5401Miscellaneous suppliesy18.00
2025-08-25Wilko5401Cleaning and kitchen suppliesy15.00
2025-08-25Mileage claim5601Business mileage to Manchesterv38.2585.00
2025-08-28Shell5601Additional fuel purchasev120.00
2025-08-31Smith & Co5800Monthly accountancy retainerl300.00
Sep
DateSupplierAccountDescriptionCodeAmountMileageReference
2025-09-01WorkSpace Ltd5200Monthly office rentp1,200.00
2025-09-01Microsoft5501Microsoft 365 subscriptiong30.00
2025-09-01Slack5501Slack team subscriptiong15.00
2025-09-01GitHub5002GitHub Team subscriptiono45.00
2025-09-01Cloudflare5002CDN and DNS serviceso24.00
2025-09-01Zoom5501Video conferencing subscriptiong18.00
2025-09-03AWS5002Cloud hosting chargeso180.00
2025-09-03Argos5401Miscellaneous office itemsy22.00
2025-09-05Ryman5401Stationery suppliesy24.00
2025-09-05BP5601Fuel for company vehiclev180.00
2025-09-08National Rail5600Train ticket client meetingh48.00
2025-09-08Hilti5301Power tool hireo360.00
2025-09-10Amazon5401Office suppliesy36.00
2025-09-10Royal Mail5300Special delivery courierg96.00
2025-09-12NCP5601Parking chargesv18.00
2025-09-14Uber5600Taxi to client siteh24.00
2025-09-14Costa Coffee5600Client meeting refreshmentsh12.00
2025-09-15Shell5601Fuel for company vehiclev150.00
2025-09-15Royal Mail5501Postageg12.00
2025-09-15Jones Solicitors5800Contract review and legal advicel960.00
2025-09-16WHSmith5501Magazines and stationeryg12.00
2025-09-18ElectroParts5000Specialist electronic componentss240.00
2025-09-18Jet5601Fuel for company vehiclev96.00
2025-09-20BT Business5501Telephone line rentalg60.00
2025-09-21Greggs5600Working lunchh8.00
2025-09-22Screwfix5401Miscellaneous suppliesy18.00
2025-09-22Halfords5601Vehicle maintenance suppliesv72.00
2025-09-25EnergySupply5201Quarterly utility billp300.00
2025-09-25Wilko5401Cleaning and kitchen suppliesy15.00
2025-09-25Mileage claim5601Business mileage to Bristolv72.00160.00
2025-09-28Shell5601Additional fuel purchasev120.00
2025-09-30Smith & Co5800Monthly accountancy retainerl300.00
2025-09-30Directors loan5803Directors loan interestl208.00PUR-INT-002
2025-09-01Precision Tooling Supplies5900Bench calibration kit bought under HP-2025-02fa8,400.00PUR-FA-005
Oct
DateSupplierAccountDescriptionCodeAmountMileageReference
2025-10-01WorkSpace Ltd5200Monthly office rentp1,200.00
2025-10-01Microsoft5501Microsoft 365 subscriptiong30.00
2025-10-01Slack5501Slack team subscriptiong15.00
2025-10-01GitHub5002GitHub Team subscriptiono45.00
2025-10-01Simply Business5700Contents insurance renewaly360.00
2025-10-01Cloudflare5002CDN and DNS serviceso24.00
2025-10-01Zoom5501Video conferencing subscriptiong18.00
2025-10-03AWS5002Cloud hosting chargeso180.00
2025-10-03Argos5401Miscellaneous office itemsy22.00
2025-10-05Ryman5401Stationery suppliesy24.00
2025-10-05BP5601Fuel for company vehiclev180.00
2025-10-05DigitalOcean5002Cloud VPS hostingo36.00
2025-10-08National Rail5600Train ticket client meetingh48.00
2025-10-10Amazon5401Office suppliesy36.00
2025-10-10Xerox5701Printer lease paymentg180.00
2025-10-10TechParts5000Hardware components for resales480.00
2025-10-10Google Ads5500PPC advertising campaign Q3a1,800.00
2025-10-12NCP5601Parking chargesv18.00
2025-10-14Toolstation5401Assorted fixings and partsy36.00
2025-10-14Uber5600Taxi to client siteh24.00
2025-10-14Costa Coffee5600Client meeting refreshmentsh12.00
2025-10-15Shell5601Fuel for company vehiclev150.00
2025-10-15Royal Mail5501Postageg12.00
2025-10-15TechExpo5500Exhibition stand and materialsa1,200.00
2025-10-18Premier Inn5600Hotel for Birmingham meetingh120.00
2025-10-18Jet5601Fuel for company vehiclev96.00
2025-10-20BT Business5501Telephone line rentalg60.00
2025-10-20Office Maintenance Ltd5400Premises maintenance and repairsm96.00
2025-10-21Greggs5600Working lunchh8.00
2025-10-22Screwfix5401Miscellaneous suppliesy18.00
2025-10-25Wilko5401Cleaning and kitchen suppliesy15.00
2025-10-25Mileage claim5601Business mileage to Sheffieldv42.7595.00
2025-10-25Ford5900Ford Transit Custom vanfa36,000.00PUR-FA-002
2025-10-28Shell5601Additional fuel purchasev120.00
2025-10-31Smith & Co5800Monthly accountancy retainerl300.00
Nov
DateSupplierAccountDescriptionCodeAmountReferenceCis deductionMileage
2025-11-01WorkSpace Ltd5200Monthly office rentp1,200.00
2025-11-01Microsoft5501Microsoft 365 subscriptiong30.00
2025-11-01Slack5501Slack team subscriptiong15.00
2025-11-01GitHub5002GitHub Team subscriptiono45.00
2025-11-01Cloudflare5002CDN and DNS serviceso24.00
2025-11-01Zoom5501Video conferencing subscriptiong18.00
2025-11-03AWS5002Cloud hosting chargeso180.00
2025-11-03Argos5401Miscellaneous office itemsy22.00
2025-11-05Ryman5401Stationery suppliesy24.00
2025-11-05BP5601Fuel for company vehiclev180.00
2025-11-06Trainline5600Advance train ticketh72.00
2025-11-08National Rail5600Train ticket client meetingh48.00
2025-11-10Amazon5401Office suppliesy36.00
2025-11-12NCP5601Parking chargesv18.00
2025-11-14Uber5600Taxi to client siteh24.00
2025-11-14Costa Coffee5600Client meeting refreshmentsh12.00
2025-11-15Shell5601Fuel for company vehiclev150.00
2025-11-15Royal Mail5501Postageg12.00
2025-11-15ComponentsDirect5000Electronic componentss540.00
2025-11-15BuildTech Solutions5001Sub-contractor cabling worksc3,000.00PUR-CIS-002600.00
2025-11-16WHSmith5501Magazines and stationeryg30.00
2025-11-18Jet5601Fuel for company vehiclev96.00
2025-11-20BT Business5501Telephone line rentalg60.00
2025-11-20ParcelForce5300Equipment deliveryg240.00
2025-11-20CableCo5000Cabling and connectorss300.00
2025-11-21Greggs5600Working lunchh8.00
2025-11-22Screwfix5401Miscellaneous suppliesy18.00
2025-11-25Wilko5401Cleaning and kitchen suppliesy15.00
2025-11-25Mileage claim5601Business mileage to Londonv81.00180.00
2025-11-28Shell5601Additional fuel purchasev120.00
2025-11-30Smith & Co5800Monthly accountancy retainerl300.00
Dec
DateSupplierAccountDescriptionCodeAmountMileageReference
2025-12-01WorkSpace Ltd5200Monthly office rentp1,200.00
2025-12-01Microsoft5501Microsoft 365 subscriptiong30.00
2025-12-01Slack5501Slack team subscriptiong15.00
2025-12-01GitHub5002GitHub Team subscriptiono45.00
2025-12-01Cloudflare5002CDN and DNS serviceso24.00
2025-12-01Zoom5501Video conferencing subscriptiong18.00
2025-12-03AWS5002Cloud hosting chargeso180.00
2025-12-03Argos5401Miscellaneous office itemsy22.00
2025-12-05Ryman5401Stationery suppliesy24.00
2025-12-05BP5601Fuel for company vehiclev180.00
2025-12-05DigitalOcean5002Cloud VPS hostingo36.00
2025-12-08National Rail5600Train ticket client meetingh48.00
2025-12-10Amazon5401Office suppliesy36.00
2025-12-10Vistaprint5501Business cards and flyersg120.00
2025-12-12NCP5601Parking chargesv18.00
2025-12-14Toolstation5401Assorted fixings and partsy24.00
2025-12-14Uber5600Taxi to client siteh24.00
2025-12-14Costa Coffee5600Client meeting refreshmentsh12.00
2025-12-15Shell5601Fuel for company vehiclev150.00
2025-12-15Royal Mail5501Postageg12.00
2025-12-15Code Club UK5801Charitable donationy500.00
2025-12-18ElectroParts5000Specialist electronic componentss480.00
2025-12-18Jet5601Fuel for company vehiclev96.00
2025-12-20BT Business5501Telephone line rentalg60.00
2025-12-21Greggs5600Working lunchh8.00
2025-12-22Screwfix5401Miscellaneous suppliesy18.00
2025-12-25EnergySupply5201Quarterly utility billp420.00
2025-12-25Wilko5401Cleaning and kitchen suppliesy15.00
2025-12-25Mileage claim5601Business mileage to Variousv49.50110.00
2025-12-28Shell5601Additional fuel purchasev120.00
2025-12-31Smith & Co5800Monthly accountancy retainerl300.00
2025-12-31Director5100Director fees (non-PAYE)w5,000.00
2025-12-31Directors loan5803Directors loan interestl167.00PUR-INT-003
Jan
DateSupplierAccountDescriptionCodeAmountMileage
2026-01-01WorkSpace Ltd5200Monthly office rentp1,200.00
2026-01-01Microsoft5501Microsoft 365 subscriptiong30.00
2026-01-01Slack5501Slack team subscriptiong15.00
2026-01-01GitHub5002GitHub Team subscriptiono45.00
2026-01-01Cloudflare5002CDN and DNS serviceso24.00
2026-01-01Zoom5501Video conferencing subscriptiong18.00
2026-01-03AWS5002Cloud hosting chargeso180.00
2026-01-03Argos5401Miscellaneous office itemsy22.00
2026-01-05Ryman5401Stationery suppliesy24.00
2026-01-05LinkedIn5500Sponsored content campaigna480.00
2026-01-05BP5601Fuel for company vehiclev180.00
2026-01-08National Rail5600Train ticket client meetingh48.00
2026-01-08Hilti5301Power tool hireo180.00
2026-01-10Amazon5401Office suppliesy36.00
2026-01-10Xerox5701Printer lease paymentg180.00
2026-01-10TechParts5000Hardware components for resales600.00
2026-01-12NCP5601Parking chargesv18.00
2026-01-14Uber5600Taxi to client siteh24.00
2026-01-14Costa Coffee5600Client meeting refreshmentsh12.00
2026-01-15Shell5601Fuel for company vehiclev150.00
2026-01-15Royal Mail5501Postageg12.00
2026-01-16WHSmith5501Magazines and stationeryg18.00
2026-01-18Jet5601Fuel for company vehiclev96.00
2026-01-20BT Business5501Telephone line rentalg60.00
2026-01-20DHL5300International courierg180.00
2026-01-20Office Maintenance Ltd5400Premises maintenance and repairsm144.00
2026-01-21Greggs5600Working lunchh8.00
2026-01-22Screwfix5401Miscellaneous suppliesy18.00
2026-01-22Halfords5601Vehicle maintenance suppliesv36.00
2026-01-25Wilko5401Cleaning and kitchen suppliesy15.00
2026-01-25Mileage claim5601Business mileage to Manchesterv38.2585.00
2026-01-28Shell5601Additional fuel purchasev120.00
2026-01-31Smith & Co5800Monthly accountancy retainerl300.00
Feb
DateSupplierAccountDescriptionCodeAmountMileage
2026-02-01WorkSpace Ltd5200Monthly office rentp1,200.00
2026-02-01Microsoft5501Microsoft 365 subscriptiong30.00
2026-02-01Slack5501Slack team subscriptiong15.00
2026-02-01GitHub5002GitHub Team subscriptiono45.00
2026-02-01Cloudflare5002CDN and DNS serviceso24.00
2026-02-01Zoom5501Video conferencing subscriptiong18.00
2026-02-03AWS5002Cloud hosting chargeso180.00
2026-02-03Argos5401Miscellaneous office itemsy22.00
2026-02-05Ryman5401Stationery suppliesy24.00
2026-02-05BP5601Fuel for company vehiclev180.00
2026-02-05DigitalOcean5002Cloud VPS hostingo36.00
2026-02-06Trainline5600Advance train ticketh36.00
2026-02-08National Rail5600Train ticket client meetingh48.00
2026-02-10Amazon5401Office suppliesy36.00
2026-02-12NCP5601Parking chargesv18.00
2026-02-12ToolHire5301Equipment hire for installationo360.00
2026-02-14Toolstation5401Assorted fixings and partsy18.00
2026-02-14Uber5600Taxi to client siteh24.00
2026-02-14Costa Coffee5600Client meeting refreshmentsh12.00
2026-02-15Shell5601Fuel for company vehiclev150.00
2026-02-15Royal Mail5501Postageg12.00
2026-02-15ComponentsDirect5000Electronic componentss420.00
2026-02-18PC Repair Shop5400Desktop motherboard replacementm360.00
2026-02-18Premier Inn5600Hotel for two-day workshoph240.00
2026-02-18Jet5601Fuel for company vehiclev96.00
2026-02-20BT Business5501Telephone line rentalg60.00
2026-02-20CableCo5000Cabling and connectorss240.00
2026-02-21Greggs5600Working lunchh8.00
2026-02-22Screwfix5401Miscellaneous suppliesy18.00
2026-02-25Wilko5401Cleaning and kitchen suppliesy15.00
2026-02-25Mileage claim5601Business mileage to Nottinghamv31.5070.00
2026-02-28Smith & Co5800Monthly accountancy retainerl300.00
2026-02-28Shell5601Additional fuel purchasev120.00
Mar
DateSupplierAccountDescriptionCodeAmountMileageReference
2026-03-01WorkSpace Ltd5200Monthly office rentp1,200.00
2026-03-01Microsoft5501Microsoft 365 subscriptiong30.00
2026-03-01Slack5501Slack team subscriptiong15.00
2026-03-01GitHub5002GitHub Team subscriptiono45.00
2026-03-01Cloudflare5002CDN and DNS serviceso24.00
2026-03-01Zoom5501Video conferencing subscriptiong18.00
2026-03-03AWS5002Cloud hosting chargeso180.00
2026-03-03Argos5401Miscellaneous office itemsy22.00
2026-03-05Ryman5401Stationery suppliesy24.00
2026-03-05BP5601Fuel for company vehiclev180.00
2026-03-08National Rail5600Train ticket client meetingh48.00
2026-03-10Amazon5401Office suppliesy36.00
2026-03-10Royal Mail5300Special delivery courierg144.00
2026-03-12NCP5601Parking chargesv18.00
2026-03-14Uber5600Taxi to client siteh24.00
2026-03-14Costa Coffee5600Client meeting refreshmentsh12.00
2026-03-15Shell5601Fuel for company vehiclev150.00
2026-03-15Royal Mail5501Postageg12.00
2026-03-16WHSmith5501Magazines and stationeryg24.00
2026-03-18ElectroParts5000Specialist electronic componentss300.00
2026-03-18Jet5601Fuel for company vehiclev96.00
2026-03-20BT Business5501Telephone line rentalg60.00
2026-03-21Greggs5600Working lunchh8.00
2026-03-22Screwfix5401Miscellaneous suppliesy18.00
2026-03-22Halfords5601Vehicle maintenance suppliesv60.00
2026-03-25EnergySupply5201Quarterly utility billp360.00
2026-03-25Wilko5401Cleaning and kitchen suppliesy15.00
2026-03-25Mileage claim5601Business mileage to Variousv58.50130.00
2026-03-28Shell5601Additional fuel purchasev120.00
2026-03-31Smith & Co5800Monthly accountancy retainerl300.00
2026-03-31Directors loan5803Directors loan interestl125.00PUR-INT-004
Bank and cash entries: 150 entries, 735,104.57
Apr
DateAccountSourceDescriptionCodeAmountDirectionReference
2025-04-011200Opening balanceCurrent account opening balanceBC25,000.00inBNK-0001
2025-04-011200WorkSpace LtdOffice rent paymentCR1,200.00outBNK-CR-001
2025-04-011200DirectorDirectors loan repaymentDL1,000.00outBNK-DL-001
2025-04-051200Various suppliersAggregate supplier paymentsCR2,200.00outBNK-CR-MISC-001
2025-04-101200Acme CorpOpening debtor receiptDR7,200.00inBNK-DR-037
2025-04-151200Beta SystemsOpening debtor receiptDR1,200.00inBNK-DR-038
2025-04-191200HMRCMonthly PAYE/NI paymentRP1,673.20outBNK-RP-001
2025-04-201200Acme CorpCustomer receiptDR8,000.00inBNK-DR-001
2025-04-251200TechStart LtdCustomer receiptDR2,400.00inBNK-DR-013
2025-04-251200Gamma LtdOpening debtor receiptDR2,400.00inBNK-DR-039
2025-04-281200Various customersAggregate customer receiptsDR23,000.00inBNK-DR-025
2025-04-281200PayrollMonthly net wages (all staff)W5,652.00outBNK-W-001
2025-04-301200Smith & CoAccountancy fee paymentCR300.00outBNK-CR-013
2025-04-301200Credit card paymentPay credit card balanceX500.00outBNK-X-CC-001
2025-04-011220Opening balanceCash float opening balanceBC500.00inBNK-CASH-001
2025-04-101220Corner shopMilk and teaCR15.00outBNK-CASH-003
May
DateAccountSourceDescriptionCodeAmountDirectionReference
2025-05-011200WorkSpace LtdOffice rent paymentCR1,200.00outBNK-CR-002
2025-05-011200DirectorDirectors loan repaymentDL1,000.00outBNK-DL-002
2025-05-051200Various suppliersAggregate supplier paymentsCR2,800.00outBNK-CR-MISC-002
2025-05-191200HMRCMonthly PAYE/NI paymentRP1,673.20outBNK-RP-002
2025-05-201200Acme CorpCustomer receiptDR8,000.00inBNK-DR-002
2025-05-251200HSBCBank chargesB25.00outBNK-B-001
2025-05-251200TechStart LtdCustomer receiptDR2,400.00inBNK-DR-014
2025-05-281200Various customersAggregate customer receiptsDR22,520.00inBNK-DR-026
2025-05-281200PayrollMonthly net wages (all staff)W5,652.00outBNK-W-002
2025-05-311200Smith & CoAccountancy fee paymentCR300.00outBNK-CR-014
2025-05-071200HMRCVAT payment, prior year fourth quarterRV1,500.00outBNK-RV-VAT-000
Jun
DateAccountSourceDescriptionCodeAmountDirectionReference
2025-06-011200WorkSpace LtdOffice rent paymentCR1,200.00outBNK-CR-003
2025-06-011200DirectorDirectors loan repaymentDL1,000.00outBNK-DL-003
2025-06-051200Various suppliersAggregate supplier paymentsCR2,500.00outBNK-CR-MISC-003
2025-06-101200Cash top-upTransfer to cash floatX100.00outBNK-BC-001
2025-06-191200HMRCMonthly PAYE/NI paymentRP1,673.20outBNK-RP-003
2025-06-201200Acme CorpCustomer receiptDR8,000.00inBNK-DR-003
2025-06-251200TechStart LtdCustomer receiptDR2,400.00inBNK-DR-015
2025-06-281200Various customersAggregate customer receiptsDR24,800.00inBNK-DR-027
2025-06-281200PayrollMonthly net wages (all staff)W5,652.00outBNK-W-003
2025-06-301200Directors loan interestQuarterly loan interest paymentB250.00outBNK-B-INT-001
2025-06-301200Smith & CoAccountancy fee paymentCR300.00outBNK-CR-015
2025-06-011200Close Brothers Asset FinanceHP-2025-01 admin charges and interestB2,000.00outBNK-HP-INT-001
2025-06-011200Close Brothers Asset FinanceHP-2025-01 capital repaymentCR13,000.00outBNK-HP-CAP-001
2025-06-101220Cash top-upCash float replenishmentBB100.00inBNK-CASH-002
2025-06-101220WH SmithEnvelopes and stampsCR25.00outBNK-CASH-004
Jul
DateAccountSourceDescriptionCodeAmountDirectionReference
2025-07-011200WorkSpace LtdOffice rent paymentCR1,200.00outBNK-CR-004
2025-07-011200DirectorDirectors loan repaymentDL1,000.00outBNK-DL-004
2025-07-051200Various suppliersAggregate supplier paymentsCR2,300.00outBNK-CR-MISC-004
2025-07-151200ProprietorQuarterly drawings paymentDL3,000.00outBNK-DV-001
2025-07-191200HMRCMonthly PAYE/NI paymentRP1,673.20outBNK-RP-004
2025-07-191200HMRCCIS deduction remittanceRC1,000.00outBNK-RC-CIS-001
2025-07-201200Acme CorpCustomer receiptDR8,000.00inBNK-DR-004
2025-07-251200TechStart LtdCustomer receiptDR2,400.00inBNK-DR-016
2025-07-281200Various customersAggregate customer receiptsDR23,360.00inBNK-DR-028
2025-07-281200PayrollMonthly net wages (all staff)W5,652.00outBNK-W-004
2025-07-311200Smith & CoAccountancy fee paymentCR300.00outBNK-CR-016
2025-07-311200Credit card paymentPay credit card balanceX300.00outBNK-X-CC-002
Aug
DateAccountSourceDescriptionCodeAmountDirectionReference
2025-08-071200HMRCVAT payment Q1 Apr-JunRV13,808.17outBNK-RV-VAT-001
2025-08-011200WorkSpace LtdOffice rent paymentCR1,200.00outBNK-CR-005
2025-08-011200DirectorDirectors loan repaymentDL1,000.00outBNK-DL-005
2025-08-051200Various suppliersAggregate supplier paymentsCR2,600.00outBNK-CR-MISC-005
2025-08-051200Innovate UKGrant receivedDR2,500.00inBNK-RV-001
2025-08-191200HMRCMonthly PAYE/NI paymentRP1,673.20outBNK-RP-005
2025-08-201200Acme CorpCustomer receiptDR8,000.00inBNK-DR-005
2025-08-251200TechStart LtdCustomer receiptDR2,400.00inBNK-DR-017
2025-08-281200Various customersAggregate customer receiptsDR25,620.00inBNK-DR-029
2025-08-281200PayrollMonthly net wages (all staff)W5,652.00outBNK-W-005
2025-08-311200Smith & CoAccountancy fee paymentCR300.00outBNK-CR-017
Sep
DateAccountSourceDescriptionCodeAmountDirectionReference
2025-09-011200WorkSpace LtdOffice rent paymentCR1,200.00outBNK-CR-006
2025-09-011200DirectorDirectors loan repaymentDL1,000.00outBNK-DL-006
2025-09-051200Various suppliersAggregate supplier paymentsCR2,100.00outBNK-CR-MISC-006
2025-09-191200HMRCMonthly PAYE/NI paymentRP1,673.20outBNK-RP-006
2025-09-201200Acme CorpCustomer receiptDR8,000.00inBNK-DR-006
2025-09-251200TechStart LtdCustomer receiptDR2,400.00inBNK-DR-018
2025-09-281200Various customersAggregate customer receiptsDR23,360.00inBNK-DR-030
2025-09-281200PayrollMonthly net wages (all staff)W5,652.00outBNK-W-006
2025-09-301200Directors loan interestQuarterly loan interest paymentB208.00outBNK-B-INT-002
2025-09-301200Smith & CoAccountancy fee paymentCR300.00outBNK-CR-018
2025-09-011200Close Brothers Asset FinanceHP-2025-02 admin charges and interestB1,100.00outBNK-HP-INT-002
2025-09-011200Close Brothers Asset FinanceHP-2025-02 capital repaymentCR7,000.00outBNK-HP-CAP-002
2025-09-051220Corner shopKitchen suppliesCR18.00outBNK-CASH-005
Oct
DateAccountSourceDescriptionCodeAmountDirectionReference
2025-10-011200WorkSpace LtdOffice rent paymentCR1,200.00outBNK-CR-007
2025-10-011200DirectorDirectors loan repaymentDL1,000.00outBNK-DL-007
2025-10-011200HMRCCorporation Tax prior yearRT4,500.00outBNK-RT-CT-001
2025-10-051200Various suppliersAggregate supplier paymentsCR3,000.00outBNK-CR-MISC-007
2025-10-151200Private buyerVan sale proceedsDR15,000.00inBNK-DR-040
2025-10-151200ProprietorQuarterly drawings paymentDL3,000.00outBNK-DV-002
2025-10-191200HMRCMonthly PAYE/NI paymentRP1,673.20outBNK-RP-007
2025-10-201200Acme CorpCustomer receiptDR8,000.00inBNK-DR-007
2025-10-251200FordFord Transit Custom purchaseCR36,000.00outBNK-CR-FA-001
2025-10-251200TechStart LtdCustomer receiptDR2,400.00inBNK-DR-019
2025-10-281200Various customersAggregate customer receiptsDR25,160.00inBNK-DR-031
2025-10-281200PayrollMonthly net wages (all staff)W5,652.00outBNK-W-007
2025-10-311200Smith & CoAccountancy fee paymentCR300.00outBNK-CR-019
2025-10-311200Credit card paymentPay credit card balanceX500.00outBNK-X-CC-003
Nov
DateAccountSourceDescriptionCodeAmountDirectionReference
2025-11-071200HMRCVAT payment Q2 Jul-SepRV14,456.50outBNK-RV-VAT-002
2025-11-011200WorkSpace LtdOffice rent paymentCR1,200.00outBNK-CR-008
2025-11-011200DirectorDirectors loan repaymentDL1,000.00outBNK-DL-008
2025-11-051200Various suppliersAggregate supplier paymentsCR2,400.00outBNK-CR-MISC-008
2025-11-191200HMRCMonthly PAYE/NI paymentRP1,673.20outBNK-RP-008
2025-11-201200Acme CorpCustomer receiptDR8,000.00inBNK-DR-008
2025-11-251200HSBCBank chargesB25.00outBNK-B-002
2025-11-251200TechStart LtdCustomer receiptDR2,400.00inBNK-DR-020
2025-11-281200Various customersAggregate customer receiptsDR24,920.00inBNK-DR-032
2025-11-281200PayrollMonthly net wages (all staff)W5,652.00outBNK-W-008
2025-11-301200Smith & CoAccountancy fee paymentCR300.00outBNK-CR-020
Dec
DateAccountSourceDescriptionCodeAmountDirectionReference
2025-12-011200WorkSpace LtdOffice rent paymentCR1,200.00outBNK-CR-009
2025-12-011200DirectorDirectors loan repaymentDL1,000.00outBNK-DL-009
2025-12-051200Various suppliersAggregate supplier paymentsCR2,700.00outBNK-CR-MISC-009
2025-12-191200HMRCMonthly PAYE/NI paymentRP1,673.20outBNK-RP-009
2025-12-191200HMRCCIS deduction remittanceRC600.00outBNK-RC-CIS-002
2025-12-201200Acme CorpCustomer receiptDR8,000.00inBNK-DR-009
2025-12-251200TechStart LtdCustomer receiptDR2,400.00inBNK-DR-021
2025-12-281200Various customersAggregate customer receiptsDR22,400.00inBNK-DR-033
2025-12-281200PayrollMonthly net wages (all staff)W5,652.00outBNK-W-009
2025-12-311200Directors loan interestQuarterly loan interest paymentB167.00outBNK-B-INT-003
2025-12-311200Smith & CoAccountancy fee paymentCR300.00outBNK-CR-021
2025-12-101220VariousChristmas team refreshmentsCR50.00outBNK-CASH-006
Jan
DateAccountSourceDescriptionCodeAmountDirectionReference
2026-01-011200WorkSpace LtdOffice rent paymentCR1,200.00outBNK-CR-010
2026-01-011200DirectorDirectors loan repaymentDL1,000.00outBNK-DL-010
2026-01-051200Various suppliersAggregate supplier paymentsCR2,500.00outBNK-CR-MISC-010
2026-01-151200Director loanDirectors loan advanceDL5,000.00inBNK-DL-IN-001
2026-01-151200ProprietorQuarterly drawings paymentDL3,000.00outBNK-DV-003
2026-01-191200HMRCMonthly PAYE/NI paymentRP1,673.20outBNK-RP-010
2026-01-201200Acme CorpCustomer receiptDR8,000.00inBNK-DR-010
2026-01-251200TechStart LtdCustomer receiptDR2,400.00inBNK-DR-022
2026-01-281200Various customersAggregate customer receiptsDR25,040.00inBNK-DR-034
2026-01-281200PayrollMonthly net wages (all staff)W5,652.00outBNK-W-010
2026-01-311200Smith & CoAccountancy fee paymentCR300.00outBNK-CR-022
2026-01-311200Credit card paymentPay credit card balanceX300.00outBNK-X-CC-004
Feb
DateAccountSourceDescriptionCodeAmountDirectionReference
2026-02-071200HMRCVAT payment Q3 Oct-DecRV10,917.50outBNK-RV-VAT-003
2026-02-011200WorkSpace LtdOffice rent paymentCR1,200.00outBNK-CR-011
2026-02-011200DirectorDirectors loan repaymentDL1,000.00outBNK-DL-011
2026-02-051200Various suppliersAggregate supplier paymentsCR2,900.00outBNK-CR-MISC-011
2026-02-191200HMRCMonthly PAYE/NI paymentRP1,673.20outBNK-RP-011
2026-02-201200Acme CorpCustomer receiptDR8,000.00inBNK-DR-011
2026-02-251200TechStart LtdCustomer receiptDR2,400.00inBNK-DR-023
2026-02-281200Smith & CoAccountancy fee paymentCR300.00outBNK-CR-023
2026-02-281200Various customersAggregate customer receiptsDR23,960.00inBNK-DR-035
2026-02-281200PayrollMonthly net wages (all staff)W5,652.00outBNK-W-011
Mar
DateAccountSourceDescriptionCodeAmountDirectionReference
2026-03-011200WorkSpace LtdOffice rent paymentCR1,200.00outBNK-CR-012
2026-03-011200DirectorDirectors loan repaymentDL1,000.00outBNK-DL-012
2026-03-051200Various suppliersAggregate supplier paymentsCR2,300.00outBNK-CR-MISC-012
2026-03-151200Internal transferTransfer to savings accountX5,000.00outBNK-X-001
2026-03-191200HMRCMonthly PAYE/NI paymentRP1,673.20outBNK-RP-012
2026-03-201200Acme CorpCustomer receiptDR8,000.00inBNK-DR-012
2026-03-251200TechStart LtdCustomer receiptDR2,400.00inBNK-DR-024
2026-03-281200Various customersAggregate customer receiptsDR10,560.00inBNK-DR-036
2026-03-281200PayrollMonthly net wages (all staff)W5,652.00outBNK-W-012
2026-03-311200Directors loan interestQuarterly loan interest paymentB125.00outBNK-B-INT-004
2026-03-311200Smith & CoAccountancy fee paymentCR300.00outBNK-CR-024
2026-03-311200ProprietorQuarterly drawings paymentDL6,000.00outBNK-DV-004
2026-03-201220NewsagentNewspapers for receptionCR12.00outBNK-CASH-007

Payroll

EmployeeIDNameRoleGrossPayPayFrequencyTaxCodeNiCategoryStartDateIsDirector
EMP001Alice JohnsonSenior Developer3,500.00monthly1257LA2024-01-15no
EMP002Bob WilliamsSupport Technician2,200.00monthly1257LA2024-06-01no
EMP003Carol SmithDirector1,048.00monthly1257LA2020-01-01yes

Opening and closing balances

Stock
ItemValue
Opening10,000.00
Closing6,000.00
Opening debtors
CustomerInvoiceAmount
Acme CorpINV-09017,200.00
Beta SystemsINV-09021,200.00
Gamma LtdINV-09032,400.00
Closing debtors
CustomerInvoiceAmount
Acme CorpINV-10126,100.00
WidgetWorksINV-21041,440.00
Zeta CorpCN-1801360.00
Opening creditors
SupplierInvoiceAmount
WorkSpace LtdWS-24031,200.00
Smith & CoSC-2403300.00
TechParts LtdTP-2403600.00
ShellSH-2403120.00
Closing creditors
SupplierInvoiceAmount
WorkSpace LtdWS-26031,200.00
Smith & CoSC-2603300.00
BT BusinessBT-260360.00
ShellSH-2603150.00
Opening fixed assets
DescriptionCategoryCostAcc depTax wdv
Van (2.5 years old)motor30,000.009,828.0024,000.00
Laptop (0.5 years old)computer3,000.00270.00

Screenshots

Profit and loss account sheet of the populated workbook
Profit and loss account — Financialaccounts.xlsx, sheet Profit & Loss Account
Income tax calculation sheet of the populated workbook
Income tax calculation — Financialaccounts.xlsx, sheet Income Tax
Self assessment short pages sheet of the populated workbook
Self assessment short pages — Financialaccounts.xlsx, sheet SE Short
VAT return, quarter 1 sheet of the populated workbook
VAT return, quarter 1 — Vat.xlsx, sheet VATQtr1
Fixed asset schedule sheet of the populated workbook
Fixed asset schedule — Fixedassets.xlsx, sheet Schedule

Accounting statements

Accounting profit to tax profit bridge

LineCellAmount
Profit before tax per the profit and loss accountProfit & Loss Account!B39171,773.02
Add depreciation charged in the accountsProfit & Loss Account!B3413,740
Less grants, taxed as other business income belowProfit & Loss Account!B11-2,083.33
Less annual investment allowance (box 23)SE Short!D80-52,500
Less small-balance allowance (box 24)SE Short!D850
Less other capital allowances (box 25)SE Short!O80-11,500
Add balancing charges (box 26)SE Short!O850
Add goods and services for own use (box 27)SE Short!D940
Less the full return's own box 62 adjustmentSE Full!D1790
Add back the year's loss, carried forward rather than reducing tax below nilSE Full!O1790
Less loss brought forward (box 29)SE Short!O940
Add grants as other business income (box 30)SE Short!O992,083.33
Tax profit the bridge computes121,513.02
Tax profit the sheet carriesIncome Tax!E5121,513.02
Residue0

Journal category VAT netting

Journal amounts include VAT at 20%.

Journal categoryGross per the journalVAT strippedNetWhere the net landsFigure thereResidue
Sales Product A (sales a)373,92062,320311,600Profit & Loss Account!B5311,6000
Sales Product B (sales b)16,3202,72013,600Profit & Loss Account!B613,6000
Sales Product C (sales c)12,3602,06010,300Profit & Loss Account!B710,3000
Other Income (sales d)4,4407403,700Profit & Loss Account!B83,7000
Investment Grants received (sales g)2,500416.672,083.33Profit & Loss Account!B112,083.330
Bad Debts written off (sales o)36060300Profit & Loss Account!B29 negated3000
Sub contractors (purchases c)8,0001,333.336,666.67Profit & Loss Account!B156,666.670
Other Direct Cost of Sales (purchases o)4,8248044,020Profit & Loss Account!B164,0200
Premises Rent Rates Power (purchases p)15,8402,64013,200Profit & Loss Account!B2213,2000
Repairs & Maintenance (purchases m)1,140190950Profit & Loss Account!B239500
General Administrative Expenses (purchases g)3,6426073,035Profit & Loss Account!B243,0350
Motor Expenses (purchases v)7,598.251,1646,434.25Profit & Loss Account!B256,434.250
Travel Hotel & Subsistence (purchases h)1,8603101,550Profit & Loss Account!B261,5500
Advertising & Promotion (purchases a)4,5607603,800Profit & Loss Account!B273,8000
Legal & Professional Fees (purchases l)8,3101,3856,925Profit & Loss Account!B286,9250
Other Expenses (purchases y)3,878646.333,231.67Profit & Loss Account!B323,231.670
Purchases after stock adjustment, less the year's stock movement (purchases s)6,5401,0905,450Profit & Loss Account!B14 less the stock movement5,4500
Capitalised fixed asset spend (purchases fa)63,00010,50052,500Fixedassets.xlsx!FAreconciliation!E1152,5000
Fixed asset disposal proceeds (sales fs)15,0002,50012,500Fixedassets.xlsx!FAreconciliation!K1112,5000

Business Details

Amount
Business NamePrecision Code Trading

Profit & Loss Account

Amount
    Product A sales (code a)311,600
    Product B sales (code b)13,600
    Product C sales (code c)10,300
    Other Income3,700
Sales Turnover339,200
    Grants Received2,083.33
    Materials / Stock9,450
    Sub-Contractors6,666.67
    Other Direct Costs4,020
Cost of Sales20,136.67
Gross Profit321,146.67
    Wages & Salaries92,735.73
    Premises Rent Rates Power13,200
    Repairs & Maintenance950
    General Admin3,035
    Motor Expenses6,434.25
    Travel & Subsistence1,550
    Advertising3,800
    Legal & Professional6,925
    Bad Debts-300
    Bank Interest Paid0
    HP Interest, Lease, Bank Charges3,900
    Other Expenses3,231.67
    Loss (Profit) on Disposal of Assets172
    Depreciation13,740
Total Admin Expenses149,373.65
Operating Profit171,773.02
Profit Before Tax171,773.02

Profit Forecast

Amount
    Months of actual trade12
    Forecast Sales Turnover339,200
    Forecast Investment Grants2,083.33
    Forecast Cost of Sales20,136.67
    Forecast General Expenses149,373.65
    Forecast Interest Received0
Forecast Profit before Tax171,773.02
    Add Depreciation13,912
    Less Capital Allowances64,000
    Profit before Tax121,685.02
    Personal Allowance1,727.49
    Profit after Allowance119,957.53
    Tax at standard rate7,540
    Tax at higher rate32,903.01
    Tax at additional rate0
    National Insurance3,690.3
Forecast Tax & NI Liability44,133.31

Payroll Summary

Amount
    Apr Gross Pay6,748
    May Gross Pay6,748
    Jun Gross Pay6,748
    Jul Gross Pay6,748
    Aug Gross Pay6,748
    Sep Gross Pay6,748
    Oct Gross Pay6,748
    Nov Gross Pay6,748
    Dec Gross Pay6,748
    Jan Gross Pay6,748
    Feb Gross Pay6,748
    Mar Gross Pay6,748
    Apr PAYE800
    Apr Employer NI577.2

Quarterly Summary

Amount
Sales here are the three product lines only (Profit & Loss Account rows 5 to 7), and expenses are the direct cost lines only (Materials and Other Direct Cost of Sales).
Grants, other income and every administrative expense are outside this summary and appear in the profit and loss account and on the SA103S.
    Q1 Sales83,900
    Q2 Sales83,000
    Q3 Sales85,700
    Q4 Sales82,900
Annual Sales335,500
    Q1 Expenses2,282.5
    Q2 Expenses2,602.5
    Q3 Expenses2,182.5
    Q4 Expenses6,402.5
Annual Expenses13,470

Admin (Generator Injected)

Amount
Personal Allowance12,570
Personal Allowance Taper Threshold100,000
Basic Rate0.2
Higher Rate0.4
Additional Rate0.45
Basic Band End37,700
Higher Band Start37,701
Higher Band End125,140
NI Class 2 Weekly Rate3.65
NI Class 2 Small Profits Threshold7,105
NI Class 4 Lower Rate0.06
NI Class 4 Lower Limit12,570
NI Class 4 Upper Rate0.02
NI Class 4 Upper Limit50,270
Annual Investment Allowance Rate1
Writing Down Allowance Rate0.14
Mileage Higher Rate Limit10,000
Mileage Higher Rate Pence0.45
Mileage Lower Rate Start10,001
Mileage Lower Rate Pence0.25
VAT Registration Threshold90,000
VAT Standard Rate0.2

Fixed Asset Schedule

Amount
    Cost brought forward (Schedule E57)33,000
    Additions in the year (Schedule E110)52,500
    Cost of the assets sold in the year (Schedule W1)30,000
Cost carried forward, disposals removed55,500
    Accumulated depreciation brought forward (Schedule F1)10,098
    Depreciation charged for the year (Schedule I1)13,740
    Accumulated depreciation on the assets sold (Schedule X1)17,328
Accumulated depreciation carried forward, disposals removed6,510
Net book value at the year end (Schedule K1)48,990
    Sale proceeds of the assets sold, net of VAT (Schedule V1)12,500
    Net book value of the assets sold at the date of sale12,672

VAT Returns

Amount
    Sales invoiced including VAT424,900
    VAT charged on sales70,816.67
    Sales net of VAT354,083.33
    Purchases invoiced including VAT134,992.25
    VAT reclaimed on purchases22,396.33
    Purchases net of VAT112,595.92
VAT due for the year48,420.33
How the return periods line up with the accounting year
    Q1 covers the periods ending30 April 2026, 31 May 2026, 30 June 2026
    Q2 covers the periods ending31 July 2026, 31 August 2026, 30 September 2026
    Q3 covers the periods ending31 October 2026, 30 November 2026, 31 December 2026
    Q4 covers the periods ending31 January 2027, 28 February 2027, 31 March 2027
    Q5 covers the periods ending30 April 2027, 31 May 2027, 30 June 2027
The returns above also cover the periods ending 30 April 2027, 31 May 2027, 30 June 2027, which fall outside the accounting year.
    Output VAT on those1,100
    Input VAT on those180
The return forms as the package fills them in
    Q1 (period ending 30 June 2026) box 1: VAT due on sales16,920
    Q1 (period ending 30 June 2026) box 4: VAT reclaimed on purchases5,993.5
    Q1 (period ending 30 June 2026) box 5: net VAT due10,926.5
    Q2 (period ending 30 September 2026) box 1: VAT due on sales17,256.67
    Q2 (period ending 30 September 2026) box 4: VAT reclaimed on purchases4,451.5
    Q2 (period ending 30 September 2026) box 5: net VAT due12,805.17
    Q3 (period ending 31 December 2026) box 1: VAT due on sales19,780
    Q3 (period ending 31 December 2026) box 4: VAT reclaimed on purchases9,867
    Q3 (period ending 31 December 2026) box 5: net VAT due9,913
    Q4 (period ending 31 March 2027) box 1: VAT due on sales16,860
    Q4 (period ending 31 March 2027) box 4: VAT reclaimed on purchases2,084.33
    Q4 (period ending 31 March 2027) box 5: net VAT due14,775.67
    Q5 (period ending 30 June 2027) box 1: VAT due on sales1,100
    Q5 (period ending 30 June 2027) box 4: VAT reclaimed on purchases180
    Q5 (period ending 30 June 2027) box 5: net VAT due920
Cell values behind these statements
Business Details
CellDIY LabelValuediya-gl mapping
C5Business NamePrecision Code TradingentityInformation.organizationIdentifier
Profit & Loss Account
CellDIY LabelValuediya-gl mapping
B5Product A sales (code a)311600accounts.sales.4000
B6Product B sales (code b)13600accounts.sales.4001
B7Product C sales (code c)10300accounts.sales.4002
B8Other Income3700accounts.sales.4003
B9Sales Turnover339200gl-cor:amount (salesTurnover)
B11Grants Received2083.33333333333accounts.sales.4004
B14Materials / Stock9450accounts.purchases.5000
B15Sub-Contractors6666.66666666667accounts.purchases.5001
B16Other Direct Costs4020accounts.purchases.5002
B17Cost of Sales20136.6666666667gl-cor:amount (costOfSales)
B19Gross Profit321146.666666666gl-cor:amount (grossProfit)
B21Wages & Salaries92735.7333333333accounts.purchases.5101
B22Premises Rent Rates Power13200accounts.purchases.5201
B23Repairs & Maintenance950accounts.purchases.5400
B24General Admin3035accounts.purchases.5501
B25Motor Expenses6434.25accounts.purchases.5601
B26Travel & Subsistence1550accounts.purchases.5600
B27Advertising3800accounts.purchases.5500
B28Legal & Professional6925accounts.purchases.5800
B29Bad Debts-300accounts.sales.4005
B30Bank Interest Paid0accounts.purchases.5701
B31HP Interest, Lease, Bank Charges3900accounts.purchases.5702
B32Other Expenses3231.66666666666accounts.purchases (other)
B33Loss (Profit) on Disposal of Assets172gl-cor:amount (lossOnDisposal)
B34Depreciation13740gl-cor:amount (depreciation)
B35Total Admin Expenses149373.65gl-cor:amount (totalAdmin)
B37Operating Profit171773.016666666gl-cor:amount (operatingProfit)
B39Profit Before Tax171773.016666666gl-cor:amount (profitBeforeTax)
C525333.3333333333
D525633.3333333333
E526533.3333333333
F525633.3333333333
G527133.3333333333
H525033.3333333333
I527133.3333333333
J525633.3333333333
K526533.3333333333
L525633.3333333333
M526333.3333333333
N525033.3333333333
C61800
D6800
E6800
F61800
G6800
H6800
I61800
J6800
K6800
L61800
M6800
N6800
C70
D71000
E72000
F70
G70
H71800
I70
J73000
K70
L71000
M71500
N70
C8700
D80
E80
F8700
G80
H8500
I8700
J80
K80
L81100
M80
N80
C110
D110
E110
F110
G112083.33333333333
H110
I110
J110
K110
L110
M110
N110
C290
D290
E290
F290
G290
H290
I290
J290
K290
L290
M290
N29-300
C150
D150
E154166.66666666667
F150
G150
H150
I150
J152500
K150
L150
M150
N150
C16237.5
D16407.5
E16237.5
F16607.5
G16237.5
H16507.5
I16237.5
J16207.5
K16237.5
L16357.5
M16537.5
N16207.5
C221000
D221000
E221300
F221000
G221000
H221250
I221000
J221000
K221350
L221000
M221000
N221300
C23100
D230
E230
F23150
G23200
H230
I2380
J230
K230
L23120
M23300
N230
C24262.5
D24277.5
E24192.5
F24382.5
G24112.5
H24202.5
I24262.5
J24337.5
K24212.5
L24427.5
M24112.5
N24252.5
C25508.25
D25564
E25560
F25490.25
G25508.25
H25602
I25512.75
J25551
K25519.5
L25538.25
M25501.5
N25578.5
C2676.6666666666667
D26126.666666666667
E26226.666666666667
F2676.6666666666667
G26116.666666666667
H2676.6666666666667
I26176.666666666667
J26136.666666666667
K2676.6666666666667
L2676.6666666666667
M26306.666666666667
N2676.6666666666667
C270
D27500
E270
F27400
G270
H270
I272500
J270
K270
L27400
M270
N270
C28250
D28250
E28458.333333333333
F282750
G28250
H281223.33333333333
I28250
J28250
K28389.166666666667
L28250
M28250
N28354.166666666667
C321330.83333333333
D3295.8333333333333
E32120.833333333333
F3295.8333333333333
G32135.833333333333
H3295.8333333333333
I32425.833333333333
J3295.8333333333333
K32532.5
L3295.8333333333333
M32110.833333333333
N3295.8333333333333
C3314.3333333333333
D3314.3333333333333
E3314.3333333333333
F3314.3333333333333
G3314.3333333333333
H3314.3333333333333
I3314.3333333333333
J3314.3333333333333
K3314.3333333333333
L3314.3333333333333
M3314.3333333333333
N3314.3333333333333
C341145
D341145
E341145
F341145
G341145
H341145
I341145
J341145
K341145
L341145
M341145
N341145
C927833.3333333333
D927433.3333333333
E929333.3333333333
F928133.3333333333
G927933.3333333333
H928133.3333333333
I929633.3333333333
J929433.3333333333
K927333.3333333333
L929533.3333333333
M928633.3333333333
N925833.3333333333
B380
C380
D380
E380
F380
G380
H380
I380
J380
K380
L380
M380
N380
Income Tax
CellDIY LabelValuediya-gl mapping
E5Profit from Self Employment121513.016666666gl-cor:amount (profitSE)
E6Less: Personal Allowance1813.49166666687tax.incomeTax.personalAllowance
E7Taxable Income119699.524999999gl-cor:amount (taxableIncome)
E8Tax at Basic Rate (20%)7540tax.incomeTax.basicRate
C9Basic band ceiling the sheet applies37700tax.incomeTax.basicBandEnd (applied)
E9Tax at Higher Rate (40%)32799.8099999998tax.incomeTax.higherRate
C10Additional rate threshold the sheet applies125140tax.incomeTax.higherBandEnd (applied)
D10Additional rate the sheet applies0.45tax.incomeTax.additionalRate (applied)
E10Tax at Additional Rate (45%)0tax.incomeTax.additionalRate
E11Total Income Tax40339.8099999998tax.incomeTax (total)
E12Less: CIS Deducted0diya-gl:cisDeduction (total)
E15NI Class 4 (lower band)2262tax.nationalInsurance.class4MainRate
E16NI Class 4 (upper band)1424.86033333333tax.nationalInsurance.class4UpperRate
E18Total Tax + NI44026.6703333331gl-cor:taxAmount (totalTaxNI)
Profit Forecast
CellDIY LabelValuediya-gl mapping
C21Months of actual trade12gl-cor:amount (forecast.monthsTraded)
C22Forecast Sales Turnover339200gl-cor:amount (forecast.turnover)
C24Forecast Investment Grants2083.33333333333gl-cor:amount (forecast.grants)
C26Forecast Cost of Sales20136.6666666667gl-cor:amount (forecast.costOfSales)
C30Forecast General Expenses149373.65gl-cor:amount (forecast.expenses)
C33Forecast Interest Received0gl-cor:amount (forecast.interest)
C34Forecast Profit before Tax171773.016666666gl-cor:amount (forecast.profit)
C37Add Depreciation13912gl-cor:amount (depreciation)
C38Less Capital Allowances64000tax.capitalAllowances (schedule)
C39Profit before Tax121685.016666666gl-cor:amount (forecast.taxableProfit)
C40Personal Allowance1727.49166666687tax.incomeTax.personalAllowance
C41Profit after Allowance119957.524999999gl-cor:amount (forecast.taxableIncome)
C42Tax at standard rate7540tax.incomeTax.basicRate
C43Tax at higher rate32903.0099999998tax.incomeTax.higherRate
C44Tax at additional rate0tax.incomeTax.additionalRate
C45National Insurance3690.30033333333tax.nationalInsurance.class4
C46Forecast Tax & NI Liability44133.3103333331gl-cor:taxAmount (forecast.totalTaxNI)
SE Short
CellDIY LabelValuediya-gl mapping
C8Business namePrecision Code TradingentityInformation.organizationIdentifier
S17Accounting date46118documentInfo.periodCoveredEnd
D38Turnover339200gl-cor:amount (sa103s.turnover)
O38Other business income0gl-cor:amount (sa103s.otherIncome)
D46Cost of sales20136.6666666667gl-cor:amount (sa103s.costOfSales)
D51Car, van and travel7984.25gl-cor:amount (sa103s.travel)
D55Employee costs92735.7333333333gl-cor:amount (sa103s.employeeCosts)
D60Premises costs13200gl-cor:amount (sa103s.premises)
D64Repairs and renewals950gl-cor:amount (sa103s.repairs)
O46Accountancy, legal and professional6925gl-cor:amount (sa103s.legal)
O51Interest and bank charges3900gl-cor:amount (sa103s.interest)
O55Phone, stationery and office costs3035gl-cor:amount (sa103s.office)
O60Other business expenses6903.66666666666gl-cor:amount (sa103s.otherExpenses)
O64Total expenses155770.316666667gl-cor:amount (sa103s.totalExpenses)
D71Net profit/loss183429.683333333gl-cor:amount (sa103s.netProfit)
O71Net loss (box 22)0gl-cor:amount (sa103s.netLoss)
D80Capital allowances52500tax.capitalAllowances (sa103s)
D85AIA / WDA claimed0tax.capitalAllowances.aia (sa103s)
O80Other capital allowances (box 25)11500tax.capitalAllowances.wda (sa103s)
O85Balancing charges (box 26)0tax.capitalAllowances.balancingCharge (sa103s)
D94Other tax adjustments0gl-cor:amount (sa103s.otherAdjust)
D99Net business profit (box 28)119429.683333333gl-cor:amount (sa103s.taxableProfit)
O94Loss brought forward (box 29)0gl-cor:amount (sa103s.lossBroughtForward)
O99Grants as other business income (box 30)2083.33333333333gl-cor:amount (sa103s.otherBusinessIncome)
A33Turnover noteSELF-EMPLOYMENT FULL RETURN REQUIRED AS TURNOVER EXCEEDS £90000 VAT thresholdgl-cor:detailComment (sa103s.notes)
D106Net profit for tax calc (box 31)121513.016666666gl-cor:amount (sa103s.profitForTax)
O106Net loss for tax calc0gl-cor:amount (sa103s.lossForTax)
D124Total loss to carry forward (box 35)0gl-cor:amount (sa103s.lossCarriedForward)
O124Deductions by contractors (box 38)0diya-gl:cisDeduction (sa103s)
SE Full
CellDIY LabelValuediya-gl mapping
D55Turnover (box 15)339200gl-cor:amount (sa103f.turnover)
O55Other business income (box 16)0gl-cor:amount (sa103f.otherIncome)
D66Goods bought for resale (box 17)13470gl-cor:amount (sa103f.costOfGoods)
D70Subcontractor payments (box 18)6666.66666666667gl-cor:amount (sa103f.subcontractors)
D74Wages, salaries and staff costs (box 19)92735.7333333333gl-cor:amount (sa103f.staffCosts)
D78Car, van and travel expenses (box 20)7984.25gl-cor:amount (sa103f.travel)
D82Rent, rates, power and insurance (box 21)13200gl-cor:amount (sa103f.premises)
D86Repairs and maintenance (box 22)950gl-cor:amount (sa103f.repairs)
D90Phone, stationery and office costs (box 23)3035gl-cor:amount (sa103f.office)
D94Advertising and entertainment (box 24)3800gl-cor:amount (sa103f.advertising)
D98Interest on bank and other loans (box 25)0gl-cor:amount (sa103f.interest)
D102Bank, credit card and finance charges (box 26)3900gl-cor:amount (sa103f.bankCharges)
D106Irrecoverable debts written off (box 27)-300gl-cor:amount (sa103f.badDebts)
D110Accountancy, legal and professional fees (box 28)6925gl-cor:amount (sa103f.legal)
D114Depreciation and loss on sale of assets (box 29)13912gl-cor:amount (sa103f.depreciation)
D118Other business expenses (box 30)3231.66666666666gl-cor:amount (sa103f.otherExpenses)
D122Total expenses (box 31)169510.316666667gl-cor:amount (sa103f.totalExpenses)
O114Disallowable depreciation (box 44)13740gl-cor:amount (sa103f.disallowableDepreciation)
O122Total disallowable expenses (box 46)13740gl-cor:amount (sa103f.totalDisallowable)
D129Net profit (box 47)169689.683333333gl-cor:amount (sa103f.netProfit)
O129Net loss (box 48)0gl-cor:amount (sa103f.netLoss)
D139Annual investment allowance (box 49)52500tax.capitalAllowances.aia (sa103f)
D144Capital allowances at 18% (box 50)3360tax.capitalAllowances.wda (sa103f)
O144100% and other enhanced capital allowances (box 55)0tax.capitalAllowances.enhanced (sa103f)
O149Allowances on sale or cessation (box 56)8140tax.capitalAllowances.balancingAllowance (sa103f)
O154Total capital allowances (box 57)64000tax.capitalAllowances (sa103f)
O160Balancing charge (box 59)0tax.capitalAllowances.balancingCharge (sa103f)
D169Goods and services for own use (box 60)0gl-cor:amount (sa103f.ownUse)
D174Total additions to net profit (box 61)13740gl-cor:amount (sa103f.totalAdditions)
O169Total deductions from net profit (box 63)64000gl-cor:amount (sa103f.totalDeductions)
O174Net business profit for tax purposes (box 64)119429.683333333gl-cor:amount (sa103f.taxableProfit)
O179Net business loss for tax purposes (box 65)0gl-cor:amount (sa103f.taxableLoss)
O194Adjusted profit (box 73)119429.683333333gl-cor:amount (sa103f.adjustedProfit)
O199Loss brought forward set against this year (box 74)0gl-cor:amount (sa103f.lossBroughtForward)
O204Other business income not in boxes 15, 16 or 60 (box 75)2083.33333333333gl-cor:amount (sa103f.otherBusinessIncome)
O210Total taxable profits from this business (box 76)121513.016666666gl-cor:amount (sa103f.profitForTax)
D219Adjusted loss (box 77)0gl-cor:amount (sa103f.adjustedLoss)
O224Total loss to carry forward (box 80)0gl-cor:amount (sa103f.lossCarriedForward)
D231Contractor deductions taken off (box 81)0diya-gl:cisDeduction (sa103f)
G1COPY DETAILS TO HMRC FORM Submit HMRC RETURN ONLINE by 31st January 2028
Q246118
V246482
G1410.14
J28012570
Wagesinterface
CellDIY LabelValuediya-gl mapping
C4Apr Gross Pay6748diya-gl:grossPay (apr)
C5May Gross Pay6748diya-gl:grossPay (may)
C6Jun Gross Pay6748diya-gl:grossPay (jun)
C7Jul Gross Pay6748diya-gl:grossPay (jul)
C8Aug Gross Pay6748diya-gl:grossPay (aug)
C9Sep Gross Pay6748diya-gl:grossPay (sep)
C10Oct Gross Pay6748diya-gl:grossPay (oct)
C11Nov Gross Pay6748diya-gl:grossPay (nov)
C12Dec Gross Pay6748diya-gl:grossPay (dec)
C13Jan Gross Pay6748diya-gl:grossPay (jan)
C14Feb Gross Pay6748diya-gl:grossPay (feb)
C15Mar Gross Pay6748diya-gl:grossPay (mar)
D4Apr PAYE800diya-gl:incomeTax (apr)
H4Apr Employer NI577.2diya-gl:employerNI (apr)
E4296
D5800
E5296
H5577.2
D6800
E6296
H6577.2
D7800
E7296
H7577.2
D8800
E8296
H8577.2
D9800
E9296
H9577.2
D10800
E10296
H10577.2
D11800
E11296
H11577.2
D12800
E12296
H12577.2
D13800
E13296
H13577.2
D14800
E14296
H14577.2
D15800
E15296
H15577.2
VitalTax
CellDIY LabelValuediya-gl mapping
C5Q1 Sales83899.9999999999gl-cor:amount (vitalTax.q1Sales)
D5Q2 Sales82999.9999999999gl-cor:amount (vitalTax.q2Sales)
E5Q3 Sales85699.9999999999gl-cor:amount (vitalTax.q3Sales)
F5Q4 Sales82899.9999999999gl-cor:amount (vitalTax.q4Sales)
G5Annual Sales335500gl-cor:amount (vitalTax.annualSales)
C7Q1 Expenses2282.5gl-cor:amount (vitalTax.q1Exp)
D7Q2 Expenses2602.5gl-cor:amount (vitalTax.q2Exp)
E7Q3 Expenses2182.5gl-cor:amount (vitalTax.q3Exp)
F7Q4 Expenses6402.5gl-cor:amount (vitalTax.q4Exp)
G7Annual Expenses13470gl-cor:amount (vitalTax.annualExp)
Admin
CellDIY LabelValuediya-gl mapping
N4Personal Allowance12570tax.incomeTax.personalAllowance
N5Personal Allowance Taper Threshold100000tax.incomeTax.personalAllowanceTaperThreshold
N6Basic Rate0.2tax.incomeTax.basicRate
N7Higher Rate0.4tax.incomeTax.higherRate
N8Additional Rate0.45tax.incomeTax.additionalRate
M11Basic Band End37700tax.incomeTax.basicRateLimit
N12Higher Band Start37701
N13Higher Band End125140tax.incomeTax.additionalRateThreshold
L16NI Class 2 Weekly Rate3.65tax.nationalInsurance.class2WeeklyRate
N16NI Class 2 Small Profits Threshold7105tax.nationalInsurance.class2SmallProfitsThreshold
L20NI Class 4 Lower Rate0.06tax.nationalInsurance.class4MainRate
N20NI Class 4 Lower Limit12570tax.nationalInsurance.class4LowerProfits
L23NI Class 4 Upper Rate0.02tax.nationalInsurance.class4UpperRate
N23NI Class 4 Upper Limit50270tax.nationalInsurance.class4UpperProfits
G4Annual Investment Allowance Rate1
G5Writing Down Allowance Rate0.14tax.capitalAllowances.mainRateWDA
F21Mileage Higher Rate Limit10000
G21Mileage Higher Rate Pence0.45tax.mileage.carFirst10000
F22Mileage Lower Rate Start10001
G22Mileage Lower Rate Pence0.25tax.mileage.carOver10000
F26VAT Registration Threshold90000tax.vat.registrationThreshold
F27VAT Standard Rate0.2tax.vat.standardRate
B446118
B1746482
B2146783
StockControl
CellDIY LabelValuediya-gl mapping
AB610000
AB306000
Bank.xlsx!Mar
CellDIY LabelValuediya-gl mapping
A1183505.63
A2181215.43
Cash.xlsx!Mar
CellDIY LabelValuediya-gl mapping
A1492
A2480
Sales.xlsx!OpeningDebtors
CellDIY LabelValuediya-gl mapping
G110800
Sales.xlsx!ClosingDebtors
CellDIY LabelValuediya-gl mapping
G17900
Sales.xlsx!Apr
CellDIY LabelValuediya-gl mapping
H15566.66666666667
I127833.3333333333
H220
W10
X10
Sales.xlsx!May
CellDIY LabelValuediya-gl mapping
H15486.66666666667
I127433.3333333333
H220
W10
X10
Sales.xlsx!Jun
CellDIY LabelValuediya-gl mapping
H15866.66666666667
I129333.3333333333
H220
W10
X10
Sales.xlsx!Jul
CellDIY LabelValuediya-gl mapping
H15626.66666666667
I128133.3333333333
H220
W10
X10
Sales.xlsx!Aug
CellDIY LabelValuediya-gl mapping
H16003.33333333333
I130016.6666666667
H220
W10
X10
Sales.xlsx!Sep
CellDIY LabelValuediya-gl mapping
H15626.66666666667
I128133.3333333333
H220
W10
X10
Sales.xlsx!Oct
CellDIY LabelValuediya-gl mapping
H18426.66666666667
I142133.3333333333
H220
W10
X10
Sales.xlsx!Nov
CellDIY LabelValuediya-gl mapping
H15886.66666666667
I129433.3333333333
H220
W10
X10
Sales.xlsx!Dec
CellDIY LabelValuediya-gl mapping
H15466.66666666667
I127333.3333333333
H220
W10
X10
Sales.xlsx!Jan
CellDIY LabelValuediya-gl mapping
H15906.66666666667
I129533.3333333333
H220
W10
X10
Sales.xlsx!Feb
CellDIY LabelValuediya-gl mapping
H15726.66666666667
I128633.3333333333
H220
W10
X10
Sales.xlsx!Mar
CellDIY LabelValuediya-gl mapping
H15226.66666666667
I126133.3333333333
H220
W10
X10
Purchases.xlsx!OpeningCreditors
CellDIY LabelValuediya-gl mapping
G12220
Purchases.xlsx!ClosingCreditors
CellDIY LabelValuediya-gl mapping
G11710
Purchases.xlsx!Apr
CellDIY LabelValuediya-gl mapping
A10
A238.25
C285
G238.25
H1845.5
I14265.75
H220
AD10
Purchases.xlsx!May
CellDIY LabelValuediya-gl mapping
A10
A292.25
C2205
G254
H11053.5
I15321.5
H220
AD10
Purchases.xlsx!Jun
CellDIY LabelValuediya-gl mapping
A10
A2182.25
C2405
G290
H14094.5
I120562.5
H220
AD11000
Purchases.xlsx!Jul
CellDIY LabelValuediya-gl mapping
A10
A2202.5
C2450
G220.25
H11506.5
I17552.75
H220
AD10
Purchases.xlsx!Aug
CellDIY LabelValuediya-gl mapping
A10
A2240.75
C2535
G238.25
H1727.833333333333
I13677.41666666667
H220
AD10
Purchases.xlsx!Sep
CellDIY LabelValuediya-gl mapping
A10
A2312.75
C2695
G272
H12217.16666666667
I111157.8333333333
H220
AD10
Purchases.xlsx!Oct
CellDIY LabelValuediya-gl mapping
A10
A2355.5
C2790
G242.75
H17160.5
I135845.25
H220
AD10
Purchases.xlsx!Nov
CellDIY LabelValuediya-gl mapping
A10
A2436.5
C2970
G281
H11139.5
I15778.5
H220
AD1600
Purchases.xlsx!Dec
CellDIY LabelValuediya-gl mapping
A10
A2486
C21080
G249.5
H11567
I17884.5
H220
AD10
Purchases.xlsx!Jan
CellDIY LabelValuediya-gl mapping
A10
A2524.25
C21165
G238.25
H1745.5
I13765.75
H220
AD10
Purchases.xlsx!Feb
CellDIY LabelValuediya-gl mapping
A10
A2555.75
C21235
G231.5
H1727.5
I13669
H220
AD10
Purchases.xlsx!Mar
CellDIY LabelValuediya-gl mapping
A10
A2614.25
C21365
G258.5
H1611.333333333333
I13115.16666666667
H220
AD10
Vat.xlsx!VATQtr1
CellDIY LabelValuediya-gl mapping
G546203
G746234
G916920
G110
G1316920
G155993.5
G1710926.5
G2184599.9999999999
G2330149.75
Vat.xlsx!VATQtr2
CellDIY LabelValuediya-gl mapping
G546295
G746326
G917256.6666666667
G110
G1317256.6666666667
G154451.5
G1712805.1666666667
G2186283.3333333333
G2322388
Vat.xlsx!VATQtr3
CellDIY LabelValuediya-gl mapping
G546387
G746418
G919780
G110
G1319780
G159867
G179913.00000000001
G2198899.9999999999
G2349508.25
Vat.xlsx!VATQtr4
CellDIY LabelValuediya-gl mapping
G546477
G746507
G916860
G110
G1316860
G152084.33333333333
G1714775.6666666667
G2184299.9999999999
G2310549.9166666667
Vat.xlsx!VATQtr5
CellDIY LabelValuediya-gl mapping
G546568
G746599
G91100
G110
G131100
G15180
G17920
G215500
G23900
Vat.xlsx!Vatinterface
CellDIY LabelValuediya-gl mapping
B446081
C446112
D44000
F4800
H4600
J4120
M40
B546112
C546142
D52000
F5400
H51000
J5200
M50
B646142
C646173
D627833.3333333333
E633833.3333333333
F65566.66666666667
G66766.66666666667
H64265.75
I65865.75
J6845.5
K61165.5
M60
B746173
C746203
D727433.3333333333
E757266.6666666666
F75486.66666666667
G711453.3333333333
H75321.5
I710587.25
J71053.5
K72099
M70
B846203
C846234
D829333.3333333333
E884599.9999999999
F85866.66666666667
G816920
H820562.5
I830149.75
J84094.5
K85993.5
M80
B946234
C946265
D928133.3333333333
E984899.9999999999
F95626.66666666667
G916980
H97552.75
I933436.75
J91506.5
K96654.5
M90
B1046265
C1046295
D1030016.6666666667
E1087483.3333333333
F106003.33333333333
G1017496.6666666667
H103677.41666666667
I1031792.6666666667
J10727.833333333333
K106328.83333333333
M100
B1146295
C1146326
D1128133.3333333333
E1186283.3333333333
F115626.66666666667
G1117256.6666666667
H1111157.8333333333
I1122388
J112217.16666666667
K114451.5
M110
B1246326
C1246356
D1242133.3333333333
E12100283.333333333
F128426.66666666667
G1220056.6666666667
H1235845.25
I1250680.5
J127160.5
K1210105.5
M120
B1346356
C1346387
D1329433.3333333333
E1399699.9999999999
F135886.66666666667
G1319940
H135778.5
I1352781.5833333333
J131139.5
K1310517.1666666667
M130
B1446387
C1446418
D1427333.3333333333
E1498899.9999999999
F145466.66666666667
G1419780
H147884.5
I1449508.25
J141567
K149867
M140
B1546418
C1546446
D1529533.3333333333
E1586299.9999999999
F155906.66666666667
G1517260
H153765.75
I1517428.75
J15745.5
K153452
M150
B1646446
C1646477
D1628633.3333333333
E1685499.9999999999
F165726.66666666667
G1617100
H163669
I1615319.25
J16727.5
K163040
M160
B1746477
C1746507
D1726133.3333333333
E1784299.9999999999
F175226.66666666667
G1716860
H173115.16666666667
I1710549.9166666667
J17611.333333333333
K172084.33333333333
M170
B1846507
C1846538
D183000
E1857766.6666666666
F18600
G1811553.3333333333
H18200
I186984.16666666667
J1840
K181378.83333333333
M180
B1946538
C1946568
D191500
E1930633.3333333333
F19300
G196126.66666666667
H19300
I193615.16666666667
J1960
K19711.333333333333
M190
B2046568
C2046599
D201000
E205500
F20200
G201100
H20400
I20900
J2080
K20180
M200
Fixedassets.xlsx!Schedule
CellDIY LabelValuediya-gl mapping
E1Total cost of every asset on the schedule, assets sold in the year included85500
F1Total accumulated depreciation brought forward10098
G1Total net book value brought forward (cost less depreciation brought forward)22902
I1Total depreciation charged for the year13740
J1Total accumulated depreciation carried forward (brought forward plus the charge)23838
K1Total net book value carried forward, disposals removed48990
Q1Total annual investment allowance claimed52500
R1Total writing down allowance claimed3360
S1Total tax written down value carried forward20640
V1Sale proceeds of the assets sold in the year, net of VAT12500
W1Cost of the assets sold in the year30000
X1Accumulated depreciation on the assets sold in the year17328
Y1Balancing allowance on the disposals8140
Z1Balancing charge on the disposals0
E57Cost of the assets owned at the start of the year33000
E110Cost of the assets bought during the year52500
Fixedassets.xlsx!FAreconciliation
CellDIY LabelValuediya-gl mapping
E11Additions the schedule lists, net of VAT52500
E13Fixed asset purchases the purchase journal carries, net of VAT52500
E15Purchases less schedule additions0
K11Disposal proceeds the schedule lists, net of VAT12500
K13Fixed asset sales the sales journal carries, net of VAT12500
K15Sales less schedule disposals0
Fixedassets.xlsx!HPfinance
CellDIY LabelValuediya-gl mapping
E220000
I8750
J8660
K890
I10405
J10355
K1050
Payslips.xlsx!Apr
CellDIY LabelValuediya-gl mapping
T1577.2
O1296
N1800
P10
Payslips.xlsx!May
CellDIY LabelValuediya-gl mapping
T1577.2
O1296
N1800
P10
Payslips.xlsx!Jun
CellDIY LabelValuediya-gl mapping
T1577.2
O1296
N1800
P10
Payslips.xlsx!Jul
CellDIY LabelValuediya-gl mapping
T1577.2
O1296
N1800
P10
T410
M4946234
D511257L
F51Alice Johnson
M513500
N51530
O51200
R512770
S51PAY-EMP001-2025-07
T51382.5
D521257L
F52Bob Williams
M522200
N52270
O5296
R521834
S52PAY-EMP002-2025-07
T52187.5
D531257L
F53Carol Smith
M531048
N530
O530
R531048
S53PAY-EMP003-2025-07
T537.2
N540
O540
T540
N550
O550
T550
Payslips.xlsx!Aug
CellDIY LabelValuediya-gl mapping
T1577.2
O1296
N1800
P10
H110
I110
J110
L110
H120
I120
J120
L120
K120
H130
I130
J130
L130
K130
H140
I140
J140
L140
K140
H150
I150
J150
L150
K150
M4946265
D511257L
F51Alice Johnson
M513500
N51530
O51200
R512770
S51PAY-EMP001-2025-08
T51382.5
D521257L
F52Bob Williams
M522200
N52270
O5296
R521834
S52PAY-EMP002-2025-08
T52187.5
D531257L
F53Carol Smith
M531048
N530
O530
R531048
S53PAY-EMP003-2025-08
T537.2
N540
O540
T540
N550
O550
T550
Payslips.xlsx!Sep
CellDIY LabelValuediya-gl mapping
T1577.2
O1296
N1800
P10
Payslips.xlsx!Oct
CellDIY LabelValuediya-gl mapping
T1577.2
O1296
N1800
P10
Payslips.xlsx!Nov
CellDIY LabelValuediya-gl mapping
T1577.2
O1296
N1800
P10
Payslips.xlsx!Dec
CellDIY LabelValuediya-gl mapping
T1577.2
O1296
N1800
P10
Payslips.xlsx!Jan
CellDIY LabelValuediya-gl mapping
T1577.2
O1296
N1800
P10
Payslips.xlsx!Feb
CellDIY LabelValuediya-gl mapping
T1577.2
O1296
N1800
P10
Payslips.xlsx!Mar
CellDIY LabelValuediya-gl mapping
T1577.2
O1296
N1800
P10
Payslips.xlsx!Payment
CellDIY LabelValuediya-gl mapping
B446142
C446161
D4873.2
E4800
I41673.2
B546173
C546192
D5873.2
E5800
I51673.2
B646203
C646222
D6873.2
E6800
I61673.2
B746234
C746253
D7873.2
E7800
I71673.2
B846265
C846284
D8873.2
E8800
I81673.2
B946295
C946314
D9873.2
E9800
I91673.2
B1046326
C1046345
D10873.2
E10800
I101673.2
B1146356
C1146375
D11873.2
E11800
I111673.2
B1246387
C1246406
D12873.2
E12800
I121673.2
B1346418
C1346437
D13873.2
E13800
I131673.2
B1446446
C1446465
D14873.2
E14800
I141673.2
B1546477
C1546496
D15873.2
E15800
I151673.2
Payslips.xlsx!Payslips
CellDIY LabelValuediya-gl mapping
H3May
H448
L7MONTHLY PAYROLL
I946173
I102
M81
G143500
H14530
I14200
M142770
G167000
H161060
I16400
M165540
M1846173
Payslips.xlsx!Admin
CellDIY LabelValuediya-gl mapping
B246118
I146482
N12026-27
A2Apr
D21
A33May
B3346149
D332
A64Jun
B6446180
D643
A95Jul
B9546211
D954
A126Aug
B12646242
D1265
A157Sep
B15746273
D1576
A188Oct
B18846304
D1887
A219Nov
B21946335
D2198
A250Dec
B25046366
D2509
A281Jan
B28146397
D28110
A312Feb
B31246428
D31211
A343Mar
B34346459
D34312
A366Mar
B36646482
D36612
A381Mar
B38146497
D38112
Salesinvoice.xlsx!Product Details
CellDIY LabelValuediya-gl mapping
D220
Salesinvoice.xlsx!Invoice Template
CellDIY LabelValuediya-gl mapping
P581200
P6037.5
P62247.5
P641485
J381200
L381
P381200
V38240

Tax review

Income Tax Calculation

Amount
Profit from Self Employment121,513.02
    Less: Personal Allowance1,813.49
Taxable Income119,699.53
    Tax at Basic Rate (20%)7,540
    Basic band ceiling the sheet applies37,700
    Tax at Higher Rate (40%)32,799.81
    Additional rate threshold the sheet applies125,140
    Additional rate the sheet applies0.45
    Tax at Additional Rate (45%)0
Total Income Tax40,339.81
    Less: CIS Deducted0
    NI Class 4 (lower band)2,262
    NI Class 4 (upper band)1,424.86
Total Tax + NI44,026.67

Self Assessment (SA103S)

Amount
Business namePrecision Code Trading
Accounting date46,118
Turnover339,200
    Other business income0
    Cost of sales20,136.67
    Car, van and travel7,984.25
    Employee costs92,735.73
    Premises costs13,200
    Repairs and renewals950
    Accountancy, legal and professional6,925
    Interest and bank charges3,900
    Phone, stationery and office costs3,035
    Other business expenses6,903.67
Total expenses155,770.32
Net profit/loss183,429.68
    Net loss (box 22)0
    Capital allowances52,500
    AIA / WDA claimed0
    Other capital allowances (box 25)11,500
    Balancing charges (box 26)0
    Other tax adjustments0
Net business profit (box 28)119,429.68
    Loss brought forward (box 29)0
    Grants as other business income (box 30)2,083.33
Turnover noteSELF-EMPLOYMENT FULL RETURN REQUIRED AS TURNOVER EXCEEDS £90000 VAT threshold
Net profit for tax calc (box 31)121,513.02
    Net loss for tax calc0
    Total loss to carry forward (box 35)0
    Deductions by contractors (box 38)0

Self Assessment (SA103F)

Amount
Turnover (box 15)339,200
    Other business income (box 16)0
    Goods bought for resale (box 17)13,470
    Subcontractor payments (box 18)6,666.67
    Wages, salaries and staff costs (box 19)92,735.73
    Car, van and travel expenses (box 20)7,984.25
    Rent, rates, power and insurance (box 21)13,200
    Repairs and maintenance (box 22)950
    Phone, stationery and office costs (box 23)3,035
    Advertising and entertainment (box 24)3,800
    Interest on bank and other loans (box 25)0
    Bank, credit card and finance charges (box 26)3,900
    Irrecoverable debts written off (box 27)-300
    Accountancy, legal and professional fees (box 28)6,925
    Depreciation and loss on sale of assets (box 29)13,912
    Other business expenses (box 30)3,231.67
Total expenses (box 31)169,510.32
    Disallowable depreciation (box 44)13,740
Total disallowable expenses (box 46)13,740
Net profit (box 47)169,689.68
    Net loss (box 48)0
    Annual investment allowance (box 49)52,500
    Capital allowances at 18% (box 50)3,360
    100% and other enhanced capital allowances (box 55)0
    Allowances on sale or cessation (box 56)8,140
Total capital allowances (box 57)64,000
    Balancing charge (box 59)0
    Goods and services for own use (box 60)0
Total additions to net profit (box 61)13,740
Total deductions from net profit (box 63)64,000
Net business profit for tax purposes (box 64)119,429.68
    Net business loss for tax purposes (box 65)0
Adjusted profit (box 73)119,429.68
    Loss brought forward set against this year (box 74)0
    Other business income not in boxes 15, 16 or 60 (box 75)2,083.33
Total taxable profits from this business (box 76)121,513.02
    Adjusted loss (box 77)0
    Total loss to carry forward (box 80)0
    Contractor deductions taken off (box 81)0