Part 1

SUPPLEMENT

DRAFT F

Number:Name:Description:Type:Operand:Fatal Period:Proposed Analytical Period:

Right Side Attribute Combination

SZUSSGL ACCOUNT NUMBER Begin/End Zero

429590 B

01,02,03,04,05,06,07,08,09,10,11,12

Left Side Attribute Combination

Equal (=)

U.S. Standard General Ledger

Data Edits - Detail Report

3Beginning Budgetary Account BalanceThe sum of the beginning balance of USSGL 4000-series accounts must equal zero for each reported TAS.USSGL / Zero

Draft Bulletin No. 2017-06 VII EDR - 1 
Part 1

SUPPLEMENT

DRAFT F

Number:Name:Description:Type:Operand:Fatal Period:Proposed Analytical Period:

Right Side Attribute Combination

SZUSSGL ACCOUNT NUMBER Begin/End Zero

119090 B135090 B135990 B

01,02,03,04,05,06,07,08,09,10,11,12

Left Side Attribute Combination

Equal (=)

U.S. Standard General Ledger

Data Edits - Detail Report

22Beginning Proprietary Account BalanceThe sum of the beginning balances for the proprietary USSGL accounts must equal zero for each reported TAS.USSGL / Zero

Draft Bulletin No. 2017-06 VII EDR - 2 
Part 1

SUPPLEMENT

DRAFT F

Number:Name:Description:Type:Operand:Fatal Period:Proposed Analytical Period:

Right Side Attribute Combination

SZUSSGL ACCOUNT NUMBER Begin/End Zero

119090 E135090 E135990 E591910 E

01,02,03,04,05,06,07,08,09,10,11,12

Left Side Attribute Combination

Equal (=)

U.S. Standard General Ledger

Data Edits - Detail Report

23Ending Proprietary Account BalanceThe sum of the pre-closing ending balances for the proprietary USSGL accounts must equal zero for each reported TAS.USSGL / Zero

Draft Bulletin No. 2017-06 VII EDR - 3 
Part 1

SUPPLEMENT

DRAFT F

Number:Name:Description:Type:Operand:Fatal Period:Proposed Analytical Period:

Right Side Attribute Combination

SZUSSGL ACCOUNT NUMBER Begin/End Zero

411991 E411992 E411993 E411994 E426800 E429590 E435190 E

01,02,03,04,05,06,07,08,09,10,11,12

Left Side Attribute Combination

Equal (=)

U.S. Standard General Ledger

Data Edits - Detail Report

24Ending Budgetary Account BalanceThe sum of the pre-closing ending balance of USSGL 4000-series accounts must equal zero for each reported TAS.USSGL / Zero

Draft Bulletin No. 2017-06 VII EDR - 4 
Part 1

SUPPLEMENT

DRAFT F

Number:Name:Description:Type:Operand:Fatal Period:Proposed Analytical Period:

Right Side Attribute Combination

SZUSSGL ACCOUNT NUMBER Begin/End PY Adj Zero

411991 E B411992 E B426800 E B435190 E B462090 E B

01,02,03,04,05,06,07,08,09,10,11,12

Left Side Attribute Combination

Equal (=)

U.S. Standard General Ledger

Data Edits - Detail Report

46Ending Budgetary Account Balance for Prior Year Adjustments Backdated in Treasury's Central Accounting SystemThe sum of the pre-closing ending balance of USSGL 4000-series accounts with Prior Year Adjustment domain value B (adjus

reporting backdated in Treasury's Central Accounting System) must equal zero for each reported TAS.USSGL / Zero

Draft Bulletin No. 2017-06 VII EDR - 5 
Part 1

SUPPLEMENT

DRAFT F

Number:Name:Description:Type:Operand:Fatal Period:Proposed Analytical Period:

Right Side Attribute Combination

SZUSSGL ACCOUNT NUMBER Begin/End PY Adj Zero

411991 E P411992 E P426800 E P429590 E P435190 E P462090 E P

01,02,03,04,05,06,07,08,09,10,11,12

Left Side Attribute Combination

Equal (=)

U.S. Standard General Ledger

Data Edits - Detail Report

47Ending Budgetary Account Balance for Prior Year Adjustments Not Backdated in Treasury's Central Accounting SystemThe sum of the pre-closing ending balance of USSGL 4000-series accounts with Prior Year Adjustment domain value P (adjus

reporting not backdated in Treasury's Central Accounting System) must equal zero for each reported TAS.USSGL / Zero

Draft Bulletin No. 2017-06 VII EDR - 6 
Part 1

SUPPLEMENT

DRAFT F

