Versions Compared

Old Version 2

changes.mady.by.user Shawna Crawford

Saved on

compared with

New Version Current

changes.mady.by.user Shawna Crawford

Saved on

Key

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


 

Overview

Panel
borderColorblack
bgColorgray
titleColorblack
borderWidth2
titleBGColorwhite


Info
titlePurpose

This report analyzes deposit details for a specified date rangebank 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 Deposited, Distributed 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

UPDATECSV or Excel


Info
titleBGColoraaaaaa
iconfalse
titleHow to Get Here?


From Portal:
From Back Office:
  1. From
the Home Page:		From the Menus:
  • Update
  • Update

 

Sample Report

(Click the image to enlarge)

 

 
  1. 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] + [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

Image Added


Back Office 

Image Added


Field Definitions

Field

Calculation Formula

Description

  UPDATE

Practice
The practice for which the charge is being billed.
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.
Check Number 
The check number of the check.
Check Date
The date of the check.
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 - 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

Field

Option

Type

Required 

Description

  UPDATE
 

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