An AI CFO can only answer questions your ledger already contains the facts to answer. If marketplace payouts land as single deposits, if all fees share one expense account, and if cost of goods sold posts as a month-end estimate, no analysis tool from any vendor will tell you anything you did not already know. It will tell you the same thing faster and with more confidence, which is worse.
The preparation work below is seven steps, takes a few weeks for most multichannel sellers, and is the same work whether you eventually buy an analysis tool or not. That is the argument for doing it: the books get better either way.
Finance leaders say the same thing when asked what would make them trust these tools. In Avalara's July 2026 research "Agents of Change," conducted by Censuswide among 1,505 CFOs and senior finance leaders, the capabilities respondents most wanted before expanding AI use were agents operating inside existing systems of record, cited by 27 percent, and outputs grounded in verified financial data, cited by 25 percent. Both are descriptions of the data layer, not the model.
Every marketplace payout should arrive in your ledger decomposed into its component transaction and fee types, not as one deposit posted to a clearing account.
This is the highest-value change available and everything after it depends on it. A deposit line tells you cash moved. A decomposed settlement tells you what you sold, what was refunded, what each fee type cost, and what was withheld. ConnectBooks does this across Amazon, Shopify, Walmart, eBay, and TikTok Shop into QuickBooks or Xero, including newer channels where the TikTok Shop payout structure is unfamiliar to most bookkeepers.
Test for completion: pick any payout from last month and trace it to a set of ledger entries whose net equals the deposit to the penny.
One "Marketplace fees" account is where analysis goes to die. Fee types answer different business questions and belong in different places.
Here is one month of Amazon fees for a mid-size seller, totaling $88,412.37:
Collapsed into one line, the only fact available is that fees rose. Split out, the storage figure is the story. It rose from $2,914.08 the prior month to $4,266.51, an increase of 46.4 percent, while sales rose 4 percent. That is aging inventory, and it is a reorder and liquidation conversation that needs to happen before the next storage assessment, not after.
An AI CFO reading a single blended fee account cannot find that. Reading five accounts, it can, and so can you.
Perpetual inventory is only as good as the day you started it. Count physically, at every location including the marketplace fulfillment centers, and value at landed cost rather than purchase price.
Reconcile the count to what the system thinks it has before going live. A variance you accept on day one becomes a permanent distortion in every margin figure that follows, and it grows as quantities turn over.
Freight, duty, customs brokerage, and inbound handling belong in the cost of the unit, not in an operating expense account below the gross margin line.
The arithmetic matters. A seller who buys 186,000 units in a year and pays $412,800 in freight and duty is carrying $2.2194 per unit that either sits in inventory and flows to COGS as units sell, or sits in operating expenses and inflates reported gross margin by several points. Same cash, entirely different picture of the business.
ConnectBooks supports landed cost allocation, which is what turns a purchase order and a freight bill into a unit cost rather than two unrelated entries.
Revenue and cost need to reach the general ledger tagged with the channel and the SKU that produced them. Otherwise a channel P&L requires an export and a spreadsheet, and any tool sitting on the ledger sees only totals.
In QuickBooks this typically means class or location tracking. In Xero it means tracking categories. Either way, the tagging has to happen at the point of posting, not in a monthly reclassification, or the detail is lost.
Test for completion: produce a profit and loss by channel for last month without opening a spreadsheet. If you cannot, neither can the software.
Settlement periods do not align with calendar months, and the mismatch creates four recurring decisions. Write down how you handle each one.
Orders that shipped in one period and refunded in the next. Reserves withheld at period end, which are receivables rather than expenses. Advertising charged against a settlement that spans two months. Inventory in transit at period end, which belongs on your balance sheet once title has passed, and which ConnectBooks tracks as in transit until received.
Consistency matters more than the specific choice. A rule applied the same way every month produces comparable periods. A rule applied differently each month produces a trend line that means nothing, and an analysis tool will happily explain that meaningless trend to you.
Automation produces a queue of items it declined to handle. Someone reviews that queue on a schedule, and that person has authority to change a coding rule when a new pattern appears.
Weekly works for most sellers. Monthly is too slow, because by the time you find a miscoding it has repeated forty times and touched a closed period.
Take last month and answer these five questions using only your accounting system.
Answer all five without a spreadsheet and your books are ready. Answer three and the analysis layer will be guessing at the other two. Answer one and you are not shopping for an AI CFO, you are shopping for a working accounting connection.
SKU and channel-level profit reporting is the specific capability that makes question five answerable, and it only works when questions one through four already are.
Books that pass the test above share four traits. Payouts reconcile to the penny. Fees are separated by type. Inventory is tracked by location at landed cost with a consistent method. Channel and SKU identity survive into the ledger.
That is not an exotic standard. It is what an acquirer's diligence team expects to find, what a lender wants before extending an inventory line, and what your own reorder decisions have always needed. The AI question just made the gap easier to see.
ConnectBooks has announced Crunch, an AI CFO designed to answer questions against exactly this reconciled data, and there is a waitlist open ahead of its release describing what it will do. Nothing on that page changes the sequence. The inventory layer and the settlement connections come first, and they are worth building on their own merits, before any analysis tool exists to sit on top of them.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
