DIY Accounting Spreadsheets

Excel bookkeeping and accounting software for UK small businesses

Limited Company reconciliation

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

Summary

Every run

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

Reconciliation checks

CheckExpectedActualDiffResult
Total Sales341283341283.333333333+0.3333333330228925PASS
P&L: Gross = Turnover - CoS323539.333333333323539.3333333330PASS
P&L: Operating = Gross - Admin276191.083333333276191.0833333330PASS
P&L: PBT = Operating + Interest276191.083333333276191.0833333330PASS
P&L: Admin lines sum = Total47348.2547348.250PASS
Premises14400144000PASS
Legal & Professional531053100PASS
Corporation Tax5304653046.3058333333+0.3058333333028713PASS
CT: Chargeable >= Operating276191.083333333279191.083333333+3000PASS
CT: Tax outstanding = CT53046.305833333353046.30583333330PASS
CT: Marginal relief expected (profit > £50K)6979853046.3058333333-16751.694166666697WARNING

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.251970,568.00
May932,920.00346,375.001126,713.00
Jun935,200.00339,057.001327,608.00
Jul933,760.00349,059.251434,353.00
Aug1036,020.00324,405.251029,353.00
Sep1033,760.00334,975.001225,504.00
Oct1150,560.003543,005.751790,873.00
Nov935,320.00316,918.001026,578.00
Dec832,800.00339,451.501227,070.00
Jan1135,440.00334,511.251437,453.00
Feb934,360.00334,396.501027,093.00
Mar831,360.00313,726.501543,040.00
Year112424,900.00393110,992.25157466,206.00

Every entry

