How to reconcile my transfers report using Daily Orders Report?

Reconciling your joe reports is simple with our new Merchant Portal Dashboard. Below we outline what information you will find in the Transfer Summary Report and how to read the report to easily understand the amount being transferred to you from joe. If you have any questions about reporting, feel free to reach out to success@joe.coffee. 

What is included in your Transfer Summary Report? 

Your Transfer Summary report has all the information you need to understand the date the bank received your deposit and the total "Card Transactions" processed through the joe Point of Sale or Digital Online Ordering. This in fact does not include any CASH transactions processed for in person ordering. 

Transfer Summary Algorithm: Total Collected - joe Commission + Reimbursements = Transfer Amount

Name		Description
Total Collected		All credit, debit, apple, google and or ACH payments processed through stripe.  Excluding all cash sales for Point of Sale Partners. For payment type breakdown for specific date please utilize your Operations Overview
joe Commission		In person orders of 2.4% + .10 rate for joe Point of Sale. 9% is our standard mobile marketplace and online ordering fee (drops to 7% with link placement on website, Instagram, and Google Biz Profile) or discounted rates upon registration.
Reimbursement		Promotion and marketing campaigns paid for by joe to be reimbursed to partner
Transfer Amount		Amount transferred to the store's bank account post cost.  Non-Cash sales - Commission + reimbursements = Transfer Amount.

How do I calculate my transfer balance using the Sales Overview Daily Orders Report?

Note: the transfer amount does not include the "Cash Sales" since it is only depositing funds of Card Transactions. To properly reconcile your transfer amount, subtract your total cash sales by filtering your charge type! Filter for Non-Cash Charge Type. This will give you a full scope of the total transactions that are included in the bank transfer amount. For any discrepancy found from your transfer amount from daily orders report please email success@joe.coffee

Sales Overview Daily Algorithm: Gross Sales - Discounts = Net Sales + Service Charge Tax + Sales Tax + Tips = Total Collected + Reimbursement - joe Commission = Transfer Amount

Name		Description
Date		Order Date
Gross Sales		Item Base Price Pre-Reward redemptions and Discounts
- Discounts		Discounts include any promos or rewards applied to an order paid by shop.
=Net Sales		Item Base Price after discounts and reward redemptions
+ Service Charge Tax		Tax on the fees paid by consumers that is reimbursed to shops due to tax rate by state
+ Sales Tax		Tax the customer paid on order - to be remitted by shop
+ Tips		Tips paid by customers (Card/Mobile Orders only)
=Total Collected		equals Net Sales + Tips + Service Charge Tax + Sales Tax = Total Collected
+Reimbursements		Discounts include any promos or rewards applied to an order paid by shop.
- joe Commission		Promotion and marketing campaigns paid for by joe to be reimbursed to partners
=Transfer Amount		Amount Transferred to your for the date period selected
Fees paid by		For customers that do not preload, we pay significantly more in processing fees. In order to keep commission as low as possible for our partners we rely on people preloading to avoid the fee or paying the convenience fee so that we can squeeze out a profit and continue to improve our technology to better serve our partners and customers