QuickBooks Integration
Sync financial data between OpenBoxes and QuickBooks to keep your supply chain and accounting systems aligned. This integration is available on Dedicated and Enterprise tiers.
What It Does
The QuickBooks integration connects your OpenBoxes procurement and inventory transactions with QuickBooks Online, reducing manual data entry and improving financial accuracy. Key capabilities:
- Purchase orders created in OpenBoxes appear as bills or purchase orders in QuickBooks
- Invoices for outbound shipments sync to QuickBooks as invoices or sales receipts
- Vendor records stay consistent across both systems
- Inventory value adjustments in OpenBoxes reflect in QuickBooks
What Data Syncs
| OpenBoxes Entity | QuickBooks Entity | Direction | Sync Trigger |
|---|---|---|---|
| Purchase Order | Purchase Order / Bill | OpenBoxes --> QuickBooks | On PO approval |
| Supplier | Vendor | OpenBoxes --> QuickBooks | On creation/update |
| Outbound Shipment | Invoice | OpenBoxes --> QuickBooks | On shipment completion |
| Product | Item | OpenBoxes --> QuickBooks | On creation/update |
| Inventory Adjustment | Journal Entry | OpenBoxes --> QuickBooks | On adjustment approval |
Note: The integration is primarily one-directional (OpenBoxes to QuickBooks). Vendor and product records created in QuickBooks are not automatically pulled into OpenBoxes.
Setup Process
Prerequisites
- A QuickBooks Online account (Plus or Advanced plan recommended)
- An OpenBoxes Lift Dedicated or Enterprise subscription
- Admin access to both systems
Step 1: Connect Your QuickBooks Account
- Log in to your OpenBoxes Lift portal at
app.openboxes.cloud. - Navigate to Settings > Integrations > QuickBooks.
- Click Connect to QuickBooks --- you will be redirected to Intuit's authorization page.
- Sign in to your QuickBooks account and grant the requested permissions.
- Select the QuickBooks company file to connect.
Step 2: Configure Account Mappings
Map OpenBoxes transaction types to the correct QuickBooks accounts:
| Transaction Type | QuickBooks Account | Example |
|---|---|---|
| Inventory purchases | Cost of Goods Sold / Inventory Asset | 5000 - COGS |
| Outbound shipments | Revenue / Sales | 4000 - Program Revenue |
| Inventory adjustments | Inventory Shrinkage | 5100 - Adjustments |
Step 3: Map Products
OpenBoxes products need to be linked to QuickBooks items. You can:
- Auto-create --- Let the integration create new QuickBooks items for each OpenBoxes product
- Manual mapping --- Match existing QuickBooks items to OpenBoxes products via SKU or product code
Step 4: Set Sync Preferences
Configure how often and what triggers a sync:
- Real-time --- Transactions sync within minutes of being created or approved
- Scheduled --- Batch sync runs daily at a time you choose (recommended for high-volume operations)
- Manual --- Sync only when triggered from the portal
Sync Frequency
| Mode | Latency | Best For |
|---|---|---|
| Real-time | 1--5 minutes | Low-volume operations needing up-to-date books |
| Scheduled (daily) | Up to 24 hours | High-volume operations, reduces API calls |
| Manual | On-demand | Testing, ad-hoc reconciliation |
Handling Sync Errors
When a transaction fails to sync, the integration:
- Logs the error in the Integration Activity panel on your portal dashboard.
- Retries automatically up to 3 times with exponential backoff.
- Marks the transaction as Sync Failed if all retries fail.
Common causes of sync failures:
- Deleted QuickBooks account --- The mapped GL account was removed from QuickBooks
- Duplicate vendor/item --- A matching record already exists with a different identifier
- QuickBooks API limits --- Intuit throttles API requests; scheduled sync avoids this
Tip: Review the Integration Activity panel weekly to catch and resolve failed syncs before they accumulate.
Limitations
- QuickBooks Online only --- QuickBooks Desktop is not supported.
- Single company file --- Each OpenBoxes instance connects to one QuickBooks company.
- Currency --- Transactions sync in the base currency of your QuickBooks company. Multi-currency support requires QuickBooks Advanced.
- Historical data --- Only transactions created after the integration is enabled will sync. Historical data must be migrated manually or via a one-time import.
- Tax calculations --- Tax codes and rates must be configured in QuickBooks. OpenBoxes does not push tax data.
Disconnecting
To disconnect the integration, go to Settings > Integrations > QuickBooks and click Disconnect. This stops all future syncs but does not delete data already in QuickBooks.