Back to Integrations
QuickBooks Online Integration
Automatically sync demurrage invoices and bills with QuickBooks Online.
Overview
| Feature | Carriers | Customers |
|---|---|---|
| Create Invoices | Automatic on approval | - |
| Create Bills | - | Automatic on approval |
| Sync Payments | ||
| Sync Customers/Vendors |
Prerequisites
- QuickBooks Online account (Plus, Advanced, or Accountant)
- Demurly admin access for your organization
- Chart of accounts set up in QuickBooks
Setup Instructions
1
Connect QuickBooks
- Navigate to Settings > Integrations
- Click Connect on the QuickBooks Online card
- Sign in to your QuickBooks account
- Authorize Demurly to access your company
- You'll be redirected back to Demurly
2
Configure Account Mapping
After connecting, configure how Demurly maps to your QuickBooks accounts:
| Setting | Description | Example |
|---|---|---|
| Demurrage Income Account | Revenue account for demurrage charges | "4100 - Service Revenue" |
| Demurrage Expense Account | Expense account for demurrage bills | "6100 - Operating Expenses" |
| Demurrage Service Item | Service item for line items | Auto-created if blank |
3
Configure Sync Settings
- Go to the Sync Settings tab
- Enable/disable:
- Auto-create Invoices - Create QB invoice when demurrage is approved
- Auto-create Bills - Create QB bill when receiving demurrage charges
- Sync Customers/Vendors - Keep business partners in sync
4
Test the Connection
- Click Sync Now to verify connectivity
- Check the Sync History tab for results
How It Works
For Carriers (Accounts Receivable)
When a demurrage record is approved:
- Demurly finds or creates the Customer in QuickBooks
- Creates an Invoice with customer reference, demurrage line items, and Demurly record reference
- Stores the QuickBooks Invoice ID for tracking
For Customers (Accounts Payable)
When you approve a demurrage charge:
- Demurly finds or creates the Vendor in QuickBooks
- Creates a Bill with vendor reference and demurrage expense line items
Payment Sync
When payments are recorded in QuickBooks:
- QuickBooks sends a webhook to Demurly
- Demurly updates the invoice status to "Paid"
- Payment date is recorded
Security
- OAuth 2.0 authentication (no passwords stored)
- Tokens encrypted with AES-256-GCM
- Automatic token refresh
- All API calls logged for audit
Having Issues?
Check the Troubleshooting Guide for common QuickBooks integration issues and solutions.