This article summarizes the order approval through bank deposit flow and how you can use the transaction report within your dashboard to reconcile bank disbursements.
When an order is approved, we immediately send it for settlement to Braintree. Transactions submitted for settlement after 6PM ET will be included in the next day's settlements. Disbursement occurs the next business day after a transaction settles and deposits are typically two business days after a transaction settles. In summary, you can expect to see funds deposited to your bank two business days after an order is approved.
You can use the transaction report to reconcile your bank disbursements to your orders. The transaction report is found in the Overview Section of your dashboard, by selecting Reports.
City Hive transaction fees, credit card fees, and insurance fees (if applicable) are deducted prior to disbursement for each transaction (i.e., for each order). You can review the details of these fees in your transaction report. The definitions of the transaction report columns are included below.
Downloading the Transaction Report
Follow the steps below to download the transaction report.
1. Click Transaction Report on the left side of your screen
2. Choose how you would like to filter the date range. For example, if you select, Get Range By "Disbursement Date," this means that only orders disbursed within the date range that you select will be included.
3. Choose the date range that you would like to review
We recommend waiting at least three business days after an order is accepted to review your bank deposits against the Transaction Report. E.g., You can run this report by disbursement date on Wednesday to account for the orders between Sunday and Saturday of the prior week. This allows Friday night and Saturday’s transactions to have been disbursed on Monday and deposited to your bank by Tuesday.
4. Select "Get Report"
5. Select "Download"
If you would like to review a report for a different date range, please make sure to refresh the page prior to selecting the new date range.
Reconciling Bank Disbursements
We recommend opening the CSV file using Excel or Google Sheets. To review your transactions against your bank disbursements, create a pivot table following the steps below:
1. Select all of the data in the spreadsheet (Ctrl+A)
2. Select Insert > Pivot Table > OK
3. Set up the pivot table to include the Disbursement Date as a Row and the Sum of Disbursed to Your Account as a Value, as shown below
4. Reconcile the disbursement amounts to the deposits in your bank account. As a reminder, deposits typically occur one business day after disbursement.
Transaction Report Details
You can add or remove columns in the transaction report by selecting Show Report Details, under the date range. Then you can select which Customer, Price, Product, or Order Information details you would like to include in the report.
The table below provides an overview of the columns that can be included in the transaction report:
Local time the order was placed
City Hive ID for the order
ID provided by our Processor (Braintree), one order can have multiple Transaction IDs (e.g., if processing refunds)
Name of the merchant that processed the order
For chains, this specifies the location that processed the order
ID of merchant who processed the order
Local time the order was approved
(Note: This action submits the order for settlement)
Credit card transactions have several steps before entering the final stage of being disbursed to your account. Learn about each stage below and when you can expect the funds to appear in your bank. Determine which stage of the order life cycle your ...
Configure your City Hive account with our credit card processor, Braintree, and get payments from online orders right to your bank. When an order comes from your mobile app and/or website, that means that the customers' bank has authorized an amount ...
It is common to have a customer grab a last minute item to add to their transaction in store, so naturally the same thing can happen online. Follow the tips below to ensure you avoid additional processing fees: When is an additional fee incurred? ...
You can now reauthorize an order through the dashboard! Seeing this error pop up when attempting to approve an order can come with multiple reasons as to why a payment may need to be re-settled. To reprocess the order simply head to the "Billing ...
If the customer request a refund we will charge the refund amount to the card on file and issue the funds back to the customer. We do this because we are not able to withdraw funds directly from their account, we are only able to deposit which will ...