Designing a Coding Scheme - Lab Report Example

Lab Report, Finance and Accounting Designing a Coding Scheme TASK 2: Explanation of how the Works The for generation of the Financial Reports work though Excel Macro Functions, through Excel Pivot Charts and Excel Filtering technique. The Coded Report Consist of four sheets, the Reconciliation Template sheet, Pivot sheet, Current Outstanding Items and Cleared Items. The ultimate function of the coding is to ensure that the balance for the items is zero, to prove that the reconciliation code worked as required.

The functions are developed in reference to different sheets. For example, the amounts in the Reconciliation Template are calculated as:=+Pivot!E23TASK 3: Suggested ImprovementThe codes can be improved by development of Graphical User Interface by integrating the program codes to Excel VBA utility. The reports can then be operated in a friendlier manner that is easier to use.