How to run an EFT batch when using Bambora

Functions-> EFT-> Create a Batch 

**Recommendation: Run and work your Validation report a day or two ahead of time by going to: Functions-> EFT-> Validate.  This report will help expedite the processing of credit card and echeck payments.  It will report back clients without an EFT payment method selected, expired credit cards, and other issues.  Also, consider reviewing your Expiring Credit Card Report from Reports-> Misc./Stat.-> Credit Card Expire Report.

Create a Batch

  1. Set SchedPay Date to those payment dates to be captured.  This will default to between (btwn), but often clients set this to [=] and enter the payment due date.
  2. You can batch by a between option, allowing the ability to batch between two values. They can be full last names, a letter, or several letters.
  3. Items per page: if you have a large database of clients, and often have many members to be excluded, consider using 50, otherwise, leaving it at 100 should be fine.
  4. User Status: this defaults to Active, but All, Frozen and Inactive are other status options.
  5. Billing Type: you can focus on Services or Memberships - or both
  6. Payment Method: you may combine, or run eChecks and Credit Cards separately (recommend separetly).
  7. Click [Search]
Review and Process EFT
  1. Review the Batch: in the first column, under Actions, if you see a red bar, this client's payment setup should be reviewed.
  2. Through the center columns-> Cycle Rate, Open Balance, and Charge Amount. If there are highlighting in any of these fields you may want to review the client's payment schedule.  It is indicating that the numbers don't match up for a single months payment; often there is a logically reason for this, the system is only bringing it to your attention.
  3. If there is a red bar for a client, and it cannot be resolved, you'll need to omit it from the batch.  If you decide you don't want to bill anyone else for another reason, they too should be omitted from the batch.  To do this, from Actions, click [Edit]; remove the check mark from the [Include] column, click [Save].
Process EFT and Download Batch
  1. After omitting any clients from your batch in the step above, click [Process EFT] at the top of the batch.
  2. Six Actions options will now be visible: View, download, modify, import fails, finalize, and cancel.
  3. Click [Download]
  4. Save the file (DO NOT OPEN THE FILE - CHOOSE 'SAVE'.) to a known and easily accessed location.
Upload Batch to Gateway
Log-in to your Bambora gateway account
Batch files are a great tool for importing multiple transactions at one time. Batch files are uploaded directly to the Portal after the file has been saved to your computer.


Must know:

  • In order to upload a batch file with the Portal, you need to ensure you have Batch Processing enabled.
  • You need to be an administrator of your account to upload Batch files or have Full Access to Batch Processing located in the User Manager.

How do I upload a Batch file?

  1. Within the Portal go to Processing > Batch Processing.
  2. Click on ‘Choose File’ and select the processing date.  (**NOTE~ The upload date defaults to the next business day.  You can change the date to process on today's date if it is before 11am PST). 
  3. Click ‘Upload’.
  4. To confirm you uploaded it successfully:
    1. For credit card batches, you can click into the batch and hover over the icon under state. The state will say scheduled on each line item. It will also show the Scheduled icon under Credit.
    2. For ACH, the file will display a debit and credit date.

Good to know:

  • If you are using the API to process batches, please visit our Developer Docs.
Results from Gateway, Omitting Failures, and Finalize Batch
  1. Go to: Functions-> EFT-> View Batches
  2. Under the Actions column, click [Modify]
  3. For any failed transaction provided by your gateway, remove the check mark under [Include]
  4. Repeat the previous step for each page; at the end of each page, click [Save Changes on THIS Page] BEFORE moving on to the next page.
  5. When complete, click [End Modify]
  6. Next, click [Finalize] **Be sure that all failures have been removed before doing this step**
**Note: for those that have been omitted from the batch, you can review their payments due from the appropriate Open Balances Report; Reports-> Financial-> Open Balances (Services, Memberships, or combined).
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk