Set up a category flat tax

Category flat tax functionality is available to users with version 18.1.107 and is not enabled by default. If you're on an eligible version, use the instructions below to get started. 

Multi-store retailers: If you share tax rates between locations, category flat taxes must be configured at your primary location and are shared in the nightly Data Exchange.

Please note that Category Flat Taxes cannot be edited by line item within a sale transaction. To exclude individual customers, edit their Customer Record by applying a Tax Exception. The instructions below are meant only as a guide - please consult your tax specialist for up-to-date state and federal law requirements. 

Unhide the tax rate 

1. Navigate to Database Explorer > Tax Rates
2. Enable the Show Hidden option near the top right corner
3. Select CategoryFlatTax and click the Restore icon

Set your preferences

1. Double-click on the unhidden CategoryFlatTax type to edit tax Amount, Description, mapped QuickBooks account, and Tax Items.

Sherpa tipOregon retailer? Set the Tax Type Amount to $0.00 and update the Category Tax field (next section) on all applicable bike categories to $15.00 for the bicycle excise tax starting January 1st, 2018

2. Click Save to record your changes or Cancel to close the window without saving changes.

Assign to categories

1. Navigate to Database Explorer > Categories
2. Double-click on the categories that you'd like to add the tax to
3. Set the flat tax by updating the field below the tax grid with the desired tax description

4. Click Save to record your changes

Sherpa tip: Category flat taxes must be set individually, by category. Flat tax rates will not be applied to any other category (including child categories) automatically. 


Getting a Validation Failed! error message when attempting to save an unmodified Tax Type like the one below? Don't worry! Simply click Cancel on the Edit Tax Type window to proceed. The default settings will be used and your Tax Type will be ready for use

Additional Resources


  1. Run a sales transaction
  2. Complete a return
  3. Create a layaway
  4. Create a quote
  5. Add a customer
  6. I messed up a sale/payment. How do I fix it?
  7. Change a Tax Rate during a sale
  8. Set up a category flat tax
  9. Create a sales promotion
  10. Add or edit products for an existing sales promotion
  11. Create, edit, and use coupons
  12. Download coupons using the Coupon Wizard
  13. Discounting By Quantity Purchased (Kits)
  14. Record a payout
  15. Sell a Gift Card
  16. Sell a Gift Certificate
  17. Issue In-Store Credit
  18. See sales totals for my customers (like what they owe us, what we owe them, and what they've spent over time)
  19. Use the Cash Drawer Counter
  20. Add a country in Ascend
  21. Add a Tax Exception Reason
  22. Create custom payment types
  23. Print a large receipt for a transaction
  24. Exchange a product for a customer
  25. Use rounded payments
  26. See who took a payment
  27. Change the customer in a transaction
  28. Charge a purchase to Purchase on Account (accounts receivable)
  29. Set up Purchase on Account for a customer (accounts receivable)
  30. Close Purchase on Account for a customer (accounts receivable)
  31. Post a payment to Purchase on Account (accounts receivable)
  32. Send invoices for Purchase on Account (accounts receivable)
  33. Handle Special Order items
  34. Process a cash payment
  35. Process a check payment
  36. Process a custom payment type
  37. Process an eCommerce payment
  38. Process a financing payment
  39. Process a gift card payment
  40. Process a gift certificate payment
  41. Process an in-store credit payment
  42. Manually process a credit card, Trek Card, or gift card payment
  43. Process credit or debit card payments using the (Ingenico) payment terminal
  44. Process a Trek Card payment
  45. Process a trade-in payment
  46. Manage Discount Reasons
  47. Discount items on a transaction
  48. Create and Use Customer Groups
  49. Using customer data

Feedback and Knowledge Base