Responsibilities:
• Conducting daily manual reconciliation between cookie orders, PayPal Settlement Reports, Bancorp FBO, and ACH Amounts.
• Reviewing confirmations and acknowledgments to ensure that the clearing bank received and successfully processed funding files.
• Receiving data from PayPal/Braintree and Venmo, as well as GSUSA API from FDGS Database, and transforming it into summary-level reconciliation reporting.
• Reviewing Submissions (Sales), Funding, IC, and all appropriate balancing points prior to converting cash transfer data into Cash In / Cash Out format.
• Reviewing and reconciling Cash In / Cash Out to ensure all incoming and outgoing cash items are balanced from a reporting perspective.
• Reconciling pending funding inventory to release for Friday funding.
• Reconciling daily Chargeback and ACH Reject Activity and completing a monthly True Up to the Fiserv Government Operating Account to align with GSUSA.
• Confirming and reconciling all timely and accurate incoming and outgoing cash postings.
• Reconciling all available funds in the FBO by fiduciary/operating category.
• Positioning funds in the account in real-time to ensure sufficient liquidity.
• Performing trending and analysis on the account activity to ensure appropriateness.
• Calculating and upstreaming revenue to Corporate Treasury on a standardized basis.
• Monitoring, troubleshooting, and optimizing to ensure proper reconciliations.
• Collaborating with internal and external stakeholders to ensure adherence to regulatory and compliance requirements.