QuickBooks Online Integration

Pointless POS Merchant Portal can post a daily sales summary to QuickBooks Online as a single journal entry. It is not a live, itemized transaction sync — QuickBooks does not receive individual card transactions. Instead, once you build and save a daily summary from a Z-run (end-of-day POS report), you can push that one summary to QuickBooks as one journal entry covering the whole day.

That journal entry records:

• A debit line for each tender type collected that day (Cash, Visa, Mastercard, Amex, Discover, Debit) — posted to whichever QuickBooks account you've mapped it to.
• A credit line for net sales, a credit line for sales tax collected, and a credit line for tips collected — each posted to its own mapped account.

Before any of this can run, two things need to be set up once per location: connecting to QuickBooks, and telling the portal which of your QuickBooks accounts each of those lines should post to.

Who can do this

• Connecting, disconnecting, changing settings, editing account mappings, and syncing all require the Merchant Admin role (or Admin/Staff) for that location.
• Merchant Staff can view connection status and last-sync results, but cannot connect, disconnect, change the mapping, or trigger a sync.

1. Connect the location to QuickBooks

You'll need portal access with permission to edit locations, and a QuickBooks Online login for the company you want to link.

1. Go to Locations, find the location, and click Edit.
2. Scroll to the QuickBooks Integration section. If the location isn't linked yet, you'll see a short note and a Connect QuickBooks button.
3. Click Connect QuickBooks. The button changes to "Redirecting to QuickBooks…" and the portal sends you to QuickBooks' own login page.
4. You're now on QuickBooks' secure site — not the portal. The portal never sees your QuickBooks password. Sign in to your Intuit/QuickBooks account, choose which company to link to this location, and authorize the connection when prompted.
5. QuickBooks sends you back to the portal automatically. The section now shows a green dot, the connected company's name, and an environment badge — production (your real, live QuickBooks company) or sandbox (a test company). Once the first sync runs, a Last synced timestamp and status also appear.

Note: One location links to one QuickBooks company. If you run multiple locations, you'll repeat these steps for each one, choosing the matching QuickBooks company each time. If a location is already connected and you need to link a different company, disconnect first, then connect again.

2. Set up account mapping

QuickBooks requires every journal entry line to point at a specific account in that company's chart of accounts — there's no generic default. This step tells the portal which account each dollar bucket belongs to, in your own words (account names, not internal QuickBooks IDs).

1. With the location connected, still in the Edit Location modal, find the Account Mapping table below the connection status.
2. For each bucket you want included in the sync, type the exact account name as it appears in that QuickBooks company's chart of accounts.
3. Leave a bucket blank to skip it — for example, if a location doesn't track tips separately, leave Tips blank and it simply won't appear in the journal entry.
4. Click Save Mapping.

The nine buckets:

Bucket	Journal side	What it represents
Cash	Debit	Cash collected for the day
Visa	Debit	Visa card sales collected
MasterCard	Debit	Mastercard sales collected
Amex	Debit	American Express sales collected
Discover	Debit	Discover card sales collected
Debit	Debit	Debit card sales collected
Sales	Credit	Net sales (income) for the day
SalesTax	Credit	Sales tax collected (payable)
Tips	Credit	Tips collected (payable to staff, not revenue)

Tip: Account names must match QuickBooks exactly, including capitalization and any sub-account prefix (e.g. "Bank Accounts:Undeposited Funds"). Copy the name directly from QuickBooks' chart of accounts rather than retyping it from memory.

Why itemized by tender type: Some integrations post everything collected as a single "Undeposited Funds" line. This portal instead posts a separate debit line per tender type, so each one can be mapped to its own account if you want that level of detail in QuickBooks — you can also point several tender types at the same account if you don't need them separated.

3. Build and save the daily summary

1. Go to the Financials page.
2. Select the location, choose a date range, and click Load Report IDs.
3. Find the Z-run for the day you want to sync and click Build Summary.
4. Review the numbers — Sales, Tax, Tender, Tips, and Adjustments — and correct Refunds or Buy Back if needed.
5. Click Save Summary. The status badge changes from Draft to Saved.

