Discussion:Help needed on a really ugly tax return

From TaxAlmanac, A Free Online Resource for Tax Professionals
Note: You are using this website at your own risk, subject to our Disclaimer and Website Use and Contribution Terms.

From TaxAlmanac

Jump to: navigation, search

Discussion Forum Index --> Basic Tax Questions --> Help needed on a really ugly tax return
Discussion Forum Index --> Tax Questions --> Help needed on a really ugly tax return

Actionbsns (talk|edits) said:

3 May 2008
I'm going to try to explain this clearly, but feel free to ask for clarification. I've been working on this return for a month or so. The main problem is that the prior CPA was not using Quickbooks to prepare his TR and his financials don't tie into my QB data file without an adjustment to AAA of $21,847. My problem is where do I book that for the TR? I can put it in distributions, but this client has taken distributions way in excess of basis already and that exascerbates the problem I think. On the personal side, I've temporarily put the excess distributions in as capital gain, but it seems unfair to pay cap gain tax on an amount that is essentially a journal entry to make a couple sets of books balance to each other. The other choice would be to make an adjustment to shareholder basis, but my reason seems funky "To adjust to prior accountant's books". Seems like I might as well put a note on the return that says "please audit me".

The history of the QB data file is that it is about five years old and started life as another corporation. The client created a new corporation effective 01/01/06 and continued using the same data file. They use AR and AP, so the history was still there. On Jan 1 06, they had all their outstanding receivables still waiting to be collected, it didn't make sense to go back and re-enter invoices for the new corp, which BTW is the same business, new name and ID #'s etc. They also brought in some assets and debt from a sole proprietorship they ceased to use at the time of the new corp. When all that filtered into the QB books, in order to tie to the 06 TR, we now have this adjustment.

I would appreciate any thoughts and help in identifying this weird transaction on my TR.

Smokeytax (talk|edits) said:

3 May 2008
Actionbsns -

So, essentially, $21,847 is gone and you don't know what happened to it?

Perhaps you should come up with a starting balance for shareholder's basis from the information you have records for from previously filed tax returns - contributions, distributions, income, loss, etc, and also adjust the starting AAA.

What I'm getting at is your going forward & reporting current & future figures correctly & not try to identify errors from previous years, plus adjusting the starting balances so that they tie into something you can back up with prior tax returns and actual balance sheet amounts.

Does that make any sense?

RJM (talk|edits) said:

3 May 2008
Action-

I had very similar situation and numbers a few years back. Ended up reviewing/adjusting detailed QB accounting for current corp from day 1 to best of my ability, trying to tie to prior year tax returns. QB files from client did not match tax returns prepared by CPA firm (2 tax accountants earlier), and CPA firm refused to provide any reconciling data and worksheets (couldn't believe it). While this was going on, and reviewing current year QB entries for preparation of current returns, I saw that client was not consistently and properly taking medical premiums into his W-2 income. By looking closely at these items from 2001 thru 2002 in QB entries, I was able to recreate nearly exactly the 2001 and 2002 tax return income and balance sheets. The prior accountants were coming up with the right tax numbers, but were not giving prior year adjusting entries to the corporation for updating the QB files. Unfortunately this is a common practice by accountants. I have done it myself with QB clients who are really inept at accounting.... explaining adjusting entries to some clients is so time-consuming it is tempting to just skip it. But I will never skip it in the future !

Smokeytax (talk|edits) said:

3 May 2008
RJM -

That's a really interesting issue. It can be so hard to get paid for adjusting the books for inept clients, so I've started to give all corporate clients a printout of their general ledger and journal entries for each tax return, in addition to the depreciation schedule and any workpapers they might need to recreate the tax returns. It's a big stack of paper, but at least if I get hit by a bus, there's nothing in my workpapers that the client might need.

I just adjust their Quickbooks starting balances each year & go forward.

Southparkcpa (talk|edits) said:

3 May 2008
When this happens, and it happens often enough, I tie out my opening quickbooks BS to the 1120/1065 last year closing balance. Obviously it is problematic if cash, AR and AP are involved. Whatever the difference is I simply book it and I never hit Cash , AR or AP. I take that difference to current year income once I am satisfied that I have done everything possible to get it right. Over the 2 year period, income becomes correct in that method.

Actionbsns (talk|edits) said:

3 May 2008
Thanks for responding. I've done what each of you have suggested, which is to tie into the 06 TR. But then there needs to be reversing entries on 01/01/07 for AR, AP, Accruals, Cash, etc. and that's when the $21,000 becomes a problem. I kind of like Southparks idea of moving it into current year income. I think I'll try that when I get to my office. I'll review my balance sheet items again, but I think they are good (I'm at home right now). I don't think $21,000 is "gone" as Smokey suggests, I really think it's the result of the changeover of corporations and bringing in the sole proprietorship, and I am really unsure of how the other CPA did a few things in his financial program to create the tax return. He's not willing to share his stuff, I've met him before and he's really arrogant. Anyway, it's a combination of issues. I just want my stuff clean so if I need to explain myself on any issue I have the ability to do so. We are moving forward with a clean set of books though if I can just clear up this number.

RoyDaleOne (talk|edits) said:

3 May 2008
Well,

First if the client is keeping the Quickbooks, look for entries in a current period that voids a check, invoice to a customer, or an invoice from a vendor, that was dated in the prior period. QB will place some of this items in the prior year automatically. Second, if you if you record an adjustment in the current year of income or expense you now have the potential for "two" years being incorrect.

If, you must enter the adjustment somewhere,

1. enter then retained earnings, there is no reconciliation provide for in the 1120S, 2. the label can be "prior period adjustment", the label doesn't really matter that much, you would still have to "prove" what it is questioned, by the IRS, client, or the next accountant.

Blrgcpa (talk|edits) said:

3 May 2008
Make certain that your beginning bal on the b/s = the ending balance on the most recent 1120S.

Actionbsns (talk|edits) said:

4 May 2008
When I went back and checked the 2006 data file, payroll taxes were paid for the previous corporation and expensed to Office Payroll Taxes in almost exactly the amount I am off. In addition, the CPA adjusted A/P by almost the same amount, there were three vendors whose amounts due were slightly higher than my $21,000 and that charge doesn't seem to be expensed in 06. So in order to move forward, I made the journal entry to book the 06 adjustments through the AAA account which is pretty much a wash. Then to set A/P to rights in 07, I've adjusted it to COGS, which would represent the three vendors who seem to be overlooked in 06. The ending balance sheet in QB ties to the T/R and my 07 Balance Sheet ties to hard numbers that I can reconcile to. So I think I'm good to go. Thanks again.

To join in on this discussion, you must first log in.