DIY Accounting Spreadsheets

Excel bookkeeping and accounting software for UK small businesses

Limited Company reconciliation

Reconciliation Report: GB Accounts Company 2027-10-31 (Oct27) Excel 2007. Every figure below comes from a scenario driven through the shipped workbooks and read back out of the recalculated sheets.

Full Ltd-scoped extract from Precision Code Ltd master data. All journals, all accounts.

Trade: IT consultancy and software development

Summary

Plausibility review: pass

All indicators align with the headline. The reconciliation run is clean and consistent.

Read back by us.amazon.nova-pro-v1:0, 2026-09-06. The arithmetic checks below run first and decide the status.

Every run

Year endPeriodScenarioStatus
2027-10-31Oct27ltd-brickwork-pro-nonvatRECONCILES
2027-10-31Oct27ltd-brickwork-pro-vatRECONCILES
2027-10-31Oct27ltd-scenario-fullRECONCILES
2027-09-30Sep27ltd-scenario-fullRECONCILES
2027-08-31Aug27ltd-scenario-fullRECONCILES
2027-07-31Jul27ltd-scenario-fullRECONCILES
2027-06-30Jun27ltd-scenario-fullRECONCILES
2027-05-31May27ltd-scenario-fullRECONCILES
2027-04-30Apr27ltd-scenario-fullRECONCILES
2027-03-31Mar27ltd-scenario-fullRECONCILES
2027-02-28Feb27ltd-scenario-fullRECONCILES
2027-01-31Jan27ltd-scenario-fullRECONCILES
2026-12-31Dec26ltd-scenario-fullRECONCILES
2026-11-30Nov26ltd-scenario-fullRECONCILES
2026-10-31Oct26ltd-scenario-fullRECONCILES
2026-09-30Sep26ltd-scenario-fullRECONCILES
2026-08-31Aug26ltd-scenario-fullRECONCILES
2026-07-31Jul26ltd-scenario-fullRECONCILES
2026-06-30Jun26ltd-scenario-fullRECONCILES
2026-05-31May26ltd-scenario-fullRECONCILES
2026-04-30Apr26ltd-scenario-fullRECONCILES
2026-03-31Mar26ltd-scenario-fullRECONCILES
2026-02-28Feb26ltd-scenario-fullRECONCILES
2026-01-31Jan26ltd-scenario-fullRECONCILES
2025-12-31Dec25ltd-scenario-fullRECONCILES
2025-11-30Nov25ltd-scenario-fullRECONCILES
2025-10-31Oct25ltd-scenario-fullRECONCILES
2025-09-30Sep25ltd-scenario-fullRECONCILES
2025-08-31Aug25ltd-scenario-fullRECONCILES
2025-07-31Jul25ltd-scenario-fullRECONCILES
2025-06-30Jun25ltd-scenario-fullRECONCILES
2025-05-31May25ltd-scenario-fullRECONCILES
2025-04-30Apr25ltd-scenario-fullRECONCILES
2025-03-31Mar25ltd-scenario-fullRECONCILES
2025-02-28Feb25ltd-scenario-fullRECONCILES
2025-01-31Jan25ltd-scenario-fullRECONCILES
2024-12-31Dec24ltd-scenario-fullRECONCILES
2024-11-30Nov24ltd-scenario-fullRECONCILES
2024-10-31Oct24ltd-scenario-fullRECONCILES
2024-09-30Sep24ltd-scenario-fullRECONCILES
2024-08-31Aug24ltd-scenario-fullRECONCILES
2024-07-31Jul24ltd-scenario-fullRECONCILES
2024-06-30Jun24ltd-scenario-fullRECONCILES
2024-05-31May24ltd-scenario-fullRECONCILES
2024-04-30Apr24ltd-scenario-fullRECONCILES
2024-03-31Mar24ltd-scenario-fullRECONCILES
2024-02-29Feb24ltd-scenario-fullRECONCILES
2024-01-31Jan24ltd-scenario-fullRECONCILES
2023-12-31Dec23ltd-scenario-fullRECONCILES
2023-11-30Nov23ltd-scenario-fullRECONCILES
2023-10-31Oct23ltd-scenario-fullRECONCILES
2023-09-30Sep23ltd-scenario-fullRECONCILES
2023-08-31Aug23ltd-scenario-fullRECONCILES
2023-07-31Jul23ltd-scenario-fullRECONCILES
2023-06-30Jun23ltd-scenario-fullRECONCILES
2023-05-31May23ltd-scenario-fullRECONCILES
2023-04-30Apr23ltd-scenario-fullRECONCILES
2023-03-31Mar23ltd-scenario-fullRECONCILES
2023-02-28Feb23ltd-scenario-fullRECONCILES
2023-01-31Jan23ltd-scenario-fullRECONCILES
2022-12-31Dec22ltd-scenario-fullRECONCILES
2022-11-30Nov22ltd-scenario-fullRECONCILES
2022-10-31Oct22ltd-scenario-fullRECONCILES
2022-09-30Sep22ltd-scenario-fullRECONCILES
2022-08-31Aug22ltd-scenario-fullRECONCILES
2022-07-31Jul22ltd-scenario-fullRECONCILES
2022-06-30Jun22ltd-scenario-fullRECONCILES
2022-05-31May22ltd-scenario-fullRECONCILES
2022-04-30Apr22ltd-scenario-fullRECONCILES
2022-03-31Mar22ltd-scenario-fullRECONCILES
2022-02-28Feb22ltd-scenario-fullRECONCILES
2022-01-31Jan22ltd-scenario-fullRECONCILES
2021-12-31Dec21ltd-scenario-fullRECONCILES
2021-11-30Nov21ltd-scenario-fullRECONCILES
2021-10-31Oct21ltd-scenario-fullRECONCILES
2021-09-30Sep21ltd-scenario-fullRECONCILES
2021-08-31Aug21ltd-scenario-fullRECONCILES
2021-07-31Jul21ltd-scenario-fullRECONCILES
2021-06-30Jun21ltd-scenario-fullRECONCILES
2021-05-31May21ltd-scenario-fullRECONCILES
2021-04-30Apr21ltd-scenario-fullRECONCILES
2021-03-31Mar21ltd-scenario-fullRECONCILES
2021-02-28Feb21ltd-scenario-fullRECONCILES
2021-01-31Jan21ltd-scenario-fullRECONCILES
2020-12-31Dec20ltd-scenario-fullRECONCILES
2020-11-30Nov20ltd-scenario-fullRECONCILES
2020-10-31Oct20ltd-scenario-fullRECONCILES
2020-09-30Sep20ltd-scenario-fullRECONCILES
2020-08-31Aug20ltd-scenario-fullRECONCILES
2020-07-31Jul20ltd-scenario-fullRECONCILES
2020-06-30Jun20ltd-scenario-fullRECONCILES
2020-05-31May20ltd-scenario-fullRECONCILES
2020-04-30Apr20ltd-scenario-fullRECONCILES

Reconciliation checks

