Project-Based Accounting: How to Make Every Dollar Know Its Project

"Money often gets mixed together. Somewhere we're waiting for a payment, but we need to make a booking — so we take money from another project, then try to record it somehow, but you can never record everything."

— Olena, co-owner of a full-cycle event agency

You know this story. On Monday you took ₴30,000 from client A's payment to cover an urgent invoice on project B. You'll pay it back on Tuesday — you promised yourself. On Wednesday the team's payroll came due, on Thursday there was an unexpected deposit refund, and on Friday client A asks you to finalize the estimate.

You open Excel and can't figure it out: how much is actually left in project A's budget? How much did project B earn? Where did the 30 thousand go?

If you have even 2 parallel projects — this article is for you. We'll break down how to set up accounting so that every dollar knows its project, and you can see the budget balance in real time — without superhuman effort.

TL;DR — what you'll get from this guide

• ✅ An understanding of how project-based accounting differs from regular bookkeeping
• ✅ A 5-step system that works from the first week
• ✅ A ready-made template of categories + tags for a service business
• ✅ A real case: how an event agency with 30+ parallel bookings brought order to its finances
• ✅ A list of the money that usually "dissolves" — and how to return it to the right project

Why Excel isn't project accounting — it's the illusion of accounting

In 9 out of 10 small businesses, project accounting looks like this: a separate tab for each project in Google Sheets, plus a summary table "for the whole business". In theory — a system. In practice — an hour-long "who paid what and where" session every evening.

Excel loses for three reasons:

1. One payment = one project. Always. Excel can't split. But reality can. An accountant serves 3 projects, office rent covers 5, the CRM subscription covers the whole business. You either assign the entire invoice to one project (lying to yourself about margin), or you type 5 rows by hand and pray the total adds up.

2. The budget balance doesn't update on its own. On Monday you planned ₴100,000 for a project. By Friday you spent ₴47,000. How much is left? In the spreadsheet — ₴53,000. In reality — ₴38,000, because you forgot to record 2 cash payments to couriers and one bank fee. The illusion of control is worse than having none.

3. The team can't enter data without chaos. You gave a manager access to the main table — they broke a formula. You made a separate template — they filled it in wrong. You created a form — it collects garbage. The bottom line: you enter everything yourself, in the evenings, with mistakes.

💡 Insight: project accounting isn't "more columns in Excel". It's a different data model, where a single transaction can belong to several projects in different proportions, and the budget balance is recalculated every minute.

The 5-step project accounting system

Step 1. Define what a "project" means for you specifically

This isn't rhetoric — it's the most important decision in your accounting.

A project = the unit you want to view a separate P&L for.

Examples:

• 🎪 Event agency: one wedding = one project. Not "the entire weddings line" — too broad.
• 🏗️ Construction: one site = one project. Not "all renovations" — you won't spot the loss-making ones.
• 💼 Agency: one client or one retainer contract = one project.
• 🌷 Flower shop: projects aren't needed — that's inventory accounting. Categories are enough.
• 🎗️ NGO: one targeted campaign = one project. Especially important for donor reporting.

Rule of thumb: if you can't say "the project closed profitably" or "the project is at a loss" — it's not a project, it's a line of business. Rework it.

Step 2. Split expenses into 3 types

Not all expenses are equal. Here's a classification that saves hours of confusion:

⚠️ The most common mistake is charging office rent to projects. Then every project shows a "red margin", and you can't tell whether the business is profitable at all. Keep overhead separate — you'll see the real margin of your projects.

Step 3. Set up the structure in Finmap (15 minutes)

This is where the tool comes into play. Let's look at the example of an event agency:

Categories (this is a universal expense structure — like rubrics):

• Income: Client payment, Prepayment, Post-payment
• Expenses: Venue, Catering, Decor, Team, Marketing, Overhead

Projects (these are specific orders):

• Ivanov Wedding 12.07
• Petrenko Anniversary 28.07
• Acme Corp Corporate Event 15.08
• Sofia's Kids Birthday 02.09

Tags (these are additional dimensions — for analytics):

• Event type: wedding / corporate / kids
• Location: Kyiv / Lviv / off-site
• Season: high / low

🎯 The categories × projects × tags structure gives you 3D analytics. You can ask: "How much did we earn on weddings in Lviv during high season?" — and get the answer in 2 seconds.

Step 4. Split payments as you enter them

This is the feature that breaks the whole Excel model.

Case: you pay a freelance photographer ₴18,000 for a week's work. He shot at two weddings.

❌ In Excel — you either put all ₴18,000 on one wedding, or make 2 rows by hand, or give up and dump it into overhead.

✅ In Finmap — one transaction, the "Split" button, two projects: ₴10,000 to the Ivanovs, ₴8,000 to the Petrenkos. The total reconciles automatically, each project sees its share, and the margin is truthful.

💡 You can split not only by projects but also by categories. A big hypermarket receipt — part of it you record as "Decor", part as "Team (food for the shoot day)". Realistic.

Step 5. Watch the project budget in real time

For each project in Finmap you set a plan: expected income + expense budget. After that — the system does the math itself.

On the project dashboard you can see:

• How much the client has already paid / how much they still owe
• How much of the budget you've spent / how much is left
• The projected margin at the current spending pace
• "Red zones" — categories where you've overspent

This is exactly the moment when you stop getting confused. Not "I'll open Excel on Friday and count" — but you open the dashboard in 5 seconds between calls.

Real case: an event agency with 30+ parallel projects

Olena (name changed) owns a full-cycle event agency. Before switching to Finmap:

• 📉 Up to 30 active projects at different stages (inquiry → prepayment → work → post-payment)
• 📉 5 people on the finance team, each keeping their own Google Sheet
• 📉 Money "got mixed up" — they took from one project, promised to return it from another, didn't return it
• 📉 Project managers had no access to finances — they asked Olena
• 📉 Once a month — a full reconciliation that took 2 days

What changed after the switch:

What Olena did:

1. Set up roles: project managers see only their own projects, not the overall business
2. Connected a sole proprietorship and a European company in one account — and saw the real profit of the entire business
3. Set up a Telegram bot for cash expenses — managers enter them without logging into the system
4. Set up auto-rules that categorize 80% of transactions automatically

"Clear. A hundred percent clear." — Olena's final reaction to the demo. And that's exactly how accounting should sound: clear.

Checklist: are you ready for project accounting?

Put a ✅ next to each item you can do in 30 minutes:

• ☐ Wrote out 5-10 active projects with specific names and deadlines
• ☐ Split expenses into direct / shared / overhead
• ☐ Created universal categories (10-15, no more)
• ☐ Know which period you're planning the budget for (week / month / project duration)
• ☐ Decided who on the team will have access, and to what exactly
• ☐ Ready to invest 2-3 hours at the start to save days later

If you have 5+ checkmarks — jump into Finmap and get started. The first project takes 20 minutes, and after that — faster than making a coffee.

What's next

If you've nodded even once by this point — it's time to try.

📌 Sign up for Finmap → create your first project → enter 5 transactions with splitting → look at the margin. All together — 25 minutes. If it doesn't click — you've lost nothing.

Try free for 14 days →

This article is based on real consultations with Finmap clients. All names and figures in the cases have been changed.

Read also

• How to Read a P&L Report — And Why Most Owners Miss the Real Signal
• Client Profitability: How to Find the 20% of Clients Who Actually Generate 80% of Your Profit
• Business Cash vs Personal Cash: How to Separate Them Cleanly (Even If You're a FOP)