Skip to content
Tally & AccountingAdvanced

How to Download Amazon Sales Invoices and GST Reports from Seller Central for TallyPrime and GST Returns

QUICK ANSWER If you sell products through Amazon India, the sales made to customers must be properly recorded in your accounting system and considered while ...

BI
Bison Technical Team Enterprise IT specialists
Updated 04 Sep 2026 16 min read 0 total views

QUICK ANSWER

If you sell products through Amazon India, the sales made to customers must be properly recorded in your accounting system and considered while preparing your GST returns.

Instead of manually downloading every customer invoice one by one, Amazon sellers should use the tax/GST and transaction reports available in Amazon Seller Central. Depending on the current Seller Central interface and report availability, these may include reports such as the Merchant Tax Report (MTR), GST reports, transaction reports, and GST Ready-to-File reports.

Advertisement

For accounting in TallyPrime, the important information generally includes:

  • Invoice number
  • Invoice date
  • Order number
  • Customer/buyer details
  • Buyer GSTIN for B2B transactions
  • Place of supply
  • Product description
  • HSN code
  • Quantity
  • Taxable value
  • GST rate
  • CGST
  • SGST
  • IGST
  • Invoice value
  • Credit note/refund details
  • Cancellation and return information

You should also separately account for Amazon seller fees, commissions and other charges. These are not your customer sales invoices.


COMPLETE ARTICLE

Why Amazon Sellers Need Sales Data for TallyPrime and GST Returns

When you sell a product through Amazon India, Amazon acts as the marketplace facilitating the transaction, but the accounting and GST implications for your business do not disappear simply because Amazon collects the customer's payment.

A GST-registered Amazon seller generally needs to maintain proper records of taxable supplies and reconcile relevant marketplace transactions with the books of accounts and GST returns.

For example, suppose you sold:

Laptop: ₹50,000 taxable value
GST: 18%
Invoice value: ₹59,000

The sale should ultimately be represented correctly in your books.

If the transaction is an intra-state supply, the tax may normally be divided between CGST and SGST:

Particular Amount
Taxable Value ₹50,000
CGST @ 9% ₹4,500
SGST @ 9% ₹4,500
Invoice Total ₹59,000

For an inter-state taxable supply where IGST applies:

Particular Amount
Taxable Value ₹50,000
IGST @ 18% ₹9,000
Invoice Total ₹59,000

The actual tax treatment depends on factors including the nature of supply, place of supply, GST registration details and applicable GST provisions.


Amazon Customer Invoice vs Amazon Seller Fee Invoice

This distinction is extremely important.

Amazon sellers deal with multiple types of financial documents, and they should not all be entered into TallyPrime in the same manner.

1. Customer Sales Invoice

This represents the sale of your goods to the customer.

For example:

Bison Infosolutions → Customer

This transaction generally belongs on the sales side of your books.

2. Amazon Seller Fee / Commission Invoice

Amazon may charge the seller for marketplace-related services such as applicable selling fees, referral fees, fulfilment-related charges or other services.

These are Amazon's charges to your business and are normally accounted for separately from customer sales.

3. Amazon Settlement

Amazon may collect money from customers and subsequently transfer a net settlement amount to your bank account after considering applicable charges, adjustments, refunds and other transactions.

Therefore:

Amazon bank settlement ≠ your total sales

This is one of the most important accounting concepts for marketplace sellers.

You should not simply treat the amount deposited by Amazon into your bank account as your Amazon sales turnover.


Why You Should Not Depend Only on Amazon Bank Settlements

Consider this simplified example:

Customer purchases goods worth:

₹59,000 including GST

Amazon later deducts marketplace charges and other applicable amounts before settling the balance.

Suppose, purely for illustration, the final amount deposited into your bank account is:

₹54,000

It would be incorrect to conclude automatically that your sales were only ₹54,000.

Your accounting records may need to separately represent:

  • Gross customer sale
  • Output GST
  • Amazon charges
  • GST charged by Amazon on eligible services
  • TCS/TDS where applicable
  • Customer refunds
  • Returns
  • Other adjustments
  • Net settlement received

The bank settlement is therefore primarily a settlement/reconciliation figure, not a substitute for invoice-level sales accounting.


How to Download Amazon Sales and GST Reports

Step 1: Log in to Amazon Seller Central India

Open Amazon Seller Central India and sign in using your seller account.

The official portal is:

Amazon Seller Central India

After login, use the reporting and tax-related sections available for your seller account.

Amazon periodically changes Seller Central navigation and report names, so the exact menu wording may differ from older screenshots or instructions.


Step 2: Look for Tax and GST Reports

