Bring the settlement in.
Use the beta Amazon connection where it’s enabled for your account, or drop in the settlement flat file you already download from Seller Central. Every line item is kept, with a trail back to the source report.
Amazon to
QuickBooks Online.
Your Amazon settlement arrives as one deposit hiding dozens of line items. TidyPayouts opens it up, maps every fee to the right account, and posts one reviewed journal entry that matches the deposit to the penny.
BETA CONNECTION + CSV✓ Free during beta✓ Review before posting
AmazonSettlement flat files
TidyPayoutsBreakdown · mapping · review
QuickBooks OnlineOne journal entry per settlementWHAT’S INSIDE AN AMAZON SETTLEMENT.Every line,
Every line,
in its place.
One deposit, many moving parts.
TidyPayouts keeps them separate.
- ↳Product salesOrdered product sales, net of promotions you fund, with SKU detail for product costs.
- ↩RefundsRefunded orders and the referral fees Amazon hands back, matched to orders.
- ⚖Referral & FBA feesReferral commissions plus pick, pack and fulfillment charges, as separate mappable lines.
- ◫Storage & inventoryMonthly storage, removals, disposals and aged-inventory surcharges.
- ✦AdvertisingSponsored Products, Brands and Display charges, mapped to your ad expense account.
- %Sales tax collectedMarketplace-collected tax passes through to a liability account — never your income.
- ≋ReservesHolds and releases that roll between settlements, so the deposit still reconciles to the penny.
- ◎Reimbursements & adjustmentsLost-inventory reimbursements, chargebacks and corrections, flagged for review.
FOUR STEPS. EVERY SETTLEMENT.From settlement to
From settlement to
journal entry, in order.
Set it up once.
Then it’s just review and post.
Give every line an account.
Map each line type to an account in your QuickBooks chart of accounts — sales, refunds, fees, storage, ads, tax, reserves. Mappings are reusable: set them once, and every future settlement follows.
Check it against the deposit.
Resolve unmapped lines, look over flagged fee combinations, and compare the net against the deposit that actually arrived. Nothing posts until you approve it.
Send it to QuickBooks.
One balanced journal entry, dated the settlement’s deposit date, nets to the penny of your bank feed. Reversible and re-postable if you change a mapping later.
WHAT LANDS IN YOUR BOOKS.One entry.
One entry.
Every dollar explained.
Your P&L shows real Amazon margins —
not one blob called “Amazon.”
Example: a $8,425.20 settlement
ILLUSTRATIVE · SAMPLE DATA| Account (as you mapped it) | Debit | Credit |
|---|---|---|
| Checking account the deposit itself | $8,425.20 | |
| Refunds & returns refunds, plus fees given back | $284.00 | |
| Marketplace fees referral, FBA and storage | $1,530.80 | |
| Product sales net of your promotions | $10,240.00 | |
| Totals | $10,240.00 | $10,240.00 |
One journal entry per settlement, dated the deposit date. The entry nets to $8,425.20 — the amount that hit the bank — so QuickBooks’ bank feed matches without manual reconciling. Advertising and marketplace-collected tax, when present, get their own mapped lines. Made a mistake or changed a mapping? Entries can be reversed and re-posted without losing the trail back to the source report.
THE SETUP GUIDE.Set it up in
Set it up in
an afternoon.
Most of this is one-time work.
After that, a settlement takes minutes.
Create your TidyPayouts account
Join the free beta with your email — no credit card, every plan is free while we’re in beta.
Connect QuickBooks Online
In the app, go to
Settings → Account settingsand connect QuickBooks with your Intuit login. Owner access in TidyPayouts is required, and the connection syncs your chart of accounts so mapping uses your real account names. Availability is rolling out during beta; check connection status inside the app.Bring in your Amazon settlements
Where the Amazon connection is enabled for your account, settlements arrive on their own. Otherwise, in Seller Central go to
Reports → Payments → Statement viewingand download the date-range statement inFlat File V2format, then import it. One file can hold many settlements; each becomes its own review.Map your line types
Assign each settlement line type — product sales, refunds, referral fees, FBA, storage, advertising, sales tax, reserves — to an account. Sensible defaults get you most of the way; adjust anything to match your chart. Bookkeepers can review or change mappings any time.
Review the settlement
Compare the net against the actual deposit, check flagged fee combinations, and add product costs if you track COGS. Unmapped lines are held out (and clearly listed) rather than guessed into an account.
Post, then match the deposit
Send the journal entry to QuickBooks, then match the deposit in your bank feed. Done — on to the next settlement, with the whole trail kept for review.
Is the Amazon to QuickBooks connection available now?+
Both connections are part of the beta and availability is rolling out by account. Meanwhile you can import settlement flat files directly — the same report type the connection uses — and post to QuickBooks as soon as the connection is offered to you. Check connection status inside the app before relying on a live import or post.
How do I download my Amazon settlement report?+
In Seller Central, go to Reports → Payments → Statement viewing and download the date-range statement in Flat File V2 format. The tab-separated file contains one or more settlements with every line item. Drop it into TidyPayouts and the deposit is broken down automatically.
Does it handle Amazon reserves?+
Yes. Reserve holds and releases are their own line type, mapped to the account you choose — usually a clearing or receivable account. A hold reduces one deposit and its release increases a later one, so your books reconcile to the actual bank amount either way.
Which QuickBooks accounts should I map Amazon lines to?+
A typical mapping: product sales to a Sales income account, refunds to refunds or contra-income, referral and FBA fees to marketplace fee expenses, advertising to an ad expense, marketplace-collected tax to a sales tax liability, and reserves to a clearing account. Defaults get you most of the way; your bookkeeper can fine-tune, and mappings are reusable.
Can my bookkeeper double-check before anything posts?+
Yes — that’s the point. Summaries, mappings and source records are all reviewable, and nothing posts until someone approves it. If a posted entry needs to change, it’s reversed and re-posted rather than edited behind the scenes.
OTHER CHANNELS, SAME IDEA.More pairs,
More pairs,
same tidy path.
Bring every channel into the same
QuickBooks workflow.
Shopify to QuickBooks
Payout reports from Shopify Payments: gross sales, refunds, processing fees and reserves.
Read the Shopify guide →
eBay to QuickBooks
Final value fees, Promoted Listings, labels and dispute holds from Seller Hub CSVs.
Read the eBay guide →
Etsy to QuickBooks
Listing, transaction and processing fees, Offsite Ads and the tax Etsy collects.
Read the Etsy guide →
Walmart to QuickBooks
Referral and WFS fees, returns, adjustments and chargebacks from Seller Center.
Read the Walmart guide →Your settlements,
already sorted.
The next settlement doesn’t have to be a mystery deposit.
Start your free beta →Free during beta. No credit card. A little more breathing room.