Homework answers / question archive / ACCT204 – TEST#1 – Instructions Read the test#1 instructions before starting

ACCT204 – TEST#1 – Instructions Read the test#1 instructions before starting

Accounting

Share With

---

ACCT204 – TEST#1 – Instructions

Read the test#1 instructions before starting.  Follow all instructions in order.  Review batch listings for errors before you post the batches.  If you are unable to post because of errors, export the batch listing for part marks.  If you get stuck on something, move on to the next step.  Try to submit something for every report requested - there are part marks!  

• Make a new folder: 204 – T1– XXX– Your Name on the local C:/ Drive or your USB, this is the folder that you are going to export your PDF reports and dump your test data file at the end of the test. (XXX should be your section #.  Replace Your Name with your actual first and last names.)   

 

• Make a new folder: Reports – T1– Your Name on the local C:/ Drive or your USB, this is the folder that you are going to export your PDF reports

 

• Go to Tests and Quizzes on your blackboard site on the left pane. 

 

• Click on ACCT204 Computer Test 1 and download the attached company data file. (It will be downloaded as a zipped file).
• Download and extract the test#1 data file – ACCT204 Test#1 Start Data and

Perform Database Load

The databases for the Test #1 are:

   System database:  OMNSYS     Company database:  OMNDAT

1. Open the test data file using session date 01/01/2021.  

 

2. Replace “Your Full Name” with your actual full name from “ACCT204 – Test1 –Your  Full Name” on the Common Service – Company Profile. Reports without your name  will not be marked.

 

3. Click File – Double –click Print Destinations - Check the Preview, Report Paper Size,  Report Orientation and Letter/A4 radio button- OK.

 

4. Define the following values for the Department segment code: 

                             NB1 –  Service

                             NB2 – Sales

 

5. Define the following account structures:
   1. 1. ACC – Account
      2. DEPT – Account 

                                        Department      

 

6. Add the following chart of accounts manually:

              1010               Bank – Chequing

              1020                Accounts Receivable

              1025                Allowance for Doubtful Accounts

              1030                Inventory

              1060               Store Equipment

              2510                Accum. Dep. - Store Equip.

              3000                Accounts Payable

              3020               GST/HST Payable

              3040               GST/HST Recoverable

              3060                Income Tax Payable

              3080                Bank Loan (10 years)

              4010                Common Stock

               4xxx                Your actual Name – Capital

      (xxx – the last three digits of your student ID)

4050               Your actual Name – Drawings

4500-NB1      Revenue from Service

4500-NB2      Revenue from Sales

4600-NB2      Sales Discounts

4700-NB2      Sales Returns

5010-NB2      Cost of Sales

5100-NB2      Purchase Discounts

6040               Telephone Expense – Clearing

6040-NB1      Telephone Expense

6040-NB2      Telephone Expense

6080-NB1      Bad Debt Expense

6080-NB2      Bad Debt Expense

6090-NB1      Bank Loan Interest

7. Assigning account – Your actual Name – Capital as Default Closing Account under G/L Setup – Options –   Account page.

 

8. Add the following ending balances as of December 31, 2020.  Use the General Ledger Setup source code for this batch (all accounts are in normal balance):   Batch Description: Your actual full name – Opening Balances, failure to do so as required will result in a test grade of ZERO.

 

December 31, 2020

                          1010                                      Bank – Chequing                  8,620

                          1020                                      Accounts Receivable           4,832

                          1025                                   Allowance for Doubtful Accounts                            525

                          1030                                      Inventory                                7,654

                          1060                                      Store Equipment                  6,689

2510 Accum. Dep. - Store Equip. 3,200 3000 Accounts Payable                                       7,800

                          3020             GST/HST Payable                                       2,701

                          3040                                      GST/HST Recoverable         1,362

3060            Income Tax Payable    1,230 3080       Bank Loan            1,800

                          4010                                      Common Stock                      5,200

                          4xxx              Your actual Name – Capital                     7,826

                          4050                                   Your actual Name – Drawings                                                                          1,125

               

9. Post the batch and export the PDF posting journal to the Reports – T1– Your Name folder. (File Name “R1_Yourlastname_last3digitsID#_OB.pdf”)

 

10. Perform the necessary steps required to move the General Ledger forward to the year 2021 (create new year)

 

11. Enter the following transactions in one batch for the month of January 31, 2021 (session date).

 

Enter the following information in each of the following entry, failure to do so as required will result in a test grade of ZERO.

Batch Description: your actual full name – Current Entries

Select “Quick” on Entry Mode

In each detail line of all entries

Reference: your student ID number

Description: your actual full name

 

 

 

1. 1. Use the appropriate source code to record the following cash sales:

 

                             Jan 08 Your Name W2021 (your actual name) (service)

                                                      $158.45            (pre-tax)                             

                                                          Plus HST (13%)

 

1. 2. Use the appropriate source code to enter the following invoice received from vendor on account.  When the telephone bill is received, it is posted to a clearing account and later allocated to each department at a rate of 70% to the Sales department and 30% to the Service department.  The Reallocation Transactions source code should be used when the allocation takes place.  

 

                             Jan 16                Bell Canada (Telephone Expense)         

                                                          $486.00 (pre-tax)                                       

                                                          Plus HST (13%)

               

Allocation: 100% to Telephone Expense – Clearing

 

1. 3. Jan 28, the owner, your name purchased a new bed-side table $185.46 (pre-tax) plus HST (13%) for her/his family and made the payment from the company Bank – Chequing.

 

1. 4. Jan 31, Memo was issued in response to a revised calculation of anticipated bad debts based on a percentage of accounts receivable.  Management has requested the Allowance for Doubtful Accounts should be $825 at the end of January. Record the adjustment entry 80% to the Sales Department and 20% to the Service department.

 

1. 5. Jan 31, the $1, 800 of Term Loan (one-year remaining) is for the period of January 1, 2021 to December 31, 2021, and the monthly interest rate is 2.5%.  Record the monthly interest to Service Department, interest and principal repayments from Chequing Account for January, 2021

 

12. Post the batch and export the PDF posting journal to the Reports – T1– Your Name folder. (File Name “R2_Yourlastname_last3digitsID#_Current .pdf”)

 

13. Create the allocation Batch for the Telephone Expense. Enter a batch description: Your Name – Allocation and use January 16, 2021 as the journal entry date. 

 

14. Post the allocation batch and export the PDF posting journal to the Reports – T1–

Your Name folder. (File Name “R3_Yourlastname_last3digitsID#_Allocation .pdf”)

 

 

15. Add the following budget sets for 2021:

 

• • • • Account 4500- NB1- Revenue from Service has a total fiscal year budget amount of $46,000

 

• • • • Account 4500- NB2- Revenue from Sales will use the budget set from Account 4500- NB1 and increase by $1,000 per fiscal period.

 

Save each of the above budget screens to the Reports – T1– Your Name folder.

When each of the above budget displayed on the screen, press [Alt] + Fn + [Print Screen] or [Alt] + [Print Screen] depending on the type of your keyboards. This step will place a copy of the budget set on the clipboard. And paste each of the above budget screens onto a word document and save the word document with your name on it. 

(File Name “R4_Yourlastname_last3digitsID#_Budgets”)

 

16. Export the following PDF reports to the Reports – T1– Your Name folder.

 

• G/L Options report (File Name “R5_Yourlastname_last3digitsID#_Option”)
• Segment Code Report (File Name “R6_Yourlastname_last3digitsID#_SGC”)
• Account Structures report (File Name “R7_Yourlastname_last3digitsID#_AST”)
• Chart of Accounts – Long Form (File Name “R8_Yourlastname_last3digitsID#_ACT”)
• G/L Batch Status report (File Name “R9_Yourlastname_last3digitsID#_BST”)

 

17. Dump your test solution files OMNSYS and OMNDAT to the folder 204 – T1– XXX –  Your Name on the local C:/ Drive or your USB. 

 

18. Highlight your 204 – T1– XXX– Your Name (make sure inside this folder including your test backup data files OMNDAT and OMNSYS, remove the hyphen if you cannot compress the folder) on the local C:/ Drive or your USB and right click on 204 – T1– XXX– Your Name folder, and select the option “Send to Compressed (Zipped) Folder. 

And Highlight your Reports – T1– Your Name folder (9 reports included, remove the hyphen if you cannot compress the folder) and right click on Reports – T1– Your Name folder, and select the option “Send to Compressed (Zipped) Folder. 

19. Go to Tests and Quizzes on blackboard, click on ACCT204 Computer Test 1 Browse my computer and attach your compressed 204 – T1– XXX– Your Name folder and Reports – T1– Your Name folder to ACCT204 Computer Test 1 and click