Question

In: Accounting

STEP 1: Acquire access to any commercial accounting software package that you don't have to purchase....

STEP 1: Acquire access to any commercial accounting software package that you don't have to purchase.

STEP 2: Use your software to create a set of books for a fictional company that includes your name and student number with the fiscal year end of December 31st of the current year. Many products have 'wizards' or tutorials to lead you through this process.

STEP 3: Post the following transactions using the 'general journal entry' option rather than specialized journal option. Hint: If you are prompted to enter customer or supplier name and address information, most likely you are not using the 'general journal entry' option, and are doing more than is required in this assignment.

1. The owner contributes to the company $1,800 in a piece of equipment.

2. A purchase in account of merchandise available for sale (perpetual system used) for an amount equal to $1,200

3. A cash sale for an amount equal to $1,200

4. A sale on account for an amount equal to $900

5. Utilities services consumed this month will be paid next month according to the invoice received. The invoice is for an amount equal to $480

6. Advanced payment made in cash from a customer for a future delivery of goods equal to $300

7. At the end of the period noticed that all the goods for resale (inventory) have been sold.

8. Received the bank statement and since you did not keep the minimum balance, it was debited from your account bank fees for $120

9. Pay 50% of the amount due for the merchandise acquired for resale.

10. The depreciation of the equipment is 5% of its acquisition cost.

STEP 4: Prepare and print the Income Statement and Balance Sheet for the period and also your general journal showing your journal entries.

Solutions

Expert Solution

Step 1 & 2) We have to buy the accounting software and fill the particulars of the company and set the password for the safety of the accounting data.

Open the various accounts and sub accounts alongwith their balances.

Step 3) Then, start entering the Journal Entries of the transactions :

Date Accounts Titles and descriptions Debit $ Credit $
1 Equipment 1800
Capital 1800
(being equipment contributed to business)
2 Merchandise 1200
AP 1200
3 Cash 1200
Sales 1200
4 AR 900
Sales 900
5 Utility expenses 480
Expenses payable 480
6 Cash 300
Unearned revenues 300
7 Cost of Goods sold 1200
Merchandise 1200
8 Bank Charges 120
Cash 120
9 AP 600
Cash 600
10 Depreciation 90
Accumulated Depreciation - Equipment 90

Step 4)

Income Statement :

Sales $2100
less: COGS 1200
Gross Profit $900
Less: Expenses :
Utility 480
Bank Charges 120
Depreciation 90
Total Expenses = 690
Net Income $210

Balance Sheet :

Liabilities and Capital Amount $ Assets Amount $
AP 600 Cash 780
Expenses payable 480 AR 900
Current Liabilities 1080 Current Assets 1680
Unearned revenues 300 Equipment 1800
Capital1800 Accu Depreciation (90)
Add: Net Profit 210 2010
Total $3390 Total $3390

We can present the Journal Entries, Income Statement and Balance Sheet after the print out of the all the documents.


Related Solutions

A small accounting firm is considering the purchase of a computer software package that would greatly...
A small accounting firm is considering the purchase of a computer software package that would greatly reduce the amount of time needed to prepare tax forms. The software costs $2250 and this expense will be incurred immediately. The firm estimates that it will save $525 at the end of each year beginning in one year for 4 consecutive years, and also save $1444 in year 5. What is the payback on the computer package?
A small accounting firm is considering the purchase of a computer software package that would greatly...
A small accounting firm is considering the purchase of a computer software package that would greatly reduce the amount of time needed to prepare tax forms. The software costs $2400 and this expense will be incurred immediately. The firm estimates that it will save $650 at the end of each year beginning in one year for 7 consecutive years, and also save $1788 in year 8. What is the payback on the computer package?
Describe any three program modules common to an accounting system software package.
Describe any three program modules common to an accounting system software package.
Computer Nerds, Inc., is planning a project to develop a commercial software package for PC’s. They...
Computer Nerds, Inc., is planning a project to develop a commercial software package for PC’s. They have come up with the following list of activities, times and precedence relationships.                                                                                           Immediate             Activity Time Symbol           Activity Description                                    Predecessors              (weeks)             P           Perform market survey                                        ––                         3            D            Design graphic icons                                          P                           4            F             Develop flow chart                                             P                           2            S             Design input/output screens                                D, F                      6            U            Code Module 1                                                  F                           5            V            Code...
1. What if you are a brand new company and you don't have any historical data...
1. What if you are a brand new company and you don't have any historical data to look at? How do you think they determine their expected sales? 2.Think about the term "flexible budget". Are all budgets "flexible" and if one is not, does that mean we can't or shouldn't hit the reset button?
You have a purchase order to acquire €1 million of heavy equipment from a French company...
You have a purchase order to acquire €1 million of heavy equipment from a French company to be paid in full at time of delivery in March 2021. Describe in detail how you would hedge this transaction. Quantify the number of contracts.
Rita Jekyll operates a sales booth in computer software trade shows, selling an accounting software package,...
Rita Jekyll operates a sales booth in computer software trade shows, selling an accounting software package, Abacus. She purchases the package from a software company for $165 each. Booth space at the convention hall costs $13,000 per show. Required a. Sales at past trade shows have ranged between 400 and 600 software packages per show. Determine the average cost of sales per unit if Ms. Jekyll sells 400, 450, 500, 550, or 600 units of Abacus at a trade show....
Tally.ERP 9 as an accounting software package was exclusively devised to automate and integrate all the...
Tally.ERP 9 as an accounting software package was exclusively devised to automate and integrate all the operations, such as sales, finance, purchasing, inventory, and manufacturing for many small and medium sized enterprises (SMEs). With Tally.ERP 9, accurate, up-to date business information is literally at your fingertips anywhere in the world. Required: With practical examples using a service company as a case study, explain the functionalities that has enabled Tally.ERP 9 to make inroads into the Ghanaian accounting software packages market.
tally.ERP as an accounting software package was exclusively devised to automate and integrate all the operations,...
tally.ERP as an accounting software package was exclusively devised to automate and integrate all the operations, such as sales, finace, purchasing, inventory, and manufacturing for many small and medium sized enterprises. With tally. ERP 9, accurate, up to date business information is literally at your fingertips anywhere in the world. required: with practical examples using a service company as a case study, explain the functionalities that has enabel Tally.ERP 9 to make introads into the Ghanaian accouting software packages market.
Tally.ERP 9 as an accounting software package was exclusively devised to automate and integrate all the...
Tally.ERP 9 as an accounting software package was exclusively devised to automate and integrate all the operations, such as sales, finance, purchasing, inventory, and manufacturing for many small and medium sized enterprises (SMEs). With Tally.ERP 9, accurate, up-to date business information is literally at your fingertips anywhere in the world. Required: With practical examples using a emirate security and finance company Ltd, Ghan as a case study, explain the functionalities that has enabled Tally.ERP 9 to make inroads into the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT