How sales tax should be calculated in the US & Canada ???

I'm writting a time tracking software, which will enable people to record time spent on a given task and then generate a sales invoice based on the billable hours.

I'm aware that there's a different sales %tax rate% for each US state, but I wonder how this should apperas on a sales invoice

My questions

1/ If I'm a Californian based company which issue a sales invoice to a Massachussets based company, does sales tax should be calculated for the invoice ? If sales tax should appears which rate should I put on the sales line (The MA or CA rate?)

2/ Imagine I've got a sales invoice which contains those 3 lines :

(The quantity are hours of work, and the description are services)

____________________________________________________________ __

Qty Description Unit Price Amount Amount inc Tax

8 Programming 100 800 ??? 1 Support Call 100 100 ??? 1 Design Spec 100 100 ??? ____________________________________________________________ TOTAL 1000 &nb sp; &nb sp;

2.a : Should I add the tax rate on each line to work out the Amount Inc TAX per sales invoice line or should I only add it to the $1000 TOTAL ?

2.b : Could you take my example and calculate the tax on this simple invoice ?

3/ Does any other kind of tax should appears on a sales invoice ? governmental ? federal ? provincial (for Canada) ??

Well I just hope calculating sales tax for North America (USA & Canada) is not a too complex process

Thank you in advance for your help

Reply to
The Night Blogger
Loading thread data ...

"The Night Blogger" wrote

Well, you have tons of code to write, as there are differing rate on different items and/or services. And, luckily for your writing fingers, they change - often as often as quarterly.

Whether sales tax applies to a given sale is a matter of state and local law. In general though, sales to out of state customers, when the goods are shipped, are not taxed with in-state sales tax. However, if you were to go to MA and provide services or deliver the product, then that states sales tax applies. Along those lines, if the MA customer were to come to you to get services or pick up the products, then CA sales tax is applied.

This is not a simple 'one-line' of code you have to write.

Most billing programs allow for the application of a tax to the services or products the user enters. Of course, given the various users situations, they can easily exempt tax from a specific product or service.

Reply to
Paul Thomas, CPA

Thanks for the feedback Paul, I'm aware that it's not a single line of code. I will provide a list of State (for the US) and Province (For Canada) so the user can modify the Tax rate when those change, so it will be flexible

I just wonder where I can find the algorithm or process for determining the Tax Entries I should generate. Mainly for Canada which seems more complicated than the US since there's federal, provincial and governement tax it's seems a bit tricky.

Reply to
The Night Blogger

"The Night Blogger" wrote

Very. Even in the US there are state rates and county/city rates and multiple jurisdictions that you would report and pay to.

Why not allow for a tax rate to be applied based on what the user enters, that relieves you of liability for keeping the rates up-to-date.

Reply to
Paul Thomas, CPA

Should I just the have ONLY one field called "Sales Tax %" (for each sales line)

And the user will manually enter the correct rate based on their state (check rate below)

formatting link
Is it ok in accounting terms, if I update a Sales Tax Ledger entries table (after the sales invoice has been posted) based on all the sales invoice line posted The user will be then able to compute how much of sales tax he has charged for a given period. This table will be basically the sum of the "Sales Tax %" field

This seems to simple to be true :-)

Reply to
The Night Blogger

For the USA:

If your company is based in state X and has no business presence in states Y and Z, then you must collect and remit sales tax sales in state X and not in states Y and Z. Customers in states Y and Z should file use taxes. In some states, services are not taxable.

Furthermore, some customers will be tax exempt, so selling to a tax exempt customer in state X would cause you NOT to collect and remit sales tax. One must evidence the tax exempt status in an audit.

Thus far, an internet presence does not constitute a business presence in another state.

IF you design your code for the customer to put in a rate and you collect it, you WILL be responsible for remitting it to the proper agency. This would be a nightmare.

Sales taxes are calculated based upon the point of sale; hence, if a person from state Z comes to state X to pick up goods or receive services, state X rates apply. If goods are shipped from state X to state Z, state Z rates apply, but are not collected by the merchant and must be remitted by the customer as use taxes.

USA sales taxes are anything BUT simple. Beverly

Reply to
Beverly

Also, there are multiple jurisdictions within the same state, i.e., Philadelphia sales tax is different than other parts of Pennsylvania; certain counties in New York are different than others. So you may be able to find a table that has rates based on the zip code rather than the state as a whole.

Reply to
Meyer1228

"Meyer1228" wrote

While you may be "close enough" using zip code data, some cases the zip cods is the same for more than one county, and if the rates are different for each county, then you could be imposing not enough, or to much.

Plus, if you have to remit the tax, you could easily be sending it to the wrong place.

Reply to
Paul Thomas, CPA

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.