Home Page link  

How do I generate this 2006 tax report?

  
Groups | Search | About
User Password
Register Now! Lost Password?

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
How do I generate this 2006 tax report? Gary 01-08-2007
Posted by Gary on January 8, 2007, 8:20 am
Please log in for more thread options
 I'm using Quicken 2007 H&B. Since I have to pay a quarterly
estimated, I need a quick report that gives me, for each security
and/or payee, annual totals of various categories of transactions that
have tax relevance:

Int inc
Div
ReinvDiv
ReinvST
ReinvLT
Pension Inc
CGLong
CGShort
Tax: Fed
Tax: State
Medical
etc.

I'm aware of the Tax Schedule and Tax Summary reports, but they insist
on generating all the details...not just the totals for each category
for each account, payee, and/or security.

Anyone know of the easiest way to generate these required totals?

Posted by JM on January 8, 2007, 9:07 am
Please log in for more thread options
Gary wrote:
> I'm using Quicken 2007 H&B. Since I have to pay a quarterly
> estimated, I need a quick report that gives me, for each security
> and/or payee, annual totals of various categories of transactions that
> have tax relevance:
>
> Int inc
> Div
> ReinvDiv
> ReinvST
> ReinvLT
> Pension Inc
> CGLong
> CGShort
> Tax: Fed
> Tax: State
> Medical
> etc.
>
> I'm aware of the Tax Schedule and Tax Summary reports, but they insist
> on generating all the details...not just the totals for each category
> for each account, payee, and/or security.
>
> Anyone know of the easiest way to generate these required totals?

The Tax Summary Rept and the Tax Schedule Rept can both be customized
to show totals only [for each category].

Open the Customize window and under the Display tab there is a check
box to 'display 'Totals only'. See if this is closer to what you are
looking for.


Posted by Gary on January 8, 2007, 3:07 pm
Please log in for more thread options


