Cash Receipts Journal

Cash Receipts Journal

The Cash Receipts Journal is a list of all payments received from both Payers and Clients. This report can be filtered by Start and End Date, Status, Payer, and Batch ID. A Client Payment is included on the day it is received. The subsequent process of applying all or part of the Client Payment to a service does not generate another entry on this report.

Cash Receipts Journal
  • The Report is grouped first by Payer then in ascending chronological order.
  • Payer Remittances show the Service Date and Activity Posted to detail.
  • Report Parameters
    • Remittance Start and Remittance End dates use the RemittanceDate column in the dbo.Remittances table or the PaymentDateTime column in the dbo.ClientPayments table. In version 3.13, the report was updated to use the TransactionDate column from the dbo.Remittances table as this is a required filed during remittance entry.
    • Status pulls from the Status column in the dbo.Remittances or dbo.ClientPayments tables. The available selections are:
      • Ready (R)
      • Not Ready (N)
      • All includes any status type. Options per the dbo.RemittanceStatus table include:
        • Ready (R)
        • Not Ready (N)
        • Batched (B)
        • Copy (C)
        • Done (D)
        • Hold (H)
        • Preview (P)
    • The Payer drop-down list is populated with Payers specified in Configuration > Services/Payers > Payers.
    • Batch ID may be used to filter the results if entered. This is either the TraceId column in the dbo.Remittances table or the TransactionReference column in the dbo.ClientPayments table.
Changed
Thu, 06/25/2020 - 13:15