Tax Rules
Keeping your tax rules accurate and organised is an essential part of running your business. Cin7 Core allows you to specify tax rules for whole orders, individual order lines, products, customers and suppliers. Tax Rates can have multiple tax components (e.g. a Sales Tax which includes a City Tax and State Tax components).
Prerequisites
Set up your Chart of Accounts
Creating Tax Rules
The method for creating Tax Rules depends on whether you are using Cin7 Core as a standalone system or if you have integrated Cin7 Core with Xero or QuickBooks Online accounting systems.
If your store country is located in Australia, UK, USA or New Zealand, default taxes are pre-loaded. If you are not sure about what tax rules you need to include or their value, you may want to consult with your accountant or bookkeeper.
Tax Inclusive vs Tax Exclusive
It is important to specify whether a transaction is Tax Inclusive or Tax Exclusive for accurate bookkeeping. For tax inclusive transactions, the tax value is included in the total amount. For tax exclusive transactions, the tax value is added to the total amount.
Example: Consider a $100 transaction, subject to 10% GST.
If the transaction is Tax Exclusive, the value of the order is $100. Calculated GST is 10% of $100.
If the transaction is Tax Inclusive, the value of the order + 10% tax is $100. $100 is 110% of the value of the order.
Each tax rule created will be set by default to be tax inclusive/exclusive, but this can be changed at the order level.
Cin7 Core Standalone
If you are using Cin7 Core without integration with Xero/QuickBooks, tax rules are created and managed from Cin7 Core.
To create/edit a Tax Rule:
Navigate to Settings → Reference Books → Financials → Taxation Rules.
Click + to add a new tax rule or select an existing tax rule to modify.
-
On the Create a new tax rule window, enter the Tax Rule Name, then the details of the new tax rule. Mandatory fields are marked with an asterisk (*).
Inclusive/Exclusive: Sets the tax rule as either tax exclusive (the default setting for all new tax rules) or tax inclusive. This can be changed at the order level in the document header by checking/unchecking the Tax Inclusive box.
Status: Set to Active by default. Tax rules cannot be deleted once they have been created. To stop using a tax rule and remove it from the list of Tax rules, change the status to Deprecated.
Tax Type: Choose from the default tax types for your country on the list. This affects how the tax will be classified in your reporting.
Liability Account: This is the liability account that will hold the taxes from transactions using this tax rule. You may use a single account for all tax liability or separate accounts for multiple tax components. Consult your bookkeeper or accountant if you are uncertain of the liability account to use.
Under the Tax Components section, edit the default tax component already added to the rule. You may edit the tax component name, enter the tax rate, check the Compound box to allow the tax to be applied to the already taxed subtotal, and select the liability account for the component. All taxes require at least one component. See Taxes with Multiple Components for more information on setting up multi-component, multiple tier tax rules.
To add more tax components, click the + button.
Click Save to complete your changes.
Cin7 Core with Xero/QuickBooks Integration
If you are using Xero or QuickBooks Online as your accounting system, all tax rule creation must take place in Xero/QuickBooks. The tax rules are then imported into Cin7 Core during synchronisation. Once a tax rule has been created and synced, it can be modified within Cin7 Core. Available modifications include:
changing the inclusive/exclusive status
changing the rate for a tax component
adding/removing/modifying components in a tax rule
Once a rule has been created in Xero/QuickBooks and synced to Cin7 Core, any of these changes made in Cin7 Core or Xero/QuickBooks will be synced both ways.
More information: What happens if I create a tax rule in Cin7 Core and not in Xero/QuickBooks?
Create/edit tax rates in Xero
From your Xero account, go to Accounting → Advanced → Tax Rates.
Click Add New Tax Rate or select an existing Tax Rate to modify.
-
Fill in the tax rate fields.
Tax Type: Choose from the default tax types for your country in this dropdown list. This affects how the tax will be classified in your reporting.
Tax Component: All taxes require at least one component. See Taxes with Multiple Components for more information on setting up multi-component, multiple tier tax rules.
Click Save to complete your changes. You will then need to sync your changes with Cin7 Core.
Create/edit tax rates in QuickBooks Online
NOTE: Some versions of QuickBooks Online (e.g. QuickBooks Online Australia) no longer support custom tax rates. In this case, the QuickBooks-provided tax rates will be imported to Cin7 Core. If you are connecting an existing Cin7 Core account to QuickBooks Online, in order for the tax mappings section of the integration to go smoothly, check your Cin7 Core tax rules and delete/edit any that do not exactly match the QuickBooks-provided tax rules if your version of QuickBooks Online does not allow custom tax rates.
From your QuickBooks Online account, select Taxes in the left menu.
Under the Related Tasks list on the right, choose Add/edit tax rates and agencies.
Fill in the tax rate fields.
Save your changes to finish. Don't forget to sync your changes with Cin7 Core!
Taxes with Multiple Components
In some cases, you may be required to create taxes with multiple components. This can be done either in Cin7 Core or through Xero/QuickBooks. Taxes with multiple components can be simple (i.e. each component of the tax rule is calculated as a percentage of the transaction value) or compound (i.e. one tax rule component is calculated as a percentage of the transaction value, another tax rule component is charged as a percentage of the taxed subtotal).
Note: If you are using Xero/QuickBooks, remember that tax rules must first be created in Xero/QuickBooks. Once a rule is created, you can add, remove or modify tax components either via Cin7 Core or via Xero/QuickBooks. The examples in this section are shown in Cin7 Core, but the process should be similar in Xero and QuickBooks Online.
Example 1: Simple tax with multiple components. In this example, a transaction is subject to a multi-component sales tax (3% City Sales Tax, 4% State Sales Tax, 5% Federal Sales Tax). The total effective tax rate is 12%. In this example, the user has created multiple liability accounts to keep each sales tax component organised.
For a transaction value of $50, the breakdown will be:
City Sales Tax: 0.03 x $50 = $1.5
State Sales Tax: 0.04 x $50 = $2
Federal Sales Tax: 0.05 x $50 = $2.5
Total transaction cost: $56
Example 2: Compound tax with multiple components. In Australia, those who make wine, import wine into Australia or sell it by wholesale, generally have to account for wine equalisation tax (WET). First, the WET of 29% is applied to the order total, then the GST of 10% is applied to the taxed subtotal. In this example, the user has created multiple liability accounts to keep each sales tax component organised.
For a transaction value of $50, the breakdown will be:
WET: 0.29 x $50 = $14.5
GST: 0.1 x ($50 + $14.5) = $6.45
Total transaction cost: $70.95
Assigning Tax Rules
Tax Rules in Cin7 Core can be assigned to customers, suppliers, products, the sale/purchase process and individual order lines to allow fine-grained control of your transaction process. Tax rules at the order line level override all other tax rules.
The order of priority is as follows:
Order line
Product
Purchase/Sale process document header
Supplier/Customer.
NOTE: If you are using Cin7 Core B2B Portal, tax rules are handled slightly differently. It is not possible to manually override a tax rule during the sale. The tax rule specified for the customer/supplier is used for the sale order/purchase order unless a tax rule has been specified at the product level.
Order Line Tax Rules
This is the highest priority tax rule and will override any other assigned tax rules.
Product Tax Rules
Tax rules assigned to a product will appear pre-filled in the order line. You can optionally specify a purchase and sale tax rules. If left blank, the order line will not be pre-filled, and the sale/purchase header tax rule will be used instead. The user can manually change the order line tax rule during the transaction if necessary, and this will take priority.
Sale/Purchase Header Tax Rules
The tax rule in the sale/purchase process document header will be used for any order lines that do not have a tax rule assigned at the product level. You can also specify whether this tax rule is tax inclusive or tax exclusive here. It is mandatory to select a tax rule for a sale/purchase order.
Note: If different tax rules are assigned at the order line level, the Tax Inclusive/Tax Exclusive status of the document header will be applied to the entire order, regardless of the default setting for the order line tax rules.
Customer/Supplier Tax Rules
Tax Rule is a mandatory field when creating a customer or supplier. The tax rule specified here will be automatically pre-filled in the sale/purchase order document header.
Tax Rules in Cin7 Core POS
See Cin7 Core POS - Getting Started and Information for more info about Cin7 Core Point of Sale.
Default tax settings for each POS can be set in Integrations → POS → [POS Name] → Setup. You can choose a default sales tax, default tax-free rate and whether POS sales are tax inclusive or tax exclusive. You can choose different default tax settings for each of your POS points.
Tax rules for sale items can also be changed during the sale.
Manually changing tax rules in Cin7 Core POS:
Add products to the sale through Cin7 Core POS. Tax is shown at the bottom right of the screen.
Click the tax line.
On the Edit Taxes window, select the tax rule to apply from the list.
Save your changes to finish.
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB