Ledger & adjustments · Guide 38 of 53
Projects: tagging revenue and costs
Some businesses run on projects: contracts, jobs, campaigns, properties. Project tags on journal lines give you a P&L per project without disrupting the chart of accounts.
Project P&L is a question of where the money came from and where it went, sliced by the project it relates to. IQ Books answers it with a project tag on every journal line. The tag is independent of the account — same chart, same categories, just an extra dimension you can filter by.
When projects make sense
Projects are worth setting up when your business has discrete revenue-and-cost units that you want to evaluate independently:
- Construction: each build is a project. Material costs, labour costs, sub-contractor invoices, customer milestones — all tagged to the build.
- Property: each property is a project. Rental income, repairs, mortgage interest, agent fees — all tagged. In a landlord’s books the screen is called Properties. In a foreign property business each property also takes its Country, and a name of up to 105 characters that is different for each property in the same country, as HMRC requires.
- Agency: each client engagement is a project. Time-billed revenue, contractor costs, third-party tools — all tagged.
- Events: each event is a project.
If your business runs a single ongoing operation, projects are overkill. You don’t need them; the regular reports give you the answer.
Where to find them
Accounting → Projects lists every project on the org. New projects are created here:
- Click New project.
- Enter a name, start and target end date (optional), customer (if relevant), budget and description.
- Save. The project is immediately available as a tag option on every line of every form that asks for it (invoices, bills, manual journals, bank-draft confirms).
The budget is a cost budget: what the project may spend. What RiQ found tells you when its cost to date reaches 80% of the budget, and again once it passes it (the 80% can be changed under Settings → Automation). Cost is the costs and bills tagged to the project, plus, with Time, billables & WIP on, each person’s time at their cost rate. The notice also shows on the project’s workspace. Only active and on-hold projects are watched.
Tagging on transactions
Wherever you enter a journal line, there is an optional Project field next to the account category. Pick a project and that line is tagged to it. Lines on the same invoice or bill can have different projects (e.g. a multi-line bill where one line is for project A and another is for project B).
Sales invoices
For project-based revenue, tag the invoice line with the project it relates to. The invoice as a whole can be against a single customer with the project line tagged appropriately. Multi-line invoices can have lines tagged to different projects, useful for clients running multiple concurrent engagements.
Bills and supplier payments
Project-tagged costs work the same way. The bill posts to the right expense category, and the project tag captures which project absorbed the cost.
Bank drafts
When confirming a bank draft, the confirm form has a project field. Tag at confirm time. CodeIQ and bank rules can carry a project tag if you set one (rare but supported).
Manual journals
Adjustments and accruals tag at line level — just like everything else. Useful for end-of-period reclassifications between projects.
The Project P&L report
Reports → Project P&L produces a P&L sliced by project. Each project gets a column showing:
- Revenue tagged to it.
- Cost of sales and direct expenses tagged to it.
- Gross margin (revenue minus direct costs).
- Optional allocation of overhead, if you set up an allocation rule (e.g. allocate Office rent across projects by revenue share).
- Net contribution per project.
The report has a final “Unallocated” column for everything that wasn’t tagged. Total revenue and total expenses in the report should equal the totals on the regular P&L.
Project status and lifecycle
Choose Edit on a project row to change its working details and lifecycle. Projects have four statuses:
- Active — new transactions can be tagged to it. Default for new projects.
- On hold — remains available for deliberate tagging, labelled as on hold. Useful for work that has paused but may still receive a late cost.
- Completed — doesn’t appear in the project dropdown for new transactions, but historical tags remain. Useful for closed engagements.
- Cancelled — also blocks new tagging while preserving everything already attributed to the project.
You can move a project between statuses at any time. Completed and cancelled projects can be reopened by editing them back to Active. The server applies the same rule even if a transaction is created outside the visible picker, so a stale project ID cannot slip onto a new line.
For a project you no longer want in the live workspace, choose Archive. Archive hides it from normal lists and every new-document picker without removing its historic invoice and bill lines or its Project P&L. Turn on Show archived to review it, then choose Restore if work resumes. Edit, status changes, archive and restore are all recorded in the audit log.
Projects vs. classes vs. tracking categories
If you’ve come from QuickBooks or Xero Projects, an IQ Books project is the same job-level home for revenue and cost. With the optional Time, billables & WIP feature it also owns tasks, people, time, recoverable costs and project invoicing. The project tag remains one reporting dimension per line; it is deliberately not a general multi-axis tracking system.
Related guides
Setting Up a Project and Its Budget
Creating a project takes a few seconds and changes nothing in your ledger — it simply gives you a label to attach to invoice and bill lines later. Each field on the form has a job to do:
- Open Projects and choose New project. This is where every job, contract, campaign or property you want a separate profit figure for lives.
- Give it a name. The name must be unique within the organisation — if you try to reuse one, IQ Books refuses it. When you run similar jobs year after year, add a year or job code so they stay apart, for example ‘Rosewood Kitchen 2026’.
- Link a customer (optional). Tying the project to the customer you’re billing keeps the job and its paperwork together and makes it obvious who the work is for.
- Choose a status. Active, completed, on hold or cancelled — this is a label to keep your project list organised; it doesn’t change any figures.
- Set start and end dates (optional). These record the window the job runs over and give you a sensible period to use later on the report.
- Enter a budget. Put in the figure you quoted or expect. It sits alongside the actuals on the Project P&L so you can see at a glance whether the job is tracking to plan. It’s a planning number only — adjust it whenever the scope changes.
Nothing is posted when you save. The project is now ready to attach to the lines of any sales invoice or supplier bill.
Costing a Job From Start to Finish
A worked example makes the flow clear. Say you’re fitting a kitchen you quoted at £12,000, and you created a project called ‘Rosewood Kitchen’ with a target net profit of £4,500.
- Raise and issue the sales invoice. Create a normal sales invoice to the customer. On each line, pick the income account as usual and set the project to Rosewood Kitchen. Issue it — that’s the £12,000 of revenue tagged to the job.
- Enter your supplier bills, tagged as you go. As the units (£4,200) and the fitter’s labour (£3,000) come in, enter each as a supplier bill and set the project on each cost line. Issue each bill so it counts.
- Split mixed documents line by line. Tagging is per line, not per document, so a single bill covering two jobs can send some lines to one project and some to another. Any line you leave untagged still hits your normal P&L — it just won’t appear against a project.
- Open the Projects P&L and set the period. Choose a start and end date that covers the job’s dates.
- Read the result. You’ll see revenue £12,000, costs £7,200 and net profit £4,800, with your £4,500 budget beside it — so the job came in £300 ahead of plan.
Why a Sale or Cost Is Missing From Your Project P&L
The Project P&L is built purely from the invoice and bill lines you’ve tagged, and it only counts documents that have actually hit the ledger. If an expected figure isn’t there, it’s almost always one of these:
- It’s still a draft or a quote. Only issued, part-paid and fully paid invoices and bills are counted. A draft invoice, an unissued bill or a quote stays invisible until you issue it.
- It was voided. Voided documents drop out of the figures entirely.
- A credit note is netting it down. Credit notes tagged to the project reduce the revenue or cost — that’s expected, not a fault.
- The line simply wasn’t tagged. Open the document and set the project on the line in question. Until then the amount lands on your normal P&L but never on a project.
- The cost was paid straight from the bank or posted as a manual journal. The report reads invoice and bill lines only, so a bank payment you categorised directly, or a manual adjustment, won’t appear against the project. If you need that cost captured on the job, enter it as a supplier bill and tag the line.
Keep the scope in mind: projects in IQ Books are a lightweight tagging layer to give you a profit-per-job view. There’s no time tracking, no work-in-progress valuation, and you can’t bill a customer straight from a project — you always raise an ordinary invoice and tag it.
Fixing a Mis-Tagged Line and Other Common Questions
- I tagged the wrong project. The tag lives on the invoice or bill line, so fix it there rather than on the ledger. Open the document and change the project on the line. For an issued invoice or bill with nothing paid against it yet, IQ Books reverses the old entry and reposts the corrected one under the same number. Once a document is part-paid or paid you can’t change the figures in place — raise a credit note, or void and re-raise, to move the amount to the right job.
- Can I put more than one project on a single invoice? Yes. Tag each line separately, and one invoice or bill can be spread across several jobs.
- It says the name is already taken. Project names are unique per organisation. Add a year, a phase number or a job code to tell two similar jobs apart.
- It won’t let me tag an old, closed-off project. Once a project is archived you can’t attach new lines to it. Set it back to active, tag the late invoice or bill, then archive it again.