AR Systems Analyst

Redemption Church•San Jose, CA

About The Position

The AR Systems Analyst owns the end -to -end flow of donor revenue—from weekly cash and check counts to online gifts processed in Pushpay—into our Salesforce CRM and Sage Intacct General Ledger. Blending accounts -receivable fundamentals with data -management savvy, you will ensure that every contribution is captured accurately, reconciled promptly, and reported clearly for multiple legal entities. Success in this role hinges on meticulous attention to detail,strong internal -control instincts, and a passion for leveraging systems to support ministry impact.

Requirements

Associate degree in Accounting, Finance, or related field (Bachelor’s preferred).
1+ year handling accounts receivable or contribution processing, including data entry in Salesforce (NPSP/Nonprofit Cloud) and Pushpay (or similar).
Exposure to Sage Intacct or another cloud GL system; understanding of multi -entity GL coding.
Working knowledge of Salesforce reports, dashboards, and data -loading tools.
Basic navigation, import/export, and report -running skills in Sage Intacct.
Intermediate Excel/Google Sheets (v -lookups, pivot tables).
Comfort manipulating CSV files and large data sets.
Impeccable attention to detail and strong sense of internal control.
Clear written and verbal communication; able to translate technical issues for non -technical staff.
Alignment with the mission and values of Redemption Church; treats donor data and funds with discretion and respect.

Nice To Haves

Salesforce Administrator (ADM -201) or NPSP/Nonprofit Cloud certification.
Prior hands -on experience posting transactions or running financial reports in Sage Intacct.
Familiarity with nonprofit revenue -recognition rules (ASC 958).

Responsibilities

Receive, open, and count weekly cash and check offerings under dual control.
Prepare batched deposit slips and post gifts by entity, fund, and campaign in Salesforce/Pushpay “Offline Gifts.”
Reconcile physical deposits to Salesforce, Sage Intacct, and bank reports; research and resolve discrepancies.
Maintain secure custody of undeposited funds following segregation -of -duties policies.
Import, validate, and post daily Pushpay transactions into Salesforce via flows or data -loader tools.
Map new funds, campaigns, and giving types, ensuring correct AR/GL coding for each entity in Sage Intacct.
Monitor automated sync jobs and troubleshoot errors quickly.
Prepare and upload journal entries or import files to record donor revenue in Sage Intacct.Maintain dimension mappings (entity, location, department, project, class) to ensure accurate financial reporting.
Assist the Accounting team with month -end close tasks, account reconciliations, and audit schedules derived from Sage Intacct.
Run weekly audits to identify duplicates, incomplete records, or out -of -policy values; merge or correct as needed. Enforce naming conventions, field -level security, and picklist standards; maintain the Finance Data Dictionary.
Reconcile Pushpay settlements, cash/check deposits, Salesforce data, and Sage Intacct GL against bank activity for multiple entities.
Produce recurring dashboards (giving trends, pledge progress) and deliver month -end donor -revenue summaries to Accounting.
Partner with Salesforce Admins and Accounting to refine automation, validation rules, and page layouts that streamline AR tasks.
Train ministry staff on proper gift entry and basic reporting; field donor -data questions.
Safeguard donor information and physical funds in alignment with PCI -DSS, IRS regulations, and internal policies. Assist with year -end giving statements and external audit requests