Canada Taxes -1 or 2 proposals/contracts - D-Tools Forum

10-25-2006, 05:34 PM

In Canada we have to deal with sillyness regarding PST(RST) and GST and whether or not line items are "builtin" or "funiture" as they are taxed differently.

With 1 proposal for lowvoltage, lighting control , av wiring, Av equipment, control systems proposals for clients, the taxes always seem to raise eyebrows due to inconsistencies in how the taxes are presented in the quote and then in the invoice.

the thought was then to do 2 quotes -1) for builtin in items such as inwall wiringing, terminations and 2)a separate quote for "furniture" items such as av gear, touchpanels, etc so that the tax is easier to understand,

but if we have 2 proposals for essentially 1 system the one proposal is not going to have all the data required (wires/wire#s) to do the drawings...

I hope the problem is clear. Any ideas on how to resolve this?
Thanks in advance
Paul

Reed Phillips · 12-27-2006, 06:46 PM

Do all the items with a particular Tax code like "Builtin" need to be grouped together? Would it be OK just to show the totals in the project summary?

Like...
Builtin Total
Builtin Tax

Non-Builtin Total
Non-Builtin Tax

Grand Total

Would it help to be able to group and show total based on Tax Code?

Could you show an example in Word or Excel of the ideal report format?

JordanC · 12-27-2006, 09:05 PM

Why not make a canadian version where they have 2 tax rate options in the project options? And in each item in the database, have a field where they can select the built-in or non built-in tax field.

Speakers - SpeakerCraft Aim7 Two : Tax, Built-in
Equipment - Marantz SR8001 : Tax, Non Built in
Equipment - Crestron TPS300L : Tax, Built-in
et cetera?

Reed Phillips · 12-28-2006, 12:44 PM

What you propose is possible in the current interface by using the “Purchase Tax Code” and “Sales Tax”. We are correcting some implementation issues in V5. It is not worded as nicely as you suggest, but it is workable. We are improving the documentation to make Canadian Taxes more understandable. Given the creative nature of taxing authorities, we anticipate that other Non-Canadian D-Tools users may need this functionality to properly estimate taxes. I was asking more about how to present the data on reports. Based on the previous post, it seems that the client is confused about how the taxes are computed. I'm trying to understand how to best present the taxes of client reports. Can you handle it in the Summary, or do the line items need to be grouped together? This may be possible in V5. I want to make sure we understand the issue.

12-29-2006, 12:07 AM

I am not using the taxes in d-tools for I cannot afford any errors in tax calculations. please help us............!!!

To calculate the taxes in my province this is how we do it...

$100.00
$ 6.00 6% GST
$106.00
$ 7.95 7.5% PST
$113.95 TOTAL

Reed Phillips · 12-29-2006, 12:24 PM

Are you in Quebec? It is the only province we are aware of that calculates Tax on Tax. To make the math work out you need to add 6% to your PST.

Until the Quebec exception can be added to SI, you should use .0795 as the PST value. QST= PST+PST*GST

Will this work for you?

Reed Phillips · 12-29-2006, 07:17 PM

Originally Posted by paradigm

In Canada we have to deal with sillyness regarding PST(RST) and GST and whether or not line items are "builtin" or "funiture" as they are taxed differently.

When you say "differently", is this a different rate or are the taxes applied to the cost of the item rather than the selling price?

12-29-2006, 08:16 PM

Yes I am in Quebec,
That is actually a good idea. I will cheat that way for now, but I sure hope they can fix this soon.
Thanks

Reed Phillips · 12-30-2006, 12:33 AM

Don't expect this change anytime soon. There is no other taxing district I know of that charges tax on tax. It would require a significant change in the way taxes are computed. It is on the list to be addressed, I just don't know when.