The data is already in the PDF you downloaded
Every seller does this at least once: print the labels, ship the parcels, then open a blank
spreadsheet and start typing order numbers, SKUs, amounts and GST figures — reading them off
the very PDF you just printed. Then do it all again next week.
The tax invoice on that page is a structured document. The order number, the HSN code, the
taxable value, the GST split and the seller GSTIN are all sitting in it as real text. There
is no reason to retype any of it. Drop the same PDF in above and it comes back as a
spreadsheet.
One row per line item — not one row per order
This distinction matters more than it sounds. If an order contains three different products,
you get three rows, each carrying its own HSN code, its own tax rate and its own
taxable value.
That is the shape GST reconciliation actually needs. A single lumped row per order forces
you to unpick a blended tax rate by hand — which is precisely the manual work you were
trying to escape. Line-item rows drop straight into a pivot table, your accountant's working
file, or Tally.
All 32 columns
The sheet opens with the core columns so it stays readable. Tick Select all and it
widens to every field Flipkart prints. Nothing here is derived, estimated or inferred — each
column is a value that physically appears on the page.
Core
- Order Date
- Order Number
- SKU
- Qty
- Payment
- Net Amount
- Tax Amount
- Place of Supply
GST & invoice
- Invoice No
- Invoice Date
- HSN
- Tax Type
- GST %
- Gross
- Discount
- Cess
- Total
- State Code
- Seller
- Seller GSTIN
- Seller PAN
- Product
Dispatch
- AWB
- Courier
- Dispatch By
- Deliver By
- Sort Code
Buyer
- Buyer
- Shipping Address
- Pincode
- Billing Name
- Billing Address
Those five dispatch columns are a Flipkart speciality. They exist because Flipkart's
shipping label keeps a real text layer, so the AWB, the courier, and the promised dispatch
and delivery dates can be read straight off it. Amazon prints its label as a flat image, so
the Amazon sheet has no dispatch columns at all — and
we would rather say so plainly than hand you a column of guesses.
Blank beats wrong. Flipkart changes its invoice layout from time to time. When an
amount line doesn't parse cleanly we leave the cell empty and show a warning naming
the order. We never write a 0 or a 1 to fill the hole.
The tool also reads each invoice's own tax-column layout instead of assuming one: an
inter-state invoice charges IGST in a single column, an intra-state one splits it into
CGST and SGST. Assuming the wrong shape is exactly how a tool silently slides the tax
figure into the discount column and hands you a sheet that looks perfect and is wrong.
Same PDF — you can crop the labels from it too
The order sheet and the 4×6 labels come out of the same file. If you're dispatching anyway,
use the label cropper and take both in one pass:
print-ready labels, the invoices as a separate PDF, and the Excel.
Nothing is uploaded
Your invoices carry your buyers' names, addresses and phone numbers — and your own GSTIN and
PAN. None of it reaches us. The PDF is parsed by code running inside your browser tab: this
is a static site with no application server, so there is nowhere on our side for a
file to be sent. Load the page, switch your internet off, and build the sheet anyway. It
works.