Skip to main content

Facility Financial Reports: Transaction Line Item Payment Application Report

See how each payment and credit at a facility was applied to rent, coverage, and fee line items in a chosen date range.

Overview

The Transaction Line Item Payment Application report shows how payments and credits at one facility were applied to individual charges. Each row is one payment application - an amount from a payment or a credit placed on one line item, such as one month of rent or one coverage charge.

For every payment application, the report lists the charge, the amount placed on it or taken off it, the date and time, the apply method, and the amount still unpaid.

Besides payments and credits, the report also shows waivers, refunds, transfers between units, reallocations, and reversed payments.

Managers use the report to see where a tenant's payment went, how a prepayment or credit was spread over future months, and which charges are still only partly paid.

Prerequisites

Access to this report requires:

  • The Read Transaction Line-Item Payment Application permission, in the Report group of facility-level permissions.

Key Terms and Calculation Basics

The report uses a few terms throughout. Each one is defined here once:

  • Line Item - A single charge, such as one month of rent for one unit, one coverage charge, one fee, one retail item, or a security deposit.

  • Transaction - A single action in QuikStor, such as a Move-in, Renewal, Payment, or a General Credit. All rows from one transaction share the same Transaction Number.

  • Payment Application - The act of placing an amount on one line item, or taking an amount off it. The report shows one payment application per row.

  • Payment Application vs. Payment Method - A payment method is how the tenant paid: Cash, Card, ACH, or Check. A payment application is where an amount went: which charge it paid, and how much. This report shows payment applications, not payment methods.

  • Apply Method - The kind of payment application in that row, for example, a payment, a credit, a waiver, or a refund. Each value is explained in Apply Method Values below.

  • Billing Period - The span of time a line item covers, shown by Period From and Period To. A billing period can be in the future, so prepaid months appear with later dates. One-time charges, such as retail items, one-time fees, and security deposits, have no billing period.

The amount columns relate to each other as follows:

  • Amount Applied - The amount placed on the line item by this one application only.

  • Amount Paid - The total paid on the line item so far, including any amounts applied before the chosen date range.

  • Amount Unpaid - What is still owed on the line item. Calculated as: Line Item Amount minus Amount Paid.

ℹ️ Info: The report shows one row per payment application, not one row per payment or per line item. A single payment or credit that covers several charges appears as several rows, and one line item can appear on several rows when amounts are placed on it or taken off it more than once.

Apply Method Values

The Apply Method column shows one of the following values: 

  • Payment - Money received from a tenant, or from a customer in an anonymous item sale, placed on the charge.

  • General Credit - A credit that a staff member added to the tenant's account, placed on the charge.

  • Waiver - The charge was waived. No money was received, but the waived amount counts toward Amount Paid, so the charge shows no Amount Unpaid.

  • Write off - The charge was written off. No money was received, but the written-off amount counts toward Amount Paid, so the charge shows no Amount Unpaid.

  • Refund - Money returned to the tenant from a paid charge. The Amount Applied is negative.

  • Transfer - An amount moved off a charge on the old unit when a tenant transfers to a new unit. The Amount Applied is negative on the old unit. The same amount appears as Payment on charges of the new unit.

  • Reallocation - An amount moved from one charge to another, for example from a security deposit to a late fee or to rent. The Amount Applied is negative on the charge the money left and positive on the charge it paid.

  • Lease termination - A row recorded when a lease ends, for example at move-out or during a transfer. These rows appear next to Refund, Transfer, or Reallocation rows for the same line item, and the amount can be $0.00.

  • Reversal - A cancelled payment. The Amount Applied is negative, and the amount goes back into Amount Unpaid.

ℹ️ Info: A negative Amount Applied means an amount was taken off a line item, not placed on it. This happens with refunds, transfers, reallocations, and reversals. It also happens when a payment is removed from a charge and applied again, which shows as a negative row and a positive row with the same Application Date & Time.

Report Scope

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

The report always covers one facility. The Facility Switcher at the top of QuikStor sets the facility before the report runs. The report itself has no Facility Switcher.

Report Layout

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

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 Payment Application, shown next to a green Financial badge.

  • Facility scope - The single facility the report covers.

  • Date range - The Generated From and To dates that set the period the report covers. The report includes every payment application made in this period, including the start and end dates, based on Application Date & Time, even when the charge itself was posted earlier.

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

    The top of the report, with the report name, Financial badge, facility, date range, and generation time.

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

Filter and Export

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

  • Filter - Opens the Generate Report - Transaction Line Item Payment Application drawer on the right side of the report. The drawer contains one required field, From to Date, plus the Cancel and Generate Report buttons. The drawer does not have other filters.

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

    The filter drawer, where a new date range can be set without leaving the report and Export as menu.

💡 Tip: Each export format fits a different job.

  • Excel - Best for sorting, filtering, and totaling the data in a spreadsheet.

  • CSV - Best for importing into another system, such as accounting software.

  • PDF - Best for printing or sharing a fixed copy, for example, for an owner or an audit file.

