Comparing the balances!!!

This query is : Resolved

Satyanarayanan (Querist)
Follow

15 May 2010 In our company we have two softwares
(i) customised ERP - upgraded one
(ii) Customised Software based on VB- the earlier one.
Currently we are working on both the versions. There is differences in balances between the two versions. On both the versions we can transfer the data to Ms-Excel.I want to compare the two ledgers and have to give a report why there is differences. There are many balances to be compared it may take more time...so it will be great if some one can help me in this issue.

Nischint Kumar Somani

Nischint Kumar Somani (Expert)
Follow

16 May 2010 i have not seen both the ledgers, if u can send me the file after analysis i can help u..u can send me the file at canischintsomani@gmail.com

Ram Avtar Singh

Ram Avtar Singh (Expert)
Follow

16 May 2010 Make Trial Balance both and copy in excel sheet1 and sheet2

use vlookup commond in sheet2 in next column for amount will collect in front of account head.

give commond in next column (ist debit amount)-(next debit amount) diff will shown.

it will take hardly 15 minuts only

thanks

Upgrade to CAclubindia Pro. Subscribe Now!