Skip to content

bkper/tax-bot

master
Switch branches/tags
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
src
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Taxes are calculated based on the transaction amount and some properties set in the account or group, specifying the rates to apply.

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 Bot will record one or more transactions with the entry for the taxes.

Bkper Tax Bot 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:

Bkper Bots Installation

Sales taxes on Bkper

Tax Bot help

Configuration

The Tax Bot 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 Bot'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 Bot.

  • 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 Bot, 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 Bot.
  • ${account.contra.name}: The contra account name of the account that triggered the Tax Bot.
  • ${transaction.description}: The same description that comes from the posted transaction that triggered the Tax Bot.

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

Example:

tax_round: 1

See the Tax Bot help article for a working example. 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