Reply
 
LinkBack Thread Tools Display Modes
Old 01-05-2011, 08:14 PM   #1 (permalink)
Junior Member
 
Join Date: Aug 2006
Posts: 1
Graham tomlinson is on a distinguished road
Default Reports With incorrect tax..

Hi
Does anybody know how to get the tax calculation to be worked out from the equipment total? Every report uses rounding of the individual items tax so the Tax ammount is always incorrect and doesnt look very professional.
Thanks
Graham
Graham tomlinson is offline   Reply With Quote
Old 01-05-2011, 11:36 PM   #2 (permalink)
Senior Member
 
JordanC's Avatar
 
Join Date: Mar 2006
Location: Orange County, CA
Posts: 377
JordanC is on a distinguished road
Default

Graham - I am note sure why your tax amounts are coming out incorrect. The most I have ever been off is 2 cents. Values have to be rounded because there are no algorithms to calculate infinite numbers. Taxes are rounded to 2 digits for each item, and then the tax fields are added at the end.

The only other way this can be done is by calculating the taxes at the end of the report based on the equipment total. Only the problem is that D-Tools offers 'non-taxable' option for every item in the project.

If you are achieving tax variances by more than a couple pennies, then you might want to check that all of your equipment is being taxed. Best way to do this is in the DataMatrix > Right click column header > Columngs & Grouping > Select to view the 'Taxable' field. Refresh and you should see that every line item you want taxed has a check mark.
__________________
Space available for rent.
JordanC is offline   Reply With Quote
Old 01-08-2011, 09:11 AM   #3 (permalink)
Junior Member
 
Join Date: Sep 2010
Location: London
Posts: 5
itsdone is on a distinguished road
Default

I'm experiencing the same problem.
I have followed JordanC's instructions and double-checked that every single product is taxed.
The difference I've found so far (I have not been using D-Tools for long) is around 5 pence (I'm based in UK) on approx. £85k project (before tax).
The tax calculated by D-tools is 5 pence higher than it should be.
Not sure what will happen when I create much larger project.
The way D-Tools calculates Tax for the whole project seems to be incorrect.
As far as I know the accounting applications calculate tax based on the total net of the project - not based on total of taxes (rounded) of all products.
5 pence isn't obviously a huge amount but I believe it still looks unprofessional if the client picks this up. Especially if they use a professional project/cost manager.
itsdone is offline   Reply With Quote
Old 02-10-2011, 09:13 PM   #4 (permalink)
Member
 
Join Date: Mar 2010
Posts: 62
John@OnyxTheaters is on a distinguished road
Default

We're having the same issue.. Although we're only a couple of cents off sometimes, the person doing accounting and billing isn't too happy about having to fix it on their side everytime this happens..

I've double checked to make sure all of my items are taxable and that I have the correct tax rate.

Anyone know of a solution?
John@OnyxTheaters is offline   Reply With Quote
Old 02-11-2011, 09:03 PM   #5 (permalink)
Senior Member
 
Join Date: Mar 2006
Location: Novato (20 miles north of San Francisco)
Posts: 445
fryeguy is on a distinguished road
Default

Are you guys having this problem using SI4 or SI5? These posts are all located in an SI4 thread...
fryeguy is offline   Reply With Quote
Old 02-16-2011, 09:11 PM   #6 (permalink)
Member
 
Join Date: Mar 2010
Posts: 62
John@OnyxTheaters is on a distinguished road
Default

Si5.
John@OnyxTheaters is offline   Reply With Quote
Old 02-23-2011, 12:41 AM   #7 (permalink)
Member
 
Join Date: Oct 2007
Posts: 32
Soundboy is on a distinguished road
Default

I'm having the same problem. It did not start until I did the update. It also throws it off when sending it to quickbooks
Soundboy is offline   Reply With Quote
Old 07-20-2011, 11:48 PM   #8 (permalink)
Junior Member
 
Join Date: May 2009
Posts: 2
arsim is on a distinguished road
Default

Same Result here in Australia using GST for tax calculation.
All reports (and project summary within the estimating program) are consistently off by 2-7 cents (depending on size of job).

I am pretty sure this didn't use to happen before the last update.
One of our customers accounting departments caught it, and it doesn't look very professional.

Anyone got a solution yet?
arsim is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 05:11 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.0
D-Tools, Inc.