Skip to main content

Facility Financial Reports: Transaction Line Item Report

See every rent, coverage, fee, and credit line item posted for a single facility within a chosen date range, including the amount charged and the amount paid for each.

Overview

The Transaction Line Item report shows a facility’s billing activity broken down to the smallest level, one row per line item, where a line item is a single charge or credit, such as one month of rent, one coverage charge, or one fee.

Because a single transaction, such as a Renewal or a Move-In, usually creates several line items at once, the report shows what each transaction is made of rather than only its total. For every line item, the report lists the transaction, the tenant, the unit, the billing period, the amount charged, and the amount paid so far.

Managers use the report to see exactly what was charged and paid at one facility in a chosen date range, line by line.

Prerequisites

Access to this report requires:

  • The Read Transaction Line Item (Report) facility-level permission. 

Key Terms and Calculation Basics

A few terms are used across the whole report and are defined here once:

  • Line item - A single billing line. One line item is one charge or one credit, such as a monthly unit rent. The report shows one line item per row.

  • Transaction - A single action in the QuikStor, such as a Move-in or a Renewal. One transaction can create several line items at once, and it can cover more than one unit when a tenant holds several leases. Line items in one transaction share the same Transaction Number. They usually belong to the same tenant, but a retail sale to a walk-in customer (an Anonymous Sale) has no tenant.

  • Billing period - The span of time a line item covers, shown by the Period From and Period To columns. A line item can cover a period in the future, so the period dates can be later than the date the line item was posted.

Report Scope

This article covers the Transaction Line Item report at the Facility level. The report is available only at the Facility level. There is no corporate-level version.

Report Layout

The report page has a set of details above the results and two actions in the top-right corner.

Report Parameters

These details appear at the top of the report and describe what was run.

  • Report name and category - The title Transaction Line Item, shown next to a green Financial badge for the Financial Reports group.

  • Facility scope - The single facility the report covers. The facility is set in the Facility Switcher at the top of QuikStor, before the report runs.

  • Date range - The Generated From and To dates that set the period the report covers.

  • Report generated - The exact date and time the report was run.

The top of the Transaction Line Item report, showing the report name and Financial badge, the facility, the date range, and the time the report was generated.

ℹ️ Info: The report shows data as of the report generation time, not live data. Running the report again later can show different amounts if new charges or payments have been posted in the meantime.

Filter and Export

The top-right corner of the report has a filter control and an export control.

  • Filter - Opens a panel on the right side of the report. The panel contains the date range only; It does not offer other filters.

  • Export as - Downloads the report as a CSV, Excel, or PDF file.

The filter control opens a date-range panel for the report, and the Export as menu offers CSV, Excel, and PDF.

💡 Tip: The date range can be changed from inside the report. The filter panel in the top-right corner holds the date range controls, so there is no need to leave the report to view a different period.

ℹ️ Info: A No Results Found message most likely means there was no billing activity at this facility in the chosen date range. A different date range may return results.

Sorting and Totals

The results have a default order and a totals row at the bottom.

  • Default order - The results are ordered by date and time, from newest to oldest. All line items from one transaction share the same posted date and time, so they appear together.

  • Totals row - A row at the bottom of the report sums two columns: the total Line Item Amount and the total Amount Paid for the results shown. Calculated as: the sum of each column across all rows in the report.

The totals row at the bottom of the report, which sums the Line Item Amount and Amount Paid columns.

Main Table Content

Each row in the report is one line item. The columns are:

  • Line Item ID - A unique reference code for a single line item in that row. Each line item has its own code, even when several line items share one transaction.

  • Date & Time - The date and time the line item was posted.

  • Transaction Number - The code for a transaction that created the line item. Line items created together share the same Transaction Number.

  • Transaction Type - The kind of transaction that created the line item. The transaction types are grouped as follows:

    • Payments received (Payment, Auto Payment);

    • Reversed or failed payments (Payment Reversal, Payment NSF, Credit Card Chargeback);

    • Lease events (Move-In, Move-Out, Renewal, Migration);

    • Unit transfers (Transfer, Transfer Credit, Transfer Out);

    • Charges (One Off Charge, Delinquency, Anonymous Sale);

    • Credits and adjustments (General Credit, General Credit Reversal, Outstanding Balance Write Off).

  • Transaction User - Who or what created the transaction. This is a staff member’s name for a manual action, or System for an automatic action such as a renewal.

  • Tenant - The name of the tenant or company on the line item, which links to the tenant’s profile. This column is blank for an Anonymous Sale, a retail sale that has no tenant.

  • Unit - The unit the line item applies to. The Unit Number links to the unit’s profile. This column is blank for an Anonymous Sale, which is not tied to a unit.

  • Line Item Type - The category of the charge or credit - for example, Rent, Coverage (the tenant’s protection plan), Recurring Fee, or Delinquency Fee.

  • Line Item Name - A short description of the line item. For rent, it names the unit and the period the rent covers. For a coverage line, it shows the protection amount of the plan. For a fee, it shows the fee name.

  • Period From - The first day of the billing period the line item covers.

  • Fee Category - A category shown for fee line items that groups the fee by what it is for.

  • Period To - The last day of the billing period the line item covers.

  • Line Item Amount - The full amount charged for the line item.

  • Amount Paid - The amount paid toward the line item so far. This can be the full amount, part of the amount, or zero if nothing has been paid yet.

The Main report table.

ℹ️ Info: Some actions do not appear as their own rows in this report. A Waiver and a Move-In or Move-Out that was later reversed are left out so their amounts are not counted twice. The amounts from these actions still show on the line items of the related transaction.

⚠️ Warning: Line Item Amount is the amount charged for a line item. Amount Paid is the amount applied to that line item so far. A line item can be charged but have nothing applied yet, so the Line Item Amount total is not the same as the Amount Paid total.

FAQ

Common questions about the Transaction Line Item report:

  1. Why does the report show line items for months in the future?

    A line item covers a billing period, and some line items are posted for periods in the future. The Period From and Period To columns show the exact period each line item covers.

  2. What is a General Credit line?

    A General Credit is an amount a facility staff member adds by hand to lower what a tenant owes. For example, a staff member might add a goodwill credit after a problem with the unit. It lowers the tenant’s balance.

  3. What does a blank Fee Category mean?

    The Fee Category column shows a category only for some line items. When it is blank, the line item has no fee category to show. A blank value is normal and does not mean data is missing.

  4. Why is the Amount Paid smaller than the Line Item Amount on some rows?

    Amount Paid shows how much has been paid toward one line item. A value smaller than the Line Item Amount means the line item is only partly paid. A value of zero means nothing has been paid toward it yet.

  5. Can the facility be changed from inside the report?

    No. The facility is set in the Facility Switcher at the top of QuikStor before the report runs. A different facility is selected there, and the report is run again.

Related Articles

Did this answer your question?