Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


 

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] + [
M
  1. R]).
  2. Enter/select the filter criteria from the Parameters window.
  3. Click Run (or press [Alt] + [
M
  1. R]).



 

Sample Reports

(Click an image to enlarge)

Portal

Image Removed 

Image Added


Back Office 

Image RemovedImage Added

 



Field Definitions

Field

Calculation Formula

Description

Practice
 

The practice for which the charge is being billed.
Accounting Date/Posted Date  
Payment Batch ID

The unique identification number assigned to the payment batch when it is created.

Remitter
The name of the person or payer who remitted the payment
The accounting date/posted date for the deposit activity, based on the Date Mode filter option selected
.
Check Number 
 

The check number of the check.
Remitter
Check Date
 

The
name
date of the
person or payer who remitted the payment
check.
Deposit Amount
Deposited 
Distributed 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
- 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.

 

Note

Only active practices are returned in the search results.

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




 

Panel
titleColorWhite
titleBGColorGray
titleRelated Topics

Portal

Reports (Portal)

 

 



Search this documentation

Livesearch
spaceKeyCD