Skip to main content

Facility Financial Reports: Financial Audit Trail Report

Trace every debit and credit posted to one facility's ledger over a date range back to the tenant, unit, transaction, and charge that produced it.

Overview

The Financial Audit Trail report lists every debit and credit that one facility's accounting ledger recorded during a selected date range, with one row for each individual posting. The report shows each posting on its own line, with no grouping, summarizing, or rounding. You can use this report for month-end reconciliation, for finding the postings behind an unexpected balance, for reviewing a single tenant's activity, and for confirming that a reversal or correction was actually posted.

Prerequisites

Running the Financial Audit Trail report requires a Facility level permission and one facility setting:

  • You are logged in to QuikStor and you are in the facility whose report you want to generate.

  • Read Financial Audit Trail permission has to be enabled at the Facility level in the Report section.

  • The facility must have an accounting basis, either Cash or Accrual, set before the Financial Audit Trail report can run. If the facility's accounting basis has not been set, then the report does not run and returns an error with the message "The accounting basis for the facility has not been set yet." To have the facility's accounting basis set up, contact our Support team.

Key Terms and Basic Rules

The Financial Audit Trail report relies on several bookkeeping terms and rules that apply across many of its columns. These terms and rules are defined once in this section.

Key Terms

The following terms are used to explain the Financial Audit Trail report:

  • Posting (journal entry) – A single line in the accounting ledger: one amount recorded against one account, on either the debit side or the credit side. Every financial event, such as a charge, a payment, a credit, or a refund, creates several postings that balance each other out.

  • Transaction – The business event that created a group of postings. Every posting created by the same event carries the same code in the Transaction column.

  • Reversing entry – The way the ledger undoes an event, such as a voided payment or a reversed charge. The original posting is never edited. Instead, the ledger adds a mirror posting with the debit and credit sides swapped, on the same account, tenant, unit, and line item, but with its own transaction number and its own recorded time.

  • Accounting basis – The rule a facility uses to decide when revenue is counted. On a Cash basis, revenue is counted when money is received. On an Accrual basis, revenue is counted when it is charged or earned. The ledger stores postings for both bases, but the Financial Audit Trail report only shows the set that matches the facility's current basis.

  • Line item – One charge on a tenant's invoice, such as a month of rent, a coverage premium, a late fee, or a merchandise item.

⚠️ Warning: A voided or reversed transaction only shows its reversal rows if the reversal was recorded within the selected date range. If the reversal was recorded after the To Date, then the Financial Audit Trail report shows only the original rows, and the original charge or payment appears as if it was never undone.

Inclusion Rules

The Financial Audit Trail report decides which postings to show based on the rules below. A posting appears only when it meets all three conditions: facility, accounting basis, and date.

  • One row per posting – Every row is a single ledger posting, and the report never combines rows. If two postings have the same account, tenant, amount, and time, then both still appear as separate rows. One business event therefore usually shows up as several rows that share one transaction number, typically with at least one debit and at least one credit.

  • Facility – The posting belongs to the selected facility.

  • Accounting basis – The posting belongs to the ledger for the facility's current accounting basis: Cash postings for a Cash basis facility and Accrual postings for an Accrual basis facility. The Financial Audit Trail report never shows both sets together.

  • Date – The calendar date on which the posting was recorded, in the facility's local time at that moment, falls on or between the From Date and the To Date. Time of day does not matter: any posting recorded from 00:00:00 to 23:59:59 on an included day is included.

  • Factors that do not affect inclusion – The service period of the charge, whether the tenant or unit is still active, the status of the transaction, and the facility's account groupings have no effect on whether a posting appears.

Accounting Basis Rules

The accounting basis changes which accounts appear in the Financial Audit Trail report:

  • Accrual basis facilities – If the facility uses the Accrual basis, then the report shows only Accrual postings. A rent charge and its payment usually produce a Revenue credit, a Receivable debit, a Cash debit, and movements in and out of Unearned Revenue.

  • Cash basis facilities – If the facility uses the Cash basis, then the report shows only Cash postings. Revenue appears when money is received, money that has not yet been applied to a charge appears under "Unapplied Revenue," and no Receivable postings appear.

  • Changed accounting basis – If the facility's accounting basis was changed at some point, then the Financial Audit Trail report shows the entire date range, including days before the change, using the current basis.

Formatting Rules

The Financial Audit Trail report displays money and dates consistently across all columns:

  • Money amounts – The Debit column, the Credit column, the Debit Total, and the Credit Total show amounts exactly as the ledger recorded them. The Financial Audit Trail report does not round any amount. For example, $27,957.04.

  • Dates – The report uses two kinds of dates. The Date column shows a full date and time in UTC. The Period From and Period To columns, and the From Date and To Date inputs, are calendar dates with no time.

