Overview

Purpose

This report analyzes bank deposits made by the practice during a specific accounting period. Set report criteria to return report  results by Accounting Date or Posted Date. You may return results for one, multiple, or all practices. The Recoup column is the sum of all recoups created from the associated check. If any reverse payment (RVPAY) transactions were made, they are reflected in the Distributed to Line Items and Distributed to On Account columns.

When running the report for multiple practices, Total values represent the sum totals for the specific practice; the Grand Total represents the combined sum totals for all practices displayed in the report.

Category

Financial

Type

Summary

Mode

Accounting / Posted

Output Options

CSV or Excel

How to Get Here?

From Portal:
From Back Office:
  1. From the Reports tab, locate the Deposit Analysis Summary report.
  2. Click Edit for the report.
  3. Enter/select filter criteria on the Criteria page.
  4. Click Run Report.
  1. Open the Manage menu and select Reports.
  2. From the Reports page > Modern tab, select the Deposit Analysis Summary report from the list of reports.
  3. Click Run (or press [Alt] + [R]).
  4. Enter/select the filter criteria from the Parameters window.
  5. Click Run (or press [Alt] + [R]).

 

Sample Reports

(Click an image to enlarge)

Portal


Back Office


Field Definitions

Field

Calculation Formula

Description

Practice
The practice for which the charge is being billed.
Deposit AmountDistributed to Line Items + Distributed to On Account + Distributed to Suspense + Distributed to External CollectionsTotal amount deposited per check.
Distributed - Line Items 
The amount from the deposit that was posted directly to service lines.
Distributed - On Account 
The amount from the deposit that was posted as a credit balance to On Account.
Distributed - Suspense
The amount from the deposit that was posted to Suspense off of the active AR.
Distributed - External Collections 
The amount from the deposit that was posted off of the active AR to external collections service lines.
Distributed - Misc Income 
The amount from the deposit that was posted to Misc Income off of the active AR.
Reversals - Line Items 
The amount of payments reversed from service lines.
Reversals - On Account 
The amount of payments reversed from service lines to On Account.
Recoup 
Sum of all recoups created from the associated check.
Accounting Date
The accounting date/posted date for the deposit activity, based on the Date Mode filter option selected.

Available Report Filters

Option

Type

Required 

Description

Date ModeDrop DownYes 

Determines how the results are grouped and ordered:

  • Accounting Date - Groups and orders deposits by the Accounting Date entered during payment entry.

  • Posted Date - Groups and orders deposits by the date the check was posted to the account.

DateDrop DownYes 

Filters transactions displayed by the selected time period. Options include: Custom Date Range, Last # of Days, Today, Previous Day, Current Month, Previous Month, Current Year, and Previous Year.


If Custom Date Range is selected, the From and To fields are enabled to enter specific dates to run the query on.

If Last # of Days is selected, the Last # of Days field is enabled to enter a specific number of days to run the query on.

The maximum timespan for the report is 366 days.
Practices List Selection Yes

Filters by all practices or by one or more practices. By default, this filter is set to All.

Only active practices are returned in the search results.

Report FolderDrop DownYesDesignates where to place or save the output from the executed report.


 

Related Topics

Portal

Reports (Portal)



Search this documentation



  • No labels