To settle to a merchant’s bank account, Bambora compiles a credit or debit file and sends the information to the banking institution. These settlement files go through several States as they are created, processed, and forwarded to the bank. These States affect the merchant’s Bambora account balance, and the information in the Transfer and Returned columns of the Settlement Summary report.
||The Daily Balance was added to a funds transfer file and a date selected for the file to be sent to the bank. The Send Date for the line item shows the date the funds are scheduled to be sent to the bank for settlement.
||The GEN shows briefly as Bambora creates a settlement file.
||Bambora sent a file with the Daily Balance to the bank, but the bank has not yet debited or credited it to the merchant’s business bank account. The funds transfer remains in the PRO state until the bank finishes processing the file and approves or declines the transaction.
As Bambora no longer owes this money to the merchant, the amount is shown as a Settlement.
||The banking network received a file that includes the Daily Balance for the line item. The transaction was approved and the final debit or credit for the account has occurred.
||The banking network received a file that includes the Daily Balance for the line item, but the transaction was declined. The debit or credit must be attempted a second time.
On the date the Decline occurs, the rejected file amount is added to the Returned column on the Settlement report. The Daily and Closing balances are adjusted to reflect that the settlement did not occur. A file is resent as soon as possible.
||TXF shows when a system error occurs that prevents a file from being sent on a scheduled date. The Daily Balance is accumulated and added to the Transfer column in the next day’s line. The amount is rescheduled and sent as soon as possible.
||Bambora placed a hold on the file transfer.
|For merchants that receive weekly, monthly, or bi-monthly settlements.
The Daily Balance is carried over to the next day and added to the Transfer column. The Transfer amount is then added to the new Daily Balance. This means that in an accumulating situation, the Daily Balance column shows a running total of everything due to be deposited at the next settlement period.
||Threshold Pending Account
||Indicates the debit or credit is below the minimum threshold set for scheduling the transaction. Not all merchants have thresholds set.
The Daily Balance is carried to the next day where it is added to the Transfer column. The Transfer amount is then added to the new Daily Balance. The Daily Balance column shows a running total of everything due to be deposited at the next settlement period. Bambora cannot debit an account. When a merchant’s settlement is below 0.00 (owing Bamborafunds) the State is set to UND and carried into the next day until there are new sales to offset the amount owed.
||Used for Canadian PSP accounts signed up through Orbit. If the merchant’s bank account was not verified, any sales by these merchants are calculated in Card Settlement and are set to PEN (Pending Verification). After verifying their account the Status changes to SCH.
On the Settlement Summary report, click the Download button to export the columns. The downloaded files are created in a tab delimited text file format. In addition to the columns in the Settlement report, the downloaded file includes the columns in this table.
||Unique Bambora customer number assigned to the company account. This field is used by Bambora Partners who are managing more than one company account.
||Company name as entered into the Bambora system. This field is designed to assist Bambora partners with managing multiple company accounts.
*FX customers only
|Currency of all original sales and fees before conversion.
*FX customers only
|Currency after conversion. Should match the currency of your business bank account.
||Date funds are expected to arrive in the merchant’s business bank account.
||Date of line item that an accumulated balance was forwarded to.