Report Fixer for QuickBooks Online · by Atesen SoftwareQuickBooks report exports: readable numbers in Excel and CSV
Take a recognised QuickBooks Online report into a spreadsheet with numeric amounts instead of currency-formatted text. Report Fixer reads the report in your browser and offers Copy, CSV and Excel workbook output.
This guide covers exporting from the report page. Report Fixer does not upload or clean an existing CSV or Excel file, change transactions, or correct accounting figures.
1. Open and check your report
Open the report you need in QuickBooks Online, check its dates and filters, and let it finish loading. Report Fixer works with recognised report tables and grids, including Modern view. Expand sections whose detail you need before exporting: collapsed detail is not made available just by downloading a file.
If you only need QuickBooks' built-in export, go to Reports → Standard reports, select the report, then choose Export/Print → Export to Excel and save it. See Intuit's export instructions. The Report Fixer options below read the open report directly; they do not modify that downloaded file.
2. Choose a Report Fixer output
- Copy: use Copy on the report, then paste into a blank Excel sheet. The clipboard includes a formatted table with numeric cells, indents and bold totals, plus plain tab-separated text. The receiving spreadsheet controls which clipboard format it uses. If prompted that the report is ready, press Copy again.
- CSV: use CSV on the report to download comma-separated text in UTF-8. Numeric values use a decimal point without currency symbols or thousands separators. CSV keeps labels and indentation as text; it does not carry bold styling or workbook row groups.
- Excel: use Excel for an .xlsx workbook with rows grouped by report level. This is a separate output from copying cells or downloading CSV.
Availability depends on your installed version and plan. Copy and CSV are Pro features for new installations; founding users keep those earlier features. Grouped .xlsx workbooks require Pro, including for founding users. Check your extension popup for the features available to you.
Before and after: an explicit synthetic example
This invented two-column report table demonstrates formatting only. It is not customer data, a QuickBooks screenshot, or a comparison with QuickBooks' own exported file. All three rows have level 0; the total row is bold in the input model.
Before: report cell text
| Account | Amount |
|---|---|
| Consulting | $1,234.50 |
| Adjustment | ($34.50) |
| Total | $1,200.00 |
After: CSV text
Account,Amount
Consulting,1234.5
Adjustment,-34.5
Total,1200The same amounts are represented as 1234.5, -34.5 and 1200. Parentheses become a negative value; no total is recalculated. The first column stays text. In formatted Copy output the amount cells are numeric and the total remains bold.
Download the synthetic input model and CSV output to inspect this example.
3. Check the spreadsheet before using it
Compare the headings, row count and totals with the report you intended to export. Check negative values and decimal separators in your spreadsheet. For CSV imports, select UTF-8, comma as the delimiter and a decimal-point number format if your import dialog asks. A CSV contains plain values, so spreadsheet import settings can affect their interpretation.
If a report is not recognised, the popup offers Copy page details for support, which masks names and amounts. See Support for help; do not send report exports, passwords or payment details.
Report Fixer changes presentation and export formatting. It does not validate your books, tax treatment or financial accuracy. Reports are read locally in your browser and are not sent to the developer.