CheckExpectedActualDiffResult
Total Sales341283341283.333333333+0.3333333330228925PASS
Trial Balance: audit accuracy (EJ91)03.26508597936481e-10+3.26508597936481e-10PASS
Opening balance sheet: accuracy check (E37)000PASS
Trial Balance: opening balances audit check (D91)000PASS
Trial Balance opening: fixed asset cost2330002330000PASS
Trial Balance opening: accumulated depreciation-50098-500980PASS
Trial Balance opening: stock10000100000PASS
Trial Balance opening: trade debtors10800108000PASS
Trial Balance opening: bank current account25000250000PASS
Trial Balance opening: bank savings account500050000PASS
Trial Balance opening: credit card account000PASS
Trial Balance opening: cash account5005000PASS
Trial Balance opening: trade creditors-2400-24000PASS
Trial Balance opening: HMRC VAT creditor-1500-15000PASS
Trial Balance opening: HMRC corporation tax creditor-4500-45000PASS
Trial Balance opening: directors loan-20000-200000PASS
Trial Balance opening: creditors due after more than one year-25000-250000PASS
Trial Balance opening: share capital-100-1000PASS
Trial Balance opening: revenue reserve-180702-1807020PASS
Trial Balance: directors loan final = opening + movement-13000-130000PASS
P&L: Gross = Turnover - CoS322496.66666666634322496.666666666-3.4924596548080444e-10PASS
P&L: Operating = Gross - Admin171840.391666666171840.3916666660PASS
P&L: PBT = Operating + Interest172115.391666666172115.3916666660PASS
P&L: Admin lines sum = Total150656.27500000005150656.275-5.820766091346741e-11PASS
Premises12000120000PASS
Legal & Professional442544250PASS
Stock: opening carried in from the opening balance sheet10000100000PASS
Stock: physical count at the year end600060000PASS
Stock: loss adjustment = count - calculated-102.00000000002001-102.000000000015+5.002220859751105e-12PASS
Published balance sheet: stock = year-end stock600060000PASS
Stock: calculated stock = opening + materials bought - materials sold61026102.00000000002+2.000888343900442e-11PASS
Published balance sheet: trade debtors = closing debtors790079000PASS
Published balance sheet: trade debtors = opening debtors plus invoices less customer receipts and the CIS suffered790079000PASS
VAT: Q1-Q4 box 1 = Sales VAT70816.666666666770816.66666666670PASS
VAT: Q1-Q4 box 4 = Purchases VAT22498.70833333333222498.70833333333-3.637978807091713e-12PASS
VAT Q1: box 5 = box 3 - box 410896.12510896.1250PASS
VAT Q2: box 5 = box 3 - box 412783.416666666712783.41666666670PASS
VAT Q3: box 5 = box 3 - box 49884.1259884.12500000001+9.094947017729282e-12PASS
VAT Q4: box 5 = box 3 - box 414754.2916666666714754.2916666667+3.092281986027956e-11PASS
VAT: annual output VAT = the sales journal at the book's rate70816.7099999999870816.6666666667-0.04333333327667788PASS
VAT: annual input VAT = the purchase journal at the book's rate22498.6700000000122498.708333333332+0.03833333332295297PASS
Sales.xlsx Nov: VAT rate charged (G2)20200PASS
Purchases.xlsx Nov: VAT rate charged (G2)20200PASS
Sales.xlsx Dec: VAT rate charged (G2)20200PASS
Purchases.xlsx Dec: VAT rate charged (G2)20200PASS
Sales.xlsx Jan: VAT rate charged (G2)20200PASS
Purchases.xlsx Jan: VAT rate charged (G2)20200PASS
Sales.xlsx Feb: VAT rate charged (G2)20200PASS
Purchases.xlsx Feb: VAT rate charged (G2)20200PASS
Sales.xlsx Mar: VAT rate charged (G2)20200PASS
Purchases.xlsx Mar: VAT rate charged (G2)20200PASS
Sales.xlsx Apr: VAT rate charged (G2)20200PASS
Purchases.xlsx Apr: VAT rate charged (G2)20200PASS
Sales.xlsx May: VAT rate charged (G2)20200PASS
Purchases.xlsx May: VAT rate charged (G2)20200PASS
Sales.xlsx Jun: VAT rate charged (G2)20200PASS
Purchases.xlsx Jun: VAT rate charged (G2)20200PASS
Sales.xlsx Jul: VAT rate charged (G2)20200PASS
Purchases.xlsx Jul: VAT rate charged (G2)20200PASS
Sales.xlsx Aug: VAT rate charged (G2)20200PASS
Purchases.xlsx Aug: VAT rate charged (G2)20200PASS
Sales.xlsx Sep: VAT rate charged (G2)20200PASS
Purchases.xlsx Sep: VAT rate charged (G2)20200PASS
Sales.xlsx Oct: VAT rate charged (G2)20200PASS
Purchases.xlsx Oct: VAT rate charged (G2)20200PASS
Vatinterface D6: Nov sales net = Sales.xlsx Nov27833.333333333327833.33333333330PASS
Vatinterface F6: Nov output VAT = Sales.xlsx Nov5566.666666666675566.666666666670PASS
Vatinterface H6: Nov purchases net = Purchases.xlsx Nov4259.3754259.3750PASS
Vatinterface J6: Nov input VAT = Purchases.xlsx Nov851.875851.8750PASS
Vatinterface D7: Dec sales net = Sales.xlsx Dec27433.333333333327433.33333333330PASS
Vatinterface F7: Dec output VAT = Sales.xlsx Dec5486.666666666675486.666666666670PASS
Vatinterface H7: Dec purchases net = Purchases.xlsx Dec5312.55312.50PASS
Vatinterface J7: Dec input VAT = Purchases.xlsx Dec1062.51062.50PASS
Vatinterface D8: Jan sales net = Sales.xlsx Jan29333.333333333329333.33333333330PASS
Vatinterface F8: Jan output VAT = Sales.xlsx Jan5866.666666666675866.666666666670PASS
Vatinterface H8: Jan purchases net = Purchases.xlsx Jan20547.520547.50PASS
Vatinterface J8: Jan input VAT = Purchases.xlsx Jan4109.54109.50PASS
Vatinterface D9: Feb sales net = Sales.xlsx Feb28133.333333333328133.33333333330PASS
Vatinterface F9: Feb output VAT = Sales.xlsx Feb5626.666666666675626.666666666670PASS
Vatinterface H9: Feb purchases net = Purchases.xlsx Feb7549.3757549.3750PASS
Vatinterface J9: Feb input VAT = Purchases.xlsx Feb1509.8751509.8750PASS
Vatinterface D10: Mar sales net = Sales.xlsx Mar30016.666666666730016.66666666670PASS
Vatinterface F10: Mar output VAT = Sales.xlsx Mar6003.333333333336003.333333333330PASS
Vatinterface H10: Mar purchases net = Purchases.xlsx Mar3671.041666666673671.041666666670PASS
Vatinterface J10: Mar input VAT = Purchases.xlsx Mar734.208333333333734.2083333333330PASS
Vatinterface D11: Apr sales net = Sales.xlsx Apr28133.333333333328133.33333333330PASS
Vatinterface F11: Apr output VAT = Sales.xlsx Apr5626.666666666675626.666666666670PASS
Vatinterface H11: Apr purchases net = Purchases.xlsx Apr11145.833333333311145.83333333330PASS
Vatinterface J11: Apr input VAT = Purchases.xlsx Apr2229.166666666672229.166666666670PASS
Vatinterface D12: May sales net = Sales.xlsx May42133.333333333342133.33333333330PASS
Vatinterface F12: May output VAT = Sales.xlsx May8426.666666666678426.666666666670PASS
Vatinterface H12: May purchases net = Purchases.xlsx May35838.12535838.1250PASS
Vatinterface J12: May input VAT = Purchases.xlsx May7167.6257167.6250PASS
Vatinterface D13: Jun sales net = Sales.xlsx Jun29433.333333333329433.33333333330PASS
Vatinterface F13: Jun output VAT = Sales.xlsx Jun5886.666666666675886.666666666670PASS
Vatinterface H13: Jun purchases net = Purchases.xlsx Jun576557650PASS
Vatinterface J13: Jun input VAT = Purchases.xlsx Jun115311530PASS
Vatinterface D14: Jul sales net = Sales.xlsx Jul27333.333333333327333.33333333330PASS
Vatinterface F14: Jul output VAT = Sales.xlsx Jul5466.666666666675466.666666666670PASS
Vatinterface H14: Jul purchases net = Purchases.xlsx Jul7876.257876.250PASS
Vatinterface J14: Jul input VAT = Purchases.xlsx Jul1575.251575.250PASS
Vatinterface D15: Aug sales net = Sales.xlsx Aug29533.333333333329533.33333333330PASS
Vatinterface F15: Aug output VAT = Sales.xlsx Aug5906.666666666675906.666666666670PASS
Vatinterface H15: Aug purchases net = Purchases.xlsx Aug3759.3753759.3750PASS
Vatinterface J15: Aug input VAT = Purchases.xlsx Aug751.875751.8750PASS
Vatinterface D16: Sep sales net = Sales.xlsx Sep28633.333333333328633.33333333330PASS
Vatinterface F16: Sep output VAT = Sales.xlsx Sep5726.666666666675726.666666666670PASS
Vatinterface H16: Sep purchases net = Purchases.xlsx Sep3663.753663.750PASS
Vatinterface J16: Sep input VAT = Purchases.xlsx Sep732.75732.750PASS
Vatinterface D17: Oct sales net = Sales.xlsx Oct26133.333333333326133.33333333330PASS
Vatinterface F17: Oct output VAT = Sales.xlsx Oct5226.666666666675226.666666666670PASS
Vatinterface H17: Oct purchases net = Purchases.xlsx Oct3105.416666666673105.416666666670PASS
Vatinterface J17: Oct input VAT = Purchases.xlsx Oct621.083333333333621.0833333333330PASS
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 rows30119.37530119.3750PASS
Vatinterface K8: quarter input VAT = its three period rows6023.8756023.8750PASS
VAT Q1: box 1 (G9) = Vatinterface quarter VAT due (G8)16920169200PASS
VAT Q1: box 4 (G15) = Vatinterface quarter VAT reclaimed (K8)6023.8756023.8750PASS
VAT Q1: box 7 (G23) = Vatinterface quarter purchases net (I8)30119.37530119.3750PASS
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)46446464460PASS
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 rows22366.2499999999722366.25+2.9103830456733704e-11PASS
Vatinterface K11: quarter input VAT = its three period rows4473.2500000000044473.25-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)4473.254473.250PASS
VAT Q2: box 7 (G23) = Vatinterface quarter purchases net (I11)22366.2522366.250PASS
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)46538465380PASS
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 rows49479.37549479.3750PASS
Vatinterface K14: quarter input VAT = its three period rows9895.8759895.8750PASS
VAT Q3: box 1 (G9) = Vatinterface quarter VAT due (G14)19780197800PASS
VAT Q3: box 4 (G15) = Vatinterface quarter VAT reclaimed (K14)9895.8759895.8750PASS
VAT Q3: box 7 (G23) = Vatinterface quarter purchases net (I14)49479.37549479.3750PASS
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)46630466300PASS
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 rows10528.5416666666710528.5416666667+3.092281986027956e-11PASS
Vatinterface K17: quarter input VAT = its three period rows2105.7083333333332105.70833333333-3.183231456205249e-12PASS
VAT Q4: box 1 (G9) = Vatinterface quarter VAT due (G17)16860168600PASS
VAT Q4: box 4 (G15) = Vatinterface quarter VAT reclaimed (K17)2105.708333333332105.708333333330PASS
VAT Q4: box 7 (G23) = Vatinterface quarter purchases net (I17)10528.541666666710528.54166666670PASS
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)46721467210PASS
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)46812468120PASS
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
Fixed assets: closing NBV = cost less disposals, less depreciation carried forward less depreciation on disposals2089902089900PASS
Schedule: motor vehicle WDA = opening tax value x the year's WDA rate, uncapped3360.00000000000053360-4.547473508864641e-13PASS
Schedule: motor vehicle pool after WDA = opening tax value less WDA20640206400PASS
Schedule: motor vehicle balancing allowance = pool after WDA less disposal proceeds814081400PASS
Schedule: motor vehicle WDA + balancing allowance = opening tax value less disposal proceeds11500115000PASS
Fixed asset note (land): cost brought forward = Schedule2000002000000PASS
Fixed asset note (land): additions = Schedule000PASS
Fixed asset note (land): disposals at cost = Schedule000PASS
Fixed asset note (land): cost carried forward2000002000000PASS
Fixed asset note (land): depreciation brought forward = Schedule40000400000PASS
Fixed asset note (land): charge for the year = Schedule000PASS
Fixed asset note (land): depreciation on disposals = Schedule000PASS
Fixed asset note (land): depreciation carried forward40000400000PASS
Fixed asset note (land): net book value = cost less depreciation1600001600000PASS
Fixed asset note (plant): cost brought forward = Schedule000PASS
Fixed asset note (plant): additions = Schedule52500525000PASS
Fixed asset note (plant): disposals at cost = Schedule000PASS
Fixed asset note (plant): cost carried forward52500525000PASS
Fixed asset note (plant): depreciation brought forward = Schedule000PASS
Fixed asset note (plant): charge for the year = Schedule525052500PASS
Fixed asset note (plant): depreciation on disposals = Schedule000PASS
Fixed asset note (plant): depreciation carried forward525052500PASS
Fixed asset note (plant): net book value = cost less depreciation47250472500PASS
Fixed asset note (fixtures): cost brought forward = Schedule000PASS
Fixed asset note (fixtures): additions = Schedule000PASS
Fixed asset note (fixtures): disposals at cost = Schedule000PASS
Fixed asset note (fixtures): cost carried forward000PASS
Fixed asset note (fixtures): depreciation brought forward = Schedule000PASS
Fixed asset note (fixtures): charge for the year = Schedule000PASS
Fixed asset note (fixtures): depreciation on disposals = Schedule000PASS
Fixed asset note (fixtures): depreciation carried forward000PASS
Fixed asset note (fixtures): net book value = cost less depreciation000PASS
Fixed asset note (computer): cost brought forward = Schedule300030000PASS
Fixed asset note (computer): additions = Schedule000PASS
Fixed asset note (computer): disposals at cost = Schedule000PASS
Fixed asset note (computer): cost carried forward300030000PASS
Fixed asset note (computer): depreciation brought forward = Schedule2702700PASS
Fixed asset note (computer): charge for the year = Schedule9909900PASS
Fixed asset note (computer): depreciation on disposals = Schedule000PASS
Fixed asset note (computer): depreciation carried forward126012600PASS
Fixed asset note (computer): net book value = cost less depreciation174017400PASS
Fixed asset note (motor): cost brought forward = Schedule30000300000PASS
Fixed asset note (motor): additions = Schedule000PASS
Fixed asset note (motor): disposals at cost = Schedule30000300000PASS
Fixed asset note (motor): cost carried forward000PASS
Fixed asset note (motor): depreciation brought forward = Schedule982898280PASS
Fixed asset note (motor): charge for the year = Schedule750075000PASS
Fixed asset note (motor): depreciation on disposals = Schedule17328173280PASS
Fixed asset note (motor): depreciation carried forward000PASS
Fixed asset note (motor): net book value = cost less depreciation000PASS
Fixed asset note: total cost brought forward = Schedule existing assets2330002330000PASS
Fixed asset note: total additions = Schedule new assets52500525000PASS
Fixed asset note: total charge for the year = Schedule13740137400PASS
Fixed asset note: total disposals at cost = Schedule30000300000PASS
Fixed asset note: total depreciation on disposals = Schedule17328173280PASS
Fixed asset note: total net book value = the asset class columns2089902089900PASS
Fixed asset schedule (land): opening cost and depreciation agree with the opening balance sheetan Existing ... headingExisting Land & PropertyPASS
Fixed asset schedule (plant): opening cost and depreciation agree with the opening balance sheetan Existing ... headingExisting Plant & MachineryPASS
Fixed asset schedule (fixtures): opening cost and depreciation agree with the opening balance sheetan Existing ... headingExisting Fixtures & FittingsPASS
Fixed asset schedule (computer): opening cost and depreciation agree with the opening balance sheetan Existing ... headingExisting ComputersPASS
Fixed asset schedule (motor): opening cost and depreciation agree with the opening balance sheetan Existing ... headingExisting Motor VehiclesPASS
Published balance sheet: fixed assets = fixed asset note net book value2089902089900PASS
RegisterofMembers: nominal value x shares issued = PubBalSht share capital1001000PASS
Directors' report: sales turnover = published P&L turnover341283.333333333341283.3333333330PASS
Directors' report: last year's turnover = published P&L prior year column000PASS
Directors' report: trading margin = published gross profit over turnover0.94495287395614480.944952873956146+1.2212453270876722e-15PASS
Directors' report: last year's trading margin = published prior year gross profit over turnoverblank, there being no turnover to divide byPASS
Published P&L: turnover = management P&L turnover341283.333333333341283.3333333330PASS
Published P&L: prior year closing stock while no comparatives are entered000PASS
Published P&L: prior year stock movement while no comparatives are entered000PASS
Published P&L: prior year retained profit while no comparatives are entered000PASS
Directors' report: year end = published balance sheet date46691466910PASS
Directors' report: ordinary shares issued = register of members total1001000PASS
Directors' report: first member's holding = register of members60600PASS
Directors' report: second member's holding = register of members25250PASS
Register of members: row 3 names Carol SmithCarol SmithCarol SmithPASS
Register of members: row 3 holds Carol Smith's shares60600PASS
Register of members: row 4 names David BrownDavid BrownDavid BrownPASS
Register of members: row 4 holds David Brown's shares25250PASS
Register of members: row 5 names Emma WilsonEmma WilsonEmma WilsonPASS
Register of members: row 5 holds Emma Wilson's shares15150PASS
Directors' report: first shareholder namedCarol SmithCarol SmithPASS
Directors' report: second shareholder namedDavid BrownDavid BrownPASS
Directors&Secretary: row 2 names Carol SmithCarol SmithCarol SmithPASS
Directors&Secretary: row 2 appoints Carol Smith as DirectorDirectorDirectorPASS
DirectorsInterests: row 2 names Carol SmithCarol SmithCarol SmithPASS
DirectorsInterests: row 2 registers Carol Smith's shareholding on the date the register of members carries43831438310PASS
Directors' report: dividend declared = the board minute15000150000PASS
Board minute: dividend declared = the scenario's declaration15000150000PASS
Board minute: meeting date = the scenario's board meeting46691466910PASS
Published P&L: dividends appropriated = the dividend the board declared15000150000PASS
Trial Balance: dividends creditor = opening plus declared less paid000PASS
Published balance sheet: creditors due after more than one year = the secured loan plus hire purchase agreements45000450000PASS
Charges register: the balance sheet carries a creditor falling due after more than one yearmore than 0 and no more than the 50000 the directors valued the charged assets and the hire purchase agreements finance45000PASS
Trial Balance: trade creditors = opening plus purchases, less creditor payments, CIS withheld and the amounts financed10832.2510832.250PASS
Trial Balance: PAYE creditor = the year's payroll deductions less the payments coded RP000PASS
Trial Balance: VAT creditor = opening plus output VAT, less input VAT and the payments coded RV9135.7899999999799135.78833333336-0.0016666666197124869PASS
Trial Balance: CIS creditor = the tax withheld from sub-contractors less the CIS suffered and the remittances paid under RC000PASS
Trial Balance: corporation tax creditor = opening plus the year's charge, less the interest tax credit and the payments coded RT29156.7667546294929156.7667546295+1.0913936421275139e-11PASS
Fixed assets: Schedule additions = Purchases.xlsx fixed asset total52500525000PASS
Fixed assets: Schedule disposals = Sales.xlsx fixed asset sales total12500125000PASS
Fixed assets: Schedule additions = fixed asset purchases net of VAT52500525000PASS
Fixed assets: Schedule disposal proceeds = fixed asset sales net of VAT12500125000PASS
Fixed assets: the purchases reconciliation reads nil000PASS
Fixed assets: the sales reconciliation reads nil000PASS
P&L: depreciation = fixed asset note charge for the year13740137400PASS
P&L: loss on disposal = Schedule cost less depreciation less proceeds1721720PASS
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 Bank Charges line (B36)393539350PASS
Currentaccount.xlsx: closing balance = opening + receipts - payments181215.43181215.430PASS
Savingaccount.xlsx: closing balance = opening + receipts - payments10275102750PASS
Cashaccount.xlsx: closing balance = opening + receipts - payments4804800PASS
Creditcardaccount.xlsx: closing balance = opening + receipts - payments102510250PASS
Trial Balance: Currentaccount.xlsx closing balance echo (EJ22)181215.43181215.430PASS
Trial Balance: Savingaccount.xlsx closing balance echo (EJ23)10275102750PASS
Trial Balance: Cashaccount.xlsx closing balance echo (EJ25)4804800PASS
Trial Balance: Creditcardaccount.xlsx closing balance echo (EJ24)102510250PASS
Published balance sheet: cash at bank = Trial Balance bank account aggregate192995.43192995.430PASS
P&L Nov C4 = Sales.xlsx "a" net25333.3325333.3333333333+0.0033333332976326346PASS
P&L Nov C5 = Sales.xlsx "b" net180018000PASS
P&L Nov C6 = Sales.xlsx "c" net000PASS
P&L Nov C7 = Sales.xlsx "d" net7007000PASS
P&L Nov C8 = Sales.xlsx "g" net000PASS
P&L Nov C34 = negated Sales.xlsx "o" net000PASS
P&L Dec D4 = Sales.xlsx "a" net25633.3325633.3333333333+0.0033333332976326346PASS
P&L Dec D5 = Sales.xlsx "b" net8008000PASS
P&L Dec D6 = Sales.xlsx "c" net100010000PASS
P&L Dec D7 = Sales.xlsx "d" net000PASS
P&L Dec D8 = Sales.xlsx "g" net000PASS
P&L Dec D34 = negated Sales.xlsx "o" net000PASS
P&L Jan E4 = Sales.xlsx "a" net26533.3326533.3333333333+0.0033333332976326346PASS
P&L Jan E5 = Sales.xlsx "b" net8008000PASS
P&L Jan E6 = Sales.xlsx "c" net200020000PASS
P&L Jan E7 = Sales.xlsx "d" net000PASS
P&L Jan E8 = Sales.xlsx "g" net000PASS
P&L Jan E34 = negated Sales.xlsx "o" net000PASS
P&L Feb F4 = Sales.xlsx "a" net25633.3325633.3333333333+0.0033333332976326346PASS
P&L Feb F5 = Sales.xlsx "b" net180018000PASS
P&L Feb F6 = Sales.xlsx "c" net000PASS
P&L Feb F7 = Sales.xlsx "d" net7007000PASS
P&L Feb F8 = Sales.xlsx "g" net000PASS
P&L Feb F34 = negated Sales.xlsx "o" net000PASS
P&L Mar G4 = Sales.xlsx "a" net27133.3327133.3333333333+0.0033333332976326346PASS
P&L Mar G5 = Sales.xlsx "b" net8008000PASS
P&L Mar G6 = Sales.xlsx "c" net000PASS
P&L Mar G7 = Sales.xlsx "d" net000PASS
P&L Mar G8 = Sales.xlsx "g" net2083.332083.33333333333+0.0033333333299196966PASS
P&L Mar G34 = negated Sales.xlsx "o" net000PASS
P&L Apr H4 = Sales.xlsx "a" net25033.3325033.3333333333+0.0033333332976326346PASS
P&L Apr H5 = Sales.xlsx "b" net8008000PASS
P&L Apr H6 = Sales.xlsx "c" net180018000PASS
P&L Apr H7 = Sales.xlsx "d" net5005000PASS
P&L Apr H8 = Sales.xlsx "g" net000PASS
P&L Apr H34 = negated Sales.xlsx "o" net000PASS
P&L May I4 = Sales.xlsx "a" net27133.3327133.3333333333+0.0033333332976326346PASS
P&L May I5 = Sales.xlsx "b" net180018000PASS
P&L May I6 = Sales.xlsx "c" net000PASS
P&L May I7 = Sales.xlsx "d" net7007000PASS
P&L May I8 = Sales.xlsx "g" net000PASS
P&L May I34 = negated Sales.xlsx "o" net000PASS
P&L Jun J4 = Sales.xlsx "a" net25633.3325633.3333333333+0.0033333332976326346PASS
P&L Jun J5 = Sales.xlsx "b" net8008000PASS
P&L Jun J6 = Sales.xlsx "c" net300030000PASS
P&L Jun J7 = Sales.xlsx "d" net000PASS
P&L Jun J8 = Sales.xlsx "g" net000PASS
P&L Jun J34 = negated Sales.xlsx "o" net000PASS
P&L Jul K4 = Sales.xlsx "a" net26533.3326533.3333333333+0.0033333332976326346PASS
P&L Jul K5 = Sales.xlsx "b" net8008000PASS
P&L Jul K6 = Sales.xlsx "c" net000PASS
P&L Jul K7 = Sales.xlsx "d" net000PASS
P&L Jul K8 = Sales.xlsx "g" net000PASS
P&L Jul K34 = negated Sales.xlsx "o" net000PASS
P&L Aug L4 = Sales.xlsx "a" net25633.3325633.3333333333+0.0033333332976326346PASS
P&L Aug L5 = Sales.xlsx "b" net180018000PASS
P&L Aug L6 = Sales.xlsx "c" net100010000PASS
P&L Aug L7 = Sales.xlsx "d" net110011000PASS
P&L Aug L8 = Sales.xlsx "g" net000PASS
P&L Aug L34 = negated Sales.xlsx "o" net000PASS
P&L Sep M4 = Sales.xlsx "a" net26333.3326333.3333333333+0.0033333332976326346PASS
P&L Sep M5 = Sales.xlsx "b" net8008000PASS
P&L Sep M6 = Sales.xlsx "c" net150015000PASS
P&L Sep M7 = Sales.xlsx "d" net000PASS
P&L Sep M8 = Sales.xlsx "g" net000PASS
P&L Sep M34 = negated Sales.xlsx "o" net000PASS
P&L Oct N4 = Sales.xlsx "a" net25033.3325033.3333333333+0.0033333332976326346PASS
P&L Oct N5 = Sales.xlsx "b" net8008000PASS
P&L Oct N6 = Sales.xlsx "c" net000PASS
P&L Oct N7 = Sales.xlsx "d" net000PASS
P&L Oct N8 = Sales.xlsx "g" net000PASS
P&L Oct N34 = negated Sales.xlsx "o" net-300-3000PASS
P&L Nov C12 = Purchases.xlsx "c" net000PASS
P&L Nov C13 = Purchases.xlsx "o" net237.5237.50PASS
P&L Nov C21 = Purchases.xlsx "r" net100010000PASS
P&L Nov C22 = Purchases.xlsx "p" net000PASS
P&L Nov C23 = Purchases.xlsx "t" net000PASS
P&L Nov C24 = Purchases.xlsx "q" net000PASS
P&L Nov C25 = Purchases.xlsx "m" net1001000PASS
P&L Nov C26 = Purchases.xlsx "u" net130.83130.833333333333+0.003333333332989241PASS
P&L Nov C27 = Purchases.xlsx "a" net000PASS
P&L Nov C28 = Purchases.xlsx "g" net112.5112.50PASS
P&L Nov C29 = Purchases.xlsx "h" net76.6776.6666666666667-0.00333333333330188PASS
P&L Nov C30 = Purchases.xlsx "v" net501.88501.875-0.0049999999999954525PASS
P&L Nov C31 = Purchases.xlsx "n" net120012000PASS
P&L Nov C32 = Purchases.xlsx "f" net1501500PASS
P&L Nov C33 = Purchases.xlsx "l" net2502500PASS
P&L Nov C37 = Purchases.xlsx "y" net000PASS
P&L Nov C38 = Purchases.xlsx "z" net000PASS
P&L Dec D12 = Purchases.xlsx "c" net000PASS
P&L Dec D13 = Purchases.xlsx "o" net207.5207.50PASS
P&L Dec D21 = Purchases.xlsx "r" net100010000PASS
P&L Dec D22 = Purchases.xlsx "p" net000PASS
P&L Dec D23 = Purchases.xlsx "t" net1501500PASS
P&L Dec D24 = Purchases.xlsx "q" net2002000PASS
P&L Dec D25 = Purchases.xlsx "m" net000PASS
P&L Dec D26 = Purchases.xlsx "u" net95.8395.8333333333333+0.00333333333330188PASS
P&L Dec D27 = Purchases.xlsx "a" net5005000PASS
P&L Dec D28 = Purchases.xlsx "g" net127.5127.50PASS
P&L Dec D29 = Purchases.xlsx "h" net126.67126.666666666667-0.003333333333003452PASS
P&L Dec D30 = Purchases.xlsx "v" net5555550PASS
P&L Dec D31 = Purchases.xlsx "n" net000PASS
P&L Dec D32 = Purchases.xlsx "f" net000PASS
P&L Dec D33 = Purchases.xlsx "l" net2502500PASS
P&L Dec D37 = Purchases.xlsx "y" net000PASS
P&L Dec D38 = Purchases.xlsx "z" net000PASS
P&L Jan E12 = Purchases.xlsx "c" net4166.674166.66666666667-0.003333333330374444PASS
P&L Jan E13 = Purchases.xlsx "o" net237.5237.50PASS
P&L Jan E21 = Purchases.xlsx "r" net100010000PASS
P&L Jan E22 = Purchases.xlsx "p" net3003000PASS
P&L Jan E23 = Purchases.xlsx "t" net000PASS
P&L Jan E24 = Purchases.xlsx "q" net000PASS
P&L Jan E25 = Purchases.xlsx "m" net000PASS
P&L Jan E26 = Purchases.xlsx "u" net120.83120.833333333333+0.003333333333003452PASS
P&L Jan E27 = Purchases.xlsx "a" net000PASS
P&L Jan E28 = Purchases.xlsx "g" net192.5192.50PASS
P&L Jan E29 = Purchases.xlsx "h" net226.67226.666666666667-0.003333333332989241PASS
P&L Jan E30 = Purchases.xlsx "v" net5455450PASS
P&L Jan E31 = Purchases.xlsx "n" net000PASS
P&L Jan E32 = Purchases.xlsx "f" net000PASS
P&L Jan E33 = Purchases.xlsx "l" net458.33458.333333333333+0.003333333332989241PASS
P&L Jan E37 = Purchases.xlsx "y" net000PASS
P&L Jan E38 = Purchases.xlsx "z" net000PASS
P&L Feb F12 = Purchases.xlsx "c" net000PASS
P&L Feb F13 = Purchases.xlsx "o" net207.5207.50PASS
P&L Feb F21 = Purchases.xlsx "r" net100010000PASS
P&L Feb F22 = Purchases.xlsx "p" net000PASS
P&L Feb F23 = Purchases.xlsx "t" net1001000PASS
P&L Feb F24 = Purchases.xlsx "q" net4004000PASS
P&L Feb F25 = Purchases.xlsx "m" net1501500PASS
P&L Feb F26 = Purchases.xlsx "u" net95.8395.8333333333333+0.00333333333330188PASS
P&L Feb F27 = Purchases.xlsx "a" net4004000PASS
P&L Feb F28 = Purchases.xlsx "g" net132.5132.50PASS
P&L Feb F29 = Purchases.xlsx "h" net76.6776.6666666666667-0.00333333333330188PASS
P&L Feb F30 = Purchases.xlsx "v" net486.88486.875-0.0049999999999954525PASS
P&L Feb F31 = Purchases.xlsx "n" net000PASS
P&L Feb F32 = Purchases.xlsx "f" net1501500PASS
P&L Feb F33 = Purchases.xlsx "l" net2502500PASS
P&L Feb F37 = Purchases.xlsx "y" net000PASS
P&L Feb F38 = Purchases.xlsx "z" net250025000PASS
P&L Mar G12 = Purchases.xlsx "c" net000PASS
P&L Mar G13 = Purchases.xlsx "o" net237.5237.50PASS
P&L Mar G21 = Purchases.xlsx "r" net100010000PASS
P&L Mar G22 = Purchases.xlsx "p" net000PASS
P&L Mar G23 = Purchases.xlsx "t" net000PASS
P&L Mar G24 = Purchases.xlsx "q" net000PASS
P&L Mar G25 = Purchases.xlsx "m" net2002000PASS
P&L Mar G26 = Purchases.xlsx "u" net135.83135.833333333333+0.003333333332989241PASS
P&L Mar G27 = Purchases.xlsx "a" net000PASS
P&L Mar G28 = Purchases.xlsx "g" net112.5112.50PASS
P&L Mar G29 = Purchases.xlsx "h" net116.67116.666666666667-0.003333333333003452PASS
P&L Mar G30 = Purchases.xlsx "v" net501.88501.875-0.0049999999999954525PASS
P&L Mar G31 = Purchases.xlsx "n" net000PASS
P&L Mar G32 = Purchases.xlsx "f" net000PASS
P&L Mar G33 = Purchases.xlsx "l" net2502500PASS
P&L Mar G37 = Purchases.xlsx "y" net000PASS
P&L Mar G38 = Purchases.xlsx "z" net000PASS
P&L Apr H12 = Purchases.xlsx "c" net000PASS
P&L Apr H13 = Purchases.xlsx "o" net207.5207.50PASS
P&L Apr H21 = Purchases.xlsx "r" net100010000PASS
P&L Apr H22 = Purchases.xlsx "p" net2502500PASS
P&L Apr H23 = Purchases.xlsx "t" net80800PASS
P&L Apr H24 = Purchases.xlsx "q" net3003000PASS
P&L Apr H25 = Purchases.xlsx "m" net000PASS
P&L Apr H26 = Purchases.xlsx "u" net95.8395.8333333333333+0.00333333333330188PASS
P&L Apr H27 = Purchases.xlsx "a" net000PASS
P&L Apr H28 = Purchases.xlsx "g" net122.5122.50PASS
P&L Apr H29 = Purchases.xlsx "h" net76.6776.6666666666667-0.00333333333330188PASS
P&L Apr H30 = Purchases.xlsx "v" net5905900PASS
P&L Apr H31 = Purchases.xlsx "n" net000PASS
P&L Apr H32 = Purchases.xlsx "f" net000PASS
P&L Apr H33 = Purchases.xlsx "l" net1223.331223.33333333333+0.0033333333301470702PASS
P&L Apr H37 = Purchases.xlsx "y" net000PASS
P&L Apr H38 = Purchases.xlsx "z" net000PASS
P&L May I12 = Purchases.xlsx "c" net000PASS
P&L May I13 = Purchases.xlsx "o" net237.5237.50PASS
P&L May I21 = Purchases.xlsx "r" net100010000PASS
P&L May I22 = Purchases.xlsx "p" net000PASS
P&L May I23 = Purchases.xlsx "t" net000PASS
P&L May I24 = Purchases.xlsx "q" net000PASS
P&L May I25 = Purchases.xlsx "m" net80800PASS
P&L May I26 = Purchases.xlsx "u" net125.83125.833333333333+0.003333333333003452PASS
P&L May I27 = Purchases.xlsx "a" net250025000PASS
P&L May I28 = Purchases.xlsx "g" net112.5112.50PASS
P&L May I29 = Purchases.xlsx "h" net176.67176.666666666667-0.003333333332989241PASS
P&L May I30 = Purchases.xlsx "v" net505.63505.625-0.0049999999999954525PASS
P&L May I31 = Purchases.xlsx "n" net3003000PASS
P&L May I32 = Purchases.xlsx "f" net1501500PASS
P&L May I33 = Purchases.xlsx "l" net2502500PASS
P&L May I37 = Purchases.xlsx "y" net000PASS
P&L May I38 = Purchases.xlsx "z" net000PASS
P&L Jun J12 = Purchases.xlsx "c" net250025000PASS
P&L Jun J13 = Purchases.xlsx "o" net207.5207.50PASS
P&L Jun J21 = Purchases.xlsx "r" net100010000PASS
P&L Jun J22 = Purchases.xlsx "p" net000PASS
P&L Jun J23 = Purchases.xlsx "t" net2002000PASS
P&L Jun J24 = Purchases.xlsx "q" net000PASS
P&L Jun J25 = Purchases.xlsx "m" net000PASS
P&L Jun J26 = Purchases.xlsx "u" net95.8395.8333333333333+0.00333333333330188PASS
P&L Jun J27 = Purchases.xlsx "a" net000PASS
P&L Jun J28 = Purchases.xlsx "g" net137.5137.50PASS
P&L Jun J29 = Purchases.xlsx "h" net136.67136.666666666667-0.003333333332989241PASS
P&L Jun J30 = Purchases.xlsx "v" net537.5537.50PASS
P&L Jun J31 = Purchases.xlsx "n" net000PASS
P&L Jun J32 = Purchases.xlsx "f" net000PASS
P&L Jun J33 = Purchases.xlsx "l" net2502500PASS
P&L Jun J37 = Purchases.xlsx "y" net000PASS
P&L Jun J38 = Purchases.xlsx "z" net000PASS
P&L Jul K12 = Purchases.xlsx "c" net000PASS
P&L Jul K13 = Purchases.xlsx "o" net237.5237.50PASS
P&L Jul K21 = Purchases.xlsx "r" net100010000PASS
P&L Jul K22 = Purchases.xlsx "p" net3503500PASS
P&L Jul K23 = Purchases.xlsx "t" net000PASS
P&L Jul K24 = Purchases.xlsx "q" net000PASS
P&L Jul K25 = Purchases.xlsx "m" net000PASS
P&L Jul K26 = Purchases.xlsx "u" net115.83115.833333333333+0.003333333333003452PASS
P&L Jul K27 = Purchases.xlsx "a" net000PASS
P&L Jul K28 = Purchases.xlsx "g" net212.5212.50PASS
P&L Jul K29 = Purchases.xlsx "h" net76.6776.6666666666667-0.00333333333330188PASS
P&L Jul K30 = Purchases.xlsx "v" net511.25511.250PASS
P&L Jul K31 = Purchases.xlsx "n" net000PASS
P&L Jul K32 = Purchases.xlsx "f" net000PASS
P&L Jul K33 = Purchases.xlsx "l" net389.17389.166666666667-0.003333333332989241PASS
P&L Jul K37 = Purchases.xlsx "y" net416.67416.666666666667-0.003333333332989241PASS
P&L Jul K38 = Purchases.xlsx "z" net000PASS
P&L Aug L12 = Purchases.xlsx "c" net000PASS
P&L Aug L13 = Purchases.xlsx "o" net207.5207.50PASS
P&L Aug L21 = Purchases.xlsx "r" net100010000PASS
P&L Aug L22 = Purchases.xlsx "p" net000PASS
P&L Aug L23 = Purchases.xlsx "t" net1501500PASS
P&L Aug L24 = Purchases.xlsx "q" net1501500PASS
P&L Aug L25 = Purchases.xlsx "m" net1201200PASS
P&L Aug L26 = Purchases.xlsx "u" net95.8395.8333333333333+0.00333333333330188PASS
P&L Aug L27 = Purchases.xlsx "a" net4004000PASS
P&L Aug L28 = Purchases.xlsx "g" net127.5127.50PASS
P&L Aug L29 = Purchases.xlsx "h" net76.6776.6666666666667-0.00333333333330188PASS
P&L Aug L30 = Purchases.xlsx "v" net531.88531.875-0.0049999999999954525PASS
P&L Aug L31 = Purchases.xlsx "n" net000PASS
P&L Aug L32 = Purchases.xlsx "f" net1501500PASS
P&L Aug L33 = Purchases.xlsx "l" net2502500PASS
P&L Aug L37 = Purchases.xlsx "y" net000PASS
P&L Aug L38 = Purchases.xlsx "z" net000PASS
P&L Sep M12 = Purchases.xlsx "c" net000PASS
P&L Sep M13 = Purchases.xlsx "o" net237.5237.50PASS
P&L Sep M21 = Purchases.xlsx "r" net100010000PASS
P&L Sep M22 = Purchases.xlsx "p" net000PASS
P&L Sep M23 = Purchases.xlsx "t" net000PASS
P&L Sep M24 = Purchases.xlsx "q" net3003000PASS
P&L Sep M25 = Purchases.xlsx "m" net3003000PASS
P&L Sep M26 = Purchases.xlsx "u" net110.83110.833333333333+0.003333333333003452PASS
P&L Sep M27 = Purchases.xlsx "a" net000PASS
P&L Sep M28 = Purchases.xlsx "g" net112.5112.50PASS
P&L Sep M29 = Purchases.xlsx "h" net306.67306.666666666667-0.003333333332989241PASS
P&L Sep M30 = Purchases.xlsx "v" net496.25496.250PASS
P&L Sep M31 = Purchases.xlsx "n" net000PASS
P&L Sep M32 = Purchases.xlsx "f" net000PASS
P&L Sep M33 = Purchases.xlsx "l" net2502500PASS
P&L Sep M37 = Purchases.xlsx "y" net000PASS
P&L Sep M38 = Purchases.xlsx "z" net000PASS
P&L Oct N12 = Purchases.xlsx "c" net000PASS
P&L Oct N13 = Purchases.xlsx "o" net207.5207.50PASS
P&L Oct N21 = Purchases.xlsx "r" net100010000PASS
P&L Oct N22 = Purchases.xlsx "p" net3003000PASS
P&L Oct N23 = Purchases.xlsx "t" net1201200PASS
P&L Oct N24 = Purchases.xlsx "q" net000PASS
P&L Oct N25 = Purchases.xlsx "m" net000PASS
P&L Oct N26 = Purchases.xlsx "u" net95.8395.8333333333333+0.00333333333330188PASS
P&L Oct N27 = Purchases.xlsx "a" net000PASS
P&L Oct N28 = Purchases.xlsx "g" net132.5132.50PASS
P&L Oct N29 = Purchases.xlsx "h" net76.6776.6666666666667-0.00333333333330188PASS
P&L Oct N30 = Purchases.xlsx "v" net568.75568.750PASS
P&L Oct N31 = Purchases.xlsx "n" net000PASS
P&L Oct N32 = Purchases.xlsx "f" net000PASS
P&L Oct N33 = Purchases.xlsx "l" net354.17354.166666666667-0.003333333332989241PASS
P&L Oct N37 = Purchases.xlsx "y" net000PASS
P&L Oct N38 = Purchases.xlsx "z" net000PASS
P&L Nov turnover = Sales.xlsx Nov net less bad debts and asset sales27833.333333333327833.33333333330PASS
P&L Nov expense lines = Purchases.xlsx Nov net less materials, wages and asset purchases3759.3753759.3750PASS
P&L Dec turnover = Sales.xlsx Dec net less bad debts and asset sales27433.333333333327433.33333333330PASS
P&L Dec expense lines = Purchases.xlsx Dec net less materials, wages and asset purchases3212.53212.50PASS
P&L Jan turnover = Sales.xlsx Jan net less bad debts and asset sales29333.333333333329333.33333333330PASS
P&L Jan expense lines = Purchases.xlsx Jan net less materials, wages and asset purchases7247.57247.500000000003+2.7284841053187847e-12PASS
P&L Feb turnover = Sales.xlsx Feb net less bad debts and asset sales28133.333333333328133.33333333330PASS
P&L Feb expense lines = Purchases.xlsx Feb net less materials, wages and asset purchases5949.3755949.3750PASS
P&L Mar turnover = Sales.xlsx Mar net less bad debts and asset sales30016.666666666730016.6666666666-1.0186340659856796e-10PASS
P&L Mar expense lines = Purchases.xlsx Mar net less materials, wages and asset purchases2554.3750000000032554.375-3.183231456205249e-12PASS
P&L Apr turnover = Sales.xlsx Apr net less bad debts and asset sales28133.333333333328133.33333333330PASS
P&L Apr expense lines = Purchases.xlsx Apr net less materials, wages and asset purchases3945.83333333329943945.8333333333294+3.001332515850663e-11PASS
P&L May turnover = Sales.xlsx May net less bad debts and asset sales29633.333333333329633.33333333330PASS
P&L May expense lines = Purchases.xlsx May net less materials, wages and asset purchases5438.1255438.1250PASS
P&L Jun turnover = Sales.xlsx Jun net less bad debts and asset sales29433.333333333329433.33333333330PASS
P&L Jun expense lines = Purchases.xlsx Jun net less materials, wages and asset purchases50655065.000000000001+9.094947017729282e-13PASS
P&L Jul turnover = Sales.xlsx Jul net less bad debts and asset sales27333.333333333327333.33333333330PASS
P&L Jul expense lines = Purchases.xlsx Jul net less materials, wages and asset purchases3309.58333333333033309.583333333334+3.637978807091713e-12PASS
P&L Aug turnover = Sales.xlsx Aug net less bad debts and asset sales29533.333333333329533.33333333330PASS
P&L Aug expense lines = Purchases.xlsx Aug net less materials, wages and asset purchases3259.3753259.3749999999995-4.547473508864641e-13PASS
P&L Sep turnover = Sales.xlsx Sep net less bad debts and asset sales28633.333333333328633.33333333330PASS
P&L Sep expense lines = Purchases.xlsx Sep net less materials, wages and asset purchases3113.753113.750PASS
P&L Oct turnover = Sales.xlsx Oct net less bad debts and asset sales25833.333333333325833.33333333330PASS
P&L Oct expense lines = Purchases.xlsx Oct net less materials, wages and asset purchases2855.416666666672855.416666666667-3.183231456205249e-12PASS
Payslips calendar: the payroll year opens on 6 April6 April6 April 2027PASS
Payslips calendar: payroll month 1 opens on the first day of tax week 146483464830PASS
Payslips calendar: payroll month 1 opens tax week 1110PASS
Payslips calendar: payroll month 1 names the Nov tabNovNovPASS
Payslips calendar: payroll month 2 opens on the first day of tax week 546509465090PASS
Payslips calendar: payroll month 2 opens tax week 5550PASS
Payslips calendar: payroll month 2 names the Dec tabDecDecPASS
Payslips calendar: payroll month 3 opens on the first day of tax week 946537465370PASS
Payslips calendar: payroll month 3 opens tax week 9990PASS
Payslips calendar: payroll month 3 names the Jan tabJanJanPASS
Payslips calendar: payroll month 4 opens on the first day of tax week 1446572465720PASS
Payslips calendar: payroll month 4 opens tax week 1414140PASS
Payslips calendar: payroll month 4 names the Feb tabFebFebPASS
Payslips calendar: payroll month 5 opens on the first day of tax week 1846600466000PASS
Payslips calendar: payroll month 5 opens tax week 1818180PASS
Payslips calendar: payroll month 5 names the Mar tabMarMarPASS
Payslips calendar: payroll month 6 opens on the first day of tax week 2246628466280PASS
Payslips calendar: payroll month 6 opens tax week 2222220PASS
Payslips calendar: payroll month 6 names the Apr tabAprAprPASS
Payslips calendar: payroll month 7 opens on the first day of tax week 2746663466630PASS
Payslips calendar: payroll month 7 opens tax week 2727270PASS
Payslips calendar: payroll month 7 names the May tabMayMayPASS
Payslips calendar: payroll month 8 opens on the first day of tax week 3146691466910PASS
Payslips calendar: payroll month 8 opens tax week 3131310PASS
Payslips calendar: payroll month 8 names the Jun tabJunJunPASS
Payslips calendar: payroll month 9 opens on the first day of tax week 3546719467190PASS
Payslips calendar: payroll month 9 opens tax week 3535350PASS
Payslips calendar: payroll month 9 names the Jul tabJulJulPASS
Payslips calendar: payroll month 10 opens on the first day of tax week 4046754467540PASS
Payslips calendar: payroll month 10 opens tax week 4040400PASS
Payslips calendar: payroll month 10 names the Aug tabAugAugPASS
Payslips calendar: payroll month 11 opens on the first day of tax week 4446782467820PASS
Payslips calendar: payroll month 11 opens tax week 4444440PASS
Payslips calendar: payroll month 11 names the Sep tabSepSepPASS
Payslips calendar: payroll month 12 opens on the first day of tax week 4846810468100PASS
Payslips calendar: payroll month 12 opens tax week 4848480PASS
Payslips calendar: payroll month 12 names the Oct tabOctOctPASS
Payslips calendar: the payroll months are numbered one to twelve in order000PASS
Payslips calendar: every payroll month opens on its own first week12120PASS
Payslips!Payment B4 tax month 1 ends on the last day of Apr46507465070PASS
Payslips!Payment C4 tax month 1 is due on the 19th after it46526465260PASS
Payslips!Payment B5 tax month 2 ends on the last day of May46538465380PASS
Payslips!Payment C5 tax month 2 is due on the 19th after it46557465570PASS
Payslips!Payment B6 tax month 3 ends on the last day of Jun46568465680PASS
Payslips!Payment C6 tax month 3 is due on the 19th after it46587465870PASS
Payslips!Payment B7 tax month 4 ends on the last day of Jul46599465990PASS
Payslips!Payment C7 tax month 4 is due on the 19th after it46618466180PASS
Payslips!Payment B8 tax month 5 ends on the last day of Aug46630466300PASS
Payslips!Payment C8 tax month 5 is due on the 19th after it46649466490PASS
Payslips!Payment B9 tax month 6 ends on the last day of Sep46660466600PASS
Payslips!Payment C9 tax month 6 is due on the 19th after it46679466790PASS
Payslips!Payment B10 tax month 7 ends on the last day of Oct46691466910PASS
Payslips!Payment C10 tax month 7 is due on the 19th after it46710467100PASS
Payslips!Payment B11 tax month 8 ends on the last day of Nov46721467210PASS
Payslips!Payment C11 tax month 8 is due on the 19th after it46740467400PASS
Payslips!Payment B12 tax month 9 ends on the last day of Dec46752467520PASS
Payslips!Payment C12 tax month 9 is due on the 19th after it46771467710PASS
Payslips!Payment B13 tax month 10 ends on the last day of Jan46783467830PASS
Payslips!Payment C13 tax month 10 is due on the 19th after it46802468020PASS
Payslips!Payment B14 tax month 11 ends on the last day of Feb46812468120PASS
Payslips!Payment C14 tax month 11 is due on the 19th after it46831468310PASS
Payslips!Payment B15 tax month 12 ends on the last day of Mar46843468430PASS
Payslips!Payment C15 tax month 12 is due on the 19th after it46862468620PASS
Payslips!Nov K49 the monthly payroll opens in the accounting period's Nov46327463270PASS
Payslips!Dec K49 the monthly payroll opens in the accounting period's Dec46357463570PASS
Payslips!Jan K59 the monthly payroll opens in the accounting period's Jan46388463880PASS
Payslips!Feb K49 the monthly payroll opens in the accounting period's Feb46419464190PASS
Payslips!Mar K49 the monthly payroll opens in the accounting period's Mar46447464470PASS
Payslips!Apr K59 the monthly payroll opens in the accounting period's Apr46478464780PASS
Payslips!May K49 the monthly payroll opens in the accounting period's May46508465080PASS
Payslips!Jun K49 the monthly payroll opens in the accounting period's Jun46539465390PASS
Payslips!Jul K59 the monthly payroll opens in the accounting period's Jul46569465690PASS
Payslips!Aug K49 the monthly payroll opens in the accounting period's Aug46600466000PASS
Payslips!Sep K49 the monthly payroll opens in the accounting period's Sep46631466310PASS
Payslips!Oct K69 the monthly payroll opens in the accounting period's Oct46661466610PASS
WagesInterface employees Nov C4 gross pay570057000PASS
WagesInterface employees Nov D4 income tax8008000PASS
WagesInterface employees Nov E4 employee NI2962960PASS
WagesInterface employees Nov H4 employer NI5705700PASS
WagesInterface directors Nov C17 gross pay104810480PASS
WagesInterface directors Nov D17 income tax000PASS
WagesInterface directors Nov E17 employee NI000PASS
WagesInterface directors Nov H17 employer NI7.27.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 employees Dec C5 gross pay570057000PASS
WagesInterface employees Dec D5 income tax8008000PASS
WagesInterface employees Dec E5 employee NI2962960PASS
WagesInterface employees Dec H5 employer NI5705700PASS
WagesInterface directors Dec C18 gross pay104810480PASS
WagesInterface directors Dec D18 income tax000PASS
WagesInterface directors Dec E18 employee NI000PASS
WagesInterface directors Dec H18 employer NI7.27.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 employees Jan C6 gross pay570057000PASS
WagesInterface employees Jan D6 income tax8008000PASS
WagesInterface employees Jan E6 employee NI2962960PASS
WagesInterface employees Jan H6 employer NI5705700PASS
WagesInterface directors Jan C19 gross pay104810480PASS
WagesInterface directors Jan D19 income tax000PASS
WagesInterface directors Jan E19 employee NI000PASS
WagesInterface directors Jan H19 employer NI7.27.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 employees Feb C7 gross pay570057000PASS
WagesInterface employees Feb D7 income tax8008000PASS
WagesInterface employees Feb E7 employee NI2962960PASS
WagesInterface employees Feb H7 employer NI5705700PASS
WagesInterface directors Feb C20 gross pay104810480PASS
WagesInterface directors Feb D20 income tax000PASS
WagesInterface directors Feb E20 employee NI000PASS
WagesInterface directors Feb H20 employer NI7.27.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 employees Mar C8 gross pay570057000PASS
WagesInterface employees Mar D8 income tax8008000PASS
WagesInterface employees Mar E8 employee NI2962960PASS
WagesInterface employees Mar H8 employer NI5705700PASS
WagesInterface directors Mar C21 gross pay104810480PASS
WagesInterface directors Mar D21 income tax000PASS
WagesInterface directors Mar E21 employee NI000PASS
WagesInterface directors Mar H21 employer NI7.27.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
WagesInterface employees Apr C9 gross pay570057000PASS
WagesInterface employees Apr D9 income tax8008000PASS
WagesInterface employees Apr E9 employee NI2962960PASS
WagesInterface employees Apr H9 employer NI5705700PASS
WagesInterface directors Apr C22 gross pay104810480PASS
WagesInterface directors Apr D22 income tax000PASS
WagesInterface directors Apr E22 employee NI000PASS
WagesInterface directors Apr H22 employer NI7.27.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 employees May C10 gross pay570057000PASS
WagesInterface employees May D10 income tax8008000PASS
WagesInterface employees May E10 employee NI2962960PASS
WagesInterface employees May H10 employer NI5705700PASS
WagesInterface directors May C23 gross pay104810480PASS
WagesInterface directors May D23 income tax000PASS
WagesInterface directors May E23 employee NI000PASS
WagesInterface directors May H23 employer NI7.27.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 employees Jun C11 gross pay570057000PASS
WagesInterface employees Jun D11 income tax8008000PASS
WagesInterface employees Jun E11 employee NI2962960PASS
WagesInterface employees Jun H11 employer NI5705700PASS
WagesInterface directors Jun C24 gross pay104810480PASS
WagesInterface directors Jun D24 income tax000PASS
WagesInterface directors Jun E24 employee NI000PASS
WagesInterface directors Jun H24 employer NI7.27.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 employees Jul C12 gross pay570057000PASS
WagesInterface employees Jul D12 income tax8008000PASS
WagesInterface employees Jul E12 employee NI2962960PASS
WagesInterface employees Jul H12 employer NI5705700PASS
WagesInterface directors Jul C25 gross pay104810480PASS
WagesInterface directors Jul D25 income tax000PASS
WagesInterface directors Jul E25 employee NI000PASS
WagesInterface directors Jul H25 employer NI7.27.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 employees Aug C13 gross pay570057000PASS
WagesInterface employees Aug D13 income tax8008000PASS
WagesInterface employees Aug E13 employee NI2962960PASS
WagesInterface employees Aug H13 employer NI5705700PASS
WagesInterface directors Aug C26 gross pay104810480PASS
WagesInterface directors Aug D26 income tax000PASS
WagesInterface directors Aug E26 employee NI000PASS
WagesInterface directors Aug H26 employer NI7.27.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 employees Sep C14 gross pay570057000PASS
WagesInterface employees Sep D14 income tax8008000PASS
WagesInterface employees Sep E14 employee NI2962960PASS
WagesInterface employees Sep H14 employer NI5705700PASS
WagesInterface directors Sep C27 gross pay104810480PASS
WagesInterface directors Sep D27 income tax000PASS
WagesInterface directors Sep E27 employee NI000PASS
WagesInterface directors Sep H27 employer NI7.27.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 employees Oct C15 gross pay570057000PASS
WagesInterface employees Oct D15 income tax8008000PASS
WagesInterface employees Oct E15 employee NI2962960PASS
WagesInterface employees Oct H15 employer NI5705700PASS
WagesInterface directors Oct C28 gross pay104810480PASS
WagesInterface directors Oct D28 income tax000PASS
WagesInterface directors Oct E28 employee NI000PASS
WagesInterface directors Oct H28 employer NI7.27.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
Payslips print: the page reads the Dec tabDecDecPASS
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 wages46387463870PASS
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 wages46387463870PASS
Payslips!Feb F51 employee nameAlice JohnsonAlice JohnsonPASS
Payslips!Feb M51 gross pay350035000PASS
Payslips!Feb N51 income tax5305300PASS
Payslips!Feb O51 employee NI2002000PASS
Payslips!Feb R51 net pay277027700PASS
Payslips!Feb T51 employer NI382.5382.50PASS
Payslips!Feb S51 referencePAY-EMP001-2025-07PAY-EMP001-2025-07PASS
Payslips!Feb F52 employee nameBob WilliamsBob WilliamsPASS
Payslips!Feb M52 gross pay220022000PASS
Payslips!Feb N52 income tax2702700PASS
Payslips!Feb O52 employee NI96960PASS
Payslips!Feb R52 net pay183418340PASS
Payslips!Feb T52 employer NI187.5187.50PASS
Payslips!Feb S52 referencePAY-EMP002-2025-07PAY-EMP002-2025-07PASS
Payslips!Feb F53 employee nameCarol SmithCarol SmithPASS
Payslips!Feb M53 gross pay104810480PASS
Payslips!Feb N53 income tax000PASS
Payslips!Feb O53 employee NI000PASS
Payslips!Feb R53 net pay104810480PASS
Payslips!Feb T53 employer NI7.27.20PASS
Payslips!Feb S53 referencePAY-EMP003-2025-07PAY-EMP003-2025-07PASS
Payslips!Feb M49 wages paid date46446464460PASS
Payslips!Mar F51 employee nameAlice JohnsonAlice JohnsonPASS
Payslips!Mar M51 gross pay350035000PASS
Payslips!Mar N51 income tax5305300PASS
Payslips!Mar O51 employee NI2002000PASS
Payslips!Mar R51 net pay277027700PASS
Payslips!Mar T51 employer NI382.5382.50PASS
Payslips!Mar S51 referencePAY-EMP001-2025-08PAY-EMP001-2025-08PASS
Payslips!Mar F52 employee nameBob WilliamsBob WilliamsPASS
Payslips!Mar M52 gross pay220022000PASS
Payslips!Mar N52 income tax2702700PASS
Payslips!Mar O52 employee NI96960PASS
Payslips!Mar R52 net pay183418340PASS
Payslips!Mar T52 employer NI187.5187.50PASS
Payslips!Mar S52 referencePAY-EMP002-2025-08PAY-EMP002-2025-08PASS
Payslips!Mar F53 employee nameCarol SmithCarol SmithPASS
Payslips!Mar M53 gross pay104810480PASS
Payslips!Mar N53 income tax000PASS
Payslips!Mar O53 employee NI000PASS
Payslips!Mar R53 net pay104810480PASS
Payslips!Mar T53 employer NI7.27.20PASS
Payslips!Mar S53 referencePAY-EMP003-2025-08PAY-EMP003-2025-08PASS
Payslips!Mar M49 wages paid date46477464770PASS
Payslips!Feb F11 weekly employee line (every employee here pays monthly)PASS
Payslips!Feb F12 weekly employee line (every employee here pays monthly)PASS
Payslips!Feb F13 weekly employee line (every employee here pays monthly)PASS
Payslips!Feb F14 weekly employee line (every employee here pays monthly)PASS
Payslips!Feb F15 weekly employee line (every employee here pays monthly)PASS
Payslips!Feb T41 period total (no weekly employer NI to bring forward)000PASS
Payslips!Mar H11 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar I11 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar J11 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar L11 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar M11 brought forward (no weekly cycle carried over)PASS
Payslips!Mar H12 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar I12 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar J12 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar L12 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar K12 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar M12 brought forward (no weekly cycle carried over)PASS
Payslips!Mar H13 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar I13 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar J13 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar L13 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar K13 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar M13 brought forward (no weekly cycle carried over)PASS
Payslips!Mar H14 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar I14 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar J14 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar L14 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar K14 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar M14 brought forward (no weekly cycle carried over)PASS
Payslips!Mar H15 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar I15 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar J15 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar L15 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar K15 brought forward (no weekly cycle carried over)000PASS
Payslips!Mar M15 brought forward (no weekly cycle carried over)PASS
MnthP&L: PAYE Wages + Non-PAYE Employee (B18) = employees' gross pay + Purchases w-coded net69066.6769066.6666666667-0.0033333332976326346PASS
MnthP&L: Directors Wages (B19) = directors' gross pay + Purchases d-coded net16742.6716742.6666666667-0.0033333332976326346PASS
MnthP&L: Employers National Insurance (B20) = payroll employer NI6926.3999999999996926.4+9.094947017729282e-13PASS
Trial Balance: PAYE/NI creditor first-month movement (L34) = that month's payroll tax due-1673.2-1673.20PASS
Admin P6: corporation tax small profits rate19190PASS
Admin P7: corporation tax small profits rate (second year)19190PASS
Admin P8: corporation tax main rate25250PASS
Admin P9: marginal relief fraction0.0150.0150PASS
Admin P12: marginal relief lower limit50000500000PASS
Admin P13: marginal relief upper limit2500002500000PASS
Admin G5: annual investment allowance1001000PASS
Admin G7: annual investment allowance (new assets)1001000PASS
Admin G6: writing down allowance14140PASS
Admin G8: writing down allowance (new assets)14140PASS
Admin G15: depreciation rate, land and property000PASS
Admin G16: depreciation rate, plant and machinery0.10.10PASS
Admin G17: depreciation rate, fixtures and fittings0.20.20PASS
Admin G18: depreciation rate, computer equipment0.330.330PASS
Admin G19: depreciation rate, motor vehicles0.250.250PASS
Admin N16: mileage higher rate limit10000100000PASS
Admin O16: mileage higher rate pence0.450.450PASS
Admin N17: mileage lower rate start10001100010PASS
Admin O17: mileage lower rate pence0.250.250PASS
Admin M19: standard VAT rate20200PASS
Admin M21: standard VAT rate (second period)20200PASS
Admin: year-end seed = the package's own year end46691466910PASS
Admin: year-end seed drives the accounting period anchor46691466910PASS
Published P&L: year end = Admin year-end seed46691466910PASS
Published balance sheet: date = Admin year-end seed46691466910PASS
Fixed asset note: year end = Admin year-end seed46691466910PASS
Admin: accounting period is twelve months3653650PASS
Admin: first financial year row starts at the accounting period start46327463270PASS
Admin: second financial year row starts the day the first one ends46478464780PASS
Admin: second financial year row ends at the year end46691466910PASS
CT: working sheet heading starts at the accounting period start46327463270PASS
CT: working sheet heading ends at the year end46691466910PASS
CT: the two tax rows span the accounting period3653650PASS
CT600: return period starts at the accounting period start46327463270PASS
CT600: return period ends at the year end46691466910PASS
Expenses form Month 01: mileage rate = tax data0.450.450PASS
Expenses form Month 02: mileage rate = tax data0.450.450PASS
Expenses form Month 03: mileage rate = tax data0.450.450PASS
Expenses form Month 04: mileage rate = tax data0.450.450PASS
Expenses form Month 05: mileage rate = tax data0.450.450PASS
Expenses form Month 06: mileage rate = tax data0.450.450PASS
Expenses form Month 07: mileage rate = tax data0.450.450PASS
Expenses form Month 08: mileage rate = tax data0.450.450PASS
Expenses form Month 09: mileage rate = tax data0.450.450PASS
Expenses form Month 10: mileage rate = tax data0.450.450PASS
Expenses form Month 11: mileage rate = tax data0.450.450PASS
Expenses form Month 12: mileage rate = tax data0.450.450PASS
Fixed asset note: depreciation rate, land and property000PASS
Fixed asset note: depreciation rate, plant and machinery0.10.10PASS
Fixed asset note: depreciation rate, fixtures and fittings0.20.20PASS
Fixed asset note: depreciation rate, computer equipment0.330.330PASS
Fixed asset note: depreciation rate, motor vehicles0.250.250PASS
Published P&L: operating profit = management P&L operating profit171840.391666666171840.3916666660PASS
CT: operating profit = published P&L operating profit171840.391666666171840.3916666660PASS
CT: depreciation add-back = P&L depreciation13740137400PASS
CT: goodwill add-back = P&L goodwill written off250025000PASS
CT: add-backs = depreciation + goodwill16240162400PASS
CT: profit plus add-backs188080.391666666188080.3916666660PASS
CT: annual investment allowance = Schedule annual investment allowance52500525000PASS
CT: writing down allowances = Schedule writing down allowances336033600PASS
CT: balancing allowance on disposals = Schedule balancing allowance less balancing charge814081400PASS
CT: capital allowances = the allowance lines64000640000PASS
CT: profit after capital allowances124080.391666666124080.3916666660PASS
CT: chargeable profit = profit after allowances + interest - losses brought forward124419.8978395055124419.897839506+4.94765117764473e-10PASS
CT: chargeable profit = operating profit + add-backs - capital allowances + interest - losses124419.8978395055124419.897839506+4.94765117764473e-10PASS
CT600: turnover = published P&L turnover341283.333333333341283.3333333330PASS
CT600: trading profits = CT profit after capital allowances124080.391666666124080.3916666660PASS
CT600: losses brought forward = CT losses brought forward000PASS
CT600: net trading profits = trading profits - losses brought forward124080.391666666124080.3916666660PASS
CT600: interest received = CT interest received339.506172839506339.5061728395060PASS
CT600: profits before deductions = trading profits + interest124419.8978395055124419.897839506+4.94765117764473e-10PASS
CT600: profits chargeable = CT chargeable profit124419.897839506124419.8978395060PASS
CT600: financial year = first tax row financial year202620260PASS
CT600: amount of profit = first tax row profit51472.341297987351472.34129798730PASS
CT600: tax rate = first tax row rate25250PASS
CT600: corporation tax = first tax row gross tax12868.085324496812868.08532449680PASS
CT600: second financial year tax = second tax row gross tax18236.889135379618236.88913537960PASS
CT600: second financial year = second tax row financial year202720270PASS
CT600: second financial year profit = second tax row profit72947.556541518572947.55654151850PASS
CT600: second financial year rate = second tax row rate25250PASS
CT600: tax payable = tax chargeable31104.974459876431104.9744598765+9.822542779147625e-11PASS
CT600: marginal rate relief = the working sheet's relief1883.7015324074091883.70153240741+9.094947017729282e-13PASS
CT600: tax net of marginal relief = the working sheet's charge29221.27292746929221.2729274690PASS
CT600: corporation tax chargeable = tax net of marginal relief29221.27292746929221.2729274690PASS
CT600: underlying rate of corporation tax = the tax it bears over the profits chargeable23.48601263534442323.4860126353445+7.815970093361102e-14PASS
CT600: tax outstanding29156.766754629529156.76675462950PASS
Fixed asset note: corporation tax for the year = CT charge29221.27292746929221.2729274690PASS
Fixed asset note: directors emoluments = trial balance directors wages16742.666666666716742.66666666670PASS
CT: the two tax rows together span the days the charge is spread over3653650PASS
CT: first tax row profit = chargeable profit by its share of those days51472.3412979874151472.3412979873-1.0913936421275139e-10PASS
CT: second tax row profit = chargeable profit by its share of those days72947.5565415185872947.5565415185-8.731149137020111e-11PASS
CT: first tax row gross tax = its profit at its rate12868.08532449682412868.0853244968-2.3646862246096134e-11PASS
CT: second tax row gross tax = its profit at its rate18236.88913537962418236.8891353796-2.546585164964199e-11PASS
CT: first tax row tax = its gross tax less its marginal relief12088.80058095291112088.8005809529-1.0913936421275139e-11PASS
CT: second tax row tax = its gross tax less its marginal relief17132.4723465160817132.4723465161+2.1827872842550278e-11PASS
CT: charge for the year = the two tax rows29221.27292746929221.2729274690PASS
CT: first tax row rate = the rate its share of the profit falls in25250PASS
CT: second tax row rate = the rate its share of the profit falls in25250PASS
CT: first tax row marginal relief = its share of the profit against its share of the limits779.2847435438891779.284743543889-1.1368683772161603e-13PASS
CT: second tax row marginal relief = its share of the profit against its share of the limits1104.4167888635241104.41678886352-4.092726157978177e-12PASS
CT: both financial year rows carry the same small profits rate19190PASS
CT: Tax outstanding = CT less tax deducted at source29156.76675462949429156.7667546295+7.275957614183426e-12PASS
CT: charge for the year = the statutory computation with marginal relief29221.2729274690929221.272927469-9.094947017729282e-11PASS
Accounting profit to tax profit bridge closes to zero0-4.94765117764473e-10-4.94765117764473e-10PASS
Category netting: Sales Product A (sales a) net reaches MnthP&L!B4 with no residue000PASS
Category netting: Sales Product B (sales b) net reaches MnthP&L!B5 with no residue000PASS
Category netting: Sales Product C (sales c) net reaches MnthP&L!B6 with no residue000PASS
Category netting: Other Income (sales d) net reaches MnthP&L!B7 with no residue000PASS
Category netting: Investment Grants received (sales g) net reaches MnthP&L!B8 with no residue03.637978807091713e-12+3.637978807091713e-12PASS
Category netting: Bad Debts written off (sales o) net reaches MnthP&L!B34 negated with no residue000PASS
Category netting: Sub contractors (purchases c) net reaches MnthP&L!B12 with no residue0-2.7284841053187847e-12-2.7284841053187847e-12PASS
Category netting: Other Direct Cost of Sales (purchases o) net reaches MnthP&L!B13 with no residue000PASS
Category netting: Premises Rent & Rates (purchases r) net reaches MnthP&L!B21 with no residue000PASS
Category netting: Premises Light & Heating (purchases p) net reaches MnthP&L!B22 with no residue000PASS
Category netting: Distribution Transport Costs (purchases t) net reaches MnthP&L!B23 with no residue000PASS
Category netting: Equipment Tools & Plant Hire (purchases q) net reaches MnthP&L!B24 with no residue000PASS
Category netting: Repairs & Maintenance (purchases m) net reaches MnthP&L!B25 with no residue000PASS
Category netting: Consumable Materials (purchases u) net reaches MnthP&L!B26 with no residue000PASS
Category netting: Advertising & Promotion (purchases a) net reaches MnthP&L!B27 with no residue000PASS
Category netting: Telephone Postage & Stationery (purchases g) net reaches MnthP&L!B28 with no residue000PASS
Category netting: Travel & Hotel Expenses (purchases h) net reaches MnthP&L!B29 with no residue02.2737367544323206e-13+2.2737367544323206e-13PASS
Category netting: Motor Vehicle Expenses (purchases v) net reaches MnthP&L!B30 with no residue000PASS
Category netting: Insurance Costs (purchases n) net reaches MnthP&L!B31 with no residue000PASS
Category netting: Leasing Charges (purchases f) net reaches MnthP&L!B32 with no residue000PASS
Category netting: Legal & Professional Fees (purchases l) net reaches MnthP&L!B33 with no residue000PASS
Category netting: Charitable Donations (purchases y) net reaches MnthP&L!B37 with no residue0-3.979039320256561e-13-3.979039320256561e-13PASS
Category netting: Goodwill written off (purchases z) net reaches MnthP&L!B38 with no residue000PASS
Category netting: Wages and Salaries, less the employees' own gross pay (purchases w) net reaches MnthP&L!B18 less the employees' gross pay with no residue0-3.399236447876319e-11-3.399236447876319e-11PASS
Category netting: Directors Wages, less the directors' own gross pay (purchases d) net reaches MnthP&L!B19 less the directors' gross pay with no residue0-3.3651303965598345e-11-3.3651303965598345e-11PASS
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 Ltd
DescriptionIT consultancy and software development
Company number12345678
Address123 High Street
TownManchester
PostcodeM1 1AA
Phone0161 555 0100
Utr1234567890
Vat number123456789

