Intra-governmental Transactions

Working Group (ITWG)

August 9, 2022
Page 2 L EAD ∙ T RANSFORM ∙ D ELIVER

Today’s Agenda

• Tentative ITWG Schedule

• Program Updates

• Release 4.6 Work Underway

• New IGT Scorecard Template

• ATB Summary Report

• Reporting Snapshot

• Post-Mandate Enhancement Timeline

• Mid-Year Powerful User Recertification

• Office Hours

• July Survey Results

• Reference Materials
Page 3 L EAD ∙ T RANSFORM ∙ D ELIVER

Tentative ITWG Schedule

 June 14 – Program Updates, Release 4.5, Release 4.6 Work Underway, 

RC Data to GTAS, Office Hours, Reference Materials

 July 12 – Program Updates, Release 4.6 Work Underway, New IGT 

Scorecard Template, New IPAC Sub-Category Data Element, User 

Recertification Placeholder, Office Hours, Survey Questions, Materials

 Aug 9 – Program Updates, Release 4.6 Work Underway, New IGT 

Scorecard Template, ATB Summary Report, Reporting Snapshot, PostMandate Enhancement Timeline, Mid-Year Powerful User Recert, Office 

Hours, July Survey Results, Reference Materials

Planned Dates: Sept 13, Oct 11, Nov 8

Future Topics:

• Post-mandate enhancements

2-3:30 pm ET
Page 4 L EAD ∙ T RANSFORM ∙ D ELIVER

Program Updates

• Q4 FY22 Implementation Plans are due to Treasury by Sept 30th

‒ These submissions will be reflected on your Q4 Scorecard

‒ Reminder: Please ensure that the correct Agency G-Invoicing POCs are 

captured on your quarterly Attachment A submissions

• G-Invoicing Program Guide

‒ Guide for Basic Accounting and Reporting

‒ Updates include revisions to the budgetary/proprietary accounting scenarios 

and the inclusion of business rules by Reciprocal Category

‒ Published on August 9, 2022

• https://www.fiscal.treasury.gov/ussgl/resources-g-invoicing-program-guide.html
Page 5 L EAD ∙ T RANSFORM ∙ D ELIVER

Program Updates Continued

• Trading Partner Directory and POC Listing on OMB Max updated to 

reflect Q3 FY22 submissions

‒ Q3 FY22 Implementation Plans and Attachments A/B are also on OMB Max

‒ ALCs formerly assigned to Trading Partner Queue will now reflect “Not 

Assigned” until they are migrated to the agency Production Account

‒ Agency updates since the previous TPD publication are captured in Red font

‒ https://community.max.gov/display/CrossAgencyExternal/Bureau+of+the+Fis

cal+Service+G-Invoicing

• Webpage Updates 

‒ Updated GINV-IPAC Settlement Data Element Mapping spreadsheet 

published on the G-Invoicing webpage and updated on the IPAC webpage

• https://www.fiscal.treasury.gov/g-invoice/resources.html#standards

• https://fiscal.treasury.gov/ipac/
Page 6 L EAD ∙ T RANSFORM ∙ D ELIVER

Release 4.6 Work Underway

• Upcoming Program Objectives (R4.6)

‒ Reciprocal Category Data for GTAS

• Will allow Fiscal Service to compare GTAS to G-Invoicing data for measuring/enforcing 

mandate compliance

‒ Adjusted Trial Balance (ATB) Summary Report by TAS

• Performance Calculation Breakdown by Order

‒ Agency Feature Flags to Support FT/QA Testing

• Feature Flags set by agencies to indicate their readiness to use new features

‒ Turned off in Production for R4.6

• New API for vendor to pull Feature Info and Agency Flags

‒ Business Application (BizApp) Phase II

• Pull GT&C Document Summary in JSON

• Create new JSON endpoint for Pull Single GT&C

‒ Order Summary List UI & Exports enhancements

‒ Allow only printable ASCII characters on GT&Cs

‒ R4.6 deployment planned for October
Page 7 L EAD ∙ T RANSFORM ∙ D ELIVER

