All Case Studies
Upload your reports
Download them from Seller Central and drop them in. Your reports are read in this browser tab and never uploaded, so this path needs no account and no connection.
Add your transaction report to see profit per SKU. The other two files are optional and make the answer sharper.
Early access
Connect your Amazon account
Authorise on Amazon's own screen and the reports are pulled for you instead of downloaded each month. Read only, and you can revoke it from Seller Central at any time.
How to see your real profit per SKU
- Step 1: Export your payments report
In Seller Central go to Reports, then Payments, then Transaction view, and download the period you want. This is the only required file. It carries every order, refund, fee and adjustment Amazon posted to your account.
- Step 2: Add your ad report, if you run ads
Download the Sponsored Products advertised product report. Ad spend Amazon tagged to a SKU is charged to that SKU. Spend it could not tag is shared across SKUs by sales value, so a product is not credited with cheap profit that advertising paid for.
- Step 3: Add your cost sheet
Upload any spreadsheet holding your cost per SKU, then point the tool at the right sheet and columns. Without it you still get revenue, fees and ad cost per SKU. With it you get margin.
- Step 4: Pick a period and read the table
Choose last month, last three months, last six months, everything to date, or your own dates. Every SKU is listed with units, net revenue, Amazon fees, ad spend, cost of goods, allocated overhead and the profit left at the end.
WHAT MAKES IT DIFFERENT
Built to survive an argument with your accountant
Four decisions that separate this from a fee estimator.
Your reports never leave your browser
Settlement data is the most sensitive file a seller owns. Every calculation runs on your own machine, and your reports are never uploaded, so this path needs no account and leaves nothing to delete. Connecting your Amazon account is the one exception: it stores your email and the authorisation Amazon issues, encrypted, and revoking clears it.
Ad spend is counted once, not twice
Cost of advertising appears in the payments report and again as spend in the ads report. It is the same money. Charging both would flatter or punish a SKU by the size of its ad budget, so it is charged once.
Shared costs are allocated on a stated basis
Storage, removals and inbound scale with units, so they are spread by quantity. Untagged ad spend follows revenue, so it is spread by sales value. Both bases are shown, so you can disagree with them knowingly rather than inherit them silently.
Returns are subtracted, not ignored
Refunds, returned units and fee reversals are read from the same report and netted off. A SKU with strong gross sales and a heavy return rate shows the profit that is actually left.
Questions sellers ask before uploading
Straight answers about the data, the maths and what the tool cannot see.
No. The file is read by your browser and the maths runs on your own machine. Nothing is sent to Dcrayon or to any third party, and closing the tab clears it.
Only the payments transaction report from Seller Central, under Reports, then Payments, then Transaction view. The advertised product report and your cost sheet are optional and add ad allocation and margin respectively.
An FBA calculator prices a sale that has not happened, using figures you supply. This reads sales that already happened, using figures Amazon posted, so the answer is what you earned rather than what you hoped to earn.
You still get units, net revenue, Amazon fees, ad spend and the profit before cost of goods for every SKU. Margin and profit per unit need your cost, and any SKU missing a cost is flagged rather than assumed to be free.
Amazon cannot always attribute spend to a single SKU. Whatever it could not tag is shared across SKUs by sales value and shown separately, so you can see how much of the number is allocated rather than measured.
Yes. Pick last month, three months, six months, everything to date, or set your own start and end dates. The whole table recalculates for the period you choose.
Found a SKU that loses money?
A thin or negative SKU is usually a pricing, ad or fulfilment problem rather than a product problem. Our Amazon team can look at your numbers with you and work out which.