Drake Tax – Online Reports – Overview

Drake Tax logo

Last Updated:

Article #: 10800


Overview

You can get information about the status of electronically filed returns in real-time online. You can run reports on returns, bank products, checks, and fees; search for e-file information for a single SSN or EIN; access Multi-Office Manager (MOM) reports; view Client Status Manager (CSM) data for one or multiple offices; and check the status of each IRS Service Center. To do so, log in to the Drake Software Support website with your User Account credentials. Expand the Reports menu, and choose from the available reports. Additional details for each report type are available by expanding the list for that report. Filters and other settings and options vary for the report selected.

Note Users must have the correct report access configured to run online EF reports. See Drake Tax – Online Reports – Configure Access or Permissions.

Available Reports

  • Add-on Fees

  • E-file Status Lookup

    • Search by last name, SSN or EIN. Only information about the filer’s return e-file status is displayed (for example, shows Federal 1040 Accepted 1/1/2026, Refund $200.00). More detailed return data is displayed when running the Returns report (below). For a more in-depth review of a single return, use E-file Detail Lookup.

  • Returns

    • Allows you to list pending, accepted, and rejected state and federal returns, as well as extensions. Queries can be limited to a date range, data can be sorted, and filters can be saved for future reference. Once the query is submitted, you can search by name and the results display more detailed information regarding transmissions. You can also choose to print the taxpayer results, including the submission ID, and get Form 9325 from this report.

  • Bank Products

    • Queries can be limited to a date range, data can be sorted, and filters can be saved for future reference.

  • Checks

    • Allows reporting on checks by check status (printable, pending, and cleared). Queries can be limited to a date range, data can be sorted, and filters can be saved for future reference.

  • Fees

    • Reports on all of the fees (prep fees, bank fees, etc.) that are charged throughout a transaction. Reports may be filtered by fee type and by date.

  • MOM

    • The MOM Menu is for Multi-Office Manager (MOM) reports. MOM is the online version of the Client Status Manager. It is designed for the multi-office environment and allows you to track the work flow of multiple offices, providing a snapshot of your entire business.

    Note Companies with multiple EFINs that wish to use MOM must have an EFIN hierarchy configured and the individual offices must set the software to transmit CSM data (Setup > Options > EF tab; under Session Options, select Transmit return data to Drake for multi-office web reports, and click OK to save changes).

  • Contact List Report

    • Creates a report containing contact information for your clients; filtered by date and return type.

  • 94X Report

    • Refers to 94x filings made from Drake Accounting. Reports are filtered by date, return type, and status.

  • ABC Voice File Download

    • is a component of software used to provide automated phone status reports for tax preparers (for more information, call Versicom at (937) 438-3700).

    Note If using ABCvoice, go to the ABCV screen in Drake Tax and indicate whether the taxpayer has signed the Consent to Use and Disclosure of Tax Return Information.

  • Suppressed Returns

    • Any suppressed returns will be listed here. Reports are filtered by tax year.

  • EF Summary

  • Preparer Summary

  • Zip Code Summary

  • Returns Summary

  • Returns by ACK Summary

  • Reject Overview

  • Protection Plus Enrollments

    • View or export a .CSV file of all Protection Plus enrollments.

  • Protection Plus Summary

    • View a summary of your Protection Plus account.

Note EF Summary, Preparer Summary, ZIP Code Summary, Returns Summary, Returns by ACK Summary, and Reject Overview reports are filtered by date.

Viewing a Report

  1. From the Drake Software Support website, click Reports, then a category.
  2. Select report criteria or filters (criteria vary by report type). The report pulls information from only those returns with records that fall within the date range and other criteria you selected.
  3. Click Search.

Click Spreadsheet or Print to export a report in worksheet format (suitable for Microsoft Excel) or to print the report.

Saving, Editing, and Deleting Report Filters

Saving report filters

  1. Select a report category.
  2. Choose the report criteria.
  3. Click Save. Enter a name for the report filter, and click Save again.
  4. Click OK.

To run a saved filter later, select the report name from the Saved Filters drop list.

Editing or deleting filters

To edit a filter, select it from the Saved Filters drop list, make your changes, click Save, then click Save again (without changing the name) to overwrite the current filter. Click OK when finished.

To delete a filter, select it from the Saved Filters drop list, click Delete, click Yes to confirm, then click OK.

Report Column Definitions

The following selections are available in online database reports. Not all selections are available for all reports.

