Wizard Computer Sales and Service, Inc.
Here is the information for the excel project this semester. I have enclosed a file that describes the project. I would like you to set this entire project up in excel. You should have a separate excel tab for each step in the accounting cycle. For example, you should have a tab for journal entries, a tab for sales journals, a tab for adjusting entries, and so on. You can key in the journal entries and the adjusting entries that is it. So in order to get the journal entry information to the other steps in the accounting cycle and the project you will use excel formulas. So the spreadsheets need to be linked together. So if I change some sales information in the sales journal then the ledger, trial balance and the other tabs would change automatically.
Wizard Computer
Sales and Services, Inc.
Wizard Computers is a retail business dealing in sales of computers and equipment. In addition, the company provides installation and servicing of computer systems. The clientele includes wholesale and retail businesses, professionals, and private individuals. It is both a merchandising and a service business. It is owned by a small number of investors from Inman, South Carolina, with John Jones as the controlling investor.
The following journals should be included in your accounting for the company:
• Sales Journal
• Cash Receipts Journal
• Purchases Journal
• Cash Payments Journal
• General Journal
The trial balance for November is included. The accounts receivable and accounts payable ledgers for November are also included. Cash sales are recorded at the end of each week. All sales on account are subject to terms of 2/10, n/30. All purchases on account are subject to terms of 3/15, n/30.Totals of the Special Journals should be posted to the General Ledger weekly.
Instructions
1. Post the balances from the trial balance to the appropriate General Ledger accounts.
2. Post the balances from the accounts receivable and accounts payable totals for Nov. to the ledgers.
3. Post all transactions for December to the appropriate journals and ledgers.
4. Prepare a trial balance for December.
5. Prepare a schedule of accounts receivable and accounts payable for the end of December.
6. Journalize and post the adjusting entries based on the following information.
7.
