基于VBA的银企对账自动化设计与实现  

Design and Realization of Bank-Enterprise Reconciliation Automation Based on VBA

作　　者：郑文全[1] 邓丹 罗贵东 梁泽琳 ZHENG Wenquan;DENG Dan;LUO Guidong;LIANG Zelin(Dazhou Meteorological Bureau,Dazhou,Sichuan 635000,China;Social Security Bureau of Dachuan District,Dazhou,Sichuan 635000,China)

机构地区：[1]达州市气象局,四川达州635000 [2]达州市达川区社保局,四川达州635000

出　　处：《自动化应用》2023年第3期189-193,196,共6页Automation Application

摘　　要：文章尝试模拟人工对账的方式,从财会知识、账间联系、财会人员经验等提炼出多种对账的思路与方法,以及后备保障措施,并用VBA自动化实现上述对账过程,将财会人员从重复性工作中解放出来,提高对账效率,减少出错率。This paper attempts to simulate the way of manual reconciliation,extracts a variety of reconciliation ideas and methods from accounting knowledge,the relationship between accounts,and the experience of accounting personnel,etc.,as well as backup measures,and uses VBA automation to relaize the above reconciliation process.Liberating accounting personnel from repetitive work,improving reconciliation efficiency and reducing error rate.

关 键 词：VBA 银企对账 自动化 字典 命中率 

分 类 号：TP29[自动化与计算机技术—检测技术与自动化装置]