You are the owner of a full-service bookkeeping firm. A new client, Sandy Sweet, comes to you with her accounting files and records and needs help finding and correcting errors. She started a new business, Candies Galore, and decided to do her own bookkeeping. This was more than she could handle along with opening and running the business. She is ready to hire you as the full charge bookkeeper and has brought all of her records to you.

The following is a narrative of the first month's transactions. Her accounting records are linked here: Candies Galore accounting records.

April 1. The owner invested $10,000 in the company, resulting in her receipt of Common Stock. April 2. The owner purchased a computer, shelving, and old fashioned candy jars for $3500 on the account. She got a 12 month no interest credit arrangement and will make monthly payments to the supplier. You decide this will all be equipment. April 3. The owner set up a credit account with a wholesale candy company for inventory, and purchased supplies and candy for $1200 on account. The owner will make a payment for this at month end. The owner appropriately debited inventory for this amount. April 4. The owner purchased a desk chair from a department store for $250, paying cash. This is equipment. April 7. The owner paid for the development of a logo and other advertising materials for the candy shop. She had them printed and had her car painted with the new logo. The owner paid $500 cash for the advertising and appropriately expensed it in the current month. April 8. The owner negotiated a business transaction with a local high school Booster Club to provide candy for football games. The Booster Club paid $200 down to be used against the first month's bill. The owner will bill the Booster Club monthly based on the candy purchased. (Hint: This means the owner has an obligation to either provide candy or give the money back.) April 9. The owner sold candy and was paid cash of $150 through the store register. April 12. The owner sold candy and was paid $400 cash through the store register. April 14. The owner sold candy to a local business and billed them $500. April 22. The owner signed a contract with a social media company to manage her social media accounts. She paid $200. This is a prepaid asset. (Hint: This transaction will use the two following accounts--Cash and Prepaid Advertising. You need to decide how they will be affected.) April 23. The owner also hired a company to design and set up a website, email account, etc. for her company. She paid $240 to register everything and will expense $20 per month against this amount. (Hint: The owner is paying for advertising for a full year today, but will only "use up" $20 of that amount each month--the $20 figure is related to one of the adjusting entries below, and will not be used in this transaction. It is extra information for now.) April 24. The owner wrote a check to herself to cover her rent and car insurance for $1,200. (Remember, when the stockholders receive money from the business, it is called a dividend. The owner doesn't get to call her personal rent and car insurance business expenses--that would be a violation of the business entity concept.) April 30. The owner made her first monthly payment on the equipment she purchased on April 2, $292. (Hint: This is one of the previous charges she made, which she is now paying on account.) April 30.The owner made a payment for inventory to the wholesaler of $75. (Hint: This is one of the previous charges she made, and she is now making a payment on account.) April 30. The owner received a check from the local business for $250 in partial payment of the invoice sent to them on April 14^th. April 30. The owner billed a local bakery for candy sold to them, $1,125. The bakery will be ordering more candy in the future. (This is a new client who has not paid in advance. Treat this as new billing to a customer for services performed.)

Month End Adjusting Entries

1. The depreciation on the equipment is $104.
2. The inventory on hand at the end of the month is $150 (the owner uses a perpetual system and FIFO costing).
3. The social media company sent an invoice stating $175 is left in the owner's prepaid account. (Hint: Of the $200 that she had in the PPD social media account, $25 has now been used).
4. The monthly amount for the website and email account must be expensed. (Hint: Refer to the original entry above for the amount per month to be expensed--remember, she originally paid $240 for these services, now she has used up one month of the service).
5. The owner determined she sold $1,000 worth of candy to the booster club. (Hint: Refer to the entry for clues about what she needs to do in the entry for the restaurant--they have already paid her $200. This entry will affect THREE accounts.)

There are accounting conceptual errors and quantitative/formatting errors in the bookkeeping records of Candies Galore. Find the errors and trace them back to the source transaction. In a Word document, present the following information in a professional manner to the owner of Candies Galore. Use a copy of the Excel document when you make the quantitative and formatting corrections.

1. Make a listing of each error along with the correction needed. Use accounting principles and concepts to support the corrections needed.
2. For each error discuss an internal control procedure that would help prevent the error from happening in the future. Use COSO standards to support your discussion.

Discuss options on how the owner should handle accounts receivables and uncollectible accounts in the future. Use GAAP guidelines and research to support your discussion.

