VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Suggestions for future release
 sort sales summary by state
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Lori Titus
VP-ASP New User

126 Posts

Posted - December 20 2008 :  12:12:13  Show Profile  Visit Lori Titus's Homepage  Reply with Quote
Here is a reporting feature that would be really, really useful for me:

I have a "significant business presence" in two states. Therefore, I have to pay sales tax on Internet sales in those two states.

For end-of-month sales tax reporting, it would be useful to get a line-item report similar to the following:

State Gross Sale Taxable Sales Tax Collected
MD 1,000.00 88.50 5.31
PA 500.00 38.67 2.32
Other 12,000.00 0.00 0.00


Right now, in order to get this info, I have to download the monthly sales into a txt file, open it up in excel, cause it to sort by state, and plug in the calculations. I would love a one-step method.


The Internet's #1 supplier of honey and beeswax.

cayars
Starting Member

USA
49 Posts

Posted - December 21 2008 :  02:34:59  Show Profile  Visit cayars's Homepage  Reply with Quote
Just curious but are you running on an access database or a SQL database?

Either way (but easier on SQL server) you can easily run a sql query against your database to get this info.

Something you want to be aware of is the difference between orders taken and orders shipped when looking at reports.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000