谁和我一样，做bank recon，请帮忙！

来源: nana1 于 2010-02-04 17:17:45 [] [博客] [旧帖] [给我悄悄话] 阅读数 : (512 bytes)

原來银行提供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!

所有跟帖： 

• 回复：谁和我一样，做bank recon，请帮忙！ -sea123- ♀ 给 sea123 发送悄悄话 (79 bytes) () 02/04/2010 postreply 18:14:01

请您先登陆，再发跟帖！