practice_exam_instructions

pdf

School

Sheridan College *

*We aren’t endorsed by this school

Course

10000

Subject

Accounting

Date

Jan 9, 2024

Type

pdf

Pages

10

Uploaded by AmbassadorThunderLeopard27

Report
SAGE 50 ACCOUNTING PRACTICE TEST This test requires you to process transactions in ALL Ledgers for a company named WING DINGS , who specializes in tattoo design, application, and removal. READ These Instructions FIRST: If you do NOT have an active database ready for this exam , you must first do the following: On your computer: o Create a folder in your ASA course folder and call it something memorable, like PRACTICE. In Slate: o Go to the Content -> Practice E xam and download the file called wing_dings_bu to your PRACTICE file folder. Back to your computer: o Start Sage o Restore the Wing Dings company from the .CAB file. o Hopefully you’re in the habit of going to SETTINGS, then Company Information and adding YOUR NAME to the company name. ( Keep in mind, if this step has not been processed, your submission will NOT be graded! Meaning you will get a grade of zero!) You should be able to process all requirements within 2 hours. Watch the TIME! (The half-way point is at the end of page 6.) Process EACH of the following tasks IN ORDER. Keep in mind accounting is all about paying attention to details. We’ve hidden some details in these transactions that, if you miss them, will cost you marks. PAY ATTENTION TO THE DETAILS!
For your information 1. Here is the opening trial balance WING DINGS Trial Balance April 1, 2022 Debit Credit 1080 Bank: CAD Chequing $25 680 1100 Bank: Credit Card 2 200 1200 Accounts Receivable 2 800 1240 Loans Receivable 150 1280 Sterilized Needles 650 1300 Store Supplies 400 1420 Computers & Video Monitors 6 500 1440 Sterilization Equipment 4 800 1460 Tatoo Equipment 12 000 1480 Store Fixtures & Displays 4 500 1490 Laser Equipment 120 000 1620 Tatoo Designs 10 800 1640 Ink 1 030 2100 Bank Loan $ 6 000 2150 Credit Card Payable 1 200 2200 Accounts Payable 4 500 2300 Vacation Payable 360 2310 EI Payable 145 2320 CPP Payable 390 2330 Income Tax Payable 625 * 2650 HST Charged on Sales 1 890 * 2670 HST Paid on Purchases 1 620 2850 Mortgage Payable 60 000 3560 Owner, Capital _______ 118 020 $193 130 $193 130 2. All sales and purchases are subject to HST @ 13% (unless otherwise noted). 3. Cash/Cheque Sales Transactions default to the ‘Undeposited Cash & Cheques Account’ #1060 4. Cash/Cheque Purchase Transactions default to the ‘Bank CAD Chequing Account’ #1080 5. All Credit Card transactions are to be processed to HOPEFULL credit card. 6. Employee Danny Drawer is entitled to 2% commission on all sales 7. Partial payments, partial receipts are ineligible for discounts 8. When creating new customer, supplier and general ledger accounts, use the information provided in this document, leave all other Sage settings as the default setting.
Transactions for you to complete 1) Create A Supplier Account. Supplier: Ink Inspector Terms: N30 Exp acct: 5250 Licenses Address: Oakville, ON Tax Code: HI (HST @ 13%, included) 2) Create A Customer Account. Client: Noya Modeling Agency Terms: 1/15, N30 Rev acct: 4050 Rev from services Address: Hamilton, ON Tax Code: H (HST @13%) Credit Limit: $10,000 Change the Session Date to April 8, 2022 3) Enter the following transactions into Sage. Purchase Invoice #GB-806 Dated April 4 from Germ Busters; $3,750, plus HST for new sterilization equipment (add freight charges of $225 + HST). ( Pay attention to the words! This is not sterilized needles; this is for sterilization equipment. You need to change the account number. ) Sales Invoice Dated April 4 to Noya Modeling Agency $8,000, plus HST for laser treatments to remove tattoos on new models hired in the agency. Credit Card Sales Invoice Dated April 4 to One-Time walk-in clients. Sales Summary: $1,420, plus HST for laser treatments. Payment Cheque Dated April 5 to Dye Masters in payment of Invoice #DM-5379 (take the discount available) Payment Cheques Dated April 5 to Flesh Decorators in payment of Invoice #FD-364 Cheque Purchase Invoice #LS-35887 Dated April 5 from NEW vendor Law Sum (use Quick Add); $930, including HST for professional legal services. Terms: Net 10
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Credit Card Purchase Invoice #KK-896 Dated April 5 from NEW vendor King Kopy (use Quick Add); $580, plus HST for producing informational DVDs. Create a NEW Group Account 5225 ‘Promotional Expense’. Terms: N20 Cheque Receipt Dated April 6 from Murray Misery for remaining payment due (including discount taken) for Invoice #2435. Record Cheque #44 Memo #1 Dated April 7 Adjust Sales Invoice #2550 to Noya Modeling Agency. They will become a contract client. Instead of a one-time bill of $8,000, they will now be invoiced $2,000 bi-weekly (plus HST) until the current treatment plan is completed. Store this sales invoice as a recurring transaction. Purchase Invoice #FD-495 Dated April 7 from Flesh Decorators to fill purchase order #55 in full (we received everything we ordered. Add freight charges of $100 + HST. Memo #2 Dated April 8 A box of surgical gloves/masks and a box of sterilized needles have been contaminated. Write-off $150 worth of Store Supplies & $75 worth of Sterilized Needles to the supplies expense account. (Note, these are not inventory items. The gloves/masks are from the Store Supplies account and the sterilized needles are from the Sterilized Needles account.) Change the Session Date to April 15, 2022 4) Enter the following transactions into Sage. Cash Sales Invoice Dated April 11 from One-Time walk-in clients: (regular pricing + HST) 12 of 101 Ink – Permanent Colour $120 12 of 102 Ink – Permanent Outline 72 6 of 201 Ink – Temporary Colour 48 6 of 202 Ink – Temporary Outline 42 15 of 301 Designs – Small 375 15 of 501 Tattoo Applications 1,200 Memo #3 Dated April 11; Transfer $2,500 from ‘Bank: Credit Card’ to ‘Bank: CAD Chequing Account’
Payment Cheque Dated April 12 to Germ Busters; $2,500 in partial payment of Invoice #GB-806 Cheque Receipt Dated April 12 from Noya Modeling Agency for $2,260 for invoice #2550. Record Cheque #316 (Discount not applicable due to special pricing in contractual arrangement.) Sales Order Dated April 13 Convert Sales Quote #32 for Sunshine Weddings to a Sales Order. Adjust the order in accordance with the following details and offer preferred pricing for each of the items ordered: 20 of 101 Ink – Permanent Colour $ 160 20 of 102 Ink – Permanent Outline 100 20 of 302 Designs – Medium 1,000 20 of 501 Tattoo Applications 1,400 * Record a $750 deposit made on this order with Cheque #791 Credit Card Payment Dated April 13 to Hopefull for $900 for purchases made up to the March 31 statement date plus an additional $55 for annual credit card fees. (Total $955). (Note: This is different than the amount recorded in Sage as we will only pay the amount listed on the latest statement.) Accept the assigned cheque number as the source number. Cash Purchase Invoice #GB-1010 Dated April 14 to Germ Busters; $675, plus HST for a skid of sterilized needles. Payroll #1 Dated April 15 Pay hourly employee, Amy Artist for 35 hours regular work and 7 hours of overtime from Apr 1st to 15 th . Artist should also be paid for serving 15 clients. Add $100 for an additional loan. Payroll #2 Dated April 15 Make payroll tax remittance to the Receiver General for the pay period ending April 1st Include remittance for Income Tax, EI & CPP. Reference #MarchStats Deposit Slip #607 Dated April 15; deposit all 3 cheques received since April 1, totaling $5,767.00 and cash consisted of 18 × $5, 12 × $10, 14 × $20, 10 × $50, 11 × $100 & $8.41 in coins (cash total of $2,098.41). Total deposit amount to ‘Bank: CAD Chequing’ account = $7,865.41
Sales Invoice Dated April 15 Convert Sales Order #32 for Sunshine Weddings to a client invoice for half of the order (for the bride’s party only. The groom’s party will book later.) Bank Memo # HB-77225 Dated April 15 from Hijak Bank; NSF Cheque #316 from Noya Modeling Agency. Process the negative receipt to reverse the original entry. (Pay attention to the details. The credit should be to the bank account, not Undeposited Cheques and Cash.) After the invoice has been re-established, adjust it to bill an additional $20 for bank service charges (no HST). (Use account 5010 Credit Card and Bank Fees. ) Change the Session Date to April 22, 2022 5) Enter the following transactions into Sage. Sales Invoice Dated April 18 to Noya Modeling Agency for recurring bi-weekly billing. Credit Card Sales Invoice Dated April 19 from Silly Willy Costumes for 25 Design Creations @ $250 each + HST ( Pay attention to the details. This is a credit card transaction. No sales discounts allowed. ) Purchase Invoice #DM-5821 Dated April 19 from Dye Masters: Add freight charges of $80 + HST 26 of 101 Ink – Permanent Colour $1,040.00 26 of 102 Ink – Permanent Outline 1,300.00 34 of 201 Ink – Temporary Colour 1,700.00 34 of 202 Ink – Temporary Outline 1,360.00 Cash Receipt Dated April 20 from Murray Misery; advance deposit of $100 for booking a partial tattoo removal and re- design. Cheque 157 Credit Card Purchase Invoice #II-6310 Dated April 20 from Ink Inspectors; $720, including HST for renewal of license and site inspection. Cheque Purchase Invoice #DM-6273 Dated April 20 from Dye Masters for a tattoo gun costing $4,290 (add $60 + HST for freight charges). Paid with cheque #327.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Cheque Sales Invoice Dated April 21 from Silly Willy Costumes: Record Cheque #658 40 of 201 Ink – Temporary Colour $280 40 of 202 Ink – Temporary Outline 200 23 of 302 Designs – Medium 1,380 17 of 303 Designs – Large 1,700 Provide preferred pricing to this client on the ink purchases only. Memo #4 Dated April 21 Several boxes of inventory were damaged after a truck backed onto a skid in the parking lot. The following items are not usable and require adjustment (accept the cost price): 20 of 101 Ink - Permanent Colour 15 of 201 Ink - Temporary Colour Change the Session Date to April 30, 2022 6) Enter the following transactions into Sage. Sales Invoice - Credit Note #CN-2553 Dated April 25 to Sunshine Weddings. A tattoo applied on April 15 smudged shortly after application. Create a negative invoice and give credit for 1 Tattoo Application at the preferred price, plus HST. Edit out default terms. Create a NEW Group Account 4200 “Sales Returns & Allowances” Purchase Order Dated April 26 to Flesh Decorators for 15 Special Order Designs @ $150 each + HST * Paid $500 in advance by cheque to secure this customized special order. Purchase Invoice – Debit Note #DN-5821 Dated April 26 from Dye Masters for a purchase allowance/credit of one 101 Ink - Permanent Colour that was sent in the wrong shade. Edit out default terms. Credit Card Receipt Dated April 27 from Sunshine Weddings for the balance of their account. (Be sure to apply the pre-paid deposit.)
Bank Debit Memo #HB-96445 Dated April 28 from Hijak Bank: $700 for mortgage payment, including $90 for interest and $610 for principal. $500 for bank loan payment, including $110 for interest and $390 for principal. Total amount withdrawn from the ‘Bank: CAD Chequing ‘account is $1,200 Payroll #3 Dated April 29 Pay hourly employee; Amy Artist for 35 hours regular work from Apr 16th to 29th Artist should also be paid for serving 12 clients. Recover $125 for previous loans. Payroll #4 Dated April 29 Pay salaried employee; Danny Drawer his regular salary and $387.34 in commission from Apr 1st to 29th Memo #5 Dated April 29; Net HST owing to Receiver General from April 1 st to 22 nd Use the tax summary report to determine amount owing and process a cheque in the payment journal. Memo #6 Dated April 29; Record amortization/depreciation in the amount of $675 on capital equipment. Deposit Slip #608 Dated April 29; deposit all cheque received since April 01, and $100 in cash (5 × $20) Back-Up Your Work!
7) Bank Reconciliation; Set-up Account #1080 ‘Bank: CAD Chequing’ for reconciliation. Link the following accounts (create new accounts as necessary) Income 1: Name = Interest Revenue (Create Account #4250 Interest Revenue) Expense1 & 2: Name = Bank Charges & NSF (Link Account #5010 Credit Card & Bank Fees) Adjustment: Name = Bank Reconciliation (Create Account #5025 Bank Rec Errors) April 1 is the statement start date and April 30 is both the statement end date and the reconciliation date. NOTE: There are two prior outstanding transactions that need to be input: Source Description Date Amount 460 Deposit Slip Mar 31 Deposit: $2,600 310 Flesh Decorators Mar 31 Withdrawals: $1,800 Use the following bank statement details to complete the reconciliation; Date Description Withdrawals Deposits Balance 31-Mar-22 Opening balance $ 24,880.00 01-Apr-22 Deposit 460 2,600.00 27,480.00 01-Apr-22 Cheque 300 (1,800.00) 25,680.00 01-Apr-22 Interest on account 15.00 25,695.00 09-Apr-22 Cheque 321 (2,000.00) 23,695.00 10-Apr-22 Cheque 320 (940.50) 22,754.50 11-Apr-22 Transfer - Bank: Credit Card 2,500.00 25,254.50 12-Apr-22 Cheque 322 (930.00) 24,324.50 12-Apr-22 Deposit 607 7,865.41 32,189.91 15-Apr-22 DD Payroll (863.85) 31,326.06 15-Apr-22 NSF - Noya Modeling (2,260.00) 29,066.06 15-Apr-22 NSF - Service Fee (20.00) 29,046.06 18-Apr-22 Cheque 323 (2,500.00) 26,546.06 18-Apr-22 Cheque 325 (755.12) 25,790.94 20-Apr-22 Cheque 326 (1,160.00) 24,630.94 21-Apr-22 Cheque 324 (955.00) 23,675.94 27-Apr-22 Cheque 327 (4,669.72) 19,006.22 28-Apr-22 ETF Loans #HB-96445 (1,200.00) 17,806.22 29-Apr-22 Cheque 328 (500.00) 17,306.22 29-Apr-22 DD Payroll (471.79) 16,834.43 29-Apr-22 DD Payroll (1,758.23) 15,076.20 29-Apr-22 Service Fee (45.00) 15,031.20 29-Apr-22 Ending balance 15,031.20
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
10) Export the following reports to Excel and check the solutions for accuracy: PAY ATTENTION TO THE DATES FOR THESE REPORTS. SAGE DOES NOT START OFF THEIR REPORTS WITH THESE DATES. WE’RE TRYING TO SEE IF YOU’RE PAYING ATTENTION. UPLOAD REPORTS WITH THE WRONG DATES AND YOU GET ZERO!!! Trial Balance at April 30, 2022 ALL General Ledger Accounts from April 1 to April 30, 2022 o including corrections (miss this and you lose marks) ALL Journal Entries from April 1 to April 30, 2022 o including corrections (miss this and you lose marks) Balance Sheet at April 30, 2022 Income Statement from April 1 to April 30, 2022 Supplier Aged Detail at April 30, 2022 Customer Aged Detail at April 30, 2022 Bank Reconciliation Summary at April 30, 2022 Back-Up Your Work!