Daily Reports: Receipts for Deposit

Version 21.3

When to Use this Report

Use this report to view payments and credits collected for a specified period that can be used to match your deposits to your bank. For example, if you wish to look at all payments and credits that were set to a daysheet in the system for a period of a week, click the the Daysheet Date (1), select "Between" and choose a one week period. This will show users all daysheeted (archived) transactions for the time period the user requested the system to recall.

NoteThe Ins. Paid + Pat. Paid value (f) will be the same value captured on your Daysheet Log report Receipts for Deposit value.

Qualifications

This report only includes pay methods of 'CK' (Check),'CA' (Cash), 'CC' (Credit Card), 'BC' (bank card), 'OF' (Credit card on file), and 'EF' (electronic funds). If the pay method is not one of these, it will not be included in the receipts for deposit (different than total receipts - monies that you've actually taken that day).

About Daily Reports: Receipts for Deposit

Path: Tools > Reporting > Daily Reports > Receipts for Deposit

This report displays Receipts for Deposit to the bank (payment transactions and credits collected). The Acct Source column indicates how the payment was made where C = payment entered as a credit and P= payment posted directly against a charge. The results shown do not include voids. Results match the results on the daysheet.

Daily Reports: Receipts for Deposit Map

Hover over each of the Summary Tiles, to see specific data. For instructions on how to drill down and expand that information from the Summary Tiles, please see the Drill Down section of the Data Element Tutorial.

Note: All columns in the Detailed Report section will show by default. To hide columns, see the Visualization section of the Maximized Elements article.

Filters and Summary Tiles

Number

Section Description
1
Daysheet Date This is the effective Daysheet date. Select the date(s) for the displayed record's date range. Reports that meet the criteria and fall within the selected date range will appear in the detailed reports grid. See the Dates section of the Filter Tutorial article for the different selections.
2
Posted Date Select the date(s) to display the transactions for the posted date selected AS LONG AS they were also daysheeted. See the Dates section of the Filter Tutorial article for the different selections.
3
Daysheet ID Put in a range to display data based on the OP assigned Daysheet ID that was created during the selected date range.
4
Total Patients This Summary tile shows a true patient count, not a line item count. Patients can show up multiple times in the grid below and only be counted once in the tile.
5
Insurance Paid This Summary tile shows the total amount paid by the insurance carrier in the filtered report (totals from the Insurance Paid column).
6
Patient Paid This Summary tile shows the total total amount paid by the patients in the filtered report (totals from the Patient Paid column).
7
Total CollectedThe Total Collected Summary tile displays the total amount paid by the insurance carrier and the patient (adding the Insurance Paid column and Patient Paid column together).
8
Deposit Method The Deposit Method pie chart displays the different types of deposit methods. Hover over the chart to see the different methods in more detail.
9
Account Source Receipts The Account Source Receipts pie chart displays the patient account that the payment and credit comes from. Hover over the chart to see the different source receipts in detail. 
10
Filter/Expand/Ellipsis Hovering over the column headers in the Detailed Report pulls up the Filter/Expand/Ellipsis option. The filter shows how many filters you have specified for this report. The expand allows you to expand the Detailed Report. The ellipsis gives options to Print or Export this report.

Detailed Report

Number

Section Description
a
Deposit Method The Deposit Method column displays the type of pay method. You can collapse and expand each pay method type.
b
Daysheet ID The Daysheet ID column displays the daysheet identifier for the indicated transaction.
c
Daysheet Date The Daysheet Date column displays the date that the daysheet was created.
d
Posted Date The Posted Date column displays the date the indicated transactions were posted.
e
Patient The Patient column displays the patient's first and last name and the patient identifier for the indicated transaction.
f
Total Collected The Total Collected column displays the total amount paid by the insurance carrier and the patient (adding the Insurance Paid column and Patient Paid column together).
g
Insurance Paid The Insurance Paid column displays the amount paid by the insurance carrier.
h
Patient Paid The Patient Pay column displays the total amount paid by the patient.
i
Check # The Check # column displays the check number for the indicated transaction.
j
Deposit Source The Deposit Source column displays the way the deposit was collected (eg Copay, Portal, Deductible).
k
Note The Note Column provides any notes that were included for the selected transaction.
l
Billing Provider The Provider with Billing credentials associated with performing the service.
m
Rendering Provider The Provider who performed the service.
n
Location ID The Location ID in OP.  This is useful for practices that have multiple locations.
o
Account Source The Acct Source culumn indicates how the payment was made where C = payment entered as a credit and P= payment posted directly against a charge.
p
Archive Flag Identifies if this line has been daysheeted or not. The Archive Flag numbers listed in the colum:
  • 0: Non-daysheeted
  • 1: Daysheeted
  • 2: Daysheeted Voids
  • 3: Non-daysheeted Voids
q
Date (hint) DOS for payments and posted date for credits.
r
Transaction ID # The official Transaction ID in OP.
s
Entered by Staff The name of the staff member who entered this transaction