Objective

• Validate submitted user input using server-side validation checks in all free-form fields

Process

• Apply input form validations (whitelist) on all GT&C free-form fields to include characters 

32-126

• Apply input form validations (whitelist) on all GT&C Agreement Information fields to 

include an exception for characters 10, 13, 149, 167, 182 in addition to characters 32-

126

• Non-Printable and Extended ASCII character data already in GINV must be scrubbed. 

Solution will mimic UI replacing diacritic and accent characters with character 

equivalents. Other invalid characters will be removed completely and replaced with “?” 

signifying that data has been removed.

• GT&Cs that have been cleansed will have an updated last modified date/time stamp and 

may be re-pulled through the external API

• We will execute two cleanses; one pre R4.6 and one post R4.6

• Communication will be sent to agencies in advance of pre-clean identifying GT&Cs 

modified by the data clean process. The communication will also include a before clean 

and after clean view of the data being cleaned

Whitelist Form-Field Validations 
Page 8 L EAD ∙ T RANSFORM ∙ D ELIVER

Whitelist (allowed / approved characters)

Note: characters 10, 13, 149, 167, and 182 (red arrows) 

are permitted in the GT&C Agreement Information fields 

only
Page 9 L EAD ∙ T RANSFORM ∙ D ELIVER

New IGT Scorecard Template

• Agencies can expect to see an updated IGT Scorecard template for Q2 

FY23

‒ New G-Invoicing compliant bullet point added to Summary Quadrant

‒ G-Invoicing Implementation Plan Status Update Quadrant renamed/updated to include 

compliance percentages

• Will include the agency’s Inter-departmental and Intra-departmental G-Invoicing compliance 

percentages that makes up the overall compliance percentage

• Green/Yellow/Red metric based on the established compliance thresholds
Page 10 L EAD ∙ T RANSFORM ∙ D ELIVER

ATB Summary Report

• New option under Reports menu

• Report shows a breakdown of ATB target amounts used in GTAS analytical edits

• New ‘TAS Reconciler’ role, limited by TAS Filters assigned to user’s group(s)

• Request report by Accounting Period (e.g., 02/2023 (Nov)) and Treasury Account 

Symbol (from ATB Failed Edits report in GTAS)
Page 11 L EAD ∙ T RANSFORM ∙ D ELIVER

ATB Summary Report Continued

• Performance transactions summed by Data Element, Sub Element, Trading Partner 

AID + MAIN, and Document Number

• Legend explains Sub Element breakdown, and presentation provides more details

• User may then copy Document Number to look up Order Schedule Balances in UI

Treasury CUI - Controlled Unclassified Information

ATB Summary Report

Report Date:Tue Jul 26 2022 14:52:10 CDT

UserId: GPOTT123

Parameters: Accounting Period: 12/2021 (Sep), TAS: --- 015 010 ---- ---- X 093 0003

Buy/Sell Ind. RC GTAS Statement Line Sub Element TP AID TP MAIN Amount Document Number Requesting Agency Requesting Group Name Servicing Agency Servicing Group Name

R 22 A/P, and Other Liabilities (Reclassified Balance Sheet Line 22.2) Unreceived 010 5114 3.33 O2107-017-015-021716 Agency ABC Group 8712 Agency ABC ABC top level group

R 22 A/P, and Other Liabilities (Reclassified Balance Sheet Line 22.2) Unreceived 010 0930 14.18 O2108-015-015-021892 Agency ABC ABC top level group Agency ABC ABC top level group

R 22 A/P, and Other Liabilities (Reclassified Balance Sheet Line 22.2) Unreceived 010 0930 -166.7 O2108-015-015-021896 Agency ABC ABC top level group Agency ABC ABC top level group

R 22 A/P, and Other Liabilities (Reclassified Balance Sheet Line 22.2) Unreceived 010 6999 2 O1908-011-011-005172 Department DEF Group LRA 431 Department DEF Group EML 129

