Overview

Purpose

This report analyzes bank deposits grouped together by payment batches, displaying all checks within a batch and their corresponding amounts.

This is a tree-level report, with totaled amounts displayed at the top level for all Payment Batches/Payments included in the report.

Additional payment batch/payment information is available by drilling into specific payment batches. Click the Expand icon () to open a Payment Batch and see associated payment details. 

The Grand Total line at the bottom of the report displays the payment batch totals for the period in which the report is run.

This report is only accessible via Back Office Reports. It is not available in Portal.

Category

Management

Type

Detail

Mode

Accounting / Posted

Output Options

CSV or Excel

How to Get Here?

From Back Office:
  1. Open the Manage menu and select Reports.
  2. From the Reports page > Modern tab, select the Deposit Analysis Tree 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)

Back Office 

 


Field Definitions

Field

Description

PracticeThe practice for which the payment batch is associated.
Payment Batch IDThe unique identification number of the payment batch when it is created.
Payment ID

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

  • Information only displayed at the child (payment-specific) level.
Remitter

The name of the payer, person, or organization that issued the payment.

  • Information only displayed at the child (payment-specific) level.
Check Number

The check number of a remitted check.

  • Information only displayed at the child (payment-specific) level.
Check Date

The date on the remitted check.

  • Information only displayed at the child (payment-specific) level.
Deposit Amount

The amount of the remitted check.

  • Amounts displayed for a specific Payment at the payment level.
  • Totaled amount for all payments in a specific Payment Batch displayed at the payment batch level.
  • Totaled amount for all payments/deposits included in the report displayed in top line of the report table.
Distributed - Line Items

The amount from the deposit that was posted directly to service lines.

  • Amounts displayed for a specific Payment at the payment level.
  • Totaled amount for all payments in a specific Payment Batch displayed at the payment batch level.
  • Totaled amount for all payments/deposits included in the report displayed in top line of the report table.
Distributed - On Account

The amount from the deposit that was posted as a credit balance to On Account.

  • Amounts displayed for a specific Payment at the payment level.
  • Totaled amount for all payments in a specific Payment Batch displayed at the payment batch level.
  • Totaled amount for all payments/deposits included in the report displayed in top line of the report table.
Distributed - Suspense

The amount from the deposit that was posted to Suspense off of the active AR.

  • Amounts displayed for a specific Payment at the payment level.
  • Totaled amount for all payments in a specific Payment Batch displayed at the payment batch level.
  • Totaled amount for all payments/deposits included in the report displayed in top line of the report table.
Distributed - External Collections

The amount from the deposit that was posted off of the active AR to external collections service lines.

  • Amounts displayed for a specific Payment at the payment level.
  • Totaled amount for all payments in a specific Payment Batch displayed at the payment batch level.
  • Totaled amount for all payments/deposits included in the report displayed in top line of the report table.
Distributed - Misc Income

The amount from the deposit that was posted to Misc Income off of the active AR.

  • Amounts displayed for a specific Payment at the payment level.
  • Totaled amount for all payments in a specific Payment Batch displayed at the payment batch level.
  • Totaled amount for all payments/deposits included in the report displayed in top line of the report table.
Reversals - On Account

The amount of payments reversed from service lines to On Account.

  • Amounts displayed for a specific Payment at the payment level.
  • Totaled amount for all payments in a specific Payment Batch displayed at the payment batch level.
  • Totaled amount for all payments/deposits included in the report displayed in top line of the report table.
Recoup

Sum of all recoups created from the associated check.

  • Amounts displayed for a specific Payment at the payment level.
  • Totaled amount for all payments in a specific Payment Batch displayed at the payment batch level.
  • Totaled amount for all payments/deposits included in the report displayed in top line of the report table.
Accounting Date

The accounting date/posted date for the deposit activity, based on the Date Mode filter option selected.

  • Information only displayed at the child (payment-specific) level.

Available Report Filters

Option

Type

Required 

Description

Date Mode

Drop Down

Yes

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.

Date options include: 

  • Today
  • Previous Day
  • Current Month
  • Previous Month
  • Last 3 Months
PracticesList SelectionNo

Filters by all practices or one or more practices for which payment batches exist. By default, this filter is set to All.

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


 

Related Topics

Portal

Reports (Portal)



Search this documentation