How can we help you?

Deposit Detail Report Guide

Introduction and purpose

This guide is designed to assist you in understanding how to effectively use the Deposit Detail Report. The report displays each instance of IRS refund processing and tax-preparation fee collection. Each row represents an individual taxpayer transaction. 

  • Track Deposits - Observe precisely when and how much was deposited into your bank account
  • Match Deposits - Reconcile deposits on your bank statement with the individual fees collected from taxpayers
  • Trace Transactions - Trace each dollar back to the specific taxpayer or product that generated it

Upon opening the report, columns such as “Disbursed Date,” “Deposits,” “ACH Identifier,” and others will enable you to reconcile (match) entries appearing in our system with those on your bank statement.

 

Key benefits

Understanding the key benefits of the Deposit Detail Report will help you leverage our most popular report.

  • Accurate Fee Reconciliation - Quickly verify that the total fees indicated in the report match the deposit amounts on your bank statement
  • Clear Transaction Descriptions - The “Comment” column provides a plain-language description for each row, explaining what each entry signifies
  • Efficient Trail - Each deposit has a unique “ACH Identifier” (once posted), linking your bank deposit back to our report
  • PCenter and Site-Level Visibility - For individuals managing multiple offices or franchises, filtering by EFIN or business name allows visibility into which location generated each fee or deposit.

 

Critical columns for reconciliation

Below are the essential columns utilized for matching deposits to your bank statement:

  • Disbursed Date - The date we issued the refund (and collected any fees). Match this to the date on your bank deposit.
  • ACH Identifier - A unique code for each batch of deposits. Once funds reach your bank, this ID appears on the deposit advice. Filtering by this ID pulls the exact rows corresponding to one bank deposit.
  • Deposits - The exact dollar amount transferred to your bank account in that row. In single-item deposits, this equals the fee collected. In multi-item batches, this displays the sum of “Deposits” across all rows sharing the same “ACH Identifier.”
  • PCenter Site Fees Paid - The fee amount collected from the taxpayer. For fee-only deposits, “Deposits” and “ERO / Site Fees Paid” match. When fees post in multiple parts (partial payments), sum this column across dates.
  • Comment (for reference) - Provides a description per row, indicating deposit amount and taxpayer record or product.

 

Example scenarios

ExampleScenarioHow to Use It
Example #1 - Single Deposit (Fee Advance)The entire deposit originates from Early Fee Advance, resulting in only one row in the report.Identify a $187,500.00 deposit dated 12/05/2025 with ACH ID KZLKD2JW3ZADFWY on your bank statement.
Example #2 - Multiple Prep Fees on 04/16/2024Seven taxpayers each paid a preparation fee on the same day. SBTPG has not yet grouped them into one bank deposit, resulting in a blank “ACH Identifier” until posting.

Filter by Disbursed Date = 04/16/2024. Sum the “ERO / Site Fees Paid” column to get $3,512.00. Upon SBTPG bundling these into one ACH deposit, filter by Disbursed Date = 04/16/2024 and ACH Identifier = 5MLSRODNE3I5B2Y Confirm “Deposits” = $3,512.00 matches your bank statement

“Comment” = DAN-4761

Example #3 - Partial Fee Payments for One Taxpayer (Collected Over Two IRS funding Dates)A single taxpayer (RZFNUZF36GX4RLR6W) owed $1,905.00, but payments were received/collected in two parts on different dates.Filter by Application Reference Number = RZFNUZF36GX4RLR6W. Verify the sum of “ERO / Site Fees Paid”: $1,424.10 + $480.90 = $1,905.00. When SBTPG posts the first payment on 03/13/2024 (ACH Identifier = NM7GBEAGMRC6JKY), you will see: Disbursed Date = 03/13/2024, ACH Identifier = NM7GBEAGMRC6JKY, Deposits = $1,424.10. When SBTPG posts the second payment on 04/11/2024 (ACH Identifier = ANH65ALWUUHLTHI), you will see: Disbursed Date = 04/11/2024, ACH Identifier = ANH65ALWUUHLTHI, Deposits = $480.90.

 

Report illustration

These images illustrate how the data is structured for various scenarios, providing a clear visual representation of deposits, disbursed dates, ACH identifiers, and payment sums relevant to each scenario.

Example #1

 

Example #2

 

Example #3

 

 

Was this article helpful?
0 out of 0 found this helpful