Intragovernmental Transactions

Working Group (ITWG)

July 9, 2019
Page 2 L EAD ∙ T RANSFORM ∙ D ELIVER

Today’s Agenda

• Tentative ITWG Schedule

• Updates:

• Implementation Plans

• OMB

• Accruals

• Vendors

• Survey Results

• Finalized Settlement Data and Rules

• Settlement Extract

• Survey Questions

• Q&A
Page 3 L EAD ∙ T RANSFORM ∙ D ELIVER

Tentative ITWG Schedule

 April 9 – More on Administrative Changes and Settlement

 May 14 – Mapping FIDS to IPAC, Settlement Rules

 July 9 – Program Updates, Settlement, Remittance Files

FMSC conference is Aug 12-14 (no August ITWG meeting)

Planned Dates: Sept 10, Nov 12 (no October meeting)

Future Topics:

• Loading Active Documents

• Reporting Requirements (cont.)

• Authoritative Source

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

Agency Implementation Plans – Update

• Implementation Plans and Attachment A’s were due to 

Fiscal Service by June 28, 2019

- Currently we have received 68% of plans

• Fiscal Service is currently reviewing and analyzing the 

Plans and Attachment A’s

• Fiscal Service will be creating resources and tools to share 

information with agencies

- Visibility between Trading Partners

- Publishing August 2019
Page 5 L EAD ∙ T RANSFORM ∙ D ELIVER

Office of Management & Budget – Update

• Working group meeting hosted by OMB to review FIDS and 

OMB procurement guidance (FAR, OMB 2008 Memo, etc.) 

as it relates to interagency agreements ONLY (specifically 

focused on assisted acquisitions)

• Completed 5 working sessions, and the working group is 

identifying potential problem areas and solutions

• The working group is looking at potential modifications to 

both OMB and Treasury guidance

• Goal is to align Treasury and OMB guidance
Page 6 L EAD ∙ T RANSFORM ∙ D ELIVER

Agency Questions regarding Accruals

• G-Invoicing Program Guide established the performance 

date as the driver for agencies recording accruals

• Agencies have expressed a need for a cut-off date to 

record accruals (such as no more after the 8th business 

day)

• Fiscal Service is exploring this functionality and looking to 

see if accounting period could be used instead of 

performance date and what kind of controls G-Invoicing 

could put in place to enforce timely accruals
Page 7 L EAD ∙ T RANSFORM ∙ D ELIVER

ERP and Software Provider Engagement

Leveraging the Financial Management Standards Committee (FMSC), the G-Invoicing Program has been 

working with the Federal Enterprise Resource Planning and Software providers listed below to integrate GInvoicing functionality within their offerings. Details regarding these efforts are noted below with points of 

contact for further information.

• CGI Momentum: For information on Momentum’s G-Invoicing product direction, please join monthly 

calls hosted by Mr. Reed Waller with the Momentum Working Group and Momentum User Group 

(MUG). To join the Momentum Working Group calls, contact Reed.V.Waller@usdoj.gov. For additional 

information please contact Kerry Canfield at Kerry.Canfield@cgifederal.com.

• ORACLE: For information on Oracle's G-Invoicing product direction, please join monthly calls hosted 

by Ms. Lana Null with the Oracle Working Group and Oracle Development. To join the Oracle Working 

Group calls, contact Lana.Null@faa.gov. For additional information please contact Mike Barker at 

Michael.Barker@Oracle.com.

• SAP: For information on SAP's G-Invoicing product direction, please join monthly calls hosted by Mr. 

Martin Quinlan with the SAP Working Group and SAP Development. To join the SAP Working Group 

calls, contact Peter_Gabel@ios.doi.gov. To access specific information relating to SAP’s support for 

your Agency please send a request to SAP_G-Invoicing_Support@sap.com . Once received, SAP will 

contact you directly to grant you access to a repository of this information. For any additional 

information please contact John Purcell john.purcell@sap.com and Yves Archambault 

yves.archambault@sap.com.

• Unison (Formerly Compusearch): For information on Unison’s G-Invoicing product direction, please 

