Skip to main content

FedPayments® Reporter Service for FedACH® Services Report Descriptions

Read information on FedPayments Reporter Service for FedACH report descriptions below and click on an individual report for a sample report and more information.
Name Audience Description
ACH Customer Transaction Activity Report ODFI
RDFI
This report provides the types and numbers of reports, email deliveries and FedLine® Solution file deliveries generated for receivers and originators defined in the FedPayments Reporter Service for FedACH. This report may be valuable to DFIs that choose to charge their customers on a usage basis for reports generated. The reports are available in human-readable (PDF, TXT, HTML) formats. The FedInvent (Off-site)® system is available to convert this report into a spreadsheet.
ACH Death Notification Report RDFI This report converts and provides information for each death notification entry (DNE SEC code) received. DNEs are utilized by federal government agencies (e.g., Social Security Administration) to notify an RDFI that the recipient of a government benefit payment has died. RDFIs may find this information useful in helping them to meet the legal requirements associated with federal government benefit payments. Additional details are available at the FMS Green Book (Off-site).
The reports are available in human-readable (PDF, TXT, HTML) formats.
ACH International (IAT) Report Receiver
RDFI
This report converts and provides information for each forward IAT entry received. The report can be generated for specific receiver account numbers and/or for all International ACH Transaction (IAT SEC code) entries received by the RDFI. This report may be useful in helping to identify and understand the information in received IATs to assist in complying with the OFAC requirements associated with such entries. This report is eligible for incorporation of On-us Inclusion entries. The reports are available in human-readable (PDF, TXT, HTML) formats.
ACH Notification of Change Report ODFI
Originator
This report converts and provides information for each notification of change entry received (COR SEC code). The report provides information contained in the original forward entry along with the change information supplied by the RDFI. ODFIs may find this report useful in helping them comply with the NACHA rule requirements associated with these entries. ODFIs can establish this report for their originators in order to automatically share this information. The reports are available in human-readable (PDF, TXT, HTML) formats.
ACH Originated Batch Report (XLSX) ODFI This report provides detail level information for originated batches processed via FedACH® Services for the specified ABA. This report may be valuable to ODFIs to better understand and analyze information originated to FedACH® Services.

Some of the information shown in the report includes:
  • Date & Time (processed date, received date/time, effective entry date)
  • File ID Modifier
  • Batch number
  • Originator Name and ID
  • Same Day Information
    • An indicator to reflect if the batch contained entries that settled Same Day
    • Fields to identify why a batch processed as Same Day (date, time, SEC)
    • Credit and Debit dollar and entry counts
    • NACHA Entry Fee count
  • Category (forward/return)
  • SEC code
  • Dollar and entry counts for all, accepted, rejected, Same Day

The report is available in an Excel spreadsheet format (XLSX). An advanced setup feature is available to limit/customize the report to:

  • Include all batches or only batches containing entries that settled Same Day
  • Forward/return/all
  • Selected SEC codes
The report can be automatically generated on a daily or monthly basis. On-demand options are available for a single calendar month one or two months in the past, and for up to a 10 business day range within the previous 60 processing days. Scheduled reports supports up to 200,000 batches and on demand support up to 20,000 batches.
ACH Originator Setup Report ODFI This report provides selected batch level information to assist ODFIs in identifying originators that are receiving returns, operator rejects and NOCs. The report indicates whether or not the Company ID for the originator has been established in the FedPayments Reporter Service for FedACH. ODFIs may find this report useful in helping them identify originators that perhaps could be established in the service for automated generation of detailed return item and notification of change reports. The reports are available in human-readable (PDF, TXT, HTML) formats.
ACH Payment Data Information File Receiver This machine-readable file contains the raw payment-related information that may be contained in certain ACH addenda records. Receivers with compatible accounts receivable systems can use this file to automatically post and close open receivable items in their accounting systems. This straight-through processing (STP) option could result in significant time savings and error avoidance when compared to using the human-readable reports that require manual accounting entries.

Two machine-readable file options are available. The first is an as-is text extract of the Payment Data Information areas from the addenda records. The second is a fully NACHA-formatted file that contains the Payment Data Information along with entry and batch information.

