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

Every Transaction.
Eight Steps. Every Time.

A connector moves data. Webgility reconciles it. Follow a single Shopify order as it travels through all eight steps — from the moment it's captured at the channel to the certified close your CPA can hand to anyone.

01
Order Captured

Every Order, Every Channel, Goes In.

The moment a customer completes a purchase on Shopify, Amazon, Walmart, TikTok, or any of 50+ connected channels, Webgility captures it at the transaction level. Not a summary. The order, with every fee, every line item, every SKU — recorded before any human has touched it.

480+ pre-built accounting rules determine exactly how that order will be classified. The channel doesn't matter. The volume doesn't matter. The rules run every time.

Multi-Channel Ingest · Live
01 / 08
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
02
Order Normalized

Channel Language Unpacked into Your Chart of Accounts.

Every channel packages order data differently. Webgility translates each one into your accounting structure — mapping sales income, shipping income, fees, taxes, and COGS to the exact accounts you've configured. Nothing goes to a catch-all. Every dollar has a home.

One order. Six accounts. Zero ambiguity about where any of it lives in QuickBooks.

Order #4471 · Exploded Receipt
02 / 08
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
03
Inventory Updated

Quantities Adjust Across Every Warehouse and Channel.

Every fulfilled order triggers an inventory decrement in QuickBooks, across every active sales channel, and against your warehouse count — in near real time. Your available-to-sell number stays current, not an approximation based on yesterday's sync.

No channel is left behind. Shopify, Amazon, Walmart, eBay — all in sync before the next order can oversell.

Inventory visibility →
Inventory Sync · SKU AFF-GG
03 / 08
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
04
Journal Posted

A Balanced Double-Entry Journal, Posted Automatically.

Every transaction produces a properly balanced journal entry — debit and credit sides equal, every component classified to the correct account. Sales income, shipping income, fees, COGS, sales tax payable. Posted in 14 minutes, not at the end of the month.

This is what makes real-time P&L possible. The books stay current because the entries post as transactions happen.

Journal Entry · Order #4471 · QBO
04 / 08
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
05
Experts Review

Human Eyes on Every Exception, Before It Closes.

Automation handles the 99.9%. Specialists handle the rest. Every flagged exception — fee restructures, reserve holds, unmatched credits, wrong-period invoices — is reviewed, resolved, and documented with an audit trail attached. Nothing carries forward to suspense.

When you close the month, you know every exception has a human signature on it.

The human-verified close →
Exception Pipeline · May 2026
05 / 08
3,307
TOTAL RECORDS
AUTO-PROCESSED
4
FLAGGED
FOR REVIEW
4
RESOLVED
BY SARAH K.
0
IN SUSPENSE
BOOKS CLEAN
RESOLVED
Amazon fee restructure mid-period · 3 invoices reclassified
RESOLVED
Reserve held 22 days past release · clearing entry posted
RESOLVED
TikTok marketplace credit no match · credit note issued
RESOLVED
B2B invoice wrong period · reversed and reposted to May
0 IN SUSPENSE · 0 CARRIED FORWARD · AUDIT TRAIL ATTACHED
06
Settlement Reconciled

Every Payout Matched to Its Source Orders.

When a settlement arrives, Webgility already has the matching journal entries. Every order in that payout period, every fee deducted, every refund applied — reconciled line by line, so the deposit in your bank matches the entry in QuickBooks to the penny.

No manual matching. No suspense entries. The ledger was ready before the bank deposit arrived.

Cash flow visibility →
Shopify Settlement · May 16-31
06 / 08
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
07
Books Certified

Closed, Reviewed, and Certified — Every Month.

The close is not complete until a Webgility specialist signs off. Every transaction reconciled. Every exception resolved. Your books close certified — not approximated, not manually assembled by your team, certified — with a full audit trail you can hand to any CPA or investor.

Not an estimate. Not a best effort. A signature.

Certified close →
Books Certified · May 2026
07 / 08
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
08
Reports Delivered

The Numbers That Change How You Operate.

Channel margin, SKU-level performance, cash position adjusted for settlement timing, and a complete exception resolution log. Operational intelligence from books you can trust — not from a dashboard that has its own version of reality.

When every step has run, these numbers are authoritative. Not because the dashboard says so — because the reconciliation behind them is certified.

Why this visibility matters →
Operational Reports · May 2026
08 / 08
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
Pipeline Complete
3,307
Transactions
8
Steps Run
0
In Suspense
100%
Reconciled
Certified by Sarah K., Webgility Close Specialist · 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 ✓