Reconciliation helps you to spot potential issues in the payment-handling system. Veezi reports, along with credit card and bank statements, can help you verify that payments have been processed successfully and the correct funds have been deposited in your accounts.
Important! Most payment processors hold electronic transaction information for 10 or fewer days, so if you don't reconcile promptly, you run the risk of irreversible data and financial loss. We recommend you reconcile daily.
Note: For PA-DSS compliance, Veezi doesn't keep full credit card numbers on file after the initial authorization. Therefore, you can't use Veezi data to reprocess transactions.
Before you begin
When you reconcile financial activity, you're looking for major or ongoing discrepancies rather than confirming an exact match between daily totals in Veezi and daily totals in your various financial statements.
The money going into your bank account for a particular day will rarely match Veezi's total electronic sales value for a day. One key reason for this variance is that Veezi reports cover the period between when you open and close the business day, and your payment processor likely has a different cycle, such as midnight to midnight. Your payment processor might also be in a different time zone.
Important! While discrepancies in totals will always exist, they should amount to only a small fraction of a day's sales. Keep in mind that small day-to-day discrepancies can occur when your bank clearing time doesn't match your Veezi business day. You might see better alignment when you report on and reconcile a larger period of time.
To confirm the payment-handling system is working correctly, reconcile by doing any of the following checks:
- Compare individual transactions recorded in Veezi with those recorded by your payment processor.
- Monitor the difference between the running totals of card sales in Veezi and deposits into your bank account from your payment processor.
Note: Be sure the payment processor numbers you're reconciling with Veezi are gross totals and don't include the deduction of any processing fees.
Daily reconciliation
A full reconciliation includes both an assessment of individual transactions and a comparison of daily totals.
Reconcile Veezi transactions with payment processor transactions
- Generate a Veezi report of sales for the day.
- From your payment processor portal, extract transaction data for the same day, plus a day before and a day after, as needed.
- Compare the two reports, line by line, identifying matching transactions.
Tip: Various software programs can match card-sales data from Veezi to data from your payment processor. Alternatively, you can reconcile manually from printed reports or by importing data into a spreadsheet.
Reconcile payment processor daily totals with your bank statement
Compare your bank deposit amounts with the statements from your payment processor. You don't need any Veezi data for this step.
Reconciliation reports
A number of Veezi reports provide detailed transaction data that you can use for reconciliation:
- Daily Closing. Compare data in this report to the daily totals reported by your payment processor.
- Fandango Ticketing Reconciliation. Compare data in this report to the daily totals reported by Fandango.
- Marketing. Compare data in this report to the totals reported by your payment processor. Use this report to analyze online transactions.
- Operations. Compare data in this report to the totals reported by your payment processor. Use this report to analyze POS transactions.
- Posting Journal. Compare data in this report to the totals reported by your payment processor. This report is helpful if you want to compare data for a particular date range instead of just for one day.
Use the following reports tools to gather more information about any discrepancies you identify during reconciliation.
Learn more about Veezi reports.
Comments
0 comments