|
|
Cooperative Extension Service
Departments
Financial Services
County Depository Accounts
Monthly Reconciliation Form
- Retrieve the County Depository Account Monthly Reconciliation Form from
the templates on the Cooperative Extension Intranet and save it to your personal
computer.
- Open the County Depository Account Monthly Reconciliation Form on your
personal computer and enter the county name and the month being reconciled at
the top of the form.
- Print the Depository Account Activity Report from Quicken for the month to
be reconciled.
- Compare the transactions on your bank statement to the transactions on the
Depository Account Activity Report.
- Enter the ending balance from your bank statement for the month being
reconciled in the appropriate cell in the first box of the County Depository
Account Monthly Reconciliation Form.
- Enter the date and amount for any deposits that appear on your Depository
Account Activity Report but not on your bank statement in the appropriate cells
in the “ADD:” section in the first box of the County Depository Account Monthly
Reconciliation Form.
- Enter the date and amount for any service charges, transfers, or other
transactions that appear on your bank statement but not on your Depository
Account Activity Report in the appropriate cells in the “Other Additions”
section in the first box of your County Depository Account Monthly
Reconciliation Form.
- Enter the date and amount for any interest or other transactions that
appear on your bank statement but do not appear on your Depository Account
Activity Report in the appropriate cells in the “Deduct:” section in the first
box of your County Depository Account Monthly Reconciliation Form.
- Enter your ending Quicken balance from the prior month’s County Depository
Account Monthly Reconciliation Form and your net total transactions, OVERALL
TOTAL, from your Depository Account Activity Report in the appropriate cells in
the second box on the County Depository Account Monthly Reconciliation Form.
- Make sure that the “Reconciled Balance” in the first box on the County
Depository Account Monthly Reconciliation Form agrees with the “Quicken balance,
End of Month” in the second box on the County Depository Account Monthly
Reconciliation Form.
- Click on “File” and “Save As” in your Excel menu and save your County
Depository Account Monthly Reconciliation Form using the appropriate month and
year in your title so that you can retrieve it at a later date if needed.
- Print out and sign the County Depository Account Monthly Reconciliation
Form in the blank next to “Reconciled by:” and enter the date you reconciled
the report in the blank next to “Date Reconciled:”
- Ask the Staff Chair to review the County Depository Account Monthly
Reconciliation Form and sign in the blank above Staff Chair.
- Make a copy of the County Depository Account Monthly Reconciliation Form
for your files, attach the original bank statement to your copy, and place it in
your files.
- Attach a copy of the bank statement for the month being reconciled, your
deposit tickets for the month being reconciled, and any receipts you wrote or
voided during the month to the original County Depository Account Monthly
Reconciliation Form and send them to Linda Meeks in the Financial Services
Office at the Little Rock State Office by the fifteenth of the month following
the month being reconciled.
Back to
County Bank Accounts |
