| REPORT | COMMENT/NOTES |
| | |
| ACCOUNTING REPORTS | |
| 1 | Accounts Receivable Summary | Only a date filter. Sorted by Location Counselor client. Each session listed. Would be helpful if showed the payor or grantor. Also export includes the formatting which makes it hard to use for data analysis. This shows the amount paid not the amount owed. More of a “Revenue” than a “Receivables” report |
| 2 | billing notes Batch Report | |
| 3 | billing notes Report | |
| 4 | Billing Units Report | Filter = date range List of counselor sessions and number of units charged to that session. No $’s shown. Would need to be exported to excel and then sorted to be useful. . |
| 5 | Client Deposit Transaction Report | Reports on pre-session advance payments make by client. |
| 6 | Client Transaction History | Same report format as other reports but can specify client or all clients in the filter along with counselor, dates, plus some checkboxes. One row per transaction: date, client, session, service, attendance, payment type, Revenue (cash basis), adjustments, counselor. |
| 7 | Company Transaction History | A cash accounting vs accrual report. Shows each cash, insurance, write off transaction that occurred. Filter by day week. Very similar to the Location Transaction History which does include location. |
| 8 | Counselor Transaction History | Almost identical to the Payments Detail or summary report. The other report provides more filter options then this does. |
| 9 | CPT Based Billing Report | Filter = counselor, date range, CPT code, then several checkboxes. Formatted report grouped by counselor. Then sorted by CPT within counselor. Each row CPT, units scheduled, attended, canceled by counselor client, no shows amount billed.. No totals. |
| 10 | Facility Group Payroll Report | Filter = counselor (all) group name date range. Can't generate with data currently in production. Would not be very useful. |
| 11 | Location Transaction History | Filter by date and location. One row per revenue collection or write off. Payment date, client, session, service payment type collection, write off, counselor. Has report total. |
| 12 | Payment Transaction by User | Filter = date range. One row per client session. Payment date, client, session date, payment type, Revenue, adjustments, check number and counselor. Provides total at end of report. Good for scanning and spot checking who is recording payments or not.. Looks like many counselors may not be recording payments/write offs. |
| 13 | Payment Transaction History | One row per revenue transaction. Similar report to the above but filters on date, counselor. This does have totals that are useful. |
| 14 | Payments Details or Summary Report | Filter by counselor (All), date range can specify types of revenue. Report grouped by counselor. Summary total of each type of transaction for the date range. I.e. total cash, total checks. |
| 15 | Revenue by Location | Filter = Location, dates, cash or check or summary checkbox. Simple report with one row per day showing the date, number of sessions, clients and total cash/checks for day. If click Location Summary get one row assuming the whole date range. |
| 16 | Therapist Group Payroll Report | Filter = Counselor, Group name, date range, individual or group. Shows transaction date, session date, client, group name, counselor. No amounts. Doesn't indicate dollars or attendance. |
| 17 | Therapist Payroll Report | Filter by counselor, date range, data elements and print total revenue. Report sorts by payment type with subtotals for cash, check, insurance. |
| 18 | Therapist Progress Status Report | Filter = date range, counselor (all). List report showing each session, client , CPT code, type of progress note, note status and note date. This will be used by clinical and not accounting. |
| 19 | Therapist Progress Status Report with Hours | Same report as above except replaces the session type columns with house. This will be used by clinical managers not accounting. |