Skip to content
Safitab

Clean an accounting export

Exports from QuickBooks, Xero and similar tools are reports first: a title and a date range on top, accounts written as paths like Assets:Current Assets:Checking, sections and subtotals, and a total that has to balance.

The report title is set aside, account paths are split into the account name and its full path, totals are taken out of the data and checked — debits against credits included — and amounts become numbers. The result is one flat table you can pivot, filter or import.

Drop files here

or browse your files

XLSX, XLS, CSV, TXT, PDF · up to 25 MB · 1 file without an account

Or try a sample:

Example: before and after

“Assets:Current Assets:Checking” became the account “Checking” with its full path in Account path; the Total row was checked and both columns balance.

Beforetrial-balance.csv
1Trial Balance
2As of March 31, 2026
3
4AccountDebitCredit
5Assets:Current Assets:Checking24,310.55
6Assets:Current Assets:Accounts Receivable8,940.00
7Liabilities:Credit Card 2,115.40
8Equity:Owner's Capital 25,000.00
9Income:Sales 18,420.15
10Expenses:Rent4,500.00
11Expenses:Software7,785.00
12Total45,535.5545,535.55
After7 rows
AccountAccount pathDebitCredit
CheckingAssets > Current Assets > Checking24,310.55
Accounts ReceivableAssets > Current Assets > Accounts Receivable8,940.00
Credit CardLiabilities > Credit Card2,115.40
Owner's CapitalEquity > Owner's Capital25,000.00
SalesIncome > Sales18,420.15
RentExpenses > Rent4,500.00
SoftwareExpenses > Software7,785.00

How to do it

  1. 1Drop the trial balance, P&L or ledger export (XLSX, CSV or PDF).
  2. 2Check the totals verification and the account columns.
  3. 3Download one flat table for analysis or import.

Questions

Which accounting tools do you support?
Any that export to Excel, CSV or PDF. The layout is detected from the file rather than from a list of products, and remembered for the next export.
What happens to account hierarchies?
The account keeps its own name, and the full path goes into a separate column joined with “ > ”. Splitting the path into one column per level is a suggestion you can switch on.
Are derived lines like Gross Profit checked as sums?
No. Gross Profit, Net Income and similar lines are differences, not sums of the rows above, so they are removed from the data but not checked as totals.

Related tasks

See all tools