Continue to use your QuickBooks™ access. Return to the QuickBooks™ home page.

For 1/1/2015:
Go to home, select chart of accounts, and then select opening equity and title equity as EQUITY.
Deposit $5,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 seven transactions that follow will be completed in the CDE Bank Account in this section.

For 1/2/2015:
Select record a deposit of $1,000 from ABC Bank (Quick add: Other).
Account is Loan.
In memo, write: Loan from ABC Bank.

For 1/5/2015:
Record a deposit of $20,000 from Barbara (Quick add: Other).
Account is Equity.
In memo, write: Additional equity contribution from Barbara.

For 1/11/2015:
Select record a deposit of $40,000 from MHY Bank (Quick add: Other).
Account is Loan Account.
In memo, write: For loan from MHY Bank.

For 1/15/2015:
Select “write a check” and a picture of a check will appear.
On check, write: Pay-to-the-order-of: Levine (Quick add: Vendor) for $3,000.
In memo, write: For purchase of office supplies.
Account is Supplies.

For 1/19/2015:
Record a deposit of $20,000 from Anne (Quick add: Customer).
Account is Consulting Income.
In memo, write: Work completed on 1/19/2015.

For 1/23/2015:
Select “write a check” and a picture of a check will appear.
On check, write: Pay-to-the-order-of: Rachel (Quick add: Vendor) for $5,000.
In memo, write: For purchase of furniture and equipment.
Account is Equipment.

For 1/31/2015:
Select “write a check” and a picture of a check will appear.
On check, write: Pay-to-the-order-of: Julie(Quick add: Employee) for $15,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 Barbara’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.