Expense Analysis as CSV for Excel (GL62) Previous Top Next

 
FunctionReport to output expense analysis onto a CSV file for reading in Excel
  
How To UseEnter The Parameters
 Report TitleTitle to be printed
 Year 
 Period 
 Analysis OptionSingle / Dual / Triple Analysis
 Analysis CategoryCategories of analysis to report on. Number depends on selection of "Analysis Option"
 Analysis ValuesValues of categories to be compared
 Account SelectionAccount Code / Account Group
 Account / Account GroupA single account code or a group of accounts based on option under "Account Selection"
 Output OptionPrint Totals only / Print Totals and Details
  
Parameter ScreenEnter Parameters

  
Transfer to XLClick button to send the report to Excel
  
Report OutputOutput as seen in Excel

  
Pre-requisites 
  
Notes