reference their G-Invoicing solution website.
Page 8 L EAD ∙ T RANSFORM ∙ D ELIVER

Survey Results

• Vast majority of respondents are in favor of mapping Performance 

Comments in G-Invoicing to Description in IPAC

- Comments will be truncated at 320 characters

- The full 1000 characters are available in G-Invoicing

• Vast majority of respondents are in favor of mapping Additional 

Accounting Classification in G-Invoicing to Miscellaneous Transaction 

Information in IPAC? 

- G-Invoicing will use Additional Accounting Classification from agency that 

submitted the Performance which triggered settlement

• As it was in 2018, agencies are split on Unit of Measurement standard

- Vendors support American (ANSI) and International (ISO) standards

- Policies on Federal standards inconclusive

- Slight edge towards ANSI X-12, for example:

o DO = Dollars

o EA = Each

o HR = Hours 
Page 9 L EAD ∙ T RANSFORM ∙ D ELIVER

Settlement Features Coming in 2019

• Settlement requests from G-Invoicing to IPAC

– Only some Performance Types trigger settlement

• Advances always trigger collections

• Delivered/Performed when FOB Source

• Received/Accepted when FOB Destination

– Transactions should settle in minutes; CARS the next day

• Performance FIDS includes settlement confirmation

– Settlement Status (see next slide)

– Traceability from G-Invoicing to IPAC to CARS

• ALC, DO Symbol and Document Reference Number

• Settlement related enhancements

– Delete future Performance

– Performance reporting will include Settlement data
Page 10 L EAD ∙ T RANSFORM ∙ D ELIVER

Determining Settlement Status

• Performance which does not trigger settlement will be set to 

‘INF’ (informational only) status

• Performance which will trigger settlement will be set to 

‘PND’ (pending) status

- Settlement will be delayed if Performance Date is in the future

• Performance for which settlement has occurred will be set 

to ‘STL’ (settled) status

• Performance for which settlement has failed will be set to 

‘ERR’ (error) status

• Future dated Performance transactions that have been 

logically deleted will be set to ‘XXX’ (deleted) status

- Deleted Performance can be viewed or pulled through API

- Notification will be sent to subscribers
Page 11 L EAD ∙ T RANSFORM ∙ D ELIVER

Performance FIDS for Settlement

Name Description Level Validation Rules

Status 

Code

The current status of the requested 

document.

Header N/A for input by agencies. Status assigned by the System:

PRE for performance reported in Rel 2.3, prior to settlement.

INF(ormational) if Performance does not trigger settlement. 

See settlement rules in Push spec.

PND if settlement is currently pending. 

STL if settlement has occurred.

XXX if (future) performance transaction was deleted.

ERR if settlement failed. Actionable only by G-Invoicing Prod 

Support.

Disbursing 

Office 

Symbol

An identifier assigned to the agency 

which is disbursing funds from the 

Treasury General Account (TGA).

Header Managed by IPAC. Not allowed for input by agencies.

Only applicable if Status is STL. 

Each ALC is assigned one DO Symbol to be used for IPAC.

Document 

Reference 

Number

Details a unique identifying number 

created by a system for a document, 

e.g. payment or collection document.

Header Generated by IPAC. Not allowed for input by agencies.

Only applicable if Status is STL. 

Transfer 

Date

The date that funds are transferred 