Month by month

MonthSales entriesSales totalPurchases entriesPurchases totalBank entriesBank total
Apr933,400.00315,111.251887,740.20
May932,920.00346,375.001247,105.20
Jun935,200.003424,657.001663,180.20
Jul933,760.00349,059.251350,485.20
Aug1036,020.00324,405.251164,753.37
Sep1033,760.003413,375.001454,136.20
Oct1150,560.003543,005.7516108,005.20
Nov935,320.00316,918.001162,026.70
Dec832,800.00339,451.501246,142.20
Jan1135,440.00334,511.251356,365.20
Feb934,360.00334,396.501158,242.70
Mar831,360.00313,726.501549,372.20
Year112424,900.00395134,992.25162747,554.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
DateSupplierAccountDescriptionCodeAmount
2025-04-01WorkSpace Ltd5200Monthly office rentr1,200.00
2025-04-01Microsoft5501Microsoft 365 subscriptiong30.00
2025-04-01Slack5501Slack team subscriptiong15.00
2025-04-01GitHub5002GitHub Team subscriptiono45.00
2025-04-01Hiscox5700Professional indemnity insurancen1,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 itemsu22.00
2025-04-05Ryman5401Stationery suppliesu24.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 suppliesu36.00
2025-04-10Xerox5701Printer lease paymentf180.00
2025-04-10TechParts5000Hardware components for resales600.00
2025-04-12NCP5601Parking chargesv18.00
2025-04-14Toolstation5401Assorted fixings and partsu42.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 suppliesu18.00
2025-04-25Wilko5401Cleaning and kitchen suppliesu15.00
2025-04-25Mileage claim5601Business mileage to Manchesterv38.25
2025-04-28Shell5601Additional fuel purchasev120.00
2025-04-30Smith & Co5800Monthly accountancy retainerl300.00
May
DateSupplierAccountDescriptionCodeAmountReference
2025-05-01WorkSpace Ltd5200Monthly office rentr1,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 itemsu22.00
2025-05-05Ryman5401Stationery suppliesu24.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 hireq240.00
2025-05-10Amazon5401Office suppliesu36.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 deliveryt180.00
2025-05-20CableCo5000Cabling and connectorss240.00
2025-05-21Greggs5600Working lunchh8.00
2025-05-22Screwfix5401Miscellaneous suppliesu18.00
2025-05-22Halfords5601Vehicle maintenance suppliesv48.00
2025-05-25Wilko5401Cleaning and kitchen suppliesu15.00
2025-05-25Mileage claim5601Business mileage to Birminghamv54.00
2025-05-28Shell5601Additional fuel purchasev120.00
2025-05-31Smith & Co5800Monthly accountancy retainerl300.00
Jun
DateSupplierAccountDescriptionCodeAmountReferenceCis deduction
2025-06-01WorkSpace Ltd5200Monthly office rentr1,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 itemsu22.00
2025-06-05Ryman5401Stationery suppliesu24.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 suppliesu36.00
2025-06-10Vistaprint5501Business cards and flyersg96.00
2025-06-12NCP5601Parking chargesv18.00
2025-06-14Toolstation5401Assorted fixings and partsu30.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 suppliesu18.00
2025-06-25EnergySupply5201Quarterly utility billp360.00
2025-06-25Wilko5401Cleaning and kitchen suppliesu15.00
2025-06-25Mileage claim5601Business mileage to Londonv90.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
DateSupplierAccountDescriptionCodeAmountReference
2025-07-01WorkSpace Ltd5200Monthly office rentr1,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 amortisationz3,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 itemsu22.00
2025-07-05Ryman5401Stationery suppliesu24.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 suppliesu36.00
2025-07-10Xerox5701Printer lease paymentf180.00
2025-07-10TechParts5000Hardware components for resales720.00
2025-07-12NCP5601Parking chargesv18.00
2025-07-12ToolHire5301Equipment hire for installationq480.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 couriert120.00
2025-07-20Office Maintenance Ltd5400Premises maintenance and repairsm180.00
2025-07-21Greggs5600Working lunchh8.00
2025-07-22Screwfix5401Miscellaneous suppliesu18.00
2025-07-25Wilko5401Cleaning and kitchen suppliesu15.00
2025-07-25Mileage claim5601Business mileage to Leedsv20.25
2025-07-28Shell5601Additional fuel purchasev120.00
2025-07-31Smith & Co5800Monthly accountancy retainerl300.00
Aug
DateSupplierAccountDescriptionCodeAmount
2025-08-01WorkSpace Ltd5200Monthly office rentr1,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 itemsu22.00
2025-08-05Ryman5401Stationery suppliesu24.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 suppliesu36.00
2025-08-12NCP5601Parking chargesv18.00
2025-08-14Toolstation5401Assorted fixings and partsu48.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 suppliesu18.00
2025-08-25Wilko5401Cleaning and kitchen suppliesu15.00
2025-08-25Mileage claim5601Business mileage to Manchesterv38.25
2025-08-28Shell5601Additional fuel purchasev120.00
2025-08-31Smith & Co5800Monthly accountancy retainerl300.00
Sep
DateSupplierAccountDescriptionCodeAmountReference
2025-09-01WorkSpace Ltd5200Monthly office rentr1,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 itemsu22.00
2025-09-05Ryman5401Stationery suppliesu24.00
2025-09-05BP5601Fuel for company vehiclev180.00
2025-09-08National Rail5600Train ticket client meetingh48.00
2025-09-08Hilti5301Power tool hireq360.00
2025-09-10Amazon5401Office suppliesu36.00
2025-09-10Royal Mail5300Special delivery couriert96.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 suppliesu18.00
2025-09-22Halfords5601Vehicle maintenance suppliesv72.00
2025-09-25EnergySupply5201Quarterly utility billp300.00
2025-09-25Wilko5401Cleaning and kitchen suppliesu15.00
2025-09-25Mileage claim5601Business mileage to Bristolv72.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
DateSupplierAccountDescriptionCodeAmountReference
2025-10-01WorkSpace Ltd5200Monthly office rentr1,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 renewaln360.00
2025-10-01Cloudflare5002CDN and DNS serviceso24.00
2025-10-01Zoom5501Video conferencing subscriptiong18.00
2025-10-03AWS5002Cloud hosting chargeso180.00
2025-10-03Argos5401Miscellaneous office itemsu22.00
2025-10-05Ryman5401Stationery suppliesu24.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 suppliesu36.00
2025-10-10Xerox5701Printer lease paymentf180.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 partsu36.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 suppliesu18.00
2025-10-25Wilko5401Cleaning and kitchen suppliesu15.00
2025-10-25Mileage claim5601Business mileage to Sheffieldv42.75
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 deduction
2025-11-01WorkSpace Ltd5200Monthly office rentr1,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 itemsu22.00
2025-11-05Ryman5401Stationery suppliesu24.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 suppliesu36.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 deliveryt240.00
2025-11-20CableCo5000Cabling and connectorss300.00
2025-11-21Greggs5600Working lunchh8.00
2025-11-22Screwfix5401Miscellaneous suppliesu18.00
2025-11-25Wilko5401Cleaning and kitchen suppliesu15.00
2025-11-25Mileage claim5601Business mileage to Londonv81.00
2025-11-28Shell5601Additional fuel purchasev120.00
2025-11-30Smith & Co5800Monthly accountancy retainerl300.00
Dec
DateSupplierAccountDescriptionCodeAmountReference
2025-12-01WorkSpace Ltd5200Monthly office rentr1,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 itemsu22.00
2025-12-05Ryman5401Stationery suppliesu24.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 suppliesu36.00
2025-12-10Vistaprint5501Business cards and flyersg120.00
2025-12-12NCP5601Parking chargesv18.00
2025-12-14Toolstation5401Assorted fixings and partsu24.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 suppliesu18.00
2025-12-25EnergySupply5201Quarterly utility billp420.00
2025-12-25Wilko5401Cleaning and kitchen suppliesu15.00
2025-12-25Mileage claim5601Business mileage to Variousv49.50
2025-12-28Shell5601Additional fuel purchasev120.00
2025-12-31Smith & Co5800Monthly accountancy retainerl300.00
2025-12-31Director5100Director fees (non-PAYE)d5,000.00
2025-12-31Directors loan5803Directors loan interestl167.00PUR-INT-003
Jan
DateSupplierAccountDescriptionCodeAmount
2026-01-01WorkSpace Ltd5200Monthly office rentr1,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 itemsu22.00
2026-01-05Ryman5401Stationery suppliesu24.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 hireq180.00
2026-01-10Amazon5401Office suppliesu36.00
2026-01-10Xerox5701Printer lease paymentf180.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 couriert180.00
2026-01-20Office Maintenance Ltd5400Premises maintenance and repairsm144.00
2026-01-21Greggs5600Working lunchh8.00
2026-01-22Screwfix5401Miscellaneous suppliesu18.00
2026-01-22Halfords5601Vehicle maintenance suppliesv36.00
2026-01-25Wilko5401Cleaning and kitchen suppliesu15.00
2026-01-25Mileage claim5601Business mileage to Manchesterv38.25
2026-01-28Shell5601Additional fuel purchasev120.00
2026-01-31Smith & Co5800Monthly accountancy retainerl300.00
Feb
DateSupplierAccountDescriptionCodeAmount
2026-02-01WorkSpace Ltd5200Monthly office rentr1,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 itemsu22.00
2026-02-05Ryman5401Stationery suppliesu24.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 suppliesu36.00
2026-02-12NCP5601Parking chargesv18.00
2026-02-12ToolHire5301Equipment hire for installationq360.00
2026-02-14Toolstation5401Assorted fixings and partsu18.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 suppliesu18.00
2026-02-25Wilko5401Cleaning and kitchen suppliesu15.00
2026-02-25Mileage claim5601Business mileage to Nottinghamv31.50
2026-02-28Smith & Co5800Monthly accountancy retainerl300.00
2026-02-28Shell5601Additional fuel purchasev120.00
Mar
DateSupplierAccountDescriptionCodeAmountReference
2026-03-01WorkSpace Ltd5200Monthly office rentr1,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 itemsu22.00
2026-03-05Ryman5401Stationery suppliesu24.00
2026-03-05BP5601Fuel for company vehiclev180.00
2026-03-08National Rail5600Train ticket client meetingh48.00
2026-03-10Amazon5401Office suppliesu36.00
2026-03-10Royal Mail5300Special delivery couriert144.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 suppliesu18.00
2026-03-22Halfords5601Vehicle maintenance suppliesv60.00
2026-03-25EnergySupply5201Quarterly utility billp360.00
2026-03-25Wilko5401Cleaning and kitchen suppliesu15.00
2026-03-25Mileage claim5601Business mileage to Variousv58.50
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: 162 entries, 747,554.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-011210Opening balanceSavings account opening balanceBC5,000.00inBNK-SAV-001
2025-04-011220Opening balanceCash float opening balanceBC500.00inBNK-CASH-001
2025-04-101220Corner shopMilk and teaCR15.00outBNK-CASH-003
2025-04-301230Payment from currentCredit card payment receivedX500.00inBNK-CC-005
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
2025-05-201230HSBCCredit card annual feeB35.00outBNK-CC-004
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 floatBC100.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
2025-06-181230Premier InnHotel on credit cardCR180.00outBNK-CC-001
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-151200DividendQuarterly dividend paymentDV3,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
2025-07-311230Payment from currentCredit card payment receivedX300.00inBNK-CC-006
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-301210HSBC SavingsSavings interestK125.00inBNK-SAV-003
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-151200DividendQuarterly dividend paymentDV3,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
2025-10-181230Premier InnHotel on credit cardCR120.00outBNK-CC-002
2025-10-311230Payment from currentCredit card payment receivedX500.00inBNK-CC-007
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-151200DividendQuarterly dividend paymentDV3,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
2026-01-311230Payment from currentCredit card payment receivedX300.00inBNK-CC-008
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
2026-02-181230Premier InnHotel on credit cardCR240.00outBNK-CC-003
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-311200DividendFinal dividend paymentDV6,000.00outBNK-DV-004
2026-03-151210Internal transferTransfer from current accountX5,000.00inBNK-SAV-002
2026-03-311210HSBC SavingsSavings interestK150.00inBNK-SAV-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

