Skip to main content

Square: Post Discounts by Product or Discount

When completing a journal entry mapping, we have categories and subcategories. Categories are required to be mapped, or else the journal entry will fail to post to your accounting software. See below for an example showing Gross Sales as the category and the subcategories beneath it:

Example of Gross Sales category and subcategories

The subcategories can be located for a specific journal entry line by clicking the caret on the right, as shown below. If this caret is not present, it means this line does not have any subcategories:

Caret indicating subcategories for a specific journal entry line

Optional Subcategory Mapping

The subcategories are optional to map. In the case of the Square Summary, we offer the discount title/code or the product category from Square as subcategories for Discounts. This means you have the option to break down discounts by product category or discount title.

Creating Accounts with the Magic Wand

If you don't have accounts set up in your accounting platform, click on the "Magic Wand" button to the right, as shown below, which is visible per line. This will create an account in your accounting platform and map that line to this newly created account:

Magic Wand button for creating accounts

Once this account is created and mapped, the discount will be posted to the account in your accounting platform to give you insight into performance.

Changing the Default Discount Posting Method

The default discount posting method for Square is by product category. However, if you would like to change this rollup to per discount title, visit the "Connections" page and "My Apps" tab. From here, locate the Square connection and click “Setup” to expand the connection options to then locate "Configure," as shown below in blue. When clicking "Configure," this will open a modal to change the "Discounts Rollup Method."

Configure Discounts Rollup Method in Bookkeep

Below is the view with the Discounts Rollup Method option where you can select Product (default) or Discount, which will impact the subcategories for the discounts line as discussed above:

Discounts Rollup Method options: Product or Discount

note

When the discounts rollup method is set to Product, it will follow the product rollup method set for the Sales Rollup Method. That is, by product category.

Here is an example posting with the discounts, broken down by product category:

Example of discounts broken down by product category

Alternatively, after changing the discounts rollup method, here is the same posting above, except the discounts are broken down by discount:

Example of discounts broken down by discount title

As always, feel free to contact support@bookkeep.com if you have any questions.