Number:Name:Description:Type:Operand:Fatal Period:Proposed Analytical Period:

Right Side Attribute Combinatio

LSStatement Line Number Operand BETC

USSGL account 411100 - Debt Liquidation Appropriations + APUSSGL account 411200 - Liquidation of Deficiency - Appropriations + APADVUSSGL account 411500 - Loan Subsidy Appropriation + APBGTUSSGL account 411600 - Debt Forgiveness Appropriation + APCRREFUSSGL account 411700 - Loan Administrative Expense Appropriation + APINDUSSGL account 411800 - Reestimated Loan Subsidy Appropriation + APINDYECUSSGL account 411900 - Other Appropriations Realized + APINDYED

APLIMINDAPOTHAPROPRS

Left Side Attribute Combination

U.S. Standard General Ledger

Data Edits - Detail Report

490Proposed Edit 49 ReplacementThe BETC balances from the Central Accounting and Reporting System (CARS) that represent all the normal warrant activity sho

USSGL accounts 411100, 411200, 411500, 411700, 411800, and 411900.Statement Line / SMAFEqual (=)

Draft Bulletin No. 2017-06 VII EDR - 7 
Part 1

SUPPLEMENT

DRAFT F

Number:Name:Description:Type:Operand:Fatal Period:Proposed Analytical Period:

Right Side Attribute Combinatio

LSStatement Line Number Operand BETC

USSGL account

310100 - Unexpended Appropriations - Appropriations Received + AP

USSGL account 310600 - Unexpended Appropriations - Adjustments + APADV

APBGTAPCRREFAPINDAPINDYECAPINDYEDAPLIMINDAPOTHAPROPJRCRRAPPRCRAPPRDRSSWSWYESWYERV

Left Side Attribute Combination

U.S. Standard General Ledger

Data Edits - Detail Report

500Proposed Edit 50 ReplacementThe BETC balances from the Central Accounting and Reporting System (CARS) that represent all the normal warrant activity sho

USSGL accounts 310600 and 310100.Statement Line / SMAFEqual (=)

Draft Bulletin No. 2017-06 VII EDR - 8 
Part 1

SUPPLEMENT

DRAFT F

Number:Name:Description:Type:Operand:Fatal Period:Proposed Analytical Period:

Right Side Attribute Combinatio

LSStatement Line Number Operand BETC

USSGL account

411400 - Appropriated Receipts Derived from Available Trust or Special Fund Receipts + COLAVRAJ

COLAVRCTCOLAVRRV

Left Side Attribute Combination

U.S. Standard General Ledger

Data Edits - Detail Report

900Budgetary Resources Derived from Available Special and Trust Fund Receipt AccountsThe total End balance for USSGL 411400 must equal the balance for BETCs related to collections to available receipts in CARS.Statement Line / SMAFEqual (=)

Draft Bulletin No. 2017-06 VII EDR - 9 
Part 1

SUPPLEMENT

DRAFT F

Number:Name:Description:Type:Operand:Fatal Period:Proposed Analytical Period:

Right Side Attribute Combinatio

LSStatement Line Number Operand BETC

USSGL account

411300 - Appropriated Receipts Derived from Unavailable Trust or Special Fund Receipts + APSPCEXP

USSGL account

438700 - Temporary Reduction of Appropriaton from Unavailable Receipts, New Budget Authority + SRRCTEXP

USSGL account

438800 - Temporay Reduction of Appropriation from Unavailable Receipts, Prior-Year Balance +

Left Side Attribute Combination

U.S. Standard General Ledger

Data Edits - Detail Report

910Budgetary Resources Derived from Unavailable Unappropriated Special and Trust Fund Receipt AccountsThe sum of the ending balances in USSGL accounts 411300, 438700, and 438800 must equal the balance of BETCs related to U

Trust Funds in CARS.Statement Line / SMAFEqual (=)

Draft Bulletin No. 2017-06 VII EDR - 10 
Part 1

SUPPLEMENT

DRAFT F

Number:Name:Description:Type:Operand:Fatal Period:Proposed Analytical Period:SSUSSGL ACCOUNT NUMBER Begin/End Auth Type Code Fed/NonFed

USSGL ACCOUNT NUMBER Begin/End Auth Type Code 

119090 E 415800 E135090 E 438300 E S

Left Side Attribute Combination Right Side Attribute Combination

Equal (=)

U.S. Standard General Ledger

Data Edits - Detail Report

994Proposed Edit 4 ReplacementThis edit compares specific USSGL accounts and is intended as a replacement for Edit 4 which currently uses statement lines 

USSGL / USSGL

Draft Bulletin No. 2017-06 VII EDR - 11