I need to set up the entries on Excel or Word and show how to place the entries. Prepare closing and reversing entries. On December 31, the adjusted trial balance of Garg Employment Agency shows the following selected data.
Analysis shows that adjusting entries were made to (1) accrue $4,200 of commission revenue and (2) accrue $1,500 interest expense.
a) Prepare the closing entries for the temporary accounts at December 31.
b) Prepare the reversing entries on January 1.
c) Post the entries in (a) and (b). Rule and balance the accounts. (Use T accounts.)
d) Prepare the entries to record (1) the collection of the accrued commissions on January 10 and (2) the payment of all interest due ($2,700) on January 15.
e) Post the entries in (d) to the temporary accounts.
This solution creates entries in an Excel file for interest payable, commission revenue, interest expenses, accounts receivable and the overall account titles for Garg Employment Agency.