USDT statement for accounting: CSV, Excel, PDF and accounting formats
In short. In TronMesh Wallet, open History, tap Export, choose a period and a format. CSV and Excel give one line per operation: date in UTC and local time, type, debit and credit in USDT, counterparty, transaction hash with an explorer link, status. PDF is a printable statement with a summary. For accounting software there are Xero, QuickBooks Online, OFX and Koinly formats.
What an accountant needs from a USDT wallet #
A screenshot of a balance is not enough. To book USDT movements, an accountant usually asks for:
- every incoming and outgoing transfer of the period, with a date and time;
- the other party’s address;
- the amount, with fees shown separately;
- a reference that proves the operation happened: the transaction hash.
Many wallets have no export at all, and people end up downloading raw data from a blockchain explorer and cleaning it by hand. The statement export is built for exactly this job.
How to export a statement #
- Open TronMesh Wallet and switch to the wallet you need.
- On the main screen, tap History, then Export.
- In Period, pick this month, Last month (the default) or Custom with your own dates. Both days are included.
- In Format, choose a spreadsheet format, CSV, Excel (XLSX) or PDF, or an accounting format.
- Tap Export. Files download as
statement_<address>_<month>. For PDF, a statement page opens: tap Save as PDF and save it from your browser’s print window.
If the wallet cannot fetch the full history of the period, it creates no file and asks you to try again or pick a shorter period. Half a statement is worse than none. Details: export a statement.
What the columns mean #
| Column | What is in it |
|---|---|
| Date (UTC), Date (local) | When the network included the operation, in both time zones |
| Type | Received, Sent, Service fee or Self-transfer |
| Debit USDT | Money out: Sent and Service fee, as positive numbers |
| Credit USDT | Money in: Received, as a positive number |
| Counterparty | The other address |
| Tx hash, Explorer URL | The network’s ID of the operation and a link to it on Tronscan |
| Status | The operation’s status on the network |
Amounts are exact, with six decimal places. Column names and types are always in English, so a file reads the same for any accountant. A self-transfer (to your own address) moves nothing, so its amount cells are empty.
Service fee lines. When you send USDT from TronMesh Wallet, the fee goes as a separate small USDT transfer. The statement shows it as its own line, so the total debit equals what left your balance.
Which format to choose #
- CSV: the universal option for spreadsheets and import scripts. The separator follows your browser’s language: with a decimal comma it is “;”.
- Excel (XLSX): the same columns with real dates and numbers, plus a “Summary” sheet with totals. Pick it if CSV opens amounts as text.
- PDF: a printable statement with the wallet name, address, period, a summary and the table of operations. Good for attaching to a report.
Formats for accounting software #
The export screen also has a group of formats for accounting software:
- Xero: a bank-statement CSV for Accounting → Bank accounts → Import a statement.
- QuickBooks Online: a three-column CSV for Bank transactions → Upload from file. QuickBooks accepts limited uploads, so long periods may need splitting.
- OFX: the classic bank-file format read by Xero, GnuCash, Zoho Books and others. Accounting tools book only ISO currencies, so USDT is booked as US dollars; the hint on the export screen says so.
- Koinly: a CSV with exact USDT amounts and UTC dates; service fees are tagged as a cost.
The bank-style formats (Xero, QuickBooks, OFX) book amounts in cents and keep the exact amount in the description; self-transfers and dust amounts are left out of them. The export screen shows these rules in a hint under each format.
How to check a line on Tronscan #
Every line carries a transaction hash. To verify one, open its Explorer URL, or paste the hash into Tronscan. You should see the same sender, recipient, amount and time. That is how an auditor can confirm the statement without trusting the wallet. Tronscan also has its own API for TRC-20 transfers with their status (Tronscan docs), if someone wants to cross-check a whole period.
Good habits for clean books #
- One wallet per purpose. Separate wallets for clients, suppliers or projects give separate statements. See multiple wallets and a freelancer’s routine.
- Export on a fixed day. Last month, every month, before the details fade.
- Keep the files. The statement is generated in your wallet from network data; it is not a bank document and is not stored on our side.
Need to pay from the same wallet without holding TRX? See how to send USDT TRC-20 without TRX. More about the wallet: overview and frequently asked questions.
Frequently asked questions #
Can I export the history of all my wallets at once?
No. A statement covers the active wallet. Switch to each wallet and export it separately; each file names the wallet address.
Why are there “Service fee” lines next to my transfers?
Each transfer you send is two operations on the network - the main transfer and a separate small USDT transfer for the fee. The statement shows the fee as its own line so the debit matches your balance.
The amounts in my CSV open as text. What should I do?
Use the Excel (XLSX) format. It has real dates and numbers and needs no import settings. CSV follows your browser’s language for the separator and the decimal mark.
Is the statement an official document?
No. It is generated in your wallet from network data; it is not a bank document. Every line has a transaction hash, so anyone can check it on Tronscan.
Does the wallet tell me how to report USDT for tax?
No. Reporting rules differ by country and we do not give tax advice. The statement gives your accountant the data; how to book it is their call.
Sources #
Checked on 14 November 2026.
- Tronscan docs: TRC-20 transfers with status