Skip to main content
Skip table of contents

Certified Annual Report - File Layouts

Chart of Account Import File Layout

File Name: CARYEARDIST.txt

File naming convention:

  • CAR

  • YEAR = Fiscal Year (four digits)

  • DIST = District Number (four digits)

Example: CAR20214203.txt

Record Layout

The following table lists the fields, data type, length, and notes for the CAR electronic file.

Field

Type

Length

Notes

District ID

Text

4

-

Account ID

Text

1

Valid values:

  • 1 = Current Asset

  • 2 = Long Term Asset

  • 3 = Other Asset

  • 4 = Current Liability

  • 5 = Long Term Liability

  • 6 = Other Liability

  • 7 = Fund Balance

  • 8 = Revenue/other financing sources

  • 9 = Expenditure/expense/other financing uses

Account ID 1-7 match the first digit in the balance sheet account code.

Fund

Text

2

-

*Facility

Text

4

*required to segregate Charter School transactions

Function

Text

4

-

Program

Text

3

-

Project

Text

4

-

Object

Text

3

-

Source

Text

4

-

Account

Text

3

-

**Amount

Numeric

18

**decimal point expected; comma or dollar sign not allowed

Header Record

The first record of the import file contains the District ID. Fields following the District ID are represented by zeroes (0).

Example: 4203,0,00,0000,0000,000,0000,000,0000,000,0

Trailer Record

The last record of the import file contains the District ID and the count of records in the input file including the header and trailer records. The count of records is stored in the Amount field. Fields between the District ID and Amount fields are represented by nines (9).

Example: 4203,9,99,9999,9999,999,9999,999,9999,999,7123

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.