This detailed report gives you a day-to-day summary of net sales, net fees, reserve activity, and settlements. If you received online merchant accounts from your bank, contact your merchant account issuer for details about settlement. Note: Only available to merchants using Bambora-issued Visa or MasterCard merchant accounts.
If you have a Canadian dollar American Express merchant account through Bambora, refer to your American Express reports to see those settlement details.
Opening the settlement summary report
- Click Refresh to list your report. Column descriptions are listed below.
- You can click Download to export the columns and data. In addition to the column listed below, the report has Additional Columns.
|Date||One line item for each settlement date. Format: mm/dd/yyyy.|
|Opening||Merchant’s opening balance. The total in this column is the same amount as the closing balance from the previous settlement period. If this is the first settlement period, the opening balance is $0.00.|
|Settlement||File transfer amount sent by Bambora to the merchant’s business bank account. It takes the bank one or two business days to process the settlement file and credit funds to the business account.|
|Transfer||Balances carried over from previous dates. This occurs in the bi-weekly or weekly settlement. A transfer can occur if there is a system failure that prevents a file from being sent on a scheduled date.|
|Returned||The bank rejected a settlement file. Bambora attempted to transfer funds for a settlement amount. The file was sent without error but there was a problem that prevented the merchant’s bank from receiving the funds. The rejected amount is flagged in this column on the decline date. The closing balance and Daily Balance are recalculated to reflect the failed settlement. Settlement is attempted again as soon as possible.|
|Net Sales||Total value (net returns and chargebacks) of all processed and approved sales on the specified date.|
|Reserves||Total withheld by Bambora and put into the merchant’s rolling reserve account.|
|Total Fees||Total value of all transaction fees and discount rate charges, and where applicable, setup and monthly fees for the day.|
|GST||Total GST applied to chargeback fees. GST is not applied to any other account fee.|
|Closing||Total amount owed by Bambora, net all fees, returns and reserve holdbacks, and daily settlements.|
|Daily Balance||Total amount earned for the day, net all fees, returns, and reserve hold backs.
This column does not include earnings from previous days. If you are on bi-weekly or monthly settlement, the daily balance also includes any amounts from the Transfer column.
|Send Date||Date Bambora transfers a file to the banking network to start the settlement process.|
|State||Indicates the state of Bambora's settlement file. See Settlement States|
- On December 16, 2015, the merchant had an Opening balance of zero.
- They did $1200 in Net Sales (net chargebacks, returns and declines).
- A total of $96 was held back for the merchant’s Reserves account.
- $48 in Total Fees were charged by Bambora for transaction, discount rate, and chargeback fees.
- An additional $1 in GST was applied on chargeback fees.
- The merchant’s Closing balance was $1055.
- Their total profit for the day, Daily Balance, was also $1055 (Net Sales minus Reserves, minus all fees, and GST charges). This is the first entry, so this amount is the same as the amount in the Closing Balance column.
- The Send Date is the day the daily balance is sent in a file transfer to the merchant’s business bank account. In this example, $1055 will be transferred on December 18, 2015.
- The State column indicates that a settlement file has been scheduled to transfer (SCH). This merchant doesn’t have daily settlement. The daily balances accumulate until the next scheduled settlement day arrives.
If you have questions about sums in the Transfer column go to Detailed Settlement Summary Column Descriptions; For more information about the State column (e.g. ACC) go to Transfers, Returns, and Settlement States.
Note: If you are a Bambora FX customer, when you log into your account for secondary currency, the FX Rate and FX Amount columns are displayed to help you identify conversion rates and final settlement totals.
The next settlement on December 18 shows a Settlement of $1055 for the merchant. This is also the Daily Balance from December 16. If other line items had a Send Date of December 18, each of these Daily Balances are added together to create the amount in the Settlement column. There is a day or two lag before this money appears in the merchant’s bank account.
The new Closing balance for the December 18th of $2305.60 is equal to:
Opening balance + Net Sales – Reserves – Total Fees – the Settlement amount.
The State column from December 16 has changed to PRO and indicates the transaction is being processed by the bank.
If you have questions about sums in the Transfer column or you see ACC in the State column, for more detailed information go to Transfers, Returns, and Settlement States.
Additional settlement columns available by download
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.
Report Column Header
|merchant_id||Unique Bambora customer number assigned to the company account. This field is used by Bambora Partners who are managing more than one company account.|
|merchant_name||Company name as entered into the Bamborasystem. 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.|
|settlement_date||Date funds are expected to arrive in the merchant’s business bank account.|
|transfer_to||Date of line item that an accumulated balance was forwarded to.|