Skip to main content

Facility Financial Reports: Payments Detail Report

See exactly what each payment collected during a date range was applied to - rent, coverage, fees, delinquency, tax, other, security deposit, or items.

Overview

The Payments Detail report lists every payment a facility collected during a chosen date range and shows exactly what each one was applied to, broken out across eight charge categories such as rent, coverage, and fees. You typically run it to reconcile a day's or a month's collections, confirm that a specific tenant's payment landed where it was intended, or explain to an owner what share of collections came from rent rather than fees.

Additionally, this report shows what money was applied to, not how it was paid (cash, card, or ACH). Refunds, waivers, and write-offs are treated as outside its scope.

Prerequisites

Access to this report requires:

  • Being logged in to QuikStor at the facility whose report you want to generate.

  • The Read Payments Detail permission under the Facility tab of the Report permissions section.

Key Terms and Calculation Basics

This report is built around a set of terms and rules that apply across the whole report, not just to a single column. Some of these terms appear directly on the report; others are defined here only to explain how the report's figures are put together.

Key Terms

  • Accounting trail – The running record of every movement in the system: which account moved, in which direction, for which transaction, against which charge. This report reads only the applied-money half of that record - the half written when a payment is applied to a charge, not when the charge is first billed.

  • Transaction – One complete act of business, such as taking a payment at the counter or online and applying it to rent, coverage, and a fee in a single step.

  • Payment – One sum of money received inside a transaction. A transaction usually has one payment, but it can have more than one (for example, cash plus card), and it can have none at all if the transaction only moved existing credit around.

  • Charge line – The individual item being paid for, such as a month's rent, a month's coverage, or a single late fee. Each charge line carries the category that determines which column it lands in on this report.

  • Net amount – Money applied, minus money given back through discounts and credits on the same category. Every money column on this report is a net figure, which is why a column can be negative.

  • PTD (paid-through date) – The date a lease is paid up to. This report always shows the lease's current paid-through date as of the moment the report is run, not the paid-through date that this specific payment bought - see the Edge Cases section for what this means in practice.

Calculation Basics

Each of the eight money columns is a net total: money credited to that category, minus money debited from it. Discounts and credits are treated as debits against the category they were applied to, so they pull that column down rather than being shown separately. For example, if a $100 rent charge is settled using a $20 concession, the Rent column shows $80, not $100.

Because the report is built on the applied-money trail rather than the billing trail, a charge only appears on this report once money has actually been applied to it. For example, invoicing a tenant on the 1st puts nothing on this report; their payment on the 7th does.

A balance migrated in from a previous system (which has its own category with no column here) contributes to no column at all, and therefore not to that row's total either. Because of this, a row can exist on the report with every money column showing zero.

Formatting Rules

The following formatting rules apply consistently across the report's columns:

  • Money – Columns always show an exact, unrounded decimal amount.

  • Negative amounts – Allowed and meaningful. If a category's discounts or credits outweigh what was credited to it, that column comes out negative.

  • Date – Always a calendar date in the facility's time zone.

  • PTD – Either a calendar date or blank - never zero.

  • Unit and Tenant – Either text or blank. A blank in either column means the sale was anonymous.

Report Scope

This article covers the Facility level version of the Payments Detail report. There is no Corporate level equivalent, and the report cannot be run across more than one facility at a time - each run is scoped to a single facility.

💡 Tip: The Payments Detail report can be scheduled for recurring email delivery - daily, weekly, or monthly - and can also be marked as a favorite report for quicker access.

Report Layout

The report page includes the following report parameters and page controls.

Report Parameters

  • Report name and category – Shown as Payments Detail, tagged with a green Financial badge.

  • Facility scope – A single facility. The report always covers one facility at a time; there is no multi-facility or company-wide option.

  • Date range – The period the report covers, shown as the Generated From and To dates. Both the start and end day are included in full, read as calendar days in the facility's own time zone. The end date must fall on or after the start date, and the same date can be used for both to run the report for a single day.

  • Report Generated timestamp – The exact date and time the report was run, showing how current the data is.