Opening balance
ItemValue
Current account25,000.00
Savings account5,000.00
Cash500.00
Stock10,000.00
Trade debtors10,800.00
Directors loan20,000.00
Trade creditors2,400.00
Vat due1,500.00
Corporation tax4,500.00
Share capital100.00
Retained earnings180,702.00
Long term creditors25,000.00
Fixed asset cost[object Object]
Fixed asset depreciation[object Object]
Stock
ItemValue
Opening10,000.00
Closing6,000.00
Materials percent0.03
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
Office premisesland200,000.0040,000.00

Screenshots

Monthly profit and loss sheet of the populated workbook
Monthly profit and loss — Financialaccounts.xlsx, sheet MnthP&L
Published profit and loss sheet of the populated workbook
Published profit and loss — Financialaccounts.xlsx, sheet PubP&L
Published balance sheet sheet of the populated workbook
Published balance sheet — Financialaccounts.xlsx, sheet PubBalSht
Corporation tax computation sheet of the populated workbook
Corporation tax computation — Financialaccounts.xlsx, sheet CorporationTax
VAT return, quarter 1 sheet of the populated workbook
VAT return, quarter 1 — Vatreturns.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 management profit and loss accountMnthP&L!B45172,115.39
Less bank interest received, net of tax deducted at sourceMnthP&L!B44-275
Add back goodwill written offCorporationTax!I72,500
Add back depreciation charged in the yearCorporationTax!I813,740
Less capital allowancesCorporationTax!K20-64,000
Add gross bank interest receivedCorporationTax!K24339.51
Less losses brought forwardCorporationTax!K260
Tax profit the bridge computes124,419.9
Tax profit the sheet carriesCorporationTax!K28124,419.9
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,600MnthP&L!B4311,6000
Sales Product B (sales b)16,3202,72013,600MnthP&L!B513,6000
Sales Product C (sales c)12,3602,06010,300MnthP&L!B610,3000
Other Income (sales d)4,4407403,700MnthP&L!B73,7000
Investment Grants received (sales g)2,500416.672,083.33MnthP&L!B82,083.330
Bad Debts written off (sales o)36060300MnthP&L!B34 negated3000
Sub contractors (purchases c)8,0001,333.336,666.67MnthP&L!B126,666.670
Other Direct Cost of Sales (purchases o)3,2045342,670MnthP&L!B132,6700
Premises Rent & Rates (purchases r)14,4002,40012,000MnthP&L!B2112,0000
Premises Light & Heating (purchases p)1,4402401,200MnthP&L!B221,2000
Distribution Transport Costs (purchases t)960160800MnthP&L!B238000
Equipment Tools & Plant Hire (purchases q)1,6202701,350MnthP&L!B241,3500
Repairs & Maintenance (purchases m)1,140190950MnthP&L!B259500
Consumable Materials (purchases u)1,5782631,315MnthP&L!B261,3150
Advertising & Promotion (purchases a)4,5607603,800MnthP&L!B273,8000
Telephone Postage & Stationery (purchases g)1,9623271,635MnthP&L!B281,6350
Travel & Hotel Expenses (purchases h)1,8603101,550MnthP&L!B291,5500
Motor Vehicle Expenses (purchases v)7,598.251,266.386,331.88MnthP&L!B306,331.880
Insurance Costs (purchases n)1,8003001,500MnthP&L!B311,5000
Leasing Charges (purchases f)720120600MnthP&L!B326000
Legal & Professional Fees (purchases l)5,3108854,425MnthP&L!B334,4250
Charitable Donations (purchases y)50083.33416.67MnthP&L!B37416.670
Goodwill written off (purchases z)3,0005002,500MnthP&L!B382,5000
Wages and Salaries, less the employees' own gross pay (purchases w)800133.33666.67MnthP&L!B18 less the employees' gross pay666.670
Directors Wages, less the directors' own gross pay (purchases d)5,000833.334,166.67MnthP&L!B19 less the directors' gross pay4,166.670
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
Company Name (including Limited)Precision Code Ltd
Company registration number12345678
Telephone number0161 555 0100
First Director's NameCarol Smith
Principal activityIT consultancy and software development
Registered Office Address123 High Street
Registered Office TownManchester
PostcodeM1 1AA
Tax Reference per CT603 Notice1234567890

