All figures (e.g. sales, purchases, expenses) are net of (i.e. do not include) applicable taxes-you must add the tax unless it is not required.

Note: HST is charged at 13%. You must add HST where appropriate.

Change the company name to Test 2 and the last 4 digits of your student ID (e.g. Test 2 1234)

As well, all batches and transactions required your initials in the description. For example for batch 1 description (Historical invoices xx), where xx is your initials.

Change the Session Date to February 28, 2021.

If Purchase order numbers are required and not provided, use the current date in the format mm-dd-yy (e.g. 11-13-21).

1. Set up a new vendor with the following information: Vendor Number: 1520; Book Supplies (xx), 448 McNicoll Ave, North York, ON M2H 2E1, Telephone: (416) 499-3088;

Group code: ECN; Terms code: Net 30; Credit Limit: 5,000; Dist. Code: OFF200; Tax Group, ONT13; HST13 Class, 1-Taxable (4 Marks).

2. Enter the following current vendor invoices and set up the batch as Invoice Batch. Use 02/28/2021 as the batch date (with xx after the batch description). (10 Marks)

Name Terms Date Invoice # Amount

#1 West Metal Products 2% 10, Net 30 02/05/2021 69221 1,452.63

Distribution code: MANEQP

Amount: 1,285.51

HST13: 167.12

(with xx after each transaction line description)

#2 Maynard Insurance Net 30 02/11/2021 A85899 895.10

G/L Account: 1750-100

Amount: 792.12

HST13: 109.98

(with xx after each transaction line description)

#3 Bell Canada Net 30 02/15/2021 02/15/2021 544.66

Distribution Set: TELE

Distribution Split evenly between ELEC & MECH

Amount: 482.00

HST13: 62.66

(with xx after each transaction line description)

#4 Office Depot 2% 10, Net 30 02/03/2021 69445 4,317.73

Distribution code: OFF200

Amount: 3,821.00

HST13: 496.73

(with xx after each transaction line description)

#5 Book Supplies Net 30 02/21/2021 30465 452.00

Distribution code: OFF100

Amount: 400.00

HST13: 52.00

(with xx after each transaction line description)

3. Print the Posting Journal (PDF report or screen shot) for this batch and review for accuracy (Create a PDF or use Print screen). Post the batch. (2 marks)

4. Setup a batch called Recurring Entry Batch and enter transactions for questions 6 and 7 (2 Marks).

5. You have setup a deal with Office Depot for them to send you 10 cases of computer paper on the 15th of each month at a cost of $450.00 plus HST13, Net 30 days. Create a recurring payable code for this monthly transaction. Assign it to the monthly schedule code that is processed on the 15th of each month, beginning 02/15/2021. The recurring payable to be charged to the office expense account of the textbook department.

(Insert you initials after each batch description and transaction line description) (4 marks).

6. Invoice number 69445 from the Office Depot was posted to the wrong department. Instead of being posted to the textbook department, ii should have been posted to the Consulting Department. Create the necessary adjustment batch to make this adjustment. Use the same date as the original invoice. (with xx after each transaction line description) (3 marks)

7. Print the Posting Journal (PDF report or screen shot) for this batch and review for accuracy (Create a PDF or use Print screen). Post the batch. (2 marks)

8. Enter the following transactions in a new payment batch (2 Marks):

Description: Payments February, 2021 (xx in batch description)

Batch Date: 02/28/2021

Bank Code: TDCHQ

9. Enter a full payment to Bell Canada for invoice 02/15/2021.

(with xx after each entry number description) (3 marks)

10. Enter a partial payment to Maynard Insurance for invoice A85899 for $250.

(with xx after each entry number description) (3 marks)

.

11. Enter a miscellaneous payment to Mr. John St. John for invoice number 6281. You purchased office supplies used to print the textbooks. The total invoice is $78.00 plus HST at 13%.

(with xx after each entry number description) (4 marks).

12. Print the Posting Journal (PDF report or screen shot) for this batch and review for accuracy. Do not print the cheques. (2 marks)
13. Enter the following transactions in a new Debit Note batch (2 Marks):

Description: Debit Note February, 2021 (xx in batch description)

Batch Date: 02/28/2021

14. Use the invoice entry to create a Debit Note for West Metal Products for Interest charges with DR 8766 as the Document Number and the interest amount of $34.50. All dates will be 02/28/2021.

(3 Marks).

15. Print the Posting Journal (PDF report or screen shot) for this batch and review for accuracy (Create a PDF or use Print screen). Post the batch. (2 marks)

16. Pay the following invoices on the next cheque run, even though they may not be due yet

(6 Marks):

Office Depot Invoice Number 69221

Book Supplies Invoice Number 30465

17. After you completed YOUR last question, make sure ALL batches are posted, as applicable. Make sure ALL batches are included and PDF reports are produced (10 marks):

a. Accounts Payable Invoice Batch List

Name your PDF file AP Payable Invoice Batch List_xx , where xx= your initials

b. Accounts Payable Recurring Entry Batch List

Name your PDF file AP Recurring Entry Batch List_xx , where xx= your initials

c. Accounts Payable Payments Batch List

Name your PDF file AP Payments Batch List_xx , where xx= your initials

d. Accounts Payable Debit Note Batch List

Name your PDF file AP Debit Note Batch List_xx , where xx= your initials

e. Print (export) the Accounts Payable Aged Full Trial Balance

Name your file AP Aged TB_xx

18. At the end of the test, include the following (above reports, in PDF format or screen shots using PrtSc) files in your Answer_xx folder, where xx = your initials and post to the Test 2 Drop Box. (1 Mark).