Connect QuickBooks Online to Loupe Factory in one click and keep customers, invoices, payments, and inventory items in sync - automatically, in the background, without double-entry.
Why connect QuickBooks Online?
Manufacturers and wholesalers in the gemstone and jewelry industry often run operations in one system and accounting in another. That means the same customer gets typed twice, invoices are copy-pasted, and inventory counts drift apart. Loupe Factory's native QuickBooks Online integration closes that gap by syncing the records that matter most - so your books stay accurate without the busywork.
What syncs between Loupe Factory and QuickBooks
| Record Type | Pull (QBO → Loupe Factory) | Push (Loupe Factory → QBO) | What gets mapped |
|---|---|---|---|
| Customers | ✓ | ✓ | Name, company, email, phone, address |
| Invoices | ✓ | ✓ | Invoice number, line items, totals, currency, due date, payment status |
| Payments | ✓ | ✓ | Amount, currency, linked invoice |
| Inventory Items | ✓ | ✓ | Item name, description, cost price, sell price, quantity |
Field mapping: what goes where
When records sync between QuickBooks Online and Loupe Factory, each field lands in the right place automatically. Here's how the data maps for each record type.
Customers
| QuickBooks Online | Loupe Factory |
|---|---|
| Display Name | First Name + Last Name |
| Company Name | Company Name |
| Primary Email | |
| Primary Phone | Phone Number |
| Billing Address (Street, City, Country, Postal Code) | Street Address, City, Country, ZIP Code |
Invoices
| QuickBooks Online | Loupe Factory |
|---|---|
| Invoice Number | Invoice Number |
| Customer | Linked Customer (matched via sync mapping) |
| Line Items (Description, Quantity, Unit Price) | Invoice Line Items |
| Total | Invoice Total |
| Currency | Currency |
| Due Date | Payment Due Date |
| Status (Paid / Open / Partially Paid) | Payment Status (Paid / Unpaid / Partial) |
Payments
| QuickBooks Online | Loupe Factory |
|---|---|
| Payment Amount | Invoice Total (applied to linked invoice) |
| Currency | Currency |
| Linked Invoice | Matched Invoice (via sync mapping) |
| Payment Status | Invoice Payment Status updated to Paid or Partial |
Inventory Items
| QuickBooks Online | Loupe Factory |
|---|---|
| Item Name | Product Name |
| Description | Notes |
| SKU / Item Code | Tag ID |
| Sales Price (Unit Price) | Sell Price |
| Purchase Price (Cost) | Cost Price |
| Quantity on Hand | Quantity |
All mappings are tracked automatically. When a record is synced for the first time, Loupe Factory creates a link between the local and QuickBooks records. On subsequent syncs, the system updates the existing record instead of creating a new one.
How it works
- Connect in one click. Open Workflows → Integrations → QuickBooks Online in Loupe Factory and click "Connect QuickBooks." You'll authorize access through a secure OAuth window - no API keys to copy, no credentials to manage.
- See your connection status. Once connected, the dashboard shows your QuickBooks company name, connection health, and last sync timestamp at a glance.
- Sync what you need. Each record type (Customers, Invoices, Payments, Inventory Items) has its own pull and push controls. Click the button, and the sync runs in the background - no page freezes, no timeouts.
- Review activity. The built-in activity log shows every sync operation with timestamps, status, and error details if something needs attention.
- Disconnect anytime. One click to revoke access. Your local data stays intact for audit purposes.
Background sync - no timeouts, no waiting
Every sync operation runs asynchronously in the background. When you click "Pull from QuickBooks" or "Push to QuickBooks," the task is queued and processed server-side. You get an instant confirmation, and the dashboard updates when the sync completes. This means you can trigger a full customer pull and keep working - even if you have thousands of records.
Built-in duplicate protection
Nobody wants to see the same customer appear twice or an invoice posted to QuickBooks that already exists. Loupe Factory tracks every synced record with a mapping layer that links your local records to their QuickBooks counterparts. Before creating anything new, the system checks whether a mapping already exists - and skips it if so. On top of that, every push request includes a unique transaction identifier so that even network retries can't create duplicates.
Multi-tenant isolation
If you run multiple organizations in Loupe Factory, each tenant's QuickBooks connection is completely isolated. One organization's sync never touches another's data. Credentials, mappings, and sync history are all scoped to the tenant - so you can connect different QuickBooks companies to different Loupe Factory organizations without conflict.
Time and cost impact
Before vs. after: a typical mid-size operation
| Task | Without Integration | With Loupe Factory + QuickBooks |
|---|---|---|
| Sync 200 customers | 2-3 hours of manual entry | ~30 seconds (one click) |
| Push 50 invoices/month | 1-2 hours of copy-paste | ~30 seconds (one click) |
| Reconcile payment statuses | 30-60 min cross-referencing | Automatic on pull sync |
| Keep inventory items aligned | Ongoing manual updates | Bidirectional sync |
For a team handling 200+ customers and 50+ invoices per month, the integration can save 15-20 hours/month of manual data entry and reconciliation.
Security and credentials
- OAuth 2.0 authorization - Loupe Factory never sees or stores your QuickBooks password.
- Credentials are managed securely with automatic token refresh.
- The dashboard warns you if credentials are expiring soon so you can re-authorize before any disruption.
- Connection health is monitored and displayed on the dashboard (healthy, degraded, or down).
💡 Pro Tip: Run a customer pull sync first, then push your invoices. Invoice sync depends on customers being mapped, pulling customers first ensures every invoice links to the right account in QuickBooks.
Getting started
The QuickBooks Online integration is available on all Loupe Factory plans. To connect:
- Log in as an admin user.
- Navigate to Workflows → Integrations → QuickBooks Online.
- Click Connect QuickBooks and authorize access.
- Start syncing.
That's it. No plugins to install, no CSV exports to manage, no middleware to configure.
Want help setting up your QuickBooks integration? Talk to our team.
