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 firstname.lastname@example.org.
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
||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|
||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 - 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 email@example.com
|Sales Overview Daily Algorithm:
Gross Sales - Discounts = Net Sales + Service Charge Tax + Sales Tax + Tips = Total Collected + Reimbursement - joe Commission = Transfer Amount
||Item Base Price Pre-Reward redemptions and Discounts|
||Discounts include any promos or rewards applied to an order paid by shop.|
||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 paid by customers (Card/Mobile Orders only)|
|| equals Net Sales + Tips + Service Charge Tax + Sales Tax = Total Collected
|| 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
|| 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