Main Table Content

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

  • Line Item ID - A unique reference code for the line item in that row. The same code repeats when one line item has several payment applications.

  • Date & Time - The date and time the line item was posted. This date can be earlier than the chosen date range when an older charge receives a payment application during the range.

  • Transaction Number - The code for the 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: Move-In, Move-Out, Renewal, Transfer, Payment, General Credit, Delinquency, One Off Charge, or Migration. This column is blank for anonymous item sales.

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

  • Tenant - The name of the tenant on the line item. The name links to the tenant's profile. For an anonymous item sale, the column shows Anonymous with no link.

  • Unit - The unit the line item applies to. The Unit Number links to the unit's profile. This column is blank for anonymous item sales.

  • Line Item Type - The category of the charge: Rent, Coverage (the tenant's protection plan), Recurring Fee, One Time Fee, Delinquency Fee, Item Fee, Item (a retail item such as a box or a lock), Security Deposit, or Migration Balance (a balance carried over from a previous system).

  • Line Item Name - A short description of the charge. For rent, it names the unit and the period the rent covers. For coverage, it shows the protection amount of the plan, such as $1000 Coverage. For fees and items, it shows the fee or item name.

  • Period From - The first day of the billing period the line item covers. Blank for one-time charges.

  • Fee Category - The category of a fee line item, such as a Recurring Fee, One Time Fee, Delinquency Fee, or Item Fee. The values are grouped as Fee, Tax, or Delinquency. This column is blank for Rent, Coverage, Item, and Security Deposit line items.

  • Period To - The last day of the billing period the line item covers. Blank for one-time charges.

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

  • Amount Paid - The total paid on the line item so far, from all payment applications, including any made before the chosen date range. Waived amounts count as paid.

  • Application Date & Time - The date and time of the payment application.

  • Amount Applied - The amount this one payment application placed on the line item. A negative amount means an amount was taken off the line item.

  • Apply Method - The kind of payment application, such as Payment, General Credit, Waiver, Refund, Transfer, Reallocation, Lease Termination, Reversal, or Write off. This column does not show whether the tenant paid by cash, card, ACH, or check.

  • Amount Unpaid - The amount still owed on the line item. A value of $0.00 means the line item is fully paid. Calculated as: Line Item Amount minus Amount Paid.

    The main report table, with one row per payment application.

ℹ️ Info: Date & Time shows when the charge was posted. Application Date & Time shows when a payment or credit was placed on it. A charge posted in September and paid in October shows a September Date & Time and an October Application Date & Time.

Sorting, Column Descriptions, and Totals

The results have a default order, sortable columns, short column descriptions, and a totals row at the bottom.

  • Default order - The results are ordered by Application Date & Time, from newest to oldest. Rows from one payment or credit share the same application time, so they appear together.

  • Sorting - Every column can be sorted. Selecting a column header sorts the results by that column. Several columns can be sorted at once. A marker next to each sorted column header shows an arrow for the sort direction and a number for the order in which the columns were selected. For example, sorting by Date & Time first and Line Item ID second shows 1 next to Date & Time and 2 next to Line Item ID. The X button at the end of the header row clears all sorting and returns the results to the default order.

  • Column descriptions - Hovering over a column header shows a short description of that column. For example, Application Date & Time shows Date when payment was applied.

  • Totals row - A row at the bottom of the report sums four columns: Line Item Amount, Amount Paid, Amount Applied, and Amount Unpaid. Calculated as: the sum of each column across all rows in the report. The other columns have no total.

    The Transaction Line Item Payment Application report, showing sorted columns, the clear-sorting button, and the totals row.

⚠️ Warning: Three of the four totals can count the same charge more than once. One line item repeats on every row where an amount is placed on it or taken off it, so the Line Item Amount, Amount Paid, and Amount Unpaid totals add that line item again on each of its rows. Treat these three totals as a rough guide only. The Amount Applied total is the one dependable total, because each row’s Amount Applied belongs to that row alone.

FAQ

Common questions about the Transaction Line Item Payment Application report:

  1. What is the difference between a payment application and a payment method?

    A payment method is how the tenant paid, such as cash, card, ACH, or check. A payment application is where an amount went - which charge it paid and how much. This report shows payment applications only.

  2. Does the report show whether a tenant paid by cash, card, or ACH?

    No. Apply Method shows the kind of payment application, such as Payment, General Credit, or Waiver. It does not show the payment type.

  3. Why is Amount Applied smaller than Amount Paid on some rows?

    Amount Applied shows only the amount placed by that one payment application. Amount Paid shows everything paid on the line item so far. A smaller Amount Applied means part of the line item was paid earlier, for example, at Move-In.

  4. Why does Amount Applied show a negative amount?

    A negative amount means an amount was taken off the line item. This happens with a Refund, Transfer, Reallocation, or Reversal, or when a payment is removed from a charge and applied again.

  5. Why does the same line item appear on several rows?

    Each row is one payment application. When a line item is paid, then refunded, or moved during a transfer, each step appears as its own row with the same Line Item ID.

  6. Why does the report show charges posted before the chosen date range?

    The report lists payment applications made in a date range. When a tenant pays an older charge during the range, that charge appears with its original Date & Time and a newer Application Date & Time.

  7. How can I see where a tenant's prepayment or credit went?

    Find the tenant in the Tenant column and look at the rows with the same Transaction Number. Each row shows one month or one charge the payment or credit covered, with the Amount Applied to it. The last row often shows a partial amount and a remaining Amount Unpaid.

  8. Why is the Tenant column Anonymous on some rows?

    These rows are anonymous item sales - retail items sold to someone who is not a tenant. They have no unit and no Transaction Type.

  9. 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. After switching the facility, the report needs to be run again.

  10. Can the date range be changed after the report runs?

    Yes. The filter control in the top-right corner opens a drawer with the From to Date field. Selecting Generate Report reruns the report for the new range.

Related Articles

Did this answer your question?