Read from the tax invoice, not from the label
An Amazon label PDF alternates between two kinds of page: a page carrying the shipping
label, and one or more pages carrying that order's tax invoice. The order data lives on the
invoice pages, and those pages are real text — order number, ASIN, HSN, unit price, tax
rate, place of supply, your GSTIN. All of it can be read exactly, with no guessing.
The label page cannot. Amazon prints it as a single flattened image, so the AWB number and
the delivery-station code exist only as pixels. That is why this sheet has no dispatch
columns. We could run OCR over a barcode-dense label and produce something that looks
like an AWB number, but a wrong AWB in a spreadsheet is worse than an absent one — so we
leave it out and tell you why. (Flipkart's sheet does carry AWB and courier, because Flipkart's label keeps its text layer.)
One row per line item — not one row per order
An order with three products produces three rows, each with its own ASIN, HSN, tax
rate and taxable value. That is the shape GST reconciliation needs. A single row per order
would blend three tax rates into one meaningless average and hand the unpicking work back to
you.
Long invoices that spill onto a continuation page are handled — the continuation rows stay
attached to the order they belong to, not to whatever label happens to follow.
All 29 columns
The sheet opens with the core columns; tick Select all to widen it. Amazon's invoice
is richer than Flipkart's in two respects — it carries the ASIN and the payment
transaction ID, neither of which Flipkart prints.
Core
- Order Date
- Order Number
- SKU
- Qty
- Net Amount
- Tax Type
- Tax Amount
- Place of Supply
GST & invoice
- Invoice No
- Invoice Date
- HSN
- ASIN
- Unit Price
- Discount
- Tax Rate
- Total
- Invoice Value
- Payment Mode
- Payment Txn ID
- State Code
- Seller
- Seller GSTIN
- Seller PAN
- Product
Buyer
- Buyer
- Shipping Address
- Pincode
- Billing Name
- Billing Address
Blank beats wrong. If Amazon changes its invoice layout and an amount doesn't parse
cleanly, we leave the cell empty and warn you, naming the order. We never write a
0 or a 1 as a placeholder.
A spreadsheet that quietly under-reports your taxable value is far more dangerous than one
with an obvious hole you can go and check against Seller Central. The gap is the honest
answer; a fabricated zero is not.
Same PDF — crop the labels from it too
The Excel and the 4×6 labels come out of the same file. Use
the Amazon label cropper to take both in one pass:
print-ready 4×6 labels, the invoice pages kept intact as their own A4 PDF, and the sheet.
Nothing is uploaded
Amazon invoices carry your buyers' names, addresses and phone numbers, and your own GSTIN
and PAN. None of it reaches us. The PDF is parsed inside your own browser tab — this is a
static site with no application server, so there is nowhere on our side to send a
file. Load the page, turn off your internet, and build the sheet anyway. It works, and that
is the proof.