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.
Sem chave de API Nada para instalar no QuickBooks OnlineNada para instalar Sem cartão de créditoSem cartão
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.
Verificado pela última vez na documentação do próprio QuickBooks Online em 24 de setembro de 2026.
A lacuna
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.
O que foi vendido, para quem e por quanto.
O clique, a palavra-chave, a ligação e quanto cada um custou.
O arquivo
Três coisas sustentam a correspondência: quem, quanto e quando. O resto é opcional e só muda como o relatório pode ser detalhado.
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.
Passo a passo
Escrito para quem está com o QuickBooks Online aberto na aba ao lado. Os nomes dos relatórios variam conforme a edição, então cada passo diz o que procurar.
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.
O que você recebe
Receita por canal, a quantidade de vendas por trás de cada número e uma categoria honesta para as que ninguém conseguiu rastrear. Números de exemplo, do caso prático da página Escritórios de contabilidade — não de uma conta do QuickBooks Online.
| Canal | Parcela | Vendas | Receita |
|---|---|---|---|
| Google Ads | 71 | $182,000 | |
| E‑mail marketing | 26 | $63,000 | |
| Parceiros de indicação | 58 | $147,000 | |
| Direto / Desconhecido | 121 | $308,000 |
Vendas sem correspondência ficam em Direto / Desconhecido. Nunca são distribuídas entre os canais pagos para melhorar o total.
O 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.
Perguntas 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 setor
Como fica o relatório depois que a exportação entra, escrito para cada um.
Outros sistemas
Usa mais de um sistema ou está comparando? O método é o mesmo; as colunas, não.
QuickBooks Online e os demais nomes de produtos e logotipos desta página pertencem aos seus donos e aparecem para identificar o software de onde vem um arquivo. A CloseRev não é afiliada a eles nem endossada por eles, e não se conecta a nenhum: ela lê um arquivo que você exporta.
Comece hoje
Nada para instalar no QuickBooks Online, sem chave de API e sem precisar ter rastreado nada até agora. O ano passado funciona tão bem quanto este mês.