Sales journal: 112 entries, 424,900.00
Apr
DateCustomerCodeAmount
2025-04-01Beta Systemsb1,200.00
2025-04-03FreshField Ltdb360.00
2025-04-05CloudNine Ltdb600.00
2025-04-08Cedar Systemsa480.00
2025-04-10Pinnacle Groupa720.00
2025-04-15Acme Corpa25,000.00
2025-04-18TechStart Ltda2,400.00
2025-04-20DataFlow Inca1,800.00
2025-04-28Horizon Analyticsd840.00
May
DateCustomerCodeAmount
2025-05-03FreshField Ltdb360.00
2025-05-05CloudNine Ltdb600.00
2025-05-08Cedar Systemsa480.00
2025-05-10Pinnacle Groupa720.00
2025-05-12QuickFix ITa960.00
2025-05-15Acme Corpa25,000.00
2025-05-16Summit Trainingc1,200.00
2025-05-18TechStart Ltda2,400.00
2025-05-25Oakridge Partnersa1,200.00
Jun
DateCustomerCodeAmount
2025-06-03FreshField Ltdb360.00
2025-06-05CloudNine Ltdb600.00
2025-06-08Cedar Systemsa480.00
2025-06-10Pinnacle Groupa720.00
2025-06-15Acme Corpa25,000.00
2025-06-18TechStart Ltda2,400.00
2025-06-20DataFlow Inca1,800.00
2025-06-20Gamma Ltdc2,400.00
2025-06-22WidgetWorksa1,440.00
Jul
DateCustomerCodeAmount
2025-07-01Beta Systemsb1,200.00
2025-07-03FreshField Ltdb360.00
2025-07-05CloudNine Ltdb600.00
2025-07-08Cedar Systemsa480.00
2025-07-10Pinnacle Groupa720.00
2025-07-14NorthStar Digitala2,160.00
2025-07-15Acme Corpa25,000.00
2025-07-18TechStart Ltda2,400.00
2025-07-28Horizon Analyticsd840.00
Aug
DateCustomerCodeAmount
2025-08-01Innovate UKg2,500.00
2025-08-03FreshField Ltdb360.00
2025-08-05CloudNine Ltdb600.00
2025-08-08Cedar Systemsa480.00
2025-08-10Pinnacle Groupa720.00
2025-08-12QuickFix ITa960.00
2025-08-15Acme Corpa25,000.00
2025-08-18TechStart Ltda2,400.00
2025-08-20DataFlow Inca1,800.00
2025-08-25Oakridge Partnersa1,200.00
Sep
DateCustomerCodeAmount
2025-09-03FreshField Ltdb360.00
2025-09-05CloudNine Ltdb600.00
2025-09-08Cedar Systemsa480.00
2025-09-10Pinnacle Groupa720.00
2025-09-15Acme Corpa25,000.00
2025-09-16Summit Trainingc1,200.00
2025-09-18TechStart Ltda2,400.00
2025-09-20StartupHubc960.00
2025-09-22WidgetWorksa1,440.00
2025-09-25Epsilon Partnersd600.00
Oct
DateCustomerCodeAmount
2025-10-01Beta Systemsb1,200.00
2025-10-03FreshField Ltdb360.00
2025-10-05CloudNine Ltdb600.00
2025-10-08Cedar Systemsa480.00
2025-10-10Private buyerfs15,000.00
2025-10-10Pinnacle Groupa720.00
2025-10-14NorthStar Digitala2,160.00
2025-10-15Acme Corpa25,000.00
2025-10-18TechStart Ltda2,400.00
2025-10-20DataFlow Inca1,800.00
2025-10-28Horizon Analyticsd840.00
Nov
DateCustomerCodeAmount
2025-11-03FreshField Ltdb360.00
2025-11-05CloudNine Ltdb600.00
2025-11-08Cedar Systemsa480.00
2025-11-10Pinnacle Groupa720.00
2025-11-12QuickFix ITa960.00
2025-11-15Acme Corpa25,000.00
2025-11-18TechStart Ltda2,400.00
2025-11-20Delta PLCc3,600.00
2025-11-25Oakridge Partnersa1,200.00
Dec
DateCustomerCodeAmount
2025-12-03FreshField Ltdb360.00
2025-12-05CloudNine Ltdb600.00
2025-12-08Cedar Systemsa480.00
2025-12-10Pinnacle Groupa720.00
2025-12-15Acme Corpa25,000.00
2025-12-18TechStart Ltda2,400.00
2025-12-20DataFlow Inca1,800.00
2025-12-22WidgetWorksa1,440.00
Jan
DateCustomerCodeAmount
2026-01-01Beta Systemsb1,200.00
2026-01-03FreshField Ltdb360.00
2026-01-05CloudNine Ltdb600.00
2026-01-08Cedar Systemsa480.00
2026-01-10Pinnacle Groupa720.00
2026-01-14NorthStar Digitala2,160.00
2026-01-15Acme Corpa25,000.00
2026-01-16Summit Trainingc1,200.00
2026-01-18TechStart Ltda2,400.00
2026-01-25Lambda Corpd480.00
2026-01-28Horizon Analyticsd840.00
Feb
DateCustomerCodeAmount
2026-02-03FreshField Ltdb360.00
2026-02-05CloudNine Ltdb600.00
2026-02-08Cedar Systemsa480.00
2026-02-10Pinnacle Groupa720.00
2026-02-15Acme Corpa25,000.00
2026-02-18TechStart Ltda2,400.00
2026-02-20DataFlow Inca1,800.00
2026-02-20MegaCorpc1,800.00
2026-02-25Oakridge Partnersa1,200.00
Mar
DateCustomerCodeAmount
2026-03-03FreshField Ltdb360.00
2026-03-05CloudNine Ltdb600.00
2026-03-08Cedar Systemsa480.00
2026-03-10Pinnacle Groupa720.00
2026-03-15Acme Corpa25,000.00
2026-03-18TechStart Ltda2,400.00
2026-03-22WidgetWorksa1,440.00
2026-03-31Zeta Corpo360.00
Purchase journal: 393 entries, 110,992.25
Apr
DateSupplierCodeAmount
2025-04-01WorkSpace Ltdr1,200.00
2025-04-01Microsoftg30.00
2025-04-01Slackg15.00
2025-04-01GitHubo45.00
2025-04-01Hiscoxn1,440.00
2025-04-01Cloudflareo24.00
2025-04-01Zoomg18.00
2025-04-03AWSo180.00
2025-04-03Argosu22.00
2025-04-05Rymanu24.00
2025-04-05BPv180.00
2025-04-05DigitalOceano36.00
2025-04-08National Railh48.00
2025-04-10Amazonu36.00
2025-04-10Xeroxf180.00
2025-04-10TechPartss600.00
2025-04-12NCPv18.00
2025-04-14Toolstationu42.00
2025-04-14Uberh24.00
2025-04-14Costa Coffeeh12.00
2025-04-15Shellv150.00
2025-04-15Royal Mailg12.00
2025-04-18Jetv96.00
2025-04-20BT Businessg60.00
2025-04-20Office Maintenance Ltdm120.00
2025-04-21Greggsh8.00
2025-04-22Screwfixu18.00
2025-04-25Wilkou15.00
2025-04-25Mileage claimv38.25
2025-04-28Shellv120.00
2025-04-30Smith & Col300.00
May
DateSupplierCodeAmount
2025-05-01WorkSpace Ltdr1,200.00
2025-05-01Microsoftg30.00
2025-05-01Slackg15.00
2025-05-01GitHubo45.00
2025-05-01Cloudflareo24.00
2025-05-01Zoomg18.00
2025-05-03AWSo180.00
2025-05-03Argosu22.00
2025-05-05Rymanu24.00
2025-05-05BPv180.00
2025-05-06Trainlineh60.00
2025-05-08National Railh48.00
2025-05-08Hiltiq240.00
2025-05-10Amazonu36.00
2025-05-10Google Adsa600.00
2025-05-12NCPv18.00
2025-05-14Uberh24.00
2025-05-14Costa Coffeeh12.00
2025-05-15Shellv150.00
2025-05-15Royal Mailg12.00
2025-05-15ComponentsDirects480.00
2025-05-15Dellfa1,800.00
2025-05-16WHSmithg18.00
2025-05-18Jetv96.00
2025-05-20BT Businessg60.00
2025-05-20ParcelForcet180.00
2025-05-20CableCos240.00
2025-05-21Greggsh8.00
2025-05-22Screwfixu18.00
2025-05-22Halfordsv48.00
2025-05-25Wilkou15.00
2025-05-25Mileage claimv54.00
2025-05-28Shellv120.00
2025-05-31Smith & Col300.00
Jun
DateSupplierCodeAmount
2025-06-01WorkSpace Ltdr1,200.00
2025-06-01Microsoftg30.00
2025-06-01Slackg15.00
2025-06-01GitHubo45.00
2025-06-01Cloudflareo24.00
2025-06-01Zoomg18.00
2025-06-03AWSo180.00
2025-06-03Argosu22.00
2025-06-05Rymanu24.00
2025-06-05BPv180.00
2025-06-05DigitalOceano36.00
2025-06-08National Railh48.00
2025-06-10Amazonu36.00
2025-06-10Vistaprintg96.00
2025-06-12NCPv18.00
2025-06-14Toolstationu30.00
2025-06-14Uberh24.00
2025-06-14Costa Coffeeh12.00
2025-06-15Shellv150.00
2025-06-15Royal Mailg12.00
2025-06-15BuildTech Solutionsc5,000.00
2025-06-18Premier Innh180.00
2025-06-18ElectroPartss360.00
2025-06-18Jetv96.00
2025-06-20BT Businessg60.00
2025-06-21Greggsh8.00
2025-06-22Screwfixu18.00
2025-06-25EnergySupplyp360.00
2025-06-25Wilkou15.00
2025-06-25Mileage claimv90.00
2025-06-28Shellv120.00
2025-06-30Smith & Col300.00
2025-06-30Directors loanl250.00
Jul
DateSupplierCodeAmount
2025-07-01WorkSpace Ltdr1,200.00
2025-07-01Microsoftg30.00
2025-07-01Slackg15.00
2025-07-01GitHubo45.00
2025-07-01J. Smith Consultingz3,000.00
2025-07-01Cloudflareo24.00
2025-07-01Zoomg18.00
2025-07-03AWSo180.00
2025-07-03Argosu22.00
2025-07-05Rymanu24.00
2025-07-05LinkedIna480.00
2025-07-05BPv180.00
2025-07-08National Railh48.00
2025-07-10Amazonu36.00
2025-07-10Xeroxf180.00
2025-07-10TechPartss720.00
2025-07-12NCPv18.00
2025-07-12ToolHireq480.00
2025-07-14Uberh24.00
2025-07-14Costa Coffeeh12.00
2025-07-15Shellv150.00
2025-07-15Royal Mailg12.00
2025-07-15IKEAfa1,200.00
2025-07-16WHSmithg24.00
2025-07-18Jetv96.00
2025-07-20BT Businessg60.00
2025-07-20DHLt120.00
2025-07-20Office Maintenance Ltdm180.00
2025-07-21Greggsh8.00
2025-07-22Screwfixu18.00
2025-07-25Wilkou15.00
2025-07-25Mileage claimv20.25
2025-07-28Shellv120.00
2025-07-31Smith & Col300.00
Aug
DateSupplierCodeAmount
2025-08-01WorkSpace Ltdr1,200.00
2025-08-01Microsoftg30.00
2025-08-01Slackg15.00
2025-08-01GitHubo45.00
2025-08-01Cloudflareo24.00
2025-08-01Zoomg18.00
2025-08-03AWSo180.00
2025-08-03Argosu22.00
2025-08-05Rymanu24.00
2025-08-05BPv180.00
2025-08-05DigitalOceano36.00
2025-08-06Trainlineh48.00
2025-08-08National Railh48.00
2025-08-10Amazonu36.00
2025-08-12NCPv18.00
2025-08-14Toolstationu48.00
2025-08-14Uberh24.00
2025-08-14Costa Coffeeh12.00
2025-08-15Shellv150.00
2025-08-15Royal Mailg12.00
2025-08-15ComponentsDirects360.00
2025-08-18PC Repair Shopm240.00
2025-08-18Jetv96.00
2025-08-20BT Businessg60.00
2025-08-20Casual workerw800.00
2025-08-20CableCos180.00
2025-08-21Greggsh8.00
2025-08-22Screwfixu18.00
2025-08-25Wilkou15.00
2025-08-25Mileage claimv38.25
2025-08-28Shellv120.00
2025-08-31Smith & Col300.00
Sep
DateSupplierCodeAmount
2025-09-01WorkSpace Ltdr1,200.00
2025-09-01Microsoftg30.00
2025-09-01Slackg15.00
2025-09-01GitHubo45.00
2025-09-01Cloudflareo24.00
2025-09-01Zoomg18.00
2025-09-03AWSo180.00
2025-09-03Argosu22.00
2025-09-05Rymanu24.00
2025-09-05BPv180.00
2025-09-08National Railh48.00
2025-09-08Hiltiq360.00
2025-09-10Amazonu36.00
2025-09-10Royal Mailt96.00
2025-09-12NCPv18.00
2025-09-14Uberh24.00
2025-09-14Costa Coffeeh12.00
2025-09-15Shellv150.00
2025-09-15Royal Mailg12.00
2025-09-15Jones Solicitorsl960.00
2025-09-16WHSmithg12.00
2025-09-18ElectroPartss240.00
2025-09-18Jetv96.00
2025-09-20BT Businessg60.00
2025-09-21Greggsh8.00
2025-09-22Screwfixu18.00
2025-09-22Halfordsv72.00
2025-09-25EnergySupplyp300.00
2025-09-25Wilkou15.00
2025-09-25Mileage claimv72.00
2025-09-28Shellv120.00
2025-09-30Smith & Col300.00
2025-09-30Directors loanl208.00
Oct
DateSupplierCodeAmount
2025-10-01WorkSpace Ltdr1,200.00
2025-10-01Microsoftg30.00
2025-10-01Slackg15.00
2025-10-01GitHubo45.00
2025-10-01Simply Businessn360.00
2025-10-01Cloudflareo24.00
2025-10-01Zoomg18.00
2025-10-03AWSo180.00
2025-10-03Argosu22.00
2025-10-05Rymanu24.00
2025-10-05BPv180.00
2025-10-05DigitalOceano36.00
2025-10-08National Railh48.00
2025-10-10Amazonu36.00
2025-10-10Xeroxf180.00
2025-10-10TechPartss480.00
2025-10-10Google Adsa1,800.00
2025-10-12NCPv18.00
2025-10-14Toolstationu36.00
2025-10-14Uberh24.00
2025-10-14Costa Coffeeh12.00
2025-10-15Shellv150.00
2025-10-15Royal Mailg12.00
2025-10-15TechExpoa1,200.00
2025-10-18Premier Innh120.00
2025-10-18Jetv96.00
2025-10-20BT Businessg60.00
2025-10-20Office Maintenance Ltdm96.00
2025-10-21Greggsh8.00
2025-10-22Screwfixu18.00
2025-10-25Wilkou15.00
2025-10-25Mileage claimv42.75
2025-10-25Fordfa36,000.00
2025-10-28Shellv120.00
2025-10-31Smith & Col300.00
Nov
DateSupplierCodeAmount
2025-11-01WorkSpace Ltdr1,200.00
2025-11-01Microsoftg30.00
2025-11-01Slackg15.00
2025-11-01GitHubo45.00
2025-11-01Cloudflareo24.00
2025-11-01Zoomg18.00
2025-11-03AWSo180.00
2025-11-03Argosu22.00
2025-11-05Rymanu24.00
2025-11-05BPv180.00
2025-11-06Trainlineh72.00
2025-11-08National Railh48.00
2025-11-10Amazonu36.00
2025-11-12NCPv18.00
2025-11-14Uberh24.00
2025-11-14Costa Coffeeh12.00
2025-11-15Shellv150.00
2025-11-15Royal Mailg12.00
2025-11-15ComponentsDirects540.00
2025-11-15BuildTech Solutionsc3,000.00
2025-11-16WHSmithg30.00
2025-11-18Jetv96.00
2025-11-20BT Businessg60.00
2025-11-20ParcelForcet240.00
2025-11-20CableCos300.00
2025-11-21Greggsh8.00
2025-11-22Screwfixu18.00
2025-11-25Wilkou15.00
2025-11-25Mileage claimv81.00
2025-11-28Shellv120.00
2025-11-30Smith & Col300.00
Dec
DateSupplierCodeAmount
2025-12-01WorkSpace Ltdr1,200.00
2025-12-01Microsoftg30.00
2025-12-01Slackg15.00
2025-12-01GitHubo45.00
2025-12-01Cloudflareo24.00
2025-12-01Zoomg18.00
2025-12-03AWSo180.00
2025-12-03Argosu22.00
2025-12-05Rymanu24.00
2025-12-05BPv180.00
2025-12-05DigitalOceano36.00
2025-12-08National Railh48.00
2025-12-10Amazonu36.00
2025-12-10Vistaprintg120.00
2025-12-12NCPv18.00
2025-12-14Toolstationu24.00
2025-12-14Uberh24.00
2025-12-14Costa Coffeeh12.00
2025-12-15Shellv150.00
2025-12-15Royal Mailg12.00
2025-12-15Code Club UKy500.00
2025-12-18ElectroPartss480.00
2025-12-18Jetv96.00
2025-12-20BT Businessg60.00
2025-12-21Greggsh8.00
2025-12-22Screwfixu18.00
2025-12-25EnergySupplyp420.00
2025-12-25Wilkou15.00
2025-12-25Mileage claimv49.50
2025-12-28Shellv120.00
2025-12-31Smith & Col300.00
2025-12-31Directord5,000.00
2025-12-31Directors loanl167.00
Jan
DateSupplierCodeAmount
2026-01-01WorkSpace Ltdr1,200.00
2026-01-01Microsoftg30.00
2026-01-01Slackg15.00
2026-01-01GitHubo45.00
2026-01-01Cloudflareo24.00
2026-01-01Zoomg18.00
2026-01-03AWSo180.00
2026-01-03Argosu22.00
2026-01-05Rymanu24.00
2026-01-05LinkedIna480.00
2026-01-05BPv180.00
2026-01-08National Railh48.00
2026-01-08Hiltiq180.00
2026-01-10Amazonu36.00
2026-01-10Xeroxf180.00
2026-01-10TechPartss600.00
2026-01-12NCPv18.00
2026-01-14Uberh24.00
2026-01-14Costa Coffeeh12.00
2026-01-15Shellv150.00
2026-01-15Royal Mailg12.00
2026-01-16WHSmithg18.00
2026-01-18Jetv96.00
2026-01-20BT Businessg60.00
2026-01-20DHLt180.00
2026-01-20Office Maintenance Ltdm144.00
2026-01-21Greggsh8.00
2026-01-22Screwfixu18.00
2026-01-22Halfordsv36.00
2026-01-25Wilkou15.00
2026-01-25Mileage claimv38.25
2026-01-28Shellv120.00
2026-01-31Smith & Col300.00
Feb
DateSupplierCodeAmount
2026-02-01WorkSpace Ltdr1,200.00
2026-02-01Microsoftg30.00
2026-02-01Slackg15.00
2026-02-01GitHubo45.00
2026-02-01Cloudflareo24.00
2026-02-01Zoomg18.00
2026-02-03AWSo180.00
2026-02-03Argosu22.00
2026-02-05Rymanu24.00
2026-02-05BPv180.00
2026-02-05DigitalOceano36.00
2026-02-06Trainlineh36.00
2026-02-08National Railh48.00
2026-02-10Amazonu36.00
2026-02-12NCPv18.00
2026-02-12ToolHireq360.00
2026-02-14Toolstationu18.00
2026-02-14Uberh24.00
2026-02-14Costa Coffeeh12.00
2026-02-15Shellv150.00
2026-02-15Royal Mailg12.00
2026-02-15ComponentsDirects420.00
2026-02-18PC Repair Shopm360.00
2026-02-18Premier Innh240.00
2026-02-18Jetv96.00
2026-02-20BT Businessg60.00
2026-02-20CableCos240.00
2026-02-21Greggsh8.00
2026-02-22Screwfixu18.00
2026-02-25Wilkou15.00
2026-02-25Mileage claimv31.50
2026-02-28Smith & Col300.00
2026-02-28Shellv120.00
Mar
DateSupplierCodeAmount
2026-03-01WorkSpace Ltdr1,200.00
2026-03-01Microsoftg30.00
2026-03-01Slackg15.00
2026-03-01GitHubo45.00
2026-03-01Cloudflareo24.00
2026-03-01Zoomg18.00
2026-03-03AWSo180.00
2026-03-03Argosu22.00
2026-03-05Rymanu24.00
2026-03-05BPv180.00
2026-03-08National Railh48.00
2026-03-10Amazonu36.00
2026-03-10Royal Mailt144.00
2026-03-12NCPv18.00
2026-03-14Uberh24.00
2026-03-14Costa Coffeeh12.00
2026-03-15Shellv150.00
2026-03-15Royal Mailg12.00
2026-03-16WHSmithg24.00
2026-03-18ElectroPartss300.00
2026-03-18Jetv96.00
2026-03-20BT Businessg60.00
2026-03-21Greggsh8.00
2026-03-22Screwfixu18.00
2026-03-22Halfordsv60.00
2026-03-25EnergySupplyp360.00
2026-03-25Wilkou15.00
2026-03-25Mileage claimv58.50
2026-03-28Shellv120.00
2026-03-31Smith & Col300.00
2026-03-31Directors loanl125.00
Bank and cash entries: 157 entries, 466,206.00
Apr
DateAccountSourceDescriptionCodeAmount
2025-04-011200Opening balanceCurrent account opening balanceBC25,000.00
2025-04-011200WorkSpace LtdOffice rent paymentCR1,200.00
2025-04-011200DirectorDirectors loan repaymentDL1,000.00
2025-04-051200Various suppliersAggregate supplier paymentsCR2,200.00
2025-04-101200Acme CorpOpening debtor receiptDR7,200.00
2025-04-151200Beta SystemsOpening debtor receiptDR1,200.00
2025-04-191200HMRCMonthly PAYE/NI paymentRP1,501.00
2025-04-201200Acme CorpCustomer receiptDR8,000.00
2025-04-251200TechStart LtdCustomer receiptDR2,400.00
2025-04-251200Gamma LtdOpening debtor receiptDR2,400.00
2025-04-281200Various customersAggregate customer receiptsDR3,200.00
2025-04-281200PayrollMonthly net wages (all staff)W5,652.00
2025-04-301200Smith & CoAccountancy fee paymentCR300.00
2025-04-301200Credit card paymentPay credit card balanceX500.00
2026-04-011200HMRCVAT payment Q4 Jan-MarRP2,800.00
2025-04-011210Opening balanceSavings account opening balanceBC5,000.00
2025-04-011220Opening balanceCash float opening balanceBC500.00
2025-04-101220Corner shopMilk and teaCR15.00
2025-04-301230Payment from currentCredit card payment receivedX500.00
May
DateAccountSourceDescriptionCodeAmount
2025-05-011200WorkSpace LtdOffice rent paymentCR1,200.00
2025-05-011200DirectorDirectors loan repaymentDL1,000.00
2025-05-051200Various suppliersAggregate supplier paymentsCR2,800.00
2025-05-191200HMRCMonthly PAYE/NI paymentRP1,501.00
2025-05-201200Acme CorpCustomer receiptDR8,000.00
2025-05-251200HSBCBank chargesB25.00
2025-05-251200TechStart LtdCustomer receiptDR2,400.00
2025-05-281200Various customersAggregate customer receiptsDR3,800.00
2025-05-281200PayrollMonthly net wages (all staff)W5,652.00
2025-05-311200Smith & CoAccountancy fee paymentCR300.00
2025-05-201230HSBCCredit card annual feeB35.00
Jun
DateAccountSourceDescriptionCodeAmount
2025-06-011200WorkSpace LtdOffice rent paymentCR1,200.00
2025-06-011200DirectorDirectors loan repaymentDL1,000.00
2025-06-051200Various suppliersAggregate supplier paymentsCR2,500.00
2025-06-191200HMRCMonthly PAYE/NI paymentRP1,501.00
2025-06-201200Acme CorpCustomer receiptDR8,000.00
2025-06-251200TechStart LtdCustomer receiptDR2,400.00
2025-06-281200Various customersAggregate customer receiptsDR4,500.00
2025-06-281200PayrollMonthly net wages (all staff)W5,652.00
2025-06-301200Directors loan interestQuarterly loan interest paymentB250.00
2025-06-301200Smith & CoAccountancy fee paymentCR300.00
2025-06-101220Cash top-upCash float replenishmentX100.00
2025-06-101220WH SmithEnvelopes and stampsCR25.00
2025-06-181230Premier InnHotel on credit cardCR180.00
Jul
DateAccountSourceDescriptionCodeAmount
2025-07-011200WorkSpace LtdOffice rent paymentCR1,200.00
2025-07-011200DirectorDirectors loan repaymentDL1,000.00
2025-07-051200Various suppliersAggregate supplier paymentsCR2,300.00
2025-07-071200HMRCVAT payment Q1 Apr-JunRP3,800.00
2025-07-151200DividendQuarterly dividend paymentDV3,000.00
2025-07-191200HMRCMonthly PAYE/NI paymentRP1,501.00
2025-07-191200HMRCCIS deduction remittanceRP1,000.00
2025-07-201200Acme CorpCustomer receiptDR8,000.00
2025-07-251200TechStart LtdCustomer receiptDR2,400.00
2025-07-281200Various customersAggregate customer receiptsDR3,600.00
2025-07-281200PayrollMonthly net wages (all staff)W5,652.00
2025-07-311200Smith & CoAccountancy fee paymentCR300.00
2025-07-311200Credit card paymentPay credit card balanceX300.00
2025-07-311230Payment from currentCredit card payment receivedX300.00
Aug
DateAccountSourceDescriptionCodeAmount
2025-08-011200WorkSpace LtdOffice rent paymentCR1,200.00
2025-08-011200DirectorDirectors loan repaymentDL1,000.00
2025-08-051200Various suppliersAggregate supplier paymentsCR2,600.00
2025-08-051200Innovate UKGrant receivedRV2,500.00
2025-08-191200HMRCMonthly PAYE/NI paymentRP1,501.00
2025-08-201200Acme CorpCustomer receiptDR8,000.00
2025-08-251200TechStart LtdCustomer receiptDR2,400.00
2025-08-281200Various customersAggregate customer receiptsDR4,200.00
2025-08-281200PayrollMonthly net wages (all staff)W5,652.00
2025-08-311200Smith & CoAccountancy fee paymentCR300.00
Sep
DateAccountSourceDescriptionCodeAmount
2025-09-011200WorkSpace LtdOffice rent paymentCR1,200.00
2025-09-011200DirectorDirectors loan repaymentDL1,000.00
2025-09-051200Various suppliersAggregate supplier paymentsCR2,100.00
2025-09-191200HMRCMonthly PAYE/NI paymentRP1,501.00
2025-09-201200Acme CorpCustomer receiptDR8,000.00
2025-09-251200TechStart LtdCustomer receiptDR2,400.00
2025-09-281200Various customersAggregate customer receiptsDR3,000.00
2025-09-281200PayrollMonthly net wages (all staff)W5,652.00
2025-09-301200Directors loan interestQuarterly loan interest paymentB208.00
2025-09-301200Smith & CoAccountancy fee paymentCR300.00
2025-09-301210HSBC SavingsSavings interestRV125.00
2025-09-051220Corner shopKitchen suppliesCR18.00
Oct
DateAccountSourceDescriptionCodeAmount
2025-10-011200WorkSpace LtdOffice rent paymentCR1,200.00
2025-10-011200DirectorDirectors loan repaymentDL1,000.00
2025-10-011200HMRCCorporation Tax prior yearRP4,500.00
2025-10-051200Various suppliersAggregate supplier paymentsCR3,000.00
2025-10-071200HMRCVAT payment Q2 Jul-SepRP3,200.00
2025-10-151200Private buyerVan sale proceedsDR15,000.00
2025-10-151200DividendQuarterly dividend paymentDV3,000.00
2025-10-191200HMRCMonthly PAYE/NI paymentRP1,501.00
2025-10-201200Acme CorpCustomer receiptDR8,000.00
2025-10-251200FordFord Transit Custom purchaseCR36,000.00
2025-10-251200TechStart LtdCustomer receiptDR2,400.00
2025-10-281200Various customersAggregate customer receiptsDR5,000.00
2025-10-281200PayrollMonthly net wages (all staff)W5,652.00
2025-10-311200Smith & CoAccountancy fee paymentCR300.00
2025-10-311200Credit card paymentPay credit card balanceX500.00
2025-10-181230TrainlineTrain ticket on credit cardCR120.00
2025-10-311230Payment from currentCredit card payment receivedX500.00
Nov
DateAccountSourceDescriptionCodeAmount
2025-11-011200WorkSpace LtdOffice rent paymentCR1,200.00
2025-11-011200DirectorDirectors loan repaymentDL1,000.00
2025-11-051200Various suppliersAggregate supplier paymentsCR2,400.00
2025-11-191200HMRCMonthly PAYE/NI paymentRP1,501.00
2025-11-201200Acme CorpCustomer receiptDR8,000.00
2025-11-251200HSBCBank chargesB25.00
2025-11-251200TechStart LtdCustomer receiptDR2,400.00
2025-11-281200Various customersAggregate customer receiptsDR4,100.00
2025-11-281200PayrollMonthly net wages (all staff)W5,652.00
2025-11-301200Smith & CoAccountancy fee paymentCR300.00
Dec
DateAccountSourceDescriptionCodeAmount
2025-12-011200WorkSpace LtdOffice rent paymentCR1,200.00
2025-12-011200DirectorDirectors loan repaymentDL1,000.00
2025-12-051200Various suppliersAggregate supplier paymentsCR2,700.00
2025-12-191200HMRCMonthly PAYE/NI paymentRP1,501.00
2025-12-191200HMRCCIS deduction remittanceRP600.00
2025-12-201200Acme CorpCustomer receiptDR8,000.00
2025-12-251200TechStart LtdCustomer receiptDR2,400.00
2025-12-281200Various customersAggregate customer receiptsDR3,500.00
2025-12-281200PayrollMonthly net wages (all staff)W5,652.00
2025-12-311200Directors loan interestQuarterly loan interest paymentB167.00
2025-12-311200Smith & CoAccountancy fee paymentCR300.00
2025-12-101220VariousChristmas team refreshmentsCR50.00
Jan
DateAccountSourceDescriptionCodeAmount
2026-01-011200WorkSpace LtdOffice rent paymentCR1,200.00
2026-01-011200DirectorDirectors loan repaymentDL1,000.00
2026-01-051200Various suppliersAggregate supplier paymentsCR2,500.00
2026-01-071200HMRCVAT refund Q3 Oct-DecRV1,500.00
2026-01-151200Director loanDirectors loan advanceDL5,000.00
2026-01-151200DividendQuarterly dividend paymentDV3,000.00
2026-01-191200HMRCMonthly PAYE/NI paymentRP1,501.00
2026-01-201200Acme CorpCustomer receiptDR8,000.00
2026-01-251200TechStart LtdCustomer receiptDR2,400.00
2026-01-281200Various customersAggregate customer receiptsDR4,800.00
2026-01-281200PayrollMonthly net wages (all staff)W5,652.00
2026-01-311200Smith & CoAccountancy fee paymentCR300.00
2026-01-311200Credit card paymentPay credit card balanceX300.00
2026-01-311230Payment from currentCredit card payment receivedX300.00
Feb
DateAccountSourceDescriptionCodeAmount
2026-02-011200WorkSpace LtdOffice rent paymentCR1,200.00
2026-02-011200DirectorDirectors loan repaymentDL1,000.00
2026-02-051200Various suppliersAggregate supplier paymentsCR2,900.00
2026-02-191200HMRCMonthly PAYE/NI paymentRP1,501.00
2026-02-201200Acme CorpCustomer receiptDR8,000.00
2026-02-251200TechStart LtdCustomer receiptDR2,400.00
2026-02-281200Smith & CoAccountancy fee paymentCR300.00
2026-02-281200Various customersAggregate customer receiptsDR3,900.00
2026-02-281200PayrollMonthly net wages (all staff)W5,652.00
2026-02-181230Premier InnHotel on credit cardCR240.00
Mar
DateAccountSourceDescriptionCodeAmount
2026-03-011200WorkSpace LtdOffice rent paymentCR1,200.00
2026-03-011200DirectorDirectors loan repaymentDL1,000.00
2026-03-051200Various suppliersAggregate supplier paymentsCR2,300.00
2026-03-151200Internal transferTransfer to savings accountX5,000.00
2026-03-191200HMRCMonthly PAYE/NI paymentRP1,501.00
2026-03-201200Acme CorpCustomer receiptDR8,000.00
2026-03-251200TechStart LtdCustomer receiptDR2,400.00
2026-03-281200Various customersAggregate customer receiptsDR4,400.00
2026-03-281200PayrollMonthly net wages (all staff)W5,652.00
2026-03-311200Directors loan interestQuarterly loan interest paymentB125.00
2026-03-311200Smith & CoAccountancy fee paymentCR300.00
2026-03-311200DividendFinal dividend paymentDV6,000.00
2026-03-151210Internal transferTransfer from current accountX5,000.00
2026-03-311210HSBC SavingsSavings interestRV150.00
2026-03-201220NewsagentNewspapers for receptionCR12.00

