Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are employed by Victorias Pet Shop Inc. a company specializing in sale of products and care for home pets. Read carefully each transaction Post
You are employed by Victorias Pet Shop Inc. a company specializing in sale of products and care for home pets.
- Read carefully each transaction
- Post accordingly to the appropriate journal: sales, purchases, cash receipts or disbursements in the appropriate Excel file.
- Post the transactions to the General Ledger
- Use the excel file: acct2generalledgerspeadsheet_V. name this file acct2exercise3generalledgerspreadsheet_yourname
- Post Customers transactions to Customers auxiliary General Ledger.
- Post the Suppliers transactions to the Suppliers Auxiliary General Ledger
- Draw up the Trial Balance as of October 31st 2019
- Complete the spreadsheet as of October 31st 2019 (Income statement and Balance sheet)
TRANSACTIONS:
- October1st 2019: The owner Mrs Infantino invests $20 000.00 to open the company.
- October 1st: Purchase on credit of Office furniture at Bureau en Gros, invoice no. 14 Amount $5 600.00 plus taxes, Linear amortization, residual value $1 000.00 for 5 years, 2/15, n/30
- October 1st: Cash purchase of office supplies at Dollar Store, invoice no. 5 Amount $ 250.00 plus taxes.
- October 1st: Purchase on credit of stock of merchandise at supplier Pet supplies Inc. Amount before taxes $2 000.00, invoice no. 45, terms of payment: 3/10, n/30.
- October 2nd: Cash purchase of stock of merchandise at supplier ABC Enr. Amount before taxes is $500.00, invoice no 98.
- October 3rd: Bank of Montreal loan of $10 000.00 to purchase a delivery vehicle for the Victorias Pet Shop. Linear amortization, residual value
$2 000.00, for 6 years
- October 6th: Credit sale of product to customer Sierras and Friends, invoice no 1. Amount before taxes of $5 000.00, 3/15, n/30
- October 7th: Cash sale of services to customer Mrs Leblanc, invoice no. 2 Amount before taxes $55.00
- October 8th: Recording Bell Canada invoice of month, $160.00 before tax, n/30
- October 8th: Recording Hydro Quebec invoice of month, $200.00 before tax, n/30
- October 9th: Received check of customer Sierras and Friends: pays invoice no. 1 taking the discount allowed.
- October 10th: Prepare the checks to pay Hydro Quebec and Bell Canada invoices of the month. Check no 2 and check no 3
- October 10th: Prepare the check to pay supplier Pet Supplies Inc. take the discount allowed. Check no 4
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started