Deposit Reconciliation Report

The Deposit Reconciliation report accessible from the Deposits screen allows for in-depth reporting on deposits.

To access the Deposit Reconciliation report, take the following steps: 

1. Navigate to the Billing section of the system using the left-hand navigation pane:
   
   
   
2. In the left-hand navigation pane, select Deposits under the Payment Posting header:
   
   
   
3. On the toolbar, in the More drop-down, select Deposit Reconciliation:
   
   

When opening the Deposit Reconciliation report, you'll see the parameters at the top of the screen. By default it will show all deposits with a deposit date of the current day -- but you can modify the following parameters:

1. Reporting Period: This allows you to set a date range. 
2. Date Search Type: This allows you to set which date will be compared against the Reporting Period selected.
   1. Created: The date that the deposit was created. 
   2. Deposit: The deposit date assigned to the deposit by the user. 
   3. Disbursed: The date the deposit was finished being disbursed. 
   4. Sent to Posting: The date the deposit was initially sent to posting. 
3. Deposit Owner: This allows for filtering based on the user assigned to the deposit. 
4. Deposit Status: This allows you to filter based on the status the deposit is currently in.
   1. Build: This status means the deposit is currently being built. It's rare to see deposits in this status. 
   2. Ignore: The deposit has been ignored. This is frequently done when a deposit has been posted into a different practice or financial management system. 
   3. New: The deposit has not yet been ignored or sent to posting. 
   4. Sent to Posting: The deposit has been sent to posting. 
5. Deposit Type: This allows you to filter based on the deposit type. 
   1. EOB: Shows manually entered EOB deposits. 
   2. ERA: Shows ERA deposits sent from the Clearinghouse. 
   3. Import: Shows deposits that were manually imported into the system. 
   4. Statement: Shows statement deposits, whether imported manually or automatically from PaySimple.
6. Import File: If you have imported files, this allows you to search for deposits based on the name of the imported ERA. 

Once you have set your parameters and hit 'Search,' you will see the Deposit Reconciliation data appear in the body of the report with the following fields:

1. Deposit ID: The system ID of the deposit. 
2. Deposit Date: The deposit date manually entered in the deposit. 
3. Check #: The check number that came in on an ERA, or which was entered on a manual deposit. 
4. Payer Name: The payer on the deposit. 
5. Status: The current status of the deposit.
   1. Build: This status means the deposit is currently being built. It's rare to see deposits in this status. 
   2. Ignore: The deposit has been ignored. This is frequently done when a deposit has been posted into a different practice or financial management system. 
   3. New: The deposit has not yet been ignored or sent to posting. 
   4. Sent to Posting: The deposit has been sent to posting. 
6. Posting Status: The current posting status of the deposit. This will typically be one of the following:
   1. Disbursed: The deposit has been completely disbursed, and every related item in the posting screen is resolved. 
   2. Not Disbursed: The deposit has either not been sent to posting, or has outstanding items in the posting window. 
7. Deposit: The total deposit amount. 
8. Payments: The payments tentatively assigned to claim lines from the deposit, whether posted or not. 
9. Adjustments: The adjustments tentatively assigned to claim lines from the deposit, whether posted or not. 
10. Exclusions: The amounts of the deposit claims excluded from posting. 
11. Posted Paid: The payments currently posted from this deposit to claim lines. 
12. Posted Adj: The adjustments currently posted from this deposit to claim lines. 
13. Type: The type of the deposit. 
    1. EOB: Indicates a manually entered EOB deposits. 
    2. ERA: Indicates ERA deposits sent from the Clearinghouse. 
    3. Import: Indicates deposits that were manually imported into the system. 
    4. Statement: Indicates statement deposits, whether imported manually or automatically from PaySimple.
14. User: The user assigned to the deposit. 
15. Disbursed: The date the deposit was fully disbursed, if applicable. 
16. Sent Posting: The date the deposit was sent to posting, if applicable.