Workflow · Reconcile · Opening soon

Match Amazon settlements to QuickBooks

Match each Amazon settlement to the deposit in QuickBooks. Break out fees, refunds, and reserve holds, then show which payouts agree, are missing, short, or duplicated.

Book a demo

Someone typed

“match the amazon settlements to our quickbooks deposits, show each payout with settlement total, qbo amount, and status: Agrees when amounts match, Missing when unpaid, Short when qbo is low, Duplicate when a deposit repeats”

The agent read it as

match the Amazon settlements to our QuickBooks bank deposits, show each payout with settlement total, qbo amount, and status: Agrees when amounts match, Missing when unpaid, Short when qbo is low, Duplicate when a deposit repeats

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

File

Amazon settlements

CSV export · 12 rows

File

QuickBooks bank deposits

CSV export · 12 rows

Step

Normalize payout ids

Step 1

Step

Sum repeated deposits

Step 2

Join

Join deposits

11 of 12 paired

Step

Set status

Step 4

Result

Amazon settlement reconciliation

12 rows · 3 flagged

Schedule

Runs when you say

Proposed

File
Amazon settlements
CSV export · 12 rows
File
QuickBooks bank deposits
CSV export · 12 rows
Step
Normalize payout ids
Step 1
Step
Sum repeated deposits
Step 2
Join
Join deposits
11 of 12 paired
Step
Set status
Step 4
Result
Amazon settlement reconciliation
12 rows · 3 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 12 rows came out, and the join paired 11 of 12 rows.

Download Amazon settlements sample (12 rows)Amazon Seller Central: Payments > Date Range Reports > Settlement Report > Download flat file
Download QuickBooks bank deposits sample (12 rows)QuickBooks Online: Accounting > Chart of accounts > Checking account > Run report > Deposit transactions

What you get back

The result of that run, the rows to look at first.

Amazon settlement reconciliationSample data12 rows

9 agrees1 duplicate1 missing1 short

Settlement id	Settlement total	QBO amount	Status
amzn_settlement_1003	3,388.20	6,776.40	Duplicate
amzn_settlement_1005	1,842.60	1,792.60	Short
amzn_settlement_1009	3,094.15	·	Missing
amzn_settlement_1001	2,865.40	2,865.40	Agrees
amzn_settlement_1002	1,942.75	1,942.75	Agrees
amzn_settlement_1004	1,275.60	1,275.60	Agrees
amzn_settlement_1006	4,120.95	4,120.95	Agrees
amzn_settlement_1007	965.30	965.30	Agrees
amzn_settlement_1008	2,510.80	2,510.80	Agrees
amzn_settlement_1010	1,589.45	1,589.45	Agrees
amzn_settlement_1011	2,235.90	2,235.90	Agrees
amzn_settlement_1012	4,018.65	4,018.65	Agrees

12 rows in the result. Sample data: illustrative figures, not business results.

How do you reconcile Amazon settlements with QuickBooks deposits?

Export settlements from Amazon Seller Central and bank deposits from QuickBooks. Mammoth normalizes payout IDs, sums repeated deposits, joins the files, and sets a status for each settlement. You can see the settlement total, the QuickBooks amount, and whether it agrees, is missing, short, or duplicated.

How it works

How to use the Amazon settlement reconciliation workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Amazon settlement reconciliation: questions

What export should you use from Amazon and QuickBooks?

Use the settlement export from Amazon Seller Central and the bank deposit export from QuickBooks. The workflow needs the exported files, not a live connection.

What happens when a settlement does not match a deposit?

Rows that do not match are kept and marked by status. A missing deposit stays marked Missing, a lower QuickBooks amount is marked Short, and a repeated deposit is marked Duplicate.

How do you change the matching rules?

You change the rules in words, such as how to treat payout IDs, repeated deposits, or amount checks. Mammoth then applies those steps to the next exported files.