OFFICE OF FINANCIAL MANAGEMENT

Updated 04/14/01

---

ITA CUSTOM REPORTS

ITA010 - ITA015, Program Hierarchy Reports. Various hierarchy reports are generated for use as a crosswalk for smart codes and accounting structure. Three reports are for the current budget-fiscal-year, smart code to accounting structure and are sorted as follows: ITA010 by program, ITA011 by fund, and ITA012 by organization.
 

ITA100 - Itemized Transactions Report. This report is for the current budget-fiscal-year/current month activity showing details for obligations and expenditures grouped into cost categories by budget object code. The primary sort is by organization, BFY/fund, cost category, document number.
 

ITA101 - Itemized Transactions Report - Prior Years. This report is for the prior budget-fiscal-year/current month activity showing details for obligations and expenditures grouped into cost categories by budget object code. The primary sort is by organization, BFY/fund, cost category, document number.
 

ITA102 - Cumulative Transaction Report. This report is cumulative for the fiscal year activity showing details for obligations and expenditures grouped into cost categories by budget object code. The primary sort is by organization, BFY/fund, cost category, document number.
 

ITA105 - Document Summary Report. This report is a current snapshot of outstanding obligations at the date and time the report is run. It includes document details for unliquidated balances. Once the document outstanding balance is 0, the document is excluded from the report. The primary sort is by organization, BFY/fund, document number.
 

ITA106 - Document Summary Report. This report is a current snapshot of obligations at the date and time the report is run. It includes document details for obligations, accruals, expenditures for all transactions including documents with 0 balances. The primary sort is by organization, BFY/fund, document number.
 

ITA120 - Object Summary by Organization. This report shows obligations, payroll accruals, expenditures, and YTD total summarized to the budget object code. The dollar amounts are cumulative for the budget-fiscal-year. The primary sort is by organization, BFY/fund, budget object code.
 

ITA121 - Object Summary by Two-Digit Organization. This report shows obligations, payroll accruals, expenditures, and YTD total summarized at the two-digit organization (11XX, 12XX, etc.). The dollar amounts are cumulative for the budget-fiscal-year. The primary sort is by organization at the two-digit organization level, BFY/fund, budget object code.
 

ITA122 - Object Summary by Division Report. This report shows obligations, payroll accruals, expenditures, and YTD total summarized at the division level. The dollar amounts are cumulative for the budget-fiscal-year. The primary sort is by division, BFY/fund, budget object code.
 

ITA123 - Object Summary by BFY/Fund. This report shows obligations, payroll accruals, expenditures, and YTD total summarized at the BFY/fund level. The dollar amounts are cumulative for the budget-fiscal-year. The primary sort is by BFY/fund, budget object code.
 

ITA125 - Project Summary by Organization Report. This report shows obligations, payroll accruals, expenditures, and YTD total for each project within organization. The dollar amounts are cumulative for the budget-fiscal-year. This report is summarized at the cost category level determined by budget object code. The primary sort is by organization, BFY/fund, project number, cost category.
 

ITA126 - Project Summary by Division Report. This report shows obligations, payroll accruals, expenditures, and YTD total for each project within division. The dollar amounts are cumulative for the budget-fiscal-year. This report is summarized at the cost category level determined by budget object code. The primary sort is by division, BFY/fund, project number, cost category.
 

ITA127 - Project Summary by Two-Digit Organization Report. This report shows obligations, payroll accruals, expenditures, and YTD total for each project summarized at the two-digit organization (11XX, 12XX, etc.). The dollar amounts are cumulative for the budget-fiscal-year. The primary sort is by organization at the two-digit organization level, BFY/fund, project number.
 

ITA128 - Project Summary by BFY/Fund. This report shows obligations, payroll accruals, expenditures, and YTD total for each project summarized at the BFY/fund. The dollar amounts are cumulative for the budget-fiscal-year. The primary sort is by BFY/fund, project number, organization.
 

ITA129 - Departmental Centralized Services Major Project Summary Report. This report shows annual budget, obligations, payroll accruals, expenditures, YTD total, and balance summarized at the major project level within Departmental Centralized Services. The dollar amounts are cumulative for the budget-fiscal-year. The primary sort is by division, organization, BFY/fund, project number.
 

ITA215 - Travel Related Undelivered Orders by Organization- BOC's 2111, 2112, 2131, or 2132 and Converted from ITAAS. This report shows travel orders with outstanding amounts for domestic and foreign common carrier and per diem. It shows vendor name and code, date, order number, accounting strip, and outstanding amount. The primary sort is by BFY/fund, organization, vendor name, document number.
 

