KeyPost checks each order before it touches your books, posts it to QuickBooks Desktop or Enterprise, and writes the same verified record to an Excel workbook your controller can reconcile against. Payouts, fees and refunds included.
A Foundry Key Nexus client ran their store on Shopify and their books on QuickBooks Desktop. Every order was keyed in by hand. Typos crept into totals, a few orders got entered twice, and month-end meant chasing differences between the Shopify payout report and the bank.
We built an integration that captured each order, checked it, and posted it once. KeyPost is that integration, rebuilt as a product with the review queue, payout matching and Excel output the client asked for once the manual work went away.
Each checkpoint is recorded on its own, so a dropped connection or a re-run picks up where it stopped instead of starting over.
Shopify sends the order by webhook. KeyPost keeps the original payload untouched, along with its payment and fulfillment status, so there is always a source record to point back to.
Every SKU must map to a QuickBooks item, and lines plus tax, shipping and discounts must equal the order total. Anything that fails waits in a review queue with the reason spelled out.
Customers are matched by email first. Names and addresses are trimmed to fit QuickBooks Desktop's 41-character field limits, and customer type and class carry over.
Paid orders become Sales Receipts or Sales Orders with payment applied. Unpaid orders become Estimates. QuickBooks Web Connector delivers each one and confirms the transaction ID back.
Shopify Payments payouts post as deposits with processing fees split to their own account. Refunds post as credit memos tied to the original sale.
The same verified record lands in an .xlsx with Orders, Customers, Refunds and Payouts tabs, plus a monthly tie-out sheet comparing Shopify, QuickBooks and the bank.
Posting rules are set during onboarding to match how your accountant already works. These are the defaults.
| In Shopify | In QuickBooks Desktop / Enterprise | In the Excel workbook |
|---|---|---|
| Paid order | Sales Receipt, or Sales Order + Receive Payment | Orders tab, status Posted |
| Unpaid or pending order | Estimate | Orders tab, status Open |
| Customermatched by email | Customer, with type and class | Customers tab |
| Shipping, discounts, gift cards | Shipping, discount and gift card items on the transaction | Line detail columns |
| Sales tax | Sales tax item per jurisdiction | Tax column by state |
| Refund | Credit Memo + refund to original payment | Refunds tab |
| Shopify Payments payout | Deposit, fees to Merchant Fees | Payouts tab + monthly tie-out |
Most Shopify to QuickBooks Desktop tools focus on getting orders in without duplicates. KeyPost does that, then closes the loop on cash and gives finance a workbook to check it against.
| Capability | Typical order connector | KeyPost |
|---|---|---|
| Duplicate protection on retries and re-runs | Yes | Yes, per checkpoint |
| Customer matching within Desktop field limits | Yes | Yes |
| Blocks posting on unmapped SKUs or total mismatches | Varies | Yes, with review queue |
| Refunds as linked credit memos | Varies | Yes |
| Payouts posted as deposits with fees split out | Usually not | Yes |
| Excel workbook and monthly tie-out | No | Yes |
| Set up and mapped by the engineer who built it | Self-serve or ticket queue | Yes, direct access |
Every checkpoint carries its own key. If Web Connector times out mid-sync, the next run sees what already landed and skips it.
An order that fails validation stays in the queue until someone fixes the mapping or overrides it. The override is logged with who and when.
From any QuickBooks transaction or Excel row you can open the original Shopify payload and the full posting history.
Held orders and failed syncs send a notice to email or Slack with a direct link to the item in the queue.
Pick a plan by monthly order volume. Every plan includes the pre-post checks, duplicate protection and direct access to the engineer who set it up.
We review your chart of accounts, items and tax codes and agree on posting rules in writing.
KeyPost posts to a copy of your company file and the workbook while you keep entering by hand. We compare the two.
Manual entry stops. You get the review queue, alerts, and a monthly check-in for the first quarter.
Only QuickBooks Web Connector, the free Intuit utility that ships with QuickBooks Desktop. It runs on the computer or server that hosts your company file and checks in with KeyPost on a schedule you set.
QuickBooks Desktop Pro, Premier and Enterprise, including hosted setups that allow Web Connector. We confirm your exact version and year on the mapping call.
Yes. Some teams start with the workbook only, to check the numbers for a month, and turn on QuickBooks posting after. Others keep the workbook as an independent check on the books.
We can backfill a date range during the parallel run. Orders already entered by hand are matched and skipped so nothing is doubled.
Shopify is the standard connector. Other order sources can be scoped as a custom project by Foundry Key Nexus.
Send us a month of Shopify orders and your item list. We will show you how they would post before you commit to anything.