Preload Configuration – E-Commerce Settlement
There are some pre-requisites to the basic data of e-commerce of Flipkart & Amazon to for data upload to Tally.
Multiple Alias for Masters
Multiple alias can be imported for all Masters. Using the column in excel Name_Name for adding alias name in multiple line for single master. This feature is common for all the masters (example: Ledger, Stock Item, Cost Centre and etc.).
Mandatory Column in Excel for Vouchers
There are global logic followed in Excel for managing excel templates for all the vouchers. In excel some columns are mandatory and Some columns are Dynamic Common Mandatory Column in Vouchers
Verify, Analyse and Configure Excel Data for Vouchers
Once the Excel file is loaded, proceed verify, analyse and configure data before import If the excel file is not loaded and any error pop-up, check the lists of errors for rectification. Use the data grid features, such as filter, search & group to analyse the loaded data. Click verify masters button (at the bottom…
Excel Formats for Receipt & Payment
There are two types of Excel formats available for Receipts & Payments. Simple Columnar Formats Multi Line Formats
Auto Tax Settings and Compliance for Vouchers
Vouchers imported using Tally Master - Excel to Tally are compatible with for Tax (GST & Others) settings and compliances. When ledgers, ledger group, stock group and stock items are properly configured with Tax settings in Tally, Tally Master - Excel to Tally will be adopting for perfect Tax computation…