Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We See Clearly What Our Trading Earns Versus What Our Grants Fund?
Problems We Solve

How Do We See Clearly What Our Trading Earns Versus What Our Grants Fund?

Social enterprises lose sight of trading versus grant income when both run through one set of books. We build tracking and reports that keep them apart.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Social enterprises struggle to see whether trading covers its costs because trading income, grant income and shared costs all run through one set of books with loose coding. We set up your accounting software and a reporting layer so every income and cost line is tagged to trading or to a funded project, shared costs are split by the rules your board agrees, and the monthly view shows each clearly.

The board meeting question

Your social enterprise runs a café, a shop, a catering service or a contract cleaning business, and it also delivers funded programmes: employability support, community activity, training for people furthest from work. Some income comes from customers. Some comes from grants and trusts. Some comes from contracts with the council.

At the board meeting a trustee or director asks a straightforward question: is the café paying for itself, or is grant money quietly covering its losses? The finance manager says it is hard to tell. The accounting software shows total income and total costs, and some of the café's staff also run the training sessions that the grant pays for. The rent is shared. The manager's salary covers everything.

The board makes decisions about pricing, opening hours and whether to open a second site without being sure what the first one really earns.

Why the split is so hard to see

Social enterprises are built to blend commercial and social activity, and the admin has to follow. Most accounts packages can separate them, but only if the coding is set up and used consistently.

  • Income and costs are coded by type, such as sales, grants, wages and rent, but not by activity.
  • Staff work across trading and funded projects without their time being split.
  • Shared costs, such as premises, utilities and management, have no agreed allocation rule.
  • Trainees or supported employees work in the trading business as part of a funded programme, so their cost belongs partly to each.
  • Grants arrive in lumps that do not match the months they fund.

How costs should be allocated, and what counts as trading for your legal structure and tax position, are for your board and accountant. We do not advise on those. We make sure whatever rules they set are applied every month, not reconstructed at year end.

What a blurred picture costs

Decisions go wrong. A trading arm that looks healthy because grant-funded staff are propping it up expands into a second site that cannot pay its way. A profitable service is cut because its costs were overstated.

Funders may ask how their money was used, and whether it subsidised trading. Answering that from blended accounts is slow and uncertain.

The finance person spends days at each quarter end building a spreadsheet split that nobody else fully understands, and it is out of date by the time the board sees it.

How we set up the split

What we do is make the split part of normal bookkeeping, then report it automatically.

  1. We set up tracking categories or classes in your accounting software, such as Xero or QuickBooks, for each trading activity and each funded project.
  2. Bank rules and supplier defaults tag routine transactions automatically, so the bookkeeper tags only the unusual ones.
  3. Till and online sales flow in already tagged to the right trading activity from your EPOS or shop platform.
  4. Staff time is captured by activity through a simple timesheet, and wages are split each month using those hours.
  5. Shared costs are allocated by the rules your board agrees, such as floor area for rent or headcount for management, applied automatically each month.
  6. A monthly report shows each trading activity's income, direct costs, share of overheads and result, alongside each funded project's income and spend.
LineBeforeAfter
Café salesTotal salesCafé sales, by site
Café staffTotal wagesCafé share of wages from timesheets
RentOne figureSplit by your agreed rule
Grant incomeLump when receivedMatched to the months it funds
Trainee wagesMixed in with staffSplit between programme and trading

The report can be a dashboard or a monthly workbook, whichever your board prefers.

The next board meeting

The board pack includes a one-page summary for each trading activity and each funded project. The café covers its direct costs and part of its overheads. The catering contract does better than people assumed. The employability programme's grant is running slightly ahead of spend.

When a director asks about opening a second café, the finance manager can show what the first one earns without grant support. The discussion is about the numbers rather than about whose impression is right.

Is this your social enterprise?

  • You cannot say whether your trading arm covers its costs.
  • Staff and trainees work across trading and funded projects without their time split.
  • Shared costs have no agreed allocation rule.
  • Board reports show total income and costs only.
  • Quarter end involves a spreadsheet only one person understands.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Can you tell us how to allocate our shared costs?

No. Allocation rules are for your board and accountant. We apply the rules they set consistently and show the effect.

Do we need to change our accounting software?

Usually not. Xero and QuickBooks both support the tracking this needs. We set it up and connect the data feeding into it.

How do staff record their time?

Through a short weekly timesheet by activity, on a phone or computer. We keep it as light as your board's needs allow.

What do we need to provide?

Access to your accounting software, a list of trading activities and funded projects, and your board's rules for shared costs.

Keep reading

More on Problems We Solve

Start here

Tell us where your social enterprise's admin gets stuck

Describe how your trading and funded work are run and recorded today, and which reports or returns take the longest. We will tell you what we would build and what we would leave alone, and if your accounting software can already do it, we will show you how.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →