Billing Options: Sales Tax Rates
System Setup | Setting Up Items | How Tax Applies To Client Invoices | Tracking Tax-Exempt Clients | Printing The Invoice | Reporting | Resources
Menu > Admin > System Setup > Time and Billing > Sales Tax Rates
Sales Tax Rates are used to automatically calculate sales tax amounts on project estimates and client invoices. Sales Tax Rates can also be linked to vendors, so you can automatically determine the amount of sales tax due at the end of the year.
You can have any number of sales tax rates setup, however, only two rates can be setup on a client/vendor to automatically calculate. If possible, combine city/county/state taxes where possible.
Though only two tax rates will default onto an invoice, you are able to add Other Tax rates to individual invoices.
VAT (Value Added Tax) can be setup as a tax rate. See below regarding the Piggy Back Tax setting to ensure compliance with your local tax regulations.
Sales Tax ID: Text box, enter a unique ID for the sales tax code.
Sales Tax Name: Text box, enter a descriptive name for the sales tax code.
Invoice Description: This is used to label the Estimate and Invoice Sales tax. Enter a description that should show on client invoices and estimates when the sales tax code is used. If this is left blank, the Sales Tax Name field will be used.
Paid To: Text box, enter the vendor ID of the Tax Authority this tax will be paid to.
Tax Payable GL Account: Text box, enter the GL account you want to track the collected sales taxes for this specific code.
Tax AP GL Account: Enter the GL account you want to track the vendor paid sales taxes for this specific code. For the US, this is typically left blank as taxes charged by your vendors are just part of the overall expense. For Canada, this GL account may be set to the same account as the Tax Payable GL Account, in order to report on the difference between Client Taxes Collected vs Vendor Taxes Paid for your tax authority.
Sales Tax Rate Percentage: Text box, enter the percentage for the sales tax. The percentage should be entered as 6.25 for 6.25%, not .0625.
Active: Checkbox if you do not want people to be able to use this sales tax code, but it is already tied to existing transactions.
Piggy Back - NOTE: This type of tax is not used in the USA. Check this box when 2 tax rates are applicable and this tax should be calculated over the invoice Total + Tax 1. For example, the invoice Total + the Provincial Tax amount X the Federal Tax to arrive at the invoice Grand Total.
NOTE: This type of tax is not used in the US, however, you can have 2 tax rates calculated without “piggybacking” them. In this case, the first Tax is calculated based on the invoice Total and then the second Tax is also calculated based on the invoice Total. The invoice Grand Total is comprised of the invoice amount + Tax 1 + Tax 2 (it does not matter if the Tax rates are State or Federal or a combination of each).
Setting Up Items
In order for Sales Tax to track correctly and flow through to billing, you must also set up the following items:
Services - Define what services are taxable or not
Purchase Items - Define what purchase items are taxable or not
Expense Report Items - Define what expense report items are taxable or not
Broadcast Items and Print Items - Define what media items are taxable or not
Client Record - Define the tax rate(s) associated with the client
Vendor Record - Define the tax rate(s) associated with the vendor. This should only be used if your tax authority requires you to track tax paid to vendors, such as, Canada and Europe. If you are in the US, do not set this up.
How Tax Applies To Client Invoices
Taxes are applied at the line level of client invoices, not individual transactions.
The taxable or non-taxable status needs to be determined by separate lines in the invoice.
This process of generating invoices is based on your setup of items as well as each client's setup.
Time and Materials
To make this process as streamlined as possible, you will want to set up the client record to be "One Line Per Billing Item and Item". This way when you generate an invoice, each service and expense will have its own line on the invoice and based on how that service or expense is setup, then client designated tax will then apply to each line.
You can then use Billing Worksheets and/or Mass Billing - Production to generate these in mass, which relies on system setup and client setup.
To get as close to the Time and Materials process as possible, you will need to generate your Fixed Fee Invoices by "Percentage of Service and Item".
You can then use Billing Worksheets to facilitate this process as well.
Manually Creating the invoice.
If you manually create an invoice or edit an existing one, keep in mind that tax is applied at the invoice line level. If you have two service transactions, one is taxable while the other is not, then you need to create at least two lines, one for each service. Apply tax to the one line with the taxable service and not to the other.
You can also create a sub-line, where maybe your top line is Called Services, and you then create two lines under it. One sub-line being taxable and the other is not.
Retainers do not use Taxes, as it does not bill or generate the line detail to do this.
In some rare cases if you do need to tax the total amount of the retainer, such as in Canada, then you can set up the tax as stated above and then after you generate the invoice, check the Tax Applies box for the line generated.
If you happen to have Expenses Not Included, then it will create a separate a line/or invoice of those transactions. However it puts the transaction into one line, so you would need to manually break them out into separate lines to get the tax the way you need it.
Tracking Tax-Exempt Clients
Even though the client may be tax-exempt, it is still recommended that you track the invoice amount into the sales tax report to provide easy reporting to the tax authorities.
System Setup: Sales Tax Rates> create a Non-Taxable or Tax-Exempt rate. Set the Tax Rate % = 0
NOTE: If you have out of state clients that are tax-exempt, create an Out Of State/Non-Taxable sales tax rate to differentiate between local and out of state sales.
Client Setup: Billing>Defaults>>set the client Sales Tax 1 to the appropriate Tax-Exempt rate.
Printing The Invoice
When using taxes properly while generating invoices, more lines may be created in the invoice than what you want/need to show the client on the PDF printout.
If this is the case, then please review the Invoice Layout options on how to show the details you want.
Old Layout Tool - Invoice/Estimate Layouts
Layout Tool - Invoice Templates
To monitor sales tax overall, run the Sales Tax Analysis report.
This report will display the total amount invoiced for the selected period along with a break out for each Sales Tax Rate that was used.
Tax-Exempt/Non-taxable rates will also be displayed with the total amount billed that was considered non-taxable.