Report parameters on the Facility level Payments Detail report showing report name, category, selected facility, date range, and Report Generated timestamp

Filter and Export

  • Filter – Opens the Generate Report - Payments Detail drawer containing only a From and To date field. This drawer has no facility or facility group picker, since the Facility level report is already scoped to one facility.

The Generate Report – Payments Detail drawer where you can select the date range​

  • Export as – Downloads the report as CSV, Excel, or PDF.

The Export as button on the report page displaying CSV, Excel, and PDF as download options

Main Table Content

The report has a single results table, split here into two groups: the identifying columns and the columns that show where the money went.

Identifying Columns

  • Date – The day the payment was recorded, in the facility's time zone.

  • Unit – The unit number, taken from the unit's current record at this facility. The unit number is a clickable link that opens the unit overview page in a new tab. This column is blank when the sale was anonymous.

  • Tenant – The tenant's full name as it was recorded at the time of the payment. The name is a clickable link that opens the tenant overview page in a new tab. This column is blank when the sale was anonymous.

  • PTD – The most recent paid-through date on the lease tied to this row. Calculated as: the lease's current paid-through date as of the moment the report is run, not the date this specific payment paid through to. This column is blank when there is no lease on the row, which happens when the sale was anonymous.

Identifying columns section of the Payments Detail report displaying Date, Unit, Tenant, and PTD columns

Money Columns

  • Rent – The net amount of this payment applied to rent. Calculated as: money credited to rent, minus any discounts or credits applied against rent.

  • Coverage – The net amount applied to the tenant's protection plan. Calculated as: money credited to coverage, minus any discounts or credits applied against coverage.

  • Fees – The net amount applied to plain fees, such as admin fees, lock fees, and setup fees. Calculated as: money credited to fee charge lines whose fee kind is a plain fee, minus any discounts or credits applied against those fee charge lines.

  • Delinquency – The net amount applied to delinquency-related fees, including late fees, lien fees, and lock-cut fees, along with any other fee raised by the collections process. Calculated as: money credited to fee charge lines whose fee kind is delinquency, minus any discounts or credits applied against those fee charge lines.

  • Tax – The net amount applied to tax on a fee. Calculated as: money credited to fee charge lines whose fee kind is tax, minus any discounts or credits applied against those fee charge lines. Tax always arrives on this report as its own fee line - it is never folded into the amount of the fee it was charged on.

  • Other – The net amount applied to fees that don't fall into any of the categories above. Calculated as: money credited to fee charge lines whose fee kind is none of Fees, Delinquency, or Tax, minus any discounts or credits applied against those fee charge lines.

  • Security Deposit – The net amount applied to a security deposit. Calculated as: money credited to the security deposit charge, minus any discounts or credits applied against the security deposit charge.

  • Items – The net amount applied to merchandise, such as locks, boxes, and tape sold outright. Calculated as: money credited to merchandise charge lines, minus any discounts or credits applied against those merchandise charge lines.

  • Total – The row's grand total. Calculated as: the sum of the eight money columns above (Rent, Coverage, Fees, Delinquency, Tax, Other, Security Deposit, and Items). Nothing else contributes to this figure.

Money columns section of the Payments Detail report displaying Rent, Coverage, Fees, Delinquency, Tax, Other, Security Deposit, Items, and Total columns

Sorting and Totals

Rows are sorted oldest payment first, ordered by the moment each payment was recorded. If you want to sort a column, click on its label once to get a descending order, or twice to get an ascending order.

The summary row at the bottom of the report is built the same way as the rows above it: each summary figure - Totals rent through Totals items - is that column summed straight down. The Totals summary figure is summed down the row totals.

The Payments Detail table showing the X button at the top right of the table, used to clear the sorting, and the blue Totals footer row at the bottom summing the money columns

No rounding happens anywhere on this report. Every amount is carried at full precision from the accounting trail, added, and shown as-is.

