Consultant Expense Tracker

The consultant’s actual problem: costs that belong to a client

You already know roughly where your money goes. That isn’t the question. The question is which of these costs belongs to Acme, which belongs to the pitch you lost in March, and which is just the cost of being in business.

Two failures come out of not answering that question. The first is re-billable costs that never make it onto an invoice — a $340 flight from six weeks ago that nobody remembered when the invoice went out. The second is quieter and worse: engagements that look profitable until travel is counted. A fixed-fee project at a good day rate can end up margin-thin because you were on site four days a week and never attributed the cost to it.

Tag every cost to the engagement it belongs to

This is the whole mechanism, and it is deliberately simple. In ExpenseBot you create tags under Expense Tags, using a prefix convention the system recognises — Client – Acme, Project – Website Redesign. The separator is an en-dash with a space on each side. Then you assign them any of three ways:

• From the Tag column in your sheet, via the dropdown
• By selecting a tag when you photograph a receipt
• By writing tag:Acme directly on the receipt before you send it

ExpenseBot’s AI also suggests tags overnight by grouping related spending, but it cannot know which client a cost was for — that part is a judgement only you can make, and the product says so rather than guessing. Two seconds per expense at capture time is what buys you the per-engagement view; retrofitting it in April is the expensive version.

The profit by client page covers the reporting side of tags in full — this page is the consulting-shaped view of the same machinery.

Travel to client sites, without the shoebox

Travel is the bulk of a consultant’s re-billables and the category most often lost. Flights, hotels, rail, parking, client-site mileage, meals on a long day away — and almost none of it arrives as paper. It arrives as a confirmation email.

That is what makes it tractable. Connect Gmail once and ExpenseBot reads those confirmations into your sheet on a nightly scan — vendor, date and amount — where you tag them to the engagement. It labels what it has read so nothing is double-counted, never sends email on your behalf, and never deletes anything. That is spend capture: the receipts that already exist stop being something you have to chase yourself for.

Driving between client sites is deductible mileage, with rules worth knowing before you log a year of trips — see which miles actually count rather than assuming the drive from home to a client counts as business travel. It often doesn’t.

Re-billable vs absorbed — getting the boundary right

The boundary is contractual, not a tax question. Your engagement letter says what you can pass through; everything else you eat. Business development travel, proposal costs and pitches that didn’t land are absorbed — they are real business expenses and still deductible, they just aren’t the client’s.

If the invoicing side is what you are actually looking for, that is a different job and has its own page: billing a client for expenses.

Profit per engagement

Because income is tracked alongside expenses, tagging both sides with the same client prefix gives you a per-engagement picture. Ask the chat for per-tag P&L or profit by client and you get a ranked list: income, expenses, net profit and margin for each engagement, sorted most to least profitable. Add vs last quarter and each one shows the change.

One design detail worth knowing, because it is the difference between a report you read and one you ignore: for an engagement that lost money, it shows “expenses 1.4× revenue” rather than a meaningless “−40% margin”. You see the severity without decoding it.

This is a record of what has already happened. It does not forecast, project, or build a budget, and it is not trying to. The head term for this belongs to profit by client — read that one for the full reporting picture across clients, projects and properties.

What a consultant’s sheet looks like after a month

Illustrative round numbers — two live engagements, one proposal that went nowhere, one conference:

$1,740 is re-billable and needs to reach an invoice. $410 is the cost of trying. $690 is the cost of being in business. Against a fixed fee, Project – Redesign is carrying $560 of cost that a day-rate calculation never showed you — which is precisely the number that decides whether you quote the same way next time.

Deductions consultants commonly miss

• Professional indemnity insurance — an overhead so routine it stops being noticed
• Memberships and accreditation — institute fees, certification renewals
• Subcontractor payments — associates you bring onto an engagement; depending on amount and country these may create a reporting obligation, so check before year end
• Research and data subscriptions — the ones bought for one project and quietly renewed for three years. See whether software subscriptions are deductible.
• Coworking day passes near client sites, which rarely feel like an expense at the time

The pattern in that list is that none of them are large individually and all of them arrive by email. That is the case for capture rather than discipline. Related: the expense sheet, Gmail receipts into Google Sheets, and if you have grown past working solo, the agency expense tracker.

Estimates — confirm with your tax professional.