into or out of the TGA. (Equivalent to 

IPAC's Accomplished Date)

Header Generated by IPAC. Not allowed for input by agencies.

Only applicable if Status is STL. 
Page 12 L EAD ∙ T RANSFORM ∙ D ELIVER

G-Invoicing/IPAC Data Mapping

• G-Invoicing to IPAC

- Data elements that can be transferred from G-Invoicing to IPAC

- Will be included in Transaction Download report, albeit some 

transformed 

• Not exchanged

- No logical place in IPAC for G-Invoicing data

- No use in G-Invoicing for IPAC data

• IPAC to G-Invoicing

- Data sent back to G-Invoicing to designate settled status and 

provide traceability
Page 13 L EAD ∙ T RANSFORM ∙ D ELIVER

G-Invoicing to IPAC Data Mapping

Name Description Data Source/Rules

Originating ALC The ALC sending the Payment 

or Collection transaction

Requesting ALC on Order for Performance Type '050' (Received/Accepted), otherwise 

the Servicing ALC.

Customer ALC ALC receiving the Payment or 

Collection transaction

Servicing ALC on Order for Performance Type '050' (Received/Accepted), otherwise 

the Requesting ALC.

Contact Name Name of user responsible for 

transaction

If Perf Type = 050 (Received/Accepted) use Requesting Agency POC Name from Order, 

otherwise use Servicing Agency POC Name.

Contact Email 

Address

Email of user responsible for 

transaction

If Perf Type = 050 (Received/Accepted) use Requesting Agency POC Email Address 

from Order, otherwise use Servicing Agency POC Email Address.

Contact Phone 

Number

Phone of user responsible for 

transaction

If Perf Type = 050 (Received/Accepted) use Requesting Agency POC Telephone 

Number from Order, otherwise use Servicing Agency POC Telephone Number.

Contract Number Unique number used to identify

a contract between two partners

Strip three dashes (-) from GTC Number ... 

e.g., A1903-123-234-000345 becomes A1903123234000345

Purchase Order 

Number

Number of the document from

the receiving agency requesting 

goods or services

Strip three dashes (-) from Order Number ... 

e.g., O1903-123-234-000345 becomes O1903123234000345

There is room for full Order # but we seek consistency. 

CLIN Contract Line Item Number Performance Detail Number ... left justify

Invoice Number ID of the invoice sent by the biller 

listing the services rendered

Strip three dashes (-) from Performance Number ... 

e.g., P1903-123-234-000345 becomes P1903123234000345

Quantity Number of units Quantity in Performance Detail. Must be positive.

Unit Price Cost per unit Order Schedule Unit Price, rounded to 2 decimals ... e.g., 32.3468 becomes 32.35

Detail Amount Quantity x Unit Price Calculated by GINV and rounded: Performance Quantity x Order Schedule Unit Price

IPAC should not validate to prevent rounding errors.
Page 14 L EAD ∙ T RANSFORM ∙ D ELIVER

G-Invoicing to IPAC Data Mapping (cont.)

Name Description Data Source/Rules

Pay Flag “F” – Final payment or 

“P” – Partial payment

Final Performance Indicator on Performance Detail. 

If not 'F' then use 'P'.

Receiver Treasury 

Account Symbol

Also known as an appropriation or fund 

symbol. Account number assigned by 

Treasury to classify Agency transactions

8 TAS components on Order/Line/Schedule. Use requesting agency's TAS if 

Performance Type is '050' (Received/Accepted), otherwise servicing agency's 

TAS.

Receiver Business 

Event Type Code

Identifies the type of event that is recorded 

against a TAS

Value is opposite of Sender BETC:

If 'DISB' then 'COLL'.

If 'DISBAJ' then 'COLLAJ'.

If 'COLL' then 'DISB'.

If 'COLLAJ' then 'DISBAJ'.

Receiver DUNS Unique identifier for individual

business locations for federal vendors 

and federal customers

BPN in Order Header. 

Receiver DUNS+ 4 BPN+4 in Order Schedule.

Sender Treasury 

Account Symbol

Also known as an appropriation or fund 

symbol. Account number assigned by 

Treasury to classify Agency transactions

8 TAS components on Order/Line/Schedule. Use servicing agency's TAS if 

Performance Type is '050' (Received/Accepted), otherwise requesting 

agency's TAS.

Sender Business 

Event Type Code

Identifies the type of event that is recorded 

against a TAS

If Performance Type = '050' (Received/Accepted):

If Performance Quantity > 0 then BETC = 'DISB'.

If Performance Quantity < 0 then BETC = 'DISBAJ'.

If Performance Type <> '050' (Received/Accepted):

If Performance Quantity > 0 then BETC = 'COLL'.

If Performance Quantity < 0 then BETC = 'COLLAJ'.

Sender DUNS Unique identifier for individual 

business locations for federal vendors 

and federal customers

BPN in Order Header. 

Sender DUNS+4 BPN+4 in Order Schedule.

Looking at SAMMI replacement

Looking at SAMMI replacement
Page 15 L EAD ∙ T RANSFORM ∙ D ELIVER

G-Invoicing to IPAC Data Mapping (cont.)

Name Description Data Source/Rules

Receiver Treasury 

Account Symbol

Also known as an appropriation or fund symbol. 

Account number assigned by Treasury to classify 

Agency transactions. 

8 TAS components on Order/Line/Schedule. Use requesting 

agency's TAS if Performance Type is '050' 

(Received/Accepted), otherwise servicing agency's TAS.

Accounting 

Classification Code

Code/number which identifies a project or mission 

and is supplied to the biller by the customer on the 

original request for goods/services

First 16 characters of Requesting Agency Project ID

Accounting Classification Reference Number ACRN identifies a line of accounting on a contract Accounting Classification Reference Identifier on Schedule

Job Number Job (Project) Number First 20 characters of Servicing Agency Project ID

Obligating Document 

Number

Billing agency’s internal accounting document 

associated with a specific bill or disbursement

Strip three dashes (-) from Order Number ... 

e.g., O1903-123-234-000345 becomes O1903123234000345

Description Sufficient information to describe and support the 

adjustment transaction First 320 chars of Comments in Performance Header

Miscellaneous 

Transaction Information Additional miscellaneous transaction information

If Performance Type = 050 (Received/Accepted) use 

Requesting Agency Additional Accounting Classification from 

Order, otherwise use Servicing Agency’s.

DOD Activity Address 

Code Identifies a Department of Defense activity location Use AAC on Order/Line/Schedule

Transaction Contact Transaction level Contact Name. Prepared By Name on Performance 

Transaction Contact 

Phone Transaction level Contact Phone Number. Prepared By Phone on Performance 

Transaction

Set ID “820” – Payment or “810” – Collection. 

If Performance Quantity > 0

If Performance Type = 050 then 820, otherwise 810.

If Performance Quantity < 0

If Performance Type = 050 then 810, otherwise 820.
Page 16 L EAD ∙ T RANSFORM ∙ D ELIVER

Data Not Exchanged

Name Description Data Source/Rules

Transaction ID A unique identifier used to identify a specific 

transaction submission

Generated by IPAC and sent to CARS

Not shared with G-Invoicing

Submitter ALC The ALC sending the Payment or Collection 

transaction.

IPAC to set to zero, indicating the transaction did not 

originate from a bulk file

Summary Amount Total amount of the Transaction Generated by IPAC. Not shared with G-Invoicing

Detail Line Number Identifies the specific detail line number for an IGT Generated by IPAC. Not shared with G-Invoicing

Accounting Date Posting period Assigned by IPAC based on Accomplished Date

Requisition Number Identifies a requisition between trading partners Literal assigned by IPAC to identify G-Invoicing as source

Unit of Issue Units by which goods and services are measured N/A ... no attempt to map ANSI/ISO standards to UOI in IPAC

FY Obligation ID “C” – Current fiscal year obligation or “P” – Prior 

fiscal year obligation or “ ” – Not applicable N/A ... nothing like it in G-Invoicing or in FIDS

Receiver Dept Code 2-char code replaced recently by 3-digit AID N/A ... nothing like it in G-Invoicing or in FIDS

JAS Number Combination of Job Order Number, Accounting 

Classification Record Number and Site-ID N/A ... nothing like it in G-Invoicing or in FIDS

FSN AAA ADSN FSN/AAA/ADSN – subdivision of ALC, an 

accounting station N/A ... nothing like it in G-Invoicing or in FIDS

ACT Trace Number Accounting Trace Number – user assigned ID to 

enable back end systems to match up transactions. N/A ... nothing like it in G-Invoicing or in FIDS
Page 17 L EAD ∙ T RANSFORM ∙ D ELIVER

IPAC to G-Invoicing Data Mapping

Name Description Data Source/Rules

Accomplished 

Date Date on which IPAC was processed Generated by IPAC and returned in response. Stored in G-Invoicing as Performance Transfer Date.

Document 

Reference 

Number

A unique reference number used to 

identify a specific IGT

IPAC to generate unique DRN within ALC/DO Symbol, used to 

trace between GINV/IPAC/CARS

Sender DO 

Symbol

Organizational ID (below ALC) used 

by IPAC so ALC/DO/DRN is unique Managed by IPAC and used to trace between GINV/IPAC/CARS

• Document Reference Number (DRN) is no longer controlled by the agencies

- Agency Transaction Identifier can be used to link a key identifier in an agency’s 

system (e.g., invoice number) to the Performance record in G-Invoicing

- DRN is passed from IPAC back to G-Invoicing for traceability

- DRN will continue to be passed from IPAC to CARS for traceability
Page 18 L EAD ∙ T RANSFORM ∙ D ELIVER

April Survey Results – Remittance Report

• We asked: How will your agency consume Remittance data 

from G-Invoicing ... and how will you want that data filtered?

1. Many agencies (and vendors) want to continue pulling Transaction 

Download report from IPAC

2. Many agencies (and at least one vendor) plan to pull Performance 

and Orders though APIs then report Remittance on their own

3. Many agencies want to report Remittance from G-Invoicing

o CSV and Excel are common formats

o Some want to report daily and others less frequently

o Reporting by accomplished/settlement date is most popular

o Reporting by Organization is common (i.e., partner, ALC, department, 

business unit, cost center) 

o Reporting by document is common (e.g., “Invoice”, Order, GT&C, 

Document Reference Number)

o Reporting by TAS is common
Page 19 L EAD ∙ T RANSFORM ∙ D ELIVER

G-Invoicing

Performance 

Detail

Performance

Header

Extracting Remittance Data

Order

Header

Order Line

Order 

Schedule

Pending

Settled

Push Performance

Pull Remittance File

Pull Performance

(with settlement)

IPAC

Bulk File (or UI entry)

Transaction Download Report

New Interface

Existing Interface

Key

4

2

1

Application Program Interfaces

Remittance Download

3
Page 20 L EAD ∙ T RANSFORM ∙ D ELIVER

Remittance Reporting Requirements

• Format

– Agencies have asked for CSV, Excel and XML

• Agencies can upload CSV into MS-Excel

– XML is Treasury’s standard, and suitable for data of this depth

 GT&C

 Order Header

 Order Line

 Order Schedule

 Performance Header

 Performance Detail

– New CSV export to include full Remittance data set

• CSV file can employ multiple record types or contain repeated data

• Estimated 100 data elements occupying 4000 characters per settlement record

– There will be a limit to the size of the Remittance file

• Compression could reduce file size by 50x
Page 21 L EAD ∙ T RANSFORM ∙ D ELIVER

Remittance Reporting Requirements (cont.)

• Frequency

– Some agencies want to report daily and others less frequently

• Filtering by Performance Date range supports any frequency 

• G-Invoicing will typically settle with IPAC within 15 minutes

• Filters

– Performance filters for user interface (in Release 2.3) include: 

• Order Number, Performance Number or Agency Transaction ID

• Performance Date (range)

– Additional filters could be added if needed, for example:

• Status (e.g., STL = settled)

• Transfer Date (aka, Accomplished Date) range

• Partner ALC

• Treasury Account Symbol

– Similar filters will be available for the Pull Remittance API
Page 22 L EAD ∙ T RANSFORM ∙ D ELIVER

Survey Questions for Today

1. Please provide your agency name and (ideally) your contact info so we can address 

your concerns.

2. Do you see anything in the plans for G-Invoicing to settle with IPAC that is a cause of 

concern for your agency?

3. How many business days should agencies have at month end to communicate 

accruals?

4. Do you think performance date or accounting period should be used to communicate 

the accrual information?

5. Does the change to how Document Reference Number will be generated (on slide 

17) present an insurmountable challenge for your agency? (Please explain).

Describe how your agency will extract remittance data from G-Invoicing? Specifically:

6. Will you export CSV via user interface, pull XML from API or both?

7. Do you need to get remittance data into an MS-Excel format?

8. Would you have issues decompressing a Zipped file?

9. Do you need to extract more than a month of data at a time?

10. What filters does your agency want to use?