Order-to-close reconciliation workflow

From Order to Certified Books

Webgility reads transactions from your sales channels, applies accounting rules, posts clean entries, reconciles payouts, and, with our certified experts, guarantees that your ecommerce books are ready to trust.

100%
Order-level detail, no summaries
Real-time
Every transaction posted as it happens
8 steps
Every transaction, every time
Certified
Specialist-reviewed close every month
01 / Order Captured Every Order through Every Channel Goes In. Webgility captures every order at the source across Shopify, Amazon, Walmart, TikTok, and 50+ other channels.
02 / Order Normalized Channel Language is Unpacked. Each order maps to your Chart of Accounts. Every fee type, tax line, and SKU routed to the right journal.
03 / Inventory Updated Quantities Adjust in Real Time. Inventory decrements into QuickBooks and back across every channel the moment an order is captured.
04 / Journal Posted Double-Entry, Every Time. Each order component posts as a properly balanced double-entry journal. Every debit has a matching credit.
05 / Experts Review Human Eyes on Every Exception. Specialists review every flagged exception. They resolve, document the resolution, and update your rules. Nothing closes without a verified audit trail.
06 / Settlement Reconciled Payout Matches Orders. Every settlement matched to its orders line by line. The deposit in your bank matches the entry in QuickBooks.
07 / Books Certified Close in Hours, Not Days. Every transaction reconciled. Every exception resolved. Your books close certified, not just reviewed.
08 / Reports Delivered Numbers You Can Act On. Margin by channel, SKU performance, cash position, and any items that required specialist intervention.
SHOPIFY
Order #4471
$52.91 · Nate M.
CAPTURED
$52.91
ORDER #4471 · SHOPIFY
AMAZON
57 orders
this settlement
TIKTOK SHOP
12 orders · this settlement
50+ CHANNELS · 480+ RULES · POSTED IN 14 MIN
ORDER #4471 · EXPLODED RECEIPT $52.91
Grape Gurgle x3
+$13.47
Bacon Cream Soda x2
+$10.98
Birthday Cake Bubble Drops x1
+$17.99
Shipping
+$7.95
Sales Tax NY (8.875%)
+$4.47
Shopify Txn Fee (2.9%+30c)
-$1.95
SKU: AFF-GG · GRAPE GURGLE · GG x3 FULFILLED
531528
SYNC TIME: NEAR REAL-TIME · ALL CHANNELS UPDATED
CHANNELBEFOREDELTAAFTERSTATUS
Shopify 247 -3 244 SYNCED
Amazon FBA 182 0 182 NO CHANGE
Walmart 88 0 88 NO CHANGE
eBay 14 0 14 NO CHANGE
QuickBooks Total 531 -3 528 BALANCED
JOURNAL ENTRY · ORDER #4471 · QBO MAY 16, 09:28 ET · POSTED IN 14 MIN
ACCOUNTDEBITCREDIT
Undeposited Funds Shopify payout $52.91
Shopify Fees Expense $1.95
Cost of Goods Sold AFF-GG x3, AFF-BCS x2, AFF-BDB x1 $22.54
Shopify Sales Income $42.44
Shopify Shipping Income $7.95
Sales Tax Payable, NY $4.47
Inventory (6 units) $22.54
BALANCED · DR $77.40 = CR $77.40
3,307
TOTAL RECORDS
AUTO-PROCESSED
4
FLAGGED
FOR REVIEW
4
RESOLVED
BY SARAH K.
0
IN SUSPENSE
BOOKS CLEAN
FLAGGED
Amazon fee restructure mid-period · 3 invoices reclassified
FLAGGED
Reserve held 22 days past release · clearing entry posted
FLAGGED
TikTok marketplace credit no match · credit note issued
FLAGGED
B2B invoice wrong period · reversed and reposted to May
0 IN SUSPENSE · 0 CARRIED FORWARD · AUDIT TRAIL ATTACHED
SHOPIFY SETTLEMENT · MAY 16-31 2026
$3,200.00
PAYOUT DEPOSITED · MAY 31 · BANK VERIFIED
47 orders (May 16-31) +$3,412.18
Refunds (3 orders) -$112.97
Platform fees (txn + sub) -$99.21
NET PAYOUT $3,200.00
RECONCILED · DEPOSIT MATCHED
BOOKS CERTIFIED · MAY 2026
3,307 / 3,307 transactions reconciled
All channels reconciled to the penny
All payouts matched to settlements
Fee categories verified · current rate schedule
4 / 4 exceptions resolved · 0 in suspense
CHANNEL MARGIN
Shopify
18.2%
Amazon
6.1%
Walmart
14.7%
SKU PERFORMANCE
AFF-S12 (Soda 12pk) +34.8%
AFF-GG-4 (Grape Gurgle) +22.1%
AFF-BCS (Bacon Cream Soda) +12.4%
AFF-HDW (Hot Dog Water) -2.3% WATCH
CLOSE: 3,307 / 3,307 · EXCEPTIONS: 4 / 4 RESOLVED · SUSPENSE: 0 Sarah K. · May 31, 2026
Pre-Post Validation

