HomeHome Product Discus... Product Discus...SmithCartSmithCartHow to reconcile credit card transactions with Authorize.Net and merchant bankHow to reconcile credit card transactions with Authorize.Net and merchant bank
Previous
 
Next
New Post
7/13/2016 3:49 PM
 
Follow these steps to reconcile credit card payments submitted from your Smith module and processed by Authorize.net:
  1. Smith records transaction information by date and time (A day begins at 12:00am and ends 11:59pm)
  2. Authorize.net is only a payment gateway. It batches payments and processes through funds to your merchant bank
  3. Submit Date in Authorize.net = Create Date in Smith Report
  4. Settlement Date in Authorize.net = Date pushed to your merchant bank

Authorize.net Set Up:
  1. Set the Transaction Cut off time to 11:59pm (your local time)
  2. Once you set your cut off time, the difference between your Submit Date & Settlement Date should be 12 hours.

Steps to Reconcile:
  1. In SmithCart, run the report titled "Payment History by Date". Enter the date range for your reconciliation. Export to CSV and convert to an excel file.
  2. In Authorize.net, click on the tab for Reports. The only option available is to report by Settlement Date, which is one day at a time. Run this report for each day.
  3. Reconcile the daily Authorize.net Settlement report against the SmithCart payment history report. Although the Authorize.net report will only report by day, it is a better practice to reconcile across a period of time. Compare the daily Authorize.net reports against a report over a period of time in SmithCart (ex: 2 weeks). This is because of the potential difference between Submit Date and when a payment actually settles (Settlement Date).
  4. Reconcile Authorize.net with your Merchant Bank.
See the following link for information on how to sync Authorize.Net and QuickBooks:

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
Yesterday @ 11:07 PM
 
This reconciliation workflow with Authorize.Net is a good example of how transaction timing (submit vs. settlement date) affects ledger accuracy. For businesses handling large payment volumes, especially across multiple gateways or acquirers, automating this process can drastically reduce manual mismatches.

At Optimus Fintech, we’ve built automated payment reconciliation software that integrates with gateways like Authorize.Net, Stripe, and merchant banks to sync settlements in real time and identify discrepancies instantly. This ensures that payment batches, refunds, and chargebacks are accurately matched to ledger records without manual review.

The best part is that it supports custom reconciliation logic—so even when settlement timing or fee deductions vary, the system still provides a clean, automated match.
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartHow to reconcile credit card transactions with Authorize.Net and merchant bankHow to reconcile credit card transactions with Authorize.Net and merchant bank