For accountants/CFO’s that would like to see more detailed reporting or reconciliation for a deposit slip, we have a custom report that will provide additional fields and layouts and will match the deposit slip.
The only caveat here is as long as the payment is applied to charges at the same location it was originally entered into – especially in these situations:
- When your team enters charges, they must confirm they are in the correct location.
- When your team enters payments they must confirm they are in the correct location.
- When your team applies a payment (in the case of prepay), they must confirm the charge was in the same location that they payment is entered.
We set up Dentrix Ascend to document the location payments are entered/applied because providers can be paid based on location as well as collection.
First, run your deposit slip. (This report uses transaction date.)
Next, using the Analysis Ledger Report Builder (found in the Financials tab), use the transaction date and filter for the same date range as your deposit slip.
Now you can add additional fields, such as:
- Category (filtered to include guarantor payments and insurance payments)
- Measures – Amount
In report options, select grand total by row and columns.
Now, you will see this grand total in the power report matches the deposit slip.
(Article authored by J. Alldredge, J. Nesbitt 2019)