“Our bookkeeper will not give marketing the ledger.”
They do not have to. What leaves is a contact detail, an amount and a date — no accounts, no bank data, no payroll. It is a report, not the file.
For Xero
Export sales invoices, upload your lead and call records beside them, and rank channels on the revenue you actually billed.
CloseRev reads a Xero export of sales invoices — the contact's email or phone, the amount and the date — and matches it against the calls and leads recorded elsewhere. It answers which marketing produced the work you billed, for a business whose ledger is the only complete record of what it sold. Invoices with no matching lead stay in Direct / Unknown rather than being credited to whichever campaign was running.
Page updated September 24, 2026.
The gap
The ledger is complete and the story is missing. You can tell anyone exactly what you invoiced last quarter and nothing at all about which marketing caused it.
What was sold, to whom, and for how much.
The click, the keyword, the call, and what each one cost.
The file
Three things carry the match: who, how much, and when. Anything else is optional and only changes how the report can be sliced.
On the Xero contact the invoice is raised against. Contacts created by an import or by a connected app are the ones most likely to be missing it.
The billed amount. Gross or net both work as long as the file is consistent — mixing them understates some channels and not others.
The date the invoice was raised. Where you bill in stages, this is the date of the stage rather than of the job.
Whatever you already track by — branch, service line, team. It becomes a cut of the report if it is in the file.
Step by step
Written for somebody with Xero open in the next tab. Report names vary by edition, so each step says what to look for.
One row per invoice, carrying a contact detail, an amount and a date. Xero's invoice reporting exports to CSV and Excel; the column that matters is the contact's email or phone rather than the contact's name.
Whichever you pick, keep it for the whole file. A file that mixes tax-inclusive and tax-exclusive rows makes one channel look better than another for a reason that has nothing to do with marketing.
Call tracking, a form handler, an ad platform's lead download, or a spreadsheet. It needs the same contact detail and where the lead came from.
The lead happens first. Start the invoice file earlier than the lead file or you will miss the revenue those leads produced.
The match runs on the email and the phone, normalized on both sides, and reports what it could not place instead of spreading it.
What comes back
Revenue by channel, the count of sales behind each figure, and an honest bucket for the ones nobody could trace. Sample figures, from the worked example on the Accounting Firms page — not from a Xero account.
| Channel | Share | Sales | Revenue |
|---|---|---|---|
| Google Ads | 71 | $182,000 | |
| Email marketing | 26 | $63,000 | |
| Referral partners | 58 | $147,000 | |
| Direct / Unknown | 121 | $308,000 |
Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.
The argument
Xero is unusually good at being the full record. Bank feeds mean almost nothing is missed, reconciliation means the numbers are checked, and for a small business the sales ledger is very often the single most reliable dataset it owns.
It is also, for marketing purposes, mute. An invoice records that somebody bought, what for and for how much. Nothing in it says the customer arrived from a search advertisement in March, and nothing ever will, because that is not what an accounting system is for.
Which makes the pairing straightforward: the most reliable record of revenue a business has, joined to the record of where its inquiries came from. Neither system is modified and neither has to learn about the other.
Xero files routinely carry both, depending on how each invoice was raised and which template produced it. In a ledger this is unremarkable and correctly handled. In a channel comparison it is a distortion, because it does not fall evenly.
If one line of business is billed one way and another the other way, and the two are produced by different campaigns, the ranking changes for a reason that has nothing to do with advertising. Deciding once, at export, costs nothing and removes the whole problem.
The report will not silently normalize it, because it cannot know which convention you meant. It will show what the file said.
Anybody invoicing in stages — builders, consultancies, agencies on retainer, anyone taking a deposit — has one won job appearing as three or four invoices over several months.
That is right for accounting and misleading for attribution if each invoice is read as a separate win. The job was won once, by one thing. Every stage invoice carries the same contact, so all of them credit the channel that produced the customer; the sales count will still show four rows, so read the revenue rather than the count, or export one row per job.
Most Xero files have contacts from several sources: typed in by hand, imported once from a spreadsheet, and created automatically by whatever else is connected — a point of sale, a job system, a payment processor.
The automatic ones are where contact details go missing, because the connected app only passes what it has. The result is a file where recent invoices match well and a particular slice of older ones does not, and the pattern looks like a marketing finding when it is a plumbing one.
The report keeps unmatched rows visible for exactly this reason. A matched share that jumps at a particular date is usually telling you when something changed in the file rather than when something changed in the market.
Fair questions
They do not have to. What leaves is a contact detail, an amount and a date — no accounts, no bank data, no payroll. It is a report, not the file.
That is normal: every stage invoice carries the same contact, so all of them credit the channel that won the job. Each still counts as a row in the sales count, so judge the channel on revenue.
Then use it: map it as Product / service or as Location and it becomes a cut of the report beside the channel ranking.
No. It reads a file you exported, so no credential to your organization is held and nothing is written back.
One row per sales invoice with the contact's email or phone, the amount and the date. Look for those columns rather than for a particular report name.
Either, consistently. Mixing tax-inclusive and tax-exclusive rows in one file distorts the comparison between channels.
Include them. They reduce a channel's revenue, which is the honest figure when its customers are credited.
No. All four invoices carry the same contact and credit the same channel, so the revenue is right; the sales count shows four rows, so read revenue rather than count.
That invoice is reported as Direct / Unknown. It is never matched on a company name, because names are not unique.
Yes, if the export carries them. They become a cut of the report.
Upload one currency per dataset. Currency is set per dataset rather than globally, so several organizations can each be read in their own.
Further than the lead file. The lead precedes the invoice, often by months in project work.
A contact detail, an amount and a date, and a tracking category if you include one. No accounts, no bank feeds, no payroll, no reconciliations. Uploads are encrypted in transit and at rest, isolated to your workspace, and removed with the import.
Yes, and it has its own page. Both are ledgers with the same three columns in them.
Revenue by channel from billed invoices, the share that could be matched, and everything that could not, kept separate.
By trade
What the report looks like once the export is in, written for each one.
Other systems
Running more than one system, or comparing? The method is the same and the columns are not.
Xero and the other product names and logos on this page belong to their owners and are shown to identify the software a file comes from. CloseRev is not affiliated with or endorsed by them, and connects to none of them: it reads a file you export.
From the blog
The export is the part of an attribution project that everyone treats as trivial and that determines whether the whole thing works. Here is the field list, the date-range trap, the deduplication rule, and the six columns to leave out on purpose.
Read the articleEvery attribution vendor quotes a match rate and none of them define it the same way. Here is what the number actually measures, what range is honest for a mid-market business, and the three ways the figure gets inflated before it reaches your slide.
Read the articleThe channel with the cheapest leads is often the one whose leads almost never buy. Lead conversion rate by source divides the new customers each channel produced by the real, deduplicated leads it sent, counted by the month the lead arrived. Here is the formula, what to take out of the denominator, why small counts lie, how revenue per lead and cost per customer follow from it, and a five-channel worked example.
Read the articleStart today
Nothing to install in Xero, no API key, and no need to have been tracking anything until now. Last year works as well as this month.