How the Web Connector works
QuickBooks Desktop has no cloud address for a POS to call. Intuit's free Web Connector runs on the same Windows PC as QuickBooks and checks in with the POS on a schedule, every few minutes or as often as you set. Each time, it asks what is waiting and passes those records into the company file. Nothing happens while the PC is off, asleep or logged out, so choose a PC that stays on.
The POS gives you a small .qwc file that tells the Web Connector where to connect. You add the file, enter the password from the POS, approve access once in QuickBooks, and tick the schedule.
Per sale or per day
The biggest decision is how much detail goes into QuickBooks. One invoice per sale gives full detail but creates thousands of transactions a month for a busy restaurant. One summary per day, grouped by product or by category, keeps the books readable and is what most accountants prefer for a high-volume counter. Decide with your accountant before the first sync, because changing later means cleaning up what was already sent.
Refunds need a decision too: refund straight away (a credit memo and refund cheque) or keep the amount as a credit on the customer.
Mapping is where accuracy is won
Every kind of money the POS records has to land somewhere in QuickBooks: sales income, cost of goods, inventory, discounts, tips, shipping, packing charges, card surcharges and rounding. Each tax rate needs a matching QuickBooks tax item or code. Map these once, carefully, with your accountant. Most sync errors come from a missing or mismatched mapping, not from the connector itself.
In QuickBooks, turn off 'Automatically apply payments' so the POS controls which invoice each payment applies to.
Send in order and check
Send products and customers before sales, because a sale cannot refer to an item QuickBooks does not have yet. Then send sales, then suppliers, purchases and expenses. After each step, open QuickBooks and look at a few records. Once the daily sync is running, check weekly for failures and compare the POS sales report with QuickBooks for the same dates.
Doing it in SeroPOS
SeroPOS connects to QuickBooks Desktop 2021 or later (Pro, Premier or Enterprise, Canadian or US edition) on the Pro plan. Everything is under QuickBooks in the back office sidebar, from the dashboard's Desktop card.
- Setup guide: five steps to create the connection, download the .qwc, add it to the Web Connector, enter the password and tick the every-minute schedule.
- Connection: create the connection, download the .qwc, regenerate the password, and see when the Web Connector last checked in. A company-file fingerprint stops data going to the wrong file.
- Accounts & items: fetch the QuickBooks catalogue, then map or 'Create everything in QuickBooks', including income, COGS, inventory, discount, tip, shipping, packing, surcharge and rounding.
- Taxes: 'Build my tax structure in QuickBooks' creates tax items, groups and codes; mapping is by rate, with a warning on any mismatch.
- Invoices & refunds: one invoice per sale, or one per day grouped by product or by category; refund right away or keep as a credit.
- Send data: products, customers, invoices (or Day-end with a preview), suppliers, purchases and expenses, in that order.
- Health: what is holding the sync up, a pre-flight check of mapped names, retry failed, and an inventory check that compares stock with QuickBooks.