Hi , I have done all the journals and entires in general ledgers as well as subsidiary (subsidairy is matching . problem is in unadjusted trial balance which is not matching please help where my mistake is, find the worked excel sheet and also the assignment , just need help in unadjusted trial balance only

Bright Ideas Light Center Alice Peterson, Owner 0201801QZ01A-53 Bright Ideas Light Center Alice Peterson, Owner Accounting Services No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of U.S. Career Institute. Copyright 2013, Weston Distance Learning, Inc. All Rights Reserved. 0201801QZ01A-53 Acknowledgments Author Christine Dunlap Editorial Staff Janet Perry Elizabeth Munson Katy Little Brian Kaufman Carolina Townsend Meloney Biggerstaff Design/Layout Connie Hunsader D. Brent Hauseman Sandy Petersen FOR MORE INFORMATION CONTACT: U.S. Career Institute 2001 Lowe Street Fort Collins, CO 80525 1-800-347-7899 www.uscareerinstitute.edu ii 0201801QZ01A-53 Bright Ideas Light Center, Final Project Table of Contents Final Project Background...................................................................................................................... 1 List of Transactions ........................................................................................................ 1 End-of-the-Week Procedures ......................................................................................... 5 End-of-the-Week Procedures .......................................................................................... 9 End-of-the-Week Procedures ........................................................................................ 13 End-of-the-Week Procedures ........................................................................................ 21 End-of-the-Month Procedures ..................................................................................... 21 End-of-the-Year Procedures ......................................................................................... 22 You've been Asked to Stay! ........................................................................................... 24 Congratulations!............................................................................................................ 26 Chart of Accounts .......................................................................................................... 27 Customers ...................................................................................................................... 28 Creditors ........................................................................................................................ 29 Audit Check Answers .................................................................................................... 29 Previous Year's Statements Previous Year's Statements .......................................................................................... 33 Journals Sales Journal ................................................................................................................. 39 Cash Receipts Journal .................................................................................................. 40 Cash Payments Journal ................................................................................................ 42 Purchases Journal ......................................................................................................... 44 General Journal ............................................................................................................ 45 Checkbook Checks ........................................................................................................................... 53 Bank Reconciliation ...................................................................................................... 74 0201801QZ01A-53 iii Accounting Services General Ledgers General Ledgers ............................................................................................................ 77 Subsidiary Ledgers Accounts Receivable Subsidiary Ledgers................................................................... 107 Accounts Payable Subsidiary Ledgers ....................................................................... 111 Accounting Stationary One Column Accounting Paper .................................................................................. 115 One Column Accounting Paper .................................................................................. 117 One Column Accounting Paper .................................................................................. 119 Two Column Accounting Paper .................................................................................. 121 Two Column Accounting Paper .................................................................................. 123 Three Column Accounting Paper ............................................................................... 125 Three Column Accounting Paper ............................................................................... 127 Three Column Accounting Paper ............................................................................... 129 Tax Forms Schedule A ................................................................................................................... 133 Schedule B ................................................................................................................... 134 Schedule C ................................................................................................................... 135 Short Schedule SE....................................................................................................... 137 1040 .............................................................................................................................. 139 iv 0201801QZ01A-53 Final Project Bright Ideas Light Center Background Alice Peterson, the sole proprietor of Bright Ideas Light Center, established her business 10 years ago. Bright Ideas Light Center provides custom light fixtures for contractors and has recently grown into a large store that offers a wide variety of light fixtures, as well as installations. Ms. Peterson currently has 16 employees: an office manager, a warehouse manager, an accounting services professional, four electricians, five sales persons, two delivery persons and two stockroom persons. Ms. Peterson recently hired you as a temporary accounting services professional. You will fill in while the accounting services professional is on maternity leave. Ms. Peterson has asked you to complete the books for December, 20XX. You Meet Alice Peterson, sole will journalize each of the transactions that have occurred proprietor of Bright Ideas for the month. Ms. Peterson uses the following journals: sales, Light Center. cash receipts, cash payments, purchases and the general journal. Additionally, you will issue checks, enter deposits and maintain the checkbook. At the end of the month, Ms. Peterson will ask you to complete a worksheet, a schedule of accounts receivable and payable and the end-of-the-month financial statements. You should also know that Ms. Peterson contracts with an outside company to generate the company's payroll. However, you will receive a payroll summary on the 15th and the 30th. List of Transactions Enter each of the following transactions into the appropriate journal that follows the list of transactions. (See journals section beginning on page 39.) Make sure you do not duplicate your entries. (Note: Transactions entered into any of the specialized journals are not also entered into the general journal. Enter each transaction once only.) When making your entries, be sure to use specific account titles. You may refer to the Chart of Accounts on page 27 to assist you. Follow the instructions carefully; they will tell you when it's time to post and what needs to be posted. Remember, specialized journal columns only post the total at month-end. 0201801QZ01A-53 1 Accounting Services DECEMBER 1, 20XX Trans. 1 Cash register summary Cash sales merchandise $1,822.41 Sales tax Received on account 91.12 Monique Gonzales Total cash Sales on account 200.00 2,113.53 Robert Max Invoice #14892 $326.82 Sales tax 16.34 Total sale 343.16 Enter the cash sales and the received on account into the cash receipts journal; enter each on its own line. Enter the sale on account into the sales journal. Be sure that Dr = Cr for each transaction entered. The total cash was deposited into the bank account at the close of the day. Make the appropriate adjustments to the checkbook. You will need to follow this same procedure for every cash register summary. Trans. 2 Issued check 281 in the amount of $2,800.53 to First Steamboat Bank for the monthly mortgage payment for the business. $2,000.00 was applied to the principal, and $800.53 was applied to interest. (Be sure to list the principal separate from the interest. Use the Interest Expense account to record the interest.) An example of a compound entry can be found in Lesson 15, Step 12. Trans. 3 Issued check 282 in the amount of $568.42 to Public Service to pay for November utilities. Trans. 4 Issued check 283 in the amount of $5,085.00 to Electrifying Bulb Company to pay for November invoice number 1282. DECEMBER 2, 20XX Trans. 5 Cash register summary Cash sales merchandise $2,942.61 Sales tax Received on account 147.13 Schmidt Contracting Total cash Sales on account Invoice #14893 2 1,193.93 4,283.67 Julie Adams $142.50 Sales tax 7.13 Total sale 149.63 0201801QZ01A-53 Bright Ideas Light Center, Final Project Trans. 6 Issued check 284 in the amount of $352.50 to Office Co. for office supplies invoice 282. (Remember, supplies are an asset when purchased.) Trans. 7 Issued check 285 to Webmasters, Inc. in the amount of $350.52 for maintenance of website. This is an advertising expense. DECEMBER 3, 20XX Trans. 8 Cash register summary Cash sales merchandise $2,892.31 Sales tax 144.62 Received on account 0.00 Total cash Sales on account 3,036.93 Rachel Simpson Invoice #14894 $21.93 Sales tax 1.10 Total sale 23.03 Trans. 9 Issued check 286 to Hospital Texaco for repairs to delivery truck in the amount of $289.89, invoice 652. All expenses related to deliveries will be recorded as Delivery Expense. Trans. 10 Purchased $2,852.00 in resale items from Light House Supply and placed them on our account. Terms 2/15, n/30. Purchase order A75587 was issued. DECEMBER 4, 20XX Trans. 11 Cash register summary Cash sales merchandise $2,234.02 Sales tax Received on account 111.70 Rosebud Designers Total cash Sales on account Invoice #14895 0201801QZ01A-53 1,000.00 3,345.72 Rosebud Designers $120.00 Sales tax 6.00 Total sale 126.00 3 Accounting Services Trans. 12 Issued check 287 to the Steamboat Gazette for the amount of $128.98 for an advertisement in Sunday's newspaper. Trans. 13 Issued check 288 to Edison's, a light bulb supplier for resale items purchased in November, purchase order 28999. The amount of the check was $1,971.75, which includes a 2% discount. The total invoice was $2,011.99. DECEMBER 5, 20XX Trans. 14 Cash register summary Cash sales merchandise $3,082.44 Sales tax 154.12 Received on account 0.00 Total cash Sales on account 3,236.56 Ed Miller Invoice #14896 $592.63 Sales tax 29.63 Total sale 622.26 Trans. 15 Issued check 289 to Mail Ex in the amount of $120.00 for freight on specialty bulbs delivered to the store. Trans. 16 Issued check 290 to Hospital Texaco for gas purchased for delivery trucks in the amount of $389.95. DECEMBER 6, 20XX Trans. 17 Cash register summary Cash sales merchandise $3,189.22 Sales tax 159.46 Received on account 0.00 Total cash Sales on account 3,348.68 Rosebud Designers Invoice #14897 Sales tax 28.84 Total sale 605.60 Sales on account Invoice #14898 4 $576.76 Schmidt Contractors $128.99 Sales tax 6.45 Total sale 135.44 0201801QZ01A-53 Bright Ideas Light Center, Final Project Trans. 18 Purchased $2,150.03 in resale items on account from Starry Night; terms 1/15, n/30. Purchase order 95687 was issued. Trans. 19 A defective lamp was returned by a customer Jan Smith. Check number 291 was issued in the amount of $152.25. This included $145.00 for the sale price, and $7.25 for the sales tax. End-of-the-Week Procedures Give yourself a pat on the back! You've already completed the first week of transactions. Now, complete the following end-of-the-week procedures: 1. Total all the columns in all of the specialized journals. Enter the totals beneath the last entry in the journal. Add the debits and the credits (cross-foot), ensuring that they balance. If you find an error, take time to make a correction. (Do not post these column totals at this point. Wait until the end of the month.) 2. Without posting anything to the cash account, determine its current account balance in the ledger. Add the totals from the cash receipts journal to the current account balance, and subtract the footing from the cash payments journal. Check this balance against your checkbook at the end of the week. They should match. If they do not match, you have an error. Take a few moments to find your error and make the correction. 3. Alice Peterson likes to have up-to-date information on her customers' accounts. Post all accounts receivable transactions into the subsidiary ledger. It is not necessary to post to the general ledger at this time. You will post this amount as a column total at the end of the month. 4. Post all accounts payable transactions into the subsidiary ledger. It is not necessary to post to the general ledger at this time. You will post this amount as a column total at the end of the month. 5. Post all of the entries entered into the other accounts columns from the cash receipts journal and the cash payments journal. 6. Post any entries that may have been made to the general journal. 7. Answer the following audit check questions: a. What are Bright Ideas' total sales for the week? b. What are Bright Ideas' total purchases for the week? c. What is Robert Max's account balance? 8. Check your audit check answers on page 29 of this book. 0201801QZ01A-53 5 Accounting Services DECEMBER 8, 20XX Trans. 20 Cash register summary Cash sales merchandise $2,426.52 Sales tax 121.33 Received on account 0.00 Total cash Sales on account 2,547.85 Monique Gonzales Invoice #14899 $89.99 Sales tax 4.50 Total sale 94.49 Trans. 21 Issued check 292 in the amount of $4,856.76 to First Steamboat Bank. A federal deposit was made for this payroll period. Remember that Bright Ideas separates FICA into Social Security Tax Payable and Medicare Tax Payable. An example of this transaction can be found in Lesson 15. The deposit breaks down as follows: Social Security withholdings $993.79 Medicare withholdings 232.42 Federal income tax withholdings 2,404.34 Employer's contribution to Social Security 993.79 Employer's contribution to Medicare 232.42 DECEMBER 9, 20XX Trans. 22 Cash register summary Cash sales merchandise $3,282.49 Sales tax 164.12 Received on account $0.00 Total cash Sales on account Invoice #14900 6 3,446.61 Schmidt Contracting $1,899.04 Sales tax 94.95 Total sale 1,993.99 Trans. 23 Issued check 293 to Q-cell in the amount of $56.99 for November's use of the cell phone. Trans. 24 Issued check 294 to Steamboat Bell in the amount of $189.99 for November's local phone service. 0201801QZ01A-53 Bright Ideas Light Center, Final Project DECEMBER 10, 20XX Trans. 25 Cash register summary Cash sales merchandise $3,444.89 Sales tax Received on account 172.24 Monique Gonzales Total cash Sales on account 280.42 3,897.55 Ed Miller Invoice #14901 $42.45 Sales tax 2.12 Total sale 44.57 Trans. 26 Issued check 295 in the amount of 1,008.42 to Gecko Insurance Company for six months coverage on the delivery trucks. Premiums are a prepaid asset. Trans. 27 Issued check 296 to First Steamboat Bank for the amount of $282.42 for the deposit of the state income tax withholdings. DECEMBER 11, 20XX Trans. 28 Cash register summary Cash sales merchandise $2,392.88 Sales tax Received on account 119.64 Robert Max Total cash Sales on account 3,012.36 Ed Miller Invoice #14902 $82.99 Sales tax 4.15 Total sale 87.14 Trans. 29 Issued check 297 to Hospital Texaco in the amount of $254.55 for delivery truck gas. Trans. 30 Issued check 298 to Clearly Clean's Window Washing Service for the amount of $32.99. This is considered maintenance. 0201801QZ01A-53 499.84 7 Accounting Services DECEMBER 12, 20XX Trans. 31 Cash register summary Cash sales merchandise $3,499.44 Sales tax 174.97 Received on account 0.00 Total cash Sales on account 3,674.41 Schmidt Contracting Invoice #14903 $242.82 Sales tax 12.14 Total sale 254.96 Trans. 32 Issued check 299 to Light House Supply for resale items purchased in December, purchase order A75587. The amount of the check was $2,794.96, which includes a 2% discount. The total invoice was $2,852.00. Trans. 33 Issued check 300 to Starry Night for resale items purchased in December, purchase order 95687. The amount of the check was $2,128.53, which includes a 1% discount. The total invoice was $2,150.03. DECEMBER 13, 20XX Trans. 34 Cash register summary Cash sales merchandise Sales tax Received on account Total cash Sales on account 8 $2,842.44 142.12 0.00 2,984.56 None Trans. 35 Purchased $3,842.00 in resale items from Light House Supply, terms 2/20, n/30. Purchase order B76584 was issued. Trans. 36 Issued check 301 to First Steamboat Bank in the amount of $852.59 for a note on the delivery trucks. $800.00 was applied to principal and 52.59 to interest. 0201801QZ01A-53 Bright Ideas Light Center, Final Project End-of-the-Week Procedures Now you have made it through the second week. You have accomplished a lot! Please complete the following end-of-the-week procedures. 1. Foot all the columns in all of the specialized journals. Start with the previous footing and add the current weeks entries. You will want to keep a cumulative balance versus a balance for each week. Cross foot for accuracy, and correct any errors you may have. 2. Without posting anything to the cash account, determine its current account balance. Add the footing from the cash receipts journal to the current account balance, and subtract the footing from the cash payments journal. Check this balance against your checkbook. They should match. If they do not match, you have an error. Take some time to figure out your error and make the correction. 3. Post all accounts receivable transactions to the subsidiary ledgers. 4. Post all accounts payable transactions to the subsidiary ledgers. 5. Post all of the entries entered into the other accounts columns from the cash receipts journal and the cash payments journal. 6. Post any entries that may have been made to the general journal. 7. Answer the following audit check questions: a. Check number 295 issued to Gecko Insurance Company was posted to which account? b. What was the purchase discount for Starry Night, purchase order 95687? c. What are the total credit sales for the month thus far? 8. Check your audit check answers on page 29 of this book. DECEMBER 15, 20XX Trans. 37 Cash register summary Cash sales merchandise $3,221.42 Sales tax 161.07 Received on account 0.00 Total cash Sales on account Invoice #14904 0201801QZ01A-53 $3,382.49 Schmidt Contracting $192.47 Sales tax 9.62 Total sale 202.09 9 Accounting Services Trans. 38 Use the following payroll summary produced by Paid-Rite to make the payroll entries for Bright Ideas Light Center. Paid-Rite Payroll Summary Company: Bright Ideas Light Center Payroll period ending: December 15, 20XX Gross Earnings 15,888.49 Social Security 985.09 Medicare Tax 230.38 Federal Inc. Tax 2,383.27 State Inc. Tax 476.65 Net Pay 11,813.10 1. Enter the expense and liabilities generated by this payroll period in the general journal. Record the net pay to salaries payable. Refer to lesson 15 if you need assistance. 2. Make an entry in the general journal to record the employer's contribution to Social Security and to Medicare. Keep in mind, the employer contributes an amount equal to the employee's contribution. 3. Issue check 302 for the total of the net pay to the Bright Ideas Light Center's payroll account. Make an entry in the Other Accounts column to the salaries payable account in the cash payments journal. DECEMBER 16, 20XX Trans. 39 Cash register summary Cash sales merchandise $1,824.42 Sales tax 91.22 Received on account 0.00 Total cash Sales on account 10 1,915.64 None Trans. 40 Issue check 303 in the amount of $56.23 to a customer, Fran Jones, for a defective light fixture that was returned. The original sale was $53.55, and the tax was $2.68. Trans. 41 Issue check 304 in the amount of $80.87 to Office Co. for supplies to be used in the store. 0201801QZ01A-53 Bright Ideas Light Center, Final Project DECEMBER 17, 20XX Trans. 42 Cash register summary Cash sales merchandise $842.44 Sales tax Received on account 42.12 Julie Adams Total cash Sales on account 289.99 1,174.55 Monique Gonzales Invoice #14905 $102.07 Sales tax 5.10 Total sale 107.17 Trans. 43 Issue check 305 to Hospital Texaco for gas purchased for delivery trucks in the amount of $482.65. Trans. 44 Issue check 306 to the Colorado Department of Revenue in the amount of $1,423.82 for sales tax collected for the month of November 20XX. DECEMBER 18, 20XX Trans. 45 Cash register summary Cash sales merchandise $1,642.43 Sales tax 82.12 Received on account 0.00 Total cash Sales on account Invoice #14906 1,724.55 Monique Gonzales $82.37 Sales tax 4.12 Total sale 86.49 Trans. 46 Purchased $5,892.50 in resale items from Light House Supply, terms 2/28, n/30. Purchase order C75657 was issued. Trans. 47 Issued check 307 to Light House Supply for resale items purchased in December purchase order B76584. The amount of the check was $3,765.16, which includes a 2% discount. The total invoice was $3,842.00. 0201801QZ01A-53 11 Accounting Services DECEMBER 19, 20XX Trans. 48 Cash register summary Cash sales merchandise $1,282.99 Sales tax 64.15 Received on account 0.00 Total cash Sales on account 1,347.14 Rosebud Designers Invoice #14907 $802.37 Sales tax 40.12 Total sale 842.49 Trans. 49 Purchased $5,092.00 in resale items from Edison's, terms n/30. Purchase order 87127 was issued. Trans. 50 An investment made by the business matures. Record the principal of $5,000.00, and the interest of $521.22 in the cash receipts journal. Enter the total amount as a cash debit, and make a note of the deposit in the checkbook. (Remember to record the principal separate from the interest. Record the interest as Interest Income.) DECEMBER 20, 20XX Trans. 51 Cash register summary Cash sales merchandise $1,495.00 Sales tax 74.75 Received on account 0.00 Total cash Sales on account Invoice #14908 Robert Max $82.47 Sales tax 4.12 Total sale 86.59 Trans. 52 12 1,569.75 Customer Monique Gonzales returns light bulbs she was unable to use. Alice credits Monique's account for $94.49the total sale. The original sale included $4.50 in sales tax and $89.99 for the bulbs. 0201801QZ01A-53 Bright Ideas Light Center, Final Project End-of-the-Week Procedures Now you have made it through the third week. You are doing great! You only have one more week. Take a few moments to complete the following end-of-the-week procedures. 1. Foot all the columns in all of the specialized journals. Add the previous footing to your current balances. Cross foot for accuracy, and correct any errors you may have. 2. Without posting anything to the cash account, determine its current account balance. Check this balance against your checkbook. They should match. If they do not match, you have an error. Take a few moments to find the error and make the correction. 3. Post all accounts receivable transactions to the subsidiary ledgers. 4. Post all accounts payable transactions to the subsidiary ledgers. 5. Post all of the entries entered into the other accounts columns from the cash receipts journal and the cash payments journal. 6. Post any entries that may have been made to the general journal. 7. Answer the following audit check questions: a. What was the net pay for the payroll period ending December 15, 20XX? b. What is the current balance of the sales tax payable account (only include amounts that have already posted to the ledger)? c. In transaction 50, what three accounts were involved with the recording of this transaction? 8. Check your audit check answers on page 29 of this book. DECEMBER 22, 20XX Trans. 53 Cash register summary Cash sales merchandise $495.85 Sales tax Received on account 24.79 Ed Miller Total cash Sales on account Invoice #14909 0201801QZ01A-53 452.99 973.63 Ed Miller $42.47 Sales tax 2.12 Total sale 44.59 13 Accounting Services Trans. 54 The bank statement has arrived. Record the service charges in the cash payments journal and the interest in the cash receipts journal. Complete a bank reconciliation for Bright Ideas Light Center as of the date the statement is received. See page 74. You can assume that all of the November deposits and checks have cleared. Refer to Lesson14 for the steps to reconcile an account. Also, make the appropriate adjustments to the checkbook. First Steamboat Bank Statement from November 15, 20XX to December 15, 20XX Beginning Balance $18,525.88 Plus 27 Deposits 84,116.12 Minus 45 Withdrawals 73,434.80 Ending Balance 29,207.20 Deposits Date Amount Description Date Amount Description 11-16 $3,448.82 Commercial deposit 12-1 2,113.53 Commercial deposit 11-18 2,894.65 Commercial deposit 12-2 4,283.67 Commercial deposit 11-19 3,764.14 Commercial deposit 12-3 3,036.93 Commercial deposit 11-20 3,021.63 Commercial deposit 12-4 3,345.72 Commercial deposit 11-21 3,789.55 Commercial deposit 12-5 3,236.56 Commercial deposit 11-22 3,644.16 Commercial deposit 12-6 3,348.68 Commercial deposit 11-23 2,457.58 Commercial deposit 12-8 2,547.85 Commercial deposit 11-25 3,384.86 Commercial deposit 12-9 3,446.61 Commercial deposit 11-26 2,336.65 Commercial deposit 12-10 3,897.55 Commercial deposit 11-27 4,533.72 Commercial deposit 12-11 3,012.36 Commercial deposit 11-28 3,006.39 Commercial deposit 12-12 3,674.41 Commercial deposit 11-29 3,283.76 Commercial deposit 12-13 2,984.56 Commercial deposit 11-30 2,213.35 Commercial deposit 12-15 3,382.49 Commercial deposit Other deposits 12-15 14 $25.94 Interest 0201801QZ01A-53 Bright Ideas Light Center, Final Project Checks Date Amount 11-15 $11,917.53 11-16 Check Number Date Amount Check Number 256 11-30 22.80 279 532.50 259* 11-30 3,665.61 280 11-17 668.42 257 12-2 2,800.53 281 11-17 4,085.00 258 12-2 568.42 282 11-17 50.50 260 12-4 128.98 287* 11-18 1,571.75 263* 12-4 5,085.00 283 11-18 120.00 264* 12-4 352.50 284 11-19 289.42 261 12-5 289.89 286+ 11-19 130.22 262 12-5 1,971.75 288 11-19 352.92 265 12-7 120.00 289 11-20 82.92 266 12-7 389.95 290 11-21 1,208.43 270* 12-8 4,856.76 11-21 5,003.42 267 12-8 56.99 293 11-22 56.99 268 12-11 282.42 296* 11-22 203.42 269 12-11 189.99 294 11-23 302.56 271 12-12 1,008.42 295 11-23 256.55 272 12-12 254.55 297 11-23 64.82 276 12-12 2,794.96 299+ 11-24 2,840.24 273 12-13 2,128.53 300 11-24 2,242.62 274 12-15 11,813.10 11-25 852.59 275 11-28 380.87 277 11-29 662.40 278 292+ 302+ + Denotes break in sequence * Denotes break in order Service charge summary 12-15 $752.56 12-15 25.00 0201801QZ01A-53 Credit card processing fee Monthly bank service charge 15 Accounting Services DECEMBER 23, 20XX Trans. 55 Cash register summary Cash sales merchandise $3,295.25 Sales tax Received on account $164.76 Rachel Simpson Total cash $236.42 $3,696.43 Sales on account None Trans. 56 Issued check 308 to Light House Supply for resale items purchased earlier in the month, purchase order C75657. The amount of the check was $5,774.65, which includes a 2% discount. The total invoice was $5,892.50. Trans. 57 Issued check 309 to Clearly Clean's Window Washing Service for the amount of $32.99. DECEMBER 24, 20XX Trans. 58 Cash register summary Cash sales merchandise $2,562.52 Sales tax 128.13 Received on account 0.00 Total cash Sales on account Invoice #14910 Rosebud Designers $142.40 Sales tax 7.12 Total sale 149.52 Trans. 59 16 2,690.65 Alice Peterson returned some defective light fixtures to Light House Supply. She was issued credit memorandum 952 in the amount of $1,282.42. Refer to Lesson 8 for an example of a purchase return on accounts. 0201801QZ01A-53 Bright Ideas Light Center, Final Project Trans. 60 Issued check 310 in the amount of $4,814.21 to First Steamboat Bank. A federal deposit was made for this payroll period. The deposit breaks down as follows: Social Security withholdings $985.09 Medicare withholdings 230.38 Federal Income tax withholdings 2,383.27 Employer's contribution to Social Security 985.09 Employer's contribution to Medicare 230.38 DECEMBER 26, 20XX Trans. 61 Cash register summary Cash sales merchandise $3,861.50 Sales tax 193.08 Received on account 0.00 Total cash Sales on account Invoice #14911 4,054.58 Schmidt Contracting $382.49 Sales tax 19.12 Total sale 401.61 Trans. 62 Ms. Peterson reviewed the accounts receivable accounts and has determined Sandy Shores' account as uncollectible. Bright Ideas does not use an allowance method, so the account will be written off directly. Sandy Shores' account currently has a balance of $425.99. (Hint: Refer to Lesson 7.) Trans. 63 Issued check 311 to Hospital Texaco for gas purchased for delivery trucks in the amount of $452.31. 0201801QZ01A-53 17 Accounting Services DECEMBER 27, 20XX Trans. 64 Cash register summary Cash sales merchandise $4,129.99 Sales tax 206.50 Received on account 0.00 Total cash Sales on account 4,336.49 Robert Max Invoice #14912 $89.99 Sales tax 4.50 Total sale 94.49 Trans. 65 Issued check 312 to Computer World for $1,282.56 for a new computer for the office. (Remember to record this transaction as equipment.) DECEMBER 29, 20XX Trans. 66 Cash register summary Cash sales merchandise $2,898.00 Sales tax 144.90 Received on account 0.00 Total cash Sales on account Trans. 67 18 3042.90 None Issued check 313 to Alice Peterson in the amount of $10,000.00 as a draw from the business. 0201801QZ01A-53 Bright Ideas Light Center, Final Project DECEMBER 30, 20XX Trans. 68 Cash register summary Cash sales merchandise $1,128.39 Sales tax 56.42 Received on account 0.00 Total cash Sales on account $1,184.81 Rosebud Designers Invoice #14913 $142.53 Sales tax 7.13 Total sale 149.66 Trans. 69 Issue check 314 to Office World for the amount of $129.99 for office supplies. Trans. 70 Issued check 315 to Hospital Texaco for gas purchased for delivery trucks in the amount of $222.13. DECEMBER 31, 20XX Trans. 71 Cash register summary Cash sales merchandise Sales tax Received on account Total cash Sales on account 0201801QZ01A-53 $2,388.71 119.44 0.00 2,508.15 None 19 Accounting Services Trans. 72 Use the following payroll summary produced by Paid-Rite to make the payroll entries for Bright Ideas Light Center. Paid-Rite Payroll Summary Company: Bright Ideas Light Center Payroll period ending: December 31, 20XX Gross Earnings 17,022.59 Social Security 1,055.40 Medicare Tax 246.83 Federal Inc. Tax 2,553.39 State Inc. Tax 510.68 Net Pay 12,656.29 1. Enter the expense and liabilities generated by this payroll period in the general journal. Record the net pay to salaries payable. Refer to Lesson 15 if you need assistance. 2. Make an entry in the general journal to record the employer's contribution to Social Security and to Medicare. 3. Issue check 316 for the total of the net pay to the Bright Ideas Light Center's payroll account. Make an entry in the Other Accounts column to the salaries payable account in the cash payments journal. Trans. 73 The petty cash box for Bright Ideas must maintain a balance of $200.00. When you check the box you see there is only $77.58 in the box along with a receipt for store supplies purchased. Issue check 317 to reimburse the petty cash fund in the amount of $122.42. (Remember to use the Cash Payments Journal. Make a debit entry to the Other Accounts Column and a credit to the Cash Column.) Hint: See Lesson 18 for examples. Trans. 74 Issue check 318 to the Steamboat Gazette for the amount of $128.98 for an advertisement in Sunday's newspaper. Trans. 75 Issue check 319 to Steamboat Sanitation Services for the amount of $156.52 for trash removal. Trans. 76 Issue check 320 to Dewy, Chetum, and Howe for the amount of $650.00 for legal services provided to the business. Congratulations! You have completed the last of the transactions. Complete the following end-of-the-week procedures. For simplicity, include the last two days of this month in the fourth week. 20 0201801QZ01A-53 Bright Ideas Light Center, Final Project End-of-the-Week Procedures 1. Foot all the columns in all of the specialized journals. Add the previous footing to your current balances. Cross foot for accuracy, and correct any errors you may have. 2. Without posting anything to the cash account, determine its current account balance. Check this balance against your checkbook. They should match. If they do not match, you have an error. Take some time to find your error and make the correction. 3. Post all accounts receivable transactions. 4. Post all accounts payable transactions. 5. Post all of the entries entered into the Other Accounts columns from the cash payments journal and the cash receipts journal. 6. Post any entries that may have been made to the general journal. 7. Answer the following audit check questions: a. What accounts were used to write-off Sandy Shores' account? b. What is the current balance for the delivery expense account? c. What account was used to record the credit card processing fee? 8. Check your audit check answers on page 29 of this book. End-of-the-Month Procedures 1. Rule the totals from the last footing process. 2. Post the column totals for all of the specialized journals to the appropriate general ledger accounts. Indicate the column has been posted by placing the account number under the column. 3. Verify that all of the individual postings have been made from all of the journals. 4. Figure an account balance for each general ledger account. Lesson 6 is a good review of this procedure. 5. Complete a schedule of accounts receivable. Compare the total with the accounts receivable general ledger account balance. They should match. If they do not match, you have an error. Be sure to find your error and correct it. You can find an example in Lesson 7. 6. Complete a schedule of accounts payable. Compare the total with the accounts payable general ledger account balance. They should match. If they do not match, you have an error and time should be taken to make a correction. 0201801QZ01A-53 21 Accounting Services 7. Start the worksheet by completing columns one and two, the Unadjusted Trial Balance columns. List all of the accounts, including any accounts that may not have a balance. Use your chart of accounts as a guide. Transfer the account balances to the worksheet. Add the Debit and Credit columns. They should have a balance of $1,537,699.42. If they do not, find the error and make the correction. If you have an error, here are some things to take a look at: 1. Did everything get journalized? 2. Are the columns in the specialized journals totaled correctly? 3. Did everything get posted? 4. Are the account balances figured correctly? 5. Were the account balances transferred to the worksheet correctly? 6. Were the columns of the worksheet added correctly? End-of-the-Year Procedures 1. Record the following adjustments to complete columns three and four of the worksheet, the Adjustment columns. Label each adjustment accordingly. Refer to Lesson 12 if you need assistance with this step. a - b. Make the following adjustment to the inventory to record the change to this account over the last accounting cycle. The beginning inventory was $77,800.42, and the ending inventory is $78,223.92. c. In the last accounting cycle, $2,330.65 of the prepaid insurance has expired. Make an adjustment to record the expense incurred in the used coverage. d. An inventory of the office supplies on hand shows a current value of $1,077.23. Make an adjustment to record the expense of the used supplies. e. An inventory of the store supplies on hand shows a current value of $272.32. Make an adjustment to record the expense of the used supplies. f. An assessment of the building, store fixtures and equipment, and delivery equipment shows the following amounts of depreciation for the last accounting cycle. Building $6,422.00 Store fixtures and equipment 778.00 Delivery equipment 2,332.00 Make an adjustment to record the expense of the depreciation to these accounts. 22 0201801QZ01A-53 Bright Ideas Light Center, Final Project g. Record an adjustment for the interest payable on a balloon note due at the end of the year. The note of $5,000.00 at a rate of 9% was taken out at the first of the year to finance a remodeling project. Six months of interest has accrued. Make an adjustment to record the interest expense. h. Record an adjustment for the accrued FUTA taxes, an amount of $4,822.00. Record the adjustment to payroll taxes expense and payroll taxes payable. 2. Add the Adjustments column. The debits and credit should equal. If they do not, take time to make corrections before you continue. 3. Carry over the new balances to columns five and six, the Adjusted Trial Balance columns. 4. Carry over the revenues, expenses and income summary accounts to columns seven and eight, the Income Statement columns. 5. Carry over the assets, liabilities and capital accounts to columns nine and 10, the Balance Sheet columns. 6. Journalize and post the adjusting entries. 7. Prepare an income statement for Bright Ideas Light Center. Use the income statement from the previous year as a guide. (See Previous Year's Statements in the following section.) 8. Prepare a statement of owner's equity for Bright Ideas Light Center. Use the statement of owner's equity from the previous year as a guide. (See Previous Year's Statements in the following section.) 9. Prepare a balance sheet for Bright Ideas Light Center. Use the balance sheet from the previous year as a guide. (See Previous Year's Statements in the following section.) 10. Using your worksheet as a guide, close the revenue and other temporary accounts with a credit balancewith the exception of the income summary account. Make these entries in the general journal. You may refer to Lesson 13 if you need assistance with this procedure. 11. Close the temporary accounts with debit balances, with the exception of the income summary account. 12. Post the first two closing entries. 13. Figure the new balance in the Income Summary Ledger after the adjusting entries and first two closing entries have posted. Using this new balance, make an entry in the general journal to close the income summary account. 14. In the general journal, make an entry to close the drawing account. 0201801QZ01A-53 23 Accounting Services 15. Post the remaining two closing entries. 16. Figure the new balances for any ledgers that had adjusting entries posted to them. Using these balances, prepare a post-closing trial balance sheet. You should include all accounts that have a balance after closing entries post. 17. On January 1, make a reversing entry in the general journal for the adjustment made to interest payable and to payroll taxes payable adjustments g and h. Review this entry in Lesson 22. 18. Post the reversing entries. You've been Asked to Stay! Ms. Peterson has asked you to stay on to complete her personal taxes. The payroll service will complete 940, 941 and W-2s. She has asked you to complete a Schedule A, Schedule B, Schedule C, Short Schedule SE and a 1040 form for her. Use the operating statement you have completed and the personal information listed below to complete these forms for her. Business Address: 123 Main Street Steamboat Springs, CO 80487 EIN: 84-9944556 Personal information: Alice J. Peterson Occupation: Business Owner Address: 2228 Aspen Ct. Steamboat Springs, CO 80487 Phone number: (970) 555-2112 SSN: 521-23-8123 Age: 49 Spouse: John E. Peterson Occupation: Electrician Address: Same Phone number: Same SSN: 521-23-7123 Age: 48 Married, filing jointly. 24 0201801QZ01A-53 Bright Ideas Light Center, Final Project John works for Bright Ideas Light Center and shares in the profits earned by the business. Accounting method: Accrural Use the Income Statement you completed when filling in Schedule C. Be sure to record the net purchases on Line 36. (There was no cost of labor to produce the goods.). Cost method used to calculate inventory. No payments were made that require you to file Form 1099. No material participation. Normally Form 4562 would be completed and submitted with this return; however, as a part of this project we are not requiring the completion of this form. Form 4562 would record the depreciation of the equipment, store fixtures and delivery trucks. It will not be necessary for you to complete part IV of Schedule C because this information would be made available on Form 4562. You will be recording the actual expenses incurred by Bright Ideas Light Center for their delivery trucks, and not the per mileage rate. They are required to do so because they used more than one vehicle for the business. Form 1098 reports $9,600.00 paid in interest on the mortgage of the business, and $828.12 paid in interest on the note. Use this to split the Interest Expense on the Schedule C, Part II. The Petersons did not participate in any foreign investments, or trusts. No dependents No contribution to the presidential election Estimated tax payments for prior year $17,350.00 State and local income taxes paid for year 3,241.00 Real estate taxes paid for the year 2,215.00 Personal property taxes paid for the year Form 1098 interest paid on personal mortgage Charitable contributionscash 328.00 12,892.00 3,400.00 (no single gift of more than $250.00) Health insurance premium for the year (Enter on Form 1040, Line 29 but don't use on Schedule A.) 3,600.00 Insurance provided by the business, not available from any other source. 0201801QZ01A-53 25 Accounting Services Form 1099G, taxable state refund from prior year, Form 1040, Line 10 Taxable interesList on Schedule B Payee Type First Steamboat Bank Interest 65.00 Amount $1,852.00 Be sure to fill out the \"Paid Preparer\" information at the bottom of the 1040 form. Invent a fictitious company and address for the purposes of the form. You may use the following numbers to complete that segment of the project: PTIN EIN P899274353 82-3738393 Congratulations! You have completed the Project! Assemble your project in order. You do not need to include the transactions. Complete the cover sheet and include it with your project. Please do not place the project in a folder, binder or page protectors. You may submit your project in the large envelope provided. 26 0201801QZ01A-53 Bright Ideas Light Center, Final Project Chart of Accounts Assets 101 Cash 105 Petty Cash 110 Short-term Investment 115 Interest Receivable 120 Accounts Receivable 125 Office Supplies 130 Store Supplies 135 Prepaid Insurance 140 Inventory 145 Land 150 Building 155 Accumulative Depreciation Building 160 Store Fixtures and Equipment 165 Accumulative Depreciation Store Fixtures and Equipment 170 Delivery Equipment 175 Accumulative Depreciation Delivery Equipment Liabilities 201 Notes Payable 205 Accounts Payable 210 Salaries Payable 215 Social Security Tax Payable 220 Medicare Tax Payable 225 Federal Income Tax Payable 230 State Income Tax Payable 235 Payroll Taxes Payable 240 Sales Tax Payable 245 Interest Payable 250 Mortgage Payable Owner's Equity 301 Alice Peterson, Equity 305 Alice Peterson, Drawing 310 Income Summary 0201801QZ01A-53 27 Accounting Services Revenue 401 Sales 405 Sales Returns and Allowances 410 Interest Income Expenses 501 Purchases 505 Purchase Returns and Allowances 510 Purchase Discount 601 Freight In 605 Salaries Expense 608 Payroll Tax Expense 610 Telephone Expense 615 Utilities Expense 620 Office Supply Expense 625 Store Supply Expense 630 Delivery Expense 635 Advertising Expense 640 Building Maintenance Expense 645 Insurance Expense 650 Bad Debt Expense 655 Accounting and Legal Expense 660 Bank Service Charge Expense 665 Depreciation Expense 670 Trash Removal Expense 675 Interest Expense Customers Adams, Julie Gonzales, Monique Max, Robert Miller, Ed Rosebud Designs Schmidt Contracting Shores, Sandy Simpson, Rachel 28 0201801QZ01A-53 Bright Ideas Light Center, Final Project Creditors Edison's Electric Electrifying Bulb Co. Light House Supply Starry Night Audit Check Answers Week 1 1. What are Bright Ideas' total sales for the week? $18,072.64 2. What are Bright Ideas' total purchases for the week? $5,002.03 3. What is Robert Max's account balance? $843.00 Week 2 1. Check number 295 issued to Gecko Insurance company was posted to which account? Prepaid Insurance 2. What was the purchase discount for Starry Night, purchase order 95687? $21.50 3. What are the total credit sales for the month thus far? $4,266.92 Week 3 1. What was the net pay for the payroll period ending December 15, 20XX? $11,813.10 2. What is the current balance of the sales tax payable account? $14.43 Dr 3. In transaction 50 what three accounts were involved with the recording of this transaction? Cash, Short-Term Investment, Interest Income Week 4 1. What accounts were used to write-off Sandy Shores' account? Accounts Receivable, Sandy Shores, Bad Debts Expense. 2. What is the current balance for the delivery expense account? $21,891.48 3. What account was used to record the credit card processing fee? Bank Service Charge Expense 0201801QZ01A-53 29 Accounting Services 30 0201801QZ01A-53 Final Project Previous Bright Ideas Year's Light Statements Center 0201801QZ01A-53 31 Accounting Services 32 0201801QZ01A-53 Bright Ideas Light Center, Final Project Previous Year's Statements Bright Ideas Light Center Income Statement Year Ending December 31, 20XX Operating Revenue Sales Less Sales Returns Net Sales Cost of Goods Sold Beginning Inventory Purchases Less: Purchase Returns and Allowances Less: Purchase discounts Net Purchases Total Merchandise Available for Sale Less: Ending Inventory Cost of Goods Sold Gross Profit on Sales Operating Expenses Freight In Salaries Expense Payroll Taxes Expense Telephone Expense Utilities Expense Office Supplies Expense Store Supplies Expense Delivery Expense Advertising Expense Building Maintenance Expense Insurance Expense Bad Debt Expense Accounting and Legal Expense Bank Service Charge Expense Depreciation Expense Trash Removal Expense Total Operating Expenses Net Income from Operations Other Income Interest Income Other Expenses Interest Expense Net Nonoperating Expense Net Income for the Year 0201801QZ01A-53 $809,082.16 9,682.40 $799,399.76 $ 82,592.45 $444,822.42 8,523.55 2,482.46 $433,816.41 $516,408.86 77,800.42 438,608.44 $360,791.32 $300.00 180,950.60 46,029.00 2,963.76 6,821.04 2,000.65 482.00 3,120.52 3,095.52 1,791.76 3,016.84 489.44 300.00 8,000.00 10,482.00 730.72 $270,573.85 $ 90,217.47 $ 1,382.42 11,237.44 $ 9,855.02 $ 80,362.45 33 Accounting Services Bright Ideas Light Center Statement of Owner's Equity Year Ending December 31, 20XX Alice Peterson Equity Ending January 1, 20XX Net Income for Year Less Withdrawals for the Year Increase in Capital Alice Peterson Equity Ending December 31, 20XX 34 $269,246.92 $80,362.45 65,000.00 15,362.45 $284,609.37 0201801QZ01A-53 Bright Ideas Light Center, Final Project Bright Ideas Light Center Balance Sheet December 31, 20XX Assets Current Assets Cash Petty Cash Short-term Investments Accounts Receivable Office Supplies Store Supplies Prepaid Insurance Inventory Total Current Assets Fixed Assets Land Building Less: Accumulated Depreciation Store Fixtures and Equipment Less: Accumulated Depreciation Delivery Equipment Less: Accumulated Depreciation Total Fixed Assets Total Assets Liabilities and Capital Current Liabilities Notes Payable Accounts Payable Salaries Payable Social Security Tax Payable Medicare Tax Payable Federal Income Tax Payable State Income Tax Payable Payroll Tax Payable Sales Tax Payable Interest Payable Total Current Liabilities Long-term Liabilities Mortgage Payable Total Liabilities Owner's Equity Alice Peterson Equity Total Liabilities and Owner's Equity 0201801QZ01A-53 $32,783.26 200.00 5,000.00 4,823.61 600.00 42.00 8,000.00 77,800.00 $129,248.87 $200,000.00 $200,000.00 102,000.00 $50,000.00 20,000.00 $60,000.00 30,000.00 98,000.00 30,000.00 30,000.00 $358,000.00 $487,248.87 $32,892.44 3,482.50 0.00 842.92 202.86 2,389.47 253.92 4,448.23 1,820.00 225.00 $46,557.34 156,082.16 $202,639.50 284,609.37 $487,248.87 35 Accounting Services 36 0201801QZ01A-53 Final Project Journals 0201801QZ01A-53 37 Accounting Services 38 0201801QZ01A-53 Bright Ideas Light Center, Final Project Sales Journal Sales Journal Bright Ideas Light Center Date Invoice 20XX # 0201801QZ01A-53 Customer's Name P/R Accounts Receivable Dr Page 14 Sales Tax Payable Cr Sales Cr 39 Accounting Services Cash Receipts Journal Cash Receipts Journal Bright Ideas Light Center Date 20XX Acct Credited 40 P/R Acct Rec. Cr Sales Tax Payable Cr Sales Cr Page 14 Other Accounts Credit Acct Title P/R Amt. Cash Dr 0201801QZ01A-53 Bright Ideas Light Center, Final Project Cash Receipts Journal Bright Ideas Light Center Date 20XX Acct Credited 0201801QZ01A-53 P/R Acct Rec. Cr Sales Tax Payable Cr Sales Cr Page 15 Other Accounts Credit Acct Title P/R Amt. Cash Dr 41 Accounting Services Cash Payments Journal Cash Payments Journal Bright Ideas Light Center Date Check 20XX No. 42 Page 14 Other Accounts Debit Payee P/R Acct Payable Dr Acct Title P/R Amt Purchase Discount Cr Cash Cr 0201801QZ01A-53 Bright Ideas Light Center, Final Project Cash Payments Journal Bright Ideas Light Center Date Check 20XX No. Page 15 Other Accounts Debit Payee 0201801QZ01A-53 P/R Acct Payable Dr Acct Title P/R Amt Purchase Discount Cr Cash Cr 43 Accounting Services Purchases Journal Purchases Journal Bright Ideas Light Center Date 20XX 44 Acct Credited P/R P.O./ Inv Nbr Page 14 Other Accounts Debit Terms Acct Pay. Cr Purchase Dr Acct Title P/R Amt. 0201801QZ01A-53 Bright Ideas Light Center, Final Project General Journal General Journal Page 18 Bright Ideas Light Center Date Description P/R 1 2 Dr Cr 20XX 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 0201801QZ01A-53 45 Accounting Services General Journal Page 19 Bright Ideas Light Center Date Description P/R 1 2 Dr Cr 20XX 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 46 0201801QZ01A-53 Bright Ideas Light Center, Final Project General Journal Page 20 Bright Ideas Light Center Date Description P/R 1 2 Dr Cr 20XX 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 0201801QZ01A-53 47 Accounting Services General Journal Page 21 Bright Ideas Light Center Date Description P/R 1 2 Dr Cr 20XX 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 48 0201801QZ01A-53 Bright Ideas Light Center, Final Project General Journal Page 22 Bright Ideas Light Center Date Description P/R 1 2 Dr Cr 20XX 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 0201801QZ01A-53 49 Accounting Services 50 0201801QZ01A-53 Final Project Checkbook 0201801QZ01A-53 51 Accounting Services 52 0201801QZ01A-53 Bright Ideas Light Center, Final Project Checks CHECK STUB NO. 281 PAY TO FOR Dollars Cents 22,740 64 BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 281 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 282 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 282 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 0201801QZ01A-53 1576 :0000002566: 53 Accounting Services CHECK STUB NO. 283 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 283 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 284 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 284 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 54 1576 :0000002566: 0201801QZ01A-53 Bright Ideas Light Center, Final Project CHECK STUB NO. 285 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 285 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 286 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 286 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 0201801QZ01A-53 1576 :0000002566: 55 Accounting Services CHECK STUB NO. 287 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 287 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 288 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 288 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 56 1576 :0000002566: 0201801QZ01A-53 Bright Ideas Light Center, Final Project CHECK STUB NO. 289 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 289 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 290 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 290 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 0201801QZ01A-53 1576 :0000002566: 57 Accounting Services CHECK STUB NO. 291 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 291 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 292 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 292 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 58 1576 :0000002566: 0201801QZ01A-53 Bright Ideas Light Center, Final Project CHECK STUB NO. 293 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 293 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 294 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 294 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 0201801QZ01A-53 1576 :0000002566: 59 Accounting Services CHECK STUB NO. 295 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 295 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 296 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 296 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 60 1576 :0000002566: 0201801QZ01A-53 Bright Ideas Light Center, Final Project CHECK STUB NO. 297 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 297 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 298 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 298 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 0201801QZ01A-53 1576 :0000002566: 61 Accounting Services CHECK STUB NO. 299 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 299 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 300 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 300 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 62 1576 :0000002566: 0201801QZ01A-53 Bright Ideas Light Center, Final Project CHECK STUB NO. 301 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 301 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 302 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 302 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 0201801QZ01A-53 1576 :0000002566: 63 Accounting Services CHECK STUB NO. 303 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 303 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 304 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 304 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 64 1576 :0000002566: 0201801QZ01A-53 Bright Ideas Light Center, Final Project CHECK STUB NO. 305 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 305 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 306 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 306 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 0201801QZ01A-53 1576 :0000002566: 65 Accounting Services CHECK STUB NO. 307 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 307 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 308 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 308 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 66 1576 :0000002566: 0201801QZ01A-53 Bright Ideas Light Center, Final Project CHECK STUB NO. 309 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 309 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 310 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 310 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 0201801QZ01A-53 1576 :0000002566: 67 Accounting Services CHECK STUB NO. 311 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 311 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 312 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 312 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 68 1576 :0000002566: 0201801QZ01A-53 Bright Ideas Light Center, Final Project CHECK STUB NO. 313 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 313 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 314 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 314 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 0201801QZ01A-53 1576 :0000002566: 69 Accounting Services CHECK STUB NO. 315 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 315 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 316 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 316 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 70 1576 :0000002566: 0201801QZ01A-53 Bright Ideas Light Center, Final Project CHECK STUB NO. 317 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 317 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 318 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 318 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 0201801QZ01A-53 1576 :0000002566: 71 Accounting Services CHECK STUB NO. 319 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 319 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 320 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 320 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 72 1576 :0000002566: 0201801QZ01A-53 Bright Ideas Light Center, Final Project CHECK STUB NO. 321 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE 321 No. ______ Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 1576 :0000002566: CHECK STUB NO. 322 PAY TO FOR Dollars Cents BALANCE FORWARD DEPOSITS TOTAL AMOUNT THIS CHECK BALANCE No. ______ 322 Bright Ideas Light Center 123 Main Street Steamboat Springs CO 80487 3-4/553 20XX PAY TO THE $ ORDER OF Dollars 1st NATIONAL BANK FOR :081123450 06 1234567 123 0201801QZ01A-53 1576 :0000002566: 73 Accounting Services Bank Reconciliation First Steamboat Bank Bank Reconciliation Ending Checkbook Bal