Reviewing Your Electronic Transactions
The Electronic Transaction Logs Report is where you can view a snapshot of all electronically processed payments in your system. It also shows whether payments were a success or had failed. Failed payments will also show the reason why it was not successful. This is a useful tool for your accounts receivable department to use in collecting payments, specifically for failed reasons.
In order to take advantage of this report, you will need to have a payment processor enabled and specific report permissions. Credit Card or ACH payments made using the payment processor integration will show up in the Transaction Logs, which includes payments made from within your system, through customer portals, and emailed invoice payment links.
Important
To view the Electronic Transaction Logs Report, you will need the permission ‘View Transaction Logs’, which is found under the Billing/Payables permissions.
To find the report, navigate to Reports > All Reports. Click on the Finance tab, and select Electronic Transaction Logs. Alternatively, you can search for the report using the global search bar.
You can filter the report to find transactions based on Company, Invoice, Transaction Date Range, Transaction Status (Success or Failed), and Payment Method (Credit Card or ACH).
When you click search, the table will display the following information about the processed transaction:
Invoice – The number of the invoice that the payment was applied to. The invoice column will also include the type of invoice, including regular, master, special, and cart. The invoice number is a quick link, which will open a PDF of the invoice.
Order # - If the transaction was for a special or regular invoice, then a specific order number will show up in this column. If the payment was made on a master invoice, then this column will simply show ‘Multiple’ rather than listing all of the potential orders that could be associated with the invoice. If there is a single order number listed, then it also serves as a quick link which opens a PDF of the order.
Company - When a company is associated with the transaction, the name will show up in this column. If a transaction was made for a subscription or an ecommerce order, this column may be blank. When there is a company name present, it is a quick link which will bring you to the Company’s Overview page.
Name - If a customer pays through the Client Portal, then there will be a specific contact associated with the transaction. Their name will show up under this column, and is also a quick link which will bring you to the Contact’s Overview page.
Method – The method column shows whether the processed transaction was a Credit Card or ACH payment.
Last Four Digits - The last four digits field either shows the last four digits of the credit card, or the payment account.
Amount – The total of the processed payment.
Status – The status column shows whether the attempted payment was a success, or if it failed.
Note - The note field will be blank if the transaction was processed successfully. If, however, the payment failed, then the note field will explain what caused it to fail. Some examples would be if the transaction was declined, or if the ABA code was invalid. These reasons would be listed in the note column.
Tip
All of the table column headers can be used to further sort your search results. Clicking on the column name will sort the table by that field.