Practice in QuickBooks™: The Case of Sam’s Company
Continue to use your QuickBooks™ access. Return to the QuickBooks™ home page.
For 1/1/2015:
Go to home, then select chart of accounts, and then select opening equity and title equity as EQUITY.
Deposit $150,000 to the CDE Bank Account (Quick add: Other).
Select “Banking Section” from the icons on the screen (i.e., Vendors, Customers, Employees, Company, and Bank). All five transactions that follow will be completed in the CDE Bank Account in this section.
For 1/3/2015:
Select “write a check” and a picture of a check will appear.
On check, write: Pay-to-the-order-of: Weiss (Quick add: Vendor) for $50,000.
In memo, write: For purchase of plant and equipment.
Account is Furniture and Equipment.
For 1/10/2015:
Select record a deposit of $40,000 from ABC Bank (Quick add: Other).
Account is Consulting Income.
In memo, write: Work completed on 1/10/15.
For 1/20/2015:
Select write a check and a picture of a check will appear.
On check, write: Pay-to-the-order-of: Wansi (Quick add, Vendor) for $5,000.
In memo, write: For purchase of office supplies.
Account is Supplies.
For 1/31/2015:
Record a deposit of $120,000 from Bill (Quick add: Customer).
Account is Consulting Income.
In memo, write: Work completed on 1/31/2015.
For 1/31/2015:
Select “write a check” and a picture of a check will appear.
On check, write: Pay-to-the-order-of: #1 Employee (Quick add: Employee) for $25,000.
In memo, write: Payroll expense for month of January, 2015.
Account is Payroll Expense.
Instructions:
- In an Excel worksheet, submit to the assignment area the standard balance for the end of last month for Sam’s Company.
- Go to the check register icon, then to the top ribbon called Reports, then select Company and Financial, and then select Statement of Cash Flow Report. Make sure that the dates on top are from January 1 to January 31, 2015.
- To export data to Excel, select the Excel tab and then select “create a new worksheet.”
- Save your file as your last name_first name.
0 comments