Opening Balance Sheet

Amount
    Tangible assets (net book value)182,902
    Stock at cost10,000
    Trade Debtors10,800
    Cash and Bank Balances30,500
    Trade Creditors2,400
    Corporation Tax4,500
    Taxation and Social Security1,500
    Directors Loan Account20,000
    Called up share capital100
    Retained Profit and Loss account180,702
Accuracy Check0

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 Direct Income (code d)3,700
    Grants Received (code g)2,083.33
Sales Turnover341,283.33
    Materials / Stock (code s)9,450
    Sub-Contractors (code c)6,666.67
    Other Direct Costs (code o)2,670
Cost of Sales18,786.67
Gross Profit322,496.67
    PAYE Wages + Non-PAYE Employee69,066.67
    Directors Wages + Non-PAYE (code d)16,742.67
    Employers National Insurance6,926.4
    Premises (code r)12,000
    Light, Heat, Power (code p)1,200
    Distribution (code t)800
    Equipment Hire (code q)1,350
    Repairs & Maintenance (code m)950
    Consumables (code u)1,315
    Advertising (code a)3,800
    Telephone, Postage & Stationery (code g)1,635
    Travel & Hotel (code h)1,550
    Motor Vehicle (code v)6,331.88
    Insurance (code n)1,500
    Leasing (code f)600
    Legal & Professional (code l)4,425
    Bad Debts (from Sales)-300
    Bank Interest Paid0
    Bank Charges3,935
    Charitable Donations (code y)416.67
    Goodwill written off (code z)2,500
    Loss on disposal of assets172
    Depreciation13,740
