Catherine Mallers

RSS

Recent Posts

QuickBooks and Windows Vista

Contributed by Catherine Mallers - Posted: February 21st, 2007

So are you enjoying the MAC vs PC commercials lately?  Here is some additional info about QuickBooks and Windows Vista direct from QuickBooks.

 Since QuickBooks 2006 and earlier versions were developed and released before the introduction of Windows Vista, these versions may be adversely affected when used on a computer running Windows Vista. This will impact Simple Start, Basic, Pro, Premier, Payroll and Point of Sale, as well as other QuickBooks products and services. We recognize that your QuickBooks software is an important business tool and apologize for any inconvenience this may cause you. If you choose to upgrade to Windows Vista, We recommend that you use QuickBooks 2007 (and Point of Sale v6.0, if applicable). QuickBooks 2007 is the only version of the software built to run on the new Windows Vista operating system.

email E-mail to a friend print Printer-friendly view
Permalink | Leave Comment | Attachments (0) | Images (0) |


Excel Keyboard Tips

Contributed by Catherine Mallers - Posted: February 15th, 2007

Have you ever been working diligently on your computer and just wish you could do your work faster?  There are a lot of keyboard shortcuts that you can use to make your life easier.  For those of you who use the mouse, this is probably going to be a little challenging. 

EDITING WORKSHEETS

Copy                                                           Ctrl + C

Cut                                                               Ctrl + X

Paste                                                           Ctrl + V

Copy Formula Above Cell                           Ctrl + `

Copy Value Above Cell                               Ctrl + Shift + ’

Undo                                                           Ctrl + Z

Redo                                                           Ctrl + Y

Repeat Last Command                                F4

Find                                                             Ctrl + F

Find Again                                                   Ctrl + F4

Replace                                                       Ctrl + H 

MANAGING YOUR WORKBOOK

Create New File                                          Ctrl + N

Open A File                                                 Ctrl + O

Print File                                                      Ctrl + P

Save File                                                     Ctrl + S 

FORMATTING YOUR WORKSHEET

Center Text                                                 Ctrl + E

Justify                                                           Ctrl + J

Left Align                                                      Ctrl + L

Right Align                                                   Ctrl + R

Apply Currency Format                               Ctrl + Shift + $

Apply Date Format                                       Ctrl + Shift + #

Apply Number Format                                 Ctrl + ~

Apply Percentage Format                            Ctrl + %

Apply Scientific Number                               Ctrl + ^

Apply Time Format                                      Ctrl + Shift + @

Clear                                                          Del

Hide Columns                                              Ctrl + 0

Hide Row(s)                                                Ctrl + 9

Insert Current Date                                      Ctrl + ;

Insert Current Time                                      Ctrl + Shift + ; 

NAVIGATING YOUR WORKSHEET

Go To                                                          Ctrl + G

Up One Screen                                           PgUp

Down One Screen                                       PgDn

Move to Cell A1                                           Ctrl + Home

Move to Last Used Cell                                Ctrl + End

Move to Column A                                       Home

Next Worksheet                                           Ctrl + PgDn

Previous Worksheet                                     Ctrl + PgUp 

SELECTING ITEMS IN YOUR WORKSHEET

Select All                                                      Ctrl + A

Select Entire Row                                        Shift + Spacebar

Select Entire Column                                    Ctrl + Spacebar

email E-mail to a friend print Printer-friendly view
Permalink | Comments (4) | Attachments (0) | Images (0) |


Latest Update on PMI deduction

Contributed by Catherine Mallers - Posted: February 15th, 2007

Bill H.R. 6111 was passed through the House December 8 and the Senate on December 9.  The President signed the bill around December 20, and is now known as Public Law Number 109-432.  As of January 25th, a final printed copy of the bill had not been produced the Government Printing Office.

Here is the verbiage from the bill.  –Premiums paid or accrued for qualified mortgage insurance by a taxpayer during the taxable year in connection with acquisition indebtedness with respect to a qualified residence of the taxpayer shall be treated for purposes of this section as interest which is qualified residence interest.

The following information is copied directly from Mortgage News Daily.

We are relying on information on the law as signed by President Bush provided by BNA Tax Management a tax advisory site. According to BNA the following restrictions apply to what seemed like a general deduction for homeowners for private mortgage insurance premiums. These may have come about during conferences to resolve differences between House and Senate versions or may have been earlier defined by Section 6050H of the IRS Code to which Section 419 was appended.

The Act defines qualified mortgage insurance as that provided by the VA, the FHA, or the Rural Housing Administration or by private carriers and specifies that it be treated as interest on a qualified residence. This, however, is modified by the following “that premiums paid or accrued for qualified mortgage insurance by a taxpayer during the taxable year in connection with acquisition indebtedness.” This is interpreted by BNA as meaning that the deduction is only available to homeowners who assume PMI payments during 2007. In other words, you may not qualify for the deduction if you bought a house subject to PMI in 2006 or earlier even though you are currently paying premiums.

Deductions seem to be further limited to 2007 by the following: no benefit will currently accrue to taxpayers for any amount paid or accrued beyond December 31 of this year “or properly allocable to any period after that date.” We are not lawyers or tax authorities and we advise you, strongly, to consult your own tax professional, but it appears that this deduction is only available to taxpayers during the current calendar year and that paying premiums ahead as taxpayers are often advised to do with mortgage interest or property taxes at year end when deductions are needed will not work in this situation.

As we stated in our earlier article, the original House and Senate legislation was income-limited to $100,000 per household (or $50,000 for married homeowners filing separately) ? a provision that appeared to disappear from the bill that was finally voted on in December. BNA, however, states that this provision did survive into the final version and that the allowable deduction for PMI is phased out by 10 percent for each $1000 the taxpayers adjusted gross income exceeds $100,000 (or every $500 above $50,000 for the married who file separately.) This would mean that the deduction is not available for anyone with adjusted income exceeding $110,000 or $55,000.

So, it appears that few homebuyers will be eligible to use this PMI deduction and that it will only be available for 12 months. It seems strange that Congress would pass such limited legislation and interpretations could be different as corresponding IRS regulations are written. Still, if you buy a house or refinance this year make a mental note to alert your tax advisor to check on this small perk before you file for the tax year ending December 31, 2007.

email E-mail to a friend print Printer-friendly view
Permalink | Leave Comment | Attachments (0) | Images (0) |