Treasury Analyst
Current1. Cash Applications a) Process the Lockbox staging lines for customer checks for Entity wise. b) Account for cash receipts and bank transfer entries for entities. c) If an invoice number is not provided on the check and transaction details, I will collaborate with the AR team to obtain the necessary information. d) For any transactions Non-AR and Non-AP transactions, I will consult with the business owner to gather the details and subsequently record them in D365. e) For all entities, I will prepare the bank statements for all banks in an Excel sheet covering all 24 bank accounts. f) Once the GL team updates the GL, I will record Non-AP, Non-AR, and bank transfer entries in D365. 2. Bank Reconciliation - Total 46 Bank Accounts for All entities a) I will validate all bank statements across the bank accounts for all entities. b) Once all Non-AR, Non-AP, and bank transfer entries have been posted, I will reconcile all the bank accounts. c) Review bank reconciliations for a total of 46 bank accounts across PMA and PMB entities during the first week of every month. 3. Reports a) Prepare a daily cash report for all entities. b) Prepare a 10-day cash flow report for PMA entities on a daily basis. c) Prepare the daily collections summary report and send it via email to the AR Manager d) Prepare an accounts review report for bank GL reconciliations for all bank accounts. e) Prepare the Edge Market quarterly sales report and provide the collection report to the AR manager for SaaS collections on a quarterly basis. f) Assist with audit requests. g) Payroll/ HSA/ FSA/ Fidelity/ Payroll Tax payable payments monthly report 4. Project FiT a) Test customer receipts, including Non-AP, Non-AR, and bank transfer entries. b) Create bugs for unavailable options. c) Provide training to the Cash team on cash applications and bank reconciliations.
