Für QuickBooks Online
Export invoices from QuickBooks Online, upload your call and lead records beside them, and see revenue by channel — from the ledger rather than from a guess.
Kein API-Schlüssel Nichts in QuickBooks Online zu installierenNichts zu installieren Keine Karte nötigOhne Karte
CloseRev reads a QuickBooks Online export of invoices or sales receipts — the customer's email or phone, the amount and the date — and matches it against your call log and lead records. It exists for the very common business whose closed sales were never in a CRM at all: the sale was an invoice, and the invoice is the only place it is written down. Invoices that match no lead are reported as Direct / Unknown rather than shared out across channels.
Zuletzt am 24. September 2026 anhand der eigenen Dokumentation von QuickBooks Online geprüft.
Die Lücke
Every closed sale you have is in QuickBooks. Not one of them says where the customer came from, and nobody is going back through two years of invoices to write it in.
Was verkauft wurde, an wen und für wie viel.
Der Klick, das Keyword, der Anruf und was jedes davon gekostet hat.
Die Datei
Drei Dinge tragen die Zuordnung: wer, wie viel und wann. Alles andere ist optional und ändert nur, wie sich der Bericht aufschlüsseln lässt.
On the customer record the invoice is billed to rather than on the invoice itself. This is the join key, and it is the field most likely to be blank on older customers.
The amount line of the transaction. Use the total actually billed rather than what was quoted.
Either works and they answer different questions — billed date tells you when the work was won, payment date when the money arrived.
Whatever you already use to separate lines of business. It becomes a cut of the report and nothing breaks without it.
Schritt für Schritt
Geschrieben für alle, die QuickBooks Online im Nachbar-Tab geöffnet haben. Berichtsnamen unterscheiden sich je nach Edition, deshalb sagt jeder Schritt, wonach Sie suchen.
You want one row per invoice carrying a customer contact detail, an amount and a date. A transaction or invoice list report exports to CSV or Excel; what matters is that the customer column is there, not which report produced it.
This is the step that decides whether the whole exercise works. QuickBooks does not require an email or phone on a customer, so a file exported from an older company can be half blank — look at the column before you upload rather than after.
From call tracking, a web form, an ad platform's lead export, or a spreadsheet somebody keeps. It needs the same phone or email, plus where the lead came from.
The lead precedes the invoice, sometimes by months. A sales file that starts where the lead file starts will miss the revenue that lead produced.
The join is the phone or the email, normalised on both sides. Exact matches count automatically; anything weaker is put in front of a person.
Was zurückkommt
Umsatz nach Kanal, die Zahl der Verkäufe hinter jedem Wert und eine ehrliche Kategorie für alles, was niemand zuordnen konnte. Beispielzahlen aus dem durchgerechneten Beispiel der Seite Steuerberatungs- und Wirtschaftsprüfungskanzleien – nicht aus einem QuickBooks Online-Konto.
| Kanal | Anteil | Verkäufe | Umsatz |
|---|---|---|---|
| Google Ads | 71 | $182,000 | |
| E‑Mail-Marketing | 26 | $63,000 | |
| Empfehlungspartner | 58 | $147,000 | |
| Direkt / Unbekannt | 121 | $308,000 |
Nicht zugeordnete Verkäufe bleiben unter Direkt / Unbekannt. Sie werden nie auf die bezahlten Kanäle verteilt, damit die Summe besser aussieht.
Das Argument
Attribution tools assume the closed sale lives in a CRM with a source field on it. For an enormous number of real businesses that is simply not the case: there is no CRM, there is an accountant, and the record that a sale happened is an invoice.
That is not a deficiency to be fixed before measurement can start. An invoice is a better record of a closed sale than a CRM deal is — it is the one nobody forgets to create, because it is how the business gets paid. What it lacks is any idea of where the customer came from.
So the missing half is supplied from outside rather than added to QuickBooks. Nothing about your bookkeeping changes, no field is added, and nobody has to remember to fill one in.
QuickBooks will happily keep a customer with a name and a billing address and nothing else. Businesses that grew without a CRM often have exactly that for their older customers, and the newer ones are better only because somebody started typing emails in at some point.
That gradient matters when you read the report. If contact details are thin before a certain date, the matched share will look low for older revenue, and that is a property of the file rather than of the marketing. The report separates what could not be matched from what was matched and found nothing, because those two are different facts and only one of them is about your ads.
The practical answer is usually to run the first import over a recent period where the data is good, see whether the answer is useful, and widen it afterwards.
For most businesses these are days apart and the choice does not matter. For anybody invoicing on terms, or taking deposits, or running progress billing on a long project, they are months apart and the choice changes the report.
Billed date attributes revenue to when the work was won, which is the question a marketer is asking: did the campaign that ran in March produce work? Payment date attributes it to when the money arrived, which is the question a finance lead is asking about cash.
Both are legitimate and the report does not pick for you. What it refuses to do is mix them in one column, which is how a channel appears to have produced revenue in a month it produced nothing in.
A repeat customer is the normal case in trades, professional services and anything with a maintenance agreement, and it is where naive attribution goes wrong most expensively. If somebody was produced by a paid campaign in 2024 and has invoiced every quarter since, crediting all of it to that campaign flatters it enormously.
Repeat revenue is reported separately from first revenue rather than being silently folded in. Whether the campaign that won a customer should get credit for their fourth invoice is a real business judgement — a home services firm and a law firm answer it differently — and it is not a question a tool should decide quietly on your behalf.
Three columns and an optional fourth. No chart of accounts, no bank feeds, no payroll, no vendor records, no tax detail, and nothing that would let anybody reconstruct your books from what you uploaded.
That matters more here than on most systems in this catalogue, because an accounting export is the file a business is most reasonably nervous about. The match cannot use any of it, so it is not asked for.
Berechtigte Fragen
Then the matched share will be low and the report will say so rather than quietly attribute anyway. A phone number works just as well, and many QuickBooks files have one where they have no email.
You can, and it will be accurate from the day somebody starts filling it in — for the customers they remember. This works on the invoices you already have, including the two years behind you.
The export is a report, not a change to the file. Nothing is written back and no access to the company is needed.
No. It reads a file you exported, so nothing holds a credential to your company file and nothing writes back.
Any that gives one row per invoice with the customer, the amount and the date. The exact name varies by plan and by how your file is set up, so look for the columns rather than for a particular report.
Either, and both together if you take payment at the point of sale as well as on terms. They are the same shape to the match.
Billed date if you are asking which marketing won the work; payment date if you are asking about cash. Pick one and keep it — mixing them in one file is what produces a wrong month.
That invoice cannot be matched and is reported as Direct / Unknown. It is never attributed on a name, because names are not unique and an attribution built on one is a guess.
Not silently. Repeat revenue is reported separately so you can decide whether a customer's fourth invoice should credit what won them.
Yes, on the same terms. The product differs; a file with a customer contact detail, an amount and a date does not.
Include them and they reduce the matched revenue, which is the honest figure. A channel's revenue should fall when its customers are refunded.
Yes, if you already use them. They become a cut of the report and nothing depends on them.
Further back than the lead file, because the lead comes first. Six months further is a reasonable starting point.
Three columns leave QuickBooks: a contact detail, an amount and a date. No chart of accounts, no bank feeds, no payroll, no vendors, no tax detail — the match cannot use any of it, so it is not asked for. What you upload is encrypted in transit and at rest and deleted with its import.
Revenue by channel, the share of invoices it could match, and everything it could not, kept separate rather than distributed.
Nach Branche
Wie der Bericht aussieht, sobald der Export drin ist – für jede Branche eigens geschrieben.
Andere Systeme
Mehrere Systeme im Einsatz oder im Vergleich? Die Methode ist dieselbe, die Spalten sind es nicht.
QuickBooks Online und die anderen Produktnamen und Logos auf dieser Seite gehören ihren Inhabern und dienen nur dazu, die Software zu kennzeichnen, aus der eine Datei stammt. CloseRev ist mit ihnen nicht verbunden oder von ihnen empfohlen und verbindet sich mit keinem davon: CloseRev liest eine Datei, die Sie exportieren.
Heute starten
Nichts in QuickBooks Online zu installieren, kein API-Schlüssel, und Sie müssen bisher nichts getrackt haben. Das Vorjahr funktioniert so gut wie dieser Monat.
