FedNow Send Transactions Outstanding

TodayPayments.com empowers businesses to not only send and receive FedNow® payments, but to also manage and automate accounts receivable in real-time — thanks to downloadable, structured payment files.

🔄 Instant Tracking of Sent & Outstanding Transactions

Download transaction data filtered by date, client, invoice number, or status — see what’s unpaid or pending instantly.

🧾 Automated Aging Reports

Group aging receivables into custom date ranges (0–30, 31–60, 61–90, 90+ days) using ISO 20022 metadata from JSON/XML files.

💡 Centralized Dashboard for DSO Visibility

Whether you're sending via FedNow® or RTP®, all outstanding transactions appear in one interface for simplified financial forecasting.

📤 Upload Back Into Bank or FinTech Portals

Reconcile transactions by uploading updated payment files back into your system — complete with aged status and comments.

From FedNow® Speed to Financial Strategy: Interoperability is the Key

Speed is only part of the solution. What businesses need now is interoperability across rails — with clear, downloadable data that drives measurable improvements in DSO and cash management.

TodayPayments.com ensures your operations are:

• Network-agnostic — Compatible with FedNow® and RTP®
• Data-driven — Using ISO 20022-rich files to support audit and compliance
• Forward-looking — Focused on real-time receivables automation

Regardless of the rail, format, or transaction type, your business can view, download, and act on send transactions like never before.

Calculating FedNow Send Transactions Outstanding in an Excel template involves tracking and managing payment transactions sent through the FedNow service. Below is a general guide on how you might set up an Excel template to monitor and analyze outstanding FedNow transactions:

1. Data Setup:

1. Headers:

• Create column headers in Excel for essential information, such as Transaction ID, Sender's Name, Amount, Send Date, Expected Settlement Date, and Transaction Status.

2. Data Entry:

• Enter the details of each FedNow transaction into the respective columns.

2. Status Tracking:

3. Transaction Status:

• Include a "Transaction Status" column to track whether the transaction is outstanding, settled, or voided.

3. Calculate Outstanding Transactions:

4. Calculate Days Outstanding:

• Create a "Days Outstanding" column to calculate the number of days each transaction has been outstanding. Use a formula like:

excelCopy code

=IF([Transaction Status Cell] = "Outstanding", TODAY() - [Send Date Cell], 0)

4. Categorize Outstanding Transactions:

5. Age Categories:

• Create age categories based on the days outstanding, such as "Current," "1-30 Days," "31-60 Days," etc. Use IF statements or VLOOKUP to categorize transactions.

5. Analysis and Reporting:

6. Total Outstanding Amount:

• Create a formula to calculate the total outstanding amount. Use the SUMIFS function to sum amounts based on age categories.

7. Charts and Graphs:

• Use charts or graphs to visualize the distribution of outstanding transactions based on age categories.

6. Automation and Alerts:

8. Conditional Formatting:

• Apply conditional formatting to highlight overdue transactions or specific age categories for better visualization.

9. Automated Alerts (Optional):

• If using Excel for real-time monitoring, set up automated alerts or notifications when transactions are overdue or meet certain criteria.

7. Regular Updates:

10. Data Entry Updates:

• Regularly update the Excel template with new FedNow transactions and mark settled or voided transactions accordingly.

8. Documentation and Audit:

11. Documentation:

• Keep a record of transactions, updates, and any adjustments made for audit and reference purposes.

9. Integration (if applicable):

12. Integration with FedNow System:

• Explore integration options with the FedNow system or any associated APIs for real-time data updates.

Remember that the specific columns and formulas may vary based on your unique requirements and data structure. Additionally, it's important to regularly reconcile your Excel template with the actual FedNow transaction data to ensure accuracy. If there are changes or updates to the FedNow service, you may need to adjust your Excel template accordingly.