Coffee & cafe supplier accounting excel

PLEASE COMPLETE FOLLOWING QUESTIONS IN EXCEL, AND PUTTING ANSWERS IN THE WORKSHEET (IN EXCEL).

 

7. Schedules of accounts

a. Create a schedule of accounts receivable balances as at the end of June.

b. Create a schedule of accounts payable balances as at the end of June.

8. Financial statements

a. Prepare an income statement for the month of June.

b. Prepare a statement of stockholders’ equity for the month of June.

c. Prepare a balance sheet as at the end of June.

9. Closing entries

a. Journalise closing entries in the general journal.

b. Post the closing entries from the general journal to the relevant ledger accounts.

10. Post-closing trial balance

Prepare a post-closing trial balance as at the end of June.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer