Home Page link  

Help: Est Taxes Applied from Prior Year - How to handle in Quicken?

 

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
Help: Est Taxes Applied from Prior Year - How to handle in Quicken? Margaret 08-05-2007
Posted by Margaret on August 5, 2007, 1:18 pm
Please log in for more thread options
I'm using QP2007. 2006 was the first year that I was required to pay
estimated tax payments. So I created two subcategories to handle this:

Tax:MI1040-ES and Tax:US1040-ES and applied the appropriate tax line
item assignments.

Last year I overpaid both state and US taxes by a few hundred dollars
and at tax filing time, just had the overage applied to 2007, thereby
reducing the size of my estimated tax payments for this year.

For my 2007 quarterly payments, I've set up each transaction using a
split, whereby the full amount due is a positive amount, and the amt
applied from 2006 is a negative amount. (Same categories for each
split.) This, of course, means that although the transactions look
fine, the tax reports are wrong, because they only show the amount
actually paid in 2007 (reduced by the amount paid in 2006).

BTW, the feds applied my entire overage to my first payment, but the
state broke it out over several payments, so my April payment for the
state ended up being $0.

Any input on how I should handle this situation in Quicken so it's
properly documented in my reports ... esp come tax time? I've looked
through the category list and the corresponding tax line item
assignments, but I can't find anything related to overpayment of
estimated taxes, just underpayment.

TIA and Regards,

Margaret


Posted by JM on August 5, 2007, 6:13 pm
Please log in for more thread options
wrote:
> I'm using QP2007. 2006 was the first year that I was required to pay
> estimated tax payments. So I created two subcategories to handle this:
>
> Tax:MI1040-ES and Tax:US1040-ES and applied the appropriate tax line
> item assignments.
>
> Last year I overpaid both state and US taxes by a few hundred dollars
> and at tax filing time, just had the overage applied to 2007, thereby
> reducing the size of my estimated tax payments for this year.
>
> For my 2007 quarterly payments, I've set up each transaction using a
> split, whereby the full amount due is a positive amount, and the amt
> applied from 2006 is a negative amount. (Same categories for each
> split.) This, of course, means that although the transactions look
> fine, the tax reports are wrong, because they only show the amount
> actually paid in 2007 (reduced by the amount paid in 2006).
>
> BTW, the feds applied my entire overage to my first payment, but the
> state broke it out over several payments, so my April payment for the
> state ended up being $0.
>
> Any input on how I should handle this situation in Quicken so it's
> properly documented in my reports ... esp come tax time? I've looked
> through the category list and the corresponding tax line item
> assignments, but I can't find anything related to overpayment of
> estimated taxes, just underpayment.
>
> TIA and Regards,
>
> Margaret

Part of your problem with this situation is that QW only looks at the
calendar year in compiling tax data.

Haven't completely wrung this out but some thoughts here to hopefully
lead to a solution.

One way to get around this might be to create a "Holding Account".
Using the overpayment of Fed taxes as an example;
Credit the Holding Acct with the 06 overpayment - dated 12/31/06.
Debit the Holding Acct when estimated payments are made in 07.
The amount of the debit will be the amount of the 06 overpayment that
is applied.
In the end, the Holding Acct will zero out.

For the state, the situation might be slightly different.
Question - Is the 06 state overpayment actually equivalent to a state
refund and therefore reportable in your 07 Fed return??
The answer here might alter the approach slightly - but would be
similar to the handling of the Fed taxes.
Seems one might credit the Holding Acct [dated 01/01/07] with the
amount of the state 06 overpayment and with the category and tax line
assignment for a reportable state refund.
Then debit the Holding Acct for the estimated payments.

Have not dealt with your situation but have a similar dilema with
taxable dividends [or other distributions] received in Jan but
reportable for the prior tax year. I use the Holding Acct approach to
properly record these events - and satisfy QW's calendar year
restrictions.


