Marketing Spend the Finance System Can See: Closing the Loop from Invoice to Pipeline.

Ask the marketing lead what was spent on paid search last month and the answer comes from a spreadsheet. Ask the finance chief and the answer comes from the ledger, and the two numbers differ, usually by the agency fee, a tool licence and a timing difference nobody can explain in the meeting. Both numbers are right in their own building. The loop between them has never been closed. This video is the spend side of a table we built in the previous piece: cost per qualified conversation, by channel, from recorded facts.

The pipeline side lives in the sales system. The spend side lives in the finance system already. The work is getting the finance system to say which channel and which month each invoice bought. Everything on screen is a mock demo with sample data: a mock Zoho Books bill, a mock Zoho CRM lead, invented figures. Here is the loop as it usually stands. On the left, the sales system: leads arrive with a source, paid search, email, an event, and a salesperson sets the status that makes one a qualified conversation.

On the right, the finance system: bills arrive from the ad platform, the agency and the software vendors, they are coded to a marketing expense account, approved and paid. Between them, nothing. The bill does not say it bought paid search in September. The lead does not know what was paid for it. So marketing keeps a spreadsheet of spend by channel that finance never sees, finance keeps a ledger line called marketing that marketing cannot break down, and the number the board is shown, cost per qualified conversation, is assembled by hand once a quarter from both, and argued about.

Marketing spend hides in three places in a finance system, and each one breaks the join differently. The first is the platform invoice. The ad platform bills monthly, sometimes mid-month on a threshold, for several campaigns at once, so one bill is three channels and two months unless somebody splits it. The second is the agency or the contractor. One monthly fee covers paid search management, two blog posts and a design day, coded to one line. The third is the tool. The automation platform, the analytics subscription, the design licence, billed annually, sitting in software rather than marketing, and never counted against the channels they serve.

Add them up and the ledger's marketing line is at once too small, because the tools are elsewhere, and too blunt, because nothing in it says which channel. The platform's own spend report fills the gap in most companies, and finance does not trust it, correctly, because it is the vendor grading its own homework. The fix is one discipline at the door of the finance system, the same discipline the attribution piece put at the door of the sales system. Every marketing bill, when it is entered, carries two things: the channel it bought, and the month it bought it for.

A platform bill that covers three campaigns is entered as three lines, one per channel. An agency fee is split at the lines the agency already itemises. A tool licence is tagged with the channel it serves, or with a line called shared, which is honest. In Zoho Books that is a reporting tag on the bill line and the bill date set to the service month, which takes the person entering it about a minute more than it takes today. The expense account does not change; finance's ledger is untouched.

What changes is that the ledger can now answer the question by channel, from its own records, and the marketing spreadsheet has nothing left to hold. Now the test that turns a marketing figure into a finance figure. Sum the tagged lines for September across every channel, and the total must equal the ledger's marketing expense for September, plus the tool licences wherever they sit. If it does not, something was entered without a tag, and the difference is a reconciling item: a list of bills to fix, not an argument about a model.

That is the whole difference between this and a dashboard. A dashboard shows spend by channel from the platform's report and nobody can tie it to the ledger. This table ties to the ledger to the dollar, because it is the ledger, grouped a second way. When the finance chief asks where the forty-two thousand went, every row traces to a bill she has already approved. With the tag on the bill and the source on the lead, the report that closes the loop is one query over two systems: for each channel and month, the spend from the tagged bills, the leads created and the qualified conversations from the sales system, and the division.

In the Zoho suite that is a report in Zoho Analytics reading Zoho Books and Zoho CRM, or a small spend table synced into the sales system if the company prefers one screen; either way nobody exports anything. Finance runs it, because the numbers are theirs. Marketing reads it, because the decisions are theirs. And the quarterly argument about whether paid search is worth it becomes a row: this much spend, this many conversations a person vouched for, this cost per conversation against the revenue those conversations later produced. We run our own marketing on this report, and the spend line in our weekly summary is read from the bills, not from the platform.

The spend is already in the finance system. The pipeline is already in the sales system. Closing the loop is a tag on every marketing bill and a source on every lead, and then a report that reads both. The lead side is in the previous video, the attribution table the finance chief signs; this is the invoice side, and together they are the marketing measurement a controller can audit. We are CodeStringers, a Zoho authorised consulting partner. Discovery is no-risk: we tag one month of bills with you, build the report, and you pay only if you go ahead.

The series is linked below.