These files are eligible for incorporation of On-us Inclusion entries. These files contain payment and prenotification entries. Returns and NOCs are excluded.
ACH Received Entries Detail Report (XLSX) RDFI
Receiver
This report provides selected key information for received entries for the entire RDFI ABA and/or the information for a specified receiver. The report can be automatically generated on a daily, weekly or monthly basis. On-demand options are also available. The human-readable formats (PDF, TXT, HTML) contain a few fields while the spreadsheet formats (XLSX, CSV) contain many more fields. An advanced setup feature is available to limit the report to specific entries: SEC codes, number of entries, forward, return, NOC, debit, credit, Same Day settlement. The receiver level report shows only forward entries, not returns and NOCs. This report is eligible for incorporation of On-us Inclusion entries. The report may not align with FedACH billing.

The spreadsheet formats may be useful for many purposes, such as retirement of an ABA, IAT reporting needs, identifying large volume/dollar customers, identifying entries that settled Same Day, searching/sorting/summing/counting by available fields, creating charts and graphs.

Scheduled CSV format supports up to 100,000 entries. Other scheduled formats support up to 50,000 entries. On demand formats support up to 10,000 entries.
ACH Receiver Setup Report RDFI This report provides selected information for forward entries received that contain addenda records for specific SEC codes. The report provides key information about forward entries that assists the RDFI in better understanding the accounts that could be established in the FedPayments Reporter Service for FedACH for automatic generation of reports. The report indicates whether or not the receiver account number has been established in the FedPayments Reporter Service for FedACH. The following SEC codes are scanned for this report: CCD, CIE, IAT, CTX, PPD, WEB, POS, DNE. This report is eligible for incorporation of On-us Inclusion entries. The reports are available in human-readable (PDF, TXT, HTML) formats.

The report may also be useful for marketing purposes as it allows the RDFI to easily identify receivers that have addenda records in their entries and therefore might benefit from reporting services.
ACH Remittance Advice Summary and Detail Reports Receiver
Originator
These reports convert and provide information from the ACH entries for each selected SEC code. The following SEC codes can be selected for this report:  CCD, CIE, CTX, PPD, WEB, POS.

These reports contain payment and prenotification entries. Returns and NOCs are excluded.

Provided the addenda records contain properly formatted EDI information, the information is shown in an easy-to-understand, human-readable format. The summary report selects a few key components that most receivers find essential while the detail report selects all of the obscure EDI information for the report. These reports are eligible for incorporation of On-us Inclusion entries for receiver-level information. The detail report contains the necessary information needed by health care providers.

Receivers and originators may find this information valuable in helping them easily understand the information that is exchanged between trading partners via the ACH network. Receivers can use this information to match payments to open accounts receivable entries. RDFIs may establish this report for their receivers as a way of meeting the NACHA rule requirements associated with these entries. ODFIs may establish this report for their originators to assist them with validation, tracking and auditing purposes. The reports are available in human-readable (PDF, TXT, HTML) formats.

Note that if the receiver has an accounts receivable system that can import a machine-readable file of this information, then perhaps the “Payment Data Information File” would be a more useful option.
ACH Return Item Report ODFI
Originator
This report provides information for return items and operator rejected entries received. The report provides information contained in the forward entry along with return information supplied by the RDFI, domestic ACH operator, or international ACH gateway operator. ODFIs may find this information useful in helping them easily understand information associated with returned items. ODFIs can establish this report for their originators in order to automatically share this information. The reports are available in human-readable (PDF, TXT, HTML) formats.
ACH Return Ratio Report ODFI
Originator
This report provides summary level information to help ODFIs and/or originators monitor return item activity. The report can be generated for originators and third party senders by specifying the Company ID(s) that are associated with that business entity. The report can be automatically generated on a daily, weekly, or monthly basis. ODFIs may find this report useful in helping them meet the NACHA return rate threshold rules. The report shows dollar and entry counts in total and by SEC codes. To assist in complying with the NACHA rule requirement, the report shows the percent of debit forward monetary entries returned.

This report reflects monetary entries occurring within the selected time period. Therefore, the original entries that resulted in the “Returned Items” represented in the report may not be represented in the “Originated Items” section of the report. Non-monetary entries (prenotification, NOCs, DNEs, ENRs…) are excluded from the counts. Dishonored returns are included in the counts.

