Bank Account Reconciliation Worksheet
Additional information about account reconciliation can be found on the Account Reconciliation User Guide page.
Download Account Reconciliation Worksheet (Excel – .xlsx)
Instructions
Bank account reconciliation instructions
A. Steps to balance your bank account
A1. Fill out the top portion of the account reconciliation worksheet.
A2. Enter the month end balance from the bank statement.
A3. Enter any deposits in transit as of the end of the month you are reconciling.
A4. Enter the month end balance from the check register.
A5. Enter all outstanding checks as of the end of the month you are reconciling. Outstanding checks are those that have not cleared.
A6. Enter any outstanding adjustments as of the end of the month you are reconciling.
A7. The Adjusted Bank Statement Balance and the Adjusted Check Register should equal.
B. Steps to balance to the authorized Custodian Fund amount
B1. Enter the checks written through the month you are reconciling that have not been replenished.
B2. Enter the total amount of checks that have a stop payment. Enter the amount as a negative amount. Note that checks 90 days or older are to have a stop payment placed in US Bank SinglePoint.
B3. Enter the current authorized amount.
B4. Difference should be zero.
B5. Total amount of replenishment that needs to be requested from Cash Management to replenish the bank account. Note: complete replenishments at least every 90 days or sooner.
Download an Illustration of Instructions (Excel – .xlsx) |
Reloadable debit card reconciliation instructions
A. Steps to balance account
A1. Fill out top portion of Account Reconciliation Worksheet.
A2. Enter month end balance from Account Reconciliation Report.
A3. Enter any deposits in transit.
A4. Enter month end balance from Card Load Report.
A5. Enter all outstanding payments.
A6. Enter any outstanding adjustments.
A7. The Adjusted Account Statement Balance & the Adjusted Check Register should equal.
B. Steps to balance to the authorized Custodian Fund amount
B1. Enter the card load payments made through the month you are reconciling that have not been replenished.
B2. Enter the total amount of payment reversals.
B3. Enter current authorized amount.
B4. Difference should be zero.
B5. Total amount of replenishment that needs to be requested from Cash Management to replenish the reloadable debit card account. Note: complete replenishments at least every 90 days or sooner.
Reloadable Debit Card Reconciliation Instructions (PDF) |
Use this form to create a record for all Capital Equipment located off-campus.
Use this form to create a record for all Capital Equipment located off-campus.
The form can be signed by either site personnel or by a University of Wisconsin employee who has visited the site and can verify the information requested
Download Off Campus Verification (PDF)
Gift in Kind Routing Form
This form is used to setup a new bank account.
This form is used to setup a new bank account.
Download the New Bank Account Form (doc)
UW-Madison FY19 Year End Roll Forward Adjustment Request
Period 998 adjustment transactions are used to move SFS cash balances to the proper funding string for the new fiscal year operations.
A journal entry, with a JR998 journal mask, is created to record this type of transaction. This entry will be posted in early August and creates your beginning balance in WISER.
Download the 998 Department Adjustment Request FY19 (xls)
Instructions
Complete all required fields
- Requesting Department
- Contact name and phone #
- Roll From Coding: Fund, Project, Department ID or Range
- Roll To Coding: Fund, Project, Department ID
- Special Instructions
Enter the appropriate coding string
- 3-digit Fund
- 7-digit Project
- 6-digit Department ID
- Funds can only be requested from the funds listed to a different department or project at year end:
- Funds – 127, 128, 130, 134, 136, 140, 141, 143, 147, 151, 166, 533
Send in the form
Follow the Year End Accounting instructions.
A form used to justify and document why the requested transaction cannot be purchased using a competitive process.
Download the Non-Competitive Purchasing Request Form (PDF)
Use this form to justify and document why the requested transaction cannot be purchased using a competitive process.
Related Policies and Procedures
A form used to submit a request to SWAP for pick-up of surplus property.
Submit a request to SWAP for pick-up of surplus property AKA offload/dispose of surplus property.
Complete SWAP Surplus Request Form
Related policies and procedures
A summary sheet to outline information for processing transactions in the $5,000.00 to $49,999.00 range.
A form to be signed by a sole proprietor performing work for us, releasing the University from workers compensation liability.
A form to be signed by a sole proprietor performing work for us, releasing the University from workers compensation liability.
Download Worker’s Compensation Release of Liability (Word doc)
A form to include when an Entertainer or Speaker presents their own contract for the University's signature.
A form to include when an Entertainer or Speaker presents their own contract for the University’s signature.
View Standard Rider (Word doc)
Related Policies and Procedures