Spreadsheet: 868166d1714919583-mapping-formula-help-test1
Sheet: ACT24

Test |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 months
Profit & Loss Account |  | 2024 |  |  |  |  |  |  |  |  |  |  |  |  | Act 23 | Act 22 | Act 21 | Act 20 | Act 19 | Act18 |  | Month | YTD | proj 19 | proj 18
 |  | Actual | Actual | Actual | Projections | Projections | Projections | Projections | Projections | Projections | Projections | Projections | Projections
 |  | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | Total |  |  |  |  |  | Total
 |  | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ |  |  |  | £ | £
Turnover
Management & Supervision |  | 78353.04000000001 | 153139.39 | all TB TUR001 populates here |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR001
Forest Planning & FSC Certification |  | 1250 | 4265 | etc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR002
Restock Planting |  | 0 | 0 | etc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR003
New Planting |  | 6652.8 | 9690.3 | etc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR004
Establishment, Maintenance & Protection |  | 0 | 0 | etc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR005
Cost+ Tender Contracts |  | 525664.8910000001 |  | etc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR006
Commission on Sales |  | 562 | 0 | etc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR007
Tree Safety & Consultancy |  | 41710.46 | 40647.92 | etc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR008
Mileage |  | 42188.39 | 7526.35 | etc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR009
Roads & New Fencing |  | 0 | 0 | etc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR010
Additional Turnover |  | 0 | 0 | etc |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3829321 |  |  |  |  | TUR011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2746563
Cost of Sales
Purchases |  | 997.46 | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COS001
Restocking |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COS002
New Planting |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COS003
Establishment, Maintenance & Protection |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | COS004
Cost+ Tender Contracts |  | 345222.4899999999 | 636836.4099999999 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | COS005
Roads & New Fencing |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COS006
Additional COS |  | 22015.8 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2333285 |  |  |  |  | COS007
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1373625
Gross Profit
Gross Profit
Gross Profit %
Other Income |  |  |  |  |  |  | 0