Skip to main content

Mindbody Sales Summary

Bookkeep offers a daily sales summary journal entry for Mindbody that posts to your accounting platform on a daily basis, capturing the sales from the prior day. This includes gross sales down to net sales, discounts, refunds, and the breakdown of payments by tender type.

Below, we review an example of what Bookkeep recorded versus Mindbody.

Step-by-Step Review Process​

Step 1: Retrieve Daily Closeout Report​

Bookkeep best aligns with the Daily Closeout report that can be retrieved from Mindbody for a specific day under Reports from the Mindbody top navigation.

Location of the Daily Closeout report in Mindbody

Daily closeout is under sales reports:

Sales reports section in Mindbody

Step 2: Include Gift Cards Report​

The Daily Closeout report does not include gift cards issued. You must fetch the gift cards report also under the sales section:

Location of the Gift Cards report in Mindbody

Select prepaid gift cards and filter to the day and location:

Filtering the Gift Cards report by day and location

Negative amounts in the gift card report indicate redeemed gift cards, and positive amounts indicate issued gift cards.

In the example below, we have fetched the gift card report:

Example of the Gift Cards report in Mindbody

For 6/1/23, we see a total of $148 issued and $211 redeemed as posted below.

Step 3: Review Bookkeep Entries​

In this example, we are reviewing 6/1/23, and below shows what Bookkeep posted:

Entries posted by Bookkeep for 6/1/23

Step 4: Fetch Daily Closeout Report​

Fetch the daily closeout report in Mindbody as shown here:

Fetching the Daily Closeout report in Mindbody

Step 5: Reconcile Reports​

When tying out the report to Bookkeep, start with gross sales and discounts. The numbers in the Mindbody report are shown after discounts. Subtract the discount amount per category from the gross sales amount per category to align with the report.

Mindbody:​

Mindbody report showing gross sales and discounts

Bookkeep:​

Bookkeep report showing gross sales and discounts

On this date, there were no discounts, so no subtraction was necessary.

Step 6: Reconcile Refunds, Gratuity/Tips, and Payments​

Next, tie out the refunds, gratuity/tips, and payments.

Mindbody:​

Mindbody report showing refunds, tips, and payments

The tips total of $820.35 matches what Bookkeep posted as well. The $168 total returns in the Mindbody report match what Bookkeep posted. The total column on the right per payment type matches what Bookkeep posted.

Bookkeep report showing payment types

note

Mindbody does not include the amount received in the payments for gift cards sold/issued. For Visa/MC, Bookkeep shows 8340.05, while Mindbody shows 8192.05. This difference of $148.00 represents the gift cards issued.

Step 7: Reconcile Accounts Receivable​

The final number to tie out from Mindbody is the accounts receivable, called Payments on Account. Bookkeep posted:

!Bookkeep report showing Accounts Receivable

[](/img/mindbody-journal-entry-sales-summary-11.png)

This ties out to the sales by category section of the daily checkout report as shown below:

Mindbody report showing sales by category

If you have any questions regarding our Mindbody journal entry, feel free to contact [email protected]. We understand the complexity of reporting and can save you much time with this accounting automation.

info

Mindbody is supported by Bookkeep Sales Tax.