R 22 A/P, and Other Liabilities (Reclassified Balance Sheet Line 22.2) Unreceived 010 6999 -10 O1908-011-011-005180 Department DEF Group LRA 431 Department DEF Group EML 129

R 22 A/P, and Other Liabilities (Reclassified Balance Sheet Line 22.2) Unreceived 010 6999 16 O1908-011-011-005208 Department DEF Group LRA 431 Department DEF Group EML 129

R 23 Advances to Others and Prepayments (Reclassified Balance Sheet Line 5) Performed 010 0930 2 O2003-020-020-007056 Bureau GHI Child group 20040001 Bureau GHI Group ASA 499

R 23 Advances to Others and Prepayments (Reclassified Balance Sheet Line 5) Performed 010 6999 4 O1908-011-011-005223 Department DEF Group LRA 431 Department DEF Group EML 129

R 23 Advances to Others and Prepayments (Reclassified Balance Sheet Line 5) Performed 010 0104 1 O2004-010-010-007350 Department DEF Group EML 129 Department DEF Group EML 129

R 23 Advances to Others and Prepayments (Reclassified Balance Sheet Line 5) Performed 010 0930 133.36 O1808-010-020-000159 Department DEF Group EML 129 Department DEF Group NIN 768

Legend

Accounting Period is synonymous with Fiscal Period

Reporting TAS represents the TAS submitted to GTAS in the ATB file

Buy/Sell Ind.: Provides the perspective of the TAS evaluation as Requesting TAS or Servicing TAS

RC: Reciprocal Category

GTAS Statement Line: Concatonation of the Statement Line number and name used for ATB reporting in GTAS

TP: Trading Partner involved in the other side of the transaction (e.g., the Servicing side Receivables when reporting the Requesting side Payables)

Sub Element - Deferred: Reported as a Deferred Payment (accrual) in the accounting period

Sub Element - Unreceived: Delivered/Performed but not Received/Accepted by the end of the accounting period

Sub Element - Unsettled: Delivered/Performed but not Transferred (aka, settled) by the end of the accounting period

Sub Element - Performed: Net Advanced less net Delivered/Performed reported before the closing of the accounting period

Sub Element - Delivered: Delivered/Performed reported before the closing of the accounting period

Sub Element - EZ Invoiced: Net EZ Invoices less Reversals and Rejections (within rejection window) by the end of the accounting period

AID: Agency Identifier

MAIN: Main Account

Document Number: Order number or EZ Invoice number involved in the transaction(s)
Page 12 L EAD ∙ T RANSFORM ∙ D ELIVER

Source: July 2022 Trading Partner Directory

Snapshot of What You Are Reporting

G-Invoicing Mandate Readiness Levels by ALC Percentage 

Target ALCs Establish in Production as of June 30th, 2022 94%

Agencies Planning to use G-Invoicing APIs 90%

Ready for GT&Cs Now 34%

Ready for GT&Cs by Oct 1st, 2022 94%

Ready for Orders Now 18%

Ready for Orders by Oct 1st, 2022 78%

Ready for Performance Now 16%

Ready for Performance by Oct 1st, 2022 79%
Page 13 L EAD ∙ T RANSFORM ∙ D ELIVER

• The following enhancements are high priority following the mandate 

based on Agency requests. These enhancements will also require 

further ERP integration changes:

Post-Mandate Enhancement Timeline

• Note: Specifications for each enhancement published Q2 FY2022. 

Fiscal Service will continue to collaborate with ERP Vendors on 

establishing timelines for ERP Development. 

Enhancement

G-Invoicing 

Development 

Completed

Available in 

Production

Agency 

Implementation 

Date, if Required

**7600-EZ (Low Dollar Purchases) *Q1 FY2023 Q2 FY2023 Q1 FY2024

**Constructive Order Acceptance (GSA Rent) *Q2 FY2023 Q3 FY2023 Q1 FY2025

**Enhanced Order Modification Functionality *Q1 FY2024 Q2 FY2024 N/A

In-Flight Order Upload Tool for the User Interface *Q1 FY2023 Q2 FY2023 N/A

