谁和我一样，做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!