Your Shopify & Amazon numbers shouldn't need 12 spreadsheets to make sense.
I build QuickBooks Online accounting automations for ecommerce sellers — so your payouts reconcile, your fees are separated, your real margin is visible, and you finally know what your store is actually making.
Ecommerce Accounting OS
Payouts → QuickBooks Profit Report
Messy inputs
QuickBooks report
Profit clarity
Sales
$142.8K
Fees
$8.4K
Refunds
$3.1K
COGS
$61.9K
Net Profit
$34.7K
Margin
24.3%
Here's what's actually broken
QuickBooks isn’t the problem.
The problem is expecting QuickBooks to understand ecommerce payouts by itself.
QuickBooks is great as your accounting system. But it doesn’t know what’s inside a Shopify payout, Amazon settlement, or Stripe transfer. That’s where ecommerce books break.
“Shopify deposit — $38,742”
Gross sales, refunds, discounts, gift cards, taxes, processor fees, timing differences
“Amazon deposit — $51,300”
Sales, FBA fees, referral fees, storage, ads, reimbursements, refunds, reserves, marketplace tax
“Stripe payout — $12,900”
Charges, refunds, disputes, fees, reserves, payout timing
“Supplier payment — $25,000”
Inventory deposit, balance payment, freight, duties, landed cost, prepaid inventory
“Sales tax payable”
Seller-collected tax, marketplace-collected tax, refunded tax, filing timing, nexus exposure
Sound familiar?
Your books aren't messy because you're careless. Ecommerce accounting is just built differently.
A regular bookkeeper reconciles a bank account. You need someone who reconciles payouts, processors, inventory, refunds, fees, gift cards, sales tax, and marketplace settlements — all at once.
Shopify says one number. QuickBooks says another.
Your store shows $200K in sales, but QuickBooks only shows the net deposits. Discounts, refunds, taxes, gift cards, and Shopify fees are hiding inside every payout.
Amazon settlements feel impossible to decode.
One Amazon payout can include product sales, FBA fees, referral fees, storage, refunds, reimbursements, tax, reserves, and ad deductions. If it's posted as one deposit — your margin is fiction.
Sales tax is sitting in the wrong place.
Marketplace-collected tax, Shopify-collected tax, refunded tax, and state-by-state nexus — all mixed together. That's how scary tax notices happen.
P&L says "profitable," but cash feels tight.
Inventory deposits, ad spend, processor reserves, chargebacks, and supplier payments drain cash even when revenue is growing. Your P&L won't warn you fast enough.
You don't know your real product margin.
Factory cost isn't true COGS. Add freight, duties, tariffs, packaging, 3PL receiving, Amazon adjustments, damaged units, and returns — that's your real number.
Month-end close is a spreadsheet marathon.
You're exporting from Shopify, Amazon, Stripe, PayPal, your 3PL, bank, tax tool, and ad platforms — then stitching them together manually before your CPA asks questions.
Services
Built for ecommerce complexity.
From messy payout data to unclear margins — every service is designed to give business owners a cleaner financial operating system.
Clean Monthly Books
Accurate close, payout reconciliations, COGS, fees, refunds, and inventory-aware reporting — every single month.
Marketplace Clarity
Shopify, Amazon, Stripe, PayPal, and ad spend organized into numbers you can actually trust and act on.
Automation Systems
Custom n8n workflows, dashboards, and reporting automations that quietly cut your manual admin work in half.
CFO Insights
Margin analysis, cash flow visibility, and growth decisions backed by clean financial data — not gut feel.
Mary Anne Bantog
Ecommerce Bookkeeper · Certified Bookkeeper
About me
Your store deserves a bookkeeper who gets ecommerce.
I'm Mary Anne, a Certified Bookkeeper with 13+ years of accounting experience supporting 100+ US and international clients. My focus is helping Shopify and Amazon sellers turn complicated transactions into clean books and a clearer picture of profit.
From Shopify payouts and Amazon settlements to fees, refunds, inventory costs, and month-end close, I connect the details in QuickBooks Online—so you can see what your store is really earning. I pair hands-on bookkeeping with practical automation, keeping your books accurate before making the process faster.
- Years Accounting Experience
- 13+
- Years Accounting Experience
- Clients Supported
- 100+
- Clients Supported
- Accounting / Project Hours
- 8,000+
- Accounting / Project Hours
- Accounting Learners Trained
- 14,000+
- Accounting Learners Trained
What I automate · Real n8n workflows
8 ecommerce automations I've actually built.
Every workflow below is a real n8n build — not a template. Each one runs quietly in the background and pushes clean, accounting-ready data into QuickBooks.
Shopify Payout Reconciliation
Before
Shopify deposits recorded as Sales. Nothing ties to the bank.
After
Each payout splits into gross sales, refunds, discounts, gift cards, tax, and fees — posted to QuickBooks through a clearing account.
Amazon Settlement Decoder
Before
Amazon payouts are one lump sum. FBA fees, refunds, reimbursements, and reserves are invisible.
After
Settlement data is mapped line by line into QuickBooks — separate accounts for sales, fees, refunds, reimbursements, tax, and reserves.
Stripe & PayPal Clearing
Before
Processor deposits never match sales reports. Someone exports CSVs and hunts for differences.
After
Payouts matched to charges, refunds, disputes, and fees before hitting QuickBooks. You know what cleared, what's pending, and what's leaking.
Sales Tax Separator
Before
Marketplace-collected and seller-collected tax get mixed into revenue or one generic liability.
After
Marketplace facilitator tax separated from seller-collected tax, with a state-level review dashboard.
Landed Cost & COGS Engine
Before
Supplier cost, freight, duties, tariffs, and 3PL fees scattered across invoices and spreadsheets.
After
Shipment costs allocated by SKU with month-end inventory/COGS entries auto-posted to QuickBooks. You price based on real margin.
Expense Auto-Categorizer
Before
Klaviyo, Gorgias, ShipStation, Route, Triple Whale — all coded randomly as software or marketing.
After
Ecommerce vendors categorized by function: marketing, retention, fulfillment, support, analytics, payment fees.
Weekly Cash Dashboard
Before
You check your bank balance and hope it covers inventory, ads, payroll, and supplier payments.
After
Weekly view of cash on hand + pending payouts + open bills + ad commitments + inventory payments. See problems before they're emergencies.
CPA-Ready Close Binder
Before
Tax time means hunting through Gmail, Shopify, Amazon, and 6 other platforms for documents.
After
Every month gets a close binder: QuickBooks reports, payout summaries, inventory schedules, tax support, and missing-document alerts.
The process
A clear path from chaos to control.
A practical workflow that turns scattered transactions into reliable monthly insights — without overhauling your business.
Diagnose the books
Free audit of your QuickBooks file, sales channels, payout flow, and inventory setup. We find the leaks.
Clean up the data
Cleanup, catch-up, account remapping, and channel separation — so books are accurate before automating.
Automate reporting
Custom n8n workflows wired to Shopify, Amazon, Stripe, PayPal, QuickBooks, and your inventory tools.
Review growth decisions
Weekly dashboards and monthly insights so you make growth decisions backed by clean data — not guesses.
Results
From the people I've worked with.
They came in stressed about their books. They left with systems that actually work.
“Excellent to work with; extremely responsive / cooperative. Very talented / skilled. Highly recommended and would definitely hire again!”
“Mary was very flexible and very responsive. She knows QuickBooks very well and was willing to learn customized tasks as needed.”
“Mary is a great bookkeeper and effective communicator. Highly recommended”
“Quick and thorough, very knowledgeable in her field. Hardworking and excellent character that is rare to find.”
“I am extremely pleased with Mary's services. Highly recommended and very experienced, patient and communicative. Thank you very much for the great job.”
“Mary Anne was a pleasure to work with! She straightened out our books, including a migration from Xero back to Quickbooks faster than expected. Great communication and my books now look clean and organized. Highly recommend!”
Your tools, connected
I work with the tools your business already uses.
No new dashboards to babysit. I connect systems behind the scenes so QuickBooks receives clean, accounting-ready data.
QuickBooks Online
Your ledger, reports, bank feeds, reconciliations, and financial statements.
Shopify
Sales, discounts, refunds, gift cards, tax, payout summaries, and order data.
Amazon Seller Central
Settlements, FBA/referral/storage fees, refunds, reimbursements, reserves.
Stripe & PayPal
Charges, refunds, disputes, fees, reserves, payouts, and deposit matching.
A2X / Synder
Settlement summaries, payout mappings, and QuickBooks posting review.
TaxJar / Avalara
Sales tax reports, nexus tracking, and filing support.
Inventory Tools
Cin7, Finale, Inventory Planner — stock levels, SKU cost, and COGS support.
Hubdoc / Dext / Google Drive
Receipts, supplier invoices, tax support docs, and close binders.
I don't connect apps blindly. Bad syncs create duplicate sales, wrong tax, and broken reconciliations. My approach: map first, test second, automate third, review always.
What you'll see every week
Every Monday, you'll know the numbers that actually matter.
Not just sales are up. The numbers that tell you whether growth is profitable, cash is safe, and inventory decisions make sense.
Net Sales by Channel
Cash + Pending Payouts
Contribution Margin %
Ad Spend % & MER
Refund & Return Rate
Top SKU Margin Movers
Inventory Days on Hand
30-Day Cash Risk
Credentials
Certified where it counts.
Not just QuickBooks — I hold certifications across the full ecommerce accounting ecosystem.
FAQ
Questions sellers ask before fixing their books.
You can handle simple bookkeeping yourself for a while. The problem is that ecommerce accounting isn't just bank categorization. Once Shopify, Amazon, Stripe, inventory, and sales tax are all involved, the risk isn't falling behind — it's that the numbers look clean but are actually wrong.
You may not need to replace them. Many general bookkeepers are great at normal QuickBooks work but don't know ecommerce settlement accounting. I can handle the ecommerce layer and give your current bookkeeper a cleaner system to work from.
I don't blindly push data into QuickBooks. I map accounts first, test workflows, use duplicate checks, stage entries before posting, and route exceptions for review.
Nope. The automations run behind the scenes. You see the outputs: clean QuickBooks entries, exception alerts, dashboards, and monthly reports.
That's normal. I usually begin with a diagnostic review, then decide whether you need cleanup, automation setup, or both.
Pricing depends on your channels, revenue volume, inventory complexity, tax exposure, and cleanup needs. I offer a free initial consultation to scope it out.
Free diagnostic review
Every month you wait, the cleanup gets bigger.
Start with one free review. I'll look at your QuickBooks file, sales channels, payout flow, and current reporting — then show you where the biggest leaks are.
No pressure. No sales pitch. Just a clear-eyed look at your ecommerce accounting.