FedPayments® Reporter Service for FedACH® Services Report Descriptions
| 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. |
| 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 FedACH batches 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:
The report is available in an Excel spreadsheet format (XLSX). An advanced setup feature is available to limit/customize the report to:
|
| 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. If “All SEC Codes” is selected for the TXT format, the report will only include entries with addenda. If one or more SEC Codes are selected, only entries with addenda for the selected SEC Code(s) are included. If “All SEC Codes” is selected for the ACH format, the report will include entries with and without addenda. If one or more SEC Codes are selected, only entries with addenda for the selected SEC Code(s) are included. 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 an intraday, daily, weekly and 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. The report contains the same columns in the same order as the ACH Originated Entries Detail Report. This enables combining spreadsheets to view:
|
| ACH Originated Entries Detail Report (XLSX) | ODFI Originator |
This report provides selected key information for originated FedACH entries for the entire ODFI ABA and/or the information for a specified originator. The report can be automatically generated on a daily, weekly and 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 report may not align with FedACH billing. Scheduled formats supports up to 100,000 entries. On demand formats support up to 10,000 entries. The spreadsheet formats may be useful for many purposes, such as: identifying entries that settled Same Day, IAT reporting needs, identifying large volume/dollar customers, searching/sorting/summing/counting by available fields, creating charts and graphs. The report contains the same columns in the same order as the ACH Received Entries Detail Report. This enables combining spreadsheets to view:
|
| 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 can be automatically generated on an intraday or daily basis. On-demand options are also available. 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 Item File | Originator | This machine-readable Nacha-formatted file contains information for return items and operator rejected entries received by an originator. This straight-through processing (STP) option could result in significant time savings and error avoidance when compared to using the human-readable reports. Originators with compatible back-end systems can use this file to automatically apply their return item activity. An advanced setup feature is available to configure the file to meet specific needs of various back-end systems. The file can be scheduled on a daily basis to automatically scan for returns and an On-demand option is also available. |
| 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, and 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. |
| 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 and 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. |
| 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…). |
| Configuration Report (XLSX) | ODFI RDFI |
The configuration report is available at both the DFI and Customer-level. These complimentary reports provide information about parameters that have been established in the FedPayments Reporter Service for FedACH Services. Information shown in the reports includes names of subscribed reports, generation frequency, formats, delivery method, customer names, receiver account numbers, Originator IDs and email names/addresses. The reports may be valuable for operational, management, marketing, and audit purposes. The reports enable users to view and validate configuration information established in the service. For example, users can view the reports to determine if email addresses have been assigned to all subscribed reports and whether correct account numbers and Originator IDs have been established. Unlike other Scheduled and On Demand reports, the configuration reports are available from the “Report Information” tab in FedLine. To generate the report, use the download icon in the upper right portion of the screen. This will create an Excel-formatted report of the configuration information at the time report is generated. |