Treasury Analyst

About the role

Assists the Director of Financial Services (Controller) in monitoring and maintaining bank accounts, investment pools, securities, and recording financial transactions to the general ledger. Assists the Treasury Specialist with accounts receivable, procurement and security of district funds in accordance with state and federal guidelines and district policies.

Responsibilities

• Monitor bank balance and collateral requirements daily.
• Coincide with the Controller for funding needs and cash availability.
• Prepare and report cash and investment pool balances daily to the Controller and Director of Financial Reporting.
• Maintain record of voided vendor payments and payroll checks.
• Initiate bank transfers from the depository accounts to the vendor clearing account once funding is received.
• Compile vendor funding reports for vendor payments.
• Process all deposits & direct deposits received in investment pools and assigned bank accounts.
• Coordinate with other departments to collect supporting documentation and budget code fund needed to record journal entries to the general ledger.
• Initiate wires and ACH requests, and complete transfers for district payrolls, liabilities, benefits payments, and risk management invoices once reconciled and approved by accounting.
• Complete bank transfers as requested for the Controller, Accounting, Payroll, and Treasury departments.
• Assist the Controller and CFO with settling investment purchases, coordinate with financial institutions and confirm trade confirmations.
• Maintain investment purchases, maturities, interest payments, fees, and dividends in the Treasury Desktop database and investment spreadsheet according to monthly statements, investment activity, and trade tickets.
• Absorb quarterly investment reports to ensure reporting accuracy to the Board of Trustees.
• Review the investment spreadsheet at the end of each fiscal year and prepare end-of-year journal entries.
• Complete monthly financial reporting requirements including monthly cash balance, recording interest and other assigned banking transactions for bank accounts and investment pools in journal entries on the general ledger, collect and file bank statements, investment pool statements, and fiduciary fund statements, and reconcile voided checks with the accounting department.
• Absorb annual audit requests for Financial Services & Treasury Services.
• Fund scholarship payments annually according to board-approved scholarship awards.
• Update and maintain pool authorizations and depository information according to changes in district personnel and banking institutions.
• Absorb coordination with Varsity Football season to include but not limited to: ticket orders, staffing, scheduling couriers, event manager/supervisor.
• Track and reconcile ticket sales and prepare weekly reports for sporting event ticket sales.
• Reconcile General Ledger receivable accounts monthly; to include research and journal entries, if required.
• Research discrepancies within the scope of the department to include invoicing, credit card receipts, tickets sales and inventory.
• Prepare and processes monthly sales tax reports from campus reports to state comptroller.
• Performs other such tasks that may be assigned by the Director of Financial Services.

Qualifications

• Must have intermediate knowledge of excel to include pivot tables.
• Bachelor's degree in a business field; two or more years of working in a business office processing payments or reconciling accounts preferred OR two or more years' experience working in a Texas Public School District Business Services Department along with TASBO certification (Accounting/Finance Specialization required for CTSBS or CTSBO) may substitute for Bachelor's degree OR two or more years' experience working in a Texas Public School District Business Services Department along with 60 semester hours of college credit.
• Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.
• Ability to write reports, business correspondence, and procedure manuals.
• Ability to effectively present information and respond to questions from members of the board of trustees, administrators, staff, auditors, and the general public.
• Ability to work with mathematical concepts such as probability and statistical inference.
• Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.

Other skills and abilities

• Must be able to operate an IBM-compatible computer.
• Must be familiar with word processing, spreadsheets, e-mail, and the internet.

Reasoning ability

• Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.
• Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

Physical demands

• Occasionally lift or carry (less than 15 pounds).
• Requires considerable close up work with computer video displays.

Work environment

• Occasional district-wide travel to multiple campuses as assigned.
• The noise level in the work environment is usually quiet/moderate.

Prepared By:

Sheila Ham, Director of Financial Services

Prepared Date: June 11, 2024