The owner of Waltz Company in Fairview has asked you to prepare a worksheet from the following trial balance and additional data:

Additional Data
a. Physical count of inventory on December 31, $4,805.
b. Office supplies used up, $210.
c. Rent expired, $195.
d. Depreciation expense on office equipment, $550.
e. Office salaries earned but not paid, $310.

Transcribed Image Text:

Cash Petty Cash Accounts Receivable Inventory Prepaid Rent Office Supplies Office Equipment WALTZ COMPANY TRIAL BALANCE DECEMBER 31, 2023 Accumulated Depreciation, Office Equipment Accounts Payable K. Waltz, Capital K. Waltz, Withdrawals Income Summary Sales Sales Returns and Allowances Sales Discounts Cost of Goods Sold Office Salaries Expense Insurance Expense Advertising Expense Utilities Expense Dr. 540800 24000 251200 509200 61600 94400 928000 480000 Cr. 760000 596400 547600 52 48400 9600 240000 28 95200 740800 240000 80000 57600 71 524 00 7152400