誰和我一樣，做bank recon，請幫忙！

原來銀行提供cleared checks by notepad format. 我可以直接import 到 Great Plain裏。 當我打開Great Plain時， 所有cleared checks就被自動mark. Bank recon is done in this way.

現在銀行隻提供cleared checks by excel format, 我老板說， 我可以用excel to recon. I can use vlookup to find out all cleared checks from all checks. How about bank transfer and other EFT withdrawal.And also the GJ balance won't be change if I only revise in excel.

I wonder if anyone know. Please help!!!

Thanks a lot!