QuickBooks Integration

Muin’s QuickBooks integration creates a seamless connection between your business operations and accounting. Sync invoices, vendors, and expenses automatically, eliminating manual data entry and keeping your books accurate.

Integration Overview

What Syncs

Data Type	Direction	Description
Invoices	Muin → QB	Approved invoices sync to QuickBooks
Vendors	Two-way	Vendor records stay in sync
Expenses	QB → Muin	Expenses import for tracking
Payments	QB → Muin	Payment status updates
Chart of Accounts	QB → Muin	Account list for categorization

Benefits

• Eliminate double entry - Enter once, sync everywhere
• Real-time accuracy - Data stays current
• Reduce errors - No manual transcription mistakes
• Save time - Hours saved on data entry weekly

---

Setting Up the Integration

Prerequisites

Before connecting:

• Active QuickBooks Online subscription
• QuickBooks admin access
• Muin admin permissions

Connecting QuickBooks

1. Navigate to Settings → Integrations
2. Find QuickBooks Online and click Connect
3. Sign in to your QuickBooks account
4. Authorize Muin to access QuickBooks
5. Select your QuickBooks company (if multiple)
6. Click Connect

Initial Configuration

After connecting:

1. Map accounts - Match Muin categories to QB accounts
2. Set sync preferences - Configure what syncs and when
3. Review existing data - Decide on historical import
4. Test the connection - Verify sync works correctly

---

Invoice Sync

How Invoice Sync Works

Invoice Approved → Queued → Sent to QB → Confirmed
      │              │           │            │
   In Muin      Sync queue    Created in   Linked back
                             QuickBooks    to Muin

Configuring Invoice Sync

1. Go to Integrations → QuickBooks → Settings
2. Under Invoice Sync:
   • Enable/disable invoice sync
   • Set sync trigger (on approval, manual, scheduled)
   • Map payment terms
   • Configure tax handling

What Gets Synced

For each invoice:

• Vendor name (matched or created)
• Invoice number
• Date and due date
• Line items with descriptions
• Amounts and tax
• Payment status

Invoice Matching

Muin matches invoices to existing QB data:

• Vendor matching - By name or tax ID
• Duplicate detection - Prevents double entry
• Conflict resolution - Alerts on mismatches

---

Vendor Sync

Two-Way Vendor Sync

Vendors stay synchronized between systems:

Muin → QuickBooks:

• New vendors created in Muin appear in QB
• Updates to vendor info sync

QuickBooks → Muin:

• New QB vendors import to Muin
• Payment info updates

Vendor Mapping

Map vendor records between systems:

1. Go to Integrations → QuickBooks → Vendors
2. Review unmapped vendors
3. Map to existing QB vendor or create new
4. Set as default mapping

Vendor Fields Synced

Field	Syncs	Notes
Name	Yes	Display name
Email	Yes	Primary contact email
Phone	Yes	Primary phone
Address	Yes	Primary address
Tax ID	Yes	EIN/SSN
Payment terms	Yes	Default terms
Bank info	QB → Muin	For payment info

---

Expense Sync

Importing Expenses

Bring expenses from QuickBooks into Muin:

1. Enable expense import in settings
2. Set import frequency (real-time, daily, manual)
3. Configure filters (date range, categories)
4. Expenses appear in Muin for tracking

Expense Categorization

Map QuickBooks categories to Muin:

• Create category mappings
• Set default for unmapped
• Auto-apply to imported expenses

Using Expense Data

Imported expenses enable:

• Budget tracking
• Vendor spend analysis
• Grant allocation
• Cash flow forecasting

---

Chart of Accounts

Account Sync

Import your QuickBooks chart of accounts:

1. Go to Integrations → QuickBooks → Accounts
2. Click Sync Accounts
3. Review imported account list
4. Map to Muin categories

Account Mapping

Create mappings for:

• Expense categories
• Revenue categories
• Asset accounts
• Liability accounts

Using Accounts

Synced accounts enable:

• Proper GL coding on invoices
• Accurate expense categorization
• Report alignment between systems

---

Sync Settings

Sync Frequency

Configure how often data syncs:

Option	Description
Real-time	Immediate sync on changes
Hourly	Every hour
Daily	Once per day
Manual	Only when you trigger

Sync Direction

For each data type:

• Muin → QuickBooks - Push to QB only
• QuickBooks → Muin - Pull from QB only
• Two-way - Sync both directions

Conflict Resolution

When data conflicts:

• Muin wins - Muin data takes precedence
• QuickBooks wins - QB data takes precedence
• Manual - Alert for manual resolution
• Most recent - Newer data wins

---

Monitoring Sync

Sync Dashboard

View sync status at Integrations → QuickBooks → Status:

Metric	Description
Last Sync	When sync last ran
Status	Healthy, warning, error
Pending	Items waiting to sync
Failed	Items that failed

Sync History

Review past syncs:

• Date and time
• Items synced
• Success/failure count
• Error details

Error Handling

When sync fails:

• Error notification sent
• Details logged
• Retry options available
• Manual fix instructions

---

Common Sync Issues

Duplicate Records

If duplicates appear:

1. Review vendor matching settings
2. Enable stricter matching
3. Merge duplicates in either system
4. Mappings prevent future duplicates

Missing Data

If data isn’t syncing:

1. Check sync is enabled
2. Verify connection is active
3. Review filter settings
4. Check for errors in log

Connection Issues

If connection drops:

1. Re-authorize from settings
2. Check QuickBooks subscription
3. Verify network connectivity
4. Contact support if persists

---

Advanced Features

Custom Field Mapping

Map custom fields between systems:

1. Go to Settings → Field Mapping
2. Map Muin fields to QB custom fields
3. Set transform rules if needed
4. Test with sample data

Webhook Notifications

Receive real-time updates:

• Invoice synced successfully
• Sync error occurred
• Connection status change

API Access

For developers:

• Direct API endpoints
• Webhook subscriptions
• Bulk operations
• Custom integrations

---

Security

Data Protection

Your data is protected:

• OAuth 2.0 authentication
• Encrypted data transmission
• No credentials stored in Muin
• Audit logging of all syncs

Access Control

Control who can:

• Configure integration
• View sync status
• Trigger manual syncs
• Resolve conflicts

Disconnecting

To disconnect QuickBooks:

1. Go to Settings → Integrations → QuickBooks
2. Click Disconnect
3. Confirm disconnection
4. Existing data remains but stops syncing

---

Best Practices

Initial Setup

1. Plan your mappings - Before connecting, know how you want data organized
2. Start with manual sync - Verify before enabling auto
3. Test thoroughly - Create test records and verify
4. Document decisions - Record your mapping choices

Ongoing Management

1. Monitor regularly - Check sync status weekly
2. Address errors promptly - Don’t let failures accumulate
3. Review mappings - Update as accounts change
4. Keep both systems current - Don’t let data drift

---

Troubleshooting

”Connection Expired”

OAuth tokens expire periodically:

1. Go to integration settings
2. Click Reconnect
3. Re-authorize access
4. Connection restores

”Vendor Not Found”

When vendor matching fails:

1. Check vendor name spelling
2. Review mapping settings
3. Create manual mapping
4. Or create new vendor in QB

”Sync Stuck”

If sync seems frozen:

1. Check last sync time
2. Review pending queue
3. Try manual sync
4. Contact support if needed

---

Next Steps

• Xero Integration - Alternative accounting (coming soon)
• Building Workflows - Automate around syncs
• Invoices - Invoice processing in Muin