00:00All right, let's talk about something that drives so many Amazon sellers crazy,
00:03the settlement report. Today, we're going to show you how to turn that intimidating
00:07spreadsheet into a powerful tool that gives you real, actual insight into your business.
00:12Let's dive in. So you get that payout from Amazon, right? But have you ever looked at
00:18the report and just thought, how on earth did they come up with this specific number?
00:22If that sounds familiar, trust me, you are definitely not alone.
00:25Yeah, for a lot of sellers, that payment statement feels less like a report and more like,
00:31oh, a puzzle, a really complicated one. It's just this giant dump of data and trying to make
00:36sense of it all can be a total headache. I mean, you crack it open and it's just this
00:40wall of text and numbers, isn't it? You see orders, a dozen different kinds of fees,
00:46refunds, adjustments, all the pieces are there, sure, but trying to connect all those dots to
00:51the final deposit, it can feel next to impossible.
00:53Okay, but what if I told you there's a way simpler way to look at this? Let's just completely
00:58reframe this whole thing with one simple, but really powerful idea. And here it is. This is
01:04the secret. Just think of your settlement report as a bank statement for your Amazon store. That's
01:09it. It's just a detailed list of money coming in, your credits, and money going out, your debits.
01:14Once that clicks in your head, everything else starts to fall into place. So these reports cover
01:19what Amazon calls a settlement period. You know, maybe it runs from the 1st of August to
01:24the 15th. Amazon then crunches all the numbers for those two weeks. And then a few days later,
01:29let's say August 18th in this case, boom, the final amount lands in your bank account.
01:34Okay, so we've got the right mindset now, right? It's just a bank statement. So let's actually
01:39dive in and break this thing down. We're going to follow the money, looking at the credits
01:43coming in and then the debits going out. And to make this super clear, we're not going
01:48to talk in abstracts. We're going to follow one single real order all the way through
01:53the report. This way, you can see exactly how every part of a transaction gets locked.
01:58All right, let's start with the fun part, the money coming in. These are your credits.
02:04So for our example order, you can see a credit for the product price itself. That's a thousand
02:09rupees. And then another credit for the shipping, the customer paid, which is a hundred rupees.
02:14So how do we get to that gross sales number? Well, it's pretty simple. We take the product
02:20price, add the shipping, and then add the GST that was collected from the buyer, which in this
02:25case is 198 rupees. That gives us our total gross sale of 1,298 rupees. This is the total amount
02:33the customer actually paid. But of course, it's not all coming to you. Money also goes out.
02:38These are your debits, and we'll start with the fees. Amazon has all sorts of fees, right?
02:44Like their commission, which is a debit of 120 rupees here, and other closing fees. Now,
02:49here's a really important point. These fees reduce your payout for sure, but they don't
02:54change your sales value for your GST. That's a crucial distinction. So just for this one order,
02:59the total fees add up to a debit of 135 rupees. You can see right away how these debits start to,
03:05you know, chip away at that gross sale amount we just calculated.
03:09Okay, but what about promotions? If you're running a discount, that also shows up as a debit.
03:14But here's the thing that's different from fees. Promotions do reduce the taxable value of the
03:19sale, and that is a super important detail when you're doing your GST filings. And then, of course,
03:24you have other potential debits like refunds. If a customer sends something back, you'll see all
03:29sorts of entries for that. Goodwill refunds, maybe even restocking fees. You absolutely have to track
03:35these not just for reconciling your books, but for making sure you issue your GST credit notes
03:39correctly. Okay, so Amazon eventually figured out that the standard report was, well, kind of a
03:45nightmare to deal with. So they came out with a newer, way simpler V2 version. Let's take a look
03:50at how this really cleans things up, especially if you're an FBA seller. And wow, this really shows
03:56you the difference, doesn't it? On one side, the old report with its dozens of columns for every tiny
04:00thing. And on the other, the V2 report, which boils it all down to just three simple columns.
04:06Honestly, for sellers, this was a total game changer. So this is what it actually looks like
04:10in practice. You've got one column for the amount type, like item price or item fees, another for
04:17clear description, like commission, and then a final column for the amount itself. It's just so clean,
04:23so simple, and incredibly easy to analyze. And this is why it's so great, because it's structured so
04:29simply, the V2 report is perfect for things like pivot tables in Excel, or for importing straight
04:35into your accounting software. It literally saves hours and hours of work. All right, so now you get
04:41it. You know how to read the report. The puzzle is solved. But the real question is, how do you
04:47actually use this knowledge to grow your business? Okay, here is your five-step plan to financial
04:53clarity. Step one, use the report to reconcile your bank payouts. Make sure what Amazon says they
04:59is what you actually got. Two, use it to prep your GST returns, so they're spot on. Three,
05:06calculate your real profit. Four, analyze your fees. And five, track your refunds. This report
05:13really is the key. And if you're a visual person, this chart sums it all up perfectly. You start with
05:19this big bar, your gross sales. Then you take out a chunk for all the fees and debits. And that smaller
05:25bar that's left over, that's your net payout. That's the cash that actually hits your bank.
05:31Look, if you walk away with just one thing today, let it be this. It's so simple. The sales and tax
05:36columns, that's your turnover and your GST. The fee columns, those are your business expenses. And that
05:42total amount column, that's your cash flow. Simple as that. So now you have the decoder ring. You can look
05:49at this report and see not just a bunch of numbers, but the actual story of your business, your profits,
05:54your costs, your customers. The only question left is, what story is your business trying to tell you?
Comments