End of the Month Reporting
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 for the end of the month.
In this article, we will review the five reports you will receive the 1st of the month and how to calculate the transfer balance using each report. We recommend using the Monthly Orders Report if you have opted for daily deposits or are looking for the most detailed report versus the Weekly Order Report when calculating your weekly or monthly payouts.
In the end of the month reporting you will find:
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 does not include CASH transactions processed for in person ordering with joe Point of Sale.
|Non Cash Sales||All credit, debit, ApplePay, GooglePay and or ACH payments processed through Stripe. Excludes all cash sales for Point of Sale partners. For payment type breakdown for specific dates, please utilize your Operations Overview.|
|Consumer Fee||For customers that do not preload funds, we pay significantly more in processing fees. In order to keep commission as low as possible for our partners, we rely on customers preloading funds to avoid the fee or paying the convenience fee. This allows us to cover the necessary expenses to improve our technology and 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.|
How do I align my numbers using the Monthly Orders Report?
We recommend going back to your email and exporting the CSV file provided to you the first of every month. In the CSV file, you will find the total transactions for the entire previous month. This includes a link that will take you to a pop up browser to view the report quickly from your desktop or mobile browser.
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 total sales by filtering charge type.
|Order ID||Gross sales - pre tax and tip|
|First Name||Customers who have opted into the loyalty program or have ordered through the mobile app|
||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|
|Source||Order source from Mobile, In-Person or Online Orders|
|Charge||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||Items - Discounts + Tips + Consumer Fee + Sales Tax = Total Sales|
Next Steps: 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 firstname.lastname@example.org.
How does joe Loyalty Marketing Dashboard impact your bottom line?
Note: We recommend you continue to learn more about the loyalty marketing provided by joe by reviewing Loyalty Marketing Dashboard gives shop owners powerful insight article. For a simple Reporting view breakdown, review the table below.
|Loyalty Marketing Attributed Revenue||Total new revenue driven by joe’s automated marketing programs and new customer acquisition.|
|Loyalty Attributed Revenue||Total new revenue driven by joe’s automated marketing programs among customers you activated.|
|Marketplace Attributed Revenue||Total new revenue driven by new customers that discovered you through joe’s marketplace.|
|Total Active Customers||Marketplace users are customers that discovered you through the joe app. Loyal customers are users that made their first joe purchase at your shop. New users have made their first order on the joe app at your store.|
|Marketplace Customers||Marketplace users are customers that discovered you through the joe app.|
|New Users||Loyal customers are users that made their first joe purchase at your shop.|
|Loyal Customers||New users have made their first order on the joe app at your store.|
How to leverage your Monthly Itemized Category and Item Report?
This report is intended to provide you with insights on your top selling and most popular items in the previous month.
|Menu Category||Menu Category for the item|
|Items||Customers who have opted into the loyalty program or have ordered through the mobile app|
|Order Item Count||Customers who have opted into the loyalty program or have ordered through the mobile app|
|Items||Customers who have added their email through the mobile app|
|Discount||Order source from Mobile, In-Person or Online Orders|
Your Monthly Total Orders Report!
This report provides you with high level insights on daily order volume and week over week growth trends. This will also help you stay on top of any decline and get ahead of it so you can be proactive and work with your dedicated account manager to implement growth campaigns.
For any additional details found please email email@example.com.