cancel
Showing results for 
Search instead for 
Did you mean: 

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?

peapod44
Member
3 REPLIES 3

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

RichardH
Administrator Administrator
Administrator

Are there any updates on this?

 

We are running into the same thing: Trying to reconcile all the fees charged for the e-check service, and there does not seem to be a way to grab the data via an API.

 

Authorize.net: Any plans here? 

We're dealing with one thing: we're trying to offset all the costs of online search services, and there doesn't seem to be a way to recover data using the API.

Tinkers’ Construct

MegaBox HD

johnpeter456
Member