Business

User Tools

Site Tools

Trace: • Monthly

Sidebar

Table of Contents

academy:calendar:monthlyactivities
Book Creator
 Add this page to your book
Book Creator
 Remove this page from your book  

 Manage book(0 page(s))
 Help

Monthly

In addition to the tasks identified on the individual month tabs and the quarterly tab, the following recurring tasks were identified as items to be addressed on a monthly basis; if applicable, throughout the fiscal/school year.

❏ Bank Reconciliation
❏ New Employee Setup
❏ TRS Processing
❏ Process Payroll
❏ Payroll Liability Wire Transfer Transactions
❏ Requisition Process
❏ End-of-Month Closing Checklist

Application(s)Task
Bank Reconciliation

❏ Reconcile bank statements to general ledger cash balances.

  • Be certain that IRS and TRS withdrawals are displayed on the monthly bank statement. If not, determine if a payment was overlooked.
  • Investigate any prior month deposits in transit that do not clear.
  • Review outstanding checks for any items that are old or seem unreasonable.

❏ Reconcile investment account statements to general ledger account balances.

  • Prepare monthly/quarterly investment report for the board. (required by statute)

❏ Investigate outstanding checks to determine if action is required.

❏ Reconcile Due To and Due From accounts (126X/217X).

❏ Reconcile specific general ledger accounts such as “receivables” (12XX).

Finance

❏ Verify that all cash receipts are entered for the month.

  • Pull the TEA payment report and post receipts dated during the current month.
  • Verify that NSLP breakfast and lunch funds were received (districts only have 60 days to claim after the month ends or will lose that month's child nutrition program reimbursement).
  • Verify Foundation School Program funds are recorded.
  • Verify Available School Fund payments are recorded.
  • Verify other grant receipts are payment report are recorded.

❏ Verify that all check payments are entered.

  • 1099 reporting - Obtain W-9 forms for any new vendors.

❏ Verify that all fund transfers are recorded.

❏ Record interest earned on bank accounts and investments.

❏ Record received commodities.

❏ Review general ledger accounts for any expenditures with 00 for function; 000 for organization, or 00 for program intent code.

❏ Review and validate remaining balances in the payroll clearing fund (163).

❏ Report federal and state grant expenditures to the LEA to file for reimbursement.

❏ Review board reports (no detail) for percent expended compared to % expected for this month of the year; if any vary more than 5% above or below, review the detail line item budgets to determine the cause and whether an item was incorrectly coded.

  • Prepare budget amendments as needed.

❏ Keep the superintendent and the board informed of finance issues.

❏ Verify time and effort and make any necessary payroll adjustments for those employees who are required to track time and effort monthly.

❏ Monitor cash balances (daily) to ensure all LEA funds are secured.

❏ Drawdown federal funds monthly as needed to avoid possible high-risk auditee status.

Payroll & Personnel

❏ The TRS ActiveCare payment is due through TEXNET the 15th of the month. If the 15th of the month is not a business day, payment is due by the last business day prior to the 15th.

❏ Work on staff unique IDs (UID).

❏ New Hire Reporting – Generate the Personnel > Reports > Personnel Reports > New Hire Report

❏ Verify that all payroll transactions are recorded or interfaced.

  • Regular payroll(s) is/are processed and interfaced.
  • Supplemental payroll(s) is/are processed and interfaced.
  • Payroll transfer has been automatically posted by the system or manually posted.
  • Payroll deduction checks are processed and/or posted.
  • TRS wires are submitted and recorded by the 6th of the following month.
  • IRS wires are submitted and recorded immediately after payroll. Reference the IRS website for further information: Publication 15 (Circular E).
  • TRS reports are filed and the status is complete.
  • TRS On-Behalf calculations are recorded monthly or annually if preferred.
  • Other payroll-related items such as recognizing rent income are posted.
  • Verify all new hire reporting is done.

❏ Run the Payroll Accrual Variance Extract. This extract can be run before any payrolls are processed for a new school year or during the school year.

❏ Reconcile accrued payroll to 216X (accrued wages) and 22XX (accrued benefits).

academy/calendar/monthlyactivities.txt · Last modified: 2023/10/06 14:33 by emoreno

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.