Version 21.3
When to Use this Report
Use the Daysheet Log when a user wishes to view pertinent financial totals from each daysheet processed.
Qualifications
Processing daysheets consistently and using the effective daysheet date according to a protocol determined by the office is the only way that financial reports will be accurate.
About Daysheet Log
Path: Tools > Reporting > Daysheet Dependent > Daysheet Log
The Daysheet Log gathers and displays the pertinent financial totals from each daysheet processed. This report is intended to be a quick reference table for the financial information that is recorded daily.
Daysheet Dependent: Daysheet Log 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 |
Effective Daysheet Date | Select the date(s) you wish to search based on the date of the transaction that you daysheeted. Example: Today is 4/4 but I am daysheeting the transactions for 3/31. The effective daysheet date is 3/31.
See the Dates section of the Filter Tutorial article for the different selections.
|
2 |
Processed Daysheet Date | Select the date(s) you wish to search based on the physical date when the daysheet was ran. |
3 |
Total Charges | The Print button prints the daysheet log grid. |
4 |
Total Payments | The Total Payments tile shows the totals from the Payments column, which displays the the total for all directly applied ‘new’ money and any applied amounts from credit accounts for the processed daysheet. |
5 |
Total Adjustments | The Total Adjustments tile shows the totals from the Adjustments column, which displays the total of all Adjustment transactions with the processed daysheet. |
6 |
Total Receipts | The Total Receipts tile shows the totals from the Total Receipts column, which includes all items except those designated 'PC', 'AD', 'T', or 'R'. |
7 |
Total Receipts for Deposit | The Total Receipts for Deposit tile shows the totals from the Receipts for Deposit column, which includes payment transactions and patient credit account entries of credit cards, check, cash, and electronic funds transfer. |
Detailed Report
Number |
Section | Description |
a |
Daysheet ID | The Daysheet ID is the system generated number given to a daysheet when the daysheet is processed. |
b |
Effective Datsheet Date | Processing daysheets consistently and using the effective daysheet date according to a protocol determined by the office is the only way that financial reports will be accurate.
|
c |
Processed Daysheet Date | The Date DS Processed column provides the physical date when the daysheet was ran. |
d |
Charges | The Charges column displays the total of all billed charges for the processed daysheet. |
e |
Payments | The Payments column displays the the total for all directly applied ‘new’ money and any applied amounts from credit accounts for the processed daysheet. |
f |
Receipts for Deposit | The Receipts for Deposit are shown on the daysheet and in the Standard Reports form. This reflects 'new' money collected. It includes payment transactions and patient credit account entries of credit cards, check, cash, and electronic funds transfer. This number does not include payments entered by transferring previously collected money from the patient credit account. The Financial Summary is the sum of payments and patients credits collected as designated as CK, CA, CC, BC, OF, EF. |
g |
Total Receipts | The Total Receipts include all items except those designated 'PC', 'AD', 'T', or 'R'. |
h |
Adjustments | The Adjustments column displays the total of all Adjustment transactions with the processed daysheet. |
i |
Location # | The Location column displays the location # for the processed daysheet. This is useful for practices that have multiple locations. |
j |
Location | The Location column displays the location for the processed daysheet. This is useful for practices that have multiple locations. |
Calculation Information
This report is based on the database table ‘DayLog’.
An entry is automatically made into this table when a daysheet is processed. Entries exactly match the results that are shown on the daysheet.
All transactions are included in a daysheet: Capitation, practice level adjustments, voids, payments, and credits collected.
