DB040: EFT Master List

The DB040 report lists EFTs scheduled to be collected within the date range, including the client name, membership, Scheduled EFT Date, Actual EFT Process Date, and more. 

Tip: Run the DB040 report to view real-time statuses of membership dues and Payment Plan payments. Terminated membership EFTs will not appear in this report if the selected date range is after the membership termination.

Report definitions

Click here for details on the EFT Status sort order fields in the DB040 report.Click here for details on the EFT Status sort order fields in the DB040 report.

  • Paid: Successful EFT payment. Billing Engine will not attempt to bill client again for this payment date.
  • Not Billed: Default status for payment that has not yet been billed. Billing Engine will bill client on payment date.
  • Pending: For ACH payments; indicates payment submitted to bank and in-process.
  • Suspended: Payment attempt failed. Billing Engine will attempt to bill client again on the next payment date.
  • Waived: Payment was manually waived. Billing Engine will not attempt to bill client for this payment date.
  • Refunded: Client was refunded this payment. Billing Engine will not attempt to bill client for this payment date.
  • Frozen: Client has EFT(s) during dates that the membership is frozen.
  • Client: Name of the client who owns the membership.
  • Phone Number: Phone numbers that appear in the client's profile, with the primary number first. Appears only if Show client phone numbers is selected in the report setup screen.
  • Membership/Payment Plan ID: The name of the membership or ID of the Payment Plan.
  • Scheduled EFT Date: The date the EFT was scheduled to be run.
  • Actual EFT Process Date: The date the EFT was actually run or waived.
  • Payment Information: Displays the client's payment information, including the card type, last four digits of the card number, and expiration date. The primary payment method appears first, followed by the secondary payment method, if any.
  • EFT Amount: The amount of the EFT for that particular row.
  • Future Appt Date: The date of the client's next appointment.
  • Total EFTs Collected for [Status]: The sum of all EFTs for each individual status.

Click here for details on the Scheduled EFT Date sort order fields in the DB040 report.Click here for details on the Scheduled EFT Date sort order fields in the DB040 report.

  • Client: Name of the client who owns the membership.
  • Phone Number: Phone numbers that appear in the client's profile, with the primary number first. Appears only if Show client phone numbers is selected in the report setup screen.
  • Membership/Payment Plan ID: The name of the membership or ID of the Payment Plan.
  • Actual EFT Process Date: The date the EFT was actually run or waived.
  • Payment Information: Displays the client's payment information, including the card type, last four digits of the card number, and expiration date. The primary payment method appears first, followed by the secondary payment method, if any.
  • Status: The status of the EFT.
    • Paid: Successful EFT payment. Billing Engine will not attempt to bill client again for this payment date.
    • Not Billed: Default status for payment that has not yet been billed. Billing Engine will bill client on payment date.
    • Pending: For ACH payments; indicates payment submitted to bank and in-process.
    • Suspended: Payment attempt failed. Billing Engine will attempt to bill client again on the next payment date.
    • Waived: Payment was manually waived. Billing Engine will not attempt to bill client for this payment date.
    • Refunded: Client was refunded this payment. Billing Engine will not attempt to bill client for this payment date.
    • Frozen: Client has EFT(s) during dates that the membership is frozen.
  • EFT Amount: The amount of the EFT for that particular row.
  • Future Appt Date: The date of the client's next appointment.
  • Total EFTs Collected for [Date]: The sum of all EFTs marked as Paid, by date.
  • Total EFTs Collected for [Date Range]: The sum of all EFTs marked as Paid for the selected date range.

