Electronic Transaction Log
The Electronic Transaction Logs Report is where you can find records of all the electronically processed payments in your system. This report was created to help you better track whether your electronically processed payments were successful, or whether the transactions failed. In order to take advantage of this page, you will need to have a payment processor enabled. Any 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, within the customer portals, and from emailed invoice payment links.
Important
In order 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.
Tip
If you want to easily access this report in the future, you can Favorite the report by clicking on the star icon next to the report name on the Finance tab. If the report is Favorited, then it will show up under your site’s quick links as a Favorite Report.
You can filter the report to find transactions based on Company, Invoice Number, Transaction Date Range, Transaction Status (Success or Failed), Payment Method (Credit Card or ACH), and Authorization Code.
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 an ACH payment.
Last Four Digits - Depending on the payment method, this field either shows the last four digits of the credit card used, or the last four digits of the account number.
Amount – The total the processed payment was for.
Status – The status column shows whether the attempted payment was processed successfully, 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.
Authorization Code - The numeric code the processor sends back if the payment is processed successfully.
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.
There is a Summary at the bottom of the table which will total the Amount of all the displayed transactions.
Updated 10/17/2024