Just want to chat? Talk some smack. If it doesn't fit into one of the areas below then you'll be posting here (Note: Please try and find the best section before posting here)

Any accountants?

schmedes2
Posts: 109
Joined: 30 Apr 09
Trust:

Any accountants?

I'm asking everyone I can at this point to help me out with this danged problem


1.) fees received in advance from clients and recorded as revenue for which service has not been provided 15,000
2.) Services performed for clients that were not recorded by December 31, 2007 total 20,000
3.) Allowance for doubtful accounts should be increased by 1% of total revenues (after considering 1 and 2)
4.) Insurance expired during the year totals 1,300
5.) Furniture and equipment is being depreciated at 10% of cost a year
6.) On December 1, a 90 day not was signed at 6% for 300,000 shown as note payable. Accrue interest for this note
7.) Rent for the building is 4,000 a month. Rent for 2007 has been paid as well as January 2008
8.) Office salaries earned but unpaid as of 31 December are 3,000
9.) Assume 30% income tax rate and that amounts for revenues and expenses are taxable

Unadjusted trial balance:
DR:
Accounts receivable 340,000
cash: 213,000
furniture and equipment : 137,000
misc. office expense 1,300
office salaries expense 166,000
unexpired insurance: 3,700
utilities expense 6,000
supplies inventory 11,000
rent expense 52,000
CR:
accumulated depreciation 22,000
allowance for doubtful account 2,700
capital stock 100,000
notes payable 300,000
retained earnings 5,300
revenue from consulting fees 500,000

So I have as my adjustments
Revenue 15000
unearned revenue 15000

Accounts receivable 20000
revenue 20000

allowance for doubtful account expense 5050 = (500,000 + 20,000 - 15,000) x 10%
total allowance for doubtful account 5050

insurance expense 1300
unexpired insurance 1300

depreciation expense 13700
accumulated depreciation 13700

interest expense 6000
note payable 6000

rent expense 48,000
prepaid rent 48,000

office salaries expense 3000
office salaries payable 3000

income tax is the kicker. I did 505000 - (169,000 salaries expense + 1300 misc. office expense + 4000 rent expense + 1300 insurance expense + 6000 interest expense + 5050 bad debt expense + 13700 depreciation expense + 6000 utilities expense) = 298650 x .3 = 89595

Now when I add my DR and CR up, they don't match. I get like 1.05 million to 1.12 million

For DR i end up with
accounts receivable 360,000
cash 213,000
Furniture and equipment 137,000
misc. office expense 1300
salaries expense 169,000
rent expense 4000
prepaid rent 48,000
supplies 11,000
unexpired insurance 2400
utilities expense 6000
insurance expense 1300
doubtful account expense 5050
depreciation expense 13,700
income tax 89,595

for cr

accumulated depreciation 35,700
allowance for doubtful accounts 7750
capital stock 100,000
notes payable 306,000
retained earnings 214,355
revenue 505,000
salaries payable 3000


which gives me 1067345 dr and 1171805 cr...obviously I'm a little off somewhere
  • 1
Moderator
evobilly
Posts: 726
Joined: 27 Oct 08
Trust:
lol wah im glad im not a accountent ive read it 3 times and im still lost
  • 1
For the best guide to sell physcal products as a affiliate check out Matt Carters Rapid Profit Formula http://online-income-masters.com/getrapidprofitformula.php

If your having trouble re-writing your articles i recommend checking out this tool to make it quick and easy http://goto2.com/rewriter

If you want to outsource your articles this place seems to be good value and easy to deal with, and its free to sign up they offer a 100% American writing team http://bit.ly/bhv4Fu
 
schmedes2
Posts: 109
Joined: 30 Apr 09
Trust:
lol yea I'm missing something here I just can't find out what
  • 1
cashpro2011
Posts: 51
Joined: 04 May 09
Trust:
In my former life I was a CPA. No really...a real Certified Public Accountant. I'm now a internet marketer. I GLANCED at your account and got a headache.

AR doesnt look right.

Allowance for da doesnt look right. That should offset your ar account
depreciation should be higher because you started with 22k and increased it by 13.7k

This is just glancing at your account info.

After you get this settled, you may want to become an affiliate for Quickbooks...you would make some serious moolah!!!!

Just my 2 cents...

CashPro
  • 1
"In this business you will SELL or be SOLD. Take your pick!"
- CASHPRO
 
PremiumMember
avidpoet
Posts: 162
Joined: 17 Jan 08
Trust:
Now I see why the Partners in the Firm I work for charge in upwards of $450 an hour in fees lol.
  • 1
PremiumMember
graceharman
Posts: 124
Joined: 19 Oct 08
Trust:
You should seriously visit an accountant. They only charge about $800/year to do your tax returns. If you work from home or are a small business, you'll find they save you at least that in tax. I've found my accountant well worth the expense.
  • 1
jasondodd
Posts: 874
Joined: 08 Feb 09
Trust:
With a subject line like that you might attract a few tax investigators instead :)

Accounts are something that really should be outsourced and can often pay for themselves (as Grace mentions).

If you arent already an online accounting software program like Xero is a good investment.
  • 1
Limited time special - Try Affilorama Premium for just $1 for 7 days: http://www.affilorama.com/premium
 
schmedes2
Posts: 109
Joined: 30 Apr 09
Trust:
I figured it out, made a couple of dumb mistakes.

The adjustments for prepaid rent and rent expense were wrong and so was the interest expense and interest payable.

AND then I tried to balance the adjusted trial balance with new net income in it too! Silly me
  • 1
Moderator
wollowra
Posts: 1283
Joined: 14 Mar 08
Trust:
cashpro2011 wrote: I'm now a internet marketer. I GLANCED at your account and got a headache.

CashPro


Wise decision Cash...lol
Now you can pay other CPA's to do your stuff while your sipping cocktail's with me in OZ ( Downunder )..lol

:)
Troy
  • 1
Enjoy the little things, for one day you may look back and realize
they were the big things.

-- Robert Brault
 

This topic was started on Jun 24, 2009 and has been closed due to inactivity. If you want to discuss this topic further, please create a new forum topic.