Guide · one-time import, no subscription

How to import Square products into QuickBooks Online without paying for a sync app

Most advice about connecting Square and QuickBooks assumes you want continuous syncing — daily sales flowing into your books automatically. For that, a subscription connector makes sense. But a huge share of people searching for this are doing something simpler: a bookkeeper onboarding a new client, or an owner setting up QuickBooks for the first time, who just needs the item list moved over once. Paying $30+ every month forever to move a list once is the wrong tool.

The one-time path

1. Export from Square. Square Dashboard → Items & services → Actions → Export library. You get a CSV of your full catalog: names, variations, SKUs, categories, prices.
2. Repair the CSV. Square’s export format and QuickBooks’ import format disagree in four specific ways — duplicate names from variations, colons that hijack QuickBooks’ category syntax, the word “variable” in price cells, and occasional over-length names. Our troubleshooting guide walks through fixing each by hand, or the converter below does all four automatically.
3. Import to QuickBooks Online. Settings ⚙ → Import data → Products and Services. Upload the repaired CSV. QuickBooks shows a mapping screen where each of your columns is matched to a QuickBooks field — confirm the mapping and import.

What you give up versus a sync app

Honesty matters here: a one-time import moves your catalog, not your ongoing sales. Daily revenue, fees, and deposits still need to reach your books some other way — many bookkeepers prefer a daily summary journal entry anyway. What you avoid is a permanent subscription, an OAuth connection holding write access to your books, and a sync tool’s opinion about how your chart of accounts should look.

When a sync app actually is the right call

High-volume sellers who need item-level sales detail in QuickBooks every day, multi-location setups, or anyone whose catalog changes weekly. If that is you, buy the subscription. If you just need the list in there, do the import and keep the $360 a year.