End of period reports
Learn how to create, run, and print reports for end of day, end of month, and end of year.
Before you start
- Security access to End of Day Reports, End of Month Reports and End of Year Reports dialogs in addition to specific report security as appropriate for the user’s role and responsibilities.
- End of Period (EOP) defaults set, if applicable.
- Processed end of day, month, or year. Current period reporting also available.
- Printer assignments for EOP reports.
Accessing end of period reports
To quickly access your default EOP reports:
- Reports > End of period > End of Day, Month or Year
- This direct path preselects the default reports so they can easily be printed or saved in the fewest steps.
- This direct path preselects the default reports so they can easily be printed or saved in the fewest steps.
To view the library of available reports, view the report fields, and read descriptions:
- Reports > Find a Report
- Use this path if you are unsure what report you need and to explore report options.
- This method also allows you to view a sample report before going through the steps to create it.
Note: Set a report as a favorite to easily find it the next time it needs to be run.
Running end of period reports
- Access the end of period report group through either of the following options:
- Reports > End of Period > End of Day, Month or Year
- Reports > Find a Report > expand End of Day, End of Month, or End of Year > Create report
- The most recent closed period will be preselected.
- The dates listed are generated from closing an end of day, month, or year.
- Reports can be run from either a single period or multiple consecutive periods. Use Shift + click to select the starting and ending sequential dates.
- Based on access path taken, the selected report from Report Search or EOP default reports may be preselected. Click any report to change the selected report.
- Select Print, Preview, or Save As.
- Add range filter(s) if needed and available. and click OK. Note: End of period reports have prebuilt sort options and some may have additional range filters.
- Based on step 4 selection:
- From Print, click OK to print to the report’s default printer. Click Printer to change the printer for this print job.
- From Preview, review report on screen and choose:
- Print to select print options and click OK.
- Save to select location, enter file name, and choose file type (txt, csv, xls) for the report.
- Cancel to return to filter window or report list
- From Save As, select location to save the report, enter file name, and choose file type (txt, csv, xls). Click Save.
- From Print, click OK to print to the report’s default printer. Click Printer to change the printer for this print job.
General
- Running reports from Current does not process the period. A processed period will display with the date and time it was closed.
- A second EOD close occurs when you run EOM.
- It includes finance charges, billing fees, and open invoices that were closed as part of EOM processing.
- For the last EOD report of the month, select both EOD periods using Shift + click, so the combined report will include complete information.
- Not all EOP reports have range filters available. For example, the EOD Itemized Audit Trail does not have additional filters whereas the EOM Service and Inventory Sales reports can be further filtered by class or staff.
- Use the Report Search window to review reporting details offered per report. Once determined which are most relevant to your practice:
- Click the star to save it as a favorite report from the Report Search window.
- Set the report as an EOP default.
Recommended reporting
- Print or save the Daily Deposit and Itemized Audit Trail reports each day. These reports are necessary for data re-entry in the event of server or backup failure.
- If maintaining inventory in Cornerstone, print or save the Items Profit Analysis Report after processing the final EOD of the year. MTD and YTD totals will clear with monthly and yearly period processing.
Reports with print and preview limitations
Available from current only:
- Aged Accounts Receivable by Staff (EOM)
- Current Activity report (EOM)
Available from a single processed period selection only:
- Inventory on Hand reports (EOD, EOM)
- YTD Net Sales reports (EOM)
- Monthly Invoices and Statements (EOM)
Available from processed periods only:
- Daily Revenue Report (EOD)
- Daily Summary Report (EOD)
- Daily Summary Tax Report (EOD)
- GL Batch report (EOD, EOM)
- Sales Tax Summary (EOD)
- Statistics by Staff (EOD)
- Statistics by Species (EOD)
Most used end of period reports
Daily
- Daily Deposit Report
- Daily Payment Register
- Daily Staff Commission
- Daily Summary Report
- Deposit Report – Checks
- Itemized Audit Trail
- Patient Visit List by Date
- Serv. And Inv. Sales By Staff or Class
- Standard Fee Exception
- Statistics by Staff
Monthly
- Accounts Receivable
- Cost of Goods Sold
- Inventory Sales By Class
- Monthly Deposit
- Monthly Discount
- Monthly Sales Summary
- Monthly Staff Commission
- New Client
- Sales Tax Summary/Income Reconciliation
- Serv. And Inv. Sales – By Staff or Class
- Service Sales By Class
- Statistics by Species
- Statistics by Staff
- YTD Net Sales
Yearly
- Account Write-Off
- High/Low Client Sales
- Inventory Sales
- Sales Tax Summary/Income Reconciliation
- Service Sales
- Statistics by Species
- Statistics by Staff
- Yearly Sales Summary
Reports available based on practice settings
Invoice defaults set to track A/R by provider
- Aged Accounts Receivable by Staff
- Productivity by Staff
Multi-location single database (MLSD) configured
- Daily Payment Register by Practice
- New Client by Practice
- Accounts Receivable by Practice
- Sales Summary by Practice (EOD, EOM, EOY)
