How to calculate your transfer balance with different reports

After receiving your balance transfer from joe, we have a few CSV reports available in your joe Merchant Portal for you to pull and compare. In this article we review three reports and how to calculate the transfer balance from them. We recommend using the Summary Report or the Order Report when calculating the payout, but also provide information for using the Itemized Report as well in this article. 

IN THIS ARTICLE

How do I calculate my transfer balance using a Summary Report

We recommend pulling a Summary Report for the date range and using the following equation. Be sure to compare the date the deposit landed in your bank account with the date the deposit was sent.

Name Row Description
Total Ticket 5 Gross sales - tax & tip
+ Total Tip 6 Tips paid by customer
+ Total Tax 7 Tax customer paid on order; to be remitted by shop
+ Reward Reimbursement 8 joe Sponsored rewards (i.e. if a customer uploads $25 to their account, joe credits them a free drink)
+ Promo Reimbursement 9 joe Sponsored promos  (joe is paying merchant on behalf of customer who redeemed the promo)
- Processor Fee  10 9% rate unless during a discounted sign up period
= Merchant Payout Total 11 Amount transferred to the store's bank account

How do I calculate my transfer balance using an Orders Report?

We recommend pulling an Orders Report for more in-depth insight on your total ticket sales. Be sure to compare the date the deposit landed in your bank account with the date the deposit was sent.

Name Column Description
Goods Total B Gross sales - pre tax and tip
+ Order Tax Sum C Tax the customer paid on order - to be remitted by shop
+ Tip D Tips paid by customer
+ Reward Reimbursement E joe Sponsored rewards (i.e. if a customer uploads $25 to their account, joe credits them a free drink)
+ joe Promo Reimbursement F joe Sponsored promos  (joe is paying merchant on behalf of customer who redeemed the promo)
- Processor Fee G 9% rate unless during discount sign up period
= Merchant Payout H Amount transferred to the store's bank account

How do I calculate my transfer balance using an Itemized Report?

Note: We do not recommend pulling an Itemized report for calculating your merchant payout. Instead, use one of the reports listed above. Itemized reports are best used for consolidating number of items sold during the date range.  To calculate your merchant payout with an itemized report, you will also need information from the Summary report. 
Name Column Description
Goods Total B Gross sales - pre tax and tip
+ Total Tip Summary Row 6  (pull from Summary Report) Tips paid by customer
+ Total Tax Summary Row 7 (pull from Summary Report) Tax customer paid on order; to be remitted by shop
+ Reward Reimbursement E joe Sponsored rewards (i.e. if a customer uploads $25 to their account, joe credits them a free drink)
+ joe Promo Reimbursement F joe Sponsored promos  (joe is paying merchant on behalf of customer who redeemed the promo)
- Processor Fee Summary Row 10 (pull from Summary report) 9% rate unless during a discounted sign up period
= Total Merchant Payout Amount transferred to the store's bank account