Reply
Highlighted
Member
Posts: 1
Registered: ‎05-02-2016

how can we export authorize.net fees and ach payments from the echeck billing statement?

We are testing to using Authorize.net for ACH transactions.  We have used Auth.net as a gateway for credits cards for years.  However, with credit cards, we can export to CSV the merchant processor deposits and fees to an excel compatible format for accounting monthly reconciliation.  Now that Authorize.net is our "bank" for ach transactions, we need to export to CSV the billing charges, ACH payments, and billing transfer figures from the echeck billing statement each month to reconcile to our databases.  Customer Service has told us this cannot be done.  They have suggested we copy and paste the billing statement into Excel and reformat Excel so that it will sum the various charges and credits.  We can do this by converting text to columns for negative numbers, but have not have not been able to sum positive numbers from the billing statement in excel.  Any ideas for our accountant to use or to automate?

Highlighted
Posts: 2,765
Topics: 57
Kudos: 247
Blog Posts: 67
Registered: ‎12-05-2011

Re: how can we export authorize.net fees and ach payments from the echeck billing statement?

Hello @peapod44

We currently don't offer the kind of reporting you are looking for outside of our online statement.

You are welcome to post this as a new feature using our Ideas forum. This will allow others to vote on and make suggestions to improve the request.

Richard