project ques

D Ally & Al's Chiropractic & Massage You Hurt - We Fix! Westdale Plaza - Orangeville, ON - Tel #519-555-2315 The Franklins' met in medical school, Albert studying RMT and Ally (short for Allyson) became a Chiropractor. After the pair both graduated and completed work in different cities and towns, Ally & Al decided to marry and settle in Orangeville, Ontario to set up a dual practice, Using some of the money they saved and using loans, they opened up a storefront at the Westdate Plaza, at Westdale Ave. & Birch St. They have 2 employees, an M.O.A./Receptionist and a cleaner. The employees are paid through a payroll company. They are sent an invoice twice per month. The Franklins also sell some contour memory foam pillows and non-medicinal supplements. Because the Franklins earn more than $30,000 per year, as per federal regulations, they are required to have an HST number and charge HST on non chiropractic related items and services (massages & table rent). They are also able to claim the HST paid on certain items/expenses. They rent table space to a Masseuse and a Chiropractor Notes Inventory - March 31/2020 Foam Contour Pillows - FCP-01 - Purchased and sold in pairs. Sold for $75 /pale. Cost is $24 each pair. - 4 pairs in stock value of $96 at cost. Non-medicinal Supplements (not considered a grocery item -subject to HST) - NMirS-02 -Case of 48 Bottles - 56/ bottle. They sell for $22/ bottle in singles - 28 in stock at a value of $168 at cost. RENT of Beds for other service providers P. Doleman pays rent for a Massage Bed - $1750/mo + HST F. Sanjeed pays rent for Chiropractic Bed - $1500/mo. +HST All Documents (cheques, invoices, etc.) are to be considered printed at the time of input Be sure to review all items and services, costs, and fees for price changes to be input to the system. triOS/ Eastern trios version July 2021 9:18 al A Qe Ally & Al's Chiropractic & Massage You Hurt - We Fix! Westdal Plaza - Orangevile, ON-Tel #5195552315 The Franklin' met in medical school, Albert studying and Alyshorter on became Chiropracter the pair bound and completed word in die sand decided to marry and teleradie, Ontario tertion Using one of the money they saved and using the speed up in the Wel, A & Bicht They have employees, as MOA Meceptionisandale Theme company. They are sent an indice twice per month. The Frais ao salone con pillows and non-medicinal upplement Because the Franklin eam nore than 50.000 per year, apertadecal regulation theorette have an Sumber and change HST on non chiropracteated as a servis sages rent. They are able to claim the paid on tantum They rent table space to Master and Chiropractor vetery - March 12 Foan Contour Plows-FCP-41 - Purchased and sold in pairs Soffor 575 / Costa Duis in stock value of tot Non medicinal Supplements not considered a grocery tem-jet e NAS-02- Bottes-56/bottle. They will for 22/bottle in inglese com INT Salon rent for a speed-$175/ Sent for Chiropractic bed-1500/mo.it Al Documents chequr, mice etc.) are to be considered printed at the time oinput Be sure to view item and service, costs, and tres for price changes to be input to the Patients & Receive Massages cout 05 (HST) per hour and Core Services Emese per We-Cath receipts-Pay cash chaque ar Credit card upon Bam diction de reden Outstanding we Barn Out Hockey Club-24/2 ds. et 5 days-Outandine 118 5400.00 - 22.000 Other patients foustomers may be added to the customers. All and Supplements are to be added to the customer list All held for deposit fundeposited funds and are deposited to the Bank of Regina South Potty Cashe kept $180 starting with first deposit this month and updated the next week AB Credit Card Interact receipts go to the Regina Credit Card Interactant Preferences - Accounting uchwarni transactions are 30 days in the par 9:18 & Payables Best-1X/Net.cat Rent-$94.00/mom ST Due Iday of every month CP Compass -15/5 Net 10 outstanding Supplemental Health Co-Bronco-none cutting Draveits-Hydro & Water Metoda Bater Communication et 30 day-I-IST) Trote there is an ime with these last two windor the bistroma rotterdam overdue. You will see that you have to write cheques to these centers for March the addre accounts payable Employees & Payroll Mille Barnes - Motion 20/max 30 hrs per a period wie- para service te b-Cleane/ Mantenance - $15 as the period-pedie para service treployees are paid through power than for the service fee plus 5T) the Stars prior to pay day Alyan take northy Drawings of S2250 each. Pod by Chequest mothes. II Ae Card 11 Asari www Prep) cutbread Avertising Spot 100-200 13 1400ory Total Centro 00 Tape Comment 1700-Computer met e com 180 cm The owned www.com The Tree Orice Front WT Ate. Der One Barone SHOP Bar 3000 C 10 Dreng 100 TR49880 Wage For come 100 at Wert Chry Strong Promotion 20 Automat ases con 81300 ser Payroll Service Sage Power ready Tepende ET Depreciation TOTAL 9:18 April 2020 Entries to be completed 2 E Q $270.00 Cheque 27 Pay Rent - memorie for future April 2070 Rent $5.000.00 HST 8.99 Total Due $6.328.00 502 Carch Resepte wat in quick adid-Lindegosted Funds 12 Messages 10 $3.360.00 42 Chiropractic A4598 HST on Messages OBS Total 56.526.00 503 Receive Payment-Cheque 123 on X318-Undepstad funds The Bum Owls Hockey Cubertal payment on account 2800.00 504 Sales order 26- Patient order The Rounders Speed Skating Team-5m3 Chigre For April 10 Msages were given for $35. Chiropractor 560 Check Tax codes. Totatorder=5716.75 SOS hor 2020 Depostal Cash and Chest lank-hole $150 cash for Cathru tebe-0- Petty Cash is a bascut Nerdesi 59.11080 505 Write cheque #28 Payroll invoice for mid-month to Payroll Plus quick add vendor A/2000 Wag MOA/Reception Bohus 520 Groups Employer Benefit/ $1.73845 Wag leaner in het Gross sployer Benefits 5.170.21 Service Charges - Wape Press) $ 23:15 Stan Vice TotalPayabile 53.372.12 SD 7 Salesetem 13-Cash refund to walk in istomer domeny Cash 1 skar-CP-Contour Foan low-notcome-50.00 Customer Wanda Ar SD3 Invoice 32 ts Routers Speed Skating Team - 2/0 et 30 SM $47.00 3 Chiropractic An 5180.00 IST on 2018 $71675 100 SD 9 Wakin Customer for the week-Cash Receita 15-to undeposited fundet 15 Massages 510% v $2,675.00 46 Chiropractic Adjustments 565 $2.990.00 Sen Massage 02273 57.1425 SD 10 Ray Bat - Medical Linen Suple-29 Payale 2789 $77.70 A100 5011 Canh Recep16 - Sir Ray Skossa - Quick Ade Paid Interact 14/2020 To undeposited Fundal FCPF. 2NSO Nen Dot Media SS1440 9:19 E Q 20 deposited Fundi FCP Foam Contour 2 NMS-02 Non Bottles Medicinal Supplements 54.00 ST 15:42 Tonal 513447 5012 wme Re-Orangeville-Overde Roma Cheque 0 $5815 Inot entered previously 200 A 1200 S013 Wres Communicationsx0067437239-Overder From March 14/2020 Cheques $22.12. notre pre S014 Deposit Cash & Cheon/Credit Card Inter Debrecen transfer funds so topup Petty Cash From refund transaction Netdepot Stank Net Deposit Credit Card $1844 SOUS Ongeville Uties term Neto days Hydro Service $37800 Water $250.00 HST Total Due $7564 5036 ONTHS637 Hopen One Acet5522342-Net 30 day 2 Celles $198.00 Internet Service $18.00 Cable Pack $45.00 HST Total 52016 5017 76 Supplement Heath Cowthe cheque 12 4a bottles cases Non medicinal solener $28.00 ST 2 Due on Recent $325.44 SO Walk Customers for the week-Cash Receta 13 34 Messages $1,370.00 ul. Chopractic Adres 565 $2.45.00 HST en Massage 56.609.10 S019 Receive Payment - Oulsone box 360 52793.00 100 = A/ 200 SD 20 BESORT6 - Pow Company Terms - 1/5. Mes 20 and 12 Master case of 24-TOPOS 288.00 HST 1745 Total Due $325.4 5021 Deposit al Cash and Cheat 21/2020 Net Depot 39,488.30 SD 22 Cath Recep11 - Mi Sylvia Simouick addPd via 10FCP Foam Contros S7500 NMS 02 Non-Medicinale Supplements $132.00 HST 2891 Total 9:19 SO 22 Cash Recipes 18 - Mi. Sylvia Slider 18 C Foam Contour ilot $15.00 NNS 02 Non Medicinal Bottes Sets $132.00 31 2.1 $211.1 SD 23 27 Medical Linen Supplies - Net25 10 Sets Sheets - w/owcases & 4a Terry Towel-Whee HST Totale 5866.00 R1000 or 2012 A 20 5024 Walkinton for the week-Cash #19 $105 53,000.00 45 Copa Amers 5654 53.385.00 Stan . Total $78.70 SD 25 Wrech33.Puyol kerto Papell us WMA/ection 2017 Grows us Employer interes SSS Wages Cleaner 80 hrs 16het Gross Employer Bed $2170.23 Service Changes-Wipe Prep 52135 HST Total Pavelle 52372.12 SD 25 Cash Box200 Bos. Duste-PoVi 2 parci Foan Comorom $ 150.00 SNIS-Non-Medicinal Bottles Supplements 100.00 HST 33.22 Total SO 27 Cash Recept217. Pa hencode Table badd to investory-woven Massage Table Rent-Art $1,750.00 HST Total $1.297.50 SD 28 Cash Recepe 221. Sissid Cheque*822 Item code Talent Chiropractic Table - Apk $1.500.00 HST Total $149.00 SD 25 Wie beque 134835 Drawings for Alon Albert Frankowe Other Al Franklin $220.00 Abertin $2250.00 SD 30 Record Prepaid cage 1 Month of Praged Care Aor A 30/2000 = SD Recording otpad Adverthing 5625.00 SO 32 Record Use of Supplies Une Speed Office Supplies Used Other Supples Used $ 270.00 $50.00 9:19 A 5 625.00 30 31 Recorded Not heat Advertising SD 32 Record Use of Supplies Line Supled Office Supplies Used Other Supplies Used $ 270.00 $ 5000 5033 DI 4 CHAP 4 Cheques A900 50 Transfer Strom Regina Credit Card internet account to Bank tot SOS heconcile the Bank Account and Credit Card Interact Accounting the watched street for 2020 Bank of Orange Franklin Alo Apr 2020 Act 258954697 223 Date Der Wir Depot 27 28.00 2022.00 2020-04-01 2020-04-04 2020-04-06 2020-04-14 Beda Payroll SINO R& 172.12 70865 32 2020-04-15 57.50 35255 Orange US Medicali Supply Rogers Communications 2020-04-16 72070 20 31 DP 2020-04-20 2020-04-21 Supplement 2020-04-21 2020-04-29 125.4 3372-12 000523 Bank of Orange Credit Card feest Act Franklin Churrat April 1 to April 19,2020 258 554697 221 Description tel Wewe A DWIE bupaa 4/14/2020 4730/2020 4/30/2020 Deposit Deput Transfer to 21 30 >> 1344 2051 SS 1.800.00 Provide betong to your instructor for dig som Antinentary your inter Bank Stat Meconciliation Summary Art23/20 Trillance Apr 20/20 ANAS Ar Vendor Balance Detail April 20/20 ma Apr 1/20130/20 Inry Valuation Summary April 30 20 5:07 Teams X Ally's Chiropractic Quickb... Ally & Al's Chiropractic & Massage You Hurt. We Fix Westdale Plaza - Orangeville, ON-Tel# 519-555-2315 The Franklimmet in medical school, Alberts RMTALY and completed work ffenest cities and Ab Aldasided 30 marry and settle in Orangeville Ostatico adulti Remplo de The employees are poll company. They maldomer memory Sam HA chiropractic cited items and services ( mga & blom. They They rend table space to a Masseuse and Chinese Notes Istry Mash 342020 Feam Contear Pillows-FCP-01 - Purchase and in pairs Seso 575 pait. Cet is 524 cachait. - paint stock value of 56 cm Nee-medicinal Supplements (no cemitered a grocery imate HST - NMS-02-Ce of 4-56/hele. They S522 Puttle in singles in a value of 168 cm BENT Bocs. Dolanan payment for a May Bed SITOST F Sanjeed paperent for Chiropractic Bed - S1500/ HIST All Documents (cheques, invices, etc.) are to be considered printed at Be sure to review sitem und nice and fees for price changes to be input to the wem. Patients & Revivables Massage co 5103 (+ Chip Service Wille-Cubrecepty colchoque Credit card peetervice Bandera Speed Skating Club-term discount paid it 10 day cda 30 days - Chanding Bin Ouls Heckexchb-2.25 days Net 35 days-Ording Sis for SSC00 March 22/2000 Oder patients come may be added quickly to the All purchase of Pillows and Supplements are to be added to the All bed for depasit (undeposited funds and are deposited to the Bank Regina Clequin acceach week Petty Cash is kept 15 Marting with first deposit them and updated the mark after use. All Credit Card Interact receipt pe to the Region Credit Card & Preference - Accounting scholars are des In the past Venders & Paya Medical Line Suely 1 Net 15 days - Outstanding av #2789 fik 5690 (HST) March 202020 Wall Plus-Rene-560 mooth HST Duc day of every month FC Pil C Net 20-ostanding in Salmah.co.De Recupedig Danellele Hydra & Wet No 30. THIS Commune-Nord-E-IST) note, there with the last two vendon. The bills from March l not get entered and are vene. You will see that you are write chequesthese vender for March the ad April billetes puyable) Employees & Payroll Millic Bames - MON Receptionist - $20 hr max 80 hrs. per pay period paid twice monthly - through payroll service Jason Boume-Cleaner Maintenance - 16 hr max 80 hrs. per period - paid twice monthly through payroll service Employees are paid through a payroll service, twice per month. An invoice is sent for the total amount plus service fee (plus HST) at leasts days prior to pay day Ally and Al take monthly Drawings of $2250 cach. Paid by Cheque at month-end EESTI HER mm April 2020 Entries to be completed SD1 Write Cheque #27. Pay Rent to Westdale Plaza Apr 1/2020 -memorize for future use April 2020 Rent $ 5,600.00 HST S_728.00 Total Due $6,328.00 SD 2 Cash Receipt 14. Walk-ins (quick add - Undeposited Funds Apr 4/2020 32 Massages S105 $ 3.360.00 42 Chiropractic Adjustments S65 en $ 2,790,00 HST on Massages 416.80 Total ZONA Trial Balance Ally and Ars Chiropractic Massage at Mar 31, 20 De Cree 2 500 10000 - Bank of Regina Chequing Account 10500 Regina Credit Card Interact 11500 - Accounts Ree Patient Insurance 12000 Net Prepaidiet2100 Prepaid Tones 12000 - Net Prepaid $2200 - Prepaid Insurance (car) 12000-Net Prepaid 12400. Prepaid Advertising 13000 Supplies Totat13100 Linen Supplies 13000 - Supplies Totat 13200 - Office Supplies 13000 Supplies Total 13300 Other Supplies 54000 Inventory To 14200 Cortur Foam Polow 14000 Inventory T14300 Non-medicinal Supplements 16000-Canguter Equipment BV 16100 - Computer equipment -cost 98000Computer Equipment BV:1600 Ace. Deprec. Computer Equip 16500 Treatment Equip Tables-at-6600 Treatment Tables 16500 - Treatment Equip/Tables-Net: 16700 Trement Equipment 16800 - Treatment Equipes Net 1600 Ace Depec Treatments 17100 Office Furniture NEV:17200 Office Furniture 17100 - Office Furniture NOV 17300 Acr. Deprec. Office Furniture 21000 - Accounts Payable 22000 Bank Loan Payable 25300GSTAST Payable 30000 - Opening Balance Equity 33006 Capital 35000 Drawing 41000 - Total Revenues 43200 Chiropractices 41000 Total Revenues 43500 Massage fors 41000 Total Revenues 43700 - Tableront 41000 - Total Revenues9100 - interest Ravenue 41000 Total Revenue 47500 Sa Discounts 52000 Interest Expense 10 . 100 14 2006 BOB 10 53000 Bank Charges 2305 2000 2000 TM 2.000.00 ROBI 54700 Advertising and Promotion 60200 Automobile Expense 62300 - Des and scription 62600. Equipment Rental 63300 Insurance Expense 64400 - Supplies Exp 44900 - Payroll Service Fees 66500 Series & Wage 66700 - Professional Fees 67000. Laundry Service 47100 Expense 07200. Repairs and Maintenance 66100 Telephone Expense 72500 Depreciation Expense TOTAL 720 172.16 April 2020 Entries to be completed SD 1 TUR 5:08 Teams X Ally's Chiropractic Quickb... "We Choqe 27 Pay Rew We Masa Apr 1220 - men for futwe April 2000 Ron $5.000.00 HST S728.00 Total Due 563.00 SD Cash Receipt 14. Walk is quick anded Ape 42020 32 Maio 5230.00 42 Chiropractic Adjustments @ $65 52.730.00 HST Massage S33 Total S5360 SD Receive Payment Cheque 1234 on 316 indeposited Funds A52030 The Barn Owl Hockey Cluh-puntial payment en court 52800.00 SD Sales ander 26- Patient order Ap 100 The Rinder Speed Staling Team & Chips visits For April 10 Manapes were given for 5 cach. Chronic for Check Tax codes. Total onder $71675 SDS 73000 Deposit al Cash and Choques to unk-ho 150 cash for any Account to be created 10300 Pety Case is a bank account. Ne deposit is 59,17680 SD Winte cheque #28 Payroll vi formidato Peroll Plus dende) Apr 3/2000 Wapes MOA Reception 20 Gross Plus Employer Benefits SL7348 Wages Cleaner Roles 516h et Gros Plus Employer Benefits Taxes $1,370.21 Service Charges - WaPrep (HST) $ 233.15 HIST orice fee 3031 Total Puyalle 53.372.12 SD: Sales Retur 13R-Cash refund to walk-in customer from Petty Ape 10/2000 pkg (pa) - FCP-1 Contour Foam Pillows opened olid price) $50.00 (ST) Customer came is Wanda Sex SDN Inice $22. Runde Speed Skating Team - 2/16 tanto orden Apr 102020 Massage 3 Chiropractic Ad STRO DO HISTmases 61.75l De 571679 S475.00 SD 9 Walk Customers for the weck Cash R15 - undeposed funda Apr 11 2020 15 Maxapes sios 53.675.00 46 Chiropractic Adjustments $2.99000 HST Messages Total 57.142.75 SD 10 Tay Bill Medical Line Supplies - Cha 29 Ap 142030 Pay Invice 270 577.70 SD IN Walk-in Customers for the weck Cash Receipt 17 Apr 18 2020 14 Massages S105 cm $3,570.00 41 Chiropractic Adjustments 15 52.165.00 HST on Massages 64.10 Total 56699.10 SD 19 Receive Payment Ham Owls on in IN Apr 202020 Inv3IN puid che 301 $ 2799.00 SD 20 Bill 90876 - FC Pillow Company Toms - 1905. Net 20 (add terms) 12 x Master case of 2 - 24 pillows - FCP-OIS 288.00 Apr 212020 HST 37.44 Total S 32544 SD 21 Depoutall Cash and Cheques Net Deposit 9,4910 A 21:2000 SD 22 Cash Receipts #18 Me Sylvia Slim (quick adid) Pd Visa Apr 23/2020 1 pkg (pair) FCPO Foam Contour Pillows $75.00 6 NMS-02 Non-Medicinal Bottles Supplements S12.00 HST 52691 Total $223.91 SD 23 Bal 4267 Medical Linen Supplies - Net 15 Apr 23/2020 10 Sets Sheets - w pillow extes & 48 Terry Towels - White 576637 HST $99.63 Total payable S866.00 SD 24 Walk-in Customers for the weck Cash Receipt 19 Apr 25 2020 38 Massages S105 ca $ 3.990.00 49 Chiropractic Adjustments S65 es $3.15.00 HST Massages S.518.20 57.693.70 SD 25 Write cheque #33 - Payroll invoice for mid-mooth to Payroll A 252030 Wages MON/Reception Ohes 20h Gross Plus Employer Benefits Taxes 5173.45 Wapes Cleaner 80 hrs $16hr het Gross Plus Employer Benefits/Tunes 5137021 Service Charges Wage Prep (IST) $ 233.15 HST on service fee 31 Total Payable 5.3372.12 SD 26 Cash Rec# 20 to Rosie Ouedo-PD Visa Apr 22000 2 pair FCP-O1 Foam Contour Pillows $ 150.00 SNMS-02 Non-Medicinal Bottles Supplements $110.00 HST 5.33.0 Tocal $293.80 SD 27 Cash Receipt 21. Doleman Paid Via Apr 10/2000 Item code TabRent add to inventory - inventory item Massage Table Rent - April $1.750.00 HST 5227.50 Total 51.977.50 Tocal HST Total 195.00 S 1.695.00 SD 29 Write Cheque # 34 & 35 Apr 30/2020 Drawings for Allyson & Albert Franklin Squick add owners as Other) Allyson Franklin $ 2250.00 Albert Franklin S 2250,00 SD 30 Record Prepaid Insurance usage Apr 30/2020 1 Month of Prepaid Car Ins $ 667.00 SD 31 Record prepaid advertising usage Apr 30/2020 of Prepaid Advertising $ 625.00 SD 32 Record Use of Supplies Linen Supplies used Office Supplies Used Other Supplies Used Apr 30/2020 S 270.00 S $0.00 $ 75.00 SD 33 Deposit all Cash & Cheques Apr 30/2020 SD34 Transfer $6,500 from Regina Credit Card & interact account to Bank account Apr 30/2020 SD 35 Reconcile the Bank Account and Credit Card / Interact Account using the attached statements Apr 30/2020 Part Franklin China April 29, 2020 5554697223 Wirawat pelance AL De 16. 111213 487 0 23 Welle 27 2000-01-04 DP 2020-6-Panelles 2000-01-14 DP Changeville 2000- Unities 10 Medical Linen Supply Mogen 2000-2 Communications 31 2000.OLGT EP Supplem! 2000-042 32 200 Payroll Plus To 251.00 IT 19098047331 1354 1433 Hank Orangeville - Credit Card Recipes Act FanChupati Aprill April 16, 2020 RETIE AL Apr 30/2020 S 625.00 usage % of Prepaid Advertising SD 32 Record Use of Supplies Linen Supplies used Office Supplies Used Other Supplies Used Apr 30/2020 S 270.00 $50.00 $ 75.00 SD 33 Deposit all Cash & Cheques Apr 30 2020 SD34 Transfer S6,500 from Regina Credit Card & interact account to Bank account Apr 30/2020 SD 35 Reconcile the Bank Account and Credit Card / Interact Account using the attached statements Apr 30/2020 Tank of aki Chi AS AN 202230 Act 554333 Dale 2 Witwal Daputele 1 01 Westate 23 61280 102 ROOL be 1.NO 20.00 Pavel Plus 2012 2009-04-14 De Orange 0-1S 5750 Medical Linen 03.04.14 Seth Roger 020-04 21 H4 20-04-20 Del 194910417221 Supplement 2009-04-21 Hea 14 41397 2020-61 Payal Ple 30397212 052 Hanko Chaville - Credit Casil Ke Aca Frasis Chat April 10 April 2030 Act 258531 Date Description Wine Balance 4142026 4/30/703 Dapell 30 130208 Tramfer 3 6500 CO 134.47 59994 2505.24646 Provide the following to your Instructor for grading Journals And Inventory valuation not mandatory - Ask your instructor Bank Chaing Reconciliation Summary - April 29/20 Trial Balance - April 30 20 AR Aging Summary April 30 20 Vendor Balance Detail April 30/20 Journals - April 120 to April 30 20 Inventory Valuation Summary - April 30 20 triOS/ Eastem triOS version July 2021 Employees & Payroll Millic Bames - MON Receptionist - $20 hr max 80 hrs. per pay period paid twice monthly-through payroll service Jason Boums - Cleaner Maintenance -S16 hr max 80 hrs. per period paid twice monthly through payroll service Employees are paid through a payroll service, twice per month. An invoice is sent for the total amount plus service fee (plus HST) at least days prior to pay day Ally and Al take monthly Drawings of 2250 cach. Paid by Cheque at month-end BER LT IT April 2020 Entries to be completed SD 1 Write Cheque #27. Pay Rent to Westdale Plaza Apr 1/2020 -memorize for future use April 2020 Rent $ 5,600.00 HST S 728.00 Total Due $ 6,328.00 SD 2 Cash Receipt 14. Walk-ins (quick add - Undeposited Funds Apr 4/2020 32 Massages $105 $ 3.360.00 42 Chiropractic Adjustments S65 ca $ 2,730.00 HST on Massages S436,80 Total GARA D Ally & Al's Chiropractic & Massage You Hurt - We Fix! Westdale Plaza - Orangeville, ON - Tel #519-555-2315 The Franklins' met in medical school, Albert studying RMT and Ally (short for Allyson) became a Chiropractor. After the pair both graduated and completed work in different cities and towns, Ally & Al decided to marry and settle in Orangeville, Ontario to set up a dual practice, Using some of the money they saved and using loans, they opened up a storefront at the Westdate Plaza, at Westdale Ave. & Birch St. They have 2 employees, an M.O.A./Receptionist and a cleaner. The employees are paid through a payroll company. They are sent an invoice twice per month. The Franklins also sell some contour memory foam pillows and non-medicinal supplements. Because the Franklins earn more than $30,000 per year, as per federal regulations, they are required to have an HST number and charge HST on non chiropractic related items and services (massages & table rent). They are also able to claim the HST paid on certain items/expenses. They rent table space to a Masseuse and a Chiropractor Notes Inventory - March 31/2020 Foam Contour Pillows - FCP-01 - Purchased and sold in pairs. Sold for $75 /pale. Cost is $24 each pair. - 4 pairs in stock value of $96 at cost. Non-medicinal Supplements (not considered a grocery item -subject to HST) - NMirS-02 -Case of 48 Bottles - 56/ bottle. They sell for $22/ bottle in singles - 28 in stock at a value of $168 at cost. RENT of Beds for other service providers P. Doleman pays rent for a Massage Bed - $1750/mo + HST F. Sanjeed pays rent for Chiropractic Bed - $1500/mo. +HST All Documents (cheques, invoices, etc.) are to be considered printed at the time of input Be sure to review all items and services, costs, and fees for price changes to be input to the system. triOS/ Eastern trios version July 2021 9:18 al A Qe Ally & Al's Chiropractic & Massage You Hurt - We Fix! Westdal Plaza - Orangevile, ON-Tel #5195552315 The Franklin' met in medical school, Albert studying and Alyshorter on became Chiropracter the pair bound and completed word in die sand decided to marry and teleradie, Ontario tertion Using one of the money they saved and using the speed up in the Wel, A & Bicht They have employees, as MOA Meceptionisandale Theme company. They are sent an indice twice per month. The Frais ao salone con pillows and non-medicinal upplement Because the Franklin eam nore than 50.000 per year, apertadecal regulation theorette have an Sumber and change HST on non chiropracteated as a servis sages rent. They are able to claim the paid on tantum They rent table space to Master and Chiropractor vetery - March 12 Foan Contour Plows-FCP-41 - Purchased and sold in pairs Soffor 575 / Costa Duis in stock value of tot Non medicinal Supplements not considered a grocery tem-jet e NAS-02- Bottes-56/bottle. They will for 22/bottle in inglese com INT Salon rent for a speed-$175/ Sent for Chiropractic bed-1500/mo.it Al Documents chequr, mice etc.) are to be considered printed at the time oinput Be sure to view item and service, costs, and tres for price changes to be input to the Patients & Receive Massages cout 05 (HST) per hour and Core Services Emese per We-Cath receipts-Pay cash chaque ar Credit card upon Bam diction de reden Outstanding we Barn Out Hockey Club-24/2 ds. et 5 days-Outandine 118 5400.00 - 22.000 Other patients foustomers may be added to the customers. All and Supplements are to be added to the customer list All held for deposit fundeposited funds and are deposited to the Bank of Regina South Potty Cashe kept $180 starting with first deposit this month and updated the next week AB Credit Card Interact receipts go to the Regina Credit Card Interactant Preferences - Accounting uchwarni transactions are 30 days in the par 9:18 & Payables Best-1X/Net.cat Rent-$94.00/mom ST Due Iday of every month CP Compass -15/5 Net 10 outstanding Supplemental Health Co-Bronco-none cutting Draveits-Hydro & Water Metoda Bater Communication et 30 day-I-IST) Trote there is an ime with these last two windor the bistroma rotterdam overdue. You will see that you have to write cheques to these centers for March the addre accounts payable Employees & Payroll Mille Barnes - Motion 20/max 30 hrs per a period wie- para service te b-Cleane/ Mantenance - $15 as the period-pedie para service treployees are paid through power than for the service fee plus 5T) the Stars prior to pay day Alyan take northy Drawings of S2250 each. Pod by Chequest mothes. II Ae Card 11 Asari www Prep) cutbread Avertising Spot 100-200 13 1400ory Total Centro 00 Tape Comment 1700-Computer met e com 180 cm The owned www.com The Tree Orice Front WT Ate. Der One Barone SHOP Bar 3000 C 10 Dreng 100 TR49880 Wage For come 100 at Wert Chry Strong Promotion 20 Automat ases con 81300 ser Payroll Service Sage Power ready Tepende ET Depreciation TOTAL 9:18 April 2020 Entries to be completed 2 E Q $270.00 Cheque 27 Pay Rent - memorie for future April 2070 Rent $5.000.00 HST 8.99 Total Due $6.328.00 502 Carch Resepte wat in quick adid-Lindegosted Funds 12 Messages 10 $3.360.00 42 Chiropractic A4598 HST on Messages OBS Total 56.526.00 503 Receive Payment-Cheque 123 on X318-Undepstad funds The Bum Owls Hockey Cubertal payment on account 2800.00 504 Sales order 26- Patient order The Rounders Speed Skating Team-5m3 Chigre For April 10 Msages were given for $35. Chiropractor 560 Check Tax codes. Totatorder=5716.75 SOS hor 2020 Depostal Cash and Chest lank-hole $150 cash for Cathru tebe-0- Petty Cash is a bascut Nerdesi 59.11080 505 Write cheque #28 Payroll invoice for mid-month to Payroll Plus quick add vendor A/2000 Wag MOA/Reception Bohus 520 Groups Employer Benefit/ $1.73845 Wag leaner in het Gross sployer Benefits 5.170.21 Service Charges - Wape Press) $ 23:15 Stan Vice TotalPayabile 53.372.12 SD 7 Salesetem 13-Cash refund to walk in istomer domeny Cash 1 skar-CP-Contour Foan low-notcome-50.00 Customer Wanda Ar SD3 Invoice 32 ts Routers Speed Skating Team - 2/0 et 30 SM $47.00 3 Chiropractic An 5180.00 IST on 2018 $71675 100 SD 9 Wakin Customer for the week-Cash Receita 15-to undeposited fundet 15 Massages 510% v $2,675.00 46 Chiropractic Adjustments 565 $2.990.00 Sen Massage 02273 57.1425 SD 10 Ray Bat - Medical Linen Suple-29 Payale 2789 $77.70 A100 5011 Canh Recep16 - Sir Ray Skossa - Quick Ade Paid Interact 14/2020 To undeposited Fundal FCPF. 2NSO Nen Dot Media SS1440 9:19 E Q 20 deposited Fundi FCP Foam Contour 2 NMS-02 Non Bottles Medicinal Supplements 54.00 ST 15:42 Tonal 513447 5012 wme Re-Orangeville-Overde Roma Cheque 0 $5815 Inot entered previously 200 A 1200 S013 Wres Communicationsx0067437239-Overder From March 14/2020 Cheques $22.12. notre pre S014 Deposit Cash & Cheon/Credit Card Inter Debrecen transfer funds so topup Petty Cash From refund transaction Netdepot Stank Net Deposit Credit Card $1844 SOUS Ongeville Uties term Neto days Hydro Service $37800 Water $250.00 HST Total Due $7564 5036 ONTHS637 Hopen One Acet5522342-Net 30 day 2 Celles $198.00 Internet Service $18.00 Cable Pack $45.00 HST Total 52016 5017 76 Supplement Heath Cowthe cheque 12 4a bottles cases Non medicinal solener $28.00 ST 2 Due on Recent $325.44 SO Walk Customers for the week-Cash Receta 13 34 Messages $1,370.00 ul. Chopractic Adres 565 $2.45.00 HST en Massage 56.609.10 S019 Receive Payment - Oulsone box 360 52793.00 100 = A/ 200 SD 20 BESORT6 - Pow Company Terms - 1/5. Mes 20 and 12 Master case of 24-TOPOS 288.00 HST 1745 Total Due $325.4 5021 Deposit al Cash and Cheat 21/2020 Net Depot 39,488.30 SD 22 Cath Recep11 - Mi Sylvia Simouick addPd via 10FCP Foam Contros S7500 NMS 02 Non-Medicinale Supplements $132.00 HST 2891 Total 9:19 SO 22 Cash Recipes 18 - Mi. Sylvia Slider 18 C Foam Contour ilot $15.00 NNS 02 Non Medicinal Bottes Sets $132.00 31 2.1 $211.1 SD 23 27 Medical Linen Supplies - Net25 10 Sets Sheets - w/owcases & 4a Terry Towel-Whee HST Totale 5866.00 R1000 or 2012 A 20 5024 Walkinton for the week-Cash #19 $105 53,000.00 45 Copa Amers 5654 53.385.00 Stan . Total $78.70 SD 25 Wrech33.Puyol kerto Papell us WMA/ection 2017 Grows us Employer interes SSS Wages Cleaner 80 hrs 16het Gross Employer Bed $2170.23 Service Changes-Wipe Prep 52135 HST Total Pavelle 52372.12 SD 25 Cash Box200 Bos. Duste-PoVi 2 parci Foan Comorom $ 150.00 SNIS-Non-Medicinal Bottles Supplements 100.00 HST 33.22 Total SO 27 Cash Recept217. Pa hencode Table badd to investory-woven Massage Table Rent-Art $1,750.00 HST Total $1.297.50 SD 28 Cash Recepe 221. Sissid Cheque*822 Item code Talent Chiropractic Table - Apk $1.500.00 HST Total $149.00 SD 25 Wie beque 134835 Drawings for Alon Albert Frankowe Other Al Franklin $220.00 Abertin $2250.00 SD 30 Record Prepaid cage 1 Month of Praged Care Aor A 30/2000 = SD Recording otpad Adverthing 5625.00 SO 32 Record Use of Supplies Une Speed Office Supplies Used Other Supples Used $ 270.00 $50.00 9:19 A 5 625.00 30 31 Recorded Not heat Advertising SD 32 Record Use of Supplies Line Supled Office Supplies Used Other Supplies Used $ 270.00 $ 5000 5033 DI 4 CHAP 4 Cheques A900 50 Transfer Strom Regina Credit Card internet account to Bank tot SOS heconcile the Bank Account and Credit Card Interact Accounting the watched street for 2020 Bank of Orange Franklin Alo Apr 2020 Act 258954697 223 Date Der Wir Depot 27 28.00 2022.00 2020-04-01 2020-04-04 2020-04-06 2020-04-14 Beda Payroll SINO R& 172.12 70865 32 2020-04-15 57.50 35255 Orange US Medicali Supply Rogers Communications 2020-04-16 72070 20 31 DP 2020-04-20 2020-04-21 Supplement 2020-04-21 2020-04-29 125.4 3372-12 000523 Bank of Orange Credit Card feest Act Franklin Churrat April 1 to April 19,2020 258 554697 221 Description tel Wewe A DWIE bupaa 4/14/2020 4730/2020 4/30/2020 Deposit Deput Transfer to 21 30 >> 1344 2051 SS 1.800.00 Provide betong to your instructor for dig som Antinentary your inter Bank Stat Meconciliation Summary Art23/20 Trillance Apr 20/20 ANAS Ar Vendor Balance Detail April 20/20 ma Apr 1/20130/20 Inry Valuation Summary April 30 20 5:07 Teams X Ally's Chiropractic Quickb... Ally & Al's Chiropractic & Massage You Hurt. We Fix Westdale Plaza - Orangeville, ON-Tel# 519-555-2315 The Franklimmet in medical school, Alberts RMTALY and completed work ffenest cities and Ab Aldasided 30 marry and settle in Orangeville Ostatico adulti Remplo de The employees are poll company. They maldomer memory Sam HA chiropractic cited items and services ( mga & blom. They They rend table space to a Masseuse and Chinese Notes Istry Mash 342020 Feam Contear Pillows-FCP-01 - Purchase and in pairs Seso 575 pait. Cet is 524 cachait. - paint stock value of 56 cm Nee-medicinal Supplements (no cemitered a grocery imate HST - NMS-02-Ce of 4-56/hele. They S522 Puttle in singles in a value of 168 cm BENT Bocs. Dolanan payment for a May Bed SITOST F Sanjeed paperent for Chiropractic Bed - S1500/ HIST All Documents (cheques, invices, etc.) are to be considered printed at Be sure to review sitem und nice and fees for price changes to be input to the wem. Patients & Revivables Massage co 5103 (+ Chip Service Wille-Cubrecepty colchoque Credit card peetervice Bandera Speed Skating Club-term discount paid it 10 day cda 30 days - Chanding Bin Ouls Heckexchb-2.25 days Net 35 days-Ording Sis for SSC00 March 22/2000 Oder patients come may be added quickly to the All purchase of Pillows and Supplements are to be added to the All bed for depasit (undeposited funds and are deposited to the Bank Regina Clequin acceach week Petty Cash is kept 15 Marting with first deposit them and updated the mark after use. All Credit Card Interact receipt pe to the Region Credit Card & Preference - Accounting scholars are des In the past Venders & Paya Medical Line Suely 1 Net 15 days - Outstanding av #2789 fik 5690 (HST) March 202020 Wall Plus-Rene-560 mooth HST Duc day of every month FC Pil C Net 20-ostanding in Salmah.co.De Recupedig Danellele Hydra & Wet No 30. THIS Commune-Nord-E-IST) note, there with the last two vendon. The bills from March l not get entered and are vene. You will see that you are write chequesthese vender for March the ad April billetes puyable) Employees & Payroll Millic Bames - MON Receptionist - $20 hr max 80 hrs. per pay period paid twice monthly - through payroll service Jason Boume-Cleaner Maintenance - 16 hr max 80 hrs. per period - paid twice monthly through payroll service Employees are paid through a payroll service, twice per month. An invoice is sent for the total amount plus service fee (plus HST) at leasts days prior to pay day Ally and Al take monthly Drawings of $2250 cach. Paid by Cheque at month-end EESTI HER mm April 2020 Entries to be completed SD1 Write Cheque #27. Pay Rent to Westdale Plaza Apr 1/2020 -memorize for future use April 2020 Rent $ 5,600.00 HST S_728.00 Total Due $6,328.00 SD 2 Cash Receipt 14. Walk-ins (quick add - Undeposited Funds Apr 4/2020 32 Massages S105 $ 3.360.00 42 Chiropractic Adjustments S65 en $ 2,790,00 HST on Massages 416.80 Total ZONA Trial Balance Ally and Ars Chiropractic Massage at Mar 31, 20 De Cree 2 500 10000 - Bank of Regina Chequing Account 10500 Regina Credit Card Interact 11500 - Accounts Ree Patient Insurance 12000 Net Prepaidiet2100 Prepaid Tones 12000 - Net Prepaid $2200 - Prepaid Insurance (car) 12000-Net Prepaid 12400. Prepaid Advertising 13000 Supplies Totat13100 Linen Supplies 13000 - Supplies Totat 13200 - Office Supplies 13000 Supplies Total 13300 Other Supplies 54000 Inventory To 14200 Cortur Foam Polow 14000 Inventory T14300 Non-medicinal Supplements 16000-Canguter Equipment BV 16100 - Computer equipment -cost 98000Computer Equipment BV:1600 Ace. Deprec. Computer Equip 16500 Treatment Equip Tables-at-6600 Treatment Tables 16500 - Treatment Equip/Tables-Net: 16700 Trement Equipment 16800 - Treatment Equipes Net 1600 Ace Depec Treatments 17100 Office Furniture NEV:17200 Office Furniture 17100 - Office Furniture NOV 17300 Acr. Deprec. Office Furniture 21000 - Accounts Payable 22000 Bank Loan Payable 25300GSTAST Payable 30000 - Opening Balance Equity 33006 Capital 35000 Drawing 41000 - Total Revenues 43200 Chiropractices 41000 Total Revenues 43500 Massage fors 41000 Total Revenues 43700 - Tableront 41000 - Total Revenues9100 - interest Ravenue 41000 Total Revenue 47500 Sa Discounts 52000 Interest Expense 10 . 100 14 2006 BOB 10 53000 Bank Charges 2305 2000 2000 TM 2.000.00 ROBI 54700 Advertising and Promotion 60200 Automobile Expense 62300 - Des and scription 62600. Equipment Rental 63300 Insurance Expense 64400 - Supplies Exp 44900 - Payroll Service Fees 66500 Series & Wage 66700 - Professional Fees 67000. Laundry Service 47100 Expense 07200. Repairs and Maintenance 66100 Telephone Expense 72500 Depreciation Expense TOTAL 720 172.16 April 2020 Entries to be completed SD 1 TUR 5:08 Teams X Ally's Chiropractic Quickb... "We Choqe 27 Pay Rew We Masa Apr 1220 - men for futwe April 2000 Ron $5.000.00 HST S728.00 Total Due 563.00 SD Cash Receipt 14. Walk is quick anded Ape 42020 32 Maio 5230.00 42 Chiropractic Adjustments @ $65 52.730.00 HST Massage S33 Total S5360 SD Receive Payment Cheque 1234 on 316 indeposited Funds A52030 The Barn Owl Hockey Cluh-puntial payment en court 52800.00 SD Sales ander 26- Patient order Ap 100 The Rinder Speed Staling Team & Chips visits For April 10 Manapes were given for 5 cach. Chronic for Check Tax codes. Total onder $71675 SDS 73000 Deposit al Cash and Choques to unk-ho 150 cash for any Account to be created 10300 Pety Case is a bank account. Ne deposit is 59,17680 SD Winte cheque #28 Payroll vi formidato Peroll Plus dende) Apr 3/2000 Wapes MOA Reception 20 Gross Plus Employer Benefits SL7348 Wages Cleaner Roles 516h et Gros Plus Employer Benefits Taxes $1,370.21 Service Charges - WaPrep (HST) $ 233.15 HIST orice fee 3031 Total Puyalle 53.372.12 SD: Sales Retur 13R-Cash refund to walk-in customer from Petty Ape 10/2000 pkg (pa) - FCP-1 Contour Foam Pillows opened olid price) $50.00 (ST) Customer came is Wanda Sex SDN Inice $22. Runde Speed Skating Team - 2/16 tanto orden Apr 102020 Massage 3 Chiropractic Ad STRO DO HISTmases 61.75l De 571679 S475.00 SD 9 Walk Customers for the weck Cash R15 - undeposed funda Apr 11 2020 15 Maxapes sios 53.675.00 46 Chiropractic Adjustments $2.99000 HST Messages Total 57.142.75 SD 10 Tay Bill Medical Line Supplies - Cha 29 Ap 142030 Pay Invice 270 577.70 SD IN Walk-in Customers for the weck Cash Receipt 17 Apr 18 2020 14 Massages S105 cm $3,570.00 41 Chiropractic Adjustments 15 52.165.00 HST on Massages 64.10 Total 56699.10 SD 19 Receive Payment Ham Owls on in IN Apr 202020 Inv3IN puid che 301 $ 2799.00 SD 20 Bill 90876 - FC Pillow Company Toms - 1905. Net 20 (add terms) 12 x Master case of 2 - 24 pillows - FCP-OIS 288.00 Apr 212020 HST 37.44 Total S 32544 SD 21 Depoutall Cash and Cheques Net Deposit 9,4910 A 21:2000 SD 22 Cash Receipts #18 Me Sylvia Slim (quick adid) Pd Visa Apr 23/2020 1 pkg (pair) FCPO Foam Contour Pillows $75.00 6 NMS-02 Non-Medicinal Bottles Supplements S12.00 HST 52691 Total $223.91 SD 23 Bal 4267 Medical Linen Supplies - Net 15 Apr 23/2020 10 Sets Sheets - w pillow extes & 48 Terry Towels - White 576637 HST $99.63 Total payable S866.00 SD 24 Walk-in Customers for the weck Cash Receipt 19 Apr 25 2020 38 Massages S105 ca $ 3.990.00 49 Chiropractic Adjustments S65 es $3.15.00 HST Massages S.518.20 57.693.70 SD 25 Write cheque #33 - Payroll invoice for mid-mooth to Payroll A 252030 Wages MON/Reception Ohes 20h Gross Plus Employer Benefits Taxes 5173.45 Wapes Cleaner 80 hrs $16hr het Gross Plus Employer Benefits/Tunes 5137021 Service Charges Wage Prep (IST) $ 233.15 HST on service fee 31 Total Payable 5.3372.12 SD 26 Cash Rec# 20 to Rosie Ouedo-PD Visa Apr 22000 2 pair FCP-O1 Foam Contour Pillows $ 150.00 SNMS-02 Non-Medicinal Bottles Supplements $110.00 HST 5.33.0 Tocal $293.80 SD 27 Cash Receipt 21. Doleman Paid Via Apr 10/2000 Item code TabRent add to inventory - inventory item Massage Table Rent - April $1.750.00 HST 5227.50 Total 51.977.50 Tocal HST Total 195.00 S 1.695.00 SD 29 Write Cheque # 34 & 35 Apr 30/2020 Drawings for Allyson & Albert Franklin Squick add owners as Other) Allyson Franklin $ 2250.00 Albert Franklin S 2250,00 SD 30 Record Prepaid Insurance usage Apr 30/2020 1 Month of Prepaid Car Ins $ 667.00 SD 31 Record prepaid advertising usage Apr 30/2020 of Prepaid Advertising $ 625.00 SD 32 Record Use of Supplies Linen Supplies used Office Supplies Used Other Supplies Used Apr 30/2020 S 270.00 S $0.00 $ 75.00 SD 33 Deposit all Cash & Cheques Apr 30/2020 SD34 Transfer $6,500 from Regina Credit Card & interact account to Bank account Apr 30/2020 SD 35 Reconcile the Bank Account and Credit Card / Interact Account using the attached statements Apr 30/2020 Part Franklin China April 29, 2020 5554697223 Wirawat pelance AL De 16. 111213 487 0 23 Welle 27 2000-01-04 DP 2020-6-Panelles 2000-01-14 DP Changeville 2000- Unities 10 Medical Linen Supply Mogen 2000-2 Communications 31 2000.OLGT EP Supplem! 2000-042 32 200 Payroll Plus To 251.00 IT 19098047331 1354 1433 Hank Orangeville - Credit Card Recipes Act FanChupati Aprill April 16, 2020 RETIE AL Apr 30/2020 S 625.00 usage % of Prepaid Advertising SD 32 Record Use of Supplies Linen Supplies used Office Supplies Used Other Supplies Used Apr 30/2020 S 270.00 $50.00 $ 75.00 SD 33 Deposit all Cash & Cheques Apr 30 2020 SD34 Transfer S6,500 from Regina Credit Card & interact account to Bank account Apr 30/2020 SD 35 Reconcile the Bank Account and Credit Card / Interact Account using the attached statements Apr 30/2020 Tank of aki Chi AS AN 202230 Act 554333 Dale 2 Witwal Daputele 1 01 Westate 23 61280 102 ROOL be 1.NO 20.00 Pavel Plus 2012 2009-04-14 De Orange 0-1S 5750 Medical Linen 03.04.14 Seth Roger 020-04 21 H4 20-04-20 Del 194910417221 Supplement 2009-04-21 Hea 14 41397 2020-61 Payal Ple 30397212 052 Hanko Chaville - Credit Casil Ke Aca Frasis Chat April 10 April 2030 Act 258531 Date Description Wine Balance 4142026 4/30/703 Dapell 30 130208 Tramfer 3 6500 CO 134.47 59994 2505.24646 Provide the following to your Instructor for grading Journals And Inventory valuation not mandatory - Ask your instructor Bank Chaing Reconciliation Summary - April 29/20 Trial Balance - April 30 20 AR Aging Summary April 30 20 Vendor Balance Detail April 30/20 Journals - April 120 to April 30 20 Inventory Valuation Summary - April 30 20 triOS/ Eastem triOS version July 2021 Employees & Payroll Millic Bames - MON Receptionist - $20 hr max 80 hrs. per pay period paid twice monthly-through payroll service Jason Boums - Cleaner Maintenance -S16 hr max 80 hrs. per period paid twice monthly through payroll service Employees are paid through a payroll service, twice per month. An invoice is sent for the total amount plus service fee (plus HST) at least days prior to pay day Ally and Al take monthly Drawings of 2250 cach. Paid by Cheque at month-end BER LT IT April 2020 Entries to be completed SD 1 Write Cheque #27. Pay Rent to Westdale Plaza Apr 1/2020 -memorize for future use April 2020 Rent $ 5,600.00 HST S 728.00 Total Due $ 6,328.00 SD 2 Cash Receipt 14. Walk-ins (quick add - Undeposited Funds Apr 4/2020 32 Massages $105 $ 3.360.00 42 Chiropractic Adjustments S65 ca $ 2,730.00 HST on Massages S436,80 Total GARA