ITA216 - Travel Related Undelivered Orders by Organization - BOC's 2111, 2112, 2131, or 2132 and Travel Begin Date < XX/XX/XXXX. This report shows travel orders with outstanding amounts for domestic and foreign common carrier and per diem for travel dates prior to a specified date. It shows vendor name and code, date, order number, accounting strip, and outstanding amount. The primary sort is by BFY/fund, organization, vendor name, document number.
 

ITA219 - Partially Closed Travel Related Undelivered Orders by Organization - BOC's 2111, 2112, 2131, 2132 and Travel Begin Date XX/XX/XXXX. This report shows partially closed travel orders for domestic and foreign common carrier and per diem for travel dates prior to a specified date. It shows travel order number, referencing number, vendor name and code, vouchered amount, and outstanding amount. The primary sort is by BFY/fund, organization, vendor name, transaction number.
 

ITA300 - Weekly Collections Report by Transaction. This report includes collections received for the week and shows transaction code and number, vendor, accounting strip and dollar amount. The primary sort is by transaction code, document and line number.
 

ITA301 - Monthly Collections Report by Transaction. This report shows the collections received for the month and shows transaction code and document number, vendor, accounting strip and dollar amount. The primary sort is by transaction code, document and line number.
 

ITA305 - Weekly Collections Report by Organization. This report shows the collections received for the week and shows organization, transaction code and document number, vendor, accounting strip and dollar amount. The primary sort is by organization, transaction code, document and line number.
 

ITA306 - Monthly Collections Report by Organization. This report shows the collections received for the month and shows organization, transaction code and document number, vendor, accounting strip and dollar amount. The primary sort is by organization, transaction code, document and line number.
 

ITA322 - Document Summary Report - Info Products. This report shows only transaction code MS, fund 19 obligations, accruals, expenditures, and unliquidated balances. The primary sort is by division, organization, BFY/fund, document number.
 

ITA323 - Document Summary Report - Trade Events. This report shows only transaction code MS, fund 20 obligations, accruals, expenditures, and unliquidated balances. The primary sort is by division, organization, BFY/fund, document number.
 

ITA421 - ITA Payroll Detail NFC Labor Costs by Organization. This report shows social security number, accounting structure, regular pay, OTP pay, award pay, O/T pay, benefits, and net pay. The primary sort is by pay period, organization, employee.
 

ITA422 - Summary NFC Labor Costs by Organization. This report is a summary showing organization, total hours, regular pay, other pay, awards O/T pay, benefits, and net pay. The primary sort is by pay period, division, organization.
 

ITA450 - Detailed Subsidiary for Capitalized Equipment. This report shows acquisition costs, accumulated depreciation and book value for equipment. The primary sort is by location, custodian.
 

ITA451 - Detailed Subsidiary for Leasehold Improvement. This report shows acquisition costs, accumulated depreciation and book value for leasehold improvements. The primary sort is by location, custodian.
 

ITA455 - Disposal of Equipment. This report shows acquisition costs, accumulated depreciation and loss on disposal for capitalized equipment that has been eliminated. The primary sort is by location, custodian.
 

ITA500 - Financial Summary Report. This report shows annual budget, current month activity, total YTD spending, balance remaining, and % of annual budget spent. This report is summarized at the cost category level determined by budget object code. The primary sort is by organization, BFY/fund, cost category.
 

ITA501 - Prior Years Financial Summary Report. This report shows financial activity for prior budget-fiscal-years including current month activity, total YTD spending, balance remaining, and % of annual budget spent. This report is summarized at the cost category level determined by budget object code. The primary sort is by organization, BFY/fund, cost category.
 

ITA502 - Prior Years Growth Report. This report shows financial activity for prior budget-fiscal-years including current month activity, total YTD spending. This report is summarized at the cost category level. The primary sort is by BFY, fund, organization.
 

ITA503 - No Year Financial Summary Report. This report shows financial activity for all years.  It shows the annual budget for the current year, prior activity for each fiscal year, total year to date spending, balance remaining, and percent of annual budget spent.  this report is summarized at teh cost category level determined by budget object code.  the primary sort is by organization, BFY/Fund, cost category.
 

ITA550 - Current Year Fiscal Plan. This report shows the annual budget for each organization by appropriation/fund.  Each report shows the project by budget object class quarterly.  this report is summariezed at the organization and budget subactivitiy levels.  The primary sort is by organization, BFY/Fund, budget activity.