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.
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
2
Download Amazon reports in .xlsx format from Amazon Seller Central
3
Complete pre-steps and import transactions into TallyPrime
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
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)
Mention the SKU provided in Amazon MTR as an Alias for the stock items
Select the Mapping Templates provided by Tally under Amazon in the List of Mapping Templates
Import the transactions into TallyPrime
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 |
Get in Touch with Us
We’re Here to Help with All Your Tally Needs!