Pricebookr exports a CSV formatted for QuickBooks Online's Products & Services importer — no hand-editing required. It's the fastest way to get your priced catalog into QBO.
One-time setup
QuickBooks requires an income (and expense) account on every imported item. In Settings → QuickBooks export accounts, enter the account names exactly as they appear in your QBO chart of accounts — for example Sales of Product Income and Cost of Goods Sold. You only do this once.
Exporting
- On the Catalog, choose the pricebook whose prices you want to export.
- Click Export for QuickBooks to download the file.
- In QuickBooks Online, go to Settings ⚙ → Import Data → Products and Services and upload it.
How fields map
| QuickBooks field | Comes from |
|---|---|
| Product/Service Name | Item name, prefixed with its category (Category:Name) so the hierarchy carries over |
| Type | Service → Service; Product → Non-inventory |
| Sales price/rate | The selected pricebook's price |
| Purchase cost | The item's cost |
| Income / Expense account | Your QuickBooks export account settings |
| SKU | The item's SKU |
Why no "Inventory" type?
QuickBooks' Inventory type requires quantity-on-hand and an inventory asset account, which a price book doesn't track. Items export as Non-inventory (products) or Service — the right types for "things I price and sell" without stock tracking. You can change any item's type in QuickBooks after import if you do track it as inventory there.
Tips
- QuickBooks imports up to 1,000 rows per file. With a larger catalog, export each pricebook separately or split the file.
- The import can't be undone in QuickBooks, so review the file (or import into a test company) the first time.