Total Admin Expenses150,656.28
Operating Profit171,840.39
    Interest Received275
Profit Before Tax172,115.39

CT600 as filed

Amount
    Box 330: financial year2,026
    Box 335: amount of profit51,472.34
    Box 340: rate of tax25
    Box 345: tax12,868.09
    Box 380: financial year2,027
    Box 385: amount of profit72,947.56
    Box 390: rate of tax25
    Box 395: tax18,236.89
Box 430: corporation tax31,104.97
    Box 435: marginal rate relief1,883.7
Box 440: corporation tax net of marginal rate relief29,221.27

Published P&L

Amount
    Sales Turnover339,200
    Investment Grants2,083.33
Total Sales Turnover341,283.33
    Cost of Sales18,786.67
Gross Profit322,496.67
    Administrative Expenses150,656.28
Operating Profit171,840.39
Profit Before Tax172,179.9
    Corporation tax29,221.27
Profit after Tax142,958.62
    Dividends15,000
Retained Profit for the year127,958.62

Published Balance Sheet

Amount
Fixed Assets (NBV)208,990
    Stock at cost6,000
    Trade Debtors7,900
    Cash at bank and in hand192,995.43
Current Assets206,895.43
    Trade Creditors10,832.25
    Corporation Tax29,156.77
    Taxation and Social Security9,135.79
    Current Liabilities49,124.81
Net Current Assets157,770.62
Total Assets less CL366,760.62
    Directors Loan13,000
    Creditors due after more than one year45,000
    Other Creditors58,000
Net Assets308,760.62
    Called up share capital100
Shareholders' Funds308,760.62

Fixed Asset Note

Amount
    Original cost brought forward233,000
    Additions52,500
    Disposals30,000
Original cost carried forward255,500
    Depreciation brought forward50,098
    Charge for the year13,740
    On disposals17,328
Depreciation carried forward46,510
Net book value208,990
    Directors emoluments16,742.67
    Corporation tax for the year29,221.27

Directors' Report

Amount
    Sales turnover in the year341,283.33
    Sales turnover last year0
    Trading margin0.94
    Trading margin last year—
    Dividend declared15,000
    Ordinary shares issued100

Stock

Amount
Opening Stock10,000
Closing Stock (physical count)6,000
    Closing Stock (calculated)6,102
    Stock loss adjustment-102

Trial Balance

Amount
    Opening: Fixed Asset Land & Property200,000
    Opening: Fixed Asset Plant & Machinery0
    Opening: Fixed Asset Fixtures & Fittings0
    Opening: Fixed Asset Computers3,000
    Opening: Fixed Asset Motor Vehicles30,000
    Opening: Acc Depreciation Land & Property-40,000
    Opening: Acc Depreciation Plant & Machinery0
    Opening: Acc Depreciation Fixtures0
    Opening: Acc Depreciation Computers-270
    Opening: Acc Depreciation Motor Vehicles-9,828
    Opening: Stock10,000
    Opening: Trade Debtors10,800
    Opening: Bank Current Account25,000
    Opening: Bank Savings Account5,000
    Opening: Credit Card Account0
    Opening: Cash Account500
    Opening: Trade Creditors-2,400
    Opening: Net Wages Creditor0
    Opening: Other Deductions from Wages0
    Opening: Dividends Creditor0
    Opening: Creditor HMRC Vat-1,500
    Opening: Creditor HMRC Corporation Tax-4,500
    Opening: Directors Loan Account-20,000
    Opening: Creditor Long Term-25,000
    Opening: Share Capital-100
    Opening: Revenue Reserve P&L Account-180,702
Opening Balances Audit Check0
    Final: Trade Debtors7,900
    Final: Bank Current Account181,215.43
    Final: Bank Savings Account10,275
    Final: Credit Card Account1,025
    Final: Cash Account480
    Final: Intra Cash & Bank Transfers0
    Final: Net Wages Creditor0
    Final: Other Deductions from Wages0
    Final: Dividends Creditor0
    Final: Directors Loan Account-13,000
    Final: Creditor Long Term-45,000
    Final: Dividends declared15,000
Audit Accuracy Check0

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,498.71
    Purchases net of VAT112,493.54
VAT due for the year48,317.96
How the return periods line up with the accounting year
    Q1 covers the periods ending30 November 2026, 31 December 2026, 31 January 2027
    Q2 covers the periods ending28 February 2027, 31 March 2027, 30 April 2027
    Q3 covers the periods ending31 May 2027, 30 June 2027, 31 July 2027
    Q4 covers the periods ending31 August 2027, 30 September 2027, 31 October 2027
    Q5 covers the periods ending30 November 2027, 31 December 2027, 31 January 2028
The returns above also cover the periods ending 30 November 2027, 31 December 2027, 31 January 2028, 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 31 January 2027) box 1: VAT due on sales16,920
    Q1 (period ending 31 January 2027) box 4: VAT reclaimed on purchases6,023.88
    Q1 (period ending 31 January 2027) box 5: net VAT due10,896.13
    Q2 (period ending 30 April 2027) box 1: VAT due on sales17,256.67
    Q2 (period ending 30 April 2027) box 4: VAT reclaimed on purchases4,473.25
    Q2 (period ending 30 April 2027) box 5: net VAT due12,783.42
    Q3 (period ending 31 July 2027) box 1: VAT due on sales19,780
    Q3 (period ending 31 July 2027) box 4: VAT reclaimed on purchases9,895.88
    Q3 (period ending 31 July 2027) box 5: net VAT due9,884.13
    Q4 (period ending 31 October 2027) box 1: VAT due on sales16,860
    Q4 (period ending 31 October 2027) box 4: VAT reclaimed on purchases2,105.71
    Q4 (period ending 31 October 2027) box 5: net VAT due14,754.29
    Q5 (period ending 31 January 2028) box 1: VAT due on sales1,100
    Q5 (period ending 31 January 2028) box 4: VAT reclaimed on purchases180
    Q5 (period ending 31 January 2028) box 5: net VAT due920
