Page Comparison

...

•  1. Ensure June of the financial period you are reporting for is marked as 'Current'
•  2. Import the ‘Extract’ JSON files (provided below) into the Report Manager grid
  •  ITC Cash Extract
  •  ITC Expenditure Extract
  •  ITC Receipt Extract
  •  ITC OPU Extract
•  3. Download the 'EMISFFE First 6 Columns' Excel spreadsheets (provided below) to your computer.
  •  EMISFFE Cash First 6 Columns
  •  EMISFFE Expenditure first 6 Columns
  •  EMISFFE Receipt First 6 Columns
  •  EMISFFE OPU First 6 Columns
•  4. Generate and format ITC Cash Extract 
  •  In USAS-R, generate the ITC Cash Extract spreadsheet for the 025 funds
  •  Open the EMISFFE Cash First 6 Columns spreadsheet and copy the first 6 columns (A-F) and insert them into the first 6 columns (A-F) of the ITC Cash Extract spreadsheet (copying down the data to match the number of cash rows)
  •  Add the IRN in Column B (format the column as text to include leading zeroes)
  •  Edit the Fund Class in Column K to a one character code (Fund Class codes listed on page 3 of EMIS Cash Record chapter) 
  •  Edit the ODE Brief Description in Column I if it exceeds 21 characters. 
  •  Before saving the file in CSV format, remove Line 1 (header row).  It cannot be included when importing into EMISFFE. (example below)

...