Purpose:The Accounting Specialist is responsible for managing and reconciling all general ledger accounts, auditing expense and accounts receivable postings. Preparing financial reports and utilizing intermediate Excel skills to analyze large quantities of data to produce spreadsheets for journal entries and other reporting purposes.This is done across four companies comprising of 26 departments. The position reports to the Director of Accounting and Finance, adheres to all policies, procedures, and standards of protocol of the Mary Lee Foundation and applicable outside agencies.

Primary Responsibilities:

• Monthly bank account reconciliations for 17 bank accounts in QuickBooks
• Post invoices, payments and reconcile A/R accounts in QuickBooks
• Prepare monthly rent rolls in Excel
• Reconcile general ledger accounts on a monthly and or annual basis utilizing Excel when necessary (i.e. asset, prepaid accounts, payroll related accounts, notes payable, and liabilities, etc.)
• Prepare biweekly payroll data in Excel, enter journal entry into QuickBooks & reconcile
• Export data monthly from QuickBooks to Excel and analyze intercompany receivables and post related journal entries
• Prepare monthly and or annual spreadsheets to allocate expenses across 26 departments
• Review general ledger for expenses to capitalize and depreciate
• Maintain depreciation schedule in Excel, update for acquisitions and disposals, post entries in QuickBooks
• Gather information and prepare Excel spreadsheets for quarterly grants
• As part of monthly internal audits: check figures, postings and documents for correct entry, mathematical accuracy, and proper codes and communicate corrections effectively to appropriate staff
• Prepare annual vendor, payroll, and paid leave accruals in Excel
• Participate in and gather information for year-end audits
• Prepare Excel spreadsheets for annual cost report and enter data in online report
• Ensure accounting software is up to date and trouble shoot issues as they arise
• Cross train with other bookkeeping staff and fill in when necessary
• Other duties and special projects as assigned

Knowledge, Skills and Abilities:

• Must have intermediate Excel skills including pivot tables, Vlookup, SUMIF, COUNTIF, conditional formatting, logical functions, etc.
• Must be proficient with QuickBooks or similar accounting software
• Must have knowledge of generally accepted accounting principals
• Must be proficient with Microsoft Office applications
• Strong organizational skills, ability to prioritize, and a high attention to detail
• Strong interpersonal, written, and verbal communication skills
• Demonstrated ability to maintain a high level of confidentiality

Qualifications:

• High School Diploma or equivalent; Bachelor's in accounting/business is preferred
• Minimum two years of relevant experience in a similar bookkeeping or accounting role
• Must have no bars to employment pursuant to Health & Safety Code §250.006
• Must have no bars to employment pursuant to Texas Administrative Code, Title 40, Part 1, Chapter 3, §3.201 Texas Health and Safety Code
• Name must not appear on either the Texas or Federal Office of Inspector General’s Exclusions List
• Must be physically able to perform the duties of the position, including, but not limited to; lifting/carrying at least 50 lbs. (depending on assignment requirements), climbing stairs, bending, stooping, and driving.