Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from this space and version 4.2

 

Overview

Panel
borderColorblack
bgColorgray
titleColorblack
borderWidth2
titleBGColorwhite
Info
titlePurpose

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 Check Amount DepositedDistributed to Line Items, and Distributed to On Account columns.

Values in this report represent individual check totals. Checks are grouped by the individual practices selected.

Category

Financial

Type

Detail

Mode

Accounting / Posted

Output Options

CSV or Excel

Info
titleBGColoraaaaaa
iconfalse
titleHow to Get Here?
From Portal:
From Back Office:
  1. From the Reports tab, locate the Deposit Analysis Detail 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 Detail report from the list of reports.
  3. Click Run (or press [Alt] + [MR]).
  4. Enter/select the filter criteria from the Parameters window.
  5. Click Run (or press [Alt] + [MR]).

 

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.
Accounting Date/Posted Date Remitter The accounting date/posted date for the deposit activity, based on the Date Mode filter option selectedname of the person or payer who remitted the payment.
Check Number  The check number of the check.
Remitter The name of the person or payer who remitted the payment.
Amount Deposited Deposit AmountDistributed to Line Items + Distributed to On Account + Distributed to Suspense + Distributed to External CollectionsTotal amount deposited per check.
Distributed to Line Items  The amount from the deposit that was posted directly to service lines.
Distributed to - On Account  The amount from the deposit that was posted as a credit balance to On Account.
Distributed to Distributed - Suspense The amount from the deposit that was posted to Suspense off of the active AR.
Distributed to Distributed - External Collections  The amount from the deposit that was posted off of the active AR to external collections service lines.
Distributed to Distributed - Misc Income  The amount from the deposit that was posted to Misc Income off of the active AR.Recoup 
 Sum of all recoups created from the associated check.Reversals Line 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.

 

Note

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.

 

 

Warning
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.


 

 

Panel
titleColorWhite
titleBGColorGray
titleRelated Topics

Portal

Reports (Portal)

 

 

Search this documentation

Livesearch
spaceKeyCD