Non-UGLG Distribution Transactions

Summary

A reporting template, Non-UGLG Distribution Transactions, version 2022.06.02, for a state to report transactions to jurisdictions within a non-UGLG county. It instructs reporters not to change cell formatting or reformat the template and to enter all data as text. The fields are the non-UGLG county name, jurisdiction name, jurisdiction number assigned by the state, UEI number, transaction ID, whether the transaction was a payment or a transfer to the state under Section 603(c)(4), first or second tranche, amount and date.

Summary drafted by a model from the document's text below and checked by script against that text before publication. It is a navigation aid, not a reading of what the document proves. Where AI is used

Full text

Text extracted from the spreadsheet file: one line per row, cells separated by tabs, each sheet headed by its name. Numbers appear as stored, without the workbook’s formatting.

Sheet: Non-UGLG Distribution Template 
Version: 2022.06.02
Template Name: Non-UGLG Distribution Transactions
Instructions to Reporter: - Do not change the cell formatting - Do not reformat the template - All data should be as text
Field ID	Non_UGLG_County_Name__c	Jurisdiction_Name__c	Jurisdiction_Number__c	Jurisdiction_UEI__c	Transaction_ID_as_Assigned__c	Payment_or_Transfer__c	First_Tranche_or_Second_Tranche__c	Transaction_Amount__c	Transaction_Date__c
Required/Optional	Required	Required	Required	Required	Required	Required	Required	Required	Required
Field Name	Non-UGLG County Name	Jurisdiction  Name	Jurisdiction  Number	Jurisdiction UEI number	Transaction ID  (assigned by the State)	Transaction Type	Transaction Description	Transaction Amount	Transaction Date
Help Text	Provide the name of the Non-UGLG County	Provide the name of the UGLG jurisdiction within the non-UGLG county	Include the Jurisdiction Recipient Number assigned by the State to the Jurisdiction (e.g., AZ0013)	Include the Jurisdiction UEI number,  (Valid Format XXXXXXXX)	Provide the transaction ID, assigned by the State	Indicate whether the transaction was a Payment or Transfer to State under Section 603(c)(4) Valid Entries "Payment" or "Transfer"	Provide a description of the transaction (Enter "First Tranche" or "Second Tranche")	Provide the transaction amount. For transfers to the state under Section 603(c)(4), include the amount intended for transfer to the state. DO NOT include a "$" sign when entering Amounts.	Provide the date of the transaction. For transfers to the state under Section 603(c)(4), provide the date that Treasury's transfer form agreement was signed by both parties (not the expected date that Treasury grants the transfer).  Valid Format MM/DD/YYYY

File and source

File

TREAS-Non-UGLG-Transaction.xlsx

Size

19,767 bytes

SHA-256

9f12cb0e27a41db857d372c9fd817b1963d1916692e32a9dc9327f24172479c9

Our copy

TREAS-Non-UGLG-Transaction.xlsx

Original

home.treasury.gov