Payroll

EmployeeIDNameRoleGrossPayPayFrequencyTaxCodeNiCategoryIsDirector
EMP001Alice JohnsonSenior Developer3,500.00monthly1257LAno
EMP002Bob WilliamsSupport Technician2,200.00monthly1257LAno
EMP003Carol SmithDirector1,048.00monthly1257LAyes

Opening and closing balances

Opening balance
ItemValue
Fixed assets21,087.00
Motor vehicles20,172.00
Computer equipment2,730.00
Stock10,000.00
Trade debtors10,800.00
Current account25,000.00
Savings account5,000.00
Cash500.00
Trade creditors2,400.00
Vat liability1,500.00
Corporation tax4,500.00
Directors loan20,000.00
Share capital100.00
Retained earnings45,702.00
Stock
ItemValue
Opening10,000.00
Closing6,000.00
Opening debtors
CustomerInvoiceAmount
Acme CorpINV-09017,200.00
Beta SystemsINV-09021,200.00
Gamma LtdINV-09032,400.00
Closing debtors
CustomerInvoiceAmount
Acme CorpINV-10128,000.00
TechStart LtdINV-11122,400.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 dep
Van (2.5 years old)motor30,000.009,828.00
Laptop (0.5 years old)computer3,000.00270.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

Business Details