Depending on the current Seller Central interface, marketplace configuration and your account, look under areas such as:

Reports

and tax/GST-related report sections such as:

Tax Document Library

or other available GST/tax reporting options.

Look for reports containing invoice-level tax information.

A particularly useful report historically provided to Indian sellers is the:

Merchant Tax Report (MTR)

The Merchant Tax Report can contain detailed marketplace transaction and GST information that can be useful for accounting and reconciliation.


What Is the Amazon Merchant Tax Report (MTR)?

The Merchant Tax Report, commonly referred to as MTR, is intended to provide detailed tax-related transaction information to sellers.

Instead of opening hundreds of orders and downloading invoices individually, a report containing transaction-level information can be much more practical for accounting.

Depending on the report version and transaction type, useful fields can include information relating to:

  • Order
  • Invoice
  • Transaction
  • Product
  • Buyer
  • Seller
  • GST
  • Taxable value
  • Place of supply
  • Returns/refunds
  • Credit notes

The exact columns can change, so always examine the current report downloaded from your own Seller Central account before building an accounting import around fixed column positions.


Download the Report for the Required GST Period

For monthly accounting, select the required reporting period.

For example:

From: 01 August 2026
To: 31 August 2026

Download the relevant Amazon GST/tax reports for the same period for which you are preparing your accounts.

Where available, CSV or spreadsheet-compatible reports are usually much easier to process than downloading hundreds of individual PDF invoices.


Important Fields to Check in the Amazon Report

Before importing or manually entering Amazon sales into TallyPrime, identify the following information.

Amazon Information Accounting Purpose
Invoice Number Sales voucher/invoice reference
Invoice Date Voucher date
Amazon Order ID Reconciliation/reference
Buyer Name Customer information
Buyer GSTIN B2B GST reporting
State / Place of Supply GST determination
Product Stock item/sales description
SKU Product mapping
HSN GST/HSN reporting
Quantity Inventory
Taxable Value Sales value before GST
GST Rate Applicable GST rate
CGST Output CGST
SGST Output SGST
IGST Output IGST
Invoice Total Total invoice value

Not every Amazon report will use exactly these column names.


Separate B2B and B2C Amazon Sales

Amazon customers can include both businesses and consumers.

This distinction is important for GST reporting.

B2B Sales

A business customer may provide a valid GSTIN for an eligible business purchase.

The transaction may therefore contain information such as:

  • Customer GSTIN
  • Business name
  • Invoice number
  • Taxable value
  • Tax amount
  • Place of supply

These transactions should be carefully checked because invoice-level information can affect GST reporting.

B2C Sales

Many Amazon orders are placed by individual consumers without a GSTIN.

These are generally treated as B2C transactions for GST reporting purposes, subject to the applicable GST rules.

Do not create arbitrary GSTINs for customers who have not provided one.


Intra-State vs Inter-State Amazon Sales

Another important consideration is the place of supply.

Intra-State Sale

Where the applicable GST rules make the transaction an intra-state supply, GST is generally charged as:

CGST + SGST

Example:

₹10,000 taxable value at 18% GST:

CGST @ 9% = ₹900
SGST @ 9% = ₹900

Total = ₹11,800

Inter-State Sale

Where the applicable GST rules make it an inter-state supply:

IGST

may apply.

Example:

₹10,000 taxable value at 18% GST:

IGST @ 18% = ₹1,800

Total = ₹11,800

Do not decide CGST/SGST versus IGST merely from the customer's name or Amazon order number. The transaction's GST and place-of-supply information must be checked.


How to Enter Amazon Sales in TallyPrime

There are several practical approaches depending on the number of Amazon orders.

Method 1: Enter Every Amazon Invoice Manually

This can work for sellers with very few orders.

In TallyPrime, create the appropriate sales voucher and enter the information from the Amazon invoice/report.

Typical structure:

Sales Voucher

Customer / Debtor

Sales Ledger or Stock Item

Taxable Value

CGST + SGST

or:

IGST

depending on the transaction.

This method gives detailed invoice-level accounting but becomes time-consuming as sales volume increases.


Method 2: Use Amazon Reports to Prepare Sales Data

For sellers processing many transactions, download the relevant Amazon tax/transaction report and prepare the data in Excel or CSV.

You can then clean and map the data according to your TallyPrime configuration.

For example:

Amazon Field Tally Field
Invoice Date Voucher Date
Invoice Number Voucher/Reference Number
Buyer Name Party Ledger
Buyer GSTIN GSTIN
SKU Stock Item
HSN HSN/SAC
Quantity Quantity
Taxable Amount Assessable/Sales Value
CGST Output CGST
SGST Output SGST
IGST Output IGST
Invoice Total Voucher Total

