This file layout is used to import general journal transactions.
|Appropriation Amount||11||6, 8|
|Expenditure Amount||11||6, 8|
|Estimated Revenue Amount||11||5, 7|
|Realized Revenue Amount||11||5, 7|
|Balance Amount||11||1, 2, 3|
|Journal Voucher Number||6|
|JV Number Description||30|
|JV Voucher Reason||30|
|General Ledger Account Description||30|
This is a comma-delimited file format, which means that commas are not allowed within a field. For example, there should not be any commas in the JV Number Description or the GL Account Description fields.
For amounts, decimal places not implied. For example, 6789 indicates $6,789, and 67.89 indicates $67.89. Eleven numeric characters can be entered with two decimal places, or when whole number are entered, nine numeric characters are allowed.
Credit amounts should start with a minus sign (e.g., -).
Amount fields with no data should be empty in the file; do not use zeros.
Newly created accounts will be validated by each component within the Finance > Tables > Account Codes tabs and will contain the same edits as found on the Finance > Maintenance > Create Chart of Accounts page.
The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.