Amount
Company NamePrecision Code Ltd
Company Number12345678
Address123 High Street, Manchester M1 1AA
UTR1234567890

Profit & Loss Account

Amount
    Product A — Consultancy311,600
    Product B — Software13,600
    Product C — Training10,300
    Other Direct Income3,700
    Grants Received2,083.33
Sales Turnover341,283.33
    Materials / Stock6,540
    Sub-Contractors8,000
    Other Direct Costs3,204
Cost of Sales17,744
Gross Profit323,539.33
    PAYE Wages + Non-PAYE Employee800
    Directors Non-PAYE (code d)5,000
    PAYE Employee Wages0
    Premises (code r)14,400
    Light, Heat, Power (code p)1,440
    Distribution (code t)960
    Equipment Hire (code q)1,620
    Repairs & Maintenance (code m)1,140
    Consumables (code u)1,578
    Advertising (code a)4,560
    General Admin (code g)1,962
    Travel & Hotel (code h)1,860
    Motor Vehicle (code v)7,598.25
    Insurance (code n)1,800
    Leasing (code f)720
    Legal & Professional (code l)5,310
    Bad Debts (from Sales)-300
    Depreciation (bank)0
    Depreciation (combined)-6,600
    Charitable Donations (code y)500
    Goodwill (code z)3,000
    Depreciation 20
    Depreciation 30
