Dashboard
      Back to home
      1. Support Home
      2. AR Workflow Automation
      3. Dashboard

      Cash Waterfall (PCC)

      See how the Cash Waterfall report for PCC DataRelay users works.

      1. About this report
      2. How to check the accuracy of the report

      1. About this report

      • The report is updated every 4 hours.
      • Each row is a month of Posting Dates
        • The report shows the last 18 months of Posting Dates (so there are 18 rows on the report) 
      • Each column is a month of Service Dates
        • The report shows the last 22 months of Service Dates (so there are 22 columns on the report) 
      • For example:
        • In the example below, $883k was posted in Aug '25 for services in Jun '25.  And $2.5m was posted in Jun '25 for services in Mar '25

      2. How to check the accuracy of the report 

      To confirm that the Cash Waterfall report is accurate, compare it with PointClickCare.com reports. 

      Summary: run the PCC Cash Aging report, and confirm each month’s cash total matches the ARP Cash Waterfall report.

      Details: here’s how:

      1. In the Cash Waterfall report, pick a Posting Date Row

        1. Since we are only checking the accuracy of the data, we’ll filter (check) just one facility. You could check the accuracy for All facilities, but the PCC Report will take longer to export.
        2. In the example below, we picked February 2025 for Rehab Center, for which:
          1. March 2025 (Future Cash) is $509
          2. February 2025 (Current) is $112,652
          3. January 2025 is $269,007
          4. December 2024 is $459,327
          5. November 2024 is $32,295


      2. Get the Cash for each Service Date period from PCC Cash Waterfall (PCC)

        1. Go to PCC > Reports > A/R Aging *New*
          1. Report output option: select PDF (for better readability)
          2. Facilities to be included in this report: select the facility you are using to check on the Cash Waterfall report accuracy. In this example, we picked “Rehab Center”.
          3. Aging By Type: select Cash Aging
          4. As Of: select the month and year you picked earlier. In this example, we picked February 2025.


          5. Aging Buckets: You can leave them as default unless you’d like to see less previous months (each bucket represents one service date month). In this example, we keep it as is.


          6. Accounts to Include: select Specific and select All
          7. Use the default report settings for every other option.

        2. Click Run Now
        3. Once exported, open the PDF file:
          1. Scroll down to the end of the buckets per resident table.
          2. Now you’ll see one column per “bucket”, these represent the months on the selected row for the Cash Waterfall report.
          3. Check the bold values on the Total row for each column, they should match with the values in step 1.

          4. This confirms the accuracy of the Cash Waterfall report:
            1. March 2025 (Future Cash) is $509
            2. February 2025 (Current) is $112,652
            3. January 2025 is $269,007
            4. December 2024 is $459,327
            5. November 2024 is $32,295

      (last updated 10/22/2025)