Author Topic: Sales Tax Reports  (Read 14004 times)

prismbeer

  • Newbie
  • *
  • Posts: 32
Sales Tax Reports
« on: March 06, 2012, 07:52:53 am »
How can I run reports for sales tax collected?

Jack

JohnS

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 677
Re: Sales Tax Reports
« Reply #1 on: March 06, 2012, 08:10:07 am »
Have a look here http://forum2.sambapos.org/index.php/topic,232.msg1189.html#msg1189

Using Tax templates will show on Work Period Report as one total for all different tax templates.
Using Service templates will list each as a separate total for each service template.
SambaPOS - POS'n the World, one Terminal at a time.

prismbeer

  • Newbie
  • *
  • Posts: 32
Re: Sales Tax Reports
« Reply #2 on: March 06, 2012, 11:48:21 am »
I have 2 tax templates defined... However, I do not see them on any work reports ...

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: Sales Tax Reports
« Reply #3 on: March 06, 2012, 04:11:59 pm »
Did you assigned tax templates to product cards ?

JohnS

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 677
Re: Sales Tax Reports
« Reply #4 on: March 06, 2012, 04:45:58 pm »
Sorry, forgot to mention that in your tax templates you need to untick 'Tax Included to Price' to show Tax on the Work Period Report.
SambaPOS - POS'n the World, one Terminal at a time.

prismbeer

  • Newbie
  • *
  • Posts: 32
Re: Sales Tax Reports
« Reply #5 on: March 07, 2012, 02:49:05 pm »
ok for the future (although I like the "Tax included in price" feature. But, How can I get jan & feb sales tax? I am familiar with MS SQL to query, but need to know which table(s) to look in.


Jack

JohnS

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 677
Re: Sales Tax Reports
« Reply #6 on: March 07, 2012, 05:22:55 pm »
You can select the date range for the Work Period Report to give you total figures for 1-Jan-2012 to 29-Feb-2012.

SambaPOS - POS'n the World, one Terminal at a time.

prismbeer

  • Newbie
  • *
  • Posts: 32
Re: Sales Tax Reports
« Reply #7 on: March 07, 2012, 05:26:34 pm »
Apparently, since I have the 'Tax included in Price' checked, the tax wil not show up on my reports for previous sales (or will it?)

I can change this for all taxed items for the future, but how can I retreive tax for previous months?

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: Sales Tax Reports
« Reply #8 on: March 07, 2012, 06:35:50 pm »
prism do you need to add taxes to item prices while printing tickets or display tax totals under ticket?

prismbeer

  • Newbie
  • *
  • Posts: 32
Re: Sales Tax Reports
« Reply #9 on: March 08, 2012, 11:59:53 pm »
I'd like to do that as well for the customers sake, but I'm trying to get sales tax reports so I can pay my State Sales Taxes based on my sales.

Jack

japohara

  • Newbie
  • *
  • Posts: 3
Re: Sales Tax Reports
« Reply #10 on: February 28, 2013, 07:50:44 pm »
anyone have a solution for this ??