INCOME Everyday Flowers and Workshops Sales of Product Income Special Occasions Total Income COST OF GOODS...

Transcribed Image Text:

INCOME Everyday Flowers and Workshops Sales of Product Income Special Occasions Total Income COST OF GOODS SOLD Flower Purchases and Supplies Supplies and materials - COS Total Cost of Goods Sold GROSS PROFIT EXPENSES Bank charges Dues and Subscriptions Legal and professional fees Accounting Support Total Legal and professional fees Marketing Website Total Marketing Meals and entertainment Office expenses Promotional Rent or lease payments Taxes and Licenses Utilities Total Expenses PROFIT Beautiful Blooms Floral Co. - SLW PROFIT AND LOSS January - July, 2026 TOTAL 615.00 2,880.00 2,700.00 $8,195.00 3.057.88 341.85 $3,399.73 $2,795.27 55.00 395.00 100.00 100.00 800.00 800.00 175.00 72.66 208.00 4,075.00 650.00 145.00 $6,675.66 $ -3,880.39 Beautiful Blooms Floral Co. BALANCE SHEET As of July 31, 2026 TOTAL Assets Current Assets Cash and Cash Equivalent Petty Cash TD Operating Account TD Savings Undeposited Funds Total Cash and Cash Equivalent Accounts Receivable (A/R) Accounts Receivable (A/R) Total Accounts Receivable (A/R) Prepaid expenses Total Current Assets Non-current Assets Property, plant and equipment Flower Fridges 100.00 3,627.24 1,000.00 0.00 $4,727.24 2,542.50 $2,542.50 2,750.00 $10,019.74 5,000.00 Renovations Original cost 5,000.00 Total Renovations 5,000.00 Total Property, plant and equipment $10,000.00 Total Non Current Assets $10,000.00 $20,019.74 Total Assets Liabilities and Equity Liabilities Current Liabilities Accounts Payable (A/P) Accounts Payable (A/P) Total Accounts Payable (A/P) Credit Card TD Visa Total Credit Card GST/HST Payable Total Current Liabilities Non-current Liabilities Bank loans TD Reno Loan Total Non-current Liabilities Total Liabilities Equity Owner's Equity Profit for the year Total Equity Total Liabilities and Equity 982.60 $982.60 633.14 $633.14 -2,041.61 $ -425.87 5,000.00 4,326.00 $9,326.00 $8,900.13 15,000.00 -3,880.39 $11,119.61 $20,019.74 Week Ending August 15, 2026 Melanie is ramping up for big sales this summer at the store. This week was the sidewalk sale in town, and things were hopping. There were sales throughout the store and a big run on supplies. Thursday, August 13, 2026 OT about basisogeb U 59 There were several small sales paid with cash; create a customer called Daily Sales and post a sales receipt, 2026, for 12 Fresh Flower Bouquets. Jennifer Brown placed an order for Bridal Flowers; she'll come back and pay in 15 days, invoice s bovismil To 2027. Cheque 239 came in the mail to pay the outstanding invoice for H2H Medical Arts for May 29. (790) O Received bill A-175 from Flower Growers Corp for $565 (account/category: Flower Purchases and Supplies). It is due in 30 days. Paid for a delivery of a small cooler and some bottled water to keep on hand; $205.19 with TD VISA card (account/category: Office expenses). me to 196 2010 TIP! You do not need a payee on an Expense form, but it is recommended for ease of reference in the future and for auditing purposes. If you do not want a lot of suppliers in your list, use general suppliers for a more commonly used expense, such as a supplier named "Gas" or "Meals & Entertainment." For our purposes, the office expense above ($205.19) should have no supplier name. Paid for a push broom and bathroom supplies at Office Team with the TD VISA; $117.55 (account/ category: Office expenses). no voyer CHECK FIGURE Your figures from your Balance Sheet should match those shown here as at this date: Account Amount TD Operating Account $3,627.24 0 900 1809 1009s 916910 Undeposited Funds $813.60 GST/HST Payable $-2,008.54 T 00.200.52 od Friday, August 14, 2026 Bryan Fouts stopped in to finally go through with his estimate 1001 for the potted plant program. He needs an invoice and will be back in 15 days to pay. InDomA Wrote cheque 10026 to pay the City of Toronto utilities bill. gnite T Daily Sales for today included 6 Fresh Floral Bouquets and 2 Birthday Vases, all paid by cash. ACW CT Keeping it Kool stopped in for an equipment check on the flower coolers. Their office sends a bill, 85, by email for $56.50 due immediately. Book to Repairs and maintenance account. Received and paid a bill, C-12, from Special Events Superstore. Write cheque 10028 for Supplies and materials in the amount of $412.45. . Mary Beth Dunham needs an invoice, 2030, for a Wedding arrangement for her daughter Sharon's wedding project. Do not forget her credit. now sysos e A Week Ending August 15, 2026 177 CHECK FIGURE Your figures from your Balance Sheet should match those shown here as at this date: Account Amount TD Operating Account $3,069.79 Undeposited Funds $1,288.20 GST/HST Payable $-1,874.64 griquod new id bus acc Saturday, August 15, 2026 boons besig word inst Received a bill from Atlas Planning, 2026-1, for some layout designs for remodeling the back room and adding a bigger event space; for $150; due in 15 days (account/category: Legal and profes- sional fees). Daily sales today were 3 Fresh Flower Bouquets and 3 Birthday Vases paid by debit card and 3 more Fresh Flower Bouquets paid by cash. off no dept of 1916 Mail off cheque 10027 to pay the Chamber of Commerce dues. vtovilob a hot bis9 Placed promotions online with Easy Media Design for upcoming Wreath Workshop; 1-week cover- age for $295, paid by Visa. miot sansux ne no esysq 990 urs not bris shutut tut adt A fresh flower bouquet delivery was late; Lynda Higgs is given a refund back to her credit card from the Undeposited Funds account.ne 10 "360" b laque or ever bluods Make the bank deposit into the TD Operating account for the week's sales in cash and cheques; the deposit should be for $1,440.75. ooidied bas Transfer $633.14 from the Operating account to TD VISA to pay off the balance owing for July 2026. Post the monthly recurring loan payment transfer. Create a Report JnuernA $nu000A AS.100.08 nooA Bois #qQ QT Prepare a Sales by Customer Summary report for Melanie for the week (August 9-15). Total sales should be $2,935.00. A2.800,- day69 T2H\T20 CHECK FIGURE Your figures from your Balance Sheet should match those shown here, as at August 15, 2026: TO ACCOUNT BALANCES 1011001 Account Amount TD Operating Account $3,421.40 TD VISA $617.74 mA/R and A/P BALANCES Statement add lliw b Accounts Receivable (A/R) $4,062.35 Accounts Payable (A/P) $1,359.10 2300 asyid. Balance NOTW 298 ylisd niq GST/HST Payable $-1,867.34 Mood vietaibemuat bub 02.022 101 firms yd,28 asduqu2 101 82001 Super Wu v neq3 mont$1-Did e'noda og gibbsW [sq be Devi Prepare Your Deliverables-Set 1 QGOS S JA yebius? Prepare these reports. Export each to Excel and keep in mind that QuickBooks will create either an .xls or an .xlsx file. Always open the file, enable editing and then save .xls files as .xlsx before submitting to Quick Grader. 9 owi ai zin Sales by Customer Summary report for the week of August 9-15, saved as: 263 082 CH07 Sales by Customer Summary 15-08-26 Transaction Detail by Account report for the week of August 9-15, saved as: CH07 Transactions by Account TD VISA register, saved as: CH07 TD VISA Register 018 sritysbot asina ylieb of Week Ending August 22, 2026 of any sinsis 910 mod Melanie is ready for another great week. She has a big wreath workshop coming up that she is hoping to sell out. Thursday, August 20, 2026 LOC Debit and credit card payments or refunds from last week are deposited into the bank today. DA Sales for the Wreath Workshop are being booked to a new customer, Special Events; five people signed up and paid by credit card; three stopped in and paid for the workshop in cash. David Bell stopped in looking for arrangements for his grandmother's funeral that coming Saturday. He pays with a credit card for two funeral baskets. 92.082 ABIV OT Sharon McColl has called for the full invoice for her program, to be paid immediately, so her program will start September 1. Paid for a one-year subscription to Flowers Forum Magazine with credit card; $24.95. Friday, August 21, 2026 CT 919 A to 193w art tol hoqa yismmu? moja y al 6.91819 Pay Floral, Fauna and Faux over the phone with TD VISA; apply credit before paying. A bill, BBFC-98, from Farm Fresh Flowers arrives for the supplies order from purchase order 1001, for the wreath workshop supplies, due in 15 days. Jaugu grib W Roy Fisher sent in cheque 78, with an apology note for being so late in paying his invoice. Sales for the Wreath workshop tomorrow, posted to the Special Events customer, have filled up w with three people paying by credit card and four with cash. Daily Sales are three Birthday Vases and two Fresh Flower Bouquets, paid by debit. Sharon McColl sends an e-transfer for her invoice, which is deposited right into the operating account. (Create a new payment method if one isn't already there.) Paid all the bills due on or before August 31 from the TD Operating account. (Print cheques later.) Make the bank deposit for monies received the last two days in cash and cheques. The deposit should equal $1,101.75. 401b bloow zais? ylis Saturday, August 22, 2026 Wendy Greenberg's wedding got pushed to October. She popped in to pay 50% of her estimate on the spot with cheque 47. (Hint: This is two steps.) 27AWIA eli xalx. ris to Donated $50 to Sundown Middle School for fundraiser; cheque to print later (account/category: Charitable Donations, Tax exempt). Melanie transfers $500 to the TD Savings account to save for her income taxes. T A bill, 1001, is received from Torrez Lock and Stor for July, August and September 2026 rental in the amount of $254.25, payable in 30 days (category: Prepaid expenses).3782 No daily sales today; the store is closed for the workshop. Melanie makes a payment to the TD VISA from the TD Operating Account for $1,200; use the Pay Down Credit Card form. Print all cheques, starting with cheque 10029. Print to PDF and put in the Chapter 07 folder. CHECK FIGURE Your figures from your Balance Sheet should match those shown here as at August 22, 2026: ACCOUNT BALANCES bel b21 915 A/R and A/P BALANCES 160 Account Amount Statement of Balance 7129162 bengiz TD Operating Account $6,877.60 Accounts Receivable (A/R) $3,553.85 bivad - TD VISA TD Savings vis $30.29 219 Accounts Payable (A/P) mont b $1,500 si 19 101 solovni liul edt 10) balls as looM noted Prepare Your Deliverables-Set 2 QG I tell m ughozsz 189y-900 8 101 bis. Prepare a Sales by Customer Summary report for the week of August 16-22. Export the report to Excel, saving it as: CH07 Sales by Customer Summary 22-08-26 $1,313.06 bus E 10 25ligque 69 how m Week Ending August 29, 2026 que contro se si o Because the Wreath workshop the previous week was such a success, Melanie is offering a Build Your Own Bouquet Workshop this coming Saturday. Until then, it is business as usual and getting ready. dess dilw Thursday, August 27, 2026 All debit and credit card payments from last week are deposited today, in the amount of $1,598.95. Bryan Fouts dropped in and paid his invoice with his debit card. 18910) Receive e-transfer from H2H for the four outstanding June invoices. To no sub allid ad its bisq Called in an order to Farm Fresh Flowers for Flower Purchases and Supplies. Paid $625.88 by credit card so they would drop off today. 20.01.18 1ups bloode Daily Sales are four Birthday Vases and three Bouquets paid by debit, and five Bouquets paid in cash. Four people have signed up for the Build Your Own Bouquet workshop over the phone and paid with credit card. Post to your Special Events customer. 180 QuickBooks Online, Chapter 7: All in a Day's Work! Friday, August 28, 2026 bos The store is closed due to an electrical short. Melanie took the business cell phone home in hopes of handling any incoming calls. Saturday, August 29, 2026 All debit and credit card payments from last week are deposited today, in the amount of $1,327.75. Melanie received five phone calls to reserve a space for the workshop on Friday; three people paid cash when they arrived for the workshop, and the other two paid by credit card. Bill #298 for $565 left in store for emergency repairs and maintenance to electrical on Friday from We Work Space Co. Deposit any cheques and cash, for a total of $937.90. CHECK FIGURE Your figures from your Balance Sheet should match those shown here as at August 29, 2026: ACCOUNT BALANCES A/R and A/P BALANCES Account Amount Statement Balance TD Operating Account $11,555.80 Undeposited Funds $79.10 Accounts Receivable (A/R) $2,062.25 $1,878.06 Accounts Payable (A/P) Prepaid Expenses $2,975 ge Prepare Your Deliverables-Set 3 QG Prepare a Sales by Customer Summary report for the week of August 23-29. Export the report to Excel, saving it as: CH07 Sales by Customer Summary 29-08-26 Tuesday, September 1, 2026 You are working from home to reconcile the bank and credit card accounts, catch up on a few things for Melanie and prepare the month-end financial report. Use the following files from your Chapter 07 folder: CH07 VISA Transactions.csv CH07 TD Savings July.pdf CH07 TD Savings August.pdf CH07 TD VISA August.pdf Perform these tasks: Post the monthly recurring transaction for rent for August and the July and August reallocation of storage rent. Reconcile the TD Savings account for July and August using the statements. There are no monthly fees on this account, but you notice that there was interest earned on the balance each month that you booked at the time of reconciliation to the Interest earned account. reports Import the CSV Visa transactions into QBO and then match the transactions as required. Review any remaining transactions in the list. Record the $113 charge for DANS DELI to Daniel's Deli Delights, category: meals and entertainment, exempt from tax. Reconcile the TD VISA account for August 2026. eliso gnimooni yne gnilbner Create a bank rule to save time when entering the payments for AW Accounting in the future. Use the description AW Accounting. Prepare Your Deliverables-Set 4 QG Prepare these end-of-month reports, exporting each to Excel: 19 Sales by Customer Summary for August 2026, saved as: CH07 Summary August 2026 5 101 69 Jib9 brs Jidab IIA ertori avi bevis991 9inslM erli ol bovins volt edas cja i 119 2022 101 80* lia. Sales by Customer W 90 Balance sheet report for the period as at August 31, 2026, saved as: CH07 Balance Sheet August 2026 199/12 SOS Profit and loss statement for July 1, 2026, through August 31, 2026, saved as: CH07 Profit and Loss Statement August 2026bn \A 230 LA TUA Internets32 Look at the Big Picture A) eldevisne etnuo JnuomA nuoA 08.222.112 Consider these questions (this is not an assessment, but your instructor may want to discuss these issues): 20.818.12 (9\A) UGODA Which suppliers does Melanie owe as of August 31? about betizoqabU onera are,sa 292099x3 bisq919 Which customers owe Melanie as of August 31? aalde neviled quoy 915 and of oqx.es-ES zugu to low sill 101 root 2962 916 a8-80-es you Besa OHO :26 11 gnivea yd 19 919 101 agmidt wat s not bad mon gaihow 918 LOY boombs ainsleM blot TQ quoy mom zelft griwollot uds U vax.ar tbq yut Abq tauguA bq AABJV UT TOHO - INCOME Everyday Flowers and Workshops Sales of Product Income Special Occasions Total Income COST OF GOODS SOLD Flower Purchases and Supplies Supplies and materials - COS Total Cost of Goods Sold GROSS PROFIT EXPENSES Bank charges Dues and Subscriptions Legal and professional fees Accounting Support Total Legal and professional fees Marketing Website Total Marketing Meals and entertainment Office expenses Promotional Rent or lease payments Taxes and Licenses Utilities Total Expenses PROFIT Beautiful Blooms Floral Co. - SLW PROFIT AND LOSS January - July, 2026 TOTAL 615.00 2,880.00 2,700.00 $8,195.00 3.057.88 341.85 $3,399.73 $2,795.27 55.00 395.00 100.00 100.00 800.00 800.00 175.00 72.66 208.00 4,075.00 650.00 145.00 $6,675.66 $ -3,880.39 Beautiful Blooms Floral Co. BALANCE SHEET As of July 31, 2026 TOTAL Assets Current Assets Cash and Cash Equivalent Petty Cash TD Operating Account TD Savings Undeposited Funds Total Cash and Cash Equivalent Accounts Receivable (A/R) Accounts Receivable (A/R) Total Accounts Receivable (A/R) Prepaid expenses Total Current Assets Non-current Assets Property, plant and equipment Flower Fridges 100.00 3,627.24 1,000.00 0.00 $4,727.24 2,542.50 $2,542.50 2,750.00 $10,019.74 5,000.00 Renovations Original cost 5,000.00 Total Renovations 5,000.00 Total Property, plant and equipment $10,000.00 Total Non Current Assets $10,000.00 $20,019.74 Total Assets Liabilities and Equity Liabilities Current Liabilities Accounts Payable (A/P) Accounts Payable (A/P) Total Accounts Payable (A/P) Credit Card TD Visa Total Credit Card GST/HST Payable Total Current Liabilities Non-current Liabilities Bank loans TD Reno Loan Total Non-current Liabilities Total Liabilities Equity Owner's Equity Profit for the year Total Equity Total Liabilities and Equity 982.60 $982.60 633.14 $633.14 -2,041.61 $ -425.87 5,000.00 4,326.00 $9,326.00 $8,900.13 15,000.00 -3,880.39 $11,119.61 $20,019.74 Week Ending August 15, 2026 Melanie is ramping up for big sales this summer at the store. This week was the sidewalk sale in town, and things were hopping. There were sales throughout the store and a big run on supplies. Thursday, August 13, 2026 OT about basisogeb U 59 There were several small sales paid with cash; create a customer called Daily Sales and post a sales receipt, 2026, for 12 Fresh Flower Bouquets. Jennifer Brown placed an order for Bridal Flowers; she'll come back and pay in 15 days, invoice s bovismil To 2027. Cheque 239 came in the mail to pay the outstanding invoice for H2H Medical Arts for May 29. (790) O Received bill A-175 from Flower Growers Corp for $565 (account/category: Flower Purchases and Supplies). It is due in 30 days. Paid for a delivery of a small cooler and some bottled water to keep on hand; $205.19 with TD VISA card (account/category: Office expenses). me to 196 2010 TIP! You do not need a payee on an Expense form, but it is recommended for ease of reference in the future and for auditing purposes. If you do not want a lot of suppliers in your list, use general suppliers for a more commonly used expense, such as a supplier named "Gas" or "Meals & Entertainment." For our purposes, the office expense above ($205.19) should have no supplier name. Paid for a push broom and bathroom supplies at Office Team with the TD VISA; $117.55 (account/ category: Office expenses). no voyer CHECK FIGURE Your figures from your Balance Sheet should match those shown here as at this date: Account Amount TD Operating Account $3,627.24 0 900 1809 1009s 916910 Undeposited Funds $813.60 GST/HST Payable $-2,008.54 T 00.200.52 od Friday, August 14, 2026 Bryan Fouts stopped in to finally go through with his estimate 1001 for the potted plant program. He needs an invoice and will be back in 15 days to pay. InDomA Wrote cheque 10026 to pay the City of Toronto utilities bill. gnite T Daily Sales for today included 6 Fresh Floral Bouquets and 2 Birthday Vases, all paid by cash. ACW CT Keeping it Kool stopped in for an equipment check on the flower coolers. Their office sends a bill, 85, by email for $56.50 due immediately. Book to Repairs and maintenance account. Received and paid a bill, C-12, from Special Events Superstore. Write cheque 10028 for Supplies and materials in the amount of $412.45. . Mary Beth Dunham needs an invoice, 2030, for a Wedding arrangement for her daughter Sharon's wedding project. Do not forget her credit. now sysos e A Week Ending August 15, 2026 177 CHECK FIGURE Your figures from your Balance Sheet should match those shown here as at this date: Account Amount TD Operating Account $3,069.79 Undeposited Funds $1,288.20 GST/HST Payable $-1,874.64 griquod new id bus acc Saturday, August 15, 2026 boons besig word inst Received a bill from Atlas Planning, 2026-1, for some layout designs for remodeling the back room and adding a bigger event space; for $150; due in 15 days (account/category: Legal and profes- sional fees). Daily sales today were 3 Fresh Flower Bouquets and 3 Birthday Vases paid by debit card and 3 more Fresh Flower Bouquets paid by cash. off no dept of 1916 Mail off cheque 10027 to pay the Chamber of Commerce dues. vtovilob a hot bis9 Placed promotions online with Easy Media Design for upcoming Wreath Workshop; 1-week cover- age for $295, paid by Visa. miot sansux ne no esysq 990 urs not bris shutut tut adt A fresh flower bouquet delivery was late; Lynda Higgs is given a refund back to her credit card from the Undeposited Funds account.ne 10 "360" b laque or ever bluods Make the bank deposit into the TD Operating account for the week's sales in cash and cheques; the deposit should be for $1,440.75. ooidied bas Transfer $633.14 from the Operating account to TD VISA to pay off the balance owing for July 2026. Post the monthly recurring loan payment transfer. Create a Report JnuernA $nu000A AS.100.08 nooA Bois #qQ QT Prepare a Sales by Customer Summary report for Melanie for the week (August 9-15). Total sales should be $2,935.00. A2.800,- day69 T2H\T20 CHECK FIGURE Your figures from your Balance Sheet should match those shown here, as at August 15, 2026: TO ACCOUNT BALANCES 1011001 Account Amount TD Operating Account $3,421.40 TD VISA $617.74 mA/R and A/P BALANCES Statement add lliw b Accounts Receivable (A/R) $4,062.35 Accounts Payable (A/P) $1,359.10 2300 asyid. Balance NOTW 298 ylisd niq GST/HST Payable $-1,867.34 Mood vietaibemuat bub 02.022 101 firms yd,28 asduqu2 101 82001 Super Wu v neq3 mont$1-Did e'noda og gibbsW [sq be Devi Prepare Your Deliverables-Set 1 QGOS S JA yebius? Prepare these reports. Export each to Excel and keep in mind that QuickBooks will create either an .xls or an .xlsx file. Always open the file, enable editing and then save .xls files as .xlsx before submitting to Quick Grader. 9 owi ai zin Sales by Customer Summary report for the week of August 9-15, saved as: 263 082 CH07 Sales by Customer Summary 15-08-26 Transaction Detail by Account report for the week of August 9-15, saved as: CH07 Transactions by Account TD VISA register, saved as: CH07 TD VISA Register 018 sritysbot asina ylieb of Week Ending August 22, 2026 of any sinsis 910 mod Melanie is ready for another great week. She has a big wreath workshop coming up that she is hoping to sell out. Thursday, August 20, 2026 LOC Debit and credit card payments or refunds from last week are deposited into the bank today. DA Sales for the Wreath Workshop are being booked to a new customer, Special Events; five people signed up and paid by credit card; three stopped in and paid for the workshop in cash. David Bell stopped in looking for arrangements for his grandmother's funeral that coming Saturday. He pays with a credit card for two funeral baskets. 92.082 ABIV OT Sharon McColl has called for the full invoice for her program, to be paid immediately, so her program will start September 1. Paid for a one-year subscription to Flowers Forum Magazine with credit card; $24.95. Friday, August 21, 2026 CT 919 A to 193w art tol hoqa yismmu? moja y al 6.91819 Pay Floral, Fauna and Faux over the phone with TD VISA; apply credit before paying. A bill, BBFC-98, from Farm Fresh Flowers arrives for the supplies order from purchase order 1001, for the wreath workshop supplies, due in 15 days. Jaugu grib W Roy Fisher sent in cheque 78, with an apology note for being so late in paying his invoice. Sales for the Wreath workshop tomorrow, posted to the Special Events customer, have filled up w with three people paying by credit card and four with cash. Daily Sales are three Birthday Vases and two Fresh Flower Bouquets, paid by debit. Sharon McColl sends an e-transfer for her invoice, which is deposited right into the operating account. (Create a new payment method if one isn't already there.) Paid all the bills due on or before August 31 from the TD Operating account. (Print cheques later.) Make the bank deposit for monies received the last two days in cash and cheques. The deposit should equal $1,101.75. 401b bloow zais? ylis Saturday, August 22, 2026 Wendy Greenberg's wedding got pushed to October. She popped in to pay 50% of her estimate on the spot with cheque 47. (Hint: This is two steps.) 27AWIA eli xalx. ris to Donated $50 to Sundown Middle School for fundraiser; cheque to print later (account/category: Charitable Donations, Tax exempt). Melanie transfers $500 to the TD Savings account to save for her income taxes. T A bill, 1001, is received from Torrez Lock and Stor for July, August and September 2026 rental in the amount of $254.25, payable in 30 days (category: Prepaid expenses).3782 No daily sales today; the store is closed for the workshop. Melanie makes a payment to the TD VISA from the TD Operating Account for $1,200; use the Pay Down Credit Card form. Print all cheques, starting with cheque 10029. Print to PDF and put in the Chapter 07 folder. CHECK FIGURE Your figures from your Balance Sheet should match those shown here as at August 22, 2026: ACCOUNT BALANCES bel b21 915 A/R and A/P BALANCES 160 Account Amount Statement of Balance 7129162 bengiz TD Operating Account $6,877.60 Accounts Receivable (A/R) $3,553.85 bivad - TD VISA TD Savings vis $30.29 219 Accounts Payable (A/P) mont b $1,500 si 19 101 solovni liul edt 10) balls as looM noted Prepare Your Deliverables-Set 2 QG I tell m ughozsz 189y-900 8 101 bis. Prepare a Sales by Customer Summary report for the week of August 16-22. Export the report to Excel, saving it as: CH07 Sales by Customer Summary 22-08-26 $1,313.06 bus E 10 25ligque 69 how m Week Ending August 29, 2026 que contro se si o Because the Wreath workshop the previous week was such a success, Melanie is offering a Build Your Own Bouquet Workshop this coming Saturday. Until then, it is business as usual and getting ready. dess dilw Thursday, August 27, 2026 All debit and credit card payments from last week are deposited today, in the amount of $1,598.95. Bryan Fouts dropped in and paid his invoice with his debit card. 18910) Receive e-transfer from H2H for the four outstanding June invoices. To no sub allid ad its bisq Called in an order to Farm Fresh Flowers for Flower Purchases and Supplies. Paid $625.88 by credit card so they would drop off today. 20.01.18 1ups bloode Daily Sales are four Birthday Vases and three Bouquets paid by debit, and five Bouquets paid in cash. Four people have signed up for the Build Your Own Bouquet workshop over the phone and paid with credit card. Post to your Special Events customer. 180 QuickBooks Online, Chapter 7: All in a Day's Work! Friday, August 28, 2026 bos The store is closed due to an electrical short. Melanie took the business cell phone home in hopes of handling any incoming calls. Saturday, August 29, 2026 All debit and credit card payments from last week are deposited today, in the amount of $1,327.75. Melanie received five phone calls to reserve a space for the workshop on Friday; three people paid cash when they arrived for the workshop, and the other two paid by credit card. Bill #298 for $565 left in store for emergency repairs and maintenance to electrical on Friday from We Work Space Co. Deposit any cheques and cash, for a total of $937.90. CHECK FIGURE Your figures from your Balance Sheet should match those shown here as at August 29, 2026: ACCOUNT BALANCES A/R and A/P BALANCES Account Amount Statement Balance TD Operating Account $11,555.80 Undeposited Funds $79.10 Accounts Receivable (A/R) $2,062.25 $1,878.06 Accounts Payable (A/P) Prepaid Expenses $2,975 ge Prepare Your Deliverables-Set 3 QG Prepare a Sales by Customer Summary report for the week of August 23-29. Export the report to Excel, saving it as: CH07 Sales by Customer Summary 29-08-26 Tuesday, September 1, 2026 You are working from home to reconcile the bank and credit card accounts, catch up on a few things for Melanie and prepare the month-end financial report. Use the following files from your Chapter 07 folder: CH07 VISA Transactions.csv CH07 TD Savings July.pdf CH07 TD Savings August.pdf CH07 TD VISA August.pdf Perform these tasks: Post the monthly recurring transaction for rent for August and the July and August reallocation of storage rent. Reconcile the TD Savings account for July and August using the statements. There are no monthly fees on this account, but you notice that there was interest earned on the balance each month that you booked at the time of reconciliation to the Interest earned account. reports Import the CSV Visa transactions into QBO and then match the transactions as required. Review any remaining transactions in the list. Record the $113 charge for DANS DELI to Daniel's Deli Delights, category: meals and entertainment, exempt from tax. Reconcile the TD VISA account for August 2026. eliso gnimooni yne gnilbner Create a bank rule to save time when entering the payments for AW Accounting in the future. Use the description AW Accounting. Prepare Your Deliverables-Set 4 QG Prepare these end-of-month reports, exporting each to Excel: 19 Sales by Customer Summary for August 2026, saved as: CH07 Summary August 2026 5 101 69 Jib9 brs Jidab IIA ertori avi bevis991 9inslM erli ol bovins volt edas cja i 119 2022 101 80* lia. Sales by Customer W 90 Balance sheet report for the period as at August 31, 2026, saved as: CH07 Balance Sheet August 2026 199/12 SOS Profit and loss statement for July 1, 2026, through August 31, 2026, saved as: CH07 Profit and Loss Statement August 2026bn \A 230 LA TUA Internets32 Look at the Big Picture A) eldevisne etnuo JnuomA nuoA 08.222.112 Consider these questions (this is not an assessment, but your instructor may want to discuss these issues): 20.818.12 (9\A) UGODA Which suppliers does Melanie owe as of August 31? about betizoqabU onera are,sa 292099x3 bisq919 Which customers owe Melanie as of August 31? aalde neviled quoy 915 and of oqx.es-ES zugu to low sill 101 root 2962 916 a8-80-es you Besa OHO :26 11 gnivea yd 19 919 101 agmidt wat s not bad mon gaihow 918 LOY boombs ainsleM blot TQ quoy mom zelft griwollot uds U vax.ar tbq yut Abq tauguA bq AABJV UT TOHO -