Q: How do I get a report of taxable and non-taxable sales, e.g. for our quarterly sales tax returns?
A: Because it doesn't keep track of which amounts were taxed, there isn't a specific report for this. Here are 2 ways you can get taxable sales information:
1. Use a category report ("Charges by Category" or "Receipts by Category") to get categorized sales, and total up the categories that are taxable for each tax rate. This of course requires that you set up your categories such that they can be separated this way. For instance if you tax cabins one way and tents another, then don't just use the default "Daily Rate" category in all of your daily rates. Set up a "Cabin daily" category and a "Tent daily" category, and use them accordingly (see Pick Lists / Transaction Categories).
2. Use the category report as above, then calculate backwards from the tax categories shown. For instance if Sales Tax shows $100 and your sales tax rate is 5%, then the taxable sales for that is $100 divided by .05, which is $2000. Of course this may not exactly match your sales, since the individual sales are rounded, but it should be close -- also be aware that it's based on tax actually collected, whether you collected the appropriate amount or not.
Page URL http://CampgroundMaster.com/shelp/reportingtaxablesales.html
Campground Master Home