Click here for details on the Client Name sort order fields in the DB040 reportClick here for details on the Client Name sort order fields in the DB040 report

  • Client: Name of the client who owns the membership.
  • Phone Number: Phone numbers that appear in the client's profile, with the primary number first. Appears only if Show client phone numbers is selected in the report setup screen.
  • Membership / Payment Plan ID: The name of the membership or ID of the Payment Plan.
  • Scheduled EFT Date: The date the EFT was scheduled to be run.
  • Actual EFT Process Date: The date the EFT was actually run or waived.
  • Payment Information: Displays the client's payment information, including the card type, last four digits of the card number, and expiration date. The primary payment method appears first, followed by the secondary payment method, if any.
  • Status: The status of the EFT.
    • Paid: Successful EFT payment. Billing Engine will not attempt to bill client again for this payment date.
    • Not Billed: Default status for payment that has not yet been billed. Billing Engine will bill client on payment date.
    • Pending: For ACH payments; indicates payment submitted to bank and in-process.
    • Suspended: Payment attempt failed. Billing Engine will attempt to bill client again on the next payment date.
    • Waived: Payment was manually waived. Billing Engine will not attempt to bill client for this payment date.
    • Refunded: Client was refunded this payment. Billing Engine will not attempt to bill client for this payment date.
    • Frozen: Client has EFT(s) during dates that the membership is frozen.
  • EFT Amount: The amount of the EFT for that particular row.
  • Future Appt Date: The date of the client's next appointment.
  • Total EFTs Collected for [Date Range]: The sum of all EFTs marked as Paid for the selected date range.

Click here for details on the Actual EFT Process Date sort order fields in the DB040 report.Click here for details on the Actual EFT Process Date sort order fields in the DB040 report.

  • Client: Name of the client who owns the membership.
  • Phone Number: Phone numbers that appear in the client's profile, with the primary number first. Appears only if Show client phone numbers is selected in the report setup screen.
  • Membership/Payment Plan ID: The name of the membership or ID of the Payment Plan.
  • Scheduled EFT Date: The date the EFT was scheduled to be run.
  • Payment Information: Displays the client's payment information, including the card type, last four digits of the card number, and expiration date. The primary payment method appears first, followed by the secondary payment method, if any.
  • Status: The status of the EFT.
    • Paid: Successful EFT payment. Billing Engine will not attempt to bill client again for this payment date.
    • Not Billed: Default status for payment that has not yet been billed. Billing Engine will bill client on payment date.
    • Pending: For ACH payments; indicates payment submitted to bank and in-process.
    • Suspended: Payment attempt failed. Billing Engine will attempt to bill client again on the next payment date.
    • Waived: Payment was manually waived. Billing Engine will not attempt to bill client for this payment date.
    • Refunded: Client was refunded this payment. Billing Engine will not attempt to bill client for this payment date.
    • Frozen: Client has EFT(s) during dates that the membership is frozen.
  • EFT Amount: The amount of the EFT for that particular row.
  • Future Appt Date: The date of the client's next appointment.
  • Total EFTs Collected for [Date Range]: The sum of all EFTs marked as Paid for the selected date range.

Setting up the DB040 report

  1. Type DB040 in the Convobar, or go to Meevo > Reports > Memberships, and then select the DB040 report.
  2. Select a date or date range for running the report:
    1. To run a report for a specific date range, select Custom and specify the Start Date and End Date for the report.
    2. Otherwise, select a predefined date or range (Yesterday, This Week, Last Week, etc.).

Note: If you select a predefined range (a date other than Custom), you can still change the Start Date and End Date. Doing so automatically changes the date range to Custom.

  1. In Sort Report by, select a sorting option:
    1. EFT Status: Sorts all EFTs by status.
    2. Scheduled EFT Date: Sorts all EFTs by date.
    3. Client Name: Sorts all EFTs alphabetically, by client name.
    4. Actual EFT Process Date: Sorts the report by date the EFT was run or waived. For field definitions, see the Client Name descriptions.
  2. Show client phone numbers: Displays client phone numbers according to the information in the client profile.
  3. Display EFT Information For: Run this report for Membership EFTs or Payment Plan EFTs. Note if you select Payment Plan EFTs, you cannot run this report for a future date range.

Running the report

  1. When you are ready to generate the report, select a Report Format beside the Run Report button.
  2. Here is a rundown of each format type:
    1. PDF: Each time you select Run Report with PDF selected, Meevo opens a separate browser tab that displays the PDF'ed report. Meevo remains on the setup page, so you can quickly jump back over to Meevo to run more date ranges or other reports. Each PDF report you run will open its own browser tab, so you can easily review and compare reports by simply jumping between browser tabs.
    2. HTML: This is our original legacy format, which opens the report within Meevo. All of the functionality within that report is still there and available via the toolbar.
    3. XLSX: Each time you select Run Report, your browser auto-downloads the report in .xlsx format. Select the downloaded file in the browser footer to open the spreadsheet.
  3. Select Run Report to generate the report in your chosen format. Depending on the type of report and criteria you entered, this process may take a few minutes.