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:

  1. Transfer Summary Report
  2. Monthly Orders Report
  3. Loyalty Marketing Dashboard
  4. Monthly Itemized Reports
  5. Monthly Total 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 does not include CASH transactions processed for in person ordering with joe Point of Sale.

Name Description
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.

Name         Description
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
Last Name  
Customers who have opted into the loyalty program or have ordered through the mobile app
Email   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 success@joe.coffee.


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.

Name   Description
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.

Name   Description
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 success@joe.coffee.