How to export to Tally

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, a new Ledger will be created when you import.

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 will need to re- import the vouchers and edit them for them to be able to reflect in Tally.

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 will 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 - select Date range - select the company you are exporting (If you use the sister companies feature) - select the type of Export - click on Export Ledgers.

Next, you can Export Sales, Receipts, Purchases, Payments, Credit/Debit Notes, Petty Cash, Vehicle Fuel, Vehicle Expenses under different sections.

Step 3 - Exporting into Tally

Select the imported file - right click on the file and click on Open With - choose another app - select Internet explorer or a browser -

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 comes 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.