Blog

How to Set Up QuickBooks for Amazon Sellers

ยท 7 min read

A payout is the money Amazon sends to your bank. It shows up as one number. Inside that number are many things. There are sales, refunds, a pile of fees and a few odd fixes. QuickBooks for Amazon sellers comes down to one job. You need to get that one deposit into your books as what it really is. And you should not lose a weekend doing it.

Can Amazon sellers use QuickBooks?

Yes. QuickBooks Online works well for an Amazon business once your payouts go in the right way. It keeps your sales, fees, products and costs in one set of books. Your accountant already knows how to read it. The one thing it does not understand by itself is an Amazon payout. Setup is mostly about that.

The trouble starts with the bank feed. That is the list of bank activity QuickBooks pulls in. Say it sees a $3,180.00 deposit from Amazon. It offers to record the whole thing as sales.

Say yes, and your books claim two things. You sold $3,180.00 of products. You paid no fees at all. Both are wrong.

Why is a payout the wrong number to record as sales?

A payout is what is left after Amazon takes its fees and pays back your buyers. If you record it as sales, your sales look too small. Your biggest costs are hidden. Your profit may come out close. Your books can no longer tell you what Amazon charged or how much was refunded.

Here is a made-up payout.

The deposit is 5,000 minus 250 minus 1,650 plus 80. That is $3,180.00.

Record it as one line and your books show $3,180.00 of sales. Record it the right way and they show each part. The same $3,180.00 still lands in the bank.

The second way answers questions the first cannot. What share of your sales goes to Amazon in fees? Here it is $1,650.00 out of $5,000.00, or 33 percent.

Tax time is the other reason. Amazon reports your total sales for the year. It does not report your deposits. Books built on deposits will not match Amazon's number. Someone will have to explain why.

Which accounts does an Amazon seller need in QuickBooks?

Keep the list short and clear. In QuickBooks, an account is a labeled bucket for one kind of money. You need a bucket for sales and one for refunds. You need a few for the main kinds of Amazon fees. You need one for the products you own and one for the cost of what you sold.

Split the fees that act in different ways.

Keep them apart and you can see which cost is growing.

Give promotions their own bucket too. A coupon is a discount you chose to give. You will want to know what it cost you.

Add one bucket for money Amazon pays you back for lost or broken units.

Sales tax needs care. In many places, Amazon collects the tax on your sales and sends it to the state for you. It can pass through a payout without being yours to keep. How to record it depends on where you sell. Ask your accountant.

How do you record an Amazon payout by hand?

Open the report for the payout in Seller Central, which is Amazon's website for sellers. Add up each kind of line. Then make one entry in QuickBooks. Put sales in the sales bucket, refunds in the refunds bucket and each fee in its own bucket. The total must equal the deposit. If it is off by a cent, you missed something.

A clearing account makes the matching cleaner. It is a holding bucket. Your entry puts the payout total there. When the deposit hits your bank, you move the money out of the holding bucket. The bucket goes back to zero.

A number left in that bucket is a warning. A payout was entered and never came. Or it came and was never entered.

The method is sound. The cost is your time. Each payout needs a report, some adding and an entry. It repeats with every payout. Skip a month and it is a chore to rebuild.

What happens when a payout crosses the end of a month?

It should be split in two. Say a payout covers March 24 to April 7. It holds sales and fees from both months. If you put all of it in April, March looks too small and April looks too big. For monthly reports to mean anything, each month should hold only its own share.

This matters if you compare one month with the next. A store can look like it had a weak March and a strong April. The only thing that changed was the day Amazon paid.

To split a payout by hand, you sort every line by its date. That doubles the work. It is an easy step to skip. It is also a good one to hand to software.

How do you handle cost of goods sold?

Cost of goods sold is what you paid for the units you sold. It is not what you paid for everything you bought. Products you buy sit in your books as something you own. As each unit sells, its cost moves over to cost of goods sold. This keeps a big buying month from looking like a loss.

To do this, you need to know what each unit cost. Tax and shipping count.

Say 10 units cost $100.00 in total. Each one cost $10.00. A payout that sold six of them carries $60.00 of cost. The other four are still yours, worth $40.00.

Lost and broken units need the same care. They leave your shelf with no sale. If Amazon pays you back, that payment goes in its own bucket. The unit's cost still comes off what you own.

What should an Amazon to QuickBooks sync do?

A sync is a tool that sends your Amazon numbers into QuickBooks for you. A good one does the hand method and holds itself to the same rules. It records each payout as its own entry. It sorts sales, refunds and fees into their own buckets. It adds the cost of the units sold. It splits a payout that crosses a month. It will not send a payout that does not match the bank deposit.

Sync tools differ in one big way. Some send every order to QuickBooks as its own entry. Others send one summary for each payout.

Summaries keep your books light. They match the way the money comes in. They also keep your buyers' details out of your books.

SourceDock's QuickBooks for Amazon sellers sync is the summary kind. Here is what it does.

Setup is short. You connect QuickBooks. SourceDock suggests accounts and makes any that are missing. You pick your bank account and your first payout month. Then you check your latest payout.

Nothing is sent until you turn it on. After that, each new payout goes in with no click from you.

Questions sellers ask

Does this work with QuickBooks Desktop?

SourceDock's sync works with QuickBooks Online only. It is for US Amazon stores and a QuickBooks company that uses US dollars. If you use Desktop, the hand method described earlier is the one to trust.

Do buyer names and addresses go into QuickBooks?

Not with a summary sync. SourceDock sends totals only. No buyer names, addresses or order details go in. That keeps private details out of a file your bookkeeper can open.

Should an Amazon seller use cash or accrual accounting?

These are two ways to keep books. Cash counts money on the day it moves. Accrual counts a sale on the day it happens. Cash is easier. Accrual gives a truer month for a business that holds products. Ask your accountant which fits you before you set up your accounts.

Which SourceDock plan includes QuickBooks?

QuickBooks Online is on the Pro plan and in every 14-day free trial. Both plans are on the pricing page. QuickBooks is a trademark of Intuit Inc. What goes into each payout entry is on the QuickBooks for Amazon sellers page.

More from the blog