Option #2: Practice in QuickBooks: The Case of Barbaras Company

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 Barbaras 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.