Two ways · Your choice

Download a file, or sync automatically.

Not every dealership manages its books the same way—which is why QuickBooks integration is included at no additional cost with every BCC Online Store. Choose the workflow that fits your business: start by downloading a QuickBooks file to review your sales, then switch to automatic QuickBooks Online syncing whenever you're ready. Both options are always available, so you're never locked into one approach.

Method 01

Download a file

Generate, import, done. No connection.

  • IIF for QuickBooks Desktop
  • CSV for QuickBooks Online or any importer
  • Pick the format at the moment you download
  • Regenerated on demand — identical bytes every time
  • No OAuth, no keys, no scheduling
quickbooks-sales-20260702-1430.csv
Best when your accountant handles imports
You’re not locked in. The two methods live side by side. Start with downloads while you get comfortable, then flip on auto-sync when you’re ready — or keep grabbing a file any time you want one, even for a store that’s already syncing.
Books that actually balance

Six categories. One clean entry.

Every order becomes a balanced double-entry General Journal — the kind accountants trust. Each part of the sale lands in the account it belongs in, every entry is forced to balance to zero, and any rounding penny is tucked into the sales line so the entry never breaks.

DEBIT

Cash received

Undeposited Funds

order_total + card surcharge — matches what actually hits your bank.

DEBIT

Discounts given

Sales Discounts

Every promo you ran, tracked as a contra-revenue debit.

CREDIT

Item sales

Sales

Sub-total of the goods sold — rounding pennies absorbed here.

CREDIT

Sales tax collected

Sales Tax Payable

sale_tax + order_shipping_tax — ready to remit.

CREDIT

Shipping charged

Shipping Income

Shipping revenue kept separate for clean margin analysis.

CREDIT

Card processing fees

Card Processing Fees

Surcharge from payment_transaction — makes cash match the bank.

Three levels of detail. Pick what suits your accountant.

per_order

One entry per order

Full audit trail. Each JournalEntry tagged with the order number as DocNumber.

daily_split

Daily entry, split

One entry per day, split across every account. Tidy but detailed.

Account mapping

Point at your chart of accounts.

The six categories are just the starting point. On every connection, map each one to the real account name in your chart of accounts. On auto-sync, BCC reads your accounts live and auto-matches the closest name — you just confirm or override. If a mapped account doesn’t exist yet, it’s created for you.

Chart of Accounts mappingAuto-matched
Cash received
1200 · Undeposited Fundsexact
Item sales
4000 · Product Revenuesubstring
Sales tax
2200 · Sales Tax Payableexact
Shipping
4100 · Shipping Incomeexact
Discounts
4900 · Sales Discountsexact
Card fees
6300 · Card Processing Feeswill create
Auto-match · find-or-create

Live chart of accounts

On auto-sync, dropdowns are populated by fetching your QuickBooks company’s accounts in real time. Always current, never stale.

Smart auto-match

Picks the closest-named account for each category: exact match first, then substring, then token overlap. Override anything you don’t like.

Find-or-create

Name an account that doesn’t exist yet and BCC creates it in QuickBooks with a sensible type/subtype. No back-and-forth.

File downloads use defaults

The six default account names appear in the file — rename them on import in QuickBooks if your chart uses different names.

Set it and forget it

Nightly sync at 02:30. Or right now.

The automatic sync runs as a platform Scheduled Job — not a spreadsheet, not a cron your IT team has to babysit. Choose daily or monthly, run it now on demand, and rest easy knowing every posted order is tagged with a unique DocNumber so re-runs never create duplicates.

02:30 AMDaily · local time
  • Idempotent by DocNumberSkips any order already posted — safe to re-run.
  • Auto token refresh401 → refresh → retry once. You never see it.
  • Stop & resumeHalts on hard errors; next run picks up where it left off.
  • Encrypted secretsClient secret & tokens stored encrypted, write-only in the UI.
SCHEDULE

Daily or monthly. Or right now.

Pick daily to keep books current with yesterday’s sales. Pick monthly if you close monthly and prefer one big posting. Either way, hit Run sync now whenever you need to catch up.

DailyMonthlyManual
Upcoming
Tomorrow · 02:30 AMnext
Wed · 02:30 AMqueued
Thu · 02:30 AMqueued
Per-run caps: 5,000 orders / 480 seconds
Multi-store

Several stores? No problem.

