论文部分内容阅读
在企业审计过程中,常会为验算企业存货出库成本的准确性而大伤脑筋,若利用Excel表功能自编小程序进行验算,会达到事半功倍的效果。 步骤一:扎框架。新建工作表,在A1(A列1行,以下均为简称)中键入需验算的品种名称,在A2中键入被审计单位名称、E2审计时间、I2计量单位,在A3中键入月份、B3中键入入库、D3中键入出库,F3中键入结存、I3中键入应转出库成本、J3中键入差额;B4中键入入库数量、C4键入入库金额、D4中键入出库数量、E4中键入出库金额,F4中键入结存数量、G4键入结存平均单价、
In the course of business auditing, it is often troubling to check the accuracy of the stock cost of the enterprise stock. If you use the Excel function to compile a small applet, you will achieve a multiplier effect. Step one: tie the framework. In the new worksheet, type the name of the breed to be checked in A1 (row 1 and row 1, the following abbreviations are abbreviated), enter the name of the audited entity in A2, E2 audit time, I2 measure, type month in A3, B3 Type into the library, enter the library in D3, F3, enter the balance, I3 type should be transferred out of the library costs, J3, type the difference; B4, enter the number of storage, C4 enter the amount of storage, D4 type the number of the library, E4 Enter the amount of the library, F4, type the number of balances, G4 key balance average unit price,