Reconcile Checks Outstanding with ISO 20022 & Real-Time RfP

Streamlined Aging RfP Invoicing for B2B & C2B Billing

The Aging Request for Payments (RfP) process enables businesses to notify payers about invoices 15, 30, 60, or 90+ days past due. With TodayPayments.com, you can:

• Digitally send invoices via text, email, or mobile link
• Customize messages with concise 140-character payment summaries
• Embed secure hosted hyperlinks to full merchant payment pages
• Schedule one-time or recurring batch uploads using ISO 20022 formats

This solution simplifies both your communication flow and your collections process—ensuring no invoice goes unnoticed.

Batch Uploads, Smart Reporting & Free Reconciliation Templates

TodayPayments.com delivers a full suite of tools designed for AR, finance, and compliance teams:

• Batch upload capabilities using Excel, XML, or JSON for large-scale RfP invoicing
• Real-time downloadable reports for tracking responses, payment statuses, and reconciliation
• Free, customizable templates for:
  • Aging Accounts Receivable (AR) Worksheets
  • Checks Outstanding Reconciliation Reports
  • Bank Matching for RfP Settlements

To support merchants and finance teams of all sizes, TodayPayments.com offers free downloadable templates, including:

• Aging Accounts Receivable Worksheet: Pre-built with 15, 30, 60, 90+ day tracking
• Bank Reconciliation Templates: Instantly match payments with deposits across batches
• ISO 20022 File Format Samples: Plug-and-play structures for batch uploads and RfP message testing

Built for scale, speed, and smart finance automation.

If you are looking to reconcile outstanding checks using a template in software like QuickBooks or Excel, here's a general guide on how you can go about it:

1. Data Collection:

1. Gather Data:

• Collect information about outstanding checks from your bank statements, accounting software (e.g., QuickBooks), or any other source.

2. Create a Reconciliation Template in Excel:

2. Headers:

• Create column headers for necessary information such as Check Number, Check Date, Payee, Amount, and Status.

3. Data Entry:

• Enter the details of each outstanding check into the respective columns.

3. Check Status:

4. Check Status Column:

• Include a "Status" column to indicate whether the check is outstanding, void, or cleared.

5. Status Update:

• Update the status of each check as you reconcile them with the bank statement.

4. Reconciliation Process:

6. Bank Statement Comparison:

• Compare the information in your reconciliation template with the corresponding entries in your bank statement.

7. Mark Cleared Checks:

• As you identify cleared checks in the bank statement, mark them as cleared in your template.

8. Voided Checks:

• Identify any voided checks and mark them accordingly.

5. Analysis and Adjustment:

9. Discrepancies:

• Investigate and resolve any discrepancies between the reconciliation template and the bank statement.

10. Adjustments:

• Make any necessary adjustments to your accounting records or the reconciliation template to ensure accuracy.

6. Record-Keeping:

11. Documentation:

• Keep a record of the reconciliation process, including any adjustments made.

12. Reconciliation Reports:

• Generate reconciliation reports if available in your accounting software.

7. Using QuickBooks for Reconciliation:

13. QuickBooks Reconciliation:

• In QuickBooks, navigate to the "Banking" menu and select "Reconcile."
• Enter the bank statement details and compare with your QuickBooks records.
• Mark outstanding checks as cleared in the reconciliation window.

8. Final Steps:

14. Save and Update:

• Save your reconciliation template and update it regularly as new checks are issued or cleared.

15. Regular Reconciliation:

• Perform check reconciliation regularly to keep your financial records accurate.

9. Automation (if available):

16. Automation in QuickBooks:

• Explore automation features in QuickBooks that can streamline the reconciliation process.

17. Import/Export:

• If using Excel, consider importing/exporting data between Excel and your accounting software.

Remember to customize the template and reconciliation process based on your specific needs and the features available in your accounting software. Always refer to the latest documentation for the software you are using for any specific functionalities or updates related to reconciliation.

Stop chasing down old checks and overdue invoices. With TodayPayments.com, you can reconcile outstanding checks, automate RfP invoicing, and track everything—digitally, instantly, and securely. Use ISO 20022 messaging, aliases, and mobile invoicing to stay in control.

👉 Get your free reconciliation and aging AR templates now.
🚀 Visit https://www.TodayPayments.com and upgrade how you invoice, reconcile, and report—today.