QuickBooks Integration in DreamzCMMS

DreamzCMMS QuickBooks Integration syncs key finance data between DreamzCMMS and QuickBooks Online, reducing double entry and keeping your operations and finance aligned.

Overview

The QuickBooks Integration in DreamzCMMS enables seamless synchronization of financial data across both platforms. The integration supports one-way sync from QuickBooks to DreamzCMMS for Chart of Accounts and Tax data, and two-way sync for Customers, Items, and Vendors. Transactions such as sales invoices, purchase invoices, payments, and expenses are also synced to keep both systems current without manual re-entry.

The sync flow summary is as follows:

• One-way sync (QuickBooks → DreamzCMMS): Chart of Accounts, Tax — sync these first.
• Two-way sync: Customers, Items, Vendors — changes in either system sync automatically.
• Sales Invoices: DreamzCMMS → QuickBooks.
• Payments: QuickBooks → DreamzCMMS (manual or auto scheduler).
• Purchase Invoices / Bills: DreamzCMMS → QuickBooks.
• Expenses: DreamzCMMS → QuickBooks (as journal entries).

Here is a reference video:

Instruction Manual

A) Prerequisites

In QuickBooks Online, keep the following credentials ready before proceeding:

• Client ID
• Client Secret
• Realm ID (Company ID)

Ensure you have the ability to add a Redirect URL in your QuickBooks app settings before proceeding with the configuration.

B) Enable & Configure QuickBooks in DreamzCMMS

1. Log in to DreamzCMMS as an Admin.
2. Go to Settings.
3. Open Configuration → System Configuration.
4. Navigate to QuickBooks Settings.
5. Set QuickBooks Enabled = Yes.
6. Enter your Client ID, Client Secret, and Realm ID / Company ID.
7. Copy the Redirect URL shown in DreamzCMMS and paste it into your QuickBooks App configuration.
8. Select the Environment: 
   • Sandbox — for demo or testing purposes
   • Production — for live use
9. Confirm the Base URL auto-populates.
10. Click Test Connection. If successful, proceed to the Sync Master Data page.

C) Sync Master Data

Important: Always sync Chart of Accounts (COA) and Tax first before syncing any other data.

1. On the QuickBooks Sync page, click Sync for Chart of Accounts (COA). Confirm the prompt and wait for completion. Click View to verify accounts have been imported.
2. Click Sync for Tax. Confirm and wait for completion. Click View to verify tax rates have been imported.

D) Sync Two-Way Masters (Customers, Items, Vendors)

1) Customers (Two-way)

• Click Sync Customers to pull customers from QuickBooks.
• Click View and confirm that QuickBooks Status = Yes and a QB ID appears for each customer.
• (Optional test) Create or edit a customer in DreamzCMMS and verify it syncs to QuickBooks.

2) Items / Inventory (Two-way)

• Click Sync Items.
• Go to Inventory → Inventory List (or click View) to confirm QB Status and QB ID are populated.
• When creating a new item in DreamzCMMS, select the Income Account, Expense Account, and Asset Account, then save. Confirm a QuickBooks ID is generated after the sync.

3) Vendors (Two-way)

• Click Sync Vendors.
• Click View to open the Business List.
• Add or edit a vendor in DreamzCMMS and confirm the QuickBooks Status = Yes with a QB ID assigned.

E) Sales Invoice Sync (DreamzCMMS → QuickBooks)

1. Go to App & Service → Invoice.
2. Click New Invoice.
3. Select a Customer synced with QuickBooks and Items synced with QuickBooks.
4. Save the invoice.
5. In the invoice list, verify QuickBooks Sync Status = Yes and a QB ID is shown.

F) Payment Sync (QuickBooks → DreamzCMMS)

1. In QuickBooks, open the invoice and Record Payment (partial or full).
2. In DreamzCMMS, go to the QuickBooks Sync page and click Sync (payment/status update).
3. Go back to the Invoice List and refresh. Verify the Paid Amount and Balance have been updated.
4. (Optional) Check the Payment Log for detailed payment records.

Note: Payment sync can also run automatically via the scheduler approximately every 30 minutes.

G) Purchase Invoice / Bill Sync (DreamzCMMS → QuickBooks)

1. Go to Purchasing → Purchase Invoice.
2. Click New Invoice.
3. Select a Vendor synced with QuickBooks.
4. Add Items and the received quantity, then Save.
5. Verify QuickBooks Sync Status = Yes and a QB ID is shown.
6. In QuickBooks, confirm the Bill appears correctly.

H) Expense Sync (DreamzCMMS → QuickBooks as Journal Entry)

1. Create an Expense from the Expense navigator, or against an Invoice / Work Order / Job.
2. Select the vendor/business, date, and amount, then Save.
3. In the Expense list, verify QuickBooks Status = Yes with a QB ID.
4. In QuickBooks, confirm the expense appears in the Journal / Journal Report.
5. Ensure Debit/Credit accounts are configured in QuickBooks settings, as these are used for journal posting.

Tips for QuickBooks Integration

• Always sync Chart of Accounts and Tax first before syncing customers, items, or vendors. Skipping this order can cause mapping errors in transactions.
• Use Sandbox environment during initial setup and testing to avoid affecting live QuickBooks data before you are confident the integration is configured correctly.
• When creating new items in DreamzCMMS, always assign the correct Income, Expense, and Asset accounts to ensure accurate journal postings in QuickBooks.
• Enable the automatic payment sync scheduler to keep invoice payment statuses updated in DreamzCMMS without needing to trigger manual syncs every time.
• After any sync operation, always click View to verify records have been imported correctly and that QuickBooks Status and QB ID fields are populated as expected.
• Confirm that Debit/Credit accounts are properly configured in QuickBooks settings before syncing expenses, to ensure journal entries post correctly.

Frequently Asked Questions

Where do I configure the QuickBooks integration in DreamzCMMS?
Go to Settings → Configuration → System Configuration → QuickBooks Settings. Set QuickBooks Enabled to Yes and enter your Client ID, Client Secret, and Realm ID. Copy the Redirect URL from DreamzCMMS and paste it into your QuickBooks app configuration.

What data needs to be synced first before anything else?
Chart of Accounts (COA) and Tax must be synced first. These are one-way syncs from QuickBooks to DreamzCMMS and must be completed before syncing customers, items, vendors, or any transactions.

Which data syncs in both directions between DreamzCMMS and QuickBooks?
Customers, Items, and Vendors are two-way synced — changes made in either DreamzCMMS or QuickBooks will be reflected in the other system.

How do payments recorded in QuickBooks reflect in DreamzCMMS?
After recording a payment in QuickBooks, go to the QuickBooks Sync page in DreamzCMMS and click Sync to update the payment status. Alternatively, enable the automatic scheduler to sync payments approximately every 30 minutes.

How do expenses in DreamzCMMS appear in QuickBooks?
Expenses created in DreamzCMMS are synced to QuickBooks as journal entries. Ensure the Debit and Credit accounts are properly configured in QuickBooks settings for correct journal posting.

Related Articles

• Configure Price Book For Services And Materials
• Configure Service Agreement Pricing
• Create Estimates and Estimate Listing
• How to Create Jobs
• Invoicing from App