Convert a old chart of accounts to a new one

[virsanpal]

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 695"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]OLD[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]NEW[/TD]
[/TR]
[TR]
[TD]Account[/TD]
[TD]Description[/TD]
[TD][/TD]
[TD]Account[/TD]
[TD]Description[/TD]
[/TR]
[TR]
[TD]042101002[/TD]
[TD]House Fund - General Cashier[/TD]
[TD][/TD]
[TD]1000[/TD]
[TD]HOUSE FUNDS[/TD]
[/TR]
[TR]
[TD]042101003[/TD]
[TD]House Fund - Human Resources[/TD]
[TD][/TD]
[TD]1010[/TD]
[TD]BANK REVENUE ACCOUNT[/TD]
[/TR]
[TR]
[TD]042101004[/TD]
[TD]House Fund - Materials Manager[/TD]
[TD][/TD]
[TD]1011[/TD]
[TD]BANK EXPENSE ACCOUNT[/TD]
[/TR]
[TR]
[TD]042101006[/TD]
[TD]House Fund - Outlet Cashiers[/TD]
[TD][/TD]
[TD]1012[/TD]
[TD]BANK ACCOUNT ALCOHOL[/TD]
[/TR]
[TR]
[TD]042101007[/TD]
[TD]House Fund - Front Office Depa[/TD]
[TD][/TD]
[TD]1020[/TD]
[TD]BANK ACCOUNT TERM DEPOSIT[/TD]
[/TR]
[TR]
[TD]042102001[/TD]
[TD]Bank Account 1 - Expense[/TD]
[TD][/TD]
[TD]1070[/TD]
[TD]VISA CREDIT CARD[/TD]
[/TR]
[TR]
[TD]042102002[/TD]
[TD]Bank Account 2 - Collection[/TD]
[TD][/TD]
[TD]1071[/TD]
[TD]MASTER CREDIT CARD[/TD]
[/TR]
[TR]
[TD]042102003[/TD]
[TD]Bank Account 3 - Alcohol[/TD]
[TD][/TD]
[TD]1072[/TD]
[TD]AMEX CREDIT CARD[/TD]
[/TR]
[TR]
[TD]042104001[/TD]
[TD]Guest Ledger[/TD]
[TD][/TD]
[TD]1073[/TD]
[TD]DINERS CREDIT CARD[/TD]
[/TR]
[TR]
[TD]042104002[/TD]
[TD]City Ledger[/TD]
[TD][/TD]
[TD]1074[/TD]
[TD]JCB CREDIT CARD[/TD]
[/TR]
[TR]
[TD]042104004[/TD]
[TD]AR Employee Loan[/TD]
[TD][/TD]
[TD]1080[/TD]
[TD]CHECKS UNDER COLLECTION[/TD]
[/TR]
[TR]
[TD]042104005[/TD]
[TD]AR Employee Advances[/TD]
[TD][/TD]
[TD]1081[/TD]
[TD]PETTY CASH[/TD]
[/TR]
[TR]
[TD]042104007[/TD]
[TD]AR Insurance Claims[/TD]
[TD][/TD]
[TD]1085[/TD]
[TD]NOTE RECEIVABLE[/TD]
[/TR]
[TR]
[TD]042104009[/TD]
[TD]AR Overpayment, Leave Settlement[/TD]
[TD][/TD]
[TD]1090[/TD]
[TD]CASH SALES CLEARANCE[/TD]
[/TR]
[TR]
[TD]042104010[/TD]
[TD]AR Travel Advance[/TD]
[TD][/TD]
[TD]1091[/TD]
[TD]CITY LEDGER CLEARANCE[/TD]
[/TR]
[TR]
[TD]042104011[/TD]
[TD]AR Visa Advance[/TD]
[TD][/TD]
[TD]1092[/TD]
[TD]CREDIT CARD CLEARANCE[/TD]
[/TR]
[TR]
[TD]042104020[/TD]
[TD]VAT - Input Tax 5%[/TD]
[TD][/TD]
[TD]1093[/TD]
[TD]GENERAL CASHIER CLEARANCE[/TD]
[/TR]
[TR]
[TD]042104090[/TD]
[TD]AR Others[/TD]
[TD][/TD]
[TD]1094[/TD]
[TD]TIPS CLEARANCE[/TD]
[/TR]
[TR]
[TD]042104099[/TD]
[TD]Provision for Bad & Doubtful Debt[/TD]
[TD][/TD]
[TD]1095[/TD]
[TD]FOREIGN EXCHANGE CLEARANCE[/TD]
[/TR]
[TR]
[TD]042106001[/TD]
[TD]Food Main Store[/TD]
[TD][/TD]
[TD]1096[/TD]
[TD]PACKAGE LEDGER CLEARANCE[/TD]
[/TR]
[TR]
[TD]042106002[/TD]
[TD]******* Food Stock[/TD]
[TD][/TD]
[TD]1100[/TD]
[TD]RECEIVABLES (CITY LEDGER)[/TD]
[/TR]
[TR]
[TD]042106005[/TD]
[TD]Beverage Main Store[/TD]
[TD][/TD]
[TD]1101[/TD]
[TD]RECEIVABLES (GUEST LEDGER)[/TD]
[/TR]
[TR]
[TD]042106006[/TD]
[TD]Outlet Beverage Stock[/TD]
[TD][/TD]
[TD]1105[/TD]
[TD]RECEIVABLE VACATION / FINAL SETTLEMENT[/TD]
[/TR]
[TR]
[TD]042106007[/TD]
[TD]Tobacco[/TD]
[TD][/TD]
[TD]1110[/TD]
[TD]RECEIVABLE INTEREST[/TD]
[/TR]
[TR]
[TD]042106009[/TD]
[TD]Outlet Merchandise Stock[/TD]
[TD][/TD]
[TD]1113[/TD]
[TD]TRAVEL ADVANCES[/TD]
[/TR]
[TR]
[TD]042106010[/TD]
[TD]General Stores[/TD]
[TD][/TD]
[TD]1114[/TD]
[TD]SALARY ADVANCES[/TD]
[/TR]
[TR]
[TD]042106020[/TD]
[TD]Engineering Stores[/TD]
[TD][/TD]
[TD]1115[/TD]
[TD]SUPPLIER ADVANCES[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
[/TD]
[/TR]
</tbody>[/TABLE]
Good Morning,
I need to convert the old chart of accounts to a new one with different numbers and names. Although the names are similar, for example receivables (City Ledger) corresponds tp City ledger on the old one. So I want to match it and once it finds similar wording change the account number.
I tried vlookup and search but is not working.
Could you help me on this. Thanks in advance Virginia

 

[Michael M]

Looking at bot tables, they don't really have much in common.....I'm guessing you will be honing your typing skills for this one !!

 

[virsanpal]

I know that is how they gave it to me so dont really know what to do.