Skip to main content

Corporate Financial Reports: Account Credit Activity Report

See every account credit applied across your facilities in a chosen period, with the tenant, amount, reason, and who applied it.

Overview

The Account Credit Activity report lists every account credit applied to a lease across selected facilities during a chosen date range. Each row is one credit, and it shows a tenant, unit, amount, reason, and an employee who applied the credit.

Managers use the report to review how account credits are being given and to spot patterns, such as repeated credits on the same lease.

Prerequisites

Viewing the Account Credit Activity report requires the following permission:

  • The Read Account Credit Activity (Report) facility-level permission.

Key Terms and Calculation Basics

Several columns in this report read a value at one of two points in time. Knowing which point a column uses prevents reading two columns as the same figure.

  • At the time of credit – the state of the lease at the exact moment the credit was applied. Account Balance at Time of Credit and Auto-Pay Before both use this point.

  • As of when the report is run – the current state, read at the moment the report is generated. Current Account Balance and Auto-Pay After both use this point.

Worked example: a tenant owes $34.00 when a credit is applied, and pays nothing more after that. Account Balance at Time of Credit shows $34.00, and Current Account Balance also shows $34.00. If the tenant instead pays the balance after the credit, Current Account Balance shows $0.00 while Account Balance at Time of Credit still shows $34.00.

Report Scope

This article covers the Account Credit Activity report at the Corporate level. The report is available only at the Corporate level; there is no Facility level version. However, the report can still be narrowed to one facility by using the facility filter.

Report Layout

The report page has a set of parameters at the top, a Filter panel and export control, and the results tables. The parts below describe everything on the page.

Report Parameters

Four items at the top of the page describe what the run covers and how current it is.

  • Report name and category – the title Account Credit Activity at the top of the page, next to the green Financial badge.

  • Facility scope – the facilities the run covers, listed under the title. A run can cover one or more facility groups, one or more individual facilities, or a mix of both.

  • Date range – the period the credits are drawn from, shown as Generated From and To dates.

  • Report generated timestamp – the date and time the report was run, shown as Report Generated, which shows how current the figures are.

    The top of the report shows the report name with the Financial badge, the facilities in scope, the Generated From and To dates, and the Report Generated time.

ℹ️ Info: A Corporate run shows one section per facility on the same page, in order. If a facility had no credit applied during the selected period, then that facility's section still appears, but it shows a No Credits Applied message ("No credits applied during this period.") in place of a table.

Filter and Export

Two controls sit at the top of the report page: one to change the period or facilities, and one to download the results.

  • Filter panel – a panel in the top-right corner reopens the same date range and facility scope options used to generate the report. The period or the facilities can be changed there and the report re-run without leaving the page.

  • Export as – downloads the report as CSV, Excel, or PDF. No other export formats are offered.

    The Filter panel reopens the date range and facility scope, and Export as downloads the report as CSV, Excel, or PDF.

Main Table Content

Each facility section with credits shows one table, and every table uses the same columns. Each column below is described on its own.

  • Tenant Name – the tenant or company on the lease the credit was applied to. Shown as a link that leads to the tenant profile.

  • Unit – the unit tied to the lease. Shown as a link that leads to the tenant profile.

  • Date Applied – the date the credit was applied to the account.

  • Credit Amount – the dollar amount of the credit that was applied.

  • Reason – the reason entered when the credit was applied. The wording varies because it is typed in by hand.

  • Applied By – the full name of the employee who applied the credit.

  • Auto-Pay Before – whether the lease had an active AutoPay payment method on file immediately before the credit was applied.

  • Auto-Pay After – whether the lease has an active AutoPay payment method on file as of when the report is run.

  • Length of Stay (Months) – how long the tenant has rented, in whole months. Calculated as: whole months from move-in through the date the report is run, with partial months rounded down.

  • Account Balance at Time of Credit – the tenant's account balance at the exact moment the credit was applied.

  • Current Account Balance – the tenant's account balance as of when the report is run.

  • Prior Credits Given - Count – how many other credits the same lease already received before this one. Calculated as: the number of other credits on the same lease in the 12 months before this credit, or since move-in if the lease is younger than 12 months.

  • Prior Credits Given - $ – the total dollar value of those prior credits. Calculated as: the sum of the credit amounts counted in Prior Credits Given - Count.

Each facility with credits shows one table with the same columns.

⚠️ Warning: Current Account Balance is read as of when the report is run, not at the time of the credit. It can differ from Account Balance at Time of Credit, so the two balance columns should not be read as the same figure.

Sorting and Totals

The report shows totals at two levels – one summary for the whole run, and one subtotal for each facility –and the tables can be re-ordered.

  • Report summary – two summary cards at the top of the report, above the facility sections, cover the whole run.

    • Credits shows the total number of credits across every facility in scope.

    • Credit Amount shows the total dollar value of those credits.

    Two cards at the top of the report show the total Credits and total Credit Amount across every facility in scope.

  • Facility subtotal – each facility's table ends with a subtotal row, labeled [Facility name] Subtotal. It shows the total Credit Amount for that facility over the period, and a Count of the credits in that facility's table.

    Each facility’s table ends with a [Facility name] Subtotal row showing that facility’s total Credit Amount and a Count of its credits.

  • Sorting – you can sort every column. A sort control appears on each column header; selecting it sorts the table by that column. Selecting the X at the end of the header row clears the sort and returns the table to its default order.

⚠️ Warning: The Credits summary at the top and the Count in each facility subtotal both count credits, not tenants. One tenant can receive more than one credit in the period, so the same tenant can appear on more than one row and be counted more than once.

💡 Tip: To bring the largest credits to the top before reviewing or exporting, sort by Credit Amount.

FAQ

These are common questions Managers ask about the Account Credit Activity report.

  1. Can the Account Credit Activity report be run at the Facility level?

    No. The report is available only at the Corporate level. A single Corporate run can be filtered down to one facility to review that facility's credits.

  2. Why does the same tenant appear on more than one row?

    The report shows one row per credit. If a lease received more than one credit during the period, then each credit is a separate row.

  3. What period does Prior Credits Given - Count look back over?

    It counts other credits on the same lease in the 12 months before the credit on that row, or since move-in if the lease is younger than 12 months.

  4. Why is Current Account Balance different from Account Balance at Time of Credit?

    The two columns read the balance at different times - one at the moment the credit was applied, the other when the report is run. A payment or a new charge after the credit changes the current balance.

Did this answer your question?