This approach substantially reduces manual processing.


Can Amazon Sales Be Imported Automatically into TallyPrime?

Potentially, yes.

For sellers with a large number of orders, automation can be far more efficient than entering every transaction manually.

A custom workflow can be designed as:

Amazon Report

CSV / Excel Processing

Data Validation

Tally-Compatible Mapping

Import into TallyPrime

GST Reconciliation

However, the import should not simply copy every spreadsheet row into Tally.

The system needs to understand different transaction types.


Transactions That Must Be Handled Correctly

An Amazon accounting import should account for at least the transaction types relevant to your business, including:

  • Normal sales
  • B2B sales
  • B2C sales
  • Intra-state sales
  • Inter-state sales
  • Product returns
  • Refunds
  • Credit notes
  • Order cancellations
  • Discounts
  • Shipping-related amounts where applicable
  • Marketplace adjustments
  • Seller fees
  • GST on Amazon services
  • TCS/TDS or other marketplace tax adjustments where applicable

Ignoring these can cause the Tally figures to differ from Amazon reports and GST records.


Returns and Refunds Are Especially Important

Suppose you sell a product in August and the customer returns it later.

Simply importing the original sale without considering the subsequent return can overstate:

  • Sales
  • GST liability
  • Customer/account balances
  • Inventory movement

Your accounting workflow therefore needs to identify the corresponding refund, return or credit-note transaction and account for it in the appropriate tax period according to applicable rules.


Do Not Delete the Original Sale Just Because the Product Was Returned

From an accounting and audit perspective, simply deleting a previously recorded sale is generally not the correct way to represent a genuine sale followed by a return.

The original transaction and subsequent return/credit adjustment should be represented appropriately in the books.

This also makes reconciliation much easier.


Amazon Settlement Reconciliation

After recording sales and marketplace-related charges, reconcile the amounts with Amazon settlements.

A simplified flow could look like:

Customer Sale

Amazon collects payment

Amazon applies applicable fees/adjustments

Amazon processes refunds/returns where applicable

Amazon makes settlement

Net amount reaches bank

Therefore, ideally, you should be able to reconcile:

Amazon Sales

with:

Amazon Adjustments + Charges + Refunds + Applicable Taxes + Settlement

and finally:

Bank Receipt


Amazon Fees Should Be Accounted for Separately

Do not reduce your sales value simply because Amazon charged you a marketplace fee.

For example, conceptually:

Customer Sale: ₹10,000
Amazon Charges: ₹1,000
Bank Settlement: ₹9,000

does not automatically mean:

Sales = ₹9,000

The ₹1,000 difference needs to be classified according to what Amazon actually charged or adjusted.

The figures above are only an illustration; actual Amazon charges and taxes depend on the transaction and seller account.


Check Amazon Fee Tax Invoices

Apart from customer sales information, Amazon sellers should also review the tax invoices/documents Amazon issues for services supplied to the seller.

These can be relevant when recording:

  • Amazon commission
  • Marketplace/service fees
  • Fulfilment charges
  • Other eligible expenses
  • GST charged on Amazon services

Input tax credit should only be claimed where legally eligible and where the relevant GST requirements are satisfied.


Recommended TallyPrime Ledger Structure

The exact ledger structure depends on your business, GST configuration and accounting method, but a marketplace seller may require ledgers such as:

Sales Ledgers

  • Amazon Local Sales
  • Amazon Interstate Sales

or GST-rate-specific sales ledgers where that approach suits the accounting configuration.

Output GST

  • Output CGST
  • Output SGST
  • Output IGST

Amazon-Related Ledgers

Potentially:

  • Amazon Settlement Account
  • Amazon Commission / Selling Fees
  • Amazon Other Charges
  • Amazon Refund / Adjustment accounts

Additional ledgers may be required for TCS, TDS and other marketplace adjustments depending on the transaction.

The correct ledger configuration should be based on the actual Amazon settlement/tax documents rather than assuming every deduction is commission.


Should Every Amazon Customer Be Created as a Separate Ledger in TallyPrime?

Not necessarily.

This depends on:

  • Number of orders
  • B2B vs B2C sales
  • Whether customer-wise outstanding tracking is required
  • Your accounting methodology
  • GST reporting requirements
  • TallyPrime configuration

For B2B transactions, customer-level GST details are particularly important.

For high-volume B2C marketplace sales, creating thousands of unnecessary permanent customer ledgers may make Tally data difficult to maintain.

The appropriate method should preserve the transaction information required for GST compliance and reconciliation without unnecessarily cluttering the ledger master.


