General Ledger Entries for Tax Allocation
Example of a Group B account using Workers Compensation
The Workers Compensation premium renews on January 1st. On December 15th you accept a new policy from your insurance provider. The total policy premium is based on $500,000.00 of labor with the following break down:
Portion | Amount |
---|---|
$375,000.00 Service Worker labor @ 5.75% = | $21,563.00 |
$125,000.00 Sales labor @ 1.75% = | $ 2,187.00 |
$150,000.00 Clerical labor @.90% = | $ 1,350.00 |
Total Premium | $25,100.00 |
On January 1st, the following General Ledger Adjusting Journal Entry is made to reflect the liability of this premium.
GL# | Description | Debit | Credit |
---|---|---|---|
1350 | Prepaid Insurance | $25100.00 | |
2100 | Accounts Payable Insurance | $25100.00 |
You will pay 10 monthly installments, the first installment is a 20% down payment and then equal installments for the remaining 9 months.
Installment | Amount |
---|---|
1st installment | $5020.00 |
2nd - 10th installment | $2231.11 |
1st invoice
GL# | Description | Debit | Credit |
---|---|---|---|
2100 | Accounts Payable Insurance | $5020.00 | |
2000 | Accounts Payable Trade | $5020.00 |
2nd - 10th invoices
GL# | Description | Debit | Credit |
---|---|---|---|
2100 | Accounts Payable Insurance | $2008.00 | |
2000 | Accounts Payable Trade | $2008.00 |
The Tax Allocation Program creates the following entries to the General Ledger by Job
GL# | Description | Debit | Credit |
---|---|---|---|
4280 | Operations Worker Comp Expense | $1796.91 | |
Sales Worker Comp Expense | $182.25 | ||
Administration Worker Comp Expense | $112.50 | ||
2300 | Accrued Workers Comp | $2091.66 |
To reduce the Prepaid insurance account and the Accrued Workers Comp, create a Recurring AJE for 1/12 of the annual premium. The AJE is as follows:
GL# | Description | Debit | Credit |
---|---|---|---|
1350 | Prepaid Insurance | $2091.67 | |
2300 | Accrued Workers Comp | $2091.67 |
Since the annual premium is based on estimated payroll dollars and the amount the Tax Allocation program expense is based on actual payroll dollars these amounts will usually be different. The reason they might be different is due to increases or decreases in actual payroll dollars for each month throughout the policy year.
An Alternative Method which does not include the Booking of the Prepaid Insurance and Accounts Payable Insurance accounts:
The Journal entries involving the Prepaid Insurance account are not totally necessary if your company does not want to book the full premium amount at January 1st into your General Ledger.
If you do not want to show the entire premium amount at the beginning of the year in the General Ledger, the sample entries showing the January 1st Adjusting Journal Entry and the Recurring Journal entry accruing 1/12 of the annual premium each month need not be entered.
Instead, you could make your Installment payments debiting the Accrued Workers Comp account. In our example, this would be G/L Account #2300. This is the same account that is credited when the Tax Allocation program runs.
The entries would look like this:
1st Invoice
GL# | Description | Debit | Credit |
---|---|---|---|
2300 | Accrued Workers Comp | $5020.00 | |
2000 | Accounts Payable Trade | $5020.00 |
2nd thru 10th Invoices
GL# | Description | Debit | Credit |
---|---|---|---|
2300 | Accrued Workers Comp | $2008.00 | |
2000 | Accounts Payable Trade | $2008.00 |
At the end of the year, the balance left in this account can be analyzed at the time of your Workers Comp audit. You may receive a kick back from your insurance audit, or you could be requested to pay additional funds.