Transaction Log Report

The Transaction Log provides a detailed list of all invoice line item transactions within the selected date range. It supplements the General Ledger Detail report and associates tenants'/customers' invoices with future transactions (payments, credits, write-offs, etc.) affecting those invoices.

Due to the volume of data included in the report, this report is only available in Excel or CSV format. This report is only available in Facility Reports.

Facility Number: The facility's unique internal identifier. This value is set in the "Store Number" field in the Facility Info section of Corporate Settings.

Facility Name: The facility's name. This value is set in the "Name" field in the Facility Info section of Corporate Settings.

Tenant Name: The first and last name of the person occupying the unit. This field will be blank if the transaction was a retail or miscellaneous transaction not associated with a tenant.

Unit Name: The specific unit number involved in the transaction.  This field will be blank if the transaction was a retail or miscellaneous transaction not associated with a unit.

ID: The internal Edge transaction identification number.

Transaction Type: The category of any financial event processed in your account, including the following

  • approved refund
  • assessment    the creation of an invoice or the billing of an item to a customer
  • assessment termination    the financial transactions associated with a move-out
  • assessment termination reversal    the financial transactions associated with a move-out that was reversed (undo move-out)
  • credit
  • credit reversal
  • denied refund
  • discount assessment
  • discount resolution
  • discount resolution reversal
  • imported assessment    an assessment during the initial software implementation
  • imported payment    a payment transaction during the initial software implementation
  • imported payment reversal    a payment reversal during the initial software implementation
  • payment
  • payment reversal
  • transfer credit
  • void assessment
  • void discount assessment
  • void write-off assessment    the reversal of a bad debt write-off transaction
  • write-off assessment    the writing-off of bad debt

Created At: The date and time the transaction was processed.

Amount: The value of the transaction. This field will be blank if the transaction was an assessment termination, credit, credit reversal, discount assessment, discount resolution, or discount resolution reversal.

Account Code: The optional accounting identifier for assessment, imported assessment, imported payment reversal, payment, payment reversal, and transfer credit transactions based on the designations you set in the Account Codes section of Edge. If you have not designated account codes in the Account Codes section, this column will match the Internal Account Code column. This field will be blank if the transaction was an assessment termination, credit, credit reversal, discount assessment, discount resolution, or discount resolution reversal.

Internal Account Code: The Edge accounting identifier for assessment, imported assessment, imported payment reversal, payment, payment reversal, and transfer credit transactions. This field will be blank if the transaction was an assessment termination, credit, credit reversal. discount assessment, discount resolution, or discount resolution reversal.

Effective On: The date the transaction applies to the tenant/customer.

Service Start Date: The beginning date of the recurring item's billing period. This field is only populated for assessment and imported assessment transaction types.

Service End Date: The ending date of the recurring item's billing period. This field is only populated for assessment and imported assessment transaction types.


This section of columns details the original assessment/invoice associated with the transaction listed in the Transaction Type column. It will be blank for all assessment and imported assessment line items. 

Assessment Amount: The value of the original invoice line item associated with the transaction listed in the Transaction Type column.  

Assessment Account Code: The optional income, tax, or security deposit accounting identifier associated with the original invoice based on the designations you set in the Account Codes section of Edge. If you have not designated account codes in the Account Codes section, this column will match the Internal Account Code column.

Internal Assessment Account Code: The Edge income, tax, or security deposit accounting identifier associated with the original invoice.

Assessment Effective On: The date the assessment/invoice applies to the tenant/customer.

Assessment Service Start Date: The beginning date of the recurring item's billing period. 

Assessment Service End Date: The ending date of the recurring item's billing period.

Previously Paid Amount: The value of any previous payment. This field is only populated for payment and transfer credit transactions. It indicates a partial payment was previously made toward the original assessment.

Reversal Effective On: The date a payment was voided, refunded, or otherwise reversed. This field is only populated for payment reversal and imported payment reversal transactions.

Discount Amount: The value of a promotion or discount applied to an invoiced item.

Assessment Resolved On: The date the original assessment was fully paid. This field is only populated for discount resolution transactions.

Assessment Unresolved On: Only populated when an assessment with a discount is voided, this is the date the assessment was voided. This field is only populated for discount resolution reversal transactions.

Move Out Date: The date a unit was vacated.

Retained Amount: The prorated income recognized when a tenant moves out before their billing period's end date.

Refund Account Code: The accounting identifier associated with an approved refund transaction.


Pending Refund Account Code: This column will be blank.

Import Effective On: The date the original list of units and tenants was imported into Edge during the facility's software implementation. This column will only be populated if the report date range includes the import/implementation date. 
 

Interpreting the Data

Below is a Transaction Log for a single unit. It includes the transactions from the last 3 months of the rental. The unit was rented for $349.00/month. The renter had a 10% ($34.90) discount applied to his monthly rent and was charged 6.6% ($20.81) tax on the rental. The tenant moved out on 08/20/2025.

The first three line items indicate a payment of $314.10 + $20.81 was recorded to the Credit Card - Visa asset (account code 1020) on 6/1/25. The original assessment/invoice was for $349.00 in rent (account code 4000) + $20.81 in tax (account code 2010) for the 6/1/25-6/30/25 rental service period. There was a $34.90 discount applied to rent (account code 4000) on 6/1/25 as well.

The next three line items indicate a new service period was billed to the customer and is due on 7/1/25. On 6/16/25, $349.00 in rent + $20.81 in tax - $34.90 discount for the 7/1/25-7/31/25 service period was billed.

The next twelve line items repeat the pattern of the recurring payment for July and August, and recurring billing for August and September.

The last four line items show the tenant moved out on 8/20/25. The recurring rent, tax, and discount billing was stopped effective 8/20/25.

Still have questions?
Don't be afraid to ask us. We're here to help you.
Powered by Zendesk