Best Workflow for Amazon Sellers Using TallyPrime

A practical monthly workflow is:

  1. Download the relevant Amazon GST/tax transaction reports.
  2. Download Amazon settlement reports.
  3. Download applicable Amazon fee/tax invoices.
  4. Identify B2B and B2C transactions.
  5. Separate intra-state and inter-state transactions where required.
  6. Check taxable values and GST.
  7. Identify returns, refunds and credit notes.
  8. Record or import sales into TallyPrime.
  9. Record Amazon fees and other adjustments separately.
  10. Reconcile Amazon settlements with bank receipts.
  11. Reconcile sales and GST figures with the GST-related reports.
  12. Review discrepancies before filing the GST return.

Do You Need to Download Every PDF Sales Invoice?

For accounting purposes, you should maintain the records and documents required by applicable GST/accounting requirements, but this does not mean that the most efficient way to prepare Tally entries is to manually open every Amazon order and type every PDF invoice into Tally.

For a high-volume seller, structured Amazon reports are generally much more practical for:

  • Data processing
  • Accounting
  • Reconciliation
  • GST verification
  • Automated imports

PDF invoices can still be important as supporting documents, but structured data is much easier to process in bulk.


Example: Amazon to TallyPrime Accounting Flow

Assume Amazon reports the following sale:

Invoice: INV-1001
Taxable Value: ₹20,000
GST: 18%
Transaction: Inter-state

Then:

IGST = ₹3,600

Invoice total:

₹23,600

The Tally sales transaction would conceptually contain:

Particular Amount
Sales ₹20,000
Output IGST ₹3,600
Invoice Value ₹23,600

If Amazon subsequently deducts selling fees before settlement, those deductions should be recorded separately rather than reducing the original taxable sale to the bank amount.


Common Mistakes Amazon Sellers Should Avoid

Treating Amazon Bank Deposit as Total Sales

This can produce incorrect turnover because Amazon settlements may be net of fees, refunds and adjustments.

Ignoring Returns

Amazon marketplace businesses can have significant returns. Sales and returns need to be reconciled.

Mixing Amazon Commission with Sales

Amazon's service charges are different transactions from your customer sales.

Ignoring B2B GSTIN Information

Business invoices containing customer GSTIN information require particular attention for GST reporting.

Incorrect CGST/SGST/IGST Classification

Always verify the applicable place-of-supply and GST treatment.

Importing the Report Without Validation

Never assume every row in an Amazon report represents a new sales invoice.

A report may contain multiple transaction or adjustment types.

Entering Only Settlement Amounts

Settlement reports are extremely useful for reconciliation but should not automatically replace invoice-level sales information.


Before Filing GSTR-1

Amazon sellers should reconcile their accounting records before filing.

Check at least:

Amazon transaction/tax data

TallyPrime sales register

B2B/B2C classification

Returns/Credit Notes

GST values

GSTR-1 data

Investigate unexplained differences rather than adjusting figures merely to make the totals match.


Keep Copies of Monthly Amazon Reports

Create a structured archive for every financial year.

For example:

Amazon GST Records

  • 2026-27
    • April 2026
    • May 2026
    • June 2026
    • July 2026
    • August 2026

Inside each month, retain relevant:

  • Sales/GST reports
  • Settlement reports
  • Fee/tax invoices
  • Return/refund reports
  • Other reconciliation documents

This makes future GST reconciliation, accounting review and audits much easier.


Important GST Compliance Note

GST treatment can depend on the seller's registration, product, transaction type, place of supply, marketplace transaction, customer status and current Indian GST rules.

Amazon's report formats, Seller Central menus and marketplace processes can also change.

Therefore, use the latest reports available in your Seller Central account and verify material tax positions with current GST guidance or your CA/tax professional where necessary.


FAQ

1. Where can I download Amazon sales data for GST?

Log in to Amazon Seller Central India and check the Reports and available tax/GST reporting sections. Depending on the current interface, reports may be available through areas such as the Tax Document Library and other GST/reporting pages.

2. What is Amazon MTR?

MTR commonly refers to the Merchant Tax Report, a report containing tax-related marketplace transaction information useful for accounting and GST reconciliation.

3. Can I use Amazon MTR for TallyPrime?

Yes, the structured data can be useful for preparing or automating TallyPrime entries. However, the report should first be mapped and validated because different transaction types should not all be treated as normal sales.

4. Do I need to manually enter every Amazon invoice in TallyPrime?

Not necessarily. Low-volume sellers may enter transactions manually, while higher-volume sellers can use structured reports and an appropriate import process.

5. Can Amazon CSV or Excel reports be imported into TallyPrime?