*Targeted Dates for Development Completion. Deployment to Production is expected to occur the quarter following.

**Both Trading Partners must enable Feature Flags to use this Functionality.
Page 14 L EAD ∙ T RANSFORM ∙ D ELIVER

2022 Mid-Year Powerful User Recertification

• The Mid-Year Powerful User recertification will begin on July 19; this applies to 

all Treasury Applications including G-Invoicing.

• The G-Invoicing user’s “User Administrator” (also known as the Recertification 

Official) is required to recertify all user’s powerful access to G-Invoicing and 

verify their Role/Group assignments are appropriate in accordance with the 

principle of least privilege access.

• All G-Invoicing “User Administrators” will be notified to recertify all powerful users 

in their agency account. 

• ACTION: Review and confirm all user’s “User Administrator” is accurate and 

ACTIVE prior to the kick-off on July 19th. If the “User Administrator” is inactive, 

the user’s access will not be able to be recertified. 
Page 15 L EAD ∙ T RANSFORM ∙ D ELIVER

Office Hours

• G-Invoicing Program conducts virtual Office Hours sessions twice monthly where we host 

targeted discussions as well as “open-mic” styled discussions

• Future Topics Include:

‒ DLA Trading Partner Spotlight (August 2nd)

‒ Open Office Hours (August 9th) 

‒ Round Table Discussion: Brokering Orders in a Continuing Resolution or when Quarterly Funding is involved (Aug 16th)

‒ Open Office Hours (August 23rd) 

‒ Open Office Hours (August 30th)

‒ Trading Partner Spotlight: Providing Agencies a platform to discuss their G-Invoicing implementation approach with trading 

partners. 

Note: If Agencies would like to volunteer for a Trading Partner Spotlight session, please reach out to IGT@fiscal.treasury.gov

• Register for Office Hours here: https://fiscal.treasury.gov/training/g-invoicing-office-hours.html
Page 16 L EAD ∙ T RANSFORM ∙ D ELIVER

July Survey Results

1. Does your agency envision needing to use the Bulk File for Buy/Sell 

activity after October 2023? If yes, explain why?

‒ Majority of responders indicated No as their response

‒ Those of you who responded Yes and provided an explanation, we 

appreciate your feedback and will take that under consideration

2. Are you having trouble connecting with a certain trading partner? If so, 

who?

‒ Majority of responders indicated No as their response

‒ Those of you who responded Yes and provided a list of agencies who have 

been unresponsive, we appreciate your feedback and will see what we can 

do to help reach out to those trading partners on your behalf.

• We may be reaching out to identify which person(s) you’ve been trying to 

contact
Page 17 L EAD ∙ T RANSFORM ∙ D ELIVER

July Survey Results Continued

3. Is there a trading partner that you’d like to see present in an upcoming 

Office Hours?

‒ Agencies mentioned include: GSA (already presented), Dept. of 

Commerce, OPM, Dept. of State, Dept. of Transportation, DoD (Army), 

Dept. of Justice, USDA, Treasury and the Intelligence Community

‒ Thanks for your feedback! We’ll see what we can do to have some of 

these agencies present at an upcoming Office Hours.

4. Are there any topics you’d like to see covered in an upcoming ITWG?

‒ Performance process (including Adjustments) in G-Invoicing

‒ Workflow setup in G-Invoicing

‒ Status of G-Invoicing interfaces with ERP solutions

‒ Use of AAC codes in G-Invoicing

‒ In-Flight Order logistics - how to process existing GT&Cs that span 

multiple years

‒ Trading Partner Communication (if OMB Max isn’t sufficient)
Page 18 L EAD ∙ T RANSFORM ∙ D ELIVER

Reference Materials

The Mandate

• Mandated that all Federal Program Agencies (FPAs) who process IGT Buy/Sell 

transactions must implement G-Invoicing 

https://tfm.fiscal.treasury.gov/v1/p2/c470.html

• TFM Bulletin 2022-03 (Published December 14, 2021) – Defined the 

