QuickBooks prerequisites — what to do before connecting

Connecting Suprata to QuickBooks Online is mechanically simple — sign into QuickBooks through Suprata, authorize, done. But the first sync after connecting is the moment of truth: every customer, item, invoice, and payment in Suprata starts pushing to QuickBooks. If your data isn't ready, you'll get duplicates, mismatched accounts, and wrong tax classifications that take days to clean up.

This article covers the five things you need lined up before you click Connect, plus the safety steps that prevent the most expensive mistakes.

When this applies

• First-time QuickBooks connect to a brand-new Suprata account.
• Connecting QuickBooks to a Suprata account that already has historical data.
• Re-connecting after a disconnect (less risky, since prior sync state is usually preserved, but still worth re-checking the prerequisites).

If you're already connected and synced, this article isn't for you — you want QuickBooks first sync walkthrough for ongoing operations.

The five prerequisites

1. A QuickBooks Online account in good standing

You need an active QuickBooks Online subscription. Suprata syncs to QuickBooks Online, not QuickBooks Desktop. If you're on Desktop, you'll need to migrate to Online first (Intuit provides a migration tool).

Within QuickBooks, make sure:

• Your chart of accounts is set up the way you want it. Suprata doesn't create accounts in QB; it maps to existing ones. If you're missing an "Accounts Receivable" account, an "Undeposited Funds" account, or an income account for service revenue, create them in QB first.
• Your sales-tax setup is configured if you charge sales tax. Suprata's tax categories will need to map to QB's tax codes.
• Class tracking is enabled if you plan to use Business Units mapped to QB Classes (Accountant Edition or Plus and above).
• Items don't already exist with the same name as your Suprata pricelist items. Otherwise the first sync creates duplicates with (2) appended to the name.

2. Cleaned-up customer list in Suprata

The first sync pushes every Account from Suprata to QB as a Customer. Two big risks:

• Duplicates. If "ABC Plumbing" exists as three separate Accounts in Suprata (because it was created multiple times by different staff), you'll get three QB Customers. De-dupe in Suprata first.
• Missing or wrong billing addresses. QuickBooks uses the billing address for tax-jurisdiction lookups in some setups. Make sure each Account has a complete, accurate billing address.

Spend an hour running a "Find Duplicates" pass on your Accounts list before connecting. This is much cheaper than cleaning up duplicate Customers in QB after sync.

3. A defined cutoff date for historical data

Decide whether you want Suprata to sync all historical invoices, only recent ones, or none.

• All history. Useful if QB is brand new and Suprata has the truth. Risky if QB also has historical data that would conflict.
• From a specific date forward (the Historical Cutoff Date option). Most common: pick the start of the current fiscal year, or the date you started using Suprata, or the date you completed your last QB-side reconciliation.
• No history, going forward only. Pick a future cutoff (or today). Then only invoices created from that date forward push to QB.

The cutoff date setting is on the QuickBooks Settings screen — you set it before enabling sync.

4. Account, Class, and Payment Method mappings planned out

Suprata sends invoices to QB. QB needs to know:

• Which Income account to credit when an invoice is created.
• Which Accounts Receivable account to use for tracking what's owed.
• Which Undeposited Funds account for payments that aren't yet deposited (optional).
• Which Class to assign (if you use class tracking — typically maps from Suprata's Business Units).
• Which QB Payment Method to record for each Suprata payment method (Stripe → "Credit Card", USIO → "ACH", check → "Check").

You don't have to memorize the QB account names — the wizard pulls them in via dropdown. But you should know what your bookkeeper expects before clicking through. If you're unsure, do this step with your bookkeeper.

5. Backup, backup, backup

Before you connect, take these snapshots:

• A backup of your QuickBooks Online file — Intuit's backup tool (or just an export of your chart of accounts, customers, items, and recent invoices to CSV).
• A note of your QB account balances as of the connect date — you'll want to compare these to QB's balances after the first sync to catch any drift.
• A backup of your Suprata data if your account supports export (your administrator can run this).

You hopefully won't need them. But "we connected and an item collision created weird tax math on 200 invoices" is the kind of thing that happens, and rolling back is much easier with backups.

Where the connection lives

Sidebar: Suprata Settings → Integrations (or wherever Integrations lives in your sidebar). Find the QuickBooks tile, click through to the QuickBooks Settings page.

This is the central hub for everything QB-related: connection status (green banner if connected), entity sync toggles (Customers, Items, Invoices, Payments, Account Credits), historical cutoff date, QB account mappings, business-unit-to-class mappings, payment-method mappings, sync logs, and the advanced reset (which you will, hopefully, never need).

The actual connect step

Once the prerequisites are in place:

1. Click Connect to QuickBooks on the Settings screen.
2. You'll be redirected to Intuit's authorization page.
3. Sign in with the QuickBooks Online owner account (not a delegated user — the owner needs to do this initial connect).
4. Authorize Suprata to access your QB company file.
5. You'll be redirected back to Suprata, and the connection banner should turn green.

The connection is now established but no data has synced yet. Sync only starts after you walk through the setup wizard (next article).

What gets synced once you turn it on

Note: sync is one-way, Suprata → QuickBooks. Changes you make in QuickBooks don't flow back to Suprata. That's on purpose — Suprata is where you run your business day-to-day, and QuickBooks is where the books live. Edits belong in Suprata.

Common prerequisite mistakes

• Connecting before de-duping accounts. Then you have N versions of "ABC Plumbing" in QB, and your bookkeeper has to merge them by hand.
• Skipping the historical cutoff date. Default behavior is "sync everything", which can push thousands of historical invoices to QB and break your historical reconciliation.
• Mapping accounts wrong (e.g., picking "Inventory Asset" as your Income Account because you misclicked). Then revenue is being booked to the wrong place. Fix it in QB Settings, not by changing entries in QB.
• Connecting under a delegated user, not the owner. Some sync operations require owner-level access in QuickBooks. If you connect as a delegated user, certain features silently fail.
• Not backing up before connect. No comment.
• Using QB Desktop and assuming Suprata supports it. It doesn't. Migrate to Online first.

Common downstream mistakes (related but worth flagging)

• Adding new pricelist items in Suprata after connect, expecting them to magically appear in QB. They will sync — automatically — but only after the next sync run picks them up. There's a sync interval (typically every 30 seconds to a few minutes). Watch the sync log if something seems missing.
• Editing an item in QB instead of in Suprata. Edits in QB don't propagate back. Future invoices using that item will use Suprata's version. Keep edits in Suprata.
• Disconnecting and reconnecting to "fix" a sync issue. Almost never the right move — disconnect/reconnect doesn't reset sync state, and reconnecting under a different QB user can create authorization weirdness. Most sync issues are addressable inside the existing connection.

What this article does NOT cover

• The actual setup wizard (account mappings, class mappings, payment-method mappings, sync settings). That's QuickBooks first sync walkthrough.
• Troubleshooting sync errors. A separate article will cover the sync report and common error patterns.
• Sales-tax sync nuances. QB and Suprata handle sales tax differently; if you charge tax, the mapping deserves its own article (forthcoming).

Related articles

• QuickBooks first sync walkthrough
• Picking the right tax category strategy
• The anatomy of an Account vs. a Contact
• Cleaning up duplicate accounts (forthcoming)
• Reading the QuickBooks sync report (forthcoming)