Potentially yes. The data usually needs to be cleaned, validated and mapped into a format and structure supported by the TallyPrime import workflow being used.

6. Is the amount received from Amazon in my bank account my sales amount?

Not necessarily. The settlement can be a net amount after fees, refunds, adjustments and other transactions.

7. How should Amazon commission be entered in TallyPrime?

Amazon commission and other marketplace charges should normally be accounted for separately from customer sales, based on Amazon's actual fee/tax documents and the applicable accounting treatment.

8. What happens if an Amazon customer returns a product?

The return/refund and any associated credit-note or tax adjustment should be identified and accounted for appropriately rather than simply ignoring it.

9. Should I delete the original sales invoice after an Amazon return?

Generally, no. A genuine sale followed by a return should normally retain the original transaction and record the corresponding return/credit adjustment appropriately.

10. How do I identify B2B Amazon sales?

Review the transaction/invoice data for valid buyer GST information and other B2B details.

11. How do I identify B2C Amazon sales?

Consumer transactions without a buyer GSTIN will generally fall into B2C reporting categories, subject to applicable GST rules.

12. Does Amazon deduct GST from my sales?

Do not interpret every Amazon deduction as GST. Amazon settlements can contain multiple types of charges, taxes and adjustments. Review the underlying settlement and tax documents.

13. Can I claim GST input credit on Amazon fees?

GST charged by Amazon on eligible business services may potentially qualify for ITC subject to applicable GST law, documentation and other eligibility conditions. Verify eligibility before claiming ITC.

14. Should Amazon sales match my bank statement?

The gross sales figure will not necessarily equal the amount Amazon deposits into your bank because settlements may include deductions, refunds and adjustments.

15. Should I download Amazon settlement reports as well?

Yes. Settlement reports are important for reconciling Amazon transactions with actual bank receipts.

16. Can I automate Amazon-to-TallyPrime accounting?

Yes. A properly designed system can process Amazon reports, classify transactions, validate GST information and generate Tally-compatible import data. It should be tested carefully before being used on live company data.

17. Can I enter all Amazon sales as one monthly sales voucher?

This should not be done merely for convenience without considering GST reporting, B2B invoice-level requirements, inventory, returns, place of supply and your accounting requirements. The appropriate level of detail depends on the transactions and applicable reporting rules.

18. Which Amazon reports should I preserve?

Preserve the relevant sales/tax reports, settlement reports, fee/tax invoices, return/refund information and other records required to support your accounting and GST reconciliation.


FINAL RECOMMENDATION / CONCLUSION

For an Amazon India seller using TallyPrime, the best approach is not to treat the Amazon bank settlement as sales and not to manually type hundreds of invoices unless your transaction volume is very small.

Use the detailed sales/GST transaction reports available in Amazon Seller Central, including the Merchant Tax Report where available, and reconcile them with settlement reports, returns, refunds and Amazon fee/tax documents.

The accounting flow should be:

Amazon Customer Sales → TallyPrime Sales → Returns/Credit Notes → Amazon Fees & Adjustments → Amazon Settlement → Bank Reconciliation → GST Reconciliation

For businesses processing many Amazon orders, a carefully validated Amazon Report → TallyPrime import workflow can save substantial accounting time while reducing manual-entry errors.

Most importantly, reconcile the Amazon data with TallyPrime and the applicable GST records before filing returns rather than relying on any single Amazon report or bank settlement figure.

 

#AmazonSeller #AmazonIndia #AmazonSellerCentral #AmazonSales #AmazonInvoice #AmazonGST #AmazonMTR #MerchantTaxReport #GSTReport #GSTIndia #GSTR1 #TallyPrime #Tally #TallyGST #AmazonToTally #TallyImport #GSTAccounting #GSTReturn #GSTReconciliation #AmazonAccounting #SellerAccounting #EcommerceAccounting #EcommerceGST #OnlineSeller #MarketplaceSeller #MarketplaceAccounting #AmazonSettlement #SettlementReconciliation #BankReconciliation #AmazonCommission #AmazonSellerFees #AmazonReturns #AmazonRefund #CreditNote #B2BSales #B2CSales #IGST #CGST #SGST #HSN #GSTIN #SalesInvoice #SalesVoucher #AccountingIndia #TaxInvoice #SellerCentralIndia #TallyPrimeGST #GSTCompliance #EcommerceIndia #AmazonBusiness

YOUR FEEDBACK

Was this guide useful?

Your answer helps us keep BISONKB accurate and practical.

THE BISON BRIEF

Practical IT knowledge, once a week.

New troubleshooting guides, scripts and infrastructure notes. No noise.

By subscribing, you agree to our privacy policy.