FEDERAL FUNDS MONTH END RECONCILIATION
Download this form as an Adobe Acrobat PDF
Month_________________________
|
Report
|
Column Heading
|
Row Heading
|
Budget Code
|
| l |
These Must = |
|
|
|
| |
BD702 |
MTD/QTD/YTD |
Ending Cash in Budget Code |
|
| |
AK 04 |
CURRENT BALANCES |
Previous Month Balance |
|
| |
BD800DET |
BALANCE |
Ending Cash Balance |
|
| * |
GL Screen 016 |
ENDING BALANCE |
Period Closing |
|
|
|
Cash 111260 |
|
|
|
|
|
|
|
|
$ |
|
| 2 |
These Must = |
|
|
|
| |
BD702 |
YEAR TO DATE |
Excess Exp. over/under Rev. per BD701 |
|
| |
BD701-Cert. |
*ACTUAL*YEAR-TO-DATE |
Increase/Decrease in Fund Balance |
$ |
|
|
3a
|
These Must = |
|
|
|
|
|
BD800SUM |
YTD RECEIPTS |
Budget Code Number |
|
|
**
|
AK 07 |
YTD RECEIPTS |
As of last entry for month closing |
$ |
| |
|
|
|
|
| 3b |
BD800SUM |
YTD DISBURSEMENTS |
Budget Code Number |
|
|
**
|
AK 08 |
YTD EXPENDITURES |
As of last entry for month closing |
$ |
|
| 4a |
These Must = |
|
|
|
| |
BD800DET |
DEPOSITS/TRANS ADJ |
Period Balance |
|
| |
BD800SUM |
CURRENT RECEIPTS |
Budget Code Number |
$ |
| |
|
|
|
|
| 4b |
BD800DET |
DISBURSEMENTS/TR ADJ |
Period Balance |
|
| |
BD800SUM |
DISBURSEMENTS |
Budget Code Number |
$ |
|
|
**
|
Entries in Cash Management (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 entries made
in the current month (or subtract current month entries from ending balance) |
| * |
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 |
