Financial Extraction for an ITC
The checklist below may be used for ITCs whose data is included with their fiscal agent’s data and must extract their 025 fund's cash, expenditure, receipt and ITC's specific OPU data for the ITC's financial reporting. (May also be used for ITCs who are their own COG who have other funds but need to extract just 025 fund). The checklist will cover:
How to import the provided JSON files into USAS-R in order to extract the ITC’s 025 Cash, Expenditure, Revenue and OPU data from their respective grids into spreadsheets
Using provided EMISFFE spreadsheets to copy the required ODE columns and insert them into the newly created spreadsheets.
Adding/editing any columns in order to prepare the spreadsheets for EMISFFE import
Importing into EMISFFE and extract the QC data into a sequential file.
EMISFFE Import Troubleshooting
CSV Invalid format error, this error will occur when the CSV layout does not match the Chapter 5 layout minus the filler, fiscal year and reporting period fields.
Negative numbers, must be formatted with a minus ( - ) sign. Negative values that are represented using parenthesis rather than a minus sign will cause an error during the import.
Please ensure leading zeroes are included in the account code dimensions before importing into EMISFFE (i.e. 025 fund code contains the leading ‘0’)