July 2018 Financial Transaction Analysis for Stratford Country Inn

Verified

Added on 2023/06/14

AI Summary

This document presents a detailed transaction analysis for Stratford Country Inn covering the period from July 1, 2018, to July 31, 2018. It includes a comprehensive listing of debits and credits across various accounts, reflecting the inn's diverse financial activities. The transactions encompass revenue from books, inn stays, dining room services, and tours, as well as expenses related to linens, maintenance, food inventory, laundry services, vehicle expenses, and utilities. Payroll transactions for employees like Hedy Horatio, Juliet Jones, Mary MacBeth, Bud Romeo and Shelley Shylock are detailed, including wages, EI, CPP, WSIB contributions, and income tax deductions. Additional transactions involve payments to suppliers such as Bard's Linen & Towel and Tempest Food Wholesalers, along with entries for GST, prepaid sales, insurance, advertising, and depreciation. The analysis provides a thorough overview of the financial operations during the specified period.

Contribute Materials

Your contribution can guide someone’s learning journey. Share your documents today.

Page 1
Stratford Country Inn
All Transactions 07/01/2018 to 07/31/2018
Account Number Account Description Debits Credits
07/01/2018 J1 BLT-64, Bard's Linen & Towel
1530 Linens & Towels 1,300.00 -
1540 Blankets & Beddings 700.00 -
2315 GST Paid on Purchases 260.00 -
2100 Accounts Payable - 2,260.00
07/01/2018 J2 AM-148, Avon Maintenance Services
2315 GST Paid on Purchases 130.00 -
5720 Maintenance & Repairs 1,000.00 -
2100 Accounts Payable - 1,130.00
07/05/2018 J3 701, Avon Maintenance Services
2100 Accounts Payable 2,260.00 -
1010 Bank: Stratford Trust CAD Che... - 2,260.00
07/06/2018 J4 701, Hamlet Holiday Agency
1200 Accounts Receivable 8,745.00 -
5020 Cost of Books Sold 350.00 -
1585 Books - 350.00
2310 GST Charged on Sales - 965.00
4020 Revenue from Books - 580.00
4030 Revenue from Inn - 4,600.00
4040 Revenue from Dinning Room - 2,100.00
4200 Revenue from Tours - 500.00
07/06/2018 J5 55, Waterloo University Literary Club: Booking Rooms in Inn
1010 Bank: Stratford Trust CAD Cheq... 1,000.00 -
2460 Prepaid Sales & Deposits - 1,000.00
07/07/2018 J6 702, Tavistock Laundry Services
2100 Accounts Payable 1,808.00 -
1010 Bank: Stratford Trust CAD Che... - 1,808.00
07/07/2018 J7 Stratford, 702, <One-time customer>
1030 Bank: Credit Card 9,573.68 -
5020 Cost of Books Sold 400.00 -
5625 Bank Charges & Card Fees 270.72 -
1585 Books - 400.00
2310 GST Charged on Sales - 1,084.40
4020 Revenue from Books - 680.00
4030 Revenue from Inn - 6,200.00
4040 Revenue from Dinning Room - 880.00
4200 Revenue from Tours - 1,000.00
07/08/2018 J10 TF-284, Tempest Food Wholesalers
1520 Food Inventory 2,000.00 -
2100 Accounts Payable - 2,000.00
07/08/2018 J11 TL-798, Tavistock Laundry Services
2315 GST Paid on Purchases 104.00 -
5030 Cost of Services 800.00 -
2100 Accounts Payable - 904.00
07/09/2018 J12 703, Tempest Food Wholesalers
2100 Accounts Payable 4,000.00 -
1010 Bank: Stratford Trust CAD Che... - 4,000.00
07/10/2018 J13 56, Hamlet Holiday Agency
1010 Bank: Stratford Trust CAD Cheq... 7,745.00 -
1200 Accounts Receivable - 7,745.00
07/10/2018 J14 704, Bard's Linen & Towel
2100 Accounts Payable 2,260.00 -
1010 Bank: Stratford Trust CAD Che... - 2,214.80
5240 Purchase Discounts - 45.20
Printed On: 04/10/2018

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.

