Cash Receipts Analysis Report

Cash Receipts Analysis Report

Purpose:

The Cash Receipts Analysis Report displays your cash receipts for pickups before, between, and after a given range of dates. Normally, this report is generated daily, allowing you to assess your total cash-flow position at the end of each day. 
Sales revenues are displayed on the report as well as the total cash receipts and the balance due from those sales. 
The Cash Receipts Analysis Report can be generated for all your locations or a specific location.

Accessing Cash Receipts Analysis Report:

Reports >> Monthly Financial Reports >> GL Posting Report >> Cash Receipts Analysis




Parameters/Filters:


Payment Location
This can be run for All Locations or a specific location.
This is the location recorded against a payment.
Brand
This can be run for All Brands or a specific brand - if branding is enabled in your system.
This refers to the brand against the booking the payment was made for.
Date Range Type
This report can be run for one of the following date range types:
  1. Payment and Pick Up Date
  2. Payment and Drop Off Date
Date Range
The date range this report will be run for.

Example:


There are two tables in the results for this report. They are both detailed below.

Tender Type
The tender type that has been assigned to the payment.
Cash Receipts between report date range and pickups/drop offs within report date range.
These are the payments that have been recorded within the reporting period where either the pickup or the drop off date (depending on the option chosen) of the booking also falls within the reporting period.
Cash Receipts between report date range and pickups/drop offs before date range.
These are the payments that have been recorded within the reporting period where either the pickup or the drop off date (depending on the option chosen)  of the booking falls before the start date of the reporting period.
Cash Receipts between report date range and pickups/drop offs after date range.
These are the payments that have been recorded within the reporting period where either the pickup or the drop off date (depending on the option chosen)  of the booking falls after the ending date of the reporting period.
Cash Receipts outside of report date range for pickups/drop offs between date range.
These are the payments that have been recorded outside of the reporting period where either the pickup or the drop off date (depending on the option chosen) of the booking also falls within the reporting period.

The second table shows the following information for the date range. It gives a summarised version of the information shown in the first table.

Sales Revenue
The Sales Revenue form bookings that fall within the report date range
Cash Receipts between date range
The payments taken within the report date range.
Cash Receipts outside date range
The payments taken outside of the report date range for bookings that fall within the report date range.
Agent Collect
The amount that had been collected by Agents within the report date range.
Balance
The Balance owing for the report date range.

Points to Note:

  1. The Sales Revenue does not include cancelled bookings
  2. The Cash Receipts and Agent Collect amounts include cancelled bookings

Printing/Exporting:

Click here for details on how to print or export a report from RCM