Calculate tax and w/out tax
I'm creating an invoice for services provided for our business. Essentially we dispatch service technicians out to businesses we use numbers to type out our service orders and with a calculated invoice total for product and services rendered.
However our services are not taxed but our products are. basically Line 1 of the invoice grid is our dispatch service rate and the descending lines below it our product lines that are taxable.
How can I use one grid to calculate the total invoice that has both the taxable and not taxable product lines?
For example:
| Description | Quantity | Unit Price | Cost |
|---|---|---|---|
| Dispatch SVC p/h | 2 | $150.00 | $150.00 |
| Product 1 | 1 | $49.00 | $49.00 |
| Product 2 | 1 | $29.00 | $29.00 |
| Subtotal | $228 | ||
| Tax | 8.5% | $19.38 | |
| Amount Due | $247.38 |
Essentially if the Dispatch was calculated without tax it should look like:
For example:
| Description | Quantity | Unit Price | Cost |
|---|---|---|---|
| Dispatch SVC p/h | 2 | $150.00 | $150.00 |
| Product 1 | 1 | $49.00 | $49.00 |
| Product 2 | 1 | $29.00 | $29.00 |
| Subtotal | $228 | ||
| Tax | 8.5% | $6.63 | |
| Amount Due | $234.63 |
Any ideas?
thanks!