Cell values behind these statements
OpenAccounts
CellDIY LabelValuediya-gl mapping
E2Company Name (including Limited)Precision Code LtdentityInformation.organizationIdentifier
E3Company registration number12345678diya-gl:companyNumber
E4Telephone number0161 555 0100gl-bus:organizationTelephone
E5First Director's NameCarol Smithdiya-gl:directorName
E8Principal activityIT consultancy and software developmentgl-bus:organizationDescription
J3Registered Office Address123 High Streetgl-bus:organizationAddress
J4Registered Office TownManchestergl-bus:organizationAddress
N6PostcodeM1 1AAgl-bus:organizationAddress
O3Tax Reference per CT603 Notice1234567890gl-taf:taxRegistrationNumber
E13Tangible assets (net book value)182902gl-cor:amount (opening.fixedAssets)
E15Stock at cost10000accounts.assets.1100 (opening)
E16Trade Debtors10800accounts.assets.1300 (opening)
E18Cash and Bank Balances30500gl-cor:amount (opening.bank)
E20Trade Creditors2400accounts.liabilities.2100 (opening)
E24Corporation Tax4500accounts.liabilities.2300 (opening)
E26Taxation and Social Security1500gl-cor:amount (opening.taxAndSocial)
E30Directors Loan Account20000accounts.liabilities.2500 (opening)
E33Called up share capital100accounts.capital.3000 (opening)
E34Retained Profit and Loss account180702accounts.capital.3100 (opening)
E37Accuracy Check0gl-cor:amount (openingBalanceCheck)
E480
MnthP&L
CellDIY LabelValuediya-gl mapping
B4Product A sales (code a)311600accounts.sales.4000
B5Product B sales (code b)13600accounts.sales.4001
B6Product C sales (code c)10300accounts.sales.4002
B7Other Direct Income (code d)3700accounts.sales.4003
B8Grants Received (code g)2083.33333333333accounts.sales.4004
B9Sales Turnover341283.333333333gl-cor:amount (salesTurnover)
B11Materials / Stock (code s)9450accounts.purchases.5000
B12Sub-Contractors (code c)6666.66666666667accounts.purchases.5001
B13Other Direct Costs (code o)2670accounts.purchases.5002
B14Cost of Sales18786.6666666667gl-cor:amount (costOfSales)
B16Gross Profit322496.666666666gl-cor:amount (grossProfit)
B18PAYE Wages + Non-PAYE Employee69066.6666666667dpl:WagesAndSalaries (combined)
B19Directors Wages + Non-PAYE (code d)16742.6666666667accounts.purchases.5100
B20Employers National Insurance6926.4dpl:SocialSecurityCosts
B21Premises (code r)12000accounts.purchases.5200
B22Light, Heat, Power (code p)1200accounts.purchases.5201
B23Distribution (code t)800accounts.purchases.5300
B24Equipment Hire (code q)1350accounts.purchases.5301
B25Repairs & Maintenance (code m)950accounts.purchases.5400
B26Consumables (code u)1315accounts.purchases.5401
B27Advertising (code a)3800accounts.purchases.5500
B28Telephone, Postage & Stationery (code g)1635accounts.purchases.5501
B29Travel & Hotel (code h)1550accounts.purchases.5600
B30Motor Vehicle (code v)6331.875accounts.purchases.5601
B31Insurance (code n)1500accounts.purchases.5700
B32Leasing (code f)600accounts.purchases.5701
B33Legal & Professional (code l)4425accounts.purchases.5800
B34Bad Debts (from Sales)-300accounts.sales.4005
B35Bank Interest Paid0accounts.purchases.5701
B36Bank Charges3935accounts.purchases.5702
B37Charitable Donations (code y)416.666666666667accounts.purchases.5801
B38Goodwill written off (code z)2500accounts.purchases.5802
B39Loss on disposal of assets172gl-cor:amount (lossOnDisposal)
B40Depreciation13740gl-cor:amount (depreciation)
B41Total Admin Expenses150656.275gl-cor:amount (totalAdmin)
B43Operating Profit171840.391666666gl-cor:amount (operatingProfit)
B44Interest Received275gl-cor:amount (interestReceived)
B45Profit Before Tax172115.391666666gl-cor:amount (profitBeforeTax)
C425333.3333333333
D425633.3333333333
E426533.3333333333
F425633.3333333333
G427133.3333333333
H425033.3333333333
I427133.3333333333
J425633.3333333333
K426533.3333333333
L425633.3333333333
M426333.3333333333
N425033.3333333333
C51800
D5800
E5800
F51800
G5800
H5800
I51800
J5800
K5800
L51800
M5800
N5800
C60
D61000
E62000
F60
G60
H61800
I60
J63000
K60
L61000
M61500
N60
C7700
D70
E70
F7700
G70
H7500
I7700
J70
K70
L71100
M70
N70
C80
D80
E80
F80
G82083.33333333333
H80
I80
J80
K80
L80
M80
N80
C340
D340
E340
F340
G340
H340
I340
J340
K340
L340
M340
N34-300
C120
D120
E124166.66666666667
F120
G120
H120
I120
J122500
K120
L120
M120
N120
C13237.5
D13207.5
E13237.5
F13207.5
G13237.5
H13207.5
I13237.5
J13207.5
K13237.5
L13207.5
M13237.5
N13207.5
C211000
D211000
E211000
F211000
G211000
H211000
I211000
J211000
K211000
L211000
M211000
N211000
C220
D220
E22300
F220
G220
H22250
I220
J220
K22350
L220
M220
N22300
C230
D23150
E230
F23100
G230
H2380
I230
J23200
K230
L23150
M230
N23120
C240
D24200
E240
F24400
G240
H24300
I240
J240
K240
L24150
M24300
N240
C25100
D250
E250
F25150
G25200
H250
I2580
J250
K250
L25120
M25300
N250
C26130.833333333333
D2695.8333333333333
E26120.833333333333
F2695.8333333333333
G26135.833333333333
H2695.8333333333333
I26125.833333333333
J2695.8333333333333
K26115.833333333333
L2695.8333333333333
M26110.833333333333
N2695.8333333333333
C270
D27500
E270
F27400
G270
H270
I272500
J270
K270
L27400
M270
N270
C28112.5
D28127.5
E28192.5
F28132.5
G28112.5
H28122.5
I28112.5
J28137.5
K28212.5
L28127.5
M28112.5
N28132.5
C2976.6666666666667
D29126.666666666667
E29226.666666666667
F2976.6666666666667
G29116.666666666667
H2976.6666666666667
I29176.666666666667
J29136.666666666667
K2976.6666666666667
L2976.6666666666667
M29306.666666666667
N2976.6666666666667
C30501.875
D30555
E30545
F30486.875
G30501.875
H30590
I30505.625
J30537.5
K30511.25
L30531.875
M30496.25
N30568.75
C311200
D310
E310
F310
G310
H310
I31300
J310
K310
L310
M310
N310
C32150
D320
E320
F32150
G320
H320
I32150
J320
K320
L32150
M320
N320
C33250
D33250
E33458.333333333333
F33250
G33250
H331223.33333333333
I33250
J33250
K33389.166666666667
L33250
M33250
N33354.166666666667
C370
D370
E370
F370
G370
H370
I370
J370
K37416.666666666667
L370
M370
N370
C380
D380
E380
F382500
G380
H380
I380
J380
K380
L380
M380
N380
C927833.3333333333
D927433.3333333333
E929333.3333333333
F928133.3333333333
G930016.6666666666
H928133.3333333333
I929633.3333333333
J929433.3333333333
K927333.3333333333
L929533.3333333333
M928633.3333333333
N925833.3333333333
C3914.3333333333333
D3914.3333333333333
E3914.3333333333333
F3914.3333333333333
G3914.3333333333333
H3914.3333333333333
I3914.3333333333333
J3914.3333333333333
K3914.3333333333333
L3914.3333333333333
M3914.3333333333333
N3914.3333333333333
C401145
D401145
E401145
F401145
G401145
H401145
I401145
J401145
K401145
L401145
M401145
N401145
CorporationTax
CellDIY LabelValuediya-gl mapping
K5Operating Profit171840.391666666gl-cor:amount (ct600.box145)
I7Add back: Goodwill2500gl-cor:amount (ct600.addBackGoodwill)
I8Add back: Depreciation13740gl-cor:amount (ct600.addBackDepreciation)
K10Add back: total16240gl-cor:amount (ct600.addBack)
K12Operational profit chargeable188080.391666666gl-cor:amount (ct600.adjustedProfit)
K20Less: Capital Allowances64000tax.capitalAllowances (ct600)
K22Profit after capital allowances124080.391666666gl-cor:amount (ct600.afterAllowances)
K24Add: gross bank interest339.506172839506gl-cor:amount (ct600.interest)
K26Less: losses brought forward0gl-cor:amount (ct600.lossesBf)
K28Profit Chargeable to CT124419.897839506gl-cor:amount (ct600.box315)
K35Corporation Tax29221.272927469gl-cor:taxAmount (ct600.box430)
K39Tax Outstanding29156.7667546295gl-cor:taxAmount (ct600.box600)
E546327
H546691
I1552500
I160
I173360
I188140
A33151
A34214
A35365
E332026
E342027
F3351472.3412979873
F3472947.5565415185
G3325
G3425
J3312868.0853244968
J3418236.8891353796
L33779.284743543889
L341104.41678886352
I3312088.8005809529
I3417132.4723465161
K3764.5061728395062
CT600
CellDIY LabelValuediya-gl mapping
C126Box 330: financial year2026gl-cor:period (ct600.box330)
N126Box 335: amount of profit51472.3412979873gl-cor:amount (ct600.box335)
AA126Box 340: rate of tax25gl-cor:rate (ct600.box340)
AJ126Box 345: tax12868.0853244968gl-cor:taxAmount (ct600.box345)
C128Box 380: financial year2027gl-cor:period (ct600.box380)
N128Box 385: amount of profit72947.5565415185gl-cor:amount (ct600.box385)
AA128Box 390: rate of tax25gl-cor:rate (ct600.box390)
AJ128Box 395: tax18236.8891353796gl-cor:taxAmount (ct600.box395)
AJ131Box 430: corporation tax31104.9744598765gl-cor:taxAmount (ct600.box430)
Y133Box 435: marginal rate relief1883.70153240741gl-cor:taxAmount (ct600.box435)
Y135Box 440: corporation tax net of marginal rate relief29221.272927469gl-cor:taxAmount (ct600.box440)
B3346327
M3346691
W13723.4860126353445
AK66341283.333333333
Z70124080.391666666
AJ74124080.391666666
AJ76339.506172839506
AJ92124419.897839506
AJ110124419.897839506
AJ14529221.272927469
AJ15464.5061728395062
AJ15929156.7667546295
AJ16629156.7667546295
PubP&L
CellDIY LabelValuediya-gl mapping
F7Sales Turnover339200gl-cor:amount (pubPL.salesTurnover)
F8Investment Grants2083.33333333333gl-cor:amount (pubPL.grants)
F9Total Sales Turnover341283.333333333gl-cor:amount (pubPL.totalTurnover)
F16Cost of Sales18786.6666666667gl-cor:amount (pubPL.cos)
F18Gross Profit322496.666666666gl-cor:amount (pubPL.gross)
F44Administrative Expenses150656.275gl-cor:amount (pubPL.admin)
F46Operating Profit171840.391666666gl-cor:amount (pubPL.operating)
F49Profit Before Tax172179.897839506gl-cor:amount (pubPL.pbt)
F50Corporation tax29221.272927469gl-cor:taxAmount (pubPL.tax)
F51Profit after Tax142958.624912037gl-cor:amount (pubPL.pat)
F52Dividends15000gl-cor:amount (pubPL.dividends)
F54Retained Profit for the year127958.624912037gl-cor:amount (pubPL.retained)
D346691
B90
B140
B180
B540
E546691
PubBalSht
CellDIY LabelValuediya-gl mapping
F6Fixed Assets (NBV)208990gl-cor:amount (pubBS.fixedAssets)
E10Stock at cost6000accounts.assets.1100 (pubBS)
E11Trade Debtors7900accounts.assets.1300 (pubBS)
E12Cash at bank and in hand192995.43gl-cor:amount (pubBS.bankCash)
E13Current Assets206895.43gl-cor:amount (pubBS.currentAssets)
E16Trade Creditors10832.25accounts.liabilities.2100 (pubBS)
E17Corporation Tax29156.7667546295accounts.liabilities.2300 (pubBS)
E18Taxation and Social Security9135.78833333336gl-cor:amount (pubBS.taxAndSocial)
E20Current Liabilities49124.8050879629gl-cor:amount (pubBS.creditors)
F22Net Current Assets157770.624912037gl-cor:amount (pubBS.netCurrent)
F26Total Assets less CL366760.624912037gl-cor:amount (pubBS.totalAssetsLessCL)
E29Directors Loan13000accounts.liabilities.2500 (pubBS)
E30Creditors due after more than one year45000accounts.liabilities.2600 (pubBS)
F31Other Creditors58000gl-cor:amount (pubBS.otherCred)
F33Net Assets308760.624912037gl-cor:amount (pubBS.netAssets)
F36Called up share capital100accounts.capital.3000 (pubBS)
F39Shareholders' Funds308760.624912037gl-cor:amount (pubBS.equity)
D246691
PubNotes
CellDIY LabelValuediya-gl mapping
G8Original cost brought forward233000gl-cor:amount (note1.costBf)
G9Additions52500gl-cor:amount (note1.additions)
G10Disposals30000gl-cor:amount (note1.disposals)
G11Original cost carried forward255500gl-cor:amount (note1.costCf)
G14Depreciation brought forward50098gl-cor:amount (note1.depBf)
G15Charge for the year13740gl-cor:amount (note1.charge)
G16On disposals17328gl-cor:amount (note1.depDisposals)
G17Depreciation carried forward46510gl-cor:amount (note1.depCf)
G20Net book value208990gl-cor:amount (note1.nbv)
D35Directors emoluments16742.6666666667gl-cor:amount (note2.emoluments)
D41Corporation tax for the year29221.272927469gl-cor:taxAmount (note4.ct)
B8200000
B90
B100
B11200000
B1440000
B150
B160
B1740000
B20160000
C80
C952500
C100
C1152500
C140
C155250
C160
C175250
C2047250
D80
D90
D100
D110
D140
D150
D160
D170
D200
E83000
E90
E100
E113000
E14270
E15990
E160
E171260
E201740
F830000
F90
F1030000
F110
F149828
F157500
F1617328
F170
F200
B270
B280.1
B290.2
B300.33
B310.25
A1146691
Report
CellDIY LabelValuediya-gl mapping
E87Sales turnover in the year341283.333333333gl-cor:amount (report.turnover)
H87Sales turnover last year0gl-cor:amount (report.priorTurnover)
D89Trading margin0.944952873956146gl-cor:percentage (report.margin)
D94Dividend declared15000gl-cor:amount (report.dividend)
I95Ordinary shares issued100gl-cor:quantity (report.sharesIssued)
F2246691
A97Carol Smith
F9760
A98David Brown
F9825
Stock
CellDIY LabelValuediya-gl mapping
D6Opening Stock10000accounts.assets.1100 (opening)
AB30Closing Stock (physical count)6000accounts.assets.1100 (closing)
D30Closing Stock (calculated)6102.00000000002accounts.assets.1100 (calculated)
Z30Stock loss adjustment-102.000000000015accounts.assets.1100 (lossAdjustment)
TrialBalance
CellDIY LabelValuediya-gl mapping
D6Opening: Fixed Asset Land & Property200000accounts.assets (opening cost)
D7Opening: Fixed Asset Plant & Machinery0accounts.assets.0010 (opening cost)
D8Opening: Fixed Asset Fixtures & Fittings0accounts.assets.0020 (opening cost)
D9Opening: Fixed Asset Computers3000accounts.assets.0030 (opening cost)
D10Opening: Fixed Asset Motor Vehicles30000accounts.assets.0040 (opening cost)
D11Opening: Acc Depreciation Land & Property-40000accounts.assets (opening dep)
D12Opening: Acc Depreciation Plant & Machinery0accounts.assets.0010 (opening dep)
D13Opening: Acc Depreciation Fixtures0accounts.assets.0020 (opening dep)
D14Opening: Acc Depreciation Computers-270accounts.assets.0030 (opening dep)
D15Opening: Acc Depreciation Motor Vehicles-9828accounts.assets.0040 (opening dep)
D19Opening: Stock10000accounts.assets.1100 (opening)
D20Opening: Trade Debtors10800accounts.assets.1300 (opening)
D22Opening: Bank Current Account25000accounts.assets.1200 (opening)
D23Opening: Bank Savings Account5000accounts.assets.1210 (opening)
D24Opening: Credit Card Account0accounts.assets.1230 (opening)
D25Opening: Cash Account500accounts.assets.1220 (opening)
D28Opening: Trade Creditors-2400accounts.liabilities.2100 (opening)
D29Opening: Net Wages Creditor0openingBalance.net_wages_due
D30Opening: Other Deductions from Wages0openingBalance.wage_deductions_due
D31Opening: Dividends Creditor0accounts.capital.3200 (opening)
D33Opening: Creditor HMRC Vat-1500accounts.liabilities.2200 (opening)
D35Opening: Creditor HMRC Corporation Tax-4500accounts.liabilities.2300 (opening)
D39Opening: Directors Loan Account-20000accounts.liabilities.2500 (opening)
D40Opening: Creditor Long Term-25000accounts.liabilities.2600 (opening)
D42Opening: Share Capital-100accounts.capital.3000 (opening)
D43Opening: Revenue Reserve P&L Account-180702accounts.capital.3100 (opening)
D91Opening Balances Audit Check0gl-cor:amount (openingColumnCheck)
EJ20Final: Trade Debtors7900accounts.assets.1300 (final)
EJ22Final: Bank Current Account181215.43accounts.assets.1200 (final)
EJ23Final: Bank Savings Account10275accounts.assets.1210 (final)
EJ24Final: Credit Card Account1025accounts.assets.1230 (final)
EJ25Final: Cash Account480accounts.assets.1220 (final)
EJ26Final: Intra Cash & Bank Transfers0gl-cor:amount (intraTransfers)
EJ29Final: Net Wages Creditor0openingBalance.net_wages_due (final)
EJ30Final: Other Deductions from Wages0openingBalance.wage_deductions_due (final)
EJ31Final: Dividends Creditor0accounts.capital.3200 (final)
EJ39Final: Directors Loan Account-13000accounts.liabilities.2500 (final)
EJ40Final: Creditor Long Term-45000accounts.liabilities.2600 (final)
EJ48Final: Dividends declared15000gl-cor:amount (dividendsDeclared)
EJ91Audit Accuracy Check3.26508597936481e-10gl-cor:amount (trialBalanceCheck)
EJ6616742.6666666667
EJ28-10832.25
EJ320
EJ33-9135.78833333336
EJ340
EJ35-29156.7667546295
EH3564.5061728395062
L34-1673.2
Admin
CellDIY LabelValuediya-gl mapping
P619
P719
P825
P90.015
P1250000
P13250000
G5100
G7100
G614
G814
G150
G160.1
G170.2
G180.33
G190.25
N1610000
O160.45
N1710001
O170.25
M1920
M2120
F2146691
B946327
B3246691
K62026
L646327
N646477
K72027
L746478
N746691
WagesInterface
CellDIY LabelValuediya-gl mapping
C45700
D4800
E4296
H4570
C55700
D5800
E5296
H5570
C65700
D6800
E6296
H6570
C75700
D7800
E7296
H7570
C85700
D8800
E8296
H8570
C95700
D9800
E9296
H9570
C105700
D10800
E10296
H10570
C115700
D11800
E11296
H11570
C125700
D12800
E12296
H12570
C135700
D13800
E13296
H13570
C145700
D14800
E14296
H14570
C155700
D15800
E15296
H15570
C171048
D170
E170
H177.2
C181048
D180
E180
H187.2
C191048
D190
E190
H197.2
C201048
D200
E200
H207.2
C211048
D210
E210
H217.2
C221048
D220
E220
H227.2
C231048
D230
E230
H237.2
C241048
D240
E240
H247.2
C251048
D250
E250
H257.2
C261048
D260
E260
H267.2
C271048
D270
E270
H277.2
C281048
D280
E280
H287.2
Sales.xlsx!Nov
CellDIY LabelValuediya-gl mapping
G15566.66666666667
G220
H127833.3333333333
T10
U10
Sales.xlsx!Dec
CellDIY LabelValuediya-gl mapping
G15486.66666666667
G220
H127433.3333333333
T10
U10
Sales.xlsx!Jan
CellDIY LabelValuediya-gl mapping
G15866.66666666667
G220
H129333.3333333333
T10
U10
Sales.xlsx!Feb
CellDIY LabelValuediya-gl mapping
G15626.66666666667
G220
H128133.3333333333
T10
U10
Sales.xlsx!Mar
CellDIY LabelValuediya-gl mapping
G16003.33333333333
G220
H130016.6666666667
T10
U10
Sales.xlsx!Apr
CellDIY LabelValuediya-gl mapping
G15626.66666666667
G220
H128133.3333333333
T10
U10
Sales.xlsx!May
CellDIY LabelValuediya-gl mapping
G18426.66666666667
G220
H142133.3333333333
T10
U112500
Sales.xlsx!Jun
CellDIY LabelValuediya-gl mapping
G15886.66666666667
G220
H129433.3333333333
T10
U10
Sales.xlsx!Jul
CellDIY LabelValuediya-gl mapping
G15466.66666666667
G220
H127333.3333333333
T10
U10
Sales.xlsx!Aug
CellDIY LabelValuediya-gl mapping
G15906.66666666667
G220
H129533.3333333333
T10
U10
Sales.xlsx!Sep
CellDIY LabelValuediya-gl mapping
G15726.66666666667
G220
H128633.3333333333
T10
U10
Sales.xlsx!Oct
CellDIY LabelValuediya-gl mapping
G15226.66666666667
G220
H126133.3333333333
T1300
U10
Purchases.xlsx!Nov
CellDIY LabelValuediya-gl mapping
G1851.875
G220
H14259.375
O1500
R10
S10
AI10
Purchases.xlsx!Dec
CellDIY LabelValuediya-gl mapping
G11062.5
G220
H15312.5
O1600
R10
S10
AI11500
Purchases.xlsx!Jan
CellDIY LabelValuediya-gl mapping
G14109.5
G220
H120547.5
O1300
R10
S10
AI113000
Purchases.xlsx!Feb
CellDIY LabelValuediya-gl mapping
G11509.875
G220
H17549.375
O1600
R10
S10
AI11000
Purchases.xlsx!Mar
CellDIY LabelValuediya-gl mapping
G1734.208333333333
G220
H13671.04166666667
O1450
R10
S1666.666666666667
AI10
Purchases.xlsx!Apr
CellDIY LabelValuediya-gl mapping
G12229.16666666667
G220
H111145.8333333333
O1200
R10
S10
AI17000
Purchases.xlsx!May
CellDIY LabelValuediya-gl mapping
G17167.625
G220
H135838.125
O1400
R10
S10
AI130000
Purchases.xlsx!Jun
CellDIY LabelValuediya-gl mapping
G11153
G220
H15765
O1700
R10
S10
AI10
Purchases.xlsx!Jul
CellDIY LabelValuediya-gl mapping
G11575.25
G220
H17876.25
O1400
R14166.66666666667
S10
AI10
Purchases.xlsx!Aug
CellDIY LabelValuediya-gl mapping
G1751.875
G220
H13759.375
O1500
R10
S10
AI10
Purchases.xlsx!Sep
CellDIY LabelValuediya-gl mapping
G1732.75
G220
H13663.75
O1550
R10
S10
AI10
Purchases.xlsx!Oct
CellDIY LabelValuediya-gl mapping
G1621.083333333333
G220
H13105.41666666667
O1250
R10
S10
AI10
Vatreturns.xlsx!VATQtr1
CellDIY LabelValuediya-gl mapping
G546418
G746446
G916920
G1316920
G156023.875
G1710896.125
G2184599.9999999999
G2330119.375
Vatreturns.xlsx!VATQtr2
CellDIY LabelValuediya-gl mapping
G546507
G746538
G917256.6666666667
G1317256.6666666667
G154473.25
G1712783.4166666667
G2186283.3333333333
G2322366.25
Vatreturns.xlsx!VATQtr3
CellDIY LabelValuediya-gl mapping
G546599
G746630
G919780
G1319780
G159895.875
G179884.12500000001
G2198899.9999999999
G2349479.375
Vatreturns.xlsx!VATQtr4
CellDIY LabelValuediya-gl mapping
G546691
G746721
G916860
G1316860
G152105.70833333333
G1714754.2916666667
G2184299.9999999999
G2310528.5416666667
Vatreturns.xlsx!VATQtr5
CellDIY LabelValuediya-gl mapping
G546783
G746812
G91100
G131100
G15180
G17920
G215500
G23900
Vatreturns.xlsx!Vatinterface
CellDIY LabelValuediya-gl mapping
B446295
C446326
D44000
F4800
H4600
J4120
M40
B546326
C546356
D52000
F5400
H51000
J5200
M50
B646356
C646387
D627833.3333333333
E633833.3333333333
F65566.66666666667
G66766.66666666667
H64259.375
I65859.375
J6851.875
K61171.875
M60
B746387
C746418
D727433.3333333333
E757266.6666666666
F75486.66666666667
G711453.3333333333
H75312.5
I710571.875
J71062.5
K72114.375
M70
B846418
C846446
D829333.3333333333
E884599.9999999999
F85866.66666666667
G816920
H820547.5
I830119.375
J84109.5
K86023.875
M80
B946446
C946477
D928133.3333333333
E984899.9999999999
F95626.66666666667
G916980
H97549.375
I933409.375
J91509.875
K96681.875
M90
B1046477
C1046507
D1030016.6666666667
E1087483.3333333333
F106003.33333333333
G1017496.6666666667
H103671.04166666667
I1031767.9166666667
J10734.208333333333
K106353.58333333333
M100
B1146507
C1146538
D1128133.3333333333
E1186283.3333333333
F115626.66666666667
G1117256.6666666667
H1111145.8333333333
I1122366.25
J112229.16666666667
K114473.25
M110
B1246538
C1246568
D1242133.3333333333
E12100283.333333333
F128426.66666666667
G1220056.6666666667
H1235838.125
I1250655
J127167.625
K1210131
M120
B1346568
C1346599
D1329433.3333333333
E1399699.9999999999
F135886.66666666667
G1319940
H135765
I1352748.9583333333
J131153
K1310549.7916666667
M130
B1446599
C1446630
D1427333.3333333333
E1498899.9999999999
F145466.66666666667
G1419780
H147876.25
I1449479.375
J141575.25
K149895.875
M140
B1546630
C1546660
D1529533.3333333333
E1586299.9999999999
F155906.66666666667
G1517260
H153759.375
I1517400.625
J15751.875
K153480.125
M150
B1646660
C1646691
D1628633.3333333333
E1685499.9999999999
F165726.66666666667
G1617100
H163663.75
I1615299.375
J16732.75
K163059.875
M160
B1746691
C1746721
D1726133.3333333333
E1784299.9999999999
F175226.66666666667
G1716860
H173105.41666666667
I1710528.5416666667
J17621.083333333333
K172105.70833333333
M170
B1846721
C1846752
D183000
E1857766.6666666666
F18600
G1811553.3333333333
H18200
I186969.16666666667
J1840
K181393.83333333333
M180
B1946752
C1946783
D191500
E1930633.3333333333
F19300
G196126.66666666667
H19300
I193605.41666666667
J1960
K19721.083333333333
M190
B2046783
C2046812
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 included285500
F1Total accumulated depreciation brought forward50098
G1Total net book value brought forward (cost less depreciation brought forward)182902
I1Total depreciation charged for the year13740
J1Total accumulated depreciation carried forward (brought forward plus the charge)63838
K1Total net book value carried forward, disposals removed208990
Q1Total annual investment allowance claimed52500
R1Total writing down allowance claimed3360
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 year233000
E110Cost of the assets bought during the year52500
E11200000
F1140000
I110
W110
X110
E640
F640
I640
W640
X640
B11Existing Land & Property
H70
E220
F220
I220
W220
X220
E7552500
F750
I755250
W750
X750
B22Existing Plant & Machinery
H130.1
E300
F300
I300
W300
X300
E830
F830
I830
W830
X830
B30Existing Fixtures & Fittings
H240.2
E413000
F41270
I41990
W410
X410
E940
F940
I940
W940
X940
B41Existing Computers
H320.33
E5530000
F559828
I557500
W5530000
X5517328
E1080
F1080
I1080
W1080
X1080
B55Existing Motor Vehicles
H430.25
O5024000
V5012500
R503360
S5020640
Y508140
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!Payment
CellDIY LabelValuediya-gl mapping
B446507
C446526
D4873.2
E4800
I41673.2
B546538
C546557
D5873.2
E5800
I51673.2
B646568
C646587
D6873.2
E6800
I61673.2
B746599
C746618
D7873.2
E7800
I71673.2
B846630
C846649
D8873.2
E8800
I81673.2
B946660
C946679
D9873.2
E9800
I91673.2
B1046691
C1046710
D10873.2
E10800
I101673.2
B1146721
C1146740
D11873.2
E11800
I111673.2
B1246752
C1246771
D12873.2
E12800
I121673.2
B1346783
C1346802
D13873.2
E13800
I131673.2
B1446812
C1446831
D14873.2
E14800
I141673.2
B1546843
C1546862
D15873.2
E15800
I151673.2
Payslips.xlsx!Payslips
CellDIY LabelValuediya-gl mapping
H3Dec
H448
L7MONTHLY PAYROLL
I946387
I102
M81
G143500
H14530
I14200
M142770
G167000
H161060
I16400
M165540
M1846387
Payslips.xlsx!Admin
CellDIY LabelValuediya-gl mapping
B246483
A2Nov
C21
D21
F21
A28Dec
B2846509
C285
D282
F281
A56Jan
B5646537
C569
D563
F561
A91Feb
B9146572
C9114
D914
F911
A119Mar
B11946600
C11918
D1195
F1191
A147Apr
B14746628
C14722
D1476
F1471
A182May
B18246663
C18227
D1827
F1821
A210Jun
B21046691
C21031
D2108
F2101
A238Jul
B23846719
C23835
D2389
F2381
A273Aug
B27346754
C27340
D27310
F2731
A301Sep
B30146782
C30144
D30111
F3011
A329Oct
B32946810
C32948
D32912
F3291
Payslips.xlsx!Nov
CellDIY LabelValuediya-gl mapping
K4946327
T1577.2
O1296
N1800
P10
Payslips.xlsx!Dec
CellDIY LabelValuediya-gl mapping
K4946357
T1577.2
O1296
N1800
P10
Payslips.xlsx!Jan
CellDIY LabelValuediya-gl mapping
K5946388
T1577.2
O1296
N1800
P10
Payslips.xlsx!Feb
CellDIY LabelValuediya-gl mapping
K4946419
T1577.2
O1296
N1800
P10
T410
M4946446
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!Mar
CellDIY LabelValuediya-gl mapping
K4946447
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
M4946477
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!Apr
CellDIY LabelValuediya-gl mapping
K5946478
T1577.2
O1296
N1800
P10
Payslips.xlsx!May
CellDIY LabelValuediya-gl mapping
K4946508
T1577.2
O1296
N1800
P10
Payslips.xlsx!Jun
CellDIY LabelValuediya-gl mapping
K4946539
T1577.2
O1296
N1800
P10
Payslips.xlsx!Jul
CellDIY LabelValuediya-gl mapping
K5946569
T1577.2
O1296
N1800
P10
Payslips.xlsx!Aug
CellDIY LabelValuediya-gl mapping
K4946600
T1577.2
O1296
N1800
P10
Payslips.xlsx!Sep
CellDIY LabelValuediya-gl mapping
K4946631
T1577.2
O1296
N1800
P10
Payslips.xlsx!Oct
CellDIY LabelValuediya-gl mapping
K6946661
T1577.2
O1296
N1800
P10
Companysecretary.xlsx!RegisterofMembers
CellDIY LabelValuediya-gl mapping
F11
G1100
A3Carol Smith
G360
A4David Brown
G425
A5Emma Wilson
G515
Companysecretary.xlsx!Boardmeeting
CellDIY LabelValuediya-gl mapping
F246691
E415000
Companysecretary.xlsx!Charges&Debentures
CellDIY LabelValuediya-gl mapping
C230000
Companysecretary.xlsx!Directors&Secretary
CellDIY LabelValuediya-gl mapping
A2Carol Smith
B2123 High Street, Manchester, M1 1AA
D2Director
D3Company Secretary
Companysecretary.xlsx!DirectorsInterests
CellDIY LabelValuediya-gl mapping
A2Carol Smith
B2123 High Street, Manchester, M1 1AA
C243831
expensesform.xlsx!Month 01
CellDIY LabelValuediya-gl mapping
C300.45
expensesform.xlsx!Month 02
CellDIY LabelValuediya-gl mapping
C300.45
expensesform.xlsx!Month 03
CellDIY LabelValuediya-gl mapping
C300.45
expensesform.xlsx!Month 04
CellDIY LabelValuediya-gl mapping
C300.45
expensesform.xlsx!Month 05
CellDIY LabelValuediya-gl mapping
C300.45
expensesform.xlsx!Month 06
CellDIY LabelValuediya-gl mapping
C300.45
expensesform.xlsx!Month 07
CellDIY LabelValuediya-gl mapping
C300.45
expensesform.xlsx!Month 08
CellDIY LabelValuediya-gl mapping
C300.45
expensesform.xlsx!Month 09
CellDIY LabelValuediya-gl mapping
C300.45
expensesform.xlsx!Month 10
CellDIY LabelValuediya-gl mapping
C300.45
expensesform.xlsx!Month 11
CellDIY LabelValuediya-gl mapping
C300.45
expensesform.xlsx!Month 12
CellDIY LabelValuediya-gl mapping
C300.45
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
Currentaccount.xlsx!Oct
CellDIY LabelValuediya-gl mapping
A1183505.63
A2181215.43
Savingaccount.xlsx!Oct
CellDIY LabelValuediya-gl mapping
A15125
A210275
Cashaccount.xlsx!Oct
CellDIY LabelValuediya-gl mapping
A1492
A2480
Creditcardaccount.xlsx!Oct
CellDIY LabelValuediya-gl mapping
A11025
A21025

Tax review

Corporation Tax working sheet

Amount
Operating Profit171,840.39
    Add back: Goodwill2,500
    Add back: Depreciation13,740
    Add back: total16,240
Operational profit chargeable188,080.39
    Less: Capital Allowances64,000
Profit after capital allowances124,080.39
    Add: gross bank interest339.51
    Less: losses brought forward0
Profit Chargeable to CT124,419.9
Corporation Tax29,221.27
Tax Outstanding29,156.77