Nothing posts until it passes.

The moment that separates reconciliation from data transfer is the validation gate. Before any entry reaches your accounting platform, Webgility runs a series of automated checks, comparing amounts against expected values, matching payouts to source orders, flagging anomalies that fall outside normal variance ranges.

Basic connectors post everything and let your accountant find the problems. Webgility finds the problems before they post. The distinction matters: an error in your books compounds. An error caught in validation disappears.

PRE-POST VALIDATION · ORDER #4471
channelShopify
order_total$42.44
shipping_collected$7.95
tax_collected$4.47
platform_fee−$1.95

amount_check✓ PASS, $52.91 reconciled
duplicate_check✓ PASS, no duplicate found
coa_mapping✓ PASS, all 4 components mapped
fee_rate_check✓ PASS, within expected range

status✓ CLEARED FOR POSTING
Dedicated Clearing Accounts

Orders post before the deposit arrives.

Most accounting systems wait for the bank deposit and try to figure out what's in it. Webgility works the other way: every order posts to a dedicated clearing account in QuickBooks for that channel and payment method, so when the deposit arrives, it's already reconciled against a full ledger.

This is what makes real-time visibility real. You're not reading the bank feed — you're reading channel-level accounts that update with every transaction. Cash position, margin by channel, and settlement status are current because the books are current, not because a batch ran overnight.

CLEARING ACCOUNT FLOW · ORDER #AMZ-8823
order_postedAmazon Clearing Account
referral_fee (15%)Marketplace Fees — Amazon
fba_fulfillment_feeFulfillment Expense — FBA
ad_attributionAdvertising — Amazon PPC

[ 14 days later ]Amazon settlement arrives
deposit_amount$3,218.44
clearing_balance$3,218.44

match_status✓ RECONCILED — ledger was ready
suspense_entries✓ 0 — nothing to chase
The Certified Close

Software automates. Specialists certify.

Always-on automation handles every transaction in real time. At the end of every month, a Webgility certified specialist takes over, reviewing the close, reconciling any flagged items, and certifying that your books are complete and accurate.

Continuous

Automated reconciliation

Every order, fee, payout, and refund, processed in real time, 24/7. Pre-post validation runs on every transaction. Anomalies are flagged automatically. Your books stay current without manual intervention.

Monthly

Specialist review

At month-end, a Webgility certified specialist reviews every flagged exception, reconciles payout totals against channel settlement records, and verifies that all transactions have posted correctly to the right accounts.

Certified

Books certified

The close is not complete until the specialist signs off. You receive notification that your books have been reviewed, reconciled, and certified, every order, every fee, every payout accounted for. Not an estimate. Certified books.

What You Get

Three things that change how you operate.

Certified books are not just a compliance deliverable. They're the operational foundation that changes the quality of every decision you make.

Always-on visibility

Every transaction posted in real time means your books reflect current reality, not last week's batch. P&L, inventory position, and cash flow are always current. No waiting for the close to understand where you stand.

Certified monthly close

Every month, your books are reviewed and certified by a Webgility specialist. Not approximated. Not manually reconciled by your team. Certified, with a full audit trail tracing every entry back to the original order.

Decision-grade reporting

Channel-level P&L. Margin by SKU, net of fees and returns. Cash position adjusted for settlement timing. The operational analytics that come from books you can actually trust, not approximations you have to verify before acting on.

The Distinction

This is not sync. This is reconciliation.

A connector moves data. Webgility reconciles it. The difference is not marketing language, it's the operational gap between summary data that looks correct and transaction-level data that is correct. Summary sync tells you Shopify revenue was $14,882 this week. Webgility tells you exactly which orders that came from, what fees were deducted, which refunds were processed, and how the net payout maps to what actually landed in your account.

The difference is visible in two places: the quality of your monthly close, and the quality of the decisions you can make from your books.

Basic sync
Data transferred
  • Revenue summaries by period
  • Fee totals without line-item detail
  • Payouts posted as lump sums
  • No pre-post validation
  • No anomaly detection
  • No specialist review
Webgility reconciliation
Operational truth
  • Every order posted with full line-item detail
  • Every fee classified to correct account
  • Every payout mapped to source orders
  • Pre-post validation on every transaction
  • Anomaly detection flags discrepancies
  • Specialist certifies every monthly close
Explore Sandbox  ·  No Signup Required

See Webgility in Action.

A real instance pre-loaded with sample orders, channels, and accounting entries. Nothing to install. No account needed.

🔒 my-sandbox.webgility.com
Online
CONTACT SALES
PREVIEW MODE
S Shopify Store
Open the Sandbox
Free to explore  ·  No account needed  ·  Sample data only
The Demo

Find out what your operational gaps are actually costing you.

Our team of experts will help surface your operations and finance concerns. In 30 minutes, we will discuss your channels, accounting setup, leakages, inventory inconsistencies, and close process.

Operational Snapshot ● Live
Orders reconciled today 1,247 ✓
Amazon payout tied out $47,241 ✓
Exceptions resolved 3 cleared
Inventory synced All channels ✓
Books status Certified ✓