Summary
QuickBooks Online cannot export a customer statement to Excel or CSV. Statements come out as PDFs that you send, print or preview. The usual workaround is to export the Customer Balance Detail or A/R Aging Detail report to Excel, one customer at a time. Paidnice can attach a statement CSV with your own columns on a schedule.
- In QuickBooks: Three statement types (Balance Forward, Open Item, Transaction), created in a batch from the customer list, as a PDF only.
- The workaround: Export a balance or aging report to Excel, filter it to one customer, tidy it, then email it yourself.
- With Paidnice: A CSV template with up to 30 columns, including QuickBooks custom fields and Statement Memo, sent with the PDF on one email.
A customer's accounts payable team asks for your statement "in Excel, so we can match it against our ledger". You open the customer in QuickBooks Online, find the Statements tab, and the only thing you can get out of it is a PDF.
Here is what QuickBooks Online gives you, which reports you can export instead, and how to send a statement as a CSV file every month without rebuilding it.
Can you export a customer statement to Excel or CSV in QuickBooks Online?
No. QuickBooks Online makes customer statements as PDF files only, and it has no option to export a statement to Excel or CSV. Excel export in QuickBooks Online covers reports and lists, not statements.
Intuit's help article Export your data from QuickBooks says customer statements "will be exported in a PDF format". You open the customer, go to the Statements tab, and use Print or Preview to get the file.
The QuickBooks team says the same in the Community. In a thread from a user who sends monthly statements to about 100 customers, the reply was that QuickBooks Online only generates customer statements in PDF format, and it suggested a feature request.
Free: Payment reminder email templatesCopy the reminder emails for before, on and after the due date.What does QuickBooks Online give you instead?
QuickBooks Online creates statements in a batch from the customer list, as Balance Forward, Open Item or Transaction Statement, and gives each one as a PDF. Our guide covers how to create each QuickBooks statement type.
What can you do with a QuickBooks statement after you create it?
After you create a statement in QuickBooks Online, you can send it again, print or preview it as a PDF, or delete it. Past statements live on the customer's Statements tab, and they update when the transactions on them change.
What Intuit's statement guide does not describe:
- A schedule that creates and sends statements on the same day each month.
- A spreadsheet version of the statement.
- A choice of which columns or fields the statement shows.
- A second file for the customer's AP system on the same email.
To send statements on a schedule from QuickBooks, see automatic statements for QuickBooks Online. For customers who want paper, see sending QuickBooks statements by post.
Which QuickBooks reports export to Excel instead of a statement?
Three QuickBooks Online reports can stand in for a statement in Excel: Customer Balance Detail, A/R Aging Detail, and the customer's own transaction list. Each exports to Excel, and you filter it to one customer before you send it.
| Report | Where to find it | The limit |
|---|---|---|
| Customer Balance Detail | Reports, Who owes you | Lists only customers with an open balance. Filter to one customer for each file. |
| A/R Aging Detail | Reports, search for the report | Aged by bucket, not laid out like a statement. Formulas and totals need rebuilding after export. |
| Customer transaction list | The customer's page, Transaction list tab | Every transaction, paid or not. One customer at a time. |
The QuickBooks team suggests Customer Balance Detail or Customer Balance Summary as the workaround: customize the report, run it, then use the export icon and Export to Excel. For a CSV, save the Excel file as CSV.
QuickBooks Online can also email a saved custom report on a schedule, with an option to attach the report as an Excel file. That sends one report to the addresses you enter. It does not make a separate file for each customer.
Why does the report workaround break at month end?
The report workaround breaks because every step is per customer. You filter the report, export it, fix the columns and totals, save it, and attach it to an email, once for each customer who wants a spreadsheet.
The Community user with 100 customers described exactly this: run A/R Aging Detail, filter to one customer, export to Excel, rebuild the formulas, email it. It worked for a handful of accounts and was too slow for all of them.
A user in another thread asked how to create a separate Customer Balance Detail report for each customer automatically, and the reply pointed back to a manual export per customer.
The other problem is drift. A hand-built spreadsheet can show different columns each month, and a balance that does not match the PDF statement sent the same day. AP teams that import statements notice both.
What should a statement CSV contain for an AP team?
A statement CSV for an AP team should have one row for each open invoice or credit, the same columns every month, dates in one fixed format, and amounts as plain numbers with no currency symbol. This statement of account CSV template shows a full layout.
Most AP teams match on the invoice number and their own purchase order number. If you keep the PO number in a QuickBooks custom field, put it in its own column. Here is an example layout, with the dates and amounts written as Paidnice writes them:
| Date | Reference | PO Number | Due Date | Amount | Payments | Balance |
|---|---|---|---|---|---|---|
| 2026-09-14 | INV-1038 | PO-5521 | 2026-10-14 | 1840.00 | 840.00 | 1000.00 |
| 2026-10-02 | INV-1042 | PO-5560 | 2026-11-01 | 2650.00 | 0.00 | 2650.00 |
| 2026-10-20 | CN-0107 | 2026-10-20 | -150.00 | 0.00 | -150.00 |
The CSV opens in Excel, and an AP team can import it into their own system. Dates in YYYY-MM-DD order read the same way in every country, so 2026-10-02 is never read as 10 February.
How do you send a QuickBooks statement as a CSV with Paidnice?
In Paidnice, you build a spreadsheet template from the columns you pick, publish it, and select it on a statement policy. Every scheduled statement email then attaches the CSV, and the PDF too if you select both.
- Go to Organisation Settings, Statements, the Custom tab, and click New template. Pick Spreadsheet (CSV).
- Pick your columns. A new spreadsheet starts with Date, Activity, Reference, Due Date, Amount, Payments and Balance.
- Add any other fields, up to 30 columns: Overdue Age, Tax Amount, Net Amount, Payment Date, Contact Name, Currency, Type, Statement Memo, and your synced QuickBooks invoice custom fields.
- Type your own header for each column, and turn on the totals row if you want a last row with the sum of each money column.
- Click Save columns, preview the file with a real customer, then Publish.
- Open your statement policy and select the template under Statement attachments, next to the PDF.
On QuickBooks, a Paidnice spreadsheet is always an outstanding statement: one row for each unpaid invoice or credit. It does not list paid activity. The full steps are in the help article Statement settings and templates.
The policy sends on the schedule you choose: monthly, monthly on weekdays only, or weekly. A customer who owes in more than one currency gets one file for each currency. Statements are on every Paidnice plan, and our page on automated customer statements covers the rest of the setup.
Which QuickBooks fields can go on a Paidnice statement CSV?
A Paidnice statement CSV can include the QuickBooks Statement Memo and any invoice custom field that Paidnice has synced from QuickBooks. Custom fields sit at the end of the column list, marked (Custom).
A custom field you pick as a column shows on the statement whether or not you let customers see custom fields in the portal. That portal setting, Display Custom Fields, is off by default. QuickBooks can hold custom fields that are not printed on the invoice, so check what each field holds before you add it.
Every column needs a header of up to 100 characters. Use the words the customer's AP team uses, such as "Invoice No." or "Your PO", so their import maps without edits.
Can customers download the statement CSV themselves?
Yes. In Paidnice's customer portal, customers can download any spreadsheet template you offer, listed by its title with (CSV) after it. You choose which templates appear under Statement Downloads in Organisation Settings, Portal. More on how to let customers download their own statements.
The portal's Download menu always offers All as CSV, and Outstanding Statement (PDF). Customers can also tick some invoices and download just those. Reminders and statements can link to the portal, and there is no login. The customer portal help article lists each setting.
How do QuickBooks Online and Paidnice statements compare?
QuickBooks Online makes a PDF statement when you run a batch. Paidnice sends PDF and CSV statements from your QuickBooks data on a schedule, with the columns you choose.
| Task | QuickBooks Online | Paidnice on QuickBooks |
|---|---|---|
| Statement file | PDF, CSV, or both on one email | |
| Choose the columns | One line or detail lines | Up to 30 columns with your own headers |
| Custom fields and Statement Memo | Not on a statement export | As columns |
| Schedule | Run a batch manually | Monthly, monthly on weekdays, or weekly |
| Spreadsheet for each customer | Export and filter a report for each one | Made for each customer, one file per currency |
| Customer self-service | Not in Intuit's statement guide | PDF and CSV downloads in the portal |
💡 Paidnice insight
An AP team that asks for your statement in Excel usually wants to import it into their own system. Send the PDF for the person and the CSV for their system on the same email, and the import works the same way every month.
Frequently asked questions
Can QuickBooks Online send customer statements automatically?
Intuit's statement guide describes creating statements in a batch from the customer list, with no schedule. To send them on a set day each month, you need an app such as Paidnice that runs a statement policy on a schedule.
Can I convert a QuickBooks statement PDF to Excel?
You can, with a PDF converter, and the QuickBooks team has pointed users to third-party apps for this. Check the result: converted tables often split rows or lose the totals, and you repeat the job for each customer.
Can a QuickBooks statement CSV list every transaction, like an activity statement?
Not in Paidnice. On QuickBooks, a Paidnice spreadsheet is always outstanding, with one row for each unpaid invoice or credit. For a full history, use the QuickBooks Transaction Statement as a PDF.
Do sub-customers and projects get their own statement?
In QuickBooks, a sub-customer set to bill with its parent goes on the parent's statement. In Paidnice, child contacts' invoices go on the parent's statement, and the Separate projects & jobs setting gives each QuickBooks job or project its own section.
Can I send the PDF and the CSV in one email?
Yes. A Paidnice statement policy attaches every template you select under Statement attachments, so one email can carry the PDF statement and one or more CSV files.
Paidnice features in this article
About the editorial team
Ashley is a co-founder and lead developer of Paidnice and has built accounting software for more than 10 years. He builds the ledger connections that put reminders, late fees and payments into Xero, QuickBooks and ERPs such as NetSuite and Business Central. Before Paidnice he co-founded A2X, ecommerce accounting software for Xero and QuickBooks.
App of the Year