regular entries in black, adjusting entries in blue, closing entries in red \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{CandiesGaloreUnadjustedTrialBalanceApril30,20XX} \\ \hline \multicolumn{2}{|r|}{ Account } & \multicolumn{2}{|c|}{ Debit } & Credit \\ \hline 100 & Cash & $ & 8,243 & \\ \hline 110 & Accounts Receivable & & 1,375 & \\ \hline 120 & Inventory & & 1,200 & \\ \hline 130 & Prepaid Advertising & & 440 & \\ \hline 140 & Equipment & & 3,750 & \\ \hline 200 & Accounts Payable & & & 4,333 \\ \hline 210 & Unearned Revenue & & & 200 \\ \hline 300 & Common Stock & & & 10,000 \\ \hline 310 & Dividends & & 1,200 & \\ \hline 400 & Service Revenue & & & 2,175 \\ \hline 500 & Advertising Expense & & 500 & \\ \hline \multirow[t]{2}{*}{520} & Cost of Goods Sold & & & \\ \hline & & $ & 16,708 & 16,708 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Journal } \\ \hline \multicolumn{2}{|c|}{ Date } & Accounts & Post. Ref & Debit & Credit \\ \hline April & 1 & Cash & 100 & 10,000 & \\ \hline & & Common Stock & 300 & & 10,000 \\ \hline & 2 & Equipment & 150 & 3,500 & \\ \hline & & Accounts Payable & 200 & & 3,500 \\ \hline & 3 & Inventory & 120 & 1,200 & \\ \hline & & Accounts Payable & 200 & & 1,200 \\ \hline & 4 & Equipment & 150 & 250 & \\ \hline & & Cash & 100 & & 250 \\ \hline & 7 & Advertising Expense & 500 & 500 & \\ \hline & & Cash & 100 & & 500 \\ \hline & 8 & Cash & 100 & 200 & \\ \hline & & Unearned Revenue & 210 & & 200 \\ \hline & 9 & Cash & 100 & 150 & \\ \hline & & Service Revenue & 400 & & 150 \\ \hline & 12 & Cash & 100 & 400 & \\ \hline & & Service Revenue & 400 & & 400 \\ \hline & 14 & Accounts Receivable & 110 & 500 & \\ \hline & & Service Revenue & 400 & & 500 \\ \hline & 22 & Prepaid Advertising & 130 & 200 & \\ \hline & & Cash & 100 & & 200 \\ \hline & 23 & Prepaid Advertising & 130 & 240 & \\ \hline & & Cash & 100 & & 240 \\ \hline & 24 & Dividends & 310 & 1,200 & \\ \hline & & Cash & 100 & & 1,200 \\ \hline & 30 & Accounts Payable & 200 & 292 & \\ \hline & & Cash & 100 & & 292 \\ \hline & 30 & Accounts Payable & 200 & 75 & \\ \hline & & Cash & 100 & & 75 \\ \hline & 30 & Cash & 100 & 250 & \\ \hline & & Accounts Receivable & 110 & & 250 \\ \hline & 30 & Accounts Receivable & 110 & 1,125 & \\ \hline & & Service Revenue & 400 & & 1,125 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Journal } \\ \hline \multicolumn{2}{|c|}{ Date } & \multirow{2}{*}{AccountsAdjustingEntries} & \multirow[t]{2}{*}{ Post. Ref } & \multirow[t]{2}{*}{ Debit } & \multirow[t]{2}{*}{ Credit } \\ \hline & & & & & \\ \hline \multirow[t]{11}{*}{ April } & 30 & Depreciation Expense & 510 & 104 & \\ \hline & & Accumulated Depreciation & 155 & & 104 \\ \hline & 30 & Cost of Goods Sold & 520 & 1,050 & \\ \hline & & Inventory & 120 & & 1,050 \\ \hline & 30 & Advertising expense & 500 & 25 & \\ \hline & & Prepaid Advertising & 130 & & 25 \\ \hline & 30 & Advertising Expense & 500 & 20 & \\ \hline & & Prepaid Advertising & 140 & & 20 \\ \hline & 30 & Accounts Receivable & 110 & 800 & \\ \hline & & Unearned Revenue & 210 & 200 & \\ \hline & & Service Revenue & 400 & & 1,000 \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{CandiesGalorePostClosingTrialBalanceApril30,20XX} \\ \hline \multicolumn{2}{|r|}{ Account } & \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{|r|}{ Credit } \\ \hline 100 & Cash & $ & 8,243 & & \\ \hline 110 & Accounts Receivable & & 2,175 & & \\ \hline 120 & Supplies & & 150 & & \\ \hline 130 & Prepaid Advertising & & 395 & & \\ \hline 140 & Equipment & & 3,750 & & \\ \hline 150 & Accumulated Depreciation & & 104 & & \\ \hline 200 & Accounts Payable & & & $ & 4,333 \\ \hline 300 & Common Stock & & & & 10,000 \\ \hline \multirow[t]{2}{*}{320} & Retained Earnings & & & & 276 \\ \hline & & $ & 14,817 & $ & 14,609 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{CandiesGaloreAdjustedTrialBalanceApril30,20XX} \\ \hline \multicolumn{2}{|r|}{ Account } & \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{|r|}{ Credit } \\ \hline 100 & Cash & $ & 8,243 & & \\ \hline 110 & Accounts Receivable & & 2,175 & & \\ \hline 120 & Inventory & & 150 & & \\ \hline 130 & Prepaid Advertising & & 395 & & \\ \hline 150 & Equipment & & 3,750 & & \\ \hline 155 & Accumulated Depreciation & & & $ & 104 \\ \hline 200 & Accounts Payable & & & & 4,333 \\ \hline 300 & Common Stock & & & & 10,000 \\ \hline 310 & Dividends & & 1,200 & & \\ \hline 400 & Service Revenue & & & & 3,175 \\ \hline 500 & Advertising Expense & & 545 & & \\ \hline 510 & Cost of Goods Sold & & 1,050 & & \\ \hline \multirow[t]{2}{*}{530} & Depreciation Expense & & 104 & & \\ \hline & & $ & 17,612 & $ & 17,612 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Journal } \\ \hline \multicolumn{2}{|c|}{ Date } & \multirow[b]{2}{*}{ Service Revenue } & \multirow{2}{*}{\begin{tabular}{|r|} Post. Ref \\ 400 \end{tabular}} & \multirow{2}{*}{Debit3,175} & \multirow[t]{2}{*}{ Credit } \\ \hline April & 30 & & & & \\ \hline & & Retained Earnings & 320 & & 3,175 \\ \hline & 30 & Retained Earnings & 320 & 1,699 & \\ \hline & & Advertising Expense & 500 & & 545 \\ \hline & & Depreciation Expense & 510 & & 104 \\ \hline & & Cost of Goods Sold & 520 & & 1,050 \\ \hline & 30 & Retained Earnings & 320 & 1,200 & \\ \hline & & Dividends & 310 & & 1,200 \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline CanInconFortheMonth & 1130,20 & & CaStatementFortheMont & ngs20xx & & & & CanBalatheMonth & diesGaloreanceSheetEndedApril30,20XX & & \\ \hline Sales Revenue & & $3,175 & Retained Earnings, April 1, 20XX & & $0 & Current Assets: & & & Current Liabilities: & & \\ \hline Cost of Goods Sold & & 1,050 & Net Income for April & $3,576 & & Cash & $8,234 & & Accounts Payable & $4,333 & \\ \hline Gross Margin & & $4,225 & Less: Dividends & 1,200 & & Accounts Receivable & 2,175 & & Total Liabilities & & $4,333 \\ \hline Advertising Expense & $104 & & Net Increase in Retained Earnings & & 2376 & Inventory & 150 & & & & \\ \hline Depreciation Expense & 545 & & Retained Earnings, April 30, 20XX & & $2,376 & Prepaid Advertising & 395 & & Stockholder's Equity: & & \\ \hline Total Expenses & & $649 & & & & & & & Common Stock & 10,000 & \\ \hline Net Income & & $3,576 & & & & Total Current Assets & & $10,954 & Retained Earnings & 0 & \\ \hline & & & & & & Property, Plant \& Equipment: & & & Total Stockholder's Equity & & 10,000 \\ \hline & & & & & & Equipment & 3,750 & & & & \\ \hline & & & & & & Less: Accumulated Depreciation & 104 & & & & \\ \hline & & & & & & Total Property, Plant \& Equipment & & 3,646 & & & \\ \hline & & & & & & Total Assets & & $14,600 & Total Liabilities \& Stockholder's Equity & & $14,333 \\ \hline & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline \end{tabular}