Export to tax software (ProSeries)...

[mikeker]

Newbie here. I couldn't find anything via search or reading through the subjects of most of the post on this forum so I'll just come right out and ask... Please let me know if I missed a FAQ somewhere. <grin>

I'm trying to export my QB data into ProSeries (ProSeries is the only Intuit product that does Form 990's -- non-profit tax reporting). The problem is that my program services income and expenses are in a couple parent accounts with many sub-accounts. When this is brought into ProSeries, each sub-account gets a line in the Form 990, which makes for a huge mess.

What I want to do is roll-up all the sub-accounts into the parent account and have the parent account exported to ProSeries. Does anyone have any ideas on how to go about this? Or am I trying to do this all wrong?

I'm pretty new to this product, so any help you can offer would be greatly appreciated!

TIA,

Mike

[Joey]

Have you contacted Proseries support?

PS: They don't charge for support.

[mikeker]

Yes, I contact ProSeries support and they said that there's nothing that can be done on their end of it. They said to figure out if there is some way of rolling the information up in Quickbooks and importing that.

Perhaps setting up a separate account?

Bottom line is that I can enter the info by hand, but it really defeats the purpose...

Any other ideas?

Thanks.

[Joey]

Please be aware that the tax software packages do help with the math part of the tax return but you still have to enter a lot of information that does not automatically transfer from the accounting program. Even in the corporate program for Proseries, it only transfers the income and expense accounts and part of the Balance Sheet numbers. You still have to know what other amounts to enter yourself (such as the equity accounts and the M1 and M2 amounts). It doesn't just transfer all amounts and the return is complete. It doesn't transfer carryovers, beginning Balance Sheet balances or depreciation amounts. That's what concerned me when you said that not being able to import the Quickbooks amounts "defeats the purpose" of the tax program. It doesn't take long at all to enter the amounts from your adjusted trial balance into Proseries without importing anything. You also need to know the other data to enter also. Just having a tax program won't do the return for you and insure correctness. Believe me, I'm a tax professional and I've used Proseries since 1993.

[mikeker]

Sorry I was kinda vague about my "defeats the purpose" comment. While I'd love a tax prep package that would do everything for me, I realize that's a pipe dream.

The "purpose" I was talking about was that I spent all this time setting up the Tax Line entries for all my service program income/expense accounts and then found that they were useless in importing all that information. That's compounded by the fact that there's a bug (feature?) in ProSeries that if you break a link between an entry in ProSeries and a QB account, it erases your Tax Line entry for those accounts. So the first time I tried to edit the entries in ProSeries, it mangled my QB file (fortunately, I'd backed it up beforehand).

Joey, Thanks for your quick replies on this matter. I appreciate your help. From what I'm understanding, there's no way to do the parent account roll-ups (for lack of a better term: rolling sub-account information up into a parent account similar to a Summary Report) in QB and have that available for export.

I'm sorry if I'm not making sense with my terminology. I'm very new to QB and accounting in general. Please feel free to contact me at ed@discnw.org if you need any clarification about what I'm trying to do.

Thanks again!

[beachviewthomas]

Are you interested in selling your 1993 Proseries Tax Software? If so, contact me at oceanviewthomas@aol.com. Thank you.

Please be aware that the tax software packages do help with the math part of the tax return but you still have to enter a lot of information that does not automatically transfer from the accounting program. Even in the corporate program for Proseries, it only transfers the income and expense accounts and part of the Balance Sheet numbers. You still have to know what other amounts to enter yourself (such as the equity accounts and the M1 and M2 amounts). It doesn't just transfer all amounts and the return is complete. It doesn't transfer carryovers, beginning Balance Sheet balances or depreciation amounts. That's what concerned me when you said that not being able to import the Quickbooks amounts "defeats the purpose" of the tax program. It doesn't take long at all to enter the amounts from your adjusted trial balance into Proseries without importing anything. You also need to know the other data to enter also. Just having a tax program won't do the return for you and insure correctness. Believe me, I'm a tax professional and I've used Proseries since 1993.