Posted by Laura on August 5, 2007, 7:46 pm
Please log in for more thread options
> wrote:
>> I'm using QP2007. 2006 was the first year that I was required to pay
>> estimated tax payments. So I created two subcategories to handle this:
>>
>> Tax:MI1040-ES and Tax:US1040-ES and applied the appropriate tax line
>> item assignments.
>>
>> Last year I overpaid both state and US taxes by a few hundred dollars
>> and at tax filing time, just had the overage applied to 2007, thereby
>> reducing the size of my estimated tax payments for this year.
>>
>> For my 2007 quarterly payments, I've set up each transaction using a
>> split, whereby the full amount due is a positive amount, and the amt
>> applied from 2006 is a negative amount. (Same categories for each
>> split.) This, of course, means that although the transactions look
>> fine, the tax reports are wrong, because they only show the amount
>> actually paid in 2007 (reduced by the amount paid in 2006).
>>
>> BTW, the feds applied my entire overage to my first payment, but the
>> state broke it out over several payments, so my April payment for the
>> state ended up being $0.
>>
>> Any input on how I should handle this situation in Quicken so it's
>> properly documented in my reports ... esp come tax time? I've looked
>> through the category list and the corresponding tax line item
>> assignments, but I can't find anything related to overpayment of
>> estimated taxes, just underpayment.
>>
>> TIA and Regards,
>>
>> Margaret
>
> Part of your problem with this situation is that QW only looks at the
> calendar year in compiling tax data.
>
> Haven't completely wrung this out but some thoughts here to hopefully
> lead to a solution.
>
> One way to get around this might be to create a "Holding Account".
> Using the overpayment of Fed taxes as an example;
> Credit the Holding Acct with the 06 overpayment - dated 12/31/06.
> Debit the Holding Acct when estimated payments are made in 07.
> The amount of the debit will be the amount of the 06 overpayment that
> is applied.
> In the end, the Holding Acct will zero out.
>
> For the state, the situation might be slightly different.
> Question - Is the 06 state overpayment actually equivalent to a state
> refund and therefore reportable in your 07 Fed return??
> The answer here might alter the approach slightly - but would be
> similar to the handling of the Fed taxes.

Yes, this is actually a refund of the 06 taxes received in 07 but part of it
is applied to the 07 estimated taxes. I would code that "refund" as a normal
deposit with a 07 date (since it was received in 07) so that it appears on
the 07 reports.

> Seems one might credit the Holding Acct [dated 01/01/07] with the
> amount of the state 06 overpayment and with the category and tax line
> assignment for a reportable state refund.
> Then debit the Holding Acct for the estimated payments.
>
> Have not dealt with your situation but have a similar dilema with
> taxable dividends [or other distributions] received in Jan but
> reportable for the prior tax year. I use the Holding Acct approach to
> properly record these events - and satisfy QW's calendar year
> restrictions.
>


Posted by NEWSGROUPS on August 6, 2007, 11:54 am
Please log in for more thread options

> wrote:
>>>>>>>>>>>>>>>>>SNIP<<<<<<<<<<<<<<<<<<<<<<<<<<<<>
> One way to get around this might be to create a "Holding Account".
> Using the overpayment of Fed taxes as an example;
> Credit the Holding Acct with the 06 overpayment - dated 12/31/06.
> Debit the Holding Acct when estimated payments are made in 07.
> The amount of the debit will be the amount of the 06 overpayment that
> is applied.
> In the end, the Holding Acct will zero out.
>
>>>>>>>>>>>>SNIP<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

ELEGANT !!

Jay



Posted by Margaret on August 6, 2007, 7:45 pm
Please log in for more thread options
Thanks for the suggestions, everyone. I think this year (if I happen to
have overpaid again, which I doubt), I will simply take the refund and
pay the estimated taxes as they come due. In the meantime, I already
have categories for both state and US tax refunds from prior year. I
believe I can dispense with a holding account if I record the refund
"deposit" on the same day as the estimated taxes were paid. I'll have
to play around with it. But thanks for this bit of info. I should be
able to get my reports correct now. :-)

Regards,

Margaret

Similar ThreadsPosted
Flexible Spending Account - prior year to current year switchover January 13, 2007, 7:42 pm
Quicken - foreign taxes not downloaded February 12, 2008, 5:00 pm
How do I handle Stock Splits in Quicken? December 29, 2006, 10:15 pm
How does Quicken 2007 handle options? February 20, 2007, 2:01 pm
Quicken Year end copy??? June 4, 2007, 7:54 pm
Year-end entries Quicken 2007 January 5, 2008, 12:25 am
Quicken Year End Copy 2008 Not Working January 6, 2008, 1:56 pm
Filing taxes April 20, 2006, 9:10 pm
Accounting for S-Corp taxes August 24, 2007, 2:15 am
1041 Estate Taxes January 27, 2008, 8:19 am

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