誰和我一樣，做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

請您先登陸，再發跟帖！