GENERAL FUND MONTH END
RECONCILIATION
Download this form as an Adobe Acrobat PDF
Month_____________________________________
|
Report
|
Column Heading
|
Row Heading
|
Budget Code
|
| l |
These Must = |
|
|
|
|
|
BD702 |
BUDGET |
Excess Exp.over/under Rev per BD701 |
|
| |
BD701-Cert. |
*BUDGETED*AUTHORIZED |
Appropriation |
|
| |
AK 04 |
APPROPRIATIONS |
Adjusted Appropriation |
$ |
|
| 2a |
These Must = |
1st Two Months of Quarter |
|
|
| |
BD702 |
UNALLOTTED |
Excess Exp. over/under Rev. per BD701 |
|
| |
AK 04 |
APPROPRIATIONS |
Appropriation Balance |
$ |
| |
|
|
|
|
| 2b |
These Must = |
Last Month of First 3 Quarters |
AFTER QUARTERLY REVERSION HAS BEEN POSTED |
|
| * |
AK 05 |
BALANCE |
As of last entry for month closing |
|
| |
BD702 |
UNALLOTTED |
Excess Exp. over/under Rev. per BD701 LESS |
- (
) |
| |
|
UNEXPENDED QTD |
Net Allotment |
$ |
| |
|
|
|
|
| 2c |
These Must = |
Last Month the Fiscal Year |
JUNE |
|
|
* |
AK 05 |
BALANCE |
As of last entry prior to June 30 |
|
| |
BD702 |
UNALLOTTED |
Excess Exp. over/under Rev. per BD701 LESS |
- (
) |
| |
|
UNEXPENDED QTD |
Net Allotment |
$ |
|
| 3a |
These Must = |
1st Two Months of Quarter |
|
|
| |
BD702 |
UNEXPENDED |
Unexpended Appropriation |
|
| |
BD702 |
UNALLOTTED |
Excess Exp.
over/under Rev. per BD701 PLUS |
+ |
| |
|
UNEXPENDED QTD |
Net Allotment |
$ |
| |
|
|
|
|
| 3b |
These Must = |
Last Month of
First 3 Quarters |
AFTER
QUARTERLY REVERSION HAS BEEN POSTED |
|
| |
BD702 |
UNEXPENDED |
Unexpended Appropriation |
|
| |
BD702 |
UNALLOTTED |
Excess Exp.
over/under Rev. per BD701 |
$ |
|
|
4 |
These Must= |
|
|
|
| |
BD702 |
MTD/QTD/YTD |
Ending Cash
in Allotment |
|
| |
BD800DET |
BALANCE |
Ending Cash Balance |
|
| |
AK 04 |
ALLOTMENTS |
Month End |
|
| ** |
GL Screen 016 |
ENDING BALANCE |
Period Closing |
|
| |
Cash 111270 |
|
|
|
| |
|
|
|
$ |
|
| 5a |
These Must = |
|
Expenditures |
Revenues |
| |
BD702 |
CURRENT MONTH |
Expenditures/Revenues |
|
| |
BD701-Cert. |
*ACTUAL*CURRENT
MONTH |
Expenditures/Revenues $ |
$ |
| |
|
|
|
|
| 5b |
BD702 |
YEAR TO DATE |
Expenditures/Revenues |
|
| |
BD701-Cert. |
*ACTUAL*YEAR-TO-DATE |
Expenditures/Revenues $ |
$ |
|
| 6a |
These Must = |
|
|
|
| |
BD800SUM |
YTD RECEIPTS |
|
|
|
* |
AK 07 |
YTD RECEIPTS |
As of last
entry for month closing |
$ |
| |
|
|
|
|
| 6b |
BD800SUM |
YTD DISBURSEMENTS |
|
|
|
* |
AK 07 |
YTD EXPENDITURES |
As of last
entry for month closing |
$ |
|
| 7a |
These Must = |
|
|
|
| |
BD800DET |
DEPOSITS/TRANS ADJ |
Period Balance |
|
| |
BD800SUM |
CURRENT RECEIPTS |
|
$ |
| |
|
|
|
|
| 7b |
BD800DET |
DISBURSEMENTS/TR ADJ |
Period Balance |
|
| |
BD800SUM |
CURRENT
DISBURSEMENTS |
|
$ |
|
|
* |
Note: Entries in Cash Management (AK05, AK07, AK08) are listed by date
entered, not effective date. In order to get the correct month-end
balance for the month you are closing, be sure and include any closing
month entries made in the current month (or subtract current month
entries from ending balance). |
| ** |
Note: You will not be able
to use summary center 999999999999 in cases where there are multiple
companies within a budget code or multiple budget codes within a
company. |