Three relationships always hold and are worth checking when reconciling:

  • On every row, without exception, the row total equals the sum of its Rent, Coverage, Fees, Delinquency, Tax, Other, Security Deposit, and Items columns.

  • The report's overall Total equals both the sum of all row totals and the sum of the eight column summary figures.

  • The report's overall Total equals the total shown on the Daily Payments by Category report for the same facility and the same dates, since the two reports filter and categorize payments identically and differ only in how they're grouped.

⚠️ Warning: This report's Total is not expected to match the money the facility actually banked for the period. Refunds, waivers, write-offs, and the tender side of a payment (cash, card, ACH) are all outside this report, and money sitting on a tenant's account without being applied to a charge has not reached this report yet either.

Edge Cases

The situations below are all deliberate report behavior, not errors. Each one covers a case where the report's answer can differ from what someone might expect.

  • Applied money versus billed or received money. If a tenant has been invoiced but hasn't paid yet, nothing appears on this report for that charge. If a tenant has paid but the money is still sitting unapplied on their account, it also doesn't appear - it shows up only once it's applied to a charge, and on the day it was applied, not the day it was received.
    ​

  • Discounts. If a discount or promotion is applied together with a payment, it reduces the category it was applied to rather than appearing as its own line.
    ​

  • Refunds, waivers, and write-offs. If a payment shown on this report is later refunded, the original row is not affected - it continues to appear exactly as it did when the payment was applied. If a fee is waived, or a balance is written off, neither ever appears on this report at all, since neither one is an application of money.
    ​

  • Migrated balances and unclassified fees. If a payment includes a balance that was carried in from a previous system, that portion lands in no column and isn't included in the row total. The same is true if a fee line has no recorded fee kind - it also lands in no column. Either situation can leave a row showing all zeros across its money columns.

  • One payment across multiple units, or one transaction across multiple payments. If a tenant pays for two units in a single payment, the report shows one row: the amounts from both units are combined into the same columns, and only one unit number is shown, so that row's unit number does not represent the entire amount on its own. If, instead, one transaction is settled using two payment methods - cash and card, for example - the report shows two separate rows, one per payment, each carrying its own share of the categories.
    ​

  • Tenant name, unit number, and PTD after the fact. If a tenant's name changes after a payment was made, the row still shows the name as it was recorded at the time of that payment - re-running the report for the same historical period later will not update it. If a unit is renumbered after the payment, the row shows the unit's current number instead, which is the opposite treatment from the tenant name. And if the lease is paid further forward after this payment, or is later closed, the PTD column always reflects the lease's current paid-through date, not the date this specific payment bought - so the same historical row can show a different PTD if the report is run again later.

FAQ

The following questions cover common points of confusion when reading the Payments Detail report.

1. Why does a row sometimes show $0.00 in every money column?

This happens when a payment's charges don't match any of the eight categories - most commonly a balance migrated in from a previous system, or a fee line with no recorded fee kind. Both types of charge are excluded from every column and from the row total.

2. Why doesn't the Total on this report match what the facility actually deposited?

The two aren't expected to match. This report shows what money was applied to, not how it was received, and it excludes refunds, waivers, write-offs, and any money still sitting unapplied on a tenant's account.

3. Is there a Corporate level version of this report?

No. The Payments Detail report exists at the Facility level only, and each run covers a single facility.

4. Why did the PTD on an older row change when I ran the report again later?

The PTD column always shows the lease's current paid-through date at the moment the report is run, not the date the original payment paid through to. If the lease was paid further forward since that payment - or later closed - a later report run can show a different PTD on the same historical row.

5. How is this different from the Daily Payments by Category report?

Daily Payments by Category uses the identical filters and the same eight categories, but groups results into one row per day instead of one row per payment. Its totals match this report's totals exactly for the same facility and dates. Use Daily Payments by Category to see the overall shape of a period, and use Payments Detail when a specific payment needs to be identified.

Related Reports

Did this answer your question?