Adjusting GST/VAT/TAX Rounding

MoneyWorks calculates GST/VAT/TAX for every line item. This makes it very easy to enter transactions for items with different tax rates. It does also mean that the tax gets rounded per line item. In addition, MoneyWorks performs Tax rounding using Banker's Rounding (also known as Round-Half-Even, meaning half-cent values are rounded towards an even whole number)‚ which reduces the incidence of accumulated rounding error.

Some other accounting systems use different rounding methods (often simply rounding all half cent values upwards), or calculate tax totals based on the entire transaction Net, instead of by line-item. When you receive an invoice from a supplier who uses one of these systems, the Tax total may differ by a few cents from that calculated by MoneyWorks. In such cases, it is desirable to make the Tax rounding (and hence the invoice total) match the invoice you have received.

When you find that a supplier invoice total, as calculated by MoneyWorks, differs by a few cents from the original invoice (due to Tax rounding):

  1. Choose Edit>Adjust GST Rounding, or press Option-⌘-A (Mac) or Ctrl-Shift-A (Windows)

The rounding of any half-cent GST values will be forced to match the invoice line-item gross values to add up to the total invoice amount entered.

Sales Tax Override (USA and Canada Only)

Sometimes invoices you receive will include a sales tax total without any indication of which items have incurred the tax and which have not. In these situations, the automatic line-by-line tax allocation done by MoneyWorks is not going to useful. To allocate the entire tax on a transaction:

  1. Click the Down Arrow icon next to the tax total at the bottom of the entry screen

The Tax Override window will open:

  1. Enter the actual tax amounts as specified on the invoice
  1. If the appropriate tax code isn’t displayed in the list, click the New icon to add it

Only base tax codes can be used (you cannot code to a composite one—see Sales Tax and PST for details of these). Unused taxes can be deleted using the Delete (Trash) icon.

  1. Click Apply to apply the taxes

Any tax will be stripped off the existing lines on the invoice, and a new line will be added for each of the taxes specified in the Tax Override screen. The tax codes on the existing lines will be changed to “*”, so you will not be able to alter these tax amounts.

Note: Sales tax is normally treated as part of the cost of the item being purchased (unless you have an exemption for the item). If the Tax Override is used, MoneyWorks can no longer apportion the tax to each line of the transaction; instead all tax is apportioned to the general ledger code used in the first line of the invoice.

Note: If using an Item transaction, MoneyWorks will create a new Item “~TAX”, and the tax lines will be allocated against this.

To Restore a Transaction to use the Default Taxes

  1. Open the Tax Override screen by clicking on the down arrow
  1. Click the Defaults button

The tax lines will be removed, and the tax restored to the default on each line. You would only do this if you changed your mind and wanted to undo the override on an unposted transaction.