Import bank statements from excel to tally.erp9

28003 views 11 replies

Simple & easiest way to post data from Excel to Tally

EazyAUTO4 has introduced a new unique feature:

Now you can directly import your bank statements in Tally as is downloaded from bank's website. You don't have to change anything in excel sheet. Just import bank statement & directly book entries in tally 6.3 onwards.

Please note: by default these all entries will be posted to suspense account in payment & receipt mode. Afterward you can alter these entries in tally.  Or if you want to post bank entries to their relative accounts then you can alter bank statement and add ledger name column to statement sheet.

Other Featurs: Import Sales/Purchase voucher entries excel to Tally6.3 to onwords.

Download Demo Version from : www.exceltotally.in

Replies (11)

Please go through the link and obtain https://1drv.ms/u/s!AvybD673nMaKgSSMm0HtcrNSdMxR

Import from excel to tally bank statements free for 500 entries 32 bit and excel 2007

Provide feedback and suggestions for improvement and developments

In XLtool there is very simple steps to import Excel data in Tally application.

Download the latest software at - www.xltally.in

Follow these steps for import vouchers Excel to Tally -

  • First enable ODBC port in Tally application.
  • Open one Tally application & open only one company.
  • In XLTOOL software ​fillup the data in appropriate voucher template.
  • Open MY MENU by F1 Key.
  • click START button.
  • Data will be imported in Tally.
  • If any errors occurred see the details on REPORT template.
  • Read software in-built HELP template for more details.
  • If any Error then you can get alert in software REPORT template.
  • Rectify the errors and process same steps.

Import data from excel to Tally using udi-Magic Software.

  1. Start Tally ERP and Open a Company.
  2. Start udi-Magic software
  3. Select the option Excel to Tally > Import data into Tally
  4. Click the Browse button and select Standard Excel template provided with udi-Magic converter
  5. Click the Start button

Download link : https://www.rtslink.com/downloads

For more information refer : https://www.udimagic.com

Using our software Product you can do it easily !!!!!!!!!!!!!!!! contact use https://www.extally.com/

1.start tally select compnay
2.start Extally click on bank statement import button.
3.select excle file and click import.
4.set ledger names in bank statement to tally.
5.click post entries.

Using our software Product you can do it easily !!!!!!!!!!!!!!!!

contact use https://www.extally.com/

 

I contacted M. N. & Associates - chartered accounts for this and they set up everything for me. It has been working flawlessly for three years now. You can contact them here:

M.N. & Associates

Chartered Accounts

F-286, Raghuleela Mall, Kandivali West

Behind Poisar Depot

Mumbai, Maharashtra 400067

Phone: 090825 14106

Website: https://www.mnpartners.in/

 

 

Email: mitesh @ mnpartners.in

GOOD, PLEASE IMPROVE MORE

Go through this link to know - How to import bank statement in excel for reconciliation https://smane9ledge.blogspot.com/2019/03/hi-friends-today-post-is-to-make-you.H T M L

Your link to the Excel sheet is not working,Please update it on the platform.

Hello Sir, 

I tried to open the blog but it showing that the blog has been removed and isn't available. Could you please update it here

In tally  we do bank reconcilaltion by just changing that bank date on which cheque is cleared.

Also you can Auto import Bank Statements Entries in Tally with cheque data by SMAART Excel Utility.

Try - https://www.xltally.in  |  https://www.nikash.in


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register