Skip to content

A VBA Macro in Word to help auditors/accountants to quick check the casting error in Word tables

Notifications You must be signed in to change notification settings

saintxu7/VBA-Word-OneClickCasting

Repository files navigation

VBA-Word-OneClickCasting

A VBA Macro in Word to help auditors/accountants/bankers to quick check the casting error in Word tables

image

Casting:简称为Ca数。按照知乎的行业黑话解释,就是计算 审计报告及其附注里面各个数字是不是前后相符,明细和加总有无计算错误。还有各种格式调整,其实意思上,本和ca report没关系,也都被纳入ca report的范围中。

(1)竖Ca : 当明细项求和=加总数时,Word左下角的Vertical Casting会显示0。即纵向↓ 加总正确无误。 image

(2)横Ca:当明细项求和=加总数时,Word左下角的Horizontal Casting会显示0。即横向→ 加总正确无误。 image

在这个时候,当明细项求和≠加总数时,左下角的状态栏会显示不等于0。这个时候,就可以缩小范围,进一步找出错误在哪里啦。
image

一键Ca数.zip只包含一份doc文档和excel文档,完全是一键式、傻瓜式、安全绿色、无需安装的。 image KPMG的同事,请到Common Drive查找关键字“oneclickcasting”文件夹,Copy整个file到Local即可使用

About

A VBA Macro in Word to help auditors/accountants to quick check the casting error in Word tables

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages