摘要
文章尝试模拟人工对账的方式,从财会知识、账间联系、财会人员经验等提炼出多种对账的思路与方法,以及后备保障措施,并用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.
作者
郑文全
邓丹
罗贵东
梁泽琳
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)
出处
《自动化应用》
2023年第3期189-193,196,共6页
Automation Application
关键词
VBA
银企对账
自动化
字典
命中率
VBA
bank-enterprise reconciliation
automation
dictionary
hit rate
