General examples of tax calculations and ledger entries
These examples show Rounding = Nearest and a rounding value of .05:
Accrual module
This table shows tax calculation for Rates, with debt raised for $100 and tax deemed to be applicable at 10%:
Account | Value |
---|---|
Credit revenue account | 90.90 |
Credit tax accrual account | 9.10 (calculated 1/11 of 100.00 and rounded) |
Debit control | 100.00 |
This table shows tax calculation for Rates, with payment received for $100 and allocated to taxable debt:
Account | Value |
---|---|
Credit control account | 100.00 |
Credit tax cash account | 9.10 (calculated 1/11 of 100.00 and rounded) |
Debit tax accrual reversal account | 9.10 |
Debit bank account | 100.00 |
Cash module
This table shows the tax calculation for Miscellaneous Receipts where the miscellaneous receipt type set up as taxable, with receipt generated for $100.00:
Account | Value |
---|---|
Credit revenue account | 90.90 |
Debit bank account | 9.10 (calculated 1/11 of 100.00 and rounded) |
Modules where tax can be exclusive
These tables show the tax calculation for Applications, Licensing, and Debtors where fee code calculations or rate type specified as tax exclusive, with parameter or system calculated Fee = $100:
Account | Value |
---|---|
Credit revenue account | 100.00 |
Credit tax cash account | 10.00 (calculated 10% of 100.00 and rounded) |
Debit bank (cash mode) | 110.00 |
Overpayment or pre-payments
This table shows the tax calculation for Rates, Applications, Licensing, and Infringements, with payment of $100 received:
Account | Value |
---|---|
Credit overpayment or pre-payment | 100.00 |
Credit tax cash account | 9.10 (calculated 1/11 of 100.00 and rounded) |
Debit tax clearing account | 9.10 (calculated 1/11 of 100.00 and rounded) |
Debit bank account | 100 |
The credit tax cash and debit tax clearing accounts are effectively the tax accrual reversal and tax cash accounts as set up on the tax codes. The tax codes that are linked to overpayment or pre-payment parameters must be considered differently.
The tax cash account is the valid tax cash account for the module, assuming that the tax is applicable on overpayments and pre-payments. If you can wait until this payment is allocated before determining tax liability, then this account should be a Clearing account.
The tax clearing account is always a clearing account.
Allocation of overpayment or pre-payments
This table shows payment of $100 now allocated to a taxable debt:
Account | Value |
---|---|
Debit overpayment or pre-payment | 100.00 |
Debit tax cash account | 9.10 |
Credit tax clearing account | 9.10 |
Credit bank account | 100.00 |
Debit overpayment or pre-payment | 100.00 |
Debit tax cash account | 9.10 |
Credit tax clearing account | 9.10 |
Credit bank account | 100.00 |
Credit control account (accrual module) | 100.00 |
Credit tax cash account | 9.10 (from tax code applicable to debt) |
Debit tax accrual reversal account | 9.10 (from tax code applicable to debt) |
Debit bank account | 100.00 |
Credit revenue account (cash mode) | 90.90 |
Credit tax cash account | 9.10 (from tax code applicable to charge) |
Debit bank account | 100.00 |
This table shows payment of $100 now allocated to a non-taxable debt:
Debit overpayment or pre-payment | 100.00 |
Debit tax cash account | 9.10 |
Credit tax clearing account | 9.10 |
Credit bank account | 100.00 |
Credit control or revenue account | 100.00 |
Debit bank account | 100.00 |
Receipt reversals
You can use receipt reversals to reverse both the standard receipt ledger entries and any tax entries generated as a result of the receipt processing.
This table shows receipt for $100 allocated to a taxable fee in a cash module:
Account | Value |
---|---|
Debit revenue account | 90.90 |
Debit tax cash account | 9.10 |
Credit bank account | 100.00 |
This table shows receipt for $100 allocated to a taxable fee in an accrual module:
Account | Value |
---|---|
Debit control account | 100.00 |
Debit tax cash account | 9.10 |
Credit tax accrual reversal | 9.10 |
Credit bank account | 100.00 |