Column Title Description
Accts
Paid
The number of federal individual return
transmissions where some preparer fees were deposited
ACK Code The status of the
return
Ack Date The date of the return
acknowledgment as specified by the IRS/state
Acptd The number of accepted federal returns
Acptd Fed The number of
accepted federal return transmissions
Acptd
Pct
The percentage of federal individual
return transmissions that were accepted that transmission
Add-On Fee The add-on fee
deposited for this return
Address The address of
the primary and secondary (if applicable) taxpayer(s)
Amount The date when the ERO transmitted the return to Drake
Software
Amount The date when the
ERO transmitted the return to Drake Software
AOF
Accts Paid
The number of federal individual return
transmissions where fees were paid and add-on fees were completely paid
AOF
Under Funded
The number of federal individual return
transmissions where fees were paid and add-on fees were not completely paid
Avg
Fee
Average Fees deposited, calculated by
dividing Fees Deposited by Accounts Paid
Avg Refund The average
refund amount for accepted or rejected federal return transmissions
Avg Refund The average
refund of the above returns
Bank The number of accepted federal return
transmissions with an associated bank product
Bank
Acptd
The number of accepted federal returns
with accepted bank products
Bank
Pct
The percentage of the accepted federal
individual return transmissions with an associated bank product
Bank
Pct Acptd
The percentage of accepted federal
returns with bank products that Prep Avg Fee accepted bank products
Bank Product The current bank product associated
with the return
Bank
Total
The number of accepted federal returns
with bank products
Bill Total The bill total of the return
Bill Total The Bill Total of
the return
Cell Phone Cell Phone Number
City City
Clear Date The date when the
bank cleared the check
Current Type The type of bank
product offered
DCN The Declaration Control Number
DD Date The date when the
preparer fees for this return were deposited
Deposits The total amount
deposited thus far for this bank product
EFIN The Electronic
Filing Identification Number
Email Address The email address
of the primary taxpayer
Fees The sum of the preparation fees,
document preparation fees, and e-filing fees
Fees
Dpstd
The sum of the deposited preparers’ fees
Hide Return Hide return from
search results
Last 4 SSN The last four digits of the primary
taxpayer’s Social Security Number
Loan Status The status of the
bank product
Name The name(s) of the primary and
secondary (if applicable) taxpayer(s)
Number Check Number
Number The check number
Original Type The type of bank
product requested
Pct
Acptd
The percentage of the Total Returns that
were accepted
Pending The number of pending federal returns
that were not accepted in the specified date range
Phone 1 Phone 1 number
Phone 2 Phone 2 number
Potential
Rev
Potential Revenue, calculated by
multiplying Average Fee by Number Accepted
Prep The Preparer ID
Prep
Accts Paid
The number of accepted federal returns
with preparers’ fee deposits
Prep
Acptd Pending Total
The sum of preparation fees, document
preparation fees, and e-filing fees for accepted and pending federal returns
Prep
Acptd to Pending
The percentage of preparers’ fees
associated with accepted federal returns versus the preparers’ fees
associated with accepted and pending federal returns
Prep
Avg Fee
The average preparation fee, calculated
by dividing the Prep Total by the Bank Total
Prep
Dpstd
The sum of preparers’ fees deposits
associated with accepted federal returns
Prep Fees The sum of the
deposited preparers’ fees
Prep
Pending Total
The sum of the preparation fees,
document preparation fees, and e-filing fees associated with pending federal
returns
Prep
Total
The sum of preparation fees, document
preparation fees, and e-filing fees for accepted federal returns
Preparer Fees The preparers
fees deposited for this return
Print Date The date when the
check was printed
Prior Number The number
associated with the prior check if this check is a reprint
Ratio The percentage of
the hierarchy’s deposited preparers’ fees that this preparer received
Ratio The percentage of
the hierarchy’s total refund that this ZIP code receives
Record Type The record type
of the return:
0 – Fed individual (1040-type)
1 – State individual (includes state individual extensions)
2 – No longer used
3 – Federal extensions
4 – Fed and state business
5 – FBAR/FinCen
Refund Amount The refund amount
of the return
Refunds The sum of the
refunds
Reject Code #1 The reject code for the return
Reject Code #2 The second reject code for the return
Reject Code #3 The third reject code for the return
Reprint Count The number of
times the authorized check disbursement has been reprinted
Returns The number of
returns
Rjctd The number of federal returns that were
not accepted in the specified date range
Service Bureau Fees The service
bureau’s fees deposited for this return
SSN Last 4 The last four
digits of the primary taxpayer’s Social Security Number
State State
Tax Year The tax year of the return
Total The total number of federal individual
return transmissions that were accepted or rejected
Total
Returns
The total number of federal returns
transmitted
Trans Date The date when the
ERO transmitted the return to Drake Software
Transaction Date The date when the
ERO transmitted the return to Drake Software
Type  The type of return
ZIP ZIP code