For E-Commerce Business Owner / Online Sellers ·
What you'll accomplish
Right now, reconciling fees and payouts across Shopify, Amazon, Etsy, or eBay is a monthly chore that's easy to put off, and easy to miss a problem inside. Once your accounts and platform feeds are connected in QuickBooks Online, its built-in AI reviews your profit-and-loss statement automatically and flags things like a shipping cost that jumped 40% month over month, well before tax time instead of at it.
What you'll need
What you should see: A banking dashboard showing recent transactions pulled in from your connected accounts, waiting to be categorized. Troubleshooting: If a bank connection fails, most banks require you to log in through QuickBooks' connection flow directly rather than pasting credentials elsewhere. Never share bank credentials outside that official connection screen.
What you should see: Marketplace payouts appearing in QuickBooks broken into sales, fees, and tax, instead of one unexplained deposit amount. Troubleshooting: If your marketplace payouts show as a single lump sum with no fee breakdown, the connector likely isn't finished syncing yet. Give it a full payout cycle before troubleshooting further.
What you should see: A cleaner transaction list with most items pre-categorized after the first few weeks of use. Troubleshooting: If a suggested category looks wrong, correct it manually. Each correction improves future suggestions.
What you should see: A summary report flagging unusual month-over-month changes, such as a spending category that jumped sharply, with the specific transactions behind the flag listed out. Troubleshooting: If nothing gets flagged in your first weeks, that's normal. The feature needs a few months of transaction history to know what "normal" looks like for your business before it can spot what's abnormal.
What you should see: A short explanation of what changed and the transactions responsible, which you can confirm or dismiss. Troubleshooting: Treat every flag as a starting point, not a final answer. AI flags catch patterns, not intent. A legitimate one-time purchase (new packaging supplies before Q4, for example) can trigger a flag the same way a real error would.
QuickBooks' AI review runs automatically rather than by typed prompt, but these questions are worth asking yourself (or your accountant) each time a flag appears:
Is this a recurring cost increase (a rate change, a new fee) or a one-time event?
If recurring, does it change my per-SKU margin enough to justify a price adjustment?
Does this flagged expense match a transaction I actually remember making?
If not, could this be a duplicate charge, a subscription I forgot to cancel,
or an error in how the connector categorized a marketplace payout?
Before tax season: pull every anomaly flagged in the past 12 months and
confirm each one has a category and a note explaining what happened,
so nothing gets left as an unexplained outlier when I file.