How automatic QuickBooks Online sync works

If you manage your business's QuickBooks Online integration, this article explains how WellnessLiving syncs your transactions to QuickBooks every day, so you know what to expect once you're up and running.

Instead of exporting reports or uploading spreadsheets, WellnessLiving posts every transaction directly to QuickBooks once a day. Your books stay current automatically, so you don't have to touch a spreadsheet to keep your records accurate.

Key tips

Only staff members with the Configure QuickBooks Online settings permission enabled can access this integration.
You'll need to have already set up your QuickBooks Online integration for the daily sync to run.
You can also trigger a sync manually at any time. For more information, see Monitor your QuickBooks sync status and history.

When does the sync run?

The sync runs once daily at the time you chose while setting up your QuickBooks Online integration. Each run processes all new and updated transactions since the last successful sync.

If a sync fails for any reason, it doesn't skip ahead. The next run picks up from the last successful point, so nothing gets missed.

What gets synced?

Every WellnessLiving transaction type is included in the daily sync:

Sales and immediate payments, posted as Sales Receipts, including any taxes, discounts, surcharges, and tips.
Memberships, posted as Sales Receipts when each successful payment is charged. Every membership renewal creates a new Sales Receipt, one per successful charge. Failed renewal payments don't sync until they're resolved successfully.
Refunds, posted based on the type of the original sale, either as a Refund Receipt or a Credit Memo.
Voided transactions, removed correctly when voided before settlement.
Account balance top-ups, posted as a payment to a liability account (no revenue is recognized at the time of top-up).
Account balance redemptions, posted as a Sales Receipt for the item purchased, with the liability account reduced by the redemption amount.
Gift card purchases, posted as a Sales Receipt that creates a deferred revenue liability, with no tax applied at the time of purchase.
Gift card redemptions, posted as a Sales Receipt for the item purchased, with tax calculated at redemption and the deferred revenue liability reduced.
Late cancel fees, no-show fees, and failed payment fees, posted as Sales Receipts using dedicated utility items. Fees only sync when the fee is successfully collected.
Appointment purchases (such as facials or personal training sessions), posted as Sales Receipts for the service. The appointment's scheduling details, like time, staff, and duration, don't sync to QuickBooks.

Notes:

Discounts reduce the taxable amount, so tax is always calculated on the discounted price.
Split payments preserve each payment method as its own line on the Sales Receipt. For example, if a client pays $80 with a credit card and $30 with a gift card, the Sales Receipt shows two payment lines, one for each method going to its mapped account. Split payments are never merged, even if both methods are mapped to the same account.
Refunds are posted based on the type of the original sale. A refund of a Sales Receipt syncs as a Refund Receipt, with the money returned to the account where the client originally paid. This could be a bank account for card refunds, or a liability account for account balance or gift card refunds. A refund of an Invoice, if your setup includes any, syncs as a Credit Memo linked to the original Invoice.
If a purchase is refunded in more than one step, like a partial refund today and another tomorrow, each refund event creates its own record. They aren't combined, even if they happen on the same day, so you always have a full audit trail of every refund.

What accounting method does the integration use?

The integration syncs using accrual accounting treatment. Gift card sales are recorded as a liability until redeemed, and account balance top-ups are recorded as a liability until spent. This matches standard accounting practice and works alongside QuickBooks' built-in Cash and Accrual reporting views.

If you run your WellnessLiving reports in Cash mode, your gift card and account balance totals may look different between WellnessLiving and QuickBooks. Both are correct, just showing the same activity from a different accounting view.

How are transactions matched to QuickBooks accounts?

During setup, WellnessLiving creates matching product items in your QuickBooks account, one for each product or service you sell, and maps each one to the QuickBooks accounts you've chosen for revenue categories, payment methods, and tax rates. When a transaction syncs, it references the corresponding item, which routes everything to the right place automatically, so you never have to match things up by hand.

But what if something doesn't have its own specific mapping? Say you add a new class type but haven't mapped it to a QuickBooks account yet. That sale doesn't get stuck or fail. It automatically uses your category's default account instead. If there's no category default either, it falls back to your catch-all default account, which you set up during mapping and can't skip.

This means every transaction always has somewhere to go in QuickBooks, even if you haven't mapped every single item by hand.

How are clients handled in QuickBooks?

WellnessLiving doesn't create individual QuickBooks customer records for your clients. Instead, all transactions post against a single shared customer record in QuickBooks (for example, WellnessLiving Sales). This record is created automatically the first time a sync runs.

Your client data stays in WellnessLiving, which remains your source of truth for client information.

Will transactions ever be duplicated?

No. Each transaction gets a unique reference ID when it's posted to QuickBooks. If a sync is retried for any reason, QuickBooks recognizes that ID and skips it, so the same transaction never posts twice.

What isn't included in the sync?

Historical transactions from before you activated the integration
Client profile data
Two-way sync — data only flows from WellnessLiving to QuickBooks