Daily Sales Report & Payout Reporting
Simple daily sales reporting is available for POS locations receiving multi-bank settlements from Bookkeep for Shopify Payments.
Our portal is location here: www.bookkeep.com/payouts
Available in our payout portal are simple net sales totals by date range as well as an export of all multi-bank settlement transactions. As well as simple revenue reporting.
Simple revenue report:
Clicking into a day will display detail for the sales day on revenue, discounts, gift cards and payments.
Sales By Day:
The payout report for each location lists the last seven sales days, with Load More and Search Date Range for older days. Hover over any column header for a description of what it contains.
| Column | What it contains |
|---|---|
| Net Sales | The location's net sales for the day from the Shopify sales summary: gross sales less discounts and returns, before tax and shipping. Franchise fees are calculated on this figure. |
| Shopify Payments | What customers paid through Shopify Payments at the location that day, net of refunds and before Shopify's processing fees. This is what Shopify is expected to deposit for the day. |
| Received from Shopify | The gross Shopify Payments for the day that Shopify has deposited into the franchisor's source bank account so far. Shown in amber while it is below the Shopify Payments column, which means Shopify has not yet deposited the full day. |
| Received by Location | The gross Shopify Payments for the day that have already been included in a payment sent to the location. |
Once a sales day has been fully deposited by Shopify and paid out to the location, the Shopify Payments, Received from Shopify and Received by Location columns all match. In the example above, September 1 to 3 are complete, while September 4 to 7 are still waiting on Shopify's deposits, which normally arrive a few business days after the sale.
If your franchisor holds franchise fees until each day is fully funded, the fee for a sales day is deducted from the first payment after Received from Shopify reaches the Shopify Payments total for that day. See How to Create Franchise Fee Settings for Payout Groups.
Export file for multi-bank settlement:
An export file with full detail on payout composition is available for download. Each BOPIS, Gift Card, Franchise Fees and Shopify Payouts are fully detailed in this export report.
Email Sent for Each Payment:
Each payout group can have one or multiple email addresses associated. Every payment sent will trigger an email with full details of what is in the upcoming payment. The email can be in french or english. The email shows a link to the portal for more detailed download capabilities.
