Skip to main content

Facility Financial Reports: Daily Payments by Category Report

See how a facility's daily collections break down across rent, coverage, fees, delinquency, tax, other, security deposit, and items, with one row per day that had activity.

Overview

The Daily Payments by Category report gives a day-by-day view of a facility's income, showing how each trading day's collections were split across eight categories. You can use it for end-of-day and month-end close, to see which days a month's fee income actually landed on, or to compare income mix across periods without any tenant-level detail. Every figure reflects the cash-basis accounting trail - a day's total reflects money applied to a charge that day, not necessarily the day the charge was originally billed or the day the money physically arrived.

Prerequisites

Access to this report requires:

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

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

Key Terms and Formatting Rules

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

Key Terms

  • Accounting trail – The complete record of accounting activity in the system. This report only reflects the cash-basis portion of that trail: the entries created when money is applied to a charge, not when the charge itself is billed.

  • Charge line – A single billable item, such as a month's rent, one late fee, or a lock. Each charge line is tagged with a category, which determines which report column it's counted under.

  • Net amount – The amount applied to a category minus any amount removed from it by discounts or credits applied that same day. Because every column is net, a column can show a negative number on a day where reversals outweighed collections.

  • Trading day – A calendar day, in the facility's own time zone, on which at least one qualifying accounting entry was recorded. Only trading days appear as rows on the report.

Formatting Rules

  • Money columns – Shown as exact decimal amounts; the report does not round any figure. A category with no activity that day shows as $0.00, never left blank.

  • Negative money – A valid, meaningful result. If a day's credits and reversals in a category outweigh what was collected in it, that column shows a negative number.

  • Date – Shown as a calendar date in the facility's own time zone, with no time-of-day component. For example, 09/22/2026.

  • Missing days – A day with no qualifying activity does not appear as a row at all. It is left out entirely rather than shown with zero values.

Report Scope

This article covers the Facility level version of the Daily Payments by Category report. The report has no Corporate level counterpart - it can only be run for one facility at a time, and there is no company-wide version that spans multiple facilities.

💡 Tip: The Daily Payments by Category report supports scheduled email delivery on a daily, weekly, or monthly basis, and can also be marked as a favorite for quicker access.

ℹ️ Info: This report and Payments Detail read the same accounting lines and sort them into the same eight categories, so each category column here matches that category's total on Payments Detail exactly, to the cent, for the same facility and date range.

Report Layout

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

Report Parameters

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

  • Facility scope – A single facility, selected from the facility you're currently working in. As noted in Report Scope, this report cannot be run across multiple facilities at once.

  • Date range – Set using From date and To date. Both dates are required and both are included in the report, read as calendar days in the facility's own time zone. The From date begins at 00:00:00 facility-local time, and the To date runs through 23:59:59 facility-local time. The To date must fall on or after the From date. Setting both to the same day produces a single-day report of at most one row.

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

Report parameters on the Facility level Daily Payments by Category report displaying report name, category, facility scope, date range, and Report Generated timestamp

Filter and Export

  • Filter – Opens the Generate Report - Daily Payments by Category 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 - Daily Payments by Category drawer of the Daily Payments by Category report where you select the From to Date

  • Export as – Available as CSV, Excel, or PDF.

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 and includes one row per trading day, with the following columns:

  • Date – The calendar day the row represents.

  • Rent – The net amount applied to rent charges that day.

  • Coverage – The net amount applied to protection plan charges that day.

  • Fees – The net amount applied to general fee charges that day, such as admin fees, lock fees, and setup fees.

  • Delinquency – The net amount applied that day to fee charges categorized as delinquency-related, including late fees, lien fees, lock-cut fees, and other charges raised through collections.

  • Tax – The net amount applied that day to fee charges categorized as tax. Tax is recorded as its own separate charge line, so it is never combined into the amount it was charged against.

  • Other – The net amount applied that day to fee charges that don't fall under Fees, Delinquency, or Tax.

  • Security Deposit – The net amount applied to security deposit charges that day.

  • Items – The net amount applied that day to merchandise sold outright, such as locks, boxes, and broom.

  • Total – The sum of the eight category columns above for that day. No other figures are included in this total.

Main table of the Daily Payments by Category report showing Date, Rent, Coverage, Fees, Delinquency, Tax, Other, Security Deposit, Items, and Total

ℹ️ Info: Balances carried over from a previous system during migration (which are tracked under their own separate category, outside this report) are not reflected in any of the eight category columns or in the day's total. If a day's only activity consists of this kind of charges, that day still produces a row on the report, but every column on it shows zero.

Sorting and Totals

Rows are sorted by date, oldest first. If you want to sort any other column, do so by clicking on the column's label - one click sorts the column in the ascending manner, two clicks sort it in the descending manner. You can undo the sorting by clicking on the X on the right-hand side of the report.

The Total row at the bottom of the report is calculated as follows:

  • Each category's summary figure (Total rent, Total coverage, and so on through Total items) is the sum of that column, added straight down every row.

  • The grand Total figure is the sum of each day's Total column.

The Total row of the Daily Payments by Category report

ℹ️ Info: This report's total is not expected to match the amount of money physically deposited that day. Refunds, waived fees, write-offs, and the payment method side of a transaction (cash, card, or ACH) all fall outside what this report tracks, and money that's been received but not yet applied to a charge is not yet reflected here.

Edge Cases

How specific situations are reflected in this report:

  • If a charge is billed on one day but paid on a later day, then the report shows the payment on the day the money was applied, not the day the charge was originally raised.

  • If a discount or promotion is applied to a charge, then it reduces that day's figure in the category the discount was applied to.

  • If account credit is applied to a charge, then it's counted on the day it's applied, even if no money physically changed hands that day.

  • If a payment is later refunded, then the refund does not appear anywhere in the report, on any day - the original day retains its original, unadjusted figure.

  • If a fee is waived or a balance is written off, then neither appears anywhere in the report.

  • If a migrated balance is paid, then that amount is not reflected in any column and is excluded from the day's total.

FAQ

The following questions cover common points of confusion when reading the Daily Payments by Category report.

1. Why is a day missing from the report?

A day only appears as a row if it had at least one qualifying accounting entry. If a day had no activity, it's left out of the report entirely rather than shown as a zero row - a gap in the date sequence is the expected signal, not an error.

2. Why does a column show a negative number?

Every money column is net: the amount applied to that category minus any amount reversed out of it that same day by discounts or credits. If reversals in a category outweigh what was collected in it that day, the column goes negative.

3. Why doesn't the day's total match what was deposited in the bank?

This report tracks what money was applied to, not how it arrived. Refunds, waived fees, write-offs, and the cash/card/ACH side of a transaction all sit outside this report, and money received but not yet applied to a charge won't show up until it is.

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

No. This report can only be run for a single facility at a time - see the Report Scope section above.

5. Why did a charge that was billed earlier in the month show up on a later date?

The report reflects the day money was applied to a charge, not the day the charge was billed. If a tenant is billed on one day and pays on a later day, the payment shows up on the day it was applied.

Related Reports

Did this answer your question?