Para 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.
Sin clave de API Nada que instalar en QuickBooks OnlineNada que instalar Sin tarjeta de créditoSin tarjeta
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.
Comprobado por última vez con la documentación del propio QuickBooks Online el 24 de septiembre de 2026.
La brecha
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.
Qué se vendió, a quién y por cuánto.
El clic, la palabra clave, la llamada y cuánto costó cada uno.
El archivo
Tres cosas sostienen la coincidencia: quién, cuánto y cuándo. Todo lo demás es opcional y solo cambia cómo se puede desglosar el informe.
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.
Paso a paso
Escrito para quien tiene QuickBooks Online abierto en la pestaña de al lado. Los nombres de los informes varían según la edición, así que cada paso indica qué buscar.
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.
Lo que recibe
Ingresos por canal, el número de ventas detrás de cada cifra y un grupo honesto para las que nadie pudo rastrear. Cifras de ejemplo, del caso práctico de la página Firmas de contabilidad, no de una cuenta de QuickBooks Online.
| Canal | Proporción | Ventas | Ingresos |
|---|---|---|---|
| Google Ads | 71 | $182,000 | |
| Email marketing | 26 | $63,000 | |
| Socios de referidos | 58 | $147,000 | |
| Directo / Desconocido | 121 | $308,000 |
Las ventas sin coincidencia quedan en Directo / Desconocido. Nunca se reparten entre los canales pagados para que el total se vea mejor.
El argumento
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.
Preguntas justas
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.
Por sector
Cómo se ve el informe una vez cargada la exportación, escrito para cada uno.
Otros sistemas
¿Usa más de un sistema o está comparando? El método es el mismo; las columnas, no.
QuickBooks Online y los demás nombres de productos y logotipos de esta página pertenecen a sus propietarios y se muestran para identificar el software del que procede un archivo. CloseRev no está afiliada a ellos ni cuenta con su respaldo, y no se conecta a ninguno: lee un archivo que usted exporta.
Empiece hoy
Nada que instalar en QuickBooks Online, sin clave de API y sin necesidad de haber rastreado nada hasta ahora. El año pasado funciona igual de bien que este mes.
