The Cash Audit report provides a comprehensive review of a property’s cash transactions and balances. It displays the payment amount based on the different modes of payment along with various product types, i.e., the rental income received, past-due rent, security deposits collected and disbursed, other fees like admin fees, late fees, etc., insurance/protection amount, the money associated with auctions, etc.  

This report helps assess the allocation between payments and refunds and whether cash transactions are accurately recorded, secure, and compliant with established policies and procedures.

Note: The Cash Audit Report reflects the property’s cash transactions and balances as of the end of each day. Any adjustments or reallocations, such as refunds or corrections made after the report date, is not included in that report. For instance, if you download the Cash Audit Report for March 11th, and a transaction adjustment occurs on March 22nd for items related to March 11th, those adjustments will not appear in the March 11th report.

This report includes payment and refund data, and the figures align with those found in other reports, such as the Payments by Product Type, Close of Day Deposits, and Management Summary Report.

To view the Cash Audit Report:

1. Expand the Financial Reports folder from your Reports Library and click Cash Audit Report. Alternatively, you can use the Search bar available in the Report Library.  
   
2. Provide the following information: 

• Report Time Period - The timeframe for which you want to view the data, i.e. Today, last 7 days, last 30 days, etc. You can also specify a date by clicking Custom Date from the drop-down list and selecting the required date from the calendar or specify a range by clicking Custom Range from the drop-down list and selecting the required date(s) from the calendar.  
  
• File Type - The preferred file format for downloading the report, i.e. .pdf or .xlsx
• Property - The property for which you want to view the associated data in the report. 

1. Click Run Report.  
   Alternatively, you can run the report by clicking Run Report from the corresponding vertical ellipsis.

Note: Since the Cash Audit is a Static report, it cannot be customized to add or remove fields, filter or sort data. It is downloaded to your computer in the specified format. 

Cash Audit Report Sections

The Cash Audit Report contains the following columns:

• Date: The date when the payment is received. 
• Payments: Payments received by a property based on the different payment modes:  
  • Cash: Total cash received by the property on a particular date.
  • Check: The amount deposited through Check to the property’s bank account.
  • Gift Card: The amount deposited through Gift Card to the property's bank account.
  • ACH: Payment is transferred through an electronic funds transfer system, ACH or Automated Clearing House.
  • C.C./Debit: Payments received through Credit/Debit Cards.
• Refunds: Amount refunded/reversed to a property on the different payment modes:
  • Voids/Refund: This includes all voided and refunded amounts from check, card, cash, and ACH payments. It covers the cancellation (voiding) or refunding of financial transactions due to errors, overpayments, or the return of security deposits, among other reasons.
  • NSF Reversals: This includes amounts related to bounced check payments. This refers to transactions where a Non-Sufficient Funds (NSF) charge or fee is reversed. An NSF reversal occurs when a property cancels a fee originally applied due to insufficient funds in a bank account to cover a payment or transaction.
• Product Types: The payment associated with different aspects of a property’s operations, i.e., the rental amount received, past rent, associated fees or services, applicable tax amounts, etc. 

• Past Due Rent: The total rental amount tenants have failed to pay on time.
• Current Rent: The amount received from tenants currently occupying Spaces at the property. 
• Prepaid Rent: The advance payments made by tenants for their Space rentals.
• Admin Fees: The total amount a property charges to cover its administrative and operational expenses. 
• Late Fees: The total charge a property imposes on tenants when they fail to pay their rent on time.
• Other Fees: Miscellaneous fees associated with a property, i.e. Lien fees, Recurring Fees, etc.
• Protect/Insurance: The total coverage payment received from tenants who purchase insurance from the property. 
• Merch: The amount received when tenants purchase merchandise from a property to facilitate their move-in— for example, locks, packing supplies, etc. 
• Tax: The total tax amount associated with rental income, services, fees, merchandise, insurance, etc. 
• Auction: The amount collected by auctioning belongings in delinquent Spaces at a property.
• Deposits: The amount related to different types of financial deposits a tenant or property manager may be involved in—for example, security deposits, cleaning deposits, etc. 
• Others: Miscellaneous costs associated with a property.
• Total: The total payment received by a property irrespective of the mode of payment, i.e. Cash, Check, ACH, etc. 

Note: Refunds and reversals are already accounted for in each product type payment.