Accounting project done through excel and the grading rubric. PDF provides instr

Accounting project done through excel and the grading rubric.
PDF provides instructions on the assignment.
The excel spreadsheet has to be fully completed, it includes a:
Sales journal, a purchases journal, cash-receipts journal,
The general journal – The general journal should have a brief detail about the transactions. Example someone bought merchandise, you would write ″bought socks on credit″ Or bought socks with cash, etc etc.
The general journal- adjusting entries -The general journal should have a brief detail about the transactions.
The general journal – closing entries – The general journal should have a brief detail about the transactions.
General ledger – add additional accounts if needed
Sub ledger – add additional accounts if needed
Accounts recievable
accounts payable
income statement
statement of retained earnings
classified balance sheet
post closing trial balance
Also the work sheet
which the instructions have said to use these details with.
″
Complete the worksheet using the information below. Also, remember to keep accounts reported
on worksheet in order (assets, liabilities, equity, revenue, expense):
a. The salon equipment was purchased on October 1, 2020 and is estimated to have a
$20,000 salvage value and a 5-year life. The straight-line method will be used.
b. Salaries of $4,500 should be accrued.
c. Ending merchandise inventory per a physical count was $25,734.
d. The note payable is an 8%, 4 year note payable that was issued on July 1, 2021. Interest is
payable every July 1.″