Log in

View Full Version : Work sheet for keystone furniture proyect #39090400


danglo123
Nov 23, 2009, 06:31 AM
I have tried to finish this proyect for five times, and the problem still the same, the figures they give in the book just don't match with the ones I get, eg: pre-adjusted total of asset account in th book is 545,605.92 and my total is 545,827.42, the pre-adjusted total of liabilities accounts from the book is 304,059.79 and my total is 304592.98, the pre-adjusted total of owner's equity from the book and mine is the same 148,664.46, the pre-adjusted total of revenues accounts is the same from the book and mine 968,772.63, the pre-adjusted total of expenses accounts from the book is 875,890.96 and mine is 876,202.65, and my accounts payable balances with the total from the book 26,081.85, and my accounts recievable balances as well with the book totals 15,015.35, I am still off somewere, I will love to get some gidance to find the mistake.
My accounts are ending as follows:
101 bank: started with75,275.27, ended with: 127,347.92.
103 payroll cash: started with 1,000.00, ended with: 1,000.00
105 petty cash: started with 350.00, ended with 350.00
122 accounts payable: started with 17,686.44, ended with 10,015.35
131 merchandise inventory: started with 115,750.00, ended with 115,750.00
141 office suplies: started with 1,500.00, ended with 1,500.00
142 store supplies, Started with 1,459.15, ended with 1,459.15
145 pre-paid insurance: started with 8,100.00, ended with 8,100.00
161 land: started with 8,100.00, ended with 8,100.00
171 building: started with 200,000.00, ended with 200,000.00
171.1 account deppreciation-building: satrted with 20,500.00, ended with 20,500.00
181 store equipment: started with 10,275.00, eneded with 10275.00
181.1 account deppreciation-store equipment: started with: 1,225.00, ended with 1,225.00
182 office equipment: started with 13,525, ended with 13,525.00
182.1 account deppreciation-office equipment: started with 1,850.00, ended with 1,850.00
202 accounts payable: started with 44,939.05, ended with 26,081.85
211 employees fed. Income tax payable: started with 2,475.00 ended with 1555.00
212 social security taxpayable: started with 1,728.74 ended with 2,051.72
213 medicare tax payable: started with 423.92 ended with 239.93
214 employees state income tax payable: started with 965.28 ended with 1,461.66
215 employees city income tax payable: started with 298.26 ended with 463.72
218 sales salary payable: started with 0.00, ended with 0.00
219 office salry payable: started with 0.00,ended with 0.00
221 FUTA tax payable: started with 28.5 ended with 132.36
222 SUTA tax payable: Started with 84.25 ended with 968.74
231 sales tax payable: started with 5,840.29 ended with 7,913.26
241 unearned rent revenue: started with 15,000.00, ended with 15,000.00
251 mortgage payable: started with 250,000.00, ended with 250,000.00 ended with 248,724.74
311 hart lee, capital: started with 175,239.46, ended with 175,239.46
312 hart lee, drawing: started with 21,500.00, ended with 26,575.00
313 income summary: stareted with 0.00, ended with 0.00
401 Sales: started with 849,560.33, ended with 981,972.63
401.1 sales returns and allowances: started with 12,675.00, ended with 13,200.00
412 rent revenue: started with 0.00, ended with 0.00
501 purchases: started with 514,956.00, ended with 553,240.00
501.1 purchase returns and allowances: started with 3,584.45, ended with 6,879.45
501.2 purchase discounts: started with 6,071.03, ended with 7,453.99
502 freight in: started with 10,926.00, ended with 11,806.00
511 sales salaries expense: started with 122,100.00, ended with 133,800.00
512 advertisisng expense: started with 8,369.00, eneded with 9,861.00
513 bank credit card expense: started with 30,115.97, ended with 33,216.56
514 store supplies expense: started with 0.00, ended with 0.00
515 travel and entertaiment expense: started with 2,650.00, ended with 2,687.50
516 cash over short: started with 36.27, ended with 33.52
519 depreciation expense-store equipment: started with 0.00, ended with 0.00
522 office salaries expense: started with 100,320.00, ended with 105,166.00
523 office supplies expense: started with 0.00, ended with 0.00
525 telephone expense: started with 1,750.00, ended with 1,960.80
530 payroll taxes expense: started with 15,109.20, ended with 17,151.91
533 utilities expense: started with 6,978.26, ended with 7,506.81
534 charitable contribution expense: started with 850.00, ended with 850.00
535 insurance expense: started with 0.00, ended with 0.00
540 depreciation expense-building: started with 0.00, ended with 0.00
541 depreciation expense-office equipment: started with 0.00, ended with 0.00
549 miscellaneous expense: started with 527.00, ended with 581.25
551 interest expense: started with 10,950.00, ended with 12,674.74

morgaine300
Nov 27, 2009, 12:10 AM
I don't know if anyone actually has this problem. How long is it and can it be attached to a post? (Like an Excel file or whatever.) It sounds vaguely familiar, but a search here turned up nothing.

meveryscary
Jan 16, 2010, 08:56 AM
I'm having the same problem with that project.
danglo123 please let me know if you were able to solve it.
Thanks