Trial Balance to Worksheet Basics Assignment

Be sure to:

Use proper accounting conventions for spreadsheet formatting and use spreadsheet formulas for accounting calculations.

Edit the Capital and Drawings accounts on both worksheets to be your own name.

Using the current year and the trial balances shown here, complete the first spreadsheet tab, H$.$ Pearson & Sons six$-$column worksheet, for the month ended April $30,20-$

$10$ marks

$\backslash$table$[[\backslash$table$[[$H$.$ Pearson & Sons$],[$Trial Balance$],[$April $30,20]],],[$Accounts$,$DEBIT,CREDIT$],[$Bank$,1,800\mathrm{.}00,],[$Accounts Receivable: Karen Baker,$10,075\mathrm{.}00,],[$Accounts Receivable: Erin Miller,$9,425\mathrm{.}00,],[$Supplies$,1,000\mathrm{.}00,],[$Prepaid Insurance,$1,750\mathrm{.}00,],[$Rental Equipment,$22,000\mathrm{.}00,],[$Automobiles$,21,000\mathrm{.}00,],[$Accounts Payable: Okay Supply Co$.,,],[$Accounts Payable: R n E Repair Ltd$.,,],[$Your$\_$Name, Capital,,$1,980\mathrm{.}00$