Module 41 · Foundation · 8 min read

One ledger, tagged by project and item of work

You will be able to: Explain what it means that one ledger carries the project and the item of work on every cost row; State what makes a project and an item of work a valid tag; Read the refusals Zeyto gives when a tag is wrong.

  • Read not done yet
  • Self-check: not taken not done yet
  • Lesson complete not done yet

Zeyto Construction & Contracting does not keep a separate set of books per project. It keeps one general ledger, and every posted cost or revenue row can carry two extra tags: the project (called a project centre in the ledger) and the item of work, which is a node of the project's breakdown. A project report is then a filter on the ledger, not a second system that must be reconciled to it.

What carries the tag

  • Purchase invoices, goods receipts, material issues, returns and write-offs, tagged on the document or on each line.
  • Journals and petty cash vouchers, tagged on each journal line.
  • Sales invoices, progress bills and VAT entries, so billing and VAT can also be read by project.
  • Payroll allocation and asset charge-out journals, which move cost onto the items they were worked on.
The Finance tab of a project showing budget, open commitments and actual cost read from the one ledger for each item of work and cost nature.

Finance tab: project cost read from the single ledger by item and nature.

Finance tab: project cost read from the single ledger by item and nature.
One supplier invoice, three viewsA supplier bills AED 8,400 for tiles plus AED 420 VAT (5%). The invoice is tagged to project P-00001, item W1.1 Floor tiling. The ledger shows debit to a project cost account AED 8,400 tagged P-00001 and W1.1, debit to input VAT AED 420, credit to payables AED 8,820. The same row feeds the general ledger, the supplier statement and the item's actual cost on the project hub. Nobody retypes it.

When Zeyto refuses a tag

Before a document posts, Zeyto checks the tag and refuses with a plain reason. The checks that matter most:

RefusalMeaningHow to fix it
Item not a leafCost can only go to an item, not to a category that groups itemsPick a sub-level item
Item belongs to another projectThe item chosen is in a different project's breakdownChange the project or the item
Project closed or cancelledA closed project takes no new costReopen through the project, or post elsewhere
Cost lockedThe posting date is on or before the project's cost lock dateUse a date after the lock, or lift the lock with authority

Cancelling a document is never blocked by these checks, because a cancel only reverses what was posted. When a tagged document is amended or cancelled, the reversal is netted per item, so two lines to two items are never blended into one.

Watch outA project can be set to allow posting without an item. Do not rely on that for control: a cost with no item shows against the project but not against any item of the budget, so it cannot be compared with a budget line.
TipDimensions must be chosen when the document is entered. Correcting a wrong item afterwards means amending or cancelling the document, which leaves a trail, not editing a ledger row.

Walk it through

  1. Take one supplier invoice and write down the project and item it belongs to before looking at the ledger.
  2. Write the three journal rows (cost, input VAT, payables) with the tags.
  3. In the demo, if you have access, open a project's Structure tab and find the item's actual cost; then find the same invoice in the Purchase Invoice register and compare the amounts.
Open the live demo

Public demo company, sign in as admin / demoAdmin123. Data refreshes nightly.

Key takeaways
  • One ledger; project and item of work are tags, not separate books.
  • Cost can only be posted to an item (a leaf) of an open project.
  • Reversals are netted per item, and a cancel is never refused by the tag checks.

Check yourself

5 questions on this lesson. Not timed, not the exam, and you can try again. Score 60% or more, and read the lesson, to complete it.

1. In Zeyto Construction & Contracting, what is the project centre of a project?

2. A supplier invoice for AED 8,400 plus 5% VAT is tagged to project P-00001 and item W1.1. What is the payables credit?

3. Which tags can a posted cost row carry in Zeyto Construction & Contracting?

Select all that apply.

4. Which checks can refuse a tagged document before it posts?

Select all that apply.

5. A project is set to allow posting without an item. What is the weakness?

Practice questions for this module · Printable study sheet