Page 2
Stratford Country Inn
All Transactions 07/01/2018 to 07/31/2018
Account Number Account Description Debits Credits
07/11/2018 J15 Stratford, 1143, Stratford Service Centre
2315 GST Paid on Purchases 20.80 -
5750 Vehicle Expenses 160.00 -
2140 Credit Card Payable - 180.80
07/12/2018 J24 705, Receiver General of Canada
2310 GST Charged on Sales 2,380.00 -
1010 Bank: Stratford Trust CAD Che... - 2,380.00
07/12/2018 J26 706, Receiver General of Canada
2100 Accounts Payable 18,599.00 -
1010 Bank: Stratford Trust CAD Che... - 18,599.00
07/13/2018 J27 703, Waterloo University Literary Club
1200 Accounts Receivable 10,508.40 -
5020 Cost of Books Sold 175.00 -
1585 Books - 175.00
2310 GST Charged on Sales - 1,188.40
4020 Revenue from Books - 290.00
4030 Revenue from Inn - 7,200.00
4040 Revenue from Dinning Room - 1,330.00
4200 Revenue from Tours - 500.00
07/14/2018 J28 Stratford, 704, <One-time customer>
1030 Bank: Credit Card 8,309.04 -
5020 Cost of Books Sold 325.00 -
5625 Bank Charges & Card Fees 234.96 -
1585 Books - 325.00
2310 GST Charged on Sales - 944.00
4020 Revenue from Books - 550.00
4030 Revenue from Inn - 3,450.00
4040 Revenue from Dinning Room - 3,100.00
4200 Revenue from Tours - 500.00
07/14/2018 J29 707, Hedy Horatio
5412 Wages: Dinning Room 1,356.80 -
5420 EI Expense 29.20 -
5430 CPP Expense 56.70 -
5440 WSIB Expense 21.76 -
1010 Bank: Stratford Trust CAD Che... - 911.20
1220 Advane & Loans Receivables - 100.00
2170 Vacation payable - 76.80
2180 EI Payable - 50.06
2185 CPP Payable - 113.40
2190 Federal Income Tax Payable - 176.24
2230 WSIB Payable - 21.76
2240 Group Insurance Payable - 15.00
07/14/2018 J30 708, Juliet Jones
5411 Wages: General 1,865.60 -
5420 EI Expense 40.17 -
5430 CPP Expense 80.46 -
5440 WSIB Expense 44.88 -
1010 Bank: Stratford Trust CAD Che... - 1,540.99
2170 Vacation payable - 105.60
2180 EI Payable - 68.86
2185 CPP Payable - 160.92
2190 Federal Income Tax Payable - 79.86
2230 WSIB Payable - 44.88
2240 Group Insurance Payable - 30.00
07/14/2018 J31 709, Mary MacBeth
5412 Wages: Dinning Room 2,111.52 -
5420 EI Expense 43.82 -
5430 CPP Expense 88.38 -
5440 WSIB Expense 33.86 -
Printed On: 04/10/2018

