Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'bank_recon'

Finance - Bank Reconciliation (BC)

[bank_recon]

ID Element Name Type Size Values Cycle

Key

BC0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2021-2022 reporting year fy must be = 32

fy Num 2 Table 1-9
BC0020

Cycle - The reporting cycle for which the data is submitted:

1 = September 30th
2 = October 15th
3 = November 15th
4 = December 15th
5 = February 15th
6 = April 15th
7 = June 15th
8 = July 31st
9 = August 31st
cycle Num 2 Table 1-9
BC0030

LEA, District/Coop -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, and cooperative. The first two digits represent the county, the second two digits represent the district, and the last three digits represent the individual school, for example:

6001000
60 = Pulaski County
01 = Little Rock School District
000 = N/A (zeroes for district)
lea Alpha 7 Appendix BD 1-9
BC0035

Finance Period - The twelve Financial Management System banking periods reported to APSCN during the year

finance_period Num 2 1-9

General

BC0040

Bank Statement Balance - This entered amount is the ending cash balance according to the bank statement being reconciled.

Cycle Cycle
Deadline
Accounting
Period
Month End of
Accounting Period
Cycle 1
Cycle 2
Cycle 3
Cycle 4
Cycle 5
Cycle 5
Cycle 6
Cycle 6
Cycle 7
Cycle 7
Cycle 8
Cycle 9

Sept 30
Oct 1
Nov 15
Dec 15
Feb 15
Feb 15
Apr 15
Apr 15
June 15
June 15
July 31
Aug 31

Period 1
Period 2
Period 3
Period 4
Period 5
Period 6
Period 7
Period 8
Period 9
Period 10
Period 11
Period 12
July 31
August 31
September 30
October 31
November 30
December 31
January 31
February 28
March 31
April 30
May 31
June 30

"All Districts, Charters and Education Service Cooperatives are to submit bank reconciliations for every cycle."

bank_bal Dec 10,2 ##,###,###.## 1-9
BC0050

Deposits In Transit - This entered amount is the money which is in transit to the bank since the closing date of the bank statement

dep_trans Dec 10,2 ##,###,###.## 1-9
BC0060

Outstanding Checks - This pulled amount from database is the total amount of checks that have not been presented to the bank for payment.

out_checks Dec 10,2 ##,###,###.## 1-9
BC0070

Adjusted Bank Balance - The bank balance calculated from the bank statement (BC0040) plus the deposits in transit (BC0050) less the outstanding checks (BC0060).

adj_bank_bal Dec 10,2 ##,###,###.## 1-9
BC0080

Computer Cash Balance - The general ledger cash accounts total (cash account range: 01010 - 01029, 01070 - 01079).

gl_cash_bal Dec 10,2 ##,###,###.## 1-9
BC0090

Bank Account Variance - The difference between the adjusted bank balance (BC0070) less the computer cash balance (BC0080).

bank_var Dec 10,2 ##,###,###.## 1-9
BC0100

Reconciled By - Staff employee who reconciled bank statement.

reconciled alpha 30 1-9
BC0110

Date Reconciled - Date staff employee reconciled bank statement.

date_recon Date ##/##/#### 1-9
BC0120

Date Reviewed By Superintendent - Date superintendent reviewed reconciled bank statement.

date_reviewed Date ##/##/#### 1-9
No change Added Modified Deleted

Back to List