Aging Request for Payments Real-time Payments

How Aging RfP Data Flows Through RTP® and FedNow®

Every RfP you upload becomes a real-time trigger for payment—and a live update for your receivables report.

After a customer responds to your RfP via the FedNow® or RTP® rail, the transaction is settled in seconds. That action automatically updates your accounts receivable aging data. Whether you are monitoring 0–30, 31–60, or 90+ day overdue balances, your dashboard keeps a live pulse on what’s been paid and what remains open.

Excel downloads are available daily or on demand and include reconciliation references, payer aliases, timestamps, and transaction statuses.

Uploading, Downloading, and Automating RfP Reconciliation

Payee dashboards allow you to import structured XML or HTML RfP files and automate payment tracking without manual effort.

Each file is processed using ISO 20022 formats, ensuring clean, validated data with every submission. RfPs can be uploaded individually or in batch, and each includes a secure Hosted Payment Page that allows the payer to complete the transaction in seconds.

You can download full reconciliation logs, filtered by merchant ID, alias, aging status, or bank account—all without relying on spreadsheets or ACH delays.

Creating a spreadsheet to track the aging of digital invoicing requests for proposals (RfPs) and real-time payments (RTP) involves organizing data in a structured manner. Below is a simplified guide on how you can set up your spreadsheet:

1. Column Headers:

Start by creating column headers. Common headers for this scenario might include:

• Vendor Name: The name of the vendor submitting the RfP.
• Invoice Number: Unique identifier for each invoice.
• Invoice Date: Date when the invoice was issued.
• RfP Submission Date: Date when the RfP was submitted.
• RTP Status: Current status of the real-time payment (e.g., Pending, Approved, Processed).
• Aging Days: Calculated field to show the aging of the RfP or RTP.

2. Data Entry:

Input the relevant data for each invoice, including vendor name, invoice number, invoice date, RfP submission date, and RTP status.

3. Calculating Aging:

Create a formula to calculate the aging of each RfP. The aging can be calculated by subtracting the RfP submission date from the current date or by using the invoice date if RfP submission date is not applicable.

excelCopy code

=IF(ISBLANK([RfP Submission Date]), TODAY() - [Invoice Date], TODAY() - [RfP Submission Date])

This formula calculates the aging in days based on whether there is an RfP submission date or not.

4. Conditional Formatting:

Apply conditional formatting to highlight overdue RfPs or RTPs. For example, you can set up a rule to turn the background of the row red if the aging days are above a certain threshold.

5. Filtering and Sorting:

Enable filters to easily sort and view data based on specific criteria, such as vendor, RTP status, or aging days.

6. Charts and Graphs:

Create visualizations, such as bar charts or pie charts, to represent the distribution of RTP statuses or aging trends over time.

7. Regular Updates:

Regularly update the spreadsheet with new data as invoices progress through the RfP and RTP process.

Remember that the specifics may vary based on your exact needs and the features of your spreadsheet software. Adjust the column headers, formulas, and formatting options according to your requirements.

Get Real-Time AR Insight at TodayPayments.com

Don’t let outdated reporting slow down your collections.

✅ Upload, send, and track RfPs in real time using FedNow® and RTP®
✅ Export Excel-based AR aging reports at no cost
✅ Confirm payment completion with bank-grade reconciliation tools
✅ Use alias-based MIDs and Hosted Payment Pages to accelerate funding
✅ Eliminate manual aging tracking with 24/7 online access
✅ Onboard instantly—no bank visits, no hidden fees

Experience the power of real-time AR aging now at https://www.TodayPayments.com
Aging RfP RTP – Instant Payments, Instant Insight, Always Free.