"Totals Only" only gets me partially there. I'm looking for totals
for each Payee x Category. "Totals Only" will give me Payee Totals,
or Category Totals, but not Payee x Category totals (which are
necessary for income tax.

Any further ideas would be genuinely appreciated.


>
>Gary wrote:
>> I'm using Quicken 2007 H&B. Since I have to pay a quarterly
>> estimated, I need a quick report that gives me, for each security
>> and/or payee, annual totals of various categories of transactions that
>> have tax relevance:
>>
>> Int inc
>> Div
>> ReinvDiv
>> ReinvST
>> ReinvLT
>> Pension Inc
>> CGLong
>> CGShort
>> Tax: Fed
>> Tax: State
>> Medical
>> etc.
>>
>> I'm aware of the Tax Schedule and Tax Summary reports, but they insist
>> on generating all the details...not just the totals for each category
>> for each account, payee, and/or security.
>>
>> Anyone know of the easiest way to generate these required totals?
>
>The Tax Summary Rept and the Tax Schedule Rept can both be customized
>to show totals only [for each category].
>
>Open the Customize window and under the Display tab there is a check
>box to 'display 'Totals only'. See if this is closer to what you are
>looking for.

Posted by JM on January 8, 2007, 6:45 pm
Please log in for more thread options
Try this one:

Reports > Cash Flow
Customize for:
Date range
All accounts
Set Rows to display Categories
Columns to display Payees
On Advanced tab check 'Tax-related transactions only'

Are we getting closer?

Gary wrote:
> "Totals Only" only gets me partially there. I'm looking for totals
> for each Payee x Category. "Totals Only" will give me Payee Totals,
> or Category Totals, but not Payee x Category totals (which are
> necessary for income tax.
>
> Any further ideas would be genuinely appreciated.
>
>
> >
> >Gary wrote:
> >> I'm using Quicken 2007 H&B. Since I have to pay a quarterly
> >> estimated, I need a quick report that gives me, for each security
> >> and/or payee, annual totals of various categories of transactions that
> >> have tax relevance:
> >>
> >> Int inc
> >> Div
> >> ReinvDiv
> >> ReinvST
> >> ReinvLT
> >> Pension Inc
> >> CGLong
> >> CGShort
> >> Tax: Fed
> >> Tax: State
> >> Medical
> >> etc.
> >>
> >> I'm aware of the Tax Schedule and Tax Summary reports, but they insist
> >> on generating all the details...not just the totals for each category
> >> for each account, payee, and/or security.
> >>
> >> Anyone know of the easiest way to generate these required totals?
> >
> >The Tax Summary Rept and the Tax Schedule Rept can both be customized
> >to show totals only [for each category].
> >
> >Open the Customize window and under the Display tab there is a check
> >box to 'display 'Totals only'. See if this is closer to what you are
> >looking for.


Posted by Gary on January 8, 2007, 8:19 pm
Please log in for more thread options
You're doing VERY well. I had not remembered that there was a report
for which I could specify a matrix, rows and columns.

Let me also mention that it is a pet peave of mine (toward Quicken,
not you) that they have not come up with a more usable format for
their matrix report. This, for example, would be infinitely more
useful:

Payee1
        Category1        100.00
        Category2        200.00
Payee2
        Category3        300.00
        Category4        400.00
Payee3
        Category5        500.00
        Category6        600.00

rather than

                Payee1        Payee2        Payee3
Category1        100.00 0 0
Category2        200.00         0         0
Category3         0        300.00 0                
Category4         0        400.00 0
Category5         0         0        500.00
Category6         0         0        600.00

especially when the matrices got really big and very sparse.


>Try this one:
>
>Reports > Cash Flow
>Customize for:
>Date range
>All accounts
>Set Rows to display Categories
>Columns to display Payees
>On Advanced tab check 'Tax-related transactions only'
>
>Are we getting closer?
>
>Gary wrote:
>> "Totals Only" only gets me partially there. I'm looking for totals
>> for each Payee x Category. "Totals Only" will give me Payee Totals,
>> or Category Totals, but not Payee x Category totals (which are
>> necessary for income tax.
>>
>> Any further ideas would be genuinely appreciated.
>>
>>
>> >
>> >Gary wrote:
>> >> I'm using Quicken 2007 H&B. Since I have to pay a quarterly
>> >> estimated, I need a quick report that gives me, for each security
>> >> and/or payee, annual totals of various categories of transactions that
>> >> have tax relevance:
>> >>
>> >> Int inc
>> >> Div
>> >> ReinvDiv
>> >> ReinvST
>> >> ReinvLT
>> >> Pension Inc
>> >> CGLong
>> >> CGShort
>> >> Tax: Fed
>> >> Tax: State
>> >> Medical
>> >> etc.
>> >>
>> >> I'm aware of the Tax Schedule and Tax Summary reports, but they insist
>> >> on generating all the details...not just the totals for each category
>> >> for each account, payee, and/or security.
>> >>
>> >> Anyone know of the easiest way to generate these required totals?
>> >
>> >The Tax Summary Rept and the Tax Schedule Rept can both be customized
>> >to show totals only [for each category].
>> >
>> >Open the Customize window and under the Display tab there is a check
>> >box to 'display 'Totals only'. See if this is closer to what you are
>> >looking for.

Similar ThreadsPosted
? generate automatic email November 30, 2007, 3:52 pm
How enter to pay a bill after auto-generate bills? September 29, 2006, 2:42 pm
Report Wont Ask to Create Reconcile Report March 15, 2008, 7:42 pm
Cannot Create New Report From Existing Report December 30, 2007, 3:53 pm
Report Transfers September 4, 2006, 12:15 pm
Reconciliation Report November 2, 2006, 8:50 pm
Tax Summary Report January 5, 2007, 1:51 am
Tax Report Wrong January 13, 2007, 8:50 pm
What's best report for all transactions? January 19, 2007, 1:50 pm
Schedule D Tax Report January 26, 2007, 4:51 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap