logo
icons

Direct Import of Amazon Reports into TallyPrime

Are you an ecommerce seller on Amazon? Now directly import excel reports into TallyPrime to automatically record transactions.

Get started now

* Compatible with TallyPrime Release 7.1 and above

Direct Import of Amazon Reports into TallyPrime

Amazon sellers deal with large, complex Excel reports every day from B2B/B2C shipments and refunds, to settlements, each with multiple columns. Entering this data manually can be time-consuming. Now with this new solution you can import these reports directly into TallyPrime to automatically record transactions.

  • Import Amazon Excel reports directly into TallyPrime. No reformatting or pre-processing needed.
  • Data gets automatically mapped to the right voucher types: Sales, Credit Notes, Receipts, and Journals.
  • Works with your existing ledgers and stock items. No changes required.
  • Uses TallyPrime's existing excel import workflow. No new process to learn.
  • Stays up to date when Amazon changes its report formats. Your workflow is never affected.
  • Reduces hours of manual data entry to just a few clicks.

How to get started with Amazon data import?

1
Enable the Amazon Data Import Plugin
arrow
2
Download Amazon reports in .xlsx format from Amazon Seller Central
arrow
3
Complete pre-steps and import transactions into TallyPrime
arrow

How to enable Amazon data import plugin?

1

Enter your TallyPrime serial number and click “Enable Now”

2

Enter the OTP sent to your registered email ID

3

The plugin will be automatically added to your TallyPrime license

4

In case you don’t see the plugin, update your TallyPrime license (F1: Help > Settings > License > Update License)

How to download amazon reports?

1

Log in to your Amazon Seller Central account

2

Navigate to the Reports section

3

Download the relevant report in .xlsx format

4

Save the file to your computer

Steps to Import Amazon Reports into TallyPrime

1

As a pre-step, import the pre-requisite ledger list provided by TallyPrime, present in the Plugin folder (In case you don't have the ledgers required for importing Amazon data)

2

Mention the SKU provided in Amazon MTR as an Alias for the stock items

3

Select the Mapping Templates provided by Tally under Amazon in the List of Mapping Templates

4

Import the transactions into TallyPrime

5

For detailed steps, refer to the Read me document present in Tally application path> appresources>Plugin> AmazonDataImport

Amazon Files Supported for Import by the Plugin

Document Type Transaction Type in Tallyprime
Amazon B2B & B2C Shipments Sales Voucher
Amazon B2B & B2C Refunds Credit Note Voucher
Amazon Settlements Receipt Voucher & Journal Voucher

How to disable the plug-in?

1

Enter your TallyPrime serial number

2

Click Disable Plugin

3

Verify with OTP

4

The plugin will be disabled automatically

FAQ

As an Amazon seller, you deal with multiple Excel reports for B2B/B2C sales, refunds, and settlements. The Amazon Data Import Plugin lets you import these reports directly into TallyPrime, saving time and eliminating manual data entry errors.

The plugin is available at no additional cost. You only need a valid TallyPrime license with an active TSS and Release 7.1 or above to use it.

You can import B2B Shipment, B2C Shipment, B2B Refund, B2C Refund, and Settlement reports. Each report is automatically mapped to the right voucher type in TallyPrime — Sales, Credit Notes, Receipts, and Journals.

Yes. The plugin works with your existing TallyPrime data. You do not need to recreate any ledgers or stock items.

No. The plugin works directly with standard Amazon-generated Excel reports. No changes or reformatting required.

The plugin activation takes under 5 minutes. Once enabled, you can start importing your Amazon reports right away.

You need TallyPrime Release 7.1 or above to use this plugin.