Start using this Workflow
Payment Reconciliation Checklist
Transaction Data Collection
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.
Data Validation and Matching
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.
Discrepancy Resolution
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.
Financial Reporting
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.
