Payments Reconciliation Specialist
New
F
FinalsitePayments reconciliation
100% Remote - Anywhere within the USContractMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Languages
- Clear written English
- Experience
- 2+ years
- Required Skills
- Microsoft Excel
Requirements
- Have 2+ years of hands-on experience in cash application, accounts receivable or payable, bank reconciliation, merchant services, payment processor operations, or business bookkeeping involving card sales.
- Have experience tying transaction detail to a total, such as reconciling multiple items to a deposit, statement line, or batch, and investigating differences.
- Use Excel features including XLOOKUP or VLOOKUP, SUMIFS, pivot tables, text-to-columns, and saving clean CSV files.
- Follow written procedures exactly and report when a step does not work.
- Maintain accuracy under daily deadlines and keep a log consistently.
- Write clear English notes for districts under the Lead's name.
- Chargeback, dispute, or NSF-return experience from the merchant side is a plus.
- Experience with ERP imports or exports such as Munis, Skyward, QuickBooks, or NetSuite is a plus.
- Experience with a payment processor portal or settlement statement is a plus.
- School district, municipal, or nonprofit finance experience is a plus.
Responsibilities
- Log each chargeback notice from Operations on the day it is received.
- Look up affected orders in the Web Store portal, using the chargeback notice as the source of truth.
- Reconstruct order line items with account or GL codes, payment IDs, amounts, and sales tax in the district settlement-file layout.
- Build correction files with accounting lines and sales tax formatted for the district's ERP import.
- Reconcile orders and correction-file details to the aggregated chargeback deduction on the settlement statement.
- Prepare daily files for delayed or unfunded transactions, disputes, and NSF returns for each client.
- Run the checklist and submit work to the Lead for review before delivery.
- Send reviewed files to the client's Customer Success Manager; do not contact districts directly.
- Escalate missing or duplicate SKU account codes, unlocated orders, partial chargebacks, mismatches, tax questions, and runbook gaps or failures.
- Document slow or awkward processes as input for potential automation.
View Full Description & ApplyYou'll be redirected to the employer's site
