Homework answers / question archive / ACCT 270 QuickBooks Test#2 Part A: Download the test data file from Blackboard: Make a new folder: 270 T2 Your Name (actual your full name) on the local C:/ Drive, this is the folder that you are going to open the test data file and save a Portable test data file into

ACCT 270 QuickBooks Test#2 Part A: Download the test data file from Blackboard: Make a new folder: 270 T2 Your Name (actual your full name) on the local C:/ Drive, this is the folder that you are going to open the test data file and save a Portable test data file into

Accounting

Share With

---

ACCT 270 QuickBooks Test#2

Part A: Download the test data file from Blackboard:

1. Make a new folder: 270 T2 Your Name (actual your full name) on the local C:/ Drive, this is the folder that you are going to open the test data file and save a Portable test data file into.

 

2. Make a new folder: Reports T2 Your Name (actual your full name), this is the folder that you are going to export all your test reports into.
3. Go to Tests and Quizzes on your blackboard site on the left pane. 

 

4. Click on ACCT270 QuickBooks Computer Test 2 folder and download the attached company data file. It will be downloaded as ACCT270 Test#2 Start (Portable).
5. Launch QuickBooks Premier 2018 and restore and open the test data file – ACCT270 Test#2 Start (Portable) to the folder 270 T2 Your Name on the local C:/ Drive. Save the test data file as: ACCT270 Test#2 Your Name. Password: WestComp18 (case sensitive).

 

6. Open the ACCT270 Test#2 file and rename the company name with your first name and last name

“ACCT270 Test#2 Your Name.”

 

Note: “Any report without your name will be marked as Zero”  

 

Part B: Enter Transactions using QuickBooks Premier 2018

           A selection of November 2017 Events for an Ontario Company

 

11/1/17   Enter a bill from Guelph Line Office Supplies for $1,200 (pre-tax) plus HST (13%), for halfyear Office Supplies, reference number #45109

 

 

11/2/17    Issued cheque #154 to Mutual Insurance Inc. for $1,188.00 PST (8%) included for one-year Insurance premium commencing Nov 1, 2017. 

 

 

11/7/17    Gerald Davis paid for 4 hours of installation and assembly, cheque #78016, Tax code H. Deposit the cheque on 11/8/17.

 

 

11/9/17    A new customer – Your Last Name plus XXX – the last three digits of your student ID e.g. 

               Amy Martin, N01075272 should enter her Customer number as Martin272 for one (ea) M415 –                 Logitech Wireless Keyboard at $99 /each, tax code H, and paid by cash and deposit to bank                 Chequing Account on the same date. 

 

 

11/10/17    Your Last Name plus XXX returned one (ea) M415 – Logitech Wireless Keyboard at $99                             /each, tax code H (without updating the item with the new cost).  We accepted the return                     and gave the customer full refund. (Record separate entries for 11/9/17 and 11/10/17 events)

 

 

11/15/17    The cheque #78016 from Gerald Davis came back NSF (no sufficient fund) from RBC Bank. 

                   Record the NSF cheque with $25.00 bank charges to RBC Bank and mark it to bill Gerald                     Davis, invoice the bank charges and NSF amount to Gerald Davis. Tax codes E

 

 

11/16/17   Purchase from Apple Inc. 5 (ea) C400 – Apple iPad Pro, $35 Freight Charges, Tax codes H,                    using their invoice # 4706. 

 

 

11/18/17   Returned one (ea) C400 – Apple iPad Pro to Apple Inc., Tax code H, for their invoice # 4706.  

                 Ref NO: CM4706 (record separate entries for 11/16/17 and 11/18/17 events)

 

 

11/21/17   Issued the next available cheque to pay Apple Inc. for their invoice # 4706, and applied any                    available discount and credit.

 

 

11/25/17   Edit employee – Student Name to Your Last Name, First Name (actual your full name). 

                

 

11/28/17  Write a reimbursement check to employee - your name who paid out of his/her pocket cash for $265 (pre-tax) plus HST for business meals with our customer Mabel Clarke. 

11/30/17  Enter two new payroll schedules named Weekly and Biweekly. The both pay period end dates are 11/30/2017 and the cheque dates are the same dates. Assign the schedules to all employees with a biweekly or weekly pay frequency when asked and leave vacation and deduction defaults as is. Yes, Yes, Ok.

 

 

11/30/17  Start a weekly Timesheet for Robert Jones starting 11/27/2017. The customer is Travelways Inc. and the service item is S110 - Delivery Charge, hourly. Enter 8 hours for Monday, and 8 hours for Wednesday, leave the Billable check box selected.

 

 

11/30/17  Create an invoice for Travelways Inc. from 11/30/17 weekly Timesheet.

 

 

 11/30/17  Pay the weekly and biweekly payroll for the period ending 11/30/17. Create, but not print, pay cheques. First cheque number 105

 

 

11/30/17  Run payroll statutory liabilities only for the period 11/01/2017 to 11/30/2017 and use a payment date of 11/30/17. 

 

 

11/30/17  Office Supplies on hand is $1, 050 at the end of November. Record adjustment entry for the office supplies

 

 

11/30/17  Write off one month (November) General Liability Insurance

 

 

11/30/17    The owner purchased a dining table $852 (pre-tax) plus HST 13% for his family at                       a local store – Best Furniture paid cheque#5546 from the company’s Chequing Account.

 

Part C: Export the following reports (Excel):

            

            Export the following reports (Excel) to Reports T2 Your Name folder 

 

• Journal from November 1, 2017 to current date 

(File Name “R1_Yourlastname_last3 digitsID#_ Journal”)

• Payroll Summary from November 1, 2017 to November 30, 2017 

(File Name “R2_Yourlastname_last3 digitsID#_ Payroll”)

 

Part D: Save the compressed file:

1. Create a Portable test solution file as ACCT270 Test#2 Your Name inside the folder of 270 T2 Your Name on the local C:/ Drive

 

2. Close ALL QuickBooks windows and exit the software completely.

 

 

3. Zip your data solution folders.  

 

Highlight your 270 T2 Your Name folder (make sure inside this folder including your test solution portable data files,) on the local C:/ Drive and right click on 270 T2 Your Name folder, and select the option “Send to Compressed (Zipped) Folder. See the image below.

 

     Highlight your Reports T2 Your Name (2 reports included) and right click on 

            Reports T2 Your Name folder, and select the option “Send to Compressed (Zipped) Folder.   

  

 

Part E: Upload your test files to blackboard

Go to Tests and Quizzes on blackboard, click on ACCT270 QuickBooks Computer Test 2

Browse my computer and attach your compressed 270 T2 Your Name folder and compressed

Reports T2 Your Name folder to ACCT270 QuickBooks Computer Test 2 and click “Submit”