Workflow Templates: Payment Reconciliation Checklist

Gather all transaction data from the e-commerce platform.

Ensure all payment gateways' transaction logs are accessible.

Collect bank statements for the reconciliation period.

Retrieve refund and chargeback records.

Compile a list of all pending transactions.

Verify the accuracy of transaction dates and amounts.

Match each transaction with the corresponding bank statement entry.

Check for any discrepancies between the platform and bank records.

Validate refund and chargeback entries against bank records.

Ensure all pending transactions are accounted for.

Investigate unmatched transactions for potential errors.

Contact payment gateways for clarification on discrepancies.

Adjust the accounting records to reflect accurate data.

Document reasons for any unresolved discrepancies.

Update internal systems to prevent future discrepancies.

Prepare a summary report of reconciled transactions.

Highlight any discrepancies and their resolutions.

Generate a detailed report for refunds and chargebacks.

Ensure all reports comply with internal audit requirements.

Submit final reports to the finance department for review.

Payment Reconciliation Checklist