FedNow Bank Reconciliation

Digital AR Aging Meets Real-Time Reconciliation: Undeposited Funds, QBO, and More

Accounts receivable aging is no longer just a back-office report—it's a real-time dashboard when powered by FedNow® and RTP®. TodayPayments.com enables your AR team to track aging in real time, update ledgers automatically, and process payments with full visibility into transaction status.

💼 Whether you're operating on:

• Cash basis (revenue recognized when received)
• Accrual accounting (revenue recognized when invoiced)
• Or leveraging QuickBooks Online (QBO) workflows with undeposited funds,

our system connects every RfP with rich reconciliation data so your books stay accurate to the second.

Send and Receive RfPs via Mobile, Texting, and Digital Invoicing

Today’s business environment demands flexibility. TodayPayments.com delivers RfP capabilities over:

• 📲 Mobile apps
• 💬 SMS/text message links
• 📧 Digital invoicing portals

Customers receive a clear payment request, with one-click approval and instant settlement. Each transaction is backed by structured ISO 20022 data and pushed to your team in .Excel, .XML, or JSON formats for streamlined accounting, compliance, and audit trails.

The result? Full payment transparency, zero ambiguity, and funding certainty in seconds—not days.

Bank reconciliation in a spreadsheet for FedNow transactions involves creating a structured workflow to track and reconcile transactions accurately. Below is a guide on how you can use a spreadsheet for FedNow Bank Reconciliation considering different accounting methods (Accrual, Cash, Hybrid) and incorporating Undeposited Funds for Request for Instant Payments.

Spreadsheet Structure:

1. Main Transaction Sheet:

• Set up a sheet with columns for essential details:

• Date: Transaction date.
• Payee: Name of the payee or vendor.
• Invoice Details: Reference to the invoice or purpose of payment.
• Amount: Transaction amount.
• FedNow Transaction Reference: A unique identifier for FedNow transactions.
• Accounting Method: Specify whether the transaction is Accrual, Cash, or Hybrid.
• Payment Status: Track whether the payment is pending, in progress, or completed.

2. Undeposited Funds Sheet:

• Create a separate sheet to track Undeposited Funds:

• Date: Date funds were received.
• Amount: Amount of funds received.
• Status: Indicate whether funds have been deposited.

3. Bank Reconciliation Sheet:

• Set up a Bank Reconciliation sheet to mirror your actual bank statements:

• Date: Transaction date.
• Description: Brief description of the transaction.
• Withdrawals: Amount withdrawn from the bank.
• Deposits: Amount deposited into the bank.
• Balance: Current balance after each transaction.

Workflow:

1. Transaction Entry:

• Enter each FedNow transaction into the main transaction sheet, specifying the accounting method and payment status.

2. Undeposited Funds Management:

• Record funds received in the Undeposited Funds sheet. Update the status when funds are deposited.

3. Reconciliation:

• Regularly update the Bank Reconciliation sheet based on your actual bank statements. Match transactions recorded in your spreadsheet with those on the bank statement.

4. Accrual, Cash, Hybrid Handling:

• Use the Accounting Method column in the main sheet to differentiate between Accrual, Cash, and Hybrid transactions.

5. Payment Status Update:

• Regularly update the payment status in the main sheet based on the progress of FedNow transactions. Use conditional formatting or formulas for visual cues.

Notes:

• Consistency is Key: Maintain consistency in updating all relevant sections of the spreadsheet.
• Automation: Explore spreadsheet automation options to streamline updates and calculations.
• Security Measures: Protect sensitive financial information by implementing access controls and securing your spreadsheet.

This approach allows you to manage FedNow transactions comprehensively within a spreadsheet environment. Customize the structure based on the specific needs of your organization. Keep in mind that while spreadsheets offer flexibility, dedicated accounting software may provide more advanced features and automation for handling transactions.

Real-Time Payments with Built-In Reconciliation—Only at TodayPayments.com

Why settle for disconnected payment systems or generic accounting files?

At TodayPayments.com, we bring the power of real-time payments together with in-house reconciliation precision:

📈 Stop guessing when the money will arrive. Start knowing—with TodayPayments.com.

👉 Visit TodayPayments.com and bring clarity, speed, and certainty to every payment you send or receive.