How do I split a QuickBooks or Xero export by client into separate Excel files?

Upload your export to Deliteful, enter the column header that identifies the client (e.g., 'Customer' or 'Client Name'), and the tool generates one .xlsx per client containing only their transactions and the original header row.

Can I split by account code or vendor instead of client name?

Yes — any column in your export works as the split key. Enter the exact column header for your account code, vendor, or any other field you want to segment by.

What if some transactions have a blank client field?

Rows with empty values in the split column are grouped into a single output file. No transactions are silently dropped from the dataset.

Are formulas preserved in the output files?

No — output files contain computed values only, not formulas. This is standard for client-facing reconciliation files and avoids broken references in isolated workbooks.

How many client files can be generated in one run?

Up to 200 output files per input file, which covers virtually any bookkeeping client roster.

Split Transaction Excel Exports by Client or Account for Bookkeeping

Bookkeepers managing multiple clients from a single bank feed or accounting export face a recurring problem: one Excel file containing transactions for every client or account, needing to be separated before reconciliation or review. Deliteful automates that split so you can stop copying and pasting rows into individual client workbooks.

Create free account

Many bookkeepers work with consolidated transaction exports from QuickBooks, Xero, Wave, or a bank portal — a single .xlsx containing hundreds or thousands of rows tagged by client name, account code, or vendor. Splitting that file manually means filtering on one client, copying visible rows, pasting into a new workbook, naming it correctly, and repeating for every client. For a bookkeeper managing 20 clients, that's a significant chunk of time at month-end, and a missed filter risks mixing one client's transactions into another's file.

Deliteful's Excel Split by Column tool reads your consolidated export and produces one .xlsx per unique value in your client or account column — whatever header your export uses. Each output file contains the full header row and only that client's rows, clean and ready for reconciliation. No formulas are carried over, which is exactly what you want for a standalone client file.

How it works

1
Sign up free with Google
Create your Deliteful account in 3 clicks — no credit card required.
2
Upload your consolidated transaction export
Drop in the .xlsx or .xls file from QuickBooks, Xero, or your bank portal.
3
Enter the client or account column name
Type the exact column header — e.g., 'Client', 'Account', or 'Entity'.
4
Download individual client files
Receive one Excel file per client or account, each ready for reconciliation or review.

Frequently asked questions

How do I split a QuickBooks or Xero export by client into separate Excel files?: Upload your export to Deliteful, enter the column header that identifies the client (e.g., 'Customer' or 'Client Name'), and the tool generates one .xlsx per client containing only their transactions and the original header row.
Can I split by account code or vendor instead of client name?: Yes — any column in your export works as the split key. Enter the exact column header for your account code, vendor, or any other field you want to segment by.
What if some transactions have a blank client field?: Rows with empty values in the split column are grouped into a single output file. No transactions are silently dropped from the dataset.
Are formulas preserved in the output files?: No — output files contain computed values only, not formulas. This is standard for client-facing reconciliation files and avoids broken references in isolated workbooks.
How many client files can be generated in one run?: Up to 200 output files per input file, which covers virtually any bookkeeping client roster.

Create your free Deliteful account with Google and split your next consolidated transaction export into individual client files in under a minute.