Section 1: Creating the batch
Functions -> EFT -> Create EFT
- SchedPay Date: Enter a date range using the BTWN or a specific date using =.
Entering a date range is best practice. This will ensure you pull in all Scheduled Pay dates that may have been created with a pay date that is not the 1st or 15th, etc.
- Batch Type: Normal or Re-Run.
The first batch you run for the date range will always be normal. When you run a batch for your failures, a Re-run batch will be created for you for the date range of that batch.
- Items per page: Number of Transactions you can view per page.
Number of transactions viewable per page.
- User Status: All, Active, Inactive, Frozen and Active and Frozen.
**User Status refers to the Member Status. If the Membership status is Inactive, but the Member status is Active, it is most likely because there are Service Packages still associated to the Membership. It is important to close those packages if they should be closed. It is also important to clear any remaining balance on a Membership before closing the Membership – if the open balance is not owed.** If you bill your Members while they are in Frozen status, select Active and Frozen.
- Category: Memberships, Services, Counter and Combined.
You can run separate batches based on Category or select combined to run them all at the same time.
- Payment Method: Credit Card, Bank Draft and Combined.
You may want to run your Credit Card batches separate from your Bank Drafts. Open Edge will submit all your Bank Drafts when they are run. You will need to log into the Open Edge ACH Portal in 5 – 7 days to retrieve any Bank Drafts that failed. Log into the Member’s membership or Service Package and reverse the charges back to No Charge. This will create an open balance for that payment so that you can collect on it.
- EFT Group: This defaults to All unless you have created EFT Groups.
An example for how you can use an EFT Group: You can create an EFT Group for Members whose dues are paid for by their company. This will allow you to better manage their billing
- Optional: Last name starts with (or between)
You can draft specific members if necessary. These fields are usually left blank during a Normal batch run. This is not typical.
Section 2: Processing the batch
The top grid shows you:
- The Batch number
- The Batch Type
- The total amount of money expected in the draft
- The total amount that will be submitted in the draft. This number may be less than expected if you are missing any account numbers or if the credit card is expired.
The bottom grid columns explained:
- Actions (History leads to Member’s payment history and Scheduled Payments lead to the Member’s Scheduled Payments)
- Include (This allows you to Include or Exclude someone from the batch). Example, if you know of a Member who does not want to be drafted this month but will pay in the club the next day when they come in, can be excluded from the draft while leaving the payment unpaid
- Member name (clicking on the Member Name will take you to their billing page)
- Member Status
- EFT Payment Preference (set in Member’s billing page). If Primary Credit Card, Secondary Credit Card or Bank Account is not selected in the Member’s billing page, the payment will not pull into the draft.
- Account Number (displays last 4 in account number)
- Cycle Rate (what their monthly payment amount is)
- Open Balance (will display if there is any open balance)
- Charge Amount is what the Member will be charged this draft. This field is editable. You can edit this field to include the open balance if you like
- Tax (if there is tax included, it will be displayed here)
- Debit/Credit. This field defaults to Debit. You can apply a refund through your draft by changing the drop down to Credit. Typically, refunds are not handled through draft
- SchedPay Date. This is the date of the scheduled payment
- SchedPay Id. This is the number scheduled payment. For example, the 4th scheduled payment in a 12 month membership.
- SchedPay Type. This will be Membership, Service or Counter
- Membership or Service Status. Active, Inactive or Frozen
Blue lines are good transactions and WILL be included in your draft. Pink line are not good and WILL NOT be included in your draft. This is most likely because you are missing the account number in the Member’s billing page or because the card is expired.
- Save Changes on THIS page. If you Include/Exclude any Members from your batch, make the correction and click Save Changes on THIS Page.
**Remember, if you have more than one page in your batch, remember to save your changes on each page.
- Exclude All. You can Exclude All, then go back and Include any Members into your batch;
- Include All. You can Include All, then go back and Exclude any Members from your batch;
- Process EFT. When you are satisfied with your batch, click ‘Process EFT’.
- Click ‘SUBMIT’. This will submit your batch to Open Edge for processing
- You can still View, Modify or Cancel your batch before Submitting
- When you click ‘Submit’, you will be asked ‘Are you sure you want to Submit this batch’. Click ‘Yes’.
Section 3: Viewing the batch
Functions -> EFT -> View Batches
- After submitting your batch, you will receive your Approvals and Failures back from Open Edge. Depending on the size of your batch, this process will take between 2 – 15 minutes. You can click the ‘Refresh’ button at the top left of your batch while it is processing. This action is strictly optional. Once you submit your batch, the process in complete. The ‘Refresh’ button simply allows you to view the Approvals and Failures as they come in.
- When the batch is complete, approved transactions will have the Status display ‘Processed’ or if it failed, the failure reason.
Section 4: Creating Batch from Failures
If you add late or failure fees to your failed transactions, you can perform this action in bulk.
Functions -> EFT -> View Batches
- You can Create a Batch from your Failures. Go to Functions -> EFT -> View Batches and click the ‘View’ link next to the batch you are re-running. The batch details will auto-populate from the current batch.
- Or you can Add Fees to your Failures first, then create your failure batch. If you charge your Members a late fee or failure fee, you can bulk add these charges before running the Re-run batch.
Adding fees to Fails
- Click the link ‘Add Fees to Fails’. All the Members who failed in this batch will display.
- The first column allows you to remove any Members that you do not want to receive a failure/late fee. UNCHECK the box in the first column to remove them.
- The data in the remaining columns comes from your batch and has the basic payment information for the Member.
- In the yellow section, enter the Payment date. This is typically the same day as the Scheduled Payment.
- Enter the Payment Amount.
- Enter a reason i.e., late, payment failed etc.
- Select a Charge Type (Charge Types are defined under the Membership Type).
- Click the ‘Add Payment’ button.
ACH payments will all be processed by Open Edge. You must log into the ACH portal 5 – 7 business days after the batch was submitted to get the failures. You must log into the Member’s membership (Quick Functions -> View Membership and/or View Packages) and reverse the payment using the Payment Type No Charge. When the Member corrects their payment, you can take the payment from the Open Balances report as a Quick Pay.
EFT Analyzer Report (Reports -> Financial -> EFT Analyzer). You can use a pre-written report or perform a Custom Query. This report will add up all of the payments submitted, settled, declined and auto- corrected for a certain date range.