To reconcile your credit cards with your payment gateway, you would use the reconciliation report under REPORTS > OTHER REPORTS > RECONCILIATION REPORT. This report was designed for reconciling the total amount of credit cards sent to the gateway for a time period.
For example, $80 was sent to the gateway for order #1234567 on X date. You can then compare the reconciliation report in VBO against the transactions detail report in your authorize.net account. The reconciliation report in VBO will also show the credit card type of Visa, MC, Etc.
You can find the transaction detail report on the left side of the authorize.net home page in the reports list.
After clicking on the transaction detail report use the date dropdown to choose the settlement date you want to reconcile and click run report. Remember that if your batch is set to 11:59 pm your settlement report may be delayed a day. For example, if the business day was April 9th, your transaction detail report may list April 10th as the settled transaction date.
The transaction detail report will look like this when you run it.
After getting your transaction detail report you can get the reconciliation report out of VBO by going to REPORTS > OTHER REPORTS > and clicking LOAD REPORT on the reconciliation report.
Select the business day at the top of the report and click submit. You'll get a list of transactions and information that you can use to compare to your authorize.net transaction detail report.