Run more than one store? BCC won’t force all their sales into one bucket. Organize stores into groups — each group can point to its own QuickBooks company with its own delivery method, its own account mapping, its own schedule. Or keep everything in one company and separate with class tracking. Two presets scaffold the whole thing in a couple of clicks.

Preset A

All together

One group for every store — one QuickBooks company.

Front StreetUptownWarehouse
qbDealership LLCOne QuickBooks company
Add class tracking to keep each store’s numbers separate inside one company.

Separation modes — inside one company

class

Tags each entry with a Class named for the store. Perfect for QuickBooks class-tracking reports.

memo

Prefixes the memo with the store name. Works everywhere; class tracking not required.

none

No separation. All stores blend together in a single ledger — simple and clean.

A clear paper trail

Every run. Every row. Re-download any time.

Every download and every automatic sync is recorded in a history grid — the range of orders, the total, who ran it, and when. Re-download any past row as IIF or CSV. Delete a record and it disappears; your actual order data is never touched.

Export history184 orders synced this month · 0 errors
Order rangeOrdersTotalByDateStatus
#B-48108 – #B-48291184$42,180.32Auto-syncJul 02 · 02:30 AMSentRe-download →
#B-47924 – #B-48107178$38,940.10Auto-syncJul 01 · 02:30 AMSentRe-download →
#B-47800 – #B-47923124$29,412.88Flo D.Jun 30 · 4:12 PMDownloadedRe-download →
#B-47612 – #B-47799188$40,220.55Auto-syncJun 30 · 02:30 AMError · retriedRe-download →
#B-47488 – #B-47611124$27,915.02Auto-syncJun 29 · 02:30 AMSentRe-download →
Errored runs auto-retry on the next scheduled sync. Clean “nothing new” API runs aren’t logged — keeps the grid quiet.

Frequently Asked Questions

Do I have to pay extra for QuickBooks integration?

No. QuickBooks integration is included free with every BCC Online Store, giving you the flexibility to manually export sales or automatically sync with QuickBooks Online.

Do I need QuickBooks Online, or does Desktop work too?

Both work — the two differ only in how the data reaches QuickBooks. For QuickBooks Desktop, download an IIF file and import it. For QuickBooks Online, you can download a CSV, or connect once and let the API auto-sync post every order for you. Automatic sync only works with Online (that’s the version with an API); Desktop is file-import only.

How do I connect QuickBooks Online?

You approve the connection through Intuit’s own secure sign-in (OAuth2). Choose the company you want to connect, and BCC captures the Realm/Company ID automatically. Client secret, refresh token, and access token are stored encrypted; the client secret is write-only in the UI. Auto token refresh means you never re-authorize just because the access token expired.

Why does the cash amount include the card fee?

Because BCC charges the card surcharge on top of the order total, the cash that actually hits your bank is order_total + card_fee. That’s exactly what posts to your Undeposited Funds account — so your recorded cash matches the deposit, instead of coming up a little short every time. The card fee itself posts as a credit to the Card Processing Fees account, keeping the entry balanced.

What happens with rounding pennies?

Every entry is forced to balance to exactly zero. If a rounding penny is left over from tax or discount math, it’s absorbed into the Sales line so the entry never breaks. In practice you’ll rarely see one, but when it happens, it lands in the right place and reconciliation stays clean.

Can I get less detail? My accountant wants a daily summary.

Yes — three detail levels. per_order is one JournalEntry per order (full audit trail, DocNumber = order #). daily_summary is one condensed entry per day with just cash / net sales / tax. daily_split is one entry per day, split across every account — tidy but detailed. Pick per connection.

I run three stores. Can each go to a different QuickBooks company?

Yes. Organize stores into groups, and each group can point to its own QuickBooks company with its own connection, mapping, schedule, and delivery method. Two presets scaffold this: “All together” (one group, one company) or “One per store” (a group per store, a company per store). Every store belongs to exactly one group; a default “All stores” group catches unmapped stores so no order is orphaned.

Or can I keep all stores in one company but separate?

Yes — use a separation mode. class tags each entry with a QuickBooks Class named for the store (requires class tracking to be enabled in your QBO company). memo prefixes the memo with the store name. none keeps everything in a single ledger. Pick per group — you don’t have to make them all the same.

Ready to see what BERNINA Commerce Connection looks like for your store?

Book a free 20-minute demo with a BERNINA specialist. We'll show you exactly how BCC works for a store like yours — no generic presentations, no pressure.



*May require add-on modules.