Aging Request For Pay


TodayPayments.com is the go-to U.S. fintech platform for automating aging Request for Pay cycles using ISO 20022 messaging, alias-driven invoicing, and real-time payment settlement.
We help businesses eliminate overdue AR using digital invoicing, push/pull payment logic, reconciliation templates, and full interoperability with FedNow®, RTP®, ACH, and card systems.

Whether your challenge is chasing payments, reconciling manually, or collecting at scale, TodayPayments.com brings everything together in one intelligent platform.

 

Aging Request for Pay (RfP): Automate Overdue Payments and Clear Invoices Faster

Mobile Request for Payment Aging receivables can choke your cash flow and bury your accounting team in manual follow-ups. But there’s a better way forward — one that leverages ISO 20022 Request for Pay (RfP) standards, real-time settlement, and automation tools to reduce friction, accelerate payments, and clear your books faster.

At TodayPayments.com, we help businesses eliminate slowdowns in their accounts receivable cycle by digitizing Aging Request for Pay workflows, supporting FedNow®, RTP®, and ACH, and offering free reconciliation templates to simplify the back end. From overdue invoices to recurring payments, we bring structure, speed, and certainty to every transaction.


If you’re tracking aging invoices manually or relying on outdated ACH systems, it’s time to upgrade. Using ISO 20022-compliant RfP messaging and alias-based invoicing, TodayPayments.com lets you send secure, digital payment requests and receive real-time confirmation through FedNow®, RTP®, or Same-Day ACH.

Key Features:

  • Send one-time or batch RfPs using .Excel, .XML, or JSON
  • Include secure .html payment links in mobile, text, or email delivery
  • Accept payments through FedNow®, RTP®, ACH, or credit card fallback
  • Use alias identifiers (email or phone) instead of bank account details
  • Validate payees with Confirmation of Payee
  • Route payments with push or pull logic, ensuring “Good Funds” settlement

Free Bank Reconciliation Templates to Match Aging RfPs and Payments

One of the biggest challenges with aging receivables? Manual reconciliation. That’s why we created free Excel-based bank reconciliation templates tailored for businesses of all sizes. These worksheets help match incoming transactions to aging RfPs, providing a clear, structured view of what’s been paid — and what hasn’t.

What You Get:

  • Pre-built Excel templates for AR and reconciliation
  • Automated payment matching by invoice ID or alias
  • Real-time updates from cleared FedNow® or RTP® payments
  • Full audit trail and reporting for finance teams
  • Faster cash forecasting and cleaner accounting books

These templates are included free for every TodayPayments.com user — no extra cost, no setup fee.

 FREE Real-Time Payments Bank Reconciliation%
"FREE" RfP Aging & Real-Time Payments Bank Reconciliation – with all merchants process with us. Real-Time Payments Bank Reconciliation


Why Aging Invoices Deserve Real-Time Tools

Traditional RfP systems lack the speed and automation needed to reduce aging cycles. With TodayPayments.com, every payment request is intelligent, mobile-ready, and linked to real-time networks that confirm receipt in seconds.

Built for:

  • B2B and C2B receivables
  • High-volume invoicing and batch settlements
  • Alias-based identity (no sensitive bank data required)
  • ISO 20022 RfP messaging for structured digital invoicing
  • Instant confirmation with FedNow® and RTP®
  • ACH fallback options and hosted payment pages

 

Creating an Aging Request for Pay (RfP) spreadsheet involves tracking and displaying the status of payment requests over time. Typically, aging reports break down outstanding payment requests into different time periods, such as 30 days, 60 days, 90 days, and beyond. Here's a simple guide on how to set up an Aging RfP spreadsheet:

Spreadsheet Columns:

  1. Vendor/Requester Name:
    • Identify the entity or individual making the payment request.
  1. Invoice/Request Number:
    • Unique identifier for each payment request.
  1. Invoice/Request Date:
    • Date when the payment request was initiated.
  1. Due Date:
    • The date by which the payment is expected.
  1. Amount Requested:
    • The total amount requested for payment.
  1. Payment Date:
    • Date when the payment is made.
  1. Days Outstanding:
    • Automatically calculated field (Payment Date - Due Date) to determine how many days the payment is overdue.

