Please visit our COVID-19 Resources page for useful payroll and reference information. During this time, when many companies are forced to telework, AccountEdge Hosted may be a good option. Host your company file to be accessed remotely from any device, for as long as you need. You can go back to your regular setup when you no longer need remote accessibility. If you’d like to discuss that or any other teleworking solution with a product specialist, please call 800.322.6962. Be safe.

  • Section: Sales
  • Last updated: July 1, 2019, 4:38 p.m.

How Sales Tax is Calculated in AccountEdge

When a sale is created in AccountEdge, the pre-tax amounts for each line are calculated and rounded to the nearest penny, if necessary (we only around to two decimal places).

 

These line amounts are added up to get the total amount for the sale.  Amounts that are taxable for each tax code (in the US there can be only one) are totaled separately.

 

The tax on that total amount is calculated and rounded to the nearest penny.  That tax is the total tax for the sale.

We then distribute this tax across the lines of the sale using the following rules:

  1. Each line that is taxed by the same code, except the last line, we calculate the tax on the line using the proportion "total tax on sale”/"total taxable amount" and round it to the nearest penny.
  2. For the last line that is taxed by that code, we include all of the tax that has not been allocated to the preceding lines.

The above rules ensure that the total tax on the sale is equal to the sum of the tax amounts charged on each line.

What this means is that if you create a sale in AccountEdge that has multiple lines with the same dollar value - you can have the two lines show different totals including tax. This is correct and should display this way.