If you sell products on Amazon, you already know how challenging it can be to manage accounting. Every day, Amazon generates multiple reports for sales, refunds, settlements, and payments. Manually entering this information into your accounting software is not only time-consuming but also increases the chances of costly errors.
With New TallyPrime 7.1 Release, Amazon sellers can now directly import Amazon Excel reports into TallyPrime, making bookkeeping faster, simpler, and more accurate. This new capability helps businesses automate transaction recording while reducing manual effort.
What is Amazon Data Import in TallyPrime?
Amazon Data Import is a built-in feature available in TallyPrime Release 7.1 and later. It allows businesses to import Amazon-generated Excel reports directly into TallyPrime without manually editing or restructuring the files.
The feature automatically maps Amazon transaction data to the appropriate accounting vouchers, helping businesses complete accounting tasks in just a few clicks.
Key Benefits of Amazon Data Import
1. Direct Excel Import
There’s no need to modify Amazon reports before importing them. Simply download the report from Amazon Seller Central and import it into TallyPrime.
2. Automatic Voucher Creation
TallyPrime intelligently converts imported data into the correct voucher types, including:
- Sales Vouchers
- Credit Notes
- Receipt Vouchers
- Journal Vouchers
This significantly reduces manual accounting work.
3. Works with Existing Masters
You don’t need to recreate your stock items or ledger accounts. The import process works with your existing TallyPrime data.
4. Faster Month-End Closing
Instead of spending hours entering transactions, accountants can complete imports in minutes, making monthly reconciliation much faster.
5. Reduced Human Errors
Since information is imported directly from Amazon reports, the possibility of typing mistakes and duplicate entries is greatly reduced.
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
How to Import Amazon Reports into TallyPrime
Step 1: Enable the Amazon Data Import Plugin.
Step 2: Download the required Amazon report in Excel (.xlsx) format from Amazon Seller Central.
Step 3: Ensure the required ledgers and stock item aliases are available in TallyPrime.
Step 4: Select the appropriate Amazon mapping template.
Step 5: Import the report using TallyPrime’s Excel Import feature.
Once completed, the transactions are automatically recorded in your books.
To use this feature, you need:
- TallyPrime Release 7.1 and Active TSS (Tally Software Services) Click Here To Update Tally Prime Latest 7.0 Version
📞 Contact Us:
+91-9910022478
📧 Email:
info@webtakersit.com
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.