Page 3
Stratford Country Inn
All Transactions 07/01/2018 to 07/31/2018
Account Number Account Description Debits Credits
1010 Bank: Stratford Trust CAD Che... - 1,624.99
2170 Vacation payable - 119.52
2180 EI Payable - 75.12
2185 CPP Payable - 176.76
2190 Federal Income Tax Payable - 217.33
2230 WSIB Payable - 33.86
2240 Group Insurance Payable - 30.00
07/14/2018 J32 710, Bud Romeo
5411 Wages: General 1,583.64 -
5420 EI Expense 32.86 -
5430 CPP Expense 64.62 -
5440 WSIB Expense 38.10 -
1010 Bank: Stratford Trust CAD Che... - 1,115.13
1220 Advane & Loans Receivables - 150.00
2170 Vacation payable - 89.64
2180 EI Payable - 56.33
2185 CPP Payable - 129.24
2190 Federal Income Tax Payable - 110.78
2230 WSIB Payable - 38.10
2240 Group Insurance Payable - 30.00
07/14/2018 J33 711, Shelley Shylock
5412 Wages: Dinning Room 1,231.72 -
5420 EI Expense 25.56 -
5430 CPP Expense 48.78 -
5440 WSIB Expense 19.75 -
1010 Bank: Stratford Trust CAD Che... - 995.09
2170 Vacation payable - 69.72
2180 EI Payable - 43.82
2185 CPP Payable - 97.56
2190 Federal Income Tax Payable - 84.87
2230 WSIB Payable - 19.75
2240 Group Insurance Payable - 15.00
07/15/2018 J34 AM-184, Avon Maintenance Services
2315 GST Paid on Purchases 143.00 -
5720 Maintenance & Repairs 1,100.00 -
2100 Accounts Payable - 1,243.00
07/17/2018 J35 57, Waterloo University Literary Club
1010 Bank: Stratford Trust CAD Cheq... 9,508.40 -
2460 Prepaid Sales & Deposits 1,000.00 -
1200 Accounts Receivable - 10,508.40
07/18/2018 J36 712, Hartford Insurance Group
1330 Prepaid Insurance 2,592.00 -
1010 Bank: Stratford Trust CAD Che... - 2,592.00
07/18/2018 J37 37232, Perth County Hydro
2315 GST Paid on Purchases 52.00 -
5700 Hydro Expenses 400.00 -
2100 Accounts Payable - 452.00
07/18/2018 J38 713, Perth County Hydro
2100 Accounts Payable 452.00 -
1010 Bank: Stratford Trust CAD Che... - 452.00
07/18/2018 J39 BC-66431, Bell Canada
2315 GST Paid on Purchases 41.60 -
5740 Telephone Expenses 320.00 -
2100 Accounts Payable - 361.60
07/20/2018 J40 705, NY Freinds of Shakespeare
1200 Accounts Receivable 8,215.28 -
5020 Cost of Books Sold 200.00 -
Printed On: 04/10/2018

Page 4
Stratford Country Inn
All Transactions 07/01/2018 to 07/31/2018
Account Number Account Description Debits Credits
1585 Books - 200.00
2310 GST Charged on Sales - 921.23
4020 Revenue from Books - 337.50
4030 Revenue from Inn - 4,961.25
4040 Revenue from Dinning Room - 1,522.80
4200 Revenue from Tours - 472.50
07/20/2018 J41 58, Festive Club of Rosedales: Booking rooms in inn
1010 Bank: Stratford Trust CAD Cheq... 1,000.00 -
2460 Prepaid Sales & Deposits - 1,000.00
07/21/2018 J42 715, Stratford
2140 Credit Card Payable 575.80 -
1010 Bank: Stratford Trust CAD Che... - 575.80
07/21/2018 J43 Stratford, 706, <One-time customer>
1030 Bank: Credit Card 7,846.03 -
5020 Cost of Books Sold 425.00 -
5625 Bank Charges & Card Fees 221.87 -
1585 Books - 425.00
2310 GST Charged on Sales - 877.90
4020 Revenue from Books - 710.00
4030 Revenue from Inn - 4,200.00
4040 Revenue from Dinning Room - 1,780.00
4200 Revenue from Tours - 500.00
07/22/2018 J44 TF-344, Tempest Food Wholesalers
1520 Food Inventory 2,000.00 -
2100 Accounts Payable - 2,000.00
07/22/2018 J45 TL-841, Tavistock Laundry Services
2315 GST Paid on Purchases 110.50 -
5030 Cost of Services 850.00 -
2100 Accounts Payable - 960.50
07/23/2018 J46 716, ZA-6998, Zephyr Advetising Agency
2315 GST Paid on Purchases 39.00 -
5615 Advertising & Promotions 300.00 -
1010 Bank: Stratford Trust CAD Che... - 339.00
07/24/2018 J47 59, NY Freinds of Shakespeare
1020 Bank: Stratford Trust USD Cheq... 8,099.65 -
4470 Exchange Rate Differences 115.63 -
1200 Accounts Receivable - 8,215.28
07/25/2018 J48 Stratford, 1207, Stratford Service Centre
2315 GST Paid on Purchases 78.00 -
5750 Vehicle Expenses 600.00 -
2140 Credit Card Payable - 678.00
07/26/2018 J49 707, Metro Arts Appreciation Group
1200 Accounts Receivable 8,008.35 -
5020 Cost of Books Sold 275.00 -
1585 Books - 275.00
2310 GST Charged on Sales - 893.35
4020 Revenue from Books - 395.00
4030 Revenue from Inn - 4,980.00
4040 Revenue from Dinning Room - 1,290.00
4200 Revenue from Tours - 450.00
07/28/2018 J50 717, Hedy Horatio
5412 Wages: Dinning Room 1,407.68 -
5420 EI Expense 29.20 -
5430 CPP Expense 56.70 -
5440 WSIB Expense 22.58 -
1010 Bank: Stratford Trust CAD Che... - 1,059.20
Printed On: 04/10/2018

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.

