Square Items to QuickBooks Products

🥦

Convert Complete

QuickBooks Product/Service Import Format
valid rows

Migrate your Square Item Library to QuickBooks Products/Services. Transfers item names, variations, SKUs, prices, and inventory.

Free preview — then from $5. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start

Download Sample

Sample item library CSV

Download Sample

How to Convert Square → QBO Products

1

Export from Square

Items & services → Items → Actions → Export Library → Export

2

Upload and Configure

Upload Item Library Export CSV and choose Products and Services Import format

3

Preview and Download

Review converted data, download Quickbooks Online-ready file

4

Import to QuickBooks Online

Settings ⚙️ → Import Data → Products and Services → Upload CSV

Output is in QuickBooks Product/Service Import format — ready to import directly, no manual reformatting needed.

Field Mapping

How Square Items fields map to Quickbooks Online Product Service

Square Items Source Value Quickbooks Online Product Service Target Value Note
SKU LAT-LRG-001 → SKU LAT-LRG-001 Stock Keeping Unit
Description Our signature espresso drink → Sales Description Our signature espresso drink Product description
Category Beverages > Hot Drinks → Category Beverages > Hot Drinks Product category (use : for hierarchy)
Price 4.50 → Sales Price/Rate 4.50 Selling price

Data Transformation

Each Square item/variation becomes one QuickBooks product/service

Input Square Item

One row per item (variations create separate rows)

Key columns: Item Name, Variation, SKU, Price, Current Quantity
1:1 — One input row creates one output row
Output QuickBooks Product/Service 1 rows per input

One inventory/non-inventory item per Square item

Product Record Item name with variation appended (e.g., 'T-Shirt:Blue')
Product/Service Name unique; SKU unique if present; Category uses colon separator

Why Use the Square → QBO Products Converter?

Variation Support

Square item variations become individual QuickBooks products.

SKU Preservation

Stock Keeping Units transferred for inventory tracking.

Price & Cost

Selling price and unit cost both transferred.

Category Hierarchy

Square category structure converted to QuickBooks format.

Inventory Levels

Optional: Import current stock quantities.

Duplicate Detection

Warns about duplicate SKUs before import.

Common Products and Services Import Errors

Issues you might encounter when importing Item Library Export data to Products and Services Import - and how we solve them

Duplicate Product Name

QBO requires unique product/service names

Name: 'T-Shirt' (already exists)
Name: 'T-Shirt:Blue' (with variation)

Variations are appended to create unique names

Use Item Name:Variation format

Duplicate SKU

QBO doesn't allow duplicate SKUs

SKU: 'ABC123' (duplicate)
SKU: 'ABC123-BLU' (unique)

Review and fix duplicate SKUs before import

The converter warns about duplicate SKUs

Category Hierarchy Format

QBO uses : to separate category levels

Category: 'Apparel > T-Shirts'
Category: 'Apparel:T-Shirts'

Square's > separator is converted to QBO's : format

Automatic conversion during import

Square → QBO Products Conversion Questions

How do I export the Item Library from Square?

Go to Square Dashboard → Items & Inventory → Item Library → Export. Choose Excel format for best results (CSV may convert SKUs to scientific notation).

How are variations handled?

Each variation becomes a separate QuickBooks product using 'Item Name:Variation' format. Enable 'Combine Variations' to use this format.

Should I import inventory?

Enable 'Import Inventory Quantities' to set initial stock levels. Products with quantities become Inventory type; others become Service type.

How People Use Square → QBO Products

Our Square item library had 420 products with size and color variations. This converter flattened every variation into individual QuickBooks products using the Item:Variation format. SKUs and prices transferred correctly, and inventory quantities set the initial stock levels.

Vanessa O.
Retail Operations Manager · 420 Square items with variations

Migrating Square product catalogs to QuickBooks is a recurring request from my retail clients. The category separator conversion from Square's > format to QuickBooks : format saves me from manual find-and-replace across hundreds of product rows.

Frank T.
Bookkeeper, Retail Clients · 7 Square POS clients

I needed to import Square items to QuickBooks with the right income and expense accounts. Setting Sales Income and Cost of Goods Sold during conversion meant every product was properly categorized on import. The duplicate SKU warning caught two conflicts I would have missed.

