The Daily Activity Details report displays transaction volumes and daily earnings. Use this report to see daily sales volumes by card type, and to review chargeback fees, GST totals, and daily reserve hold backs. When you download the report contents, many more columns are included.
Accessing the Daily Activity Details 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 many more Additional Columns.
The parameter in brackets is the what is returned in the Download report.
The Daily Activity Details report includes one line item for every day that a Bambora account is active. This is a typical entry from the Bambora member area.
- Date – A line item was created to show transaction information for December 19, 2015.
- Sales / Returns
Visa – Approved sales of $43. No returns.
MasterCard – Approved sales of $118. Returns of $3.
AMEX – Approved sales of $15. No returns.
Other – No sales or returns were processed for other cards (e.g. Discover, Diners, JCB).
- Less Fees – Bambora charged a total of $6.92, which includes a sum of all per transaction fees and monthly/setup fees, if applicable. If Bambora Visa and MasterCard merchant accounts were used, discount rates are included in this total.
- CB Fees (chargeback) – This merchant was also billed of $20 by the bank. GST Amount—$1 GST applied on chargeback fees.
- Reserves Held/Reserves Released – $13.84 was added to the merchant’s account, which is 8% of the merchant’s total Visa, MasterCard, and Amex volume for the day (hold-back rates can vary).
- Less CBs – Chargebacks posted to the Bambora system—$9.79.
- Daily Balance – The total amount due to the merchant for this day’s activity (minus all fees, returned items, and reserves)—$121.45.
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.
Additional Daily Activity columns available by download
On the Daily Activity Details report, click the Download button to export the columns and data. In addition to the columns in the Daily Activity Details report, the download includes the columns in this table. Downloaded files are created in a tab delimited text file format.
Report Column Header
|trans_date||One line item for each date. Format yyyy/mm/dd|
|merchant_id||Unique Bambora customer number assigned to the company account.
This field is for use by Bambora Partners who are managing more than one company account.
|vi_num_purchases||Visa purchases for the line item date.|
|mc_num_purchases||MasterCard purchases for the line item date.|
|am_num_purchases||Amex purchases for the line item date.|
|oth_num_purchases||Purchases made using other cards.|
|vi_amt_purchases||Total value of approved Visa purchases.|
|mc_amt_purchases||Total value of approved MasterCard purchases.|
|am_amt_purchases||Total value of approved Amex purchases.|
|oth_amt_purchases||Total value of approved purchases for other credit cards.|
|vi_num_returns||Visa returns for the day.|
|mc_num_returns||MasterCard returns for the day.|
|am_num_returns||Amex returns for the day.|
|oth_num_returns||Returns processed against other cards.|
|vi_amt_returns||Total value of returned Visa transactions.|
|mc_amt_returns||Total value of returned MasterCard transactions.|
|am_amt_returns||Total value of returned Amex transactions.|
|oth_amt_returns||Total value of returned transactions from other credit cards.|
|num_approved trans||Total approved transactions.|
|num_declined_trans||Total declined transactions.|
|processing_currency||Currency before conversion for all original sales and fees. Only for Bambora FX customers.|
|settlement_currency||Currency after conversion—should match the currency of your business bank account. Only for Bambora FX customers.|
|fee_approved_trans||Sum of per-transaction fees for approved transactions.|
|fee_declined_trans||Sum of per-transaction fees for declined transactions.|
|fee_discount||Sum of discount rate fees charged on Visa and MasterCard transactions.|
|fee_chargeback||Sum of fees applied for chargebacks.|
|reserves_held||Amount held back and added to the Bambora reserve account. This is a daily reserve total only.|
|reserves_released||Amount released from the reserve account.|
|tot_chargeback_amt||Value of transactions reversed due to chargebacks. Items appear in this column on the day the chargeback is processed by the bank.|
|tot_purchase_amt||Total value of all approved credit card purchases.|
|tot_return_amt||Total value of all returns.|
|reserve_balance_forward||Start of day opening balance for the merchant’s reserve account.|
|reserve_balance_closing||Closing balance for the merchant’s reserve account after adjusting for the days account activity.|
|num_chargebacks||Total number of chargebacks.|
|settlement_date||Date the daily_balance is expected to be debited from/credited to the merchant’s business bank account.|
|send_date||Date Bambora sends a settlement file to the merchant’s business bank account. Funds are not received in the merchant’s bank account until the settlement_date.|
|opening_balance||Total amount owing to the merchant as of the beginning of the day.|
|transfer||Indicates any balances carried over from previous dates. This occurs in a biweekly or weekly settlement. A transfer can also occur if there is a system failure that prevents a file being sent on a scheduled date. See the settlement summary report.|
|transfer_returned||An amount in this column indicates the bank rejected a settlement file. Bambora attempted to transfer funds for a settlement amount. The file was sent without error, but a problem prevented the merchant’s bank from receiving the funds. The rejected amount is flagged in the transfer_returned column on the date the decline occurred. The closing balance and daily balance are recalculated to reflect the failed settlement. Settlement is attempted again as soon as possible.|
|settlement_amount||File transfer amount sent by Bambora to the merchant’s business bank account. It takes one or two business days for the bank to process the settlement file and credit funds to the business account.|
|closing_balance||Total amount owed to you by Bambora net all fees, returns and reserve hold backs, and daily settlements.|
|cc_approved_trans||Total number of approved credit card transactions on the day of the report.|
|cc_declined_trans||Total number of declined credit card transactions for the day.|
|cc_discount_rate||Merchant account discount rate applied to all Visa and MasterCard credit card transactions. Only appears for merchants receiving account services and settlement through Bambora.|
|reserve_rate||Merchant’s rolling reserve rate. Information appears if the merchant is using Bambora Visa and MasterCard merchant accounts with a rolling reserve setup.|
|The set GST rate applied against all chargeback transaction fees.|
|state_id||Unique identifier indicating the stage of a settlement file transfer. See Settlement states.|
|message_id||A message ID is in this column if a funds transfer file is rejected by the banking network when Bambora attempts to settle the merchant’s account balance. Refer to the Message ID table for a description of the codes.|
|statement_id||References the identification number for the corresponding Bambora Summary Statement.|