Monitoring and Enforcement metrics for G-Invoicing Mandate Compliance 

https://tfm.fiscal.treasury.gov/content/tfm/v1/bull/22-03.html

Program Guide

• Provides guidance regarding proper accounting treatment for IGT Buy/Sell 

transactions processed through G-Invoicing 

https://www.fiscal.treasury.gov/ussgl/resources-g-invoicing-program-guide.html

System Integration Guide

• Details how FPAs may utilize automated data exchanges to communicate IGT 

Buy/Sell activities to/from G-Invoicing 

https://fiscal.treasury.gov/files/g-invoice/g-invoicing-system-integration-guidev1.1.pdf

Rules of Engagement

• Outlines protocol for Trading Partner interaction in support of transitioning IGT 

Buy/Sell business processes to G-Invoicing

https://www.fiscal.treasury.gov/files/g-invoice/g-invoicing-rules-of-engagement.pdf

OMB Max

• Access to the Trading Partner Directory and Agency Implementation Plans

https://community.max.gov/display/CrossAgencyExternal/Bureau+of+the+Fiscal+Service+GInvoicing

Federal Intragovernmental Data Standards (FIDS)

• Defines the data attributes and the system mapping & validation rules for the 

new IGT Buy/Sell data standard which is implemented through G-Invoicing.

https://fiscal.treasury.gov/g-invoice/resources.html#standards

Policy: 

TFM Chapter 4700 – Appendix 8

Published:

June 2021 (Updated Annually)

Guidance: 

G-Invoicing Program Guide for 

Basic Accounting and Reporting

Published:

February 2019

G-Invoicing System Integration 

Guide

Revised:

March 2021

G-Invoicing Rules of Engagement

Revised:

January 2022
Page 19 L EAD ∙ T RANSFORM ∙ D ELIVER

Appendix

• Where Should We Be Now? (Slide 20)

• New IPAC Sub-Category Data Element (Slide 21)

• Timeline and Next Steps (Slide 22)

• Thresholds for Compliance (Slide 23)

• Resource, Knowledge, and Training Offerings (Slides 24-26)

• G-Invoicing Program Contacts (Slide 27)
Page 20 L EAD ∙ T RANSFORM ∙ D ELIVER

Pilot in QA-C

Establish 

Production 

Account

Define 

Organizational 

Hierarchy

Add/Train 

Users

Work with 

Trading 

Partners to 

Broker GT&Cs

Process 

Transactions

Sprinting Towards the October 1st, 2022 G-Invoicing Mandate

Where Should We Be Now?

• Agency focus should be on completing Organizational model, and train agency 

trainers in preparation for brokering GT&Cs. 

• G-Invoicing Trading Partner Directory contains latest readiness dates

• GT&C focus should initially be on internal agency Buy/Sell

transactions, and the shift focus to external 

Trading Partners. 

*187 PROD 

Agency Accounts 

as of 06.01.22
Page 21 L EAD ∙ T RANSFORM ∙ D ELIVER

New IPAC Sub-Category Data Element

• Required data element in IPAC User Interface (UI) beginning 

on October 1, 2022

• Refer to TFM Chapter 4700 for more information on each of the 

sub-categories ‒ https://tfm.fiscal.treasury.gov/content/tfm/v1/p2/c470.html

• New IPAC Sub-Category Data Elements:

1. Buy/Sell Transfer - Appendix 8

2. Non-Exchange Expenditure Transfer - Appendix 9

3. Benefits Transfer - Appendix 7

4. Capital Transfer - Appendix 7

5. Non-Exchange Custodial Transfer - Appendix 10

6. Exchange Custodial Transfer - Appendix 10

7. Investments - Appendix 6

8. Borrowings - Appendix 6

9. Other - Used for activity that doesn’t fall under one of the other seven subcategories 
Page 22 L EAD ∙ T RANSFORM ∙ D ELIVER

Timeline and Next Steps

December 2021

• New data element 

available as optional 

in IPAC.

• Captures the type of 

IGT initiated.

• Optional for use 

through the Bulk File 