Linda N.
Gift Shop Owner · 280 products, 3 locations

Why Square Items Don't Import Directly to QuickBooks

The Variation Structure Problem

Square organizes products with variations (Size, Color) as nested data structures. QuickBooks expects flat product records—one row per SKU. Without conversion, you'd lose variation details or create incomplete product records that don't match your actual inventory structure.

What This Tool Does

We flatten Square's item hierarchy into QuickBooks-compatible product records: - Each variation becomes a separate product with combined name (Item:Variation) - SKUs, prices, and costs transfer correctly - Category hierarchy converts from Square's > to QuickBooks' : format Your QuickBooks product catalog mirrors your Square item library exactly.

Your Square → QBO Products Conversion is Secure

Client-Side Conversion

No server round-trips. Your Square → QBO Products data is processed entirely in the browser tab.

Auto-Erased on Close

The moment you close the page, all Square → QBO Products data is wiped from browser memory. No traces left.

EU Privacy Standard

Meets GDPR requirements by design — no data processing on external servers, ever.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Frequently Asked Questions

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.
Go to Square Dashboard → Items & Inventory → Item Library → Export. Choose Excel format for best results (CSV may convert SKUs to scientific notation).
Each variation becomes a separate QuickBooks product using 'Item Name:Variation' format. Enable 'Combine Variations' to use this format.
QuickBooks doesn't allow duplicate SKUs. The converter warns about duplicates so you can fix them before import.
Enable 'Import Inventory Quantities' to set initial stock levels. Products with quantities become Inventory type; others become Service type.
Square uses > for category hierarchy (Apparel > T-Shirts). QuickBooks uses : instead. We convert automatically.
When exporting from Square as CSV and importing to QuickBooks, product prices are included in the import. However, price updates must be made manually in both systems—pricing changes in one system don't automatically sync to the other.
Products with duplicate names, variations, or special characters may fail to import. Ensure each product has a unique name, check your CSV file for formatting issues, and verify the import file matches QuickBooks' requirements.
No, the integration is one-way. Price changes made in QuickBooks do not update Square automatically. You must update prices in Square first, then export and re-import to QuickBooks if needed.
Sync with Square is retired and Connect to Square is being phased out. The current recommended solution is Square Connector by Intuit, which offers better compatibility, direct support, and more reliable product syncing with QuickBooks.
Square variations can't be imported directly into QuickBooks. Export your base items without variation details, then manually create separate items in QuickBooks for each variation if needed, or use the base product name.

Square → Quickbooks Online Data Ecosystem

All available data flows from Square to Quickbooks Online

Square Customers Export Customer directory with contact info, addresses, and purchase history
→
Quickbooks Online Customer Import Customer profiles with contact and billing information
First Name + Last Name → Name Company Name → Company Email Address → Email
Customer list migration, CRM sync
Square Item Library Export Product catalog with variants, pricing, inventory, and tax settings
→
Quickbooks Online Products and Services Import Product and service items for invoicing and sales
Item Name + Variation → Product/Service Name SKU → SKU Description → Sales Description
Product catalog migration, inventory setup Current tool
Square Transactions Export Payment transactions with fees, tips, taxes, and settlement data
→
Quickbooks Online Journal Entry Double-entry accounting with debits/credits
Date → JournalDate Gross Sales → Credits Fees → Debits
Professional accounting, fee tracking, aggregated imports
Square Transactions Export Payment transactions with fees, tips, taxes, and settlement data
→
Quickbooks Online Bank Transaction CSV (3-Column) QuickBooks Online bank transaction import - 3-column format
Date → Date Net Total → Amount Event Type + Time → Description
Manual bank statement upload for 90+ day history or non-connected accounts
Square Transactions Export Payment transactions with fees, tips, taxes, and settlement data
→
Quickbooks Online Sales Receipt Cash-basis B2C sales (payment received at checkout)
Transaction ID → RefNumber Date → TxnDate Total Collected → ItemAmount
Retail, e-commerce, paid orders

Also available as

This platform pair is available in 2 other hubs

Learn More:

vs Synder vs Amaka vs Webgility vs A2X vs Bookkeep vs Taxomate vs SaaSant Export Items Guide