select * from jccworks.dbo.tbl_positionregion

select * from jccworks.dbo.tbl_PositionCategory order by positioncategoryname

        Select
            case
                when
                    salaryrange like '%Under%'
                    or salaryrange like '%over%'
                then
                    replace(replace(salaryrange,'Under ','Under $'),'Over ','Over $')
                when
                    len(isnull(salaryrange,''))>0
                then
                    '$'+replace(salaryrange,'- ','- $')
            end as salaryrange,
            (
                select top 1
                    PositionCategoryID
                from
                    jccworks.dbo.tbl_PositionDesired
                where
                    positionid=p.positionid
                order by
                    case
                        when PositionCategoryID='3E73' then 1 else 0
                    end desc
            ) as PositionCategoryID,
            convert(varchar,dateentered,101) as dateentered,
            p.*,
            replace(j.jccname,'Not-Yet-Affiliated','') as jccname,
            ja.address,
            ja.address2,
            ja.city,
            ja.state,
            ja.zip,
            m.firstname,
            m.lastname,
            m.email,
            m.jccid
        from
            jccworks.dbo.tbl_positions p
        left join
            jcca.dbo.tbl_jcc j on
            p.jccid=j.jccid
        left join
            jcca.dbo.tbl_jccaddress ja on 
            j.jccid=ja.jccid
        left join
            jcca.dbo.vw_jccmasterfile3 m on
            p.masterid=m.masterid
        where
            p.positionid='782B2873'
    

Location and Job Title:

Bookkeeper
Barshop JCC of San Antonio
12500 NW Military Hwy.
Ste. 275
San Antonio, TX 78231

Principal Responsibilities:

We are seeking an organized and detail-oriented Accounts Payable/Receivable Specialist to manage core financial transactions. You will play a vital role in the financial health of our organization by ensuring incoming revenue is collected and vendor payments are processed accurately and on time. This position requires a strong grasp of accounting principles and excellent communication skills.

The position will also communicate directly with staff members and vendors to answer questions and inquiries including statement balances, and budgetary questions. This position must maintain a high level of confidentiality and attention to detail.

Key Competencies:

• Strong work ethic
• Teamwork
• Detail-oriented
• Strong computer skills
• Advanced knowledge of key accounting competencies

Key Responsibilities:

Accounts Payable (AP - Money Going Out)

• Review, verify, and process vendor invoices for accuracy and proper authorization
• Match purchase orders, invoices, and receiving documentation
• Enter invoices into the accounting system in a timely manner
• Prepare and process payment runs (checks, ACH, wire transfers)
• Maintain vendor records and resolve discrepancies or billing issues
• Monitor accounts to ensure payments are up to date
• Respond to vendor inquiries and maintain positive relationships
• Reconcile vendor statements and investigate outstanding balances
• Ensure proper coding of expenses to the general ledger, programs, and funding sources (including restricted and unrestricted funds)
• Reconcile credit card statements

Accounts Receivable (AR - Money Coming In)

• Process and record daily payments (cash, checks, credit cards, ACH) into the accounting system.
• Monitor aging accounts, notify departments of insufficient payments

General Accounting & Reporting

• Assist with month-end and year-end closing processes.
• Provide necessary documentation for internal and external audits.

• Maintain organized documentation for audit and grant compliance purposes
• Support preparation of internal financial reports for leadership and program managers
• Assist with other accounting-related duties
• Ensure adherence to company policies and accounting procedures
• Maintain confidentiality of financial and employee data
• Support internal controls to minimize financial risk
• Attend JCC meetings and programs as required.
• Participate in JCC large scale events as required.
• Perform special projects and other duties as required or directed.

Minimum Qualifications:

Qualifications:

• BS degree in Finance, Accounting or Business Administration preferred. Experience in this field will be considered in lieu of a degree.
• Proficiency in all MS Office Suite operations and competency in other computer software (e.g. MS Great Plains preferred).
• Knowledge of accounting and financial reporting competencies.
• Ability to demonstrate excellent organization and time management skills.
• High degree of accuracy and attention to detail.
• Customer service orientation.
• Effective communication and negotiation skills.
• Ability to maintain the confidentiality required for this role.

• Exceptional problem-solving abilities, strong vendor/client relationship management
• Ability to multitask, organize, and prioritize tasks and projects.

Physical Requirements and Work Environment:

• Regularly required to use a computer, printer and telephone
• Regularly required to work in an indoor environment
• Regularly required to talk and hear
• Regularly required to sit for long periods of time
• Regularly required to stand and walk
• Occasionally required to climb a step stool
• Occasionally required to lift and/or move up to 15 lbs.

Salary:

$35,000 - $45,000

Agency Information:

The Barshop Jewish Community Center is an Equal Opportunity Employer and is committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and employees without regard to race, color, religion or belief, national, social, or ethnic origin, sex (including pregnancy), age, disability, sexual orientation, gender identity and expression, marital status, veteran status, genetic information, family or parental status, or any other status by applicable federal, state and local laws.

The JCC offers a comprehensive benefits package including generous time off, paid holidays, health, dental and vision insurance, 401(k) with employer contributions, FSA/HSA options, life insurance, long term disability, complimentary membership to the Jewish Community Center with discounts on programs including preschool, summer camp, and wellbeing programming.