Generate Account Detail for Current Sheet

The Generate Account Detail option allows users to create an audit trail, listing the individual accounts and balances included in the GXL formulas of the worksheet.

1. In Excel, from the Spreadsheet Server Ribbon, select Execute Reports > Account Detail Report. The Generate Account Detail Options panel appears.

2. In the Generate Account Detail Options panel, specify the following processing criteria:
• Source Worksheet Input:
  • Column that contains the description: identify the column in the worksheet containing the report line description. This description is used as the first column in the extracted audit trail.
  • Row that contains the first GXL Formula: identify the first row containing a GXL formula to be used in generating the detail. This will set the starting point for the extracted audit trail.
• Target Options:
  • Indicate whether to copy the selected records to the Windows clipboard, or to paste data directly in a target worksheet in the spreadsheet. When pasting directly to a worksheet, a starting cell and target worksheet must be specified.
3. Click OK. An audit trail showing the line description, all included accounts, and their balances will be generated.