Description 1Journal Entries for all journals from April 1 to April 15, 2022 Show foreign currency amounts and additional information. 2Balance Sheet at April 15, 2022 3Income Statement from April 1 to April 15, 2022 4Employee Summaryi cant upload my sage file so i will put my google drive address, u can download sage filehttps://drive.google.com/file/d/1Ch3Rw1xzvOSYN9rGR 1 attachmentsSlide 1 of 1attachment_1attachment_1.slider-slide > img { width: 100%; display: block; } .slider-slide > img:focus { margin: auto; } Unformatted Attachment Preview MAJOR PROJECT AC214 – SAGE 50 ACCOUNTING 2018 TO TEACH TO GUIDE TO LEARN MAJOR PROJECT – INSTRUCTIONS The inf ormation provided in this project allows you to set up all ledgers for an Ontario company named WOOFIE’S. WOOFIES specializing in sales of large purebred and pedigreed dogs. In addition, they sell cages or dog houses, and high-quality dog food. Some of the dog food is purchased from a supplier in the United States. The manager of the store provides some basic dog grooming services while the assistant works mostly in store sales and caring for the animals that are for sale. All ledgers are used. Allocations have been made active with this company; however, it is not used in any of the entries in this project. Ignore any references to “not being fully accolated” during this project. 1. Change the session date to April 8, 2022. Add the shortcuts you need and then enter the following transactions: NOTE: Remember to add Kitty Feline as the salesperson for all sales. Edit prices as needed. Cheque Purchase Invoice #FW-04-18 Dated April 2, 2022 From Four Walls Inc., $1 582 f or monthly rent, HST included. Paid by cheque #501. Store as monthly recurring entry. Use Quick Add for the new supplier. Cash Receipt #1522 Dated April 4, 2022 From Nikki Chow, cheque #183 for $1 450 in f ull payment of invoice #1104, taking into account 2% sales discount of $50 f or early payment. Purchase Invoice #KK-601 Dated April 4, 2022 From Kanine Kibble 10 Holistic Mature Dog Chow ($20 ea) 20 Holistic Puppy Chow ($7.50 ea) 50 Holistic Regular Chow ($10 ea) Freight Charge HST Paid Invoice Total Terms: 2/15, net 30 The exchange rate is 1.025 Purchase Order #1001 Dated April 4, 2022 Shipping Date April 11, 2022 From Kennelworth Pound 4 Samoyed ($450 ea) Freight Charge HST Paid Purchase Order Total Terms: 1/10, net 30 Copyright © 2019 Pearson Canada Inc. Page 1 of 7 $200.00 150.00 500.00 30.00 114.40 $994.40 USD USD USD USD USD USD $1 800 100 247 $2 147 0520/G2/AC214/DAY9 MAJOR PROJECT AC214 – SAGE 50 ACCOUNTING 2018 TO TEACH TO GUIDE TO LEARN Payment Cheque #502Dated April 4, 2022 To Kennelworth Pound, $3 435 in full payment of invoices #KP-6621 and KP-6808, taking into account 1% purchase discount of $65 for early payment. Payment Cheque #1023 Dated April 5, 2022 To Kanine Kibble, $290 USD in full payment of invoice #KK-402. The exchange rate is 1.030. Paid from Bank: USD Chequing Account. Sales Quote #45 Dated April 6, 2022 Delivery Date April 15, 2022 To Show Off Dogs (preparation for dog show) 10 Shampoos $22 each 10 Clippings – large dog 90 each HST Charged 13% Terms: 2/10, net 30. Cash Sales Invoice #1121 Dated April 6, 2022 To Doggie Day Care (Use Quick Add for new Regular customer) 10 5kg bags Holistic Puppy Chow $20 each 20 10kg bags Holistic Regular Chow 28 each 5 10kg bags Holistic Mature Dog Chow45 each Sales Discount for regular volume purchase 15% HST Charged 13% Invoice total $946.09 paid by cheque #4222. Store as recurring weekly entry. Memo #1 Dated April 6, 2022 Show Off Dogs has accepted the sales quote and is placing an order. Convert Sales Quote #45 to Sales Order #45 using the same shipping date. Cash Receipt #1523 Dated April 7, 2022 From Show Off Dogs, cheque #288 for $500 as deposit #36 to accept sales order #45. Deposit Slip #14 Dated April 7, 2022 Deposit three cheques received in the past week. Total deposit is $2 896.09. Deposit to the Bank: CAD Chequing account. Copyright © 2019 Pearson Canada Inc. Page 2 of 7 0520/G2/AC214/DAY9 MAJOR PROJECT AC214 – SAGE 50 ACCOUNTING 2018 TO TEACH TO GUIDE TO LEARN WOOFIE’S April 8, 2022 Invoice #1122 Bill To Customer Nikki Chow Address 55 Wagstail Boulevard London, Ontario N8P 7D3 Phone (519)762-6712 Division Sales Payment Terms 2/10 , net 30 Qty. Description 2 Saint Bernards 5 5kg bags Holistic Puppy Chow 2 Wooden Dog House Kits Unit Price Line Total $1,450 $2,900 20 100 550 1,100.00 Subtotal 4,100 Sales Tax 533 Total $4,633 Thank you for your business! WOOFIE’S 460 Barque Street London, Ontario N9L 4B6 Memo #2 Dated April 8, 2022 Pay hourly employee, Bobbi Bowser for 35 hours regular work. Include $200 advance, which will be repaid at the rate of $50 over each of the next four pay periods. Bowser should be paid for grooming 6 dogs (No. Dogs piece rate pay). Issue direct deposit slip #34. Hint: Use Payroll Run & ignore warnings. Copyright © 2019 Pearson Canada Inc. Page 3 of 7 0520/G2/AC214/DAY9 MAJOR PROJECT AC214 – SAGE 50 ACCOUNTING 2018 TO TEACH 2. TO GUIDE TO LEARN Back up the data files. Continue with the file WOOFIE.SAI. Change the session date to April 15, 2022. Enter the following transactions: KENNELWORTH POUND April 11, 2022 Invoice KP-7222 Bill To Customer WOOFIE’S Address 440 Rover Circle St. Mary, Ontario N8T 7F3 Phone (519) 774-7109 Purchase Order # 1001 Payment Terms 1/10 net 30 Qty. 4 Description Unit Price Samoyed dogs Line Total $450 $1,800 Freight Charge 100 Subtotal 1,900 HST Paid 247 Total $2,147 Thank you for your business Copyright © 2019 Pearson Canada Inc. Page 4 of 7 0520/G2/AC214/DAY9 MAJOR PROJECT AC214 – SAGE 50 ACCOUNTING 2018 TO TEACH TO GUIDE TO LEARN Memo #3 Dated April 11, 2022 WOOFIE’S will offer a package deal to the first five customers purchasing a Samoyed and Wooden Dog House Kit. They will also receive free assembly of the dog house, two coupons for free shampoos , and a supply of dog food. The regular price of this $1 600 offer is over $1 950. To prepare for this special offer: (a) Create new inventory item: 104 Promotional Spring Special Minimum level: 0 Regular and Pref erred Selling Price: $1 600 CAD each Create new Group accounts 1450 Promotions 4030 Revenue from Promotions Asset: 1450 Revenue: 4030 C.O.G.S.: 5060 Taxes: not exempt for HST (b) Enter the inventory item assembly as follows: Assembly Components 5 Samoyed @ $ 437.50 each 5 Wooden Dog House Kits @ $255.00 each 10 10kg bags Holistic Regular Chow @ $10.45 each Additional Costs $500 (labour for assembly and shampoos) Assembled Items 5 Promotional Spring Specials @ $4 067.00 total ($813.40 each) Cash Receipt #1524 Dated April 11, 2022 From Nikki Chow, cheque #189 for $4 540.34 in payment of invoice #1122, taking into account 2% sales discount of $92.66 for early payment. Sales Invoice #1123 Dated April 12, 2022 To Show Off Dogs (preparation for dog show), to fill Sales Order #45 10 Shampoos $22 each 10 Clippings – large dog 90 each HST Charged 13% Terms: 2/10, net 30 Invoice total: $1265.60 Cash Sales Invoice #1124 Dated April 13, 2022 Recall stored entry. To Doggie Day Care 10 5kg bags Holistic Puppy Chow 20 10kg bags Holistic Regular Chow 5 10kg bags Holistic Mature Dog Chow Sales Discount for regular volume purchase HST Charged Invoice total $946.09 paid by cheque #4355. Copyright © 2019 Pearson Canada Inc. $20 each 28 each 45 each 15% 13% Page 5 of 7 0520/G2/AC214/DAY9 MAJOR PROJECT AC214 – SAGE 50 ACCOUNTING 2018 TO TEACH TO GUIDE TO LEARN Credit Card Sales Invoice #1125 Dated April 15, 2022 To Collee Schnauzer (Use Full Add for new Regular customer, Terms: net 1, Tax Code: H) 2 Promotional Spring Specials $1 600 each (Including 4 coupons for shampoo and f ree dog house assembly) HST Charged 13% Invoice total $3 616 paid by SpendMore. There is no discount on the promotional offer. Memo #4 Dated April 15, 2022 Inventory stock of dog food required to feed dogs for sale in store. Complete an inventory adjustment to decrease the inventory for the following items: 5 5kg bags Holistic Puppy Chow 10 10kg bags Holistic Regular Chow Use account 1280 Food Supplies instead of the default Adjustment Write-off account. Deposit Slip #15 Dated April 15, 2022 Deposit two cheques received in the past week. Total deposit $5 486.43. Deposit to the Bank: CAD Chequing account. Memo #5 Dated April 15, 2022 Transf er $5 000 f rom Bank: Credit Card to Bank: CAD Chequing Account. Bank Credit Memo #PLCU-4433 Dated April 15, 2022 From Pet Lovers Credit Union, approval of $5 000 bank loan at 6% interest per annum. Amount deposited to CAD Chequing bank account. Memo #6 Dated April 15, 2022 Prepare the Sales by Salespersons Detail Report, to check that all sales are included for Feline. Look up all sales invoices and adjust them to add Feline as the salesperson if necessary. Calculate 1% of the total sales and document to be added to Kitty’s next pay period. Memo #7 Dated April 15, 2022 Pay hourly employee, Bobbi Bowser for 35 hours regular work. Recover $50 advance. Bowser took one day sick leave during the week. (Allow the net days accrued to be negative.) Bowser should be paid for grooming 5 dogs (No. Dogs piece rate pay). Issue deposit slip #35. Memo #8 Dated April 15, 2022 Pay salaried employee, Kitty Feline $2 250 her regular bi-monthly salary. Calculate and include sales commission (1%) for Feline. Feline took two days vacation during the pay period. Issue deposit slip #36. Cheque Purchase Invoice #PVS-445 Dated April 15, 2022 From Pooch Veterinary Services, $600, plus $78 HST, for vaccination and health checkups for all new dogs. Invoice total $678 paid by cheque #503. Memo #9 Dated April 15, 2022 Make payroll tax remittance to the Receiver General for the pay periods ending April 15, 2022. Include remittance for income tax, EI, and CPP. Issue cheque #504. Copyright © 2019 Pearson Canada Inc. Page 6 of 7 0520/G2/AC214/DAY9 MAJOR PROJECT AC214 – SAGE 50 ACCOUNTING 2018 TO TEACH 3. TO GUIDE TO LEARN Bank reconciliation: Set up account 1080 f or account reconciliation. Use the f ollowing linked accounts. Create new accounts if necessary. Income: Interest 4280 Revenue from Interest Expense1: Bank Charges 5010 Bank & Credit Card Fees Expense2: NSF fee 5010 Bank & Credit Card Fees Adjustment: 5005 Reconciliation Adjustments Reconcile the account using April 1 as statement start date and April 15 as the statement end date and the reconciliation date. There are two outstanding prior transactions: Source Description Date Amount 13 Deposit slip Mar 25 Deposit $4 600 500 Kennelworth Pound Mar 30 Payment $2 700 (Hint: af ter adding the first outstanding transaction, click Insert Outstanding again to access a new transaction line.) Use the f ollowing bank statement details to complete the reconciliation. Mar. 15 Mar. 25 Mar. 30 Apr. 1 Apr. 1 Apr. 4 Apr. 4 Apr. 8 Apr. 8 Apr. 15 Apr. 15 Apr. 15 Apr. 15 Apr. 15 Apr. 15 withdrawals Balance forward Deposit Cheque 500 2 700.00 Interest on account Service f ee 15.00 Cheque 501 1 582.00 Cheque 502 3 435.00 Deposit 14 Payroll transf er Ref #34 625.93 Deposit 15 Credit memo Transf er f rom 02333-88899 Payroll transf er Ref #35 427.05 Payroll transf er Ref #36 1781.92 Closing Balance deposits balance 22 389.00 4 600.00 22.00 2 896.09 5 486.43 5 000.00 5 000.00 34 826.62 Note: if the unresolved when done is not cleared to zero and if amount it is out is due to any of the payroll entries, go ahead and process with a balance in the unresolved. Your payroll entries will be evaluated for their accuracy at the source. 4. Print the following reports and hand them in to your instructor for grading: Journal Entries for all journals from April 1 to April 15, 2022 Show, f oreign currency amounts and additional information. Balance Sheet at April 15, 2022 Income Statement from April 1 to April 15, 2022 Employee Summary Copyright © 2019 Pearson Canada Inc. Page 7 of 7 0520/G2/AC214/DAY9 Purchase answer to see full attachment Tags: Dog Food sales of large purebred and pedigreed dogs Kanine Kibble caring for the animals Discount allowed User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.