Page 5
Stratford Country Inn
All Transactions 07/01/2018 to 07/31/2018
Account Number Account Description Debits Credits
2170 Vacation payable - 79.68
2180 EI Payable - 50.06
2185 CPP Payable - 113.40
2190 Federal Income Tax Payable - 176.24
2230 WSIB Payable - 22.58
2240 Group Insurance Payable - 15.00
07/28/2018 J51 718, Juliet Jones
5411 Wages: General 1,912.24 -
5420 EI Expense 40.17 -
5430 CPP Expense 80.46 -
5440 WSIB Expense 46.01 -
1010 Bank: Stratford Trust CAD Che... - 1,584.99
2170 Vacation payable - 108.24
2180 EI Payable - 68.86
2185 CPP Payable - 160.92
2190 Federal Income Tax Payable - 79.86
2230 WSIB Payable - 46.01
2240 Group Insurance Payable - 30.00
07/28/2018 J52 719, Mary MacBeth
5412 Wages: Dinning Room 2,035.20 -
5420 EI Expense 43.82 -
5430 CPP Expense 88.38 -
5440 WSIB Expense 32.64 -
1010 Bank: Stratford Trust CAD Che... - 1,552.99
2170 Vacation payable - 115.20
2180 EI Payable - 75.12
2185 CPP Payable - 176.76
2190 Federal Income Tax Payable - 217.33
2230 WSIB Payable - 32.64
2240 Group Insurance Payable - 30.00
07/28/2018 J53 720, Bud Romeo
5411 Wages: General 1,526.40 -
5420 EI Expense 32.86 -
5430 CPP Expense 64.62 -
5440 WSIB Expense 36.72 -
1010 Bank: Stratford Trust CAD Che... - 1,211.13
2170 Vacation payable - 86.40
2180 EI Payable - 56.33
2185 CPP Payable - 129.24
2190 Federal Income Tax Payable - 110.78
2230 WSIB Payable - 36.72
2240 Group Insurance Payable - 30.00
07/28/2018 J54 721, Shelley Shylock
5412 Wages: Dinning Room 1,231.72 -
5420 EI Expense 25.56 -
5430 CPP Expense 48.78 -
5440 WSIB Expense 19.75 -
1010 Bank: Stratford Trust CAD Che... - 995.09
2170 Vacation payable - 69.72
2180 EI Payable - 43.82
2185 CPP Payable - 97.56
2190 Federal Income Tax Payable - 84.87
2230 WSIB Payable - 19.75
2240 Group Insurance Payable - 15.00
07/28/2018 J55 Stratford, 708, <One-time customer>
1030 Bank: Credit Card 8,982.01 -
5020 Cost of Books Sold 550.00 -
5625 Bank Charges & Card Fees 253.99 -
1585 Books - 550.00
2310 GST Charged on Sales - 996.00
4020 Revenue from Books - 940.00
Printed On: 04/10/2018

