How to export to Tally
This article will take you through a step by step guide on how to export data from Indecab to Tally ERP 9.
Important: 'Export to Tally' would only work if your Tally version is GST enabled. To enable GST in Tally click on F11 and then F3 and complete the GST settings.
Make sure that the Ledger names in Tally and the Customer names in Indecab match; if they do not match when you import a new Ledger will be created.
*If you are importing data from Indecab to Tally for the first time it is a good practice to start by creating a copy of your company in Tally and import data from Indecab into the copy. Make sure everything is in order and only then import into your original company.
After an import is complete and if any changes are made to invoices on Indecab, you would need to re- import the vouchers and do the edits to reflect in Tally.
If you are going to be importing Petty Cash entries to Tally you would need to create voucher Type "Petty Cash" manually within Tally under the Payment Voucher category. Petty Cash would not get imported without this done.
Below are a few settings needed in Tally before you can start importing. This is to be done only once.
1 - Select your company and open ‘Accounts info’.
2 - Open 'Voucher Types'
3 - Select 'Alter'
4 - Select 'Sales' from the list of voucher types. If you don't have 'Sales' in the list you would need
to create it.
5 - Change the ‘Method of Voucher Numbering’ to Manual. This is to be done so that Tally is able to
accept Indecab’s invoice numbering format.
6 - Go back to the 'Gateway of Tally' menu and select 'Accounting Vouchers'
7 - Press F11 or click on Features as shown below
8 - Make sure that ‘Allow Zero valued entries’ is set to ‘Yes’. We are doing this to make sure Tally
can accept Cancelled Invoices as well.
1 - The ‘Export to Tally’ option can be found in the ‘Me’ menu at the top right of the screen.
2 - Export Vouchers
Select the date range you would like to export.
Select the company you are exporting (If you use the sister companies feature)
Click on ‘Export Ledgers’.
Tip: Always ‘Export Ledgers’ first before exporting vouchers.
Next, you can Export Sales, Receipts, Purchases, Payments, Credit/Debit Notes, Petty Cash, Vehicle Fuel, Vehicle Expenses under different sections.
3 - Select Ledgers/Voucher that you want to download> You will see the downloaded file on the bottom of your screen
1 - Click on the arrow icon and then click on ‘Show in folder’.
2 - Right click on the file select ‘Open with’ and then select ‘Choose another app’
3 - Go through the list and click on ‘Google Chrome’.
4 - Copy the address visible using ‘Ctrl + C’
5 - Open Tally again and select ‘Import of Data’
6 - Select ‘Masters’
7 - A box will open. There paste the address using Ctrl + Alt + V. This will create Ledgers in Tally from the Customers you have created in Indecab. Please note that the file path and name should match exactly for the import to take place.
8 - Once the Ledger import is complete. Next, is the Vouchers import. Select ‘Vouchers’ and follow the
same process of entering the exact file path and name.
Please note in Tally:
The 'Voucher Date' is the Supplier Invoice date of the bill as in Indecab
The 'Effective Date' is the Purchase invoice date as in Indecab
While exporting we filter by the 'Purchase invoice' date as in Indecab.
Important: 'Export to Tally' would only work if your Tally version is GST enabled. To enable GST in Tally click on F11 and then F3 and complete the GST settings.
Things to remember before starting:
Make sure that the Ledger names in Tally and the Customer names in Indecab match; if they do not match when you import a new Ledger will be created.
*If you are importing data from Indecab to Tally for the first time it is a good practice to start by creating a copy of your company in Tally and import data from Indecab into the copy. Make sure everything is in order and only then import into your original company.
After an import is complete and if any changes are made to invoices on Indecab, you would need to re- import the vouchers and do the edits to reflect in Tally.
If you are going to be importing Petty Cash entries to Tally you would need to create voucher Type "Petty Cash" manually within Tally under the Payment Voucher category. Petty Cash would not get imported without this done.
Step 1 - Complete settings needed in Tally
Below are a few settings needed in Tally before you can start importing. This is to be done only once.
1 - Select your company and open ‘Accounts info’.
2 - Open 'Voucher Types'
3 - Select 'Alter'
4 - Select 'Sales' from the list of voucher types. If you don't have 'Sales' in the list you would need
to create it.
5 - Change the ‘Method of Voucher Numbering’ to Manual. This is to be done so that Tally is able to
accept Indecab’s invoice numbering format.
6 - Go back to the 'Gateway of Tally' menu and select 'Accounting Vouchers'
7 - Press F11 or click on Features as shown below
8 - Make sure that ‘Allow Zero valued entries’ is set to ‘Yes’. We are doing this to make sure Tally
can accept Cancelled Invoices as well.
Settings completed!
Step 2 - Exporting from Indecab
1 - The ‘Export to Tally’ option can be found in the ‘Me’ menu at the top right of the screen.
2 - Export Vouchers
Select the date range you would like to export.
Select the company you are exporting (If you use the sister companies feature)
Click on ‘Export Ledgers’.
Tip: Always ‘Export Ledgers’ first before exporting vouchers.
Next, you can Export Sales, Receipts, Purchases, Payments, Credit/Debit Notes, Petty Cash, Vehicle Fuel, Vehicle Expenses under different sections.
3 - Select Ledgers/Voucher that you want to download> You will see the downloaded file on the bottom of your screen
Step 3 - Exporting into Tally
1 - Click on the arrow icon and then click on ‘Show in folder’.
2 - Right click on the file select ‘Open with’ and then select ‘Choose another app’
3 - Go through the list and click on ‘Google Chrome’.
4 - Copy the address visible using ‘Ctrl + C’
5 - Open Tally again and select ‘Import of Data’
6 - Select ‘Masters’
7 - A box will open. There paste the address using Ctrl + Alt + V. This will create Ledgers in Tally from the Customers you have created in Indecab. Please note that the file path and name should match exactly for the import to take place.
8 - Once the Ledger import is complete. Next, is the Vouchers import. Select ‘Vouchers’ and follow the
same process of entering the exact file path and name.
Import complete!
You may now view the Ledgers and Sales or Purchase register to see the data you have just imported.
Please note in Tally:
The 'Voucher Date' is the Supplier Invoice date of the bill as in Indecab
The 'Effective Date' is the Purchase invoice date as in Indecab
While exporting we filter by the 'Purchase invoice' date as in Indecab.
Updated on: 14/06/2022
Thank you!