摘要
提高应收账款的管理效率是企业营运资金管理的核心内容之一,强化应收账款管理可以有效地提高企业资金运作的效率,增强资金的流动性。应收账款财务数据多样却庞大,能否对数据做高效的归类与整理直接决定财务工作的效率,应用excel技术对应收账款管理能显著提高管理效率,该文结合应收账款的常用管理,列举并总结出了部分实用的应收账款管理中的excel技术来帮助我们统计和自动计算,就可以有效减轻财务的工作量。
Improving the management efficiency of accounts receivable is one of the core contents of enterprise working capital man?agement.Strengthening the management of accounts receivable can effectively improve the efficiency of enterprise capital opera?tion and enhance the liquidity of funds.The financial data of accounts receivable are various but huge.Whether the data can be classified and sorted efficiently directly determines the efficiency of financial work.The application of Excel technology in the man?agement of accounts receivable can significantly improve the management efficiency.Combining with the common management of accounts receivable,this paper lists and summarizes some practical excel techniques in the management of accounts receivable.To help us count and calculate automatically,we can effectively reduce the financial workload.
作者
阎冰洁
刘建生
YAN Bing-jie;LIU Jian-sheng(Jiangxi University of Science and Technology,Ganzhou 341000,China)
出处
《电脑知识与技术》
2019年第7期211-213,共3页
Computer Knowledge and Technology
关键词
应收账款
EXCEL
构成分析
账龄分析
accounts receivable
excel
composition analysis
aging analysis
