Accounting for WordPress
This tutorial will attempt to explain how Bizuno handles taxes, both sales to your customers and purchases from your vendors. In this tutorial we will use the great state of Texas for our business location. Also, we will use the sales tax for the example, working with purchase taxes is the same process but stored with a different key in the tax table.
Knowledge of your tax rates and taxing authorities for all regions that tax is to be collected.
Before tax can be applied to a sale or purchase, the tax rate must be set up. Tax rates contain one or more authorities that receive payments from the tax collected. A new tax rate cannot be established without your taxing authority entered into the list of your vendors. All taxing authorities are considered vendors for the purpose of collecting and distributing sales tax.
Adding a New Vendor
CAUTION: The tax rate table is loaded into your browser memory when you log into Bizuno. If changes are made to the rate tables, it is best to log out and back in to reload your browser cache.
In this example, Texas only has a single authority to collect taxes so we will only need to create a single entry in the tax authority table.
Assigning default tax rates to your customers is an easy way to make sure the proper tax is applied to every sale and purchase. Bizuno has tremendous flexibility when it comes to assigning default tax rates. When a default tax rate is assigned to a contact, that rate is automatically loaded into the form when the customers record is loaded. Default rates may also be applied to individual inventory items (see the next section).
In some cases, the tax rate may be driven by the type of inventory item. For example, some states do not tax labor but do tax materials. In this case, default tax rates may be assigned at the individual inventory item level and the tax calculation will take the rate for each SKU into account. To set the default tax rate for an inventory item:
NOTE: It is not recommended to edit a tax rate percentage when the authority rate changes. In this case it’s best to set the Expiration Date for the old rate and create a new record with the Effective Date and new percentage with the same authority. This will allow editing entries that had the old tax rate in effect without recalculating invoice total (with the current rate and change the invoice total, not what you want).
To edit a tax rate:
When a tax rate changes, the proper way to handle it is to create a new rate record and use the Expiration Date and Effective date to track rates over time. The image below shows three successive (and hypothetical) changes to the rate in Texas over 4 years. Bizuno will highlight the rates that are not in effect (and inactive if the filter is set) to prevent confusion as to which rate is currently in effect. The same color coding is available in the pull down menus on the order screens and throughout Bizuno. The current tax rates are shown a the top of the list.
When a taxing authority changes the percentage rate, Bizuno recommends that you create a new record for the new rate. Bizuno has a convenient tool to make this easy. The tool searches all your contacts and replaces the old tax rate id with the new one, easy-peasy.
NOTE: Once a tax rate has been used in a journal entry, it CANNOT be deleted. The rate should be set to inactive. Over time, as historical fiscal years are removed, the records that utilize these rates will be removed and at that time the tax rate can be deleted. If a tax rate has been used and you try to delete it, you will get an error message and the rate will not be deleted.
To delete a tax record:
NOTE: The Bizuno API has a multi-layer approach to guessing the tax rate and authority. If the passed tax amount/rate/description matches your tax table values, that tax rate will automatically be applied to the transaction. This overrides the defaults set in the Bizuno API settings.
Since most applications that Bizuno accepts for importing data through the API do not use gl accounts or specify how they calculated taxes, Bizuno has the ability to set default accounts/rates in their absence. To set the default tax rate for API transactions:
Tax rates can only be deleted if they are not used in a journal transaction. In this case, set them as inactive. In General, once a tax rate has been used, it should remain in the tax table until all records have been removed. This typically will only happen when past fiscal years are purged. It is helpful to put a date/revision code in the description to help keep the current straight (on top of the highlighting)
If you edited your tax rate table and changed the percentage value versus creating a new entry, Bizuno has no way of knowing what rate to apply at what time. When an entry is edited (sales or purchases), the tax rate calculation is done in real time. that means whatever the current rate is assigned to the table rate id, the new total will reflect that rate. For example, if the rate changed from 8% to 9% AND the tax rate table was edited to reflect the new rate, if a posted entry is opened, the total will be recalculated WITH THE NEW RATE. If it is then saved, the new rate (and the new total) will be applied to the record and saved in the database. The original total using the old tax rate will be over-written.
Powered by BetterDocs
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.