IMPORTANT: Please make sure you create a backup of your company data before you start. This will ensure that in case of any problems with the upload, you can easily restore the old data. See the following links for how to backup / restore your data.
We accept NO responsibility if using this application results in corrupted / lost / incorrect Tally data. It takes only a few seconds and can save you a lot of pain later. BACKUP YOUR DATA NOW!!
Recent software updates - please download latest templates as earlier versions will not be supported:
August 10, 2018: Added support for manual voucher numbers and custom voucher types
August 24, 2018: Removed requirement to enter debits as negative amounts. Added support for passing Sales / Purchase Vouchers in Invoice Mode.
September 13, 2018: Added support for custom templates with unlimited ledgers debit / credit per entry.
September 14, 2018: Added support for rounding values to 2 decimals - rounding differences allocated to Debit_Amount1.
October 1, 2018: Added advanced utilities - requires login
December 12, 2018: Added support for reference date in basic template
Once you have backed up your Tally Company, proceed as follows:
You can watch a full video of the process here or read the instructions below.
STEP 1: Select utility version based on your requirement :
STEP 2: Open Tally and select the Tally company for which you are passing entries. Go to Gateway of Tally>Display>List of Accounts. On the top left corner click on E : Export. Press backspace and configure these export options (all other settings are optional).
This will open a sheet with the current list of ledgers for your company. Go to cell A1 and press (Ctrl+A) once to select the sheet data, and then press (Ctrl+C) to copy the data.
STEP 3: Open the Excel Template downloaded in Step 1 and go the the 'Ledger' sheet cell A1. Press (Ctr+V) to paste the data into the Excel Template.
Why do I need to do this?
STEP 4: Update the 'Data' sheet with the entries required to be uploaded. You need to fill Date, Narration, Voucher Type, Ledgers to be debited, Debit Amounts, Ledgers to be credited and credit amounts. Manual voucher numbers and custom voucher types are supported.
Data update tips
STEP 5: Click on the "Choose File" button below, select the saved Excel Template and click upload.