Skip to content

Taxes Report

Switchboard: Main->Reports->Taxes Report and Main->Register Functions->Taxes Report
Menu: Reports->Financial Reports->Taxes

Action: RP_TAXES

Overview

This report shows the taxes collected by your store. It is broken down by ProfitSystem account number since each tax has a ProfitSystem Account number associated with it. If you have multiple tax rates to collect, you must assign each one to a different ProfitSystem account number when they should be totaled separately. The report also shows your sales for each tax rate, and non-taxable sales, broken down by inventory category.

If you have multiple stores, the report will break down the taxes collected and taxable, non-taxable sales for each store.

This report will also show any Tax Forward (TF) transactions that have been realized in the date range specified. The sum of the Tax Forward (TF) transactions for a specified time period will need to be added to the retail and rental tax figures from the revenue report for the same time period. This will insure that you are paying the correct amount of taxes. TF transactions are normally created as part of the BPS data conversion. They are also entered when adding existing customers to the program during setup if your shop uses the ticket zero or pickup accounting method.

Notes:

ProfitSystem will allow sales tax rates to be added, modified and removed anytime from sales transactions, EVEN if the tax has been previously realized. This report is designed to reflect those changes. For example. Suppose a sales tax was charged on a gown in January and realized on the Daily Revenue Report & reported on this Taxes Report. Now, suppose in February a user removed the sales tax from the sales item. Now, the Revenue Report & this Taxes Report will show a decrease in sales tax collected, a decrease in taxable sales and an increase in 'non taxable sales' in the amount of the sales item on the ticket that was affected, even though there wasn't any NEW sales transaction, there was just a tax reduction that took place.

There is no relation of the sales totals on the Taxes Report to the sales totaled on any sales reports (like Sales by Category). In most cases they would not be the same number.

You can run the Revenue Report in 'detail mode' and look at the tax section to see the ticket numbers of the included sales transactions where the tax was realized on this report. This would allow an audit of the tax totals by allowing the operator to review the ticket transactions. ​

Hint:

Enable the TICKTAX security setting to require a password to manually add/remove tax to a sales transaction. Logging the use of this feature via the Actions/Transfer table is available when it is password protected and would allow management to see whom is taking advantage of this capability

Criteria

Between xxx and yyy...Shows the taxes collected for the dates xxx through yyy, inclusive. You must enter a date range.

Limit to store(s)...Limits the taxes listed to the stores entered (available with the multi-store integration option). Leave blank for all stores.

Department...Limits taxes to the department entered. Departments are set up in General Setup->Departments and each register/workstation can be assigned to a Department. Therefore, selecting a Department will only list taxes created on the Registers in that department.