Report Scope

This article covers the Financial Audit Trail report, which exists only at the Facility level. There is no Corporate level version of the report. Each run covers a single facility, so if you need audit trail data for several facilities, then the report must be run separately for each facility.

💡 Tip: The Financial Audit Trail report can be scheduled and emailed as a Facility level, date-range report. Additionally, you can mark the report as favorite so you can access it quicker and easier.

Report Layout

The Financial Audit Trail report page contains report parameters, filter and export controls, the results table, and two report-level totals. Report parameters, filter, and export options will be covered in this section, whereas results table and totals will be explained in the following section.

Report Parameters

The following parameters appear at the top of the Financial Audit Trail report page:

  • Report name and category – The title Financial Audit Trail, shown next to the green Financial badge.

  • Facility scope – One facility. The Financial Audit Trail report cannot cover more than one facility in a single run.

  • Date range – The From Date and To Date that define the reporting period. Both dates are required, both are calendar dates with no time, and both are inclusive. If the same date is selected for both, then the report covers that single day.

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

Financial Audit Trail report header showing report name, Financial badge, facility, date range, and generated timestamp

Filter and Export

Two controls on the Financial Audit Trail report page narrow and download the results:

  • Filter – Opens a Generate Report - Financial Audit Trail drawer where you can change from and to dates of the report. It has no facility picker as the report runs for one facility only.

Generate Report - Financial Audit Trail drawer of the Financial Audit Trail report

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

Export as options of the Financial Audit Trail report

Main Table Content

Each row in the Financial Audit Trail report combines two views of the same posting: the accounting view (which account was affected, what kind of account it is, and whether the amount was a debit or a credit) and the operational view (which tenant, unit, transaction, and charge the posting belongs to).

Here, the report table is split into four groups: identifying columns, account, charge details, and money and time.

Identifying Columns

The following columns identify who and what each posting belongs to:

  • Tenant – The full name of the tenant the posting belongs to. If the posting is not tied to a tenant, then this column shows "Anonymous." The tenant's name is a clickable link that opens the tenant overview screen in a new tab.

  • Unit – The number of the unit the posting belongs to. Inactive units are still shown. If the posting is not tied to a unit, such as in an anonymous sale, then this column is blank. The unit number is a clickable link that opens the unit overview screen in a new tab.

  • Transaction Number – A 7-character code made of digits and capital letters that identifies the transaction behind the posting. Every posting created by the same event shares this code, and staff see the same code elsewhere in QuikStor, so it connects a report row back to the activity that caused it.

Identifying columns of the Financial Audit Trail report showing Tenant, Unit, and Transaction Number columns

Account

The following columns describe the account each posting was recorded against:

  • Account Name – The account's base name followed by a label for its sub-type, shown exactly as recorded in the ledger. This column is always filled, and the facility's account groupings are not applied to it. The label rules are:

    • For most sub-types, the sub-type name is added after the base name. For example, the base name "Storage Rent" appears as "Storage Rent Revenue" when the sub-type is Revenue and as "Storage Rent Receivable" when the sub-type is Receivable.

    • If the sub-type is Payment or Other, then no label is added to the account name. For example, the base name "Cash" stays "Cash."

    • If the sub-type is Payment Unearned Revenue, then "Unearned Revenue" is added to the account name. If the sub-type is Payment Unapplied Revenue, then "Unapplied Revenue" is added to the account name.

  • Account Type – The top-level class of the account: Asset, Liability, Equity, Revenue, or Expense. This column is always filled.

  • Account Sub-Type – The account's specific role within its account type. This column is always filled. The possible values are Credit Expense, Discount Expense, General Credit Expense, Migration Credit Expense, Refund Expense, Waiver Expense, Write Off Expense, Expense, Payable, Refunds Payable, Receivable, Revenue, Unearned Revenue, Payment, Payment Unearned Revenue, Payment Unapplied Revenue, and Other.

Account columns of the Financial Audit Trail report showing Account Name, Account Type, and Account Subtype columns

Charge Details

The following columns describe the charge behind each posting. If a posting has no specific line item behind it, then these columns are blank.

  • Category – A broad charge bucket that QuikStor assigns automatically to each charge. Charges map to the Category column as follows:

    • A Rent charge shows Category Rent.

    • An Insurance (coverage) charge shows Category Coverage.

    • A One-Time Fee, Recurring Fee, Item Fee, Delinquency Fee, or General Debit charge shows Category Fee.

    • A Security Deposit charge shows Category Security Deposit.

    • An Item (merchandise) charge shows Category Item.

    • A Migration Balance charge shows Category Migration.

  • Fee Category – The fee classification of a fee charge: Fee, Tax, Other, or Delinquency. If the charge has no fee category, then this column is blank, even when the other charge details columns are filled.

  • Period From – The first date of the service period the charge covers, such as the start of a rent month. If the charge has no service period, such as a one-time fee, then this column is blank.

  • Period To – The last date of the service period the charge covers, such as the end of a rent month. If the charge has no service period, such as a one-time fee, then this column is blank.