Description

1Journal Entries for all journals from April 1 to April 15, 2022
Show foreign currency amounts and additional information. 2Balance Sheet at April 15, 2022 3Income Statement from April 1 to April 15, 2022 4Employee Summaryi cant upload my sage file so i will put my google drive address, u can download sage filehttps://drive.google.com/file/d/1Ch3Rw1xzvOSYN9rGR

1 attachmentsSlide 1 of 1attachment_1attachment_1.slider-slide > img { width: 100%; display: block; }
.slider-slide > img:focus { margin: auto; }

Unformatted Attachment Preview

MAJOR PROJECT
AC214 – SAGE 50 ACCOUNTING 2018
TO TEACH
TO GUIDE
TO LEARN
MAJOR PROJECT – INSTRUCTIONS
The inf ormation provided in this project allows you to set up all ledgers for an Ontario company named
WOOFIE’S. WOOFIES specializing in sales of large purebred and pedigreed dogs. In addition, they sell
cages or dog houses, and high-quality dog food. Some of the dog food is purchased from a supplier in the
United States. The manager of the store provides some basic dog grooming services while the assistant
works mostly in store sales and caring for the animals that are for sale. All ledgers are used.
Allocations have been made active with this company; however, it is not used in any of the entries in this
project. Ignore any references to “not being fully accolated” during this project.
1.
Change the session date to April 8, 2022. Add the shortcuts you need and then enter the
following transactions:
NOTE: Remember to add Kitty Feline as the salesperson for all sales. Edit prices as needed.
Cheque Purchase Invoice #FW-04-18 Dated April 2, 2022
From Four Walls Inc., $1 582 f or monthly rent, HST included. Paid by cheque #501.
Store as monthly recurring entry. Use Quick Add for the new supplier.
Cash Receipt #1522 Dated April 4, 2022
From Nikki Chow, cheque #183 for $1 450 in f ull payment of invoice #1104, taking into account 2% sales
discount of $50 f or early payment.
Purchase Invoice #KK-601
Dated April 4, 2022
From Kanine Kibble
10 Holistic Mature Dog Chow ($20 ea)
20 Holistic Puppy Chow ($7.50 ea)
50 Holistic Regular Chow ($10 ea)
Freight Charge
HST Paid
Invoice Total
Terms: 2/15, net 30
The exchange rate is 1.025
Purchase Order #1001
Dated April 4, 2022
Shipping Date April 11, 2022
From Kennelworth Pound
4 Samoyed ($450 ea)
Freight Charge
HST Paid
Purchase Order Total
Terms: 1/10, net 30
Copyright © 2019 Pearson Canada Inc.
Page 1 of 7
$200.00
150.00
500.00
30.00
114.40
$994.40
USD
USD
USD
USD
USD
USD
$1 800
100
247
$2 147
0520/G2/AC214/DAY9
MAJOR PROJECT
AC214 – SAGE 50 ACCOUNTING 2018
TO TEACH
TO GUIDE
TO LEARN
Payment Cheque #502Dated April 4, 2022
To Kennelworth Pound, $3 435 in full payment of invoices #KP-6621 and KP-6808, taking into account
1% purchase discount of $65 for early payment.
Payment Cheque #1023
Dated April 5, 2022
To Kanine Kibble, $290 USD in full payment of invoice #KK-402. The exchange rate is 1.030. Paid from
Bank: USD Chequing Account.
Sales Quote #45
Dated April 6, 2022
Delivery Date April 15, 2022
To Show Off Dogs (preparation for dog show)
10 Shampoos $22 each
10 Clippings – large dog 90 each
HST Charged 13%
Terms: 2/10, net 30.
Cash Sales Invoice #1121
Dated April 6, 2022
To Doggie Day Care (Use Quick Add for new Regular customer)
10 5kg bags Holistic Puppy Chow
$20
each
20 10kg bags Holistic Regular Chow
28
each
5 10kg bags Holistic Mature Dog Chow45
each
Sales Discount for regular volume purchase
15%
HST Charged 13%
Invoice total $946.09 paid by cheque #4222.
Store as recurring weekly entry.
Memo #1
Dated April 6, 2022
Show Off Dogs has accepted the sales quote and is placing an order. Convert Sales Quote #45 to Sales
Order #45 using the same shipping date.
Cash Receipt #1523
Dated April 7, 2022
From Show Off Dogs, cheque #288 for $500 as deposit #36 to accept sales order #45.
Deposit Slip #14
Dated April 7, 2022
Deposit three cheques received in the past week. Total deposit is $2 896.09. Deposit to the Bank: CAD
Chequing account.
Copyright © 2019 Pearson Canada Inc.
Page 2 of 7
0520/G2/AC214/DAY9
MAJOR PROJECT
AC214 – SAGE 50 ACCOUNTING 2018
TO TEACH
TO GUIDE
TO LEARN
WOOFIE’S
April 8, 2022
Invoice #1122
Bill To
Customer
Nikki Chow
Address
55 Wagstail Boulevard
London, Ontario N8P 7D3
Phone
(519)762-6712
Division
Sales
Payment Terms
2/10 , net 30
Qty.
Description
2
Saint Bernards
5
5kg bags Holistic Puppy Chow
2
Wooden Dog House Kits
Unit Price
Line Total
$1,450
$2,900
20
100
550
1,100.00
Subtotal
4,100
Sales Tax
533
Total
$4,633
Thank you for your business!
WOOFIE’S
460 Barque Street
London, Ontario N9L 4B6
Memo #2
Dated April 8, 2022
Pay hourly employee, Bobbi Bowser for 35 hours regular work.
Include $200 advance, which will be repaid at the rate of $50 over each of the next four pay periods.
Bowser should be paid for grooming 6 dogs (No. Dogs piece rate pay).
Issue direct deposit slip #34. Hint: Use Payroll Run & ignore warnings.
Copyright © 2019 Pearson Canada Inc.
Page 3 of 7
0520/G2/AC214/DAY9
MAJOR PROJECT
AC214 – SAGE 50 ACCOUNTING 2018
TO TEACH
2.
TO GUIDE
TO LEARN
Back up the data files. Continue with the file WOOFIE.SAI.
Change the session date to April 15, 2022. Enter the following transactions:
KENNELWORTH POUND
April 11, 2022
Invoice KP-7222
Bill To
Customer
WOOFIE’S
Address
440 Rover Circle
St. Mary, Ontario N8T 7F3
Phone
(519) 774-7109
Purchase Order
# 1001
Payment Terms
1/10 net 30
Qty.
4
Description
Unit Price
Samoyed dogs
Line Total
$450
$1,800
Freight Charge
100
Subtotal
1,900
HST Paid
247
Total
$2,147
Thank you for your business
Copyright © 2019 Pearson Canada Inc.
Page 4 of 7
0520/G2/AC214/DAY9
MAJOR PROJECT
AC214 – SAGE 50 ACCOUNTING 2018
TO TEACH
TO GUIDE
TO LEARN
Memo #3
Dated April 11, 2022
WOOFIE’S will offer a package deal to the first five customers purchasing a Samoyed and Wooden Dog
House Kit. They will also receive free assembly of the dog house, two coupons for free shampoos , and a
supply of dog food. The regular price of this $1 600 offer is over $1 950. To prepare for this special offer:
(a) Create new inventory item:
104 Promotional Spring Special
Minimum level: 0
Regular and Pref erred Selling Price: $1 600 CAD each
Create new Group accounts 1450 Promotions 4030 Revenue from Promotions
Asset: 1450
Revenue: 4030
C.O.G.S.: 5060
Taxes: not exempt for HST
(b) Enter the inventory item assembly as follows:
Assembly Components
5 Samoyed @ $ 437.50 each
5 Wooden Dog House Kits @ $255.00 each
10 10kg bags Holistic Regular Chow @ $10.45 each
Additional Costs $500 (labour for assembly and shampoos)
Assembled Items
5 Promotional Spring Specials @ $4 067.00 total ($813.40 each)
Cash Receipt #1524 Dated April 11, 2022
From Nikki Chow, cheque #189 for $4 540.34 in payment of invoice #1122, taking into account 2% sales
discount of $92.66 for early payment.
Sales Invoice #1123 Dated April 12, 2022
To Show Off Dogs (preparation for dog show), to fill Sales Order #45
10 Shampoos
$22 each
10 Clippings – large dog 90 each
HST Charged
13%
Terms: 2/10, net 30
Invoice total: $1265.60
Cash Sales Invoice #1124
Dated April 13, 2022
Recall stored entry.
To Doggie Day Care
10 5kg bags Holistic Puppy Chow
20 10kg bags Holistic Regular Chow
5 10kg bags Holistic Mature Dog Chow
Sales Discount for regular volume purchase
HST Charged
Invoice total $946.09 paid by cheque #4355.
Copyright © 2019 Pearson Canada Inc.
$20 each
28 each
45 each
15%
13%
Page 5 of 7
0520/G2/AC214/DAY9
MAJOR PROJECT
AC214 – SAGE 50 ACCOUNTING 2018
TO TEACH
TO GUIDE
TO LEARN
Credit Card Sales Invoice #1125
Dated April 15, 2022
To Collee Schnauzer (Use Full Add for new Regular customer, Terms: net 1, Tax Code: H)
2 Promotional Spring Specials $1 600 each
(Including 4 coupons for shampoo
and f ree dog house assembly)
HST Charged 13%
Invoice total $3 616 paid by SpendMore. There is no discount on the promotional offer.
Memo #4
Dated April 15, 2022
Inventory stock of dog food required to feed dogs for sale in store. Complete an inventory adjustment to
decrease the inventory for the following items:
5 5kg bags Holistic Puppy Chow
10 10kg bags Holistic Regular Chow
Use account 1280 Food Supplies instead of the default Adjustment Write-off account.
Deposit Slip #15
Dated April 15, 2022
Deposit two cheques received in the past week. Total deposit $5 486.43. Deposit to the Bank: CAD
Chequing account.
Memo #5
Dated April 15, 2022
Transf er $5 000 f rom Bank: Credit Card to Bank: CAD Chequing Account.
Bank Credit Memo #PLCU-4433
Dated April 15, 2022
From Pet Lovers Credit Union, approval of $5 000 bank loan at 6% interest per annum. Amount
deposited to CAD Chequing bank account.
Memo #6
Dated April 15, 2022
Prepare the Sales by Salespersons Detail Report, to check that all sales are included for Feline. Look up
all sales invoices and adjust them to add Feline as the salesperson if necessary. Calculate 1% of the
total sales and document to be added to Kitty’s next pay period.
Memo #7
Dated April 15, 2022
Pay hourly employee, Bobbi Bowser for 35 hours regular work. Recover $50 advance.
Bowser took one day sick leave during the week. (Allow the net days accrued to be negative.)
Bowser should be paid for grooming 5 dogs (No. Dogs piece rate pay).
Issue deposit slip #35.
Memo #8
Dated April 15, 2022
Pay salaried employee, Kitty Feline $2 250 her regular bi-monthly salary.
Calculate and include sales commission (1%) for Feline.
Feline took two days vacation during the pay period.
Issue deposit slip #36.
Cheque Purchase Invoice #PVS-445 Dated April 15, 2022
From Pooch Veterinary Services, $600, plus $78 HST, for vaccination and health checkups for all new
dogs. Invoice total $678 paid by cheque #503.
Memo #9
Dated April 15, 2022
Make payroll tax remittance to the Receiver General for the pay periods ending April 15, 2022. Include
remittance for income tax, EI, and CPP. Issue cheque #504.
Copyright © 2019 Pearson Canada Inc.
Page 6 of 7
0520/G2/AC214/DAY9
MAJOR PROJECT
AC214 – SAGE 50 ACCOUNTING 2018
TO TEACH
3.
TO GUIDE
TO LEARN
Bank reconciliation:
Set up account 1080 f or account reconciliation.
Use the f ollowing linked accounts. Create new accounts if necessary.
Income: Interest 4280 Revenue from Interest
Expense1: Bank Charges 5010 Bank & Credit Card Fees
Expense2: NSF fee 5010 Bank & Credit Card Fees
Adjustment: 5005 Reconciliation Adjustments
Reconcile the account using April 1 as statement start date and April 15 as the statement end date and
the reconciliation date.
There are two outstanding prior transactions:
Source
Description
Date
Amount
13
Deposit slip
Mar 25
Deposit $4 600
500
Kennelworth Pound
Mar 30
Payment $2 700
(Hint: af ter adding the first outstanding transaction, click Insert Outstanding again to access a new
transaction line.)
Use the f ollowing bank statement details to complete the reconciliation.
Mar. 15
Mar. 25
Mar. 30
Apr. 1
Apr. 1
Apr. 4
Apr. 4
Apr. 8
Apr. 8
Apr. 15
Apr. 15
Apr. 15
Apr. 15
Apr. 15
Apr. 15
withdrawals
Balance forward
Deposit
Cheque 500
2 700.00
Interest on account
Service f ee
15.00
Cheque 501
1 582.00
Cheque 502
3 435.00
Deposit 14
Payroll transf er Ref #34
625.93
Deposit 15
Credit memo
Transf er f rom 02333-88899
Payroll transf er Ref #35
427.05
Payroll transf er Ref #36
1781.92
Closing Balance
deposits
balance
22 389.00
4 600.00
22.00
2 896.09
5 486.43
5 000.00
5 000.00
34 826.62
Note: if the unresolved when done is not cleared to zero and if amount it is out is due to any of the
payroll entries, go ahead and process with a balance in the unresolved. Your payroll entries will be
evaluated for their accuracy at the source.
4.
Print the following reports and hand them in to your instructor for grading:
Journal Entries for all journals from April 1 to April 15, 2022
Show, f oreign currency amounts and additional information.
Balance Sheet at April 15, 2022
Income Statement from April 1 to April 15, 2022
Employee Summary
Copyright © 2019 Pearson Canada Inc.
Page 7 of 7
0520/G2/AC214/DAY9

Purchase answer to see full
attachment

Tags:
Dog Food

sales of large purebred and pedigreed dogs

Kanine Kibble

caring for the animals

Discount allowed

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.