Tie Out Schedules
This step is to confirm that the balances tie out between the Treasurer's Report, C-4/C-5, and Schedule 06.
Using printed copies of the Treasurer's Report, tie the balances to the various reports. Next to the balance make a tie symbol, such as a check mark, and note the report that is tied to the balance, then place a tie symbol and note on the corresponding report.
Print Treasurer's Reports
- Go to Reports > Treasurer's Report
- Print December Treasurer's Report for both the reporting year and the prior reporting year and January for the reporting year. For help see How do I print the Treasurer's Report?
- Compare the ending of the prior year Treasurer's Report with the beginning balances for January of the reporting year for both funds and cash to confirm that there are no errors.
Print C-4/C-5
This is an income statement for each reportable fund as well as your entity in total. Beginning and ending balances are separated based on reserved and unreserved portions. The total ending balance for each fund should equal the ending balance column on the December Treasurer's Report. The main groupings on the C-4/C-5 usually match the financial report in BIAS. Rolled funds, however, present some challenges. Please see the BARS manual for guidance on rolling funds. The State Auditor's office will review funds to make sure only allowable funds are reported separately.
- Go to Reports > Annual Reports > C-4 / C-5 Report
- Select the reporting Tax Year
- Click Printer
- The Beginning Fund Balances must match the Ending Fund Balances for the prior year C-4/C-5 (the online version from SAO) both in total and by classification. (This is tested upon submission of Schedule 01).
- The Total Ending Fund Balance should match the Total Ending Balance on the reporting year's December Treasurer's Report.
Check Schedule 06
The Schedule 06 is also known as the Schedule Summary of Bank Reconciliation
- Go to Reports > Annual Reports > Schedule 06
- Select the reporting Tax Year
- Click C4/5 for the same year. The C4/5 MUST be run prior to the Schedule 06.
- Click Preview for the C4/5 report
- Close the C4/5 window
- Click Printer for Schedule 06
Schedule 06 is working if:
- C-4/C-5 Beginning Balance ties to GL Totals in Beginning Balance column.
- C-4/C-5 Total Revenues and Total Other Increases ties to GL Totals in Receipts column.
- C-4/C-5 Total Expenditures and Total Other Decreases ties to GL Totals in Disbursements column.
- C-4/C-5 Total Ending Balance ties to GL Totals Ending Bank Balance.
- Unreconciled Variance should be Zero
- If Unreconciled Variance are not zero and/or total does not match, make sure all debits and credits from the bank statement are entered into all months of the bank reconciliation then rerun the Treasurer's Report for the entire year by using Batch Update. Reprint the Treasurer's Report, Statements C-4/C-5, and Schedule 06 and check again.
- If the Unreconciled Variance are still not zero and/or total still does not match, then the Schedule 06 may not be working. Contact BIAS Support for troubleshooting.
- Continue with this step & subsequent steps regardless of whether the Schedule 06 is working.
Selecting Preview, Printer or PDF for the Schedule 06 will also generate an Excel file.
- Click Statements
- Statement data comes from Reconcile Checking Accounts. The ending balances of the Treasurer Reports and the bank reconciliation need to match.
- It is good practice to sum all of the Deposits and Withdrawals from the Statements and tie them out to the Schedule 06.
- Click Adjustments
- Click Print
- Save the adjustments report for the next audit.
