The three common choices
CSV is universal, OFX is a structured financial format, and QBO is QuickBooks' Web Connect variant. The best choice depends on whether you need manual review or direct import.
Decision rule
Use Excel or CSV when the client data needs review, cleanup, or mapping. Use QBO/OFX when the transaction structure is already clean and the goal is a faster QuickBooks import.
Reference table
| Format | Best for | Tradeoff |
|---|---|---|
| CSV | Flexible imports and cleanup | Requires column mapping |
| OFX | Structured financial data | Destination support varies |
| QBO | QuickBooks Web Connect workflows | Needs careful account matching |
FAQ
Can QuickBooks import PDF statements directly?
No. Convert the PDF into QBO/OFX or CSV first, then review the file before import.
Which format should a bookkeeper choose?
Choose QBO/OFX for cleaner QuickBooks imports and CSV when you need spreadsheet review or custom mapping before import.