Income Tax

M

maria

3647I am working on a worksheet to figure the calculations and submit the
accrued sales payment on a monthly basis. Cell B2 has the sales amount of
53647.81, cell C2 has the sales tax. Oklahoma has a sales tax of 3%-3.75%,
what type of formula would I use?
 
F

francis

Hi Maria

How does the tax scale is like? ie what amount is tax at 3%,and so on
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis
 
J

James Silverton

francis wrote on Sat, 14 Mar 2009 08:50:06 -0700:
How does the tax scale is like? ie what amount is tax at
3%,and so on --
Hope this is helpful
Pls click the Yes button below if this post provide answer you
have asked
Thank You
cheers, francis
"maria" wrote:

This is prompted by a tax program (TurboTax) that did not work for the
state form but can anyone recommend an Excel template, or whatever, for
non-business forms? I put one together years ago to settle whether joint
or separate returns were better but I've never used anything for
submission but commercial programs and I am now using the rival TaxCut.
The commercial programs have the advantage that they print the actual
form that the IRS expects.
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not
 
S

Simon Lloyd

Are you adding the sales tax or simply splitting the elemets from th
sales said:
3647I am working on a worksheet to figure the calculations and submi
th
accrued sales payment on a monthly basis. Cell B2 has the sales amoun
o
53647.81, cell C2 has the sales tax. Oklahoma has a sales tax o
3%-3.75%
what type of formula would I use
-
Maria A Adam

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
B

Bill Sharpe

maria said:
3647I am working on a worksheet to figure the calculations and submit the
accrued sales payment on a monthly basis. Cell B2 has the sales amount of
53647.81, cell C2 has the sales tax. Oklahoma has a sales tax of 3%-3.75%,
what type of formula would I use?
Not enough information. What was the actual percentage, not range, of
sales tax for this purchase? In California, for example, the sales tax
varies from county to county. Typically, you would take the tax from
each sales receipt, unless of course they're all made in the same county.

Bill
 
J

joeu2004

maria said:
I am working on a worksheet to figure the calculations and
submit the accrued sales payment on a monthly basis.

So I assume you are retailer. Right?
Cell B2 has the sales amount of 53647.81, cell C2 has the
sales tax. Oklahoma has a sales tax of 3%-3.75%, what
type of formula would I use?

That is inconsistent with the information I find online. Oklahoma sales tax
varies between 4.5% and 10% based on the ZIP code of either the seller or the
purchaser, generally depending on where the product is received. See
http://www.oktax.onenet.net/pod/retven.htm .

No matter. If you are a retailer, your records should show the amount of
sales tax charged for each purchase. The amount in C2 is the sum of those
sales tax amount, something like:

=SUM(X1:X100)

If this does not seem to answer your questions, please explain your
circumstances in more detail.
 
G

Gord Dibben

Based on what criterion(a)?

Looks like 3-3.75% is a sliding scale.


Gord Dibben MS Excel MVP
 
R

Ross

Are you referring to city rates within the state of Oklahoma? Those seem to
range from 3 to 4%, if I'm not mistaken.

smither fan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top