Adding Temu to a QuickBooks file that already carries Amazon takes four accounts, one clearing pattern, one conversation with your CPA about sales tax, and one decision about whose inventory the Temu orders ship from. Do those four before the first payout lands and the month closes on time. Skip them and the first Temu deposit gets booked as "Sales" with no fees, no refunds, and no COGS, and the close spends a week finding out what it was.
A new marketplace is a new set of lines on the P&L, not a bigger version of the Amazon lines. Add these before the first settlement posts.
Add a fifth if you split cost of goods by channel: COGS, Temu, so the channel's margin is readable without a report filter. If you carry one COGS account, tag the entry with a class or channel field instead.
Name them so they sort beside the Amazon set. A P&L that reads Amazon Sales, Amazon Fees, Amazon Refunds, Temu Sales, Temu Fees, Temu Refunds is a P&L your accountant can read in a minute. One that reads Sales, Marketplace fees, Other income is a P&L that needs a meeting.
The pattern is the same one that works for Amazon, and it exists because a marketplace payout is never the sales figure. Temu reports what you sold in a period and what it deducted; the bank shows a single net deposit. The clearing account holds the difference so both are true at once.
Two entries per settlement. The first books the settlement in full: debit Temu Clearing for the net payout, debit Temu Fees and Temu Refunds for what Temu deducted, credit Temu Sales for the gross. The second, when the cash lands: debit the bank, credit Temu Clearing. When both are posted, the clearing balance for that settlement is zero. When it is not zero, something on the statement did not make it to the bank, or something hit the bank that is not on the statement, and the balance is the exact size of the problem.
Settlement periods and deposit dates will not line up with your calendar month. Book by settlement, reconcile by deposit, and let the clearing account carry anything that straddles month end. Do not book deposits as sales.
Illustrative numbers. A seller of kitchen textiles adds Temu in the spring. One settlement statement shows:
Entry one, on the settlement date.
Debits: $9,610.00 plus $1,860.00 plus $620.00 plus $310.00 equals $12,400.00. Balanced.
Entry two, on the deposit date.
Entry three, cost of goods for the units that shipped. 400 units at a FIFO landed cost of $12.40 each.
The channel's contribution for the settlement: $12,400.00 minus $1,860.00 minus $620.00 minus $310.00 minus $4,960.00 equals $4,650.00, or 37.5 percent of gross, before any ad spend or the share of overhead you choose to allocate. That figure sits beside the Amazon contribution for the same weeks, on the same basis, which is the point of separate accounts.
Most US states have marketplace facilitator laws that shift sales tax collection and remittance on marketplace orders to the marketplace itself. Whether that applies to your Temu sales, in which states, and how any tax collected appears on Temu's statements are questions with answers that depend on the state, the product, and the current statute. This article gives no tax advice. Before the first settlement posts, ask your CPA two things: does Temu collect and remit on your behalf in the states you ship to, and should tax that Temu collected appear anywhere in your books at all. If the answer to the second is no, do not book it as your liability, and do not book it as your revenue. If you have nexus in a state where the marketplace does not collect, that is a registration question for the state's department of revenue, and your CPA will tell you which.
If Temu orders ship from the same stock that feeds Amazon, whether at your warehouse or a 3PL, two things go wrong without a decision. The first is overselling: both channels see the same 900 units as available, and the 901st order has nothing behind it. The second is COGS drift: the two channels draw from the same FIFO layers, and if the Temu entry uses an old average cost while the Amazon entry uses the current layer, the same physical unit gets costed two ways.
The fix is to track inventory by warehouse, treat each channel's sale as a draw from the same layer stack in date order, and set a channel allocation or a reserve so Temu cannot sell units that Amazon has already committed to an inbound shipment. Units in transit to FBA are not available to Temu and should show as in-transit, not on hand. Inventory tracking that handles warehouse-level stock, in-transit status, and FIFO across channels does this without a second spreadsheet.
ConnectBooks connects Temu data to QuickBooks or Xero, with dedicated pages for Temu and QuickBooks Online and Temu and QuickBooks Desktop and Enterprise, alongside the Amazon, Shopify, Walmart, eBay, and TikTok Shop channels already in the accounting workflow. The pattern above is what a connected channel produces on its own schedule: settlement booked, fees and refunds on their own accounts, clearing cleared against the deposit.
It does not decide your sales tax position, and it does not tell you how to split a shared pallet between two marketplaces. Those two stay with you and your CPA. What the connection removes is the part of the close that was a spreadsheet: the settlement rekeyed line by line, the deposit matched by hand, the COGS entry estimated from an average because nobody had time to look up the layer. Get the four accounts in, run the first settlement through the pattern by hand once so you know what it should look like, and then let the connection run it.
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
