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. 

IN THIS ARTICLE
  • Step #1 - What is included in your Transfer Summary Report
  • Step # 2 - How do I calculate my transfer balance using the Daily Orders Report

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