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.

Starting from $5 — see pricing & 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 It Works

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.

Quick Answers

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.

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 Data is Safe

Bank-Level Security

256-bit SSL encryption. Same standards as major financial institutions.

No Data Storage

Files are processed directly in browser. No calls to our servers.

GDPR Compliant

Full EU data protection compliance. Your privacy rights protected.

ISO/IEC 27001 Certified GDPR Compliant Swiss Privacy CCPA Compliant

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

Why Use This Tool?

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.

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

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

More credits - more savings

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

// PRICING //

Choose the plan that fits your needs

5,381 reviews, Excellent
Pay as you go

Just start processing on any tool page

$1/credit

Tools processing starts from 5 credits. Then 1 credit = 1k rows. No sign-up needed.

OR

Credit Bundles

$ /Credit

One-time purchase

  • No monthly commitment
  • Credits valid for one year
  • Access to all tools
  • Full file downloads

Monthly Bundles Pro

$ /Credit

Best for professionals and content creators

Annual Discount
Per month, billed annually:
Save 20% more
  • Credits refresh monthly
  • Priority processing

Purchase Credits

  • Full CSV & Excel export
  • Google Sheets export
  • Instant browser download
for credits

Visa Mastercard PayPal Apple Pay Google Pay
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle

Do unused credits expire?

One-time credit bundles are valid for one year. Subscription credits refresh monthly. You can use credits across any tool, anytime.

Is my data secure?

Files process entirely in your browser. We're GDPR compliant with TLS encryption.

Can I get a refund?

Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.

Powered by Paddle

Terms of service applies. VAT included where applicable.

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.
No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.
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 NameName Company NameCompany Email AddressEmail
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 + VariationProduct/Service Name SKUSKU DescriptionSales 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
DateJournalDate Gross SalesCredits FeesDebits
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
DateDate Net TotalAmount Event Type + TimeDescription
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 IDRefNumber DateTxnDate Total CollectedItemAmount
Retail, e-commerce, paid orders

Also available as

This platform pair is available in 2 other hubs