QBO QuickBooks ^® Create FedNow Files

To streamline the process of creating recurring FedNow payment files using QuickBooks Online (QBO) integrated through SecureQBPlugin.com, you can utilize .csv templates tailored for either static or variable transaction amounts. Below are the recommended .csv templates and instructions for using them.

Step 1: Integrate SecureQBPlugin with QBO

1. Install SecureQBPlugin:

• Visit SecureQBPlugin.com and download the plugin.
• Follow the instructions to integrate the plugin with your QBO account.

2. Configure the Plugin:

• Open the SecureQBPlugin and log in using your QBO credentials.
• Configure the plugin to allow data extraction for payment transactions.

Step 2: Export Payment Data from QBO Using SecureQBPlugin

1. Access Payment Data:

• Use the SecureQBPlugin to access the necessary transaction data from QBO.
• Filter transactions by date range and type as needed (e.g., customer payments, vendor payments).

2. Export Data:

• Export the filtered payment data to an Excel file (.xlsx) using the plugin.

Step 3: Create .csv Templates for FedNow Payments

Static Amount Transactions Template

For transactions with fixed amounts:

1. Open the Exported Excel File:

• Open the exported .xlsx file in Microsoft Excel or Google Sheets.

2. Enter Static Data:

• Fill in the static payment data as required.

3. Save Template:

• Save the file as StaticFedNowTemplate.csv.

Variable Amount Transactions Template

For transactions with varying amounts:

1. Open the Exported Excel File:

• Open the exported .xlsx file in Microsoft Excel or Google Sheets.

2. Enter Data (Leave Amount Column Blank):

• Fill in all data except for the amounts, which will be entered as needed.

3. Save Template:

• Save the file as VariableFedNowTemplate.csv.

Step 4: Use Templates for Recurring FedNow Payments

1. Open Template:

• Open your static or variable template in Excel.

2. Update Payment Date:

• Ensure the payment date is current.

3. Enter Variable Amounts (if applicable):

• For variable templates, enter the transaction amounts in the Amount column.

4. Save as CSV:

• Save the updated file as FedNowPayments.csv.

Step 5: Upload the CSV File to Your Bank’s Dashboard

1. Log in to Your Bank’s Online Portal:

• Navigate to the FedNow payment section.

2. Upload CSV File:

• Select and upload the FedNowPayments.csv file.

3. Review and Submit:

• Review the uploaded data for accuracy and submit it for processing.

Tips for Maintaining Templates

• Regular Updates: Keep templates updated with any changes to account or routing numbers.
• Validation: Regularly validate the data to ensure compliance with FedNow requirements.
• Backup: Maintain backups of your templates to prevent data loss.

By following these steps and using the provided templates, you can efficiently manage recurring FedNow payments through QuickBooks Online integrated with SecureQBPlugin.com, ensuring accuracy and consistency in your transactions.