Spreadsheet Formulas:

  1. Days Outstanding Formula:
    • Create a formula in the "Days Outstanding" column to calculate the number of days the payment is overdue. Use a formula like: =IF(ISBLANK([Payment Date]), TODAY() - [Due Date], [Payment Date] - [Due Date]).

Aging Buckets:

  1. Current (0-30 days):
    • Use conditional formatting to highlight payments that are within the current period.
  1. 30-60 Days:
    • Apply conditional formatting to highlight payments that are 30 to 60 days overdue.
  1. 60-90 Days:
    • Apply conditional formatting to highlight payments that are 60 to 90 days overdue.
  1. 90+ Days:
    • Apply conditional formatting to highlight payments that are more than 90 days overdue.

Summary Section:

  1. Total Amount Outstanding:
    • Sum the amounts for all outstanding payment requests.
  1. Average Days Outstanding:
    • Calculate the average number of days outstanding for all payment requests.

Visualization:

  1. Graphs/Charts:
    • Create charts to visually represent the aging of payment requests over time.

Regular Updates:

  1. Update Information:
    • Regularly update the spreadsheet with new payment requests, payment dates, and any other relevant information.

Example Structure:

Vendor

Invoice Number

Invoice Date

Due Date

Amount Requested

Payment Date

Days Outstanding

ABC Inc

INV001

2023-01-15

2023-02-15

$1,000.00

2023-02-20

=IF(ISBLANK(F2), TODAY() - D2, F2 - D2)

This structure allows you to track and manage the aging of payment requests effectively. Customize it based on your specific needs and the level of detail you require for your financial tracking.

Aging Invoices? Let’s Fix That — Fast.

Tired of juggling spreadsheets, chasing clients, or waiting days for funds to settle?
TodayPayments.com delivers the future of receivables — structured, verified, and real-time.

Send digital RfPs using ISO 20022
Accept FedNow®, RTP®, ACH, or card payments
Use alias-based invoicing for better security
Validate payees with Confirmation of Payee
Reconcile instantly with free Excel templates
Clear your AR with real-time Good Funds settlement

👉 Start reducing aging receivables today at TodayPayments.com — and get paid faster, smarter, and with complete reconciliation.

ACH and both FedNow Instant and Real-Time Payments Request for Payment ISO 20022 XML Message Versions.
The versions that NACHA and The Clearing House Real-Time Payments system for the Response to the Request are pain.013 and pain.014 respectively. Predictability, that the U.S. Federal Reserve, via the FedNow ® Instant Payments, will also use Request for Payment. The ACH, RTP® and FedNow ® versions are "Credit Push Payments" instead of "Debit Pull.".

Reconcile invoices with our Aging Request For Pay Solutions


Activation Dynamic RfP Aging and Bank Reconciliation worksheets - only $49 annually

1. Worksheet Automatically Aging for Requests for Payments and Explanations

- Worksheet to determine "Reasons and Rejects Coding" readying for re-sent Payers.
- Use our solution yourself. Stop paying accountant's over $50 an hour. So EASY to USE.
- No "Color Cells to Match Transactions" (You're currently doing this. You won't coloring with our solution).
- One-Sheet for Aging Request for Payments (Merge, Match and Clear over 100,000 transactions in less than 5 minutes!)
- Batch deposits displaying Bank Statements are not used anymore. Real-time Payments are displayed "by transaction".
- Make sure your Bank displaying "Daily FedNow and Real-time Payments" reporting for "Funds Sent and Received". (These banks have Great Reporting.)

2. Bank Reconciliation with as Payee FedNow & Real-Time Payments for Accrual, Cash and Hybrid Basis and QBO - Undeposited Funds

Each day, thousands of businesses around the country are turning their transactions into profit with real-time payment solutions like ours.



Contact Us for Request for Payment payment processing