4. Sync to QuickBooks

1. Once the summary is Saved (or Posted), a Sync to QuickBooks button appears next to Save Summary.
2. Click it. The portal resolves each mapped account name against the connected QuickBooks company, checks that the day's numbers balance (money collected equals sales plus tax plus tips), and posts one journal entry.
3. On success, the journal entry's QuickBooks ID is shown, and the location's Last Synced / Last Sync Status updates.
4. On failure, the specific error is shown on the page — see Troubleshooting below.

Sync status at a glance, on the location's QuickBooks Integration panel:

Status	Meaning
(no badge)	Not synced yet, or the last sync attempt failed before a status could be recorded.
Success	The journal entry posted to QuickBooks. Check the Journal Entries list in QuickBooks for the entry noted in "PrivateNote."
Failed	The sync attempt failed. The error message is shown on the Financials page and saved as Last Sync Error on the location. Common causes are listed below.

Managing the connection

Once connected, the QuickBooks Integration section gives you a few controls:

Control	What it does
Auto-sync on save	When checked, saving changes to this location also pushes an update to QuickBooks. Leave it off if you'd rather sync manually. The change saves immediately when toggled.
Last synced	Shows the date/time of the most recent sync and whether it succeeded.
Disconnect	Unlinks the location from QuickBooks and stops all syncing. You'll be asked to confirm.

Troubleshooting

Problem	What to do
"No QuickBooks account mappings configured for this location."	Open Locations → Edit → QuickBooks Integration → Account Mapping and enter at least one account name, then save, before syncing.
"QuickBooks account 'X' (mapped to Y) was not found in the connected company's chart of accounts."	The account name typed into the mapping table doesn't exactly match an account name in QuickBooks. Open QuickBooks, copy the exact account name (spelling, capitalization, and any parent-account prefix), and re-enter it.
"Daily summary does not balance: tenders collected $X vs. sales + tax + tips $Y"	The Z-run report's numbers don't add up — total cash/card collected doesn't equal net sales plus tax plus tips. Review and correct the daily summary on the Financials page before syncing again.
"QuickBooks token refresh failed. Please reconnect."	The connection to QuickBooks has expired or was revoked (e.g., in QuickBooks' own app settings). Disconnect and reconnect the location.
Sync button is missing	The daily summary is still in Draft status. Save the summary first — the Sync to QuickBooks button appears once it's Saved or Posted.
"Failed to initiate QuickBooks connection."	The portal couldn't reach QuickBooks. Check your internet connection and try Connect QuickBooks again.
You're not redirected back / the section still says "not connected"	The QuickBooks authorization may not have completed. Re-open the location and click Connect QuickBooks to retry.
Last sync shows an error status	The last sync didn't finish. Re-save the location (with auto-sync on) or contact your administrator if it keeps failing.
Badge says "sandbox" but you expected live data	You linked a test company. Disconnect and reconnect, choosing your real (production) company.
Wrong company linked	Click Disconnect, then Connect QuickBooks again and select the correct company.

Disconnecting

Open Locations → Edit → QuickBooks Integration and click Disconnect. Confirm when asked ("Disconnect QuickBooks from [location]? This will stop syncing."). This removes the stored connection and tokens; it does not delete anything already posted in QuickBooks, and it does not clear the saved account mapping — reconnecting the same or a different company will reuse whatever mapping is already saved, so double-check the account names still apply if you reconnect to a different company.

What this does not do

• It does not sync individual card transactions or invoices — only one daily summary journal entry per Z-run.
• It does not reconcile QuickBooks' bank deposits against the actual bank statement — that still happens in QuickBooks as usual, using whatever account you mapped the tender types to (commonly "Undeposited Funds").
• It does not automatically retry a failed sync — fix the underlying issue (mapping, balance, or connection) and click Sync to QuickBooks again.