Financial Snapshot Deposit Report

The Financial Snapshot Deposit Report provides the ability to produce a number of different types of payment deposit report formats depending on how the parameters are set up. This report is different than the Financial Snapshot connect report because this report is built based on the payment deposit date, and should match the Billing Practice Summary report when run by deposit date. For practices that are not auto-posting payments but instead, hold payments to create iSalus deposits after the amounts are reflected on their practice bank account, it is then possible to match your iSalus Deposits to your Bank Statements. 

The additional filtering options were carried over from the Financial Snapshot connect report to allow users options for getting additional report details. Similar to a pivot table in Excel, the filters build in flexibility through dynamic grouping, as it allows the user to select how the financials on the report are grouped through the Column 1, Column 2, and Column 3 parameters. As always, if you do not want to display the additional data fields, they can be excluded when setting up the new report. This report is limited to a 3-month date range, but the assumption is that this would be a daily, weekly, or monthly report depending on your workflows surrounding bank deposits and reconciling those between your bank and the iSalus Billing data.

1. Go to the Reports section, then under EMR select Connect.
2. Click the icon with a page and plus sign to create a new Connect report entry.
    
    
   
3. When asked to select the Report, scroll under the Claim header and find Financial Snapshot Deposit Report. Then fill out the description and parameters as follows:
   Description: This is what will be shown in the ‘Report’ column when choosing what to run. Because this is such a customizable report, I’d recommend making this as descriptive as possible.
4. Columns 1-3: Here you’ll select the fields you’re going to group the report on. If you select Column 1 to be Service Location and Column 2 to be Payment Method and Column 3 to be None, you’ll see all your financials broken out by Service Location and Payment Method. Where the filter doesn't apply to the payment type, you will see that noted on the report export as uncategorized which just means it has no association with the chosen category. This filtering ability is similar to adding Row Groups to pivot tables in Excel. The filter column options are: 
   1. Alternate Provider
   2. Business Unit (click here for more information on Business Unit)
   3. Claim Primary Payer
   4. Claim Primary Financial Class
   5. Code Class
   6. Paid By Financial Class
   7. Patient
   8. Patient Location
   9. Payment Method
   10. Procedure Code
   11. Procedure with Description
   12. Referring Provider
   13. Rendering Provider
   14. Service Location
   15. None
   16. Show Detail: You can choose whether or not to include Detail on the report. If you don’t include detail, the Chart Number, Patient, and Claim ID columns will be blank.
   17. Rendering Provider(s): You can select which rendering providers you want to include on the report. If All is selected, even with additional selections, all rendering providers will be returned.
   18. Service Location(s): You can select which service locations you want to include on the report. If All is selected, even with additional selections, all locations will be returned.
   19. Date Type: You can select Service Date or Post Date. If you choose service date, it will work the same as choosing service date on other reports. If choosing Post Date, it will run Charges by Charge Post Date and Payments/Adjustments by Payment Post Date, showing you all transactions that happened in this time period (whether charges, payments, or adjustments).
5. Start Date: The beginning date, of the type selected in (6).
   End Date: The end of the reporting window, of the type selected in (6).
   
   

You can use the Financial Snapshot to view your data in many different ways – here is an example of reports that can be created using this Connect report.

Financial Snapshot Deposit Report by Primary Payer, Payment Type, and Service Location – This allows you to see where payments are not associated with a category (in this case Primary Payer) then you will see it noted as uncategorized, otherwise, the associated data element will populate. 

Furthermore, the total for this report should align with your Billing > Practice Summary > Report Search by Deposit Date totals.

Reminder: For practices that are not auto-posting payments but instead, hold payments to create iSalus deposits to match their bank deposit date after the amounts are reflected on their practice bank account, it is then possible to match your iSalus Deposits to your Bank Statements. If you are not sure how to achieve this result going forward, our support team can assist you.