A configurable option directs the report to review up to 60 previous calendar days or two calendar months of activity and summarizes a number of key fields. Other configurable options allow the DFI to request separate report pages to show returns categorized as unauthorized, invalid/admin, all, and any specified return code(s) of interest. The DFI can also configure the report to be suppressed if no return items are identified.

Another configurable option allows a page to be generated that shows all unique company names encountered during the reporting period selected. This could be helpful in identifying originators that use a single Company ID to originate for different companies.

The reports are available in human-readable (PDF, TXT, HTML) formats. The FedInvent (Off-site)® system is available to convert this report into a spreadsheet.
ACH Return Reason Report (XLSX) ODFI
Originator
This report provides summary level information of return reason codes by Originator for returned entries processed via FedACH® Services. Information shown in the report includes:  Originator ID, Originator Name, Unique Originator Names Returned, Debit Returned Amount, Total Return Count, Unauthorized Return Count, Invalid/Admin Return Count, and return counts by the various individual return reason codes (R01 to R85). The reports are available in human-readable (PDF, TXT, HTML) and spreadsheet formats (XLSX, CSV). More fields are available with the spreadsheet format vs. the human-readable formats. The Originator Name will be blank if the corresponding Originator ID has not been established in the FedPayments Reporter Service for FedACH or has been entered incorrectly. A blank may also help identify Originator IDs that are flowing through FedACH that could perhaps be setup in the service.

Options are available to show information at the entire ABA level or limit the information to a particular originator. The report can be automatically generated on a daily, weekly or monthly basis. On-demand options are available for the previous month, for current month-to-date, and for up to a 10 business day range within the previous 60 processing days.

Custom configuration options support various return inclusion/exclusion and sorting options. A custom configuration option is available that aligns with the NACHA unauthorized entry fee rule.
ACH Routing Number Activity Report ODFI
RDFI
This report provides summary level information for originated and received entries processed via FedACH® Services for the specified ABA. The scheduled report is generated on the first business day of the month and shows information for the previous month and calendar year-to-date. The report can also be generated on demand for any one of the previous three months. The information reflected corresponds with FedACH process dates.

The summary level information includes:  entry counts, addenda counts, forward entries, returned entries, NOC entries, prenotification entries, enrollment (ENR) entries, operator rejects, dollar values, debits, credits, commercial and government entries and originated and received entries.

The report may not align with FedACH billing statements because certain entries, like operator rejects and reversals, are not currently billed. The reports are available in human-readable (PDF, TXT, HTML) formats. The FedInvent® (Off-site) system is available to convert this report into a spreadsheet. This may be helpful to view the information across multiple RTNs and multiple months.
ACH Social Security Beneficiary Report Receiver This report converts and provides information from multiple PPD and PPD+ entries from selected federal government originators into one easy-to-understand report. If, for example, the receiver is an extended care or child guardian facility, they likely receive many Social Security beneficiary payments for representative payees under their care. The reports are available in human-readable (PDF, TXT, HTML) formats.

Note that if the receiver has an accounts receivable system that can import a machine-readable NACHA-formatted file of this information, then perhaps the “Payment Data Information File” would be a more useful option.
ACH Volume Summary by SEC Code Report ODFI
RDFI
Originator
Receiver
This report provides summary level information for originated and received entries processed via FedACH® Services for the specified ABA. In addition to showing information at the entire ABA level, the report can be generated to limit the information to a specified originator/receiver. The information reflected corresponds with FedACH process dates. The report may not align with FedACH billing statements because certain entries, like operator rejects and reversals, are not currently billed.

This scheduled report is generated on the first business day of the month and shows information for the previous month. The report can also be generated on demand for any one of the previous three months or for current month-to-date information. The reports are available in human-readable (PDF, TXT, HTML) formats.

The report shows credit and debit dollar totals, entry counts and addenda counts by each SEC code. Multiple report pages are produced to show information by various categories such as originated and received, originated only, received only, returns originated, returns received, operator rejects, and non-monetary entries (prenotification, NOCs, DNEs, ENRs…).

Top of Page