Page 6
Stratford Country Inn
All Transactions 07/01/2018 to 07/31/2018
Account Number Account Description Debits Credits
4030 Revenue from Inn - 3,850.00
4040 Revenue from Dinning Room - 2,450.00
4200 Revenue from Tours - 1,000.00
07/30/2018 J56 709, Festive Club of Rosedales
1200 Accounts Receivable 10,866.00 -
5020 Cost of Books Sold 200.00 -
1585 Books - 200.00
2310 GST Charged on Sales - 1,226.00
4020 Revenue from Books - 340.00
4030 Revenue from Inn - 6,000.00
4040 Revenue from Dinning Room - 2,800.00
4200 Revenue from Tours - 500.00
07/31/2018 J57 60, Hamlet Holiday Agency
1010 Bank: Stratford Trust CAD Cheq... 1,000.00 -
2460 Prepaid Sales & Deposits - 1,000.00
07/31/2018 J58 FundsTransfer,
1010 Bank: Stratford Trust CAD Cheq... 40,000.00 -
1030 Bank: Credit Card - 40,000.00
07/31/2018 J59 FundsTransfer,
1010 Bank: Stratford Trust CAD Cheq... 7,944.00 -
1020 Bank: Stratford Trust USD Che... - 7,944.00
07/31/2018 J60 723, Owen Othello
5410 Wages: Management 4,454.00 -
5420 EI Expense 91.28 -
5430 CPP Expense 183.56 -
5440 WSIB Expense 113.58 -
1010 Bank: Stratford Trust CAD Che... - 3,649.42
2180 EI Payable - 156.48
2185 CPP Payable - 367.12
2190 Federal Income Tax Payable - 525.82
2230 WSIB Payable - 113.58
2240 Group Insurance Payable - 30.00
07/31/2018 J61 722, Clara Claudius
5411 Wages: General 3,200.00 -
5420 EI Expense 73.02 -
5430 CPP Expense 143.96 -
5440 WSIB Expense 81.60 -
1010 Bank: Stratford Trust CAD Che... - 2,690.44
2180 EI Payable - 125.18
2185 CPP Payable - 287.92
2190 Federal Income Tax Payable - 253.44
2230 WSIB Payable - 81.60
2240 Group Insurance Payable - 60.00
07/31/2018 J62 1,
5870 Insurance 216.00 -
1330 Prepaid Insurance - 216.00
07/31/2018 J63 2,
5615 Advertising & Promotions 50.00 -
1320 Prepaid Advertising - 50.00
07/31/2018 J64 3,
5693 Depeciation: Inn & Dinning Room 600.00 -
5691 Deprciation: Furn & Fix 600.00 -
5690 Depreciation: Computers 200.00 -
5692 Depreciation: Vehicle 800.00 -
1825 Accum Deprec: Computers - 200.00
1845 Accum Deprec: Furniture & Fixt... - 600.00
1890 Accum Deprec: Inn & Dinning R... - 600.00
Printed On: 04/10/2018

Page 7
Stratford Country Inn
All Transactions 07/01/2018 to 07/31/2018
Account Number Account Description Debits Credits
1865 Accum Deprec: Vehicle - 800.00
07/31/2018 J65 5,
5040 COGS: Food 4,255.00 -
1520 Food Inventory - 4,255.00
242,445.38 242,445.38
Printed On: 04/10/2018

1 out of 7