Revenue vs. Cash Report (PCC)

Compare revenue from last month, to the cash received this month.

  1. About this report
  2. How we calculate the Revenue vs. Cash numbers
  3. How to check the accuracy of the report 
  4. The Difference between the "Revenue vs. Cash" report and the "Percent Collected" report



1.  About this report

  • The Revenue vs. Cash Report shows you how much cash you posted this month, compared with how much revenue from prior month's services (all posting dates).
  • It appears on the Dashboard page.  It is available for companies who use PointClickCare.com (PCC) with DataRelay.
  • It is updated every 4 hours.
  • Only closed months in PCC will show constant Revenue and Cash numbers on the report.  If a month is still "open" (not closed) in PCC, then the numbers on the report may change until that month is closed. This is because transactions can be associated with an open month, until it is closed.

2.  How we calculate the Revenue vs. Cash numbers

  • Revenue:
    • the Revenue column displays the revenue for the previous Posting Month only, for all Service Dates.
  • Cash:
    • the Cash columns show the cash with Posting Dates in the month shown only, for all Service Dates
  • Percent
    • this equals the Cash posted this month, divided by the Revenue for the previous month's services.

 


3.  How to check the accuracy of the report 

To confirm that Revenue vs. Cash report is accurate, compare it with PointClickCare.com reports.  Here's how:

  1. In the Revenue vs. Cash report pick a month and Facility

    1. In the example below, we picked July 2025 for Rehab Center, for which
      1. Revenue (previous month i.e. in June) is $1,570,487
      2. Cash (in July) is $1,586,649  
  2. Get the Revenue from PCC

    1. PCC > open the same Facility (not the Management Console)
    2. Go to Reports > Transaction Report
      1. Print Report by: select Posting Date
      2. Date Range: select the same date range as above.  In our example, 6/1/25 to 6/30/25, because we're looking at Revenue in June 2025
      3. Leave resident blank, and use these default report settings.
    3. Click Run Report
    4. Open the CSV file in Excel:
      1. Turn on a filter (highlight any cell in the row 1 then click Data > Filter)
      2. On Column Q "Type" filter out (uncheck): Blanks, C , X
      3. On Column V "GL_Accounts"  filter out (uncheck) the GL Codes you supplied on the Settings > Percent Collected page.  If none appear, continue.
      4. Add the values in Column U "Amount" by click on the column header to highlight all the values.
      5. It should match with value in step 1 ($1,570,487).  This confirms the accuracy of the Revenue.
  3. Get the Cash  from PCC

    1. PCC > open the same Facility (not the Management Console)
    2. Go to Reports > AR Aging NEW, and choose these parameters:
      1. Report output option: PDF
      2. As of: set it to the same month as in step 1 (July 2025 in this example) 
      3. Aging By Type: Cash Aging
      4. Include: Resident details: uncheck this box
    3. Click Run Now
    4. Open the PDF file:
      1. Scroll down to the Total row, in the column labelled "Total +07/25"
      2. The Cash amount should match step 1 ($1,586,649).  This confirms the accuracy of the Cash.

 


4.  The Difference between the "Revenue vs. Cash" report and the "Percent Collected" report

  • The Revenue vs. Cash report  tells you "velocity", or how quickly you get paid.  For example,
    • This report is useful to understand cash flow speed.  It can help a Controller somewhat predict next month's cash flow, and know if there will be enough short-term cash for expenses, such as payroll.
    • Here some examples:
      • If you posted $100 in revenue last month, and you receive $100 in cash this month, your percent collected month-over-month is 100%.  It means you cash is coming in quickly and on-time.
      • If you posted $100 in revenue last month, and you receive $80 in cash this month, your percent collected month-over-month is 80%.  It means your cash is coming in slowly.  Assuming you'll be able to collect the remaining $20, you'll have a "catch-up" month in the future.
      • If you posted $100 in revenue last month, and you receive $120 in cash this month, your percent collected month-over-month is 120%.  It means you're receiving cash for prior month's of service, and that this month is a "catch-up" month.
    • This report does not tell you the "completion" rate.  Meaning, did you receive the full $100 cash for the $100 you billed in a particular month of service?  To know "completion" rate, use the Percent Collected report.  (Even though the Revenue vs. Cash report has a percent collected, that's just a comparison of this month's cash vs. last month's revenue.  The percentage does not tell you what happened in the past or the future.)

  • The Percent Collected report tells you the "completion" rate, or how completely to get paid. 
    • Meaning, it tells you if you received the full $100 cash for the $100 you billed in a particular month of service. 
    • It does not tell you how long (the speed) it took to get that cash, since both the cash and revenue are tied to the Service Dates (DOS), not to the posting dates. 
    • This report will help 
      • a CFO know what percent of his revenue can be expected to be converted to cash, even if he cannot predict when that will happen.
      • AR Managers and Collectors measure their performance. 

(last updated 9/12/2025)