Skip to content
/ bkper-tax-bot Public template

Calculate VAT, GST and other sales taxes based on the transaction amount

License

Notifications You must be signed in to change notification settings

bkper/bkper-tax-bot

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Taxes are calculated based on the transaction amount and some properties set in the account or group, specifying the rates to apply. Here is a quick intro video:

They can be included in overall transaction amount, such as VAT, or excluded such as income taxes. Here is an article that better explain it.

Once the taxes calculated, the Tax Agent will record one or more transactions with the entry for the taxes.

Bkper Tax Agent in action

Included tax on sale example

Tax on sale example

Included tax on purchase example

Tax on sale example

The examples use simplified cash basis for easy understanding. You can also set more complex tax flows involving accounts payable and receivable instead of the direct Bank Account.

Learn more about sales taxes and bots on Bkper:

Tax Agent quick intro video

Bkper Agents Installation

Sales taxes on Bkper

Configuration

The Tax Agent is triggered on the TRANSACTION_POSTED event. Once triggered it will check group and account properties if it has the tax_included_rate or tax_excluded_rate properties. When it finds these properties it will read the corresponding values from your book and apply the Tax Agent's logic. In this case it will calculate the tax and record another transaction with the available data.

Learn more....

Accounts and/or Group properties

Set the following account properties on accounts (or group) that should trigger the Tax Agent.

  • tax_excluded_rate: The tax rate to apply, calculating the tax based on the transaction amount.
  • tax_included_rate: The tax rate to apply, extracting the tax already included in the transaction amount.
  • tax_description: The description of the generated transaction

Generating addional 7% of income tax:

tax_excluded_rate: 7
tax_description: #incometax

Extracting 12.85% of VAT, already included in the transaction:

tax_included_rate: 12.85
tax_description: #vatin

Expressions

Expressions are like variables that allow you to dynamically use values from the posting event that triggered the Tax Agent, consisting of the account name and the transaction description. This allows you to complete accounts on the newly recorded transaction by the bot and to have a significant description that links to the original transaction.

You can add these expressions to the tax_description property of the account that has to trigger the tax bot to dynamically generate the new transaction.

  • ${account.name}: The account name of the account that triggered the Tax Agent.
  • ${account.name.origin}: The account name when participates as origin in the transaction. Empty otherwise.
  • ${account.name.destinaton}: The account name when participates as destination in the transaction. Empty otherwise.
  • ${account.contra.name}: The contra account name of the account that triggered the Tax Agent.
  • ${account.contra.name.origin}: The contra account name when participates as origin in the transaction. Empty otherwise.
  • ${account.contra.name.destinaton}: The contra account name when participates as destination in the transaction. Empty otherwise.
  • ${transaction.description}: The same description that comes from the posted transaction that triggered the Tax Agent.

Example of the account property using these expressions:

tax_description: ${account.name} Input Tax #vatin ${transaction.description}

Transaction properties

  • tax_round: The number of decimal digits to round the taxes. This should be lower than the books decimal digits settings.
  • tax_included_amount: The fixed tax amount to override the included taxes calculated based on Group or Account tax_included_rate definition
  • tax_excluded_amount: The fixed tax amount to override the excluded taxes calculated based on Group or Account tax_excluded_rate definition

Example:

tax_round: 1

Book property

  • tax_copy_properties: The properties the Tax Agent should copy from the source to the generated tax transaction, splitted by space.

See the Sales Taxes article to learn more about included and not included taxes.

About

Calculate VAT, GST and other sales taxes based on the transaction amount

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published