TREASURY UNCLASSIFIED // EXTERNAL

L EAD ∙ T RANSFORM ∙ D ELIVER

Using G-Invoicing 

Transactional Data 

in GTAS Edit Rules 

(Planned Future Enhancements)

Version 1.0 – July 2022
TREASURY UNCLASSIFIED // EXTERNAL

Page 2 L EAD ∙ T RANSFORM ∙ D ELIVER

Business Overview

• As outlined in the TFM Appendix 8, the G-Invoicing mandate is a phased 

approach that requires new Buy/Sell activity to be implemented by October 

2022 and in-flight activity to be converted by October 2023 

• Fiscal Service will measure an Entity’s compliance by comparing data that 

an Entity reports in the Government-wide Treasury Account Symbol 

Adjusted Trial Balance System (GTAS) and the Performance Transactions 

created in G-Invoicing 

• G-Invoicing has established business rules that will calculate dollar 

amounts per TAS (submitted on the G-Invoicing Performance transactions) 

that affect financial statement lines and reciprocal categories (RCs), 

specifically RC22 Accounts Receivable/Payable, RC23 Advances and 

Prepayments to/from Others, and RC24 Buy/Sell Revenue/Costs 

• The dollar amounts derived from these rules will be used as the basis for 

comparison with the ATB data within GTAS 
TREASURY UNCLASSIFIED // EXTERNAL

Page 3 L EAD ∙ T RANSFORM ∙ D ELIVER

GTAS / G-Invoicing Interaction
TREASURY UNCLASSIFIED // EXTERNAL

Page 4 L EAD ∙ T RANSFORM ∙ D ELIVER

Reciprocal Category Data 

• Monthly TAS amounts will be made available to GTAS for the following data 

elements:

1. Buyer: RC 22 - A/P, and Other Liabilities (Reclassified Balance Sheet Line 22.2)

2. Buyer: RC 23 - Advances to Others and Prepayments (Reclassified Balance Sheet Line 5)

3. Buyer: RC 24 - Buy/Sell Costs (Reclassified Statement of Net Cost Line 7.3 

4. Buyer: RC 24 - Purchase of Assets (Reclassified Statement of Net Cost Line 7.4)

5. Buyer: RC 24 - Purchase of Assets Offset (Reclassified Statement of Net Cost Line 12.3)

6. Seller: RC 22 - Accounts Receivable (Reclassified Balance Sheet Line 3.4)

7. Seller: RC 23 - Advances from Others and Deferred Credits (Reclassified Bal. Sheet Line 25)

8. Seller: RC 24 - Buy/Sell Revenue (Reclassified Statement of Net Cost Line 12.2) 

9. Seller: RC 24 - Buy/Sell Costs (Reclassified Statement of Net Cost Line 7.3)

• RC 24 data is for the target period only, thus are combined with prior (FYTD) 

periods

• RC 22 and 23 data represent FYTD balances, thus are not combined with prior 

periods
TREASURY UNCLASSIFIED // EXTERNAL

Page 5 L EAD ∙ T RANSFORM ∙ D ELIVER

RC Data Elements 1-2

1. Buyer: RC 22 - A/P, and Other Liabilities (Reclassified Balance Sheet Line 22.2)

- Applies only to non-advanced Schedules

- Total up three sub elements

a. Unsettled: Sum of Delivered/Performed transactions against FOB Point ‘Source’ Orders that have not 

settled by the last calendar day of the target reporting period

b. Unreceived: Sum of Delivered/Performed transactions against FOB Point ‘Destination’ Orders that do 

not have corresponding Received/Accepted transactions which have settled by the last calendar day of 

the target reporting period

c. Deferred: Sum of Deferred Payment transactions which are active for the target reporting period

2. Buyer: RC 23 - Advances to Others and Prepayments (Reclassified Balance Sheet Line 5)

- Applies to advanced Schedules only

- Only one sub element

a. Performed: Sum of settled Advance transactions minus sum of Delivered/Performed transactions 

performed against the reporting period or any prior period
TREASURY UNCLASSIFIED // EXTERNAL

Page 6 L EAD ∙ T RANSFORM ∙ D ELIVER

RC Data Elements 3-5

3. Buyer: RC 24 - Buy/Sell Costs (Reclassified Statement of Net Cost Line 7.3

- Capitalized Asset Indicator on the Order Line must be False

- Total up three sub elements

a) Delivered: Sum of Delivered/Performed transactions reported against accounting periods from the 

beginning of the fiscal year through the target reporting period

b) Deferred: Sum of Deferred Payment transactions which are active for the target reporting period

c) EZ Invoiced: Net EZ Invoice transactions reported against accounting periods from the beginning of the 

fiscal year through the target reporting period 

o Invoices minus Reversals minus settled Rejections

4. Buyer: RC 24 - Purchase of Assets (Reclassified Statement of Net Cost Line 7.4)

- Capitalized Asset Indicator on the Order Line must be True

- Total up three sub elements

a) Delivered: Same calculations as 3a above

b) Deferred: Same calculations as 3b above

c) EZ Invoiced: Same calculations as 3c above

5. Buyer: RC 24 - Purchase of Assets Offset (Reclassified Statement of Net Cost Line 12.3)

- Total up three sub elements

a) Delivered: Same amounts as 4a above

b) Deferred: Same amounts as 4b above

c) EZ Invoiced: Same amounts as 4c above
TREASURY UNCLASSIFIED // EXTERNAL

Page 7 L EAD ∙ T RANSFORM ∙ D ELIVER

RC Data Elements 6-9

For data elements 6-9, “My TAS” is the Servicing Agency’s and the Trading Partner AID and 

MAIN are from the Requesting side

6. Seller Receivables: RC 22 - Accounts Receivable (Reclassified Balance Sheet Line 3.4)

- Same as (1) Buyer Liabilities , but from the Seller’s perspective

7. Seller Advances: RC 23 - Advances from Others and Deferred Credits (Reclassified 

Balance Sheet Line 25)

- Same as (2) Buyer Prepayments , but from the Seller’s perspective

8. Seller Revenue: RC 24 - Buy/Sell Revenue (Reclassified Statement of Net Cost Line 12.2) 

- Same as (3) Buyer Costs plus (4) Buyer Assets, but from the Seller’s perspective 

9. Seller: RC 24 - Buy/Sell Costs (Reclassified Statement of Net Cost Line 7.3)

- Same as (4) Buyer Assets, but from the Seller’s perspective
TREASURY UNCLASSIFIED // EXTERNAL

Page 8 L EAD ∙ T RANSFORM ∙ D ELIVER

ATB Summary Report

• New option under Reports menu, available to new TAS Reconciler role

• Request by Accounting Period (Fiscal Year + Month) and Reporting TAS

• Summed by Data Element, Sub Element, Partner AID, Partner MAIN and Doc Number

• User will copy Document Number to look up Order Schedule Balance (next slide)
TREASURY UNCLASSIFIED // EXTERNAL

Page 9 L EAD ∙ T RANSFORM ∙ D ELIVER

Order Schedule Balance Page

• User still needs Order role and data access to view Orders on OSB page

• Looking up Invoices and other EZ documents will be possible when 7600EZ is released

• Later in 2023 we will discuss ways to improve ATB Summary reporting
TREASURY UNCLASSIFIED // EXTERNAL

Page 10 L EAD ∙ T RANSFORM ∙ D ELIVER

Version History

Version Date Release Description

v0.1 7/1/2022 4.6 First version for review before publishing

v1.0 7/11/2022 4.6 First published version