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?
