How to reconcile my transfers report using Daily Orders Report?

After receiving your Transfer Summary Report from joe (via Looker), we have a few CSV reports automated to hit your email that you can leverage to align your numbers. In this article we review three reports and how to calculate the transfer balance from them. We recommend using the Daily Orders Report if you have a Daily Transfer balance or the Weekly Order Report when calculating the weekly payouts.

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

Step #1 - 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. 

Name
Description
Non Cash Sales 
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
Consumer Fee
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
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 - Consumer fee - Commission + reimbursements = Transfer Amount.

Step #2 - How do I calculate my transfer balance using the Daily Orders Report?

We recommend going back to your email and review what date you'd like to reconsolidate. We also recommend reviewing the "Order" date of the transfer you are seeking to align. This will help ensure you have the proper data for the report.

Also remember that the transfer amount does not include the "Cash Sales" since it is only depositing funds of Card Transactions.  So to properly reconcile your transfer amount subtract your total  cash sales by filtering your charge type! 

Name
Description
Order ID.   
Gross sales - pre tax and tip
Customer First Name
Customers who have opted into the loyalty program or have ordered through the mobile app
Customer Last Name
Customers who have opted into the loyalty program or have ordered through the mobile app
Customer Email
Customers who have added their email through the mobile app 
Source
Order source from Mobile, In-Person or Online Orders
Charge Type
Cash or Non-Cash Orders
Item Count
Item count orders per transaction
Items
Total amount of menu items 
Discounts
Discounts include any promos or rewards applied to an order paid by shop. 
Tips
Tips paid by customers (Card/Mobile Orders only)
Consumer Fee
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 funds to avoid the fee or paying the convenience fee. So we can continue to improve our technology to better serve our partners and customers we place this consumer fee on customers who do not preload funds. 
Sales Tax
Tax the customer paid on order - to be remitted by shop
Total Sales
equals Items - Discounts + Tips + Consumer Fee + Sales Tax = Total Sales 

Next Steps: Go ahead and 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