The Projected EFT Report is designed to give you a clear overview of the expected recurring payment revenue from memberships over the next 30 days. This report is a valuable tool for businesses relying on automated payments, helping them anticipate and manage cash flow effectively.
The report is updated weekly, every Sunday at 7:00 am Central Time, ensuring that you always have the most current data to plan.
How to Generate Your Projected EFT Report
To access your Projected EFT Report, follow these steps:
On your left-hand menu, go to the Billing tab.
Click on Reports.
Select Projected EFT by clicking the View Report button.
Report Overview: Three Key Summaries
The Projected EFT Report is broken down into three easy-to-understand summaries:
Grand Total: Displays the total revenue expected from all recurring payments for the entire 30-day period.
Page Total: Provides the total revenue for the current page being viewed. If your report spans multiple pages, this total reflects only the data displayed on the current page.
Filter Total: This shows the total revenue based on any applied filters, such as customer name or membership name.
You can easily view the date range covered in the report by checking the calendar icon, which displays the From and To dates.
Filtering Options
The Projected EFT Report comes with two filtering options, allowing you to drill down into specific data:
Customer Name: View projected revenue for a specific customer or group of customers.
Membership Name: Filter by membership type to see the expected payments for specific plans or programs.
These filters make it easier to find the information you need and focus on specific clients or membership types.
Exporting Your Report
Just like other billing reports, the Projected EFT Report can be exported to an Excel file for easy documentation and future reference. To do this, simply click the Export to Excel button, and your report will be downloaded in a spreadsheet format.
The Projected EFT Report is an essential tool for businesses that rely on recurring payments. With detailed revenue projections, up-to-date data, and customizable filters, this report helps you stay on top of your financial planning. Plus, the ability to export your report ensures you have an easy way to track and archive your data. Make sure to check the report every week after it updates on Sunday to stay informed of your expected cash flow.