The CTA Detail Transaction Listing provides the detail journal lines that are included in the CTA Bulk File.
CTA Transactions are entered directly through a general ledger journal. The journal must use the Category Defined for the site level System Profile: FV: Reclassification Journal Category. This category is used to identify reclassification journals for CTA purposes. A proper reclass must balance by account type (disbursement or receipt) and ALC. Users must reverse journal reclassification entries and post new reclassifications in order to resolve exceptions posted through General Ledger journal.
The CTA Exception Report includes transactions that require review or correction before a bulk file can be processed. These include:
Journal does not Balance by Account Type and Agency Location Code (ALC)..
Adjustment BETC is not Defined for Agency Payment BETC.
Adjustment BETC is not Defined for Agency Collection BETC.
Adjustment BETC is not Defined for Trading Partner Payment BETC.
Adjustment BETC is not Defined for Trading Partner Collection BETC.
A default Payment BETC is not mapped to the Agency TAS.
BETC entered is not a valid Payment BETC for Agency TAS.
A default Collection BETC is not mapped to the Agency TAS.
BETC entered is not a valid Collection BETC for Agency TAS.
A default Collection BETC is not mapped to the Trading Partner TAS.
BETC entered is not a valid Collection BETC for Trading Partner TAS.
A default Payment BETC is not mapped to the Trading Partner TAS.
BETC entered is not a valid Payment BETC for Trading Partner TAS.
Information regarding CTA requirements is available on Treasury's Fiscal Services website:
http://www.fiscal.treasury.gov/fsservices/gov/acctg/cars/factsheet_cta.htm
In the Define Federal Options window; the Agency address, the Disbursement in the Transit checkbox, the appropriate Confirm Cash Account, and the Interagency Activity name must be selected.
A bank account must be defined for each agency ALC.
The address must be assigned for each agency ALC.
Ensure that needed BETCs are defined.
Ensure Adjustment BETCs are properly defined for primary Non-Adjustment type BETCs.
Ensure that needed Trading Partner TASs are defined.
Ensure TAS and Trading Partner TASs are mapped to appropriate BETCs with default collection and payment BETCs identified.
Define a Journal Category value for the site level System Profile: FV: Reclassification Journal Category. This category is used to identify reclassification journals for CTA purposes.
Coordinate ALC CARS full reporter status with Treasury and adjust ALC definition as necessary.
Verify that the CTA FBWT Account Definition are properly defined for Disbursement and Receipt accounts for all ALCs.
Users must reverse journal reclassification entries and post new reclassifications in order to resolve exceptions.
Use the Standard Request Submission windows to submit the CTA Process.
Ledger Name: Select the ledger to report on.
Period Name: Enter the period for the report.
Preliminary or Final: Select the Preliminary or Final mode.
Note: If Preliminary is selected, the report can be regenerated. If Final is selected, the report cannot be regenerated. Once the report is run in the Final mode, only a supplemental report can be generated.
Agency Location Code: Select the agency location code to report on.
If the "Partial or Full?" value is Partial, all applicable GWA reportable agency location codes are listed. You can either select all or one of the agency location codes.
If the "Partial or Full?" value is Full, by default all non GWA reportable agency location codes are selected.
Note: The value ALL can be selected to print the FMS Form 224 Statement of Transactions for all agency location codes defined for the ledger.
The CTA Detail Transaction Listing is printed automatically when the CTA bulk file is generated.
The CTA Detail Transaction Listing displays the TAS components per the Treasury Account Symbol or Trading Partner Treasury Account Symbol and BETC or Trading Partner BETC. This report displays data contained in the CTA Bulk file. The report groups transaction by Agency Location Code and Treasury Account Symbol within Agency Location Code as described in the following table:
| Column | Description |
|---|---|
| Header Section | Reported Period, Reported Date, Ledger name, Run Mode |
| ALC | Agency Location Code being reported |
| TAS | Treasury Account Symbol |
| BETC | Business Event Type Code for the TAS being reported |
| Journal Name | Journal name for the reclassification transaction |
| Acct No | Fund Balance with Treasury account associated with the transaction |
| Debit | Debit transaction amount |
| Credit | Credit transaction amount |
| Total for ALC | ALC, Debit total, Credit total (Note: must net to zero) |
The CTA Exception Report is printed automatically when the CTA process is run. The following table describes the CTA Exception report.
| Column | Description |
|---|---|
| Report Header Section | Reported Period, Reported Date, Ledger name, Run Mode |
| Section Header Section | Agency Location Code, Journal Name, Account type (Disbursement or Receipt) |
| TAS | Treasury Account Symbol |
| BETC | Business Event Type Code for the TAS being reported |
| Acct No | Account reported on the Journal |
| Debit | Debit transaction amount |
| Credit | Credit transaction amount |
| Exception Description | Exception description |
| Total for the Journal | Journal Name, Debit total, Credit total |