and User Interface.

October 2022

• New data element 

required in the User 

Interface.

• Remains as an optional 

field when submitting 

transactions through 

the Bulk File to 

accommodate 

Enterprise Resource 

Planning (ERP) vendor 

development and 

agency custom system 

development.

October 2023

• New data field 

required in Bulk File & 

removes Buy/Sell as 

an option for the Bulk 

File.

• Begins requiring 

agencies to populate 

the new data field in 

IPAC when transacting 

through both the User 

Interface and Bulk File.

• Inability to categorize a 

transaction as Buy/Sell 

through IPAC Bulk File 

but remains available in 

the User Interface.

October 2024

• Removal of Buy/Sell 

option for the User 

Interface.

• Full removal of the 

Buy/Sell category 

within the IPAC 

application is complete 

for the User Interface 

and the Bulk File.
Page 23 L EAD ∙ T RANSFORM ∙ D ELIVER

TFM Bulletin 2022-03 (Published December 14, 2021)

• Defined the Monitoring and Enforcement metrics for G-Invoicing Mandate Compliance.

https://tfm.fiscal.treasury.gov/content/tfm/v1/bull/22-03.html

• Ranges are based on the dollar amount of Buy/Sell activity in G-Invoicing as compared to 

the FR Entities’ GTAS data and will increase each fiscal year.

Thresholds for Compliance
Page 24 L EAD ∙ T RANSFORM ∙ D ELIVER

Connecting With Your Trading Partners

• Staying up to date on your Partners’ progress is key to your own success in 

transitioning your IGT Buy/Sell activity to G-Invoicing

• Fiscal Service provides several utilities to facilitate effective communication with your 

Partners to gain an understanding of their implementation approach and timeline 

• G-Invoicing’s OMB Max page contains data 

related to each Agency’s Implementation 

Status including the following:

‒ Implementation Plans for Significant 

Reporting Entities who receive IGT 

Scorecards 

‒ Trading Partner Directory which displays 

enrollment status and transaction 

processing readiness by Implementation 

Entity

‒ Visit our OMB Max site to access these 

resources: 

https://community.max.gov/x/szd0ZQ
Page 25 L EAD ∙ T RANSFORM ∙ D ELIVER

Knowledge and Training Offerings

G-Invoicing Learning Opportunities

• Our Agency Implementation Team hosts a variety of training options.

• Independent Training Resources including pre-recorded G-Invoicing training 

videos are available through the G-Invoicing website: 

https://www.fiscal.treasury.gov/g-invoice/training.html

• Register for Webinar-based Training and access to On-Demand Financial 

Management Training Videos here: https://www.fiscal.treasury.gov/training/
Page 26 L EAD ∙ T RANSFORM ∙ D ELIVER

You’re Not Alone – We’re Here To Help

Agency Implementation Team (AIT)

• Education

‒ Business Process Walkthroughs

‒ Application Demos

‒ User Training

• Account Establishment

• Enrollment Assistance

• Production Support

• Assistance with Agency-Led Implementation Team

Engagement | Outreach | Support
Page 27 L EAD ∙ T RANSFORM ∙ D ELIVER

G-Invoicing Program Contacts

For IGT Program Management and Agency Outreach Support

Andy Morris

Manager, Intragovernmental Transaction & Reconciliation Branch (ITRB)

Bureau of the Fiscal Service – Fiscal Accounting

andrew.r.morris@fiscal.treasury.gov

Jeff Board

G-Invoicing Product Owner, ITRB

Bureau of the Fiscal Service – Fiscal Accounting

jeffrey.board@fiscal.treasury.gov

Keith Jarboe

IGT Agency Outreach, Engagement & Onboarding

Bureau of the Fiscal Service – Fiscal Accounting

keith.jarboe@fiscal.treasury.gov

For Intragovernmental Transactions Working Group Information

IGT@fiscal.treasury.gov

https://www.fiscal.treasury.gov/g-invoice/

For G-Invoicing Application Support

STLS.G-Inv.CBAF@stls.frb.org