... 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:
TASK 3: Suggested Improvement
The codes can be...