Charge details columns of the Financial Audit Trail report showing Category, Fee Category, Period From, and Period To columns

Money and Time

The following columns show each posting's amount and when it was recorded:

  • Date – The exact date and time the posting was recorded in the ledger, delivered in UTC. For example, 09/01/2026 12:01 AM.

  • Debit – The amount recorded on the debit side of the posting. Debit and credit are the two sides of double-entry bookkeeping, and each posting has an amount in only one of them. If the posting is a credit, then the Debit column shows $0.00, never a blank.

  • Credit – The amount recorded on the credit side of the posting. Each posting carries its amount in either the Debit column or the Credit column, never both. If the posting is a debit, then the Credit column shows $0.00, never a blank.

Money and time columns of the Financial Audit Trail report showing Date, Debit, and Credit columns

Sorting and Totals

The Financial Audit Trail report has no set sort order and carries two report-level totals.

  • Row order – The Financial Audit Trail report applies no sort. Rows appear in the order the ledger returns them, which often looks roughly chronological but is not guaranteed and can change between two runs of the same date range. To read the rows in a specific order, you can sort them on screen or in the exported file.

  • Debit Total – The report-level total of the Debit column in the Financial Audit Trail report. Calculated as: the sum of the Debit amounts on every row of the Financial Audit Trail report for the selected date range.

  • Credit Total – The report-level total of the Credit column in the Financial Audit Trail report. Calculated as: the sum of the Credit amounts on every row of the Financial Audit Trail report for the selected date range.

  • Columns without totals – The Financial Audit Trail report has a Total row only for the Debit and Credit columns. Because no amount is rounded, Debit Total and Credit Total are exact sums of the amounts shown in the rows.

The Total row of the Financial Audit Trail report showing Debit total and Credit total

Good to know

The following reconciliation checks help confirm that the Financial Audit Trail report balances and agrees with other accounting reports:

  • Report-level balance – For a typical date range, the Financial Audit Trail report's Debit Total equals its Credit Total, because every transaction posts balanced debits and credits. If the two totals differ, then some transaction's postings may fall partly inside and partly outside the selected date range, or the difference needs to be investigated.

  • Transaction-level balance – For all rows that share one Transaction Number, the sum of the Debit amounts equals the sum of the Credit amounts.

  • Reversal pairs – A reversing entry and the posting it reverses have the same account and the same amount, with the debit and credit sides swapped, so together they net to zero. Both rows stay visible in the Financial Audit Trail report.

  • Summary accounting reports – For the same facility and date range, the Journal Entries and Journal Entries by Day reports should match the Financial Audit Trail report once the Financial Audit Trail rows are added up by account. Account names on those summary reports can differ from the raw account names in the Financial Audit Trail report, because the summary reports can apply the facility's account groupings.

FAQ

The following questions cover situations in the Financial Audit Trail report that are commonly found confusing:

1. Why does a charge for next month appear in this month's Financial Audit Trail report?

The Financial Audit Trail report includes a posting based on the date it was recorded, not the service period of the charge. If March rent is posted on February 28, then that posting appears in a report covering February 28 and does not appear in a report covering only March.

2. Why does the same account appear twice on one day, once with a debit and once with a credit?

The Financial Audit Trail report never nets postings against each other. If the same account is debited and credited within the date range, such as Unearned Revenue moving in and out on the same day, then the report shows two rows: one with the debit amount and one with the credit amount.

3. Why might the Date on a row fall outside the selected From Date and To Date?

The Financial Audit Trail report selects postings using the facility's local calendar date, but the Date column shows the recorded time in UTC. If a posting was recorded late in the evening or early in the morning local time, then its UTC date and time can fall on the day before or after the facility's local date, even though the posting was correctly included.

4. Should Managers still use the Financial General Ledger Detail report?

The Financial General Ledger Detail report is an older, deprecated report that the Financial Audit Trail report replaces. Both reports list the same postings for the same facility and date range, but the Financial General Ledger Detail report shows only tenant, unit number, account type and name, debit, credit, and date, with no transaction number, charge details, or service period. Managers should use the Financial General Ledger Detail report only where an existing process or schedule still depends on its layout.

Related Reports

The following reports are built from the same ledger posting:

Did this answer your question?