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.
|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|
||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|
||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.|
||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!
||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
||Customers who have added their email through the mobile app|
||Order source from Mobile, In-Person or Online Orders|
||Cash or Non-Cash Orders|
||Item count orders per transaction|
||Total amount of menu items|
|| Discounts include any promos or rewards applied to an order paid by shop.
|| Tips paid by customers (Card/Mobile Orders only)
|| 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.
|| Tax the customer paid on order - to be remitted by shop
|| 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 email@example.com