Total Admin Expenses47,348.25
Operating Profit276,191.08
    Interest Received0
Profit Before Tax276,191.08

Published P&L

Amount
    Sales Turnover339,200
    Investment Grants2,083.33
Total Sales Turnover341,283.33
    Cost of Sales17,744
Gross Profit323,539.33

Published Balance Sheet

Amount
Fixed Assets (NBV)26,500
    Stock0
Current Assets544,435
    Creditors < 1 year-0
Net Current Assets305,304.78
Total Assets less CL331,804.78
    Other Creditors0
    Directors Loan1,891,132

Stock

Amount
Opening Stock10,000
Closing Stock6,000

Trial Balance

Amount
Audit Accuracy Check-1,782,472
Cell values behind these statements
OpenAccounts
CellDIY LabelValuediya-gl mapping
E2Company NamePrecision Code LtdentityInformation.organizationIdentifier
E3Company Number12345678diya-gl:companyNumber
E4Address123 High Street, Manchester M1 1AAgl-bus:organizationAddress
E6UTR1234567890gl-taf:taxRegistrationNumber
MnthP&L
CellDIY LabelValuediya-gl mapping
B4Product A — Consultancy311600accounts.sales.4000
B5Product B — Software13600accounts.sales.4001
B6Product C — Training10300accounts.sales.4002
B7Other Direct Income3700accounts.sales.4003
B8Grants Received2083.33333333333accounts.sales.4004
B9Sales Turnover341283.333333333gl-cor:amount (salesTurnover)
B11Materials / Stock6540accounts.purchases.5000
B12Sub-Contractors8000accounts.purchases.5001
B13Other Direct Costs3204accounts.purchases.5002
B14Cost of Sales17744gl-cor:amount (costOfSales)
B16Gross Profit323539.333333333gl-cor:amount (grossProfit)
B18PAYE Wages + Non-PAYE Employee800dpl:WagesAndSalaries (combined)
B19Directors Non-PAYE (code d)5000accounts.purchases.5100
B20PAYE Employee Wages0dpl:WagesAndSalaries (PAYE)
B21Premises (code r)14400accounts.purchases.5200
B22Light, Heat, Power (code p)1440accounts.purchases.5201
B23Distribution (code t)960accounts.purchases.5300
B24Equipment Hire (code q)1620accounts.purchases.5301
B25Repairs & Maintenance (code m)1140accounts.purchases.5400
B26Consumables (code u)1578accounts.purchases.5401
B27Advertising (code a)4560accounts.purchases.5500
B28General Admin (code g)1962accounts.purchases.5501
B29Travel & Hotel (code h)1860accounts.purchases.5600
B30Motor Vehicle (code v)7598.25accounts.purchases.5601
B31Insurance (code n)1800accounts.purchases.5700
B32Leasing (code f)720accounts.purchases.5701
B33Legal & Professional (code l)5310accounts.purchases.5800
B34Bad Debts (from Sales)-300accounts.sales.4005
B35Depreciation (bank)0gl-cor:amount (depreciation)
B36Depreciation (combined)-6600gl-cor:amount (depreciation2)
B37Charitable Donations (code y)500accounts.purchases.5801
B38Goodwill (code z)3000accounts.purchases.5802
B39Depreciation 20gl-cor:amount (depreciation3)
B40Depreciation 30gl-cor:amount (depreciation4)
B41Total Admin Expenses47348.25gl-cor:amount (totalAdmin)
B43Operating Profit276191.083333333gl-cor:amount (operatingProfit)
B44Interest Received0gl-cor:amount (interestReceived)
B45Profit Before Tax276191.083333333gl-cor:amount (profitBeforeTax)
CorporationTax
CellDIY LabelValuediya-gl mapping
K5Operating Profit276191.083333333gl-cor:amount (ct600.box145)
K12Add back: Depreciation279191.083333333gl-cor:amount (ct600.addBack)
K22Less: Capital Allowances279191.083333333tax.capitalAllowances (ct600)
K28Profit Chargeable to CT279191.083333333gl-cor:amount (ct600.box315)
K35Corporation Tax53046.3058333333gl-cor:taxAmount (ct600.box430)
K39Tax Outstanding53046.3058333333gl-cor:taxAmount (ct600.box515)
PubP&L
CellDIY LabelValuediya-gl mapping
D7Sales Turnover339200gl-cor:amount (pubPL.salesTurnover)
D8Investment Grants2083.33333333333gl-cor:amount (pubPL.grants)
D9Total Sales Turnover341283.333333333gl-cor:amount (pubPL.totalTurnover)
D16Cost of Sales17744gl-cor:amount (pubPL.cos)
D18Gross Profit323539.333333333gl-cor:amount (pubPL.gross)
PubBalSht
CellDIY LabelValuediya-gl mapping
D6Fixed Assets (NBV)26500gl-cor:amount (pubBS.fixedAssets)
D9Stock0accounts.assets.1100 (pubBS)
D13Current Assets544435gl-cor:amount (pubBS.currentAssets)
D15Creditors < 1 year0gl-cor:amount (pubBS.creditors)
D22Net Current Assets305304.7775gl-cor:amount (pubBS.netCurrent)
D26Total Assets less CL331804.7775gl-cor:amount (pubBS.totalAssetsLessCL)
D28Other Creditors0gl-cor:amount (pubBS.otherCred)
D29Directors Loan1891132accounts.liabilities.2500 (pubBS)
Stock
CellDIY LabelValuediya-gl mapping
B5Opening Stock10000accounts.assets.1100 (opening)
B8Closing Stock6000accounts.assets.1100 (closing)
TrialBalance
CellDIY LabelValuediya-gl mapping
EJ91Audit Accuracy Check-1782472gl-cor:amount (trialBalanceCheck)

Tax review

Corporation Tax (CT600)

Amount
Operating Profit276,191.08
    Add back: Depreciation279,191.08
    Less: Capital Allowances279,191.08
Profit Chargeable to CT279,191.08
Corporation Tax53,046.31
Tax Outstanding53,046.31