Overpayment Of Taxes Due To Cancel/Rebills

Lets assume a cancel / rebill occurs after a payment is received and the net affect of the cancel / rebill is that the customer has overpaid their taxes.

The following table illustrates the financial transactions that are created for overpaid taxes:
Event GL Accounting Tax Payable Balance Tax Holding Balance
Bill segment created

A/R 110

Revenue <100>

Tax Holding <10>

0 (10)
Payment received

Cash 110

A/R <110>

Tax Holding 10

Tax Payable <10>

(10) 0
Cancel

A/R <110>

Revenue 100

Tax Holding 10

(10) 10
Rebill

A/R 27.50

Revenue <25>

Tax Holding <2.50>

(10) 7.50

You'll notice that the amount payable to the taxing authority still indicates $10 (the amount of tax that was paid by the customer). However, you'll notice that the tax holding balance is 7.50 (debit). This looks a bit odd, but it's correct. Remember that at this point, the customer has a credit balance of $75 and this will be whittled down as successive bills are produced as shown below. Note: refer to Cash Refunds for an example of what happens if you refund the credit with a check rather than letting it whittle down.

The following table illustrates the financial transactions that are created when overpaid taxes are refunded:
Event GL Accounting Tax Payable Balance Tax Holding Balance
(10) 7.50
Bill segment created

A/R 55

Revenue <50>

Tax Holding <5>

(10) 2.50
Bill segment created

A/R 110

Revenue <100>

Tax Holding <10>

(10) (7.50)

In the unlikely event of a payment being received while the tax holding has a debit balance, nothing will be done in respect of transferring funds from holding to payable (there is nothing to transfer).