← Back to Cuadre

Guide · updated November 18, 2026

A crypto payment Excel your accountant can defend in a review

Your accountant does not argue that you got paid: they argue about which number goes in the books. A file with thirteen columns in the right place closes the month in an afternoon; a list of hashes in a chat turns it into three days of questions.

The problem is not the file, it is what the file is missing

Exporting something from your exchange at month-end is not enough: which invoice it was, how much was invoiced and at what price the money came in are all missing. What is left is a token amount, a date and an alias that does not match the client, and with that your accountant does not book, they guess. The fix is not a prettier PDF: one row per invoice, source data next to closing data, and the evidence linked.

The five things your accountant needs from every payment

Without the fourth the entry fails the review; without the fifth it fails the audit.

The 13 columns in Cuadre's Excel

It comes from the same database as the PDF receipt, so nothing gets retyped. One row per invoice, quoted values, UTF-8:

Invoiced and arrival value are separate on purpose: an ETH invoice can close paid in tokens while its dollar value is lower because the price moved. The file shows both numbers.

The five states, and why they matter in the file

State comes from tokens received versus tokens expected, with a 99% floor and a 105% ceiling:

Without a state column everything looks like collected revenue: that is where phantom income from expired invoices comes from.

Three things that break the close even when the Excel is perfect

Checklist before you send the file

With those five answers the close gets signed. Without the last one it is a wish list.

Frequently asked questions

Does the Excel have one row per payment or per invoice?

One per invoice. If the client pays in two parts the row stays the same: received goes up and the state moves to partial and then to paid, so your accountant sees the whole case.

Is the booked amount the invoiced one or the arrival one?

Both, in separate columns: monto_usd is invoiced, valor_usd_arribo is what the token was worth when the payment landed. Neither is rewritten into the other.

Why keep the hash column if the amount is already there?

So the evidence does not rest on your word: with hash and network anyone can open the explorer and check amount, time and counterparty. It is the same hash printed on the PDF receipt.

Can a hand-built Excel sheet do the job?

For a one-off cleanup, not for a monthly close: it goes stale with the first partial payment and records no price source. The exported file comes from the same data as the receipt.

If you want the system to do this

Cuadre does that on its own — invoice, address, matching, price with source and time, receipt and Excel with these columns — for US$29/month, US$24 for life for the first 10 accounts.

Reserve founder seat · US$24 See pricing in detail

Read next: how to reconcile USDC payments against your invoices · which USD rate applies when a client pays in crypto · one deposit address per invoice · what reconciliation costs at Request Finance.