You can use the udiMagic Standard template to upload Amazon Sales entries into Tally.


Template Name : Vouchers-V11-Sales-Purchase-With-Stockitems-Advanced.xls 


B2C Sales [Sale to Unregistered dealers or consumers]

  • Please refer the Row Nos 41 and 42 in the Standard Excel sheet. which contain sample data for B2C Sales. 
    • Column V : Unregistered
  • The Amazon (or Flipkart) ledger name must be written in Column H (under section Party Ledger)
  • The Buyer Name and address must be written in the Columns N to W [under section Buyer / Supplier details]


B2B Sales [Sale to Registered Dealers]

  • For Sale to Registered dealers, you must specify the GST details in the Excel sheet as shown
    • Column V : Regular
    • Column W : <GSTIN>
  • The Amazon (or Flipkart) ledger name must be written in Column H (under section Party Ledger)
  • The Buyer Name and address must be written in the Columns N to W [under section Buyer / Supplier details]


IMPORTANT

  • You have to manually set the option "Is e-commerce operator" as Yes in Tally for the Amazon (or Flipkart) ledger. This is to be done once only.