Monday, November 21, 2011

October 2011 Remote Accountant Tax Blog Post



Year End Tax Saving Ideas For Individuals
There are a number of steps you might take by year-end to cut your 2011 tax bill, such as deferring income, accelerating deductions and capital gains planning.

Deferring Income
  • If you are planning on selling an investment this year on which you have a gain, it may be best to wait until the following tax year to defer payment of the taxes for another year (subject to estimated tax requirements).
  • If you are expecting a bonus at year-end, you may be able to defer receipt of these funds until January. This allows you to defer tax payments (other than the portion normally withheld) until the following year. However, keep in mind that you usually defer taxes on a bonus that is contractually due in 2011.
  • If your company grants stock options, it may be wise to wait until next year to exercise the option or sell stock acquired by exercise of an option. Exercise of the option is often but not always a taxable event; sale of the stock is almost always a taxable event.
  • If you're self employed, and can afford the delay in cash inflow, defer sending invoices or bills to clients or customers until the end of December.
Caution: Keep an eye on the estimated tax requirements.
Accelerating Deductions
  • Pay a state estimated tax installment in December instead of at the January due date. However, make sure the payment is based on a reasonable estimate of your state tax.
  • Pay your entire property tax bill, including installments due in year 2012, by year-end. This does not apply to mortgage escrow accounts.
  • Try to bunch "threshold" expenses, such as medical expenses and miscellaneous itemized deductions. Threshold expenses are deductible only to the extent they exceed a certain percentage of adjusted gross income (AGI). By bunching these expenses into one year, rather than spreading them out over two years, you have a better chance of exceeding the thresholds, thereby maximizing your deduction.

    For example, you might pay medical bills and dues and subscriptions in whichever year they would do you the most tax good.
Caution: In most cases, credit cards charges are considered paid in the year of the charge regardless of when you pay on the card. This, however, does not apply to store revolving credit cards, so if you charge expenses on a Wal-Mart store credit card, the deduction can not be claimed until the bill is paid.

In cases where tax benefits are phased out over a certain adjusted gross income (AGI) amount, a strategy of deferring income and accelerating deductions may also allow you to claim larger deductions, credits, and other tax breaks for 2011. The latter benefits include Roth IRA contributions, conversions of regular IRAs to Roth IRAs, child credits, higher education tax credits and deductions for student loan interest.

Tip: Deferring income into 2012 is an especially good idea for taxpayers who anticipate being in a lower tax bracket next year, generally because of much-reduced income or much-increased deductible expenses.
Tip: It may pay to accelerate income into 2011 if you think your marginal tax rate will be much lower this year than it will be next year.
Tip: If you know you have a set amount of income coming in this year that is not covered by withholding taxes, increasing your withholding before year-end can avoid or reduce any estimated tax penalty that might otherwise be due.
On the other hand, the penalty could be avoided by covering the extra tax in your final estimated tax payment and computing the penalty using the annualized income method.

If you have any questions about estimated taxes, please call us.

Caution: Alternative Minimum Tax (AMT) no longer just impacts the wealthy! Do not overlook the effect of any year-end planning moves on the AMT for 2011.
Due to tax changes in recent years, AMT impacts many more taxpayers than ever before because the tax is not indexed to inflation. As a result, growing numbers of middle-income taxpayers have been finding themselves subject to this higher tax.
Items that may affect AMT include the deductions for state property taxes and state income taxes, miscellaneous itemized deductions, and personal exemptions.

Note: AMT Exemption Amounts For 2011

  • $48,450 for single and head of household fliers;
  • $74,450 for married people filing jointly and for qualifying widows or widowers, and
  • $37,225 for married people filing separately.

Please call us if you'd like more information or if you're not sure whether AMT applies to you. We're happy to assist you.

Residential Energy Tax Credits

If you haven't taken advantage of energy tax credits for your home, 2011 is your last chance. The credits--10% of cost up to $500 or a specific amount from $50 - $300--expire on December 31, 2011 and only apply to improvements in an existing home that is your principal residence. New construction and rentals do not qualify.

The tax credits are as follows:
  • Energy Star window tax credit: up to $200 maximum
  • Water heater tax credit (includes electric, natural gas, propane, or oil): up to $300 maximum
  • Air conditioner tax credit: up to $300 maximum
  • Insulation, doors, and roof credits: up to the $500 cap
  • Furnace tax credit (includes natural gas, propane, oil, or hot water): $150 maximum. Efficiency must be 95% (up from 90% before the extension)
Caution: Taxpayer is ineligible for this tax credit if this credit has already been claimed by the taxpayer in an amount of $500 in any previous year.
Make Charitable Contributions

You can donate property as well as money to a charity. You can generally take a deduction for the fair market value of the property; however, for certain property, the deduction is limited to your cost basis. While you can also donate your services to charity, you may not deduct the value of these services. You may also be able to deduct charity-related travel expenses and some out-of-pocket expenses however.

Keep in mind that a written record of charitable contribution is required in order to qualify for a deduction. A donor may not claim a deduction for any contribution of cash, a check or other monetary gift unless the donor maintains a record of the contribution in the form of either a bank record (such as a cancelled check) or written communication from the charity (such as a receipt or a letter) showing the name of the charity, the date of the contribution, and the amount of the contribution.

Tip: Contributions of appreciated property (i.e. stock) provide an additional benefit because you avoid paying capital gains on any profit.
Investment Gains And Losses

Minimize taxes on investments by judicious matching of gains and losses. Where appropriate, try to avoid short-term gains, which are usually taxed at a much higher tax rate (up to 35%) than long-term gains, which in 2011 and 2012 are taxed at rates of zero and 15 percent depending on your tax bracket. Consider where feasible to reduce all capital gains and generate short-term capital losses up to $3,000 as well.
Tip: If you have a large capital gain this year, consider selling an investment on which you have an accumulated loss. Capital losses up to the amount of your capital gains plus $3,000 per year ($1,500 if married filing separately) can be claimed as a deduction against income.
Tip: After selling securities investment to generate a capital loss, you can repurchase it after 30 days. If you buy it back within 30 days, the loss will be disallowed. Or you can immediately repurchase a similar (but not the same) investment, e.g., another mutual fund with the same objectives as the one you sold.
Tip: If you have losses, you might consider selling securities at a gain and then immediately repurchasing them, since the 30-day rule does not apply to gains. That way, your gain will be tax-free, your original investment is restored and you have a higher cost basis for your new investment (i.e., any future gain will be lower).
Note: The maximum long term capital gains tax rate is currently 15 percent and will expire on December 31, 2012 when it's set to rise to a maximum of 20 percent. Also of note is that starting in 2013, a 3.8 percent medicare tax may also be applied to long term capital gains. This information is something to think about as you plan your long term investments.
Feel free to call us if you need assistance with any of your long term planning goals.
Mutual Fund Investments

Before investing in a mutual fund, ask whether a dividend is paid at the end of the year or whether a dividend will be paid early in the next year but be deemed paid this year. The year-end dividend could make a substantial difference in the tax you pay.
Example: You invest $20,000 in a mutual fund at the end of 2011. You opt for automatic reinvestment of dividends. In late December of 2011, the fund pays a $1,000 dividend on the shares you bought. The $1,000 is automatically reinvested.
Result: You must pay tax on the $1,000 dividend. You will have to take funds from another source to pay that tax because of the automatic reinvestment feature. The mutual fund's long-term capital gains pass through to you as capital gains dividends taxed at long-term rates, however long or short your holding period.
The mutual fund's distributions to you of dividends it receives generally qualify for the same tax relief as long-term capital gains. If the mutual fund passes through its short-term capital gains, these will be reported to you as "ordinary dividends" that don't qualify for relief.
Tip: Wait until after the dividend to buy the shares because the share net asset value will drop after the dividend is paid. Alternatively, buy the shares in 2011, but opt to take the dividend in cash instead of having it reinvested.
In spite of these tax consequences, it may be a good idea to buy shares right before the fund goes ex-dividend. For instance, the distribution could be relatively small, with only minor tax consequences. Or the market could be moving up, with share prices expected to be higher after the ex-dividend date.
Tip: To find out a fund's ex-dividend date, call the fund directly.
Call us if you'd like more information on how dividends paid out by mutual funds affect your taxes.

Year-End Giving To Reduce Your Potential Estate Tax

For many, sound estate planning begins with lifetime gifts to family members. in other words, gifts that reduce the donor's assets subject to future estate tax. Such gifts are often made at year-end, during the holiday season, in ways that qualify for exemption from federal gift tax.

Gifts to a donee are exempt from the gift tax for amounts up to $13,000 a year per donee.

Caution: An unused annual exemption doesn't carry over to later years. To make use of the exemption for 2011, you must make your gift by December 31.

Husband-wife joint gifts to any third person are exempt from gift tax for amounts up to $26,000 ($13,000 each). Though what's given may come from either you or your spouse or from both of you, both of you must consent to such "split gifts".

Gifts of "future interests", assets that the donee can only enjoy at some future time such as certain gifts in trust, generally don't qualify for exemption; however, gifts for the benefit of a minor child can be made to qualify.

Tip: If you're considering adopting a plan of lifetime giving to reduce future estate tax don't hesitate to call us. We can help you set it up.

Cash or publicly traded securities raise the fewest problems. You may choose to give property you expect to increase substantially in value later. Shifting future appreciation to your heirs keeps that value out of your estate. But this can trigger IRS questions about the gift's true value when given.

You may choose to give property that has already appreciated. The idea here is that the donee, not you, will realize and pay income tax on future earnings, and built-in gain on sale.

Gift tax returns for 2011 are due the same date as your income tax return. Returns are required for gifts over $13,000 (including husband-wife split gifts totaling more than $13,000) and gifts of future interests. Though you are not required to file if your gifts do not exceed $13,000, you might consider filing anyway as a tactical move to block a future IRS challenge about gifts not "adequately disclosed".

Tip: Call us if you're considering making a gift of property whose value isn't unquestionably less than $13,000.

Income earned on investments you give to children or other family members is generally taxed to them, not to you. In the case of dividends paid on stock given to your children, they may qualify for the reduced 5% dividend rate.
Caution: In 2011, investment income for a child (under age 18 at the end of the tax year or a full-time student under age 24) that is in excess of $1,900 is taxed at the parent's tax rate.
Other Year-End Moves

Retirement Plan Contributions. Maximize your retirement plan contributions. If you own an incorporated or unincorporated business, consider setting up a retirement plan if you don't already have one. (It doesn't need to actually be funded until you pay your taxes, but allowable contributions will be deductible on this year's return.)

If you are an employee and your employer has a 401(k), contribute the maximum amount ($16,500 for 2011 and $17,000 for 2012, plus an additional catch up contribution of $5,500 if age 50 or over, assuming the plan allows this much and income restrictions don't apply).

If you are employed or self-employed with no retirement plan, you can make a deductible contribution of up to $5,000 a year to a traditional IRA (deduction is sometimes allowed even if you have a plan). Further, there is also an additional catch up contribution of $1,000 if age 50 or over.

Health Savings Accounts. Consider setting up a health savings account (HSA). You can deduct contributions to the account, investment earnings are tax-deferred until withdrawn, and amounts you withdraw are tax-free when used to pay medical bills.

In effect, medical expenses paid from the account are deductible from the first dollar (unlike the usual rule limiting such deductions to the excess over 7.5% of AGI). For amounts withdrawn at age 65 or later, and not used for medical bills, the HSA functions much like an IRA.

To be eligible, you must have a high-deductible health plan (HDHP), and only such insurance, subject to numerous exceptions, and must not be enrolled in Medicare. For 2011, to qualify for the HSA, your minimum deductible in your HDHP must be at least $1,200 (single coverage) or $2,400 (family). It remains unchanged for 2012.

Summary

These are just a few of the steps you might take. Please contact us for help in implementing these or other year-end planning strategies that might be suitable to your particular situation.


Year-End Tax Planning for Businesses
There are a number of end of year tax strategies businesses can use to reduce their tax burden for 2011. Here's the lowdown on some of the best options.

Purchase New Business Equipment


Section 179 Expensing. Business should take advantage of Section 179 expensing this year for a couple of reasons. First, is that starting in tax year 2010 and continuing into tax year 2011, the maximum Section 179 expense deduction for equipment purchases increased to $500,000 ($535,000 for qualified enterprise zone property) and the bonus depreciation increased to 100% for qualified property. Beginning in tax year 2012 however, the Section 179 deduction is scheduled to drop to $125,000 and the bonus depreciation to be reduced to 50 percent and then be phased out completely.
In other words, in 2011 businesses can elect to expense (deduct immediately) the entire cost of most new equipment up to $500,000 (subject to a dollar-for-dollar reduction in that $500,000 for property placed in service that exceeds the maximum amount of $2,000,000).
Qualified property is defined as property that you placed in service during the tax year and used predominantly (more than 50 percent) in your trade or business. Property that is placed in service and then disposed of in that same tax year does not qualify, nor does property converted to personal use in the same tax year it is acquired.
Note: Many states have not matched these amounts and, therefore, state tax may not allow for the maximum federal deduction. In this case, two sets of depreciation records will be needed to track the federal and state tax impact.
Please contact our office if you have any questions regarding qualified property and bonus depreciation.




Timing. If you plan to purchase business equipment this year, consider the timing. You might be able to increase your tax benefit if you buy equipment at the right time. Here's a simplified explanation:

Conventions. The tax rules for depreciation include "conventions" or rules for figuring out how many months of depreciation you can claim. There are three types of conventions. To select the correct convention, you must know the type of property and when you placed the property in service.

  1. The half-year convention: This convention applies to all property except residential rental property, nonresidential real property, and railroad gradings and tunnel bores (see mid-month convention below) unless the mid-quarter convention applies. All property that you begin using during the year is treated as "placed in service" (or "disposed of") at the midpoint of the year. This means that no matter when you begin using (or dispose of) the property, you treat it as if you began using it in the middle of the year.
  2. Example: You buy a $40,000 piece of machinery on December 15. If the half-year convention applies, you get one-half year of depreciation on that machine.
  3. The mid-quarter convention: The mid-quarter convention must be used if the cost of equipment placed in service during the last three months of the tax year is more than 40% of the total cost of all property placed in service for the entire year. If the mid-quarter convention applies, the half-year rule does not apply, and you treat all equipment placed in service during the year as if it were placed in service at the midpoint of the quarter in which you began using it.
  4. The mid-month convention:

    This convention applies only to residential rental property, nonresidential real property, and railroad gradings and tunnel bores. It treats all property placed in service (or disposed of) during any month as placed in service (or disposed of) on the midpoint of that month.
  5. If you're planning on buying equipment for your business, call us first. We'll help you figure out the best time to buy it to take full advantage of these tax rules.

    Other Year-End Moves To Take Advantage Of

    Partnership or S Corporation Basis. Partners or S corporation shareholders in entities that have a loss for 2011 can deduct that loss only up to their basis in the entity. However, they can take steps to increase their basis to allow a larger deduction. Basis in the entity can be increased by lending the entity money or making a capital contribution by the end of the entity's tax year.
    Caution: Remember that by increasing basis, you're putting more of your funds at risk. Consider whether the loss signals further troubles ahead.
    Retirement Plans. Self-employed individuals who have not yet done so should set up self-employed retirement plans before the end of 2011. Call us today if you need help setting up a retirement plan. Dividend Planning. Reduce accumulated corporate profits and earnings by issuing corporate dividends to shareholders, which continue to be taxed at the 15 percent rate through 2012. Budgets. Every business, whether small or large should have a budget. The need for a business budget may seem obvious, but many companies overlook this critical business planning tool. A budget is extremely effective in making sure your business has adequate cash flow and in ensuring financial success. Once the budget has been created, then monthly actual revenue amounts can be compared to monthly budgeted amounts. If actual revenues fall short of budgeted revenues, expenses must generally be cut.
    Tip: Year-end is the best time for business owners to meet with their accountants to budget revenues and expenses for the following year.
    For more on this topic, see the article below about common budgeting errors, but if you need help developing a budget for your business don't hesitate to call us today.

    Call Us First

    These are just a few of the year-end planning tax moves that could make a substantial difference in your tax bill for 2011. But the best advice we can give you is to give us a call. We'll sit down with you, discuss your specific tax and financial needs, and develop a plan that works for your business.
    Retirement Contributions Limits and Other Tax Benefits for 2012
    The IRS has announced the maximum contribution limits for your 401(k) and other retirement plans for 2012. In general, many of the pension plan limitations will change for 2012 because the increase in the cost-of-living index met the statutory thresholds that trigger their adjustment. However, other limitations will remain unchanged. Highlights include:
    1. Individuals Limits for 401(k): Annual compensation limit $250,000 in 2012 (up from $245,000 in 2011); maximum annual contribution $17,000 in 2012 (up from $16,500 in 2011) with a $5,500 contributions for age 50 and older.
    2. Savings Incentive Match Plan for Employees (SIMPLE): Contribution limit $11,500 with a $2,500 catch up clause for age 50 and older. Remains unchanged from 2011.
    3. Individual Retirement Plans (IRAs): Maximum contribution $5,000 with a $1,000 catch up contribution for those age 50 and older. The contribution can be split between a Roth IRA and a traditional IRA, but must not exceed $6,000. Remains unchanged from 2011.

    Looking Ahead to 2012

    The value of each personal and dependent exemption will increase $100 to $3,800 in 2012. The new standard deduction is $11,900 in 2012 for married couples filing jointly. Individuals and married people filing separately will see the standard deduction rise to $5,950 and the standard deduction for head of household rises to $8,700. Nearly two out of three taxpayers take the standard deduction, rather than itemizing deductions. Annual gift tax exclusion remains at $13,000 in 2012. The basic exclusion from estate tax amount increases to $5,120,000, from $5,000,000 in 2011
    Three Most Common Budgeting Errors
    When it comes to creating a budget, it's essential to estimate your spending as realistically as possible. Here are three budget-related errors commonly made by small businesses, and some tips for avoiding them.
    1. Not Setting Goals. It's almost impossible to set spending priorities without clear goals for the coming year. It's important to identify, in detail, your business and financial goals and what you want or need to achieve in your business.
    2. Underestimating Costs. Every business has ancillary or incidental costs that don't always make it into the budget--for whatever reason. A good example of this is buying a new piece of equipment or software. While you probably accounted for the cost of the equipment in your budget, you might not have remembered to budget time and money needed to train staff or for equipment maintenance.
    3. Failing to Adjust Your Budget. Don't be afraid to update your forecasted expenditures whenever new circumstances affect your business. Several times a year you should set aside time to compare budget estimates against the amount you actually spent, and then adjust your budget accordingly.
    Call our office if you want to discuss setting up a budget to meet your business financial goals. We're happy to help.
    Income from Foreign Sources
    Many U.S. citizens earn money from foreign sources. But unless it is exempt under federal law, taxpayers sometimes forget that they have to report all such income on their tax return. U.S. citizens are taxed on their income regardless of whether they live inside or outside the United States. The foreign income rule also applies regardless of whether the person receives a Form W-2, Wage and Tax Statement, or Form 1099. Foreign source income includes earned and unearned income, such as:
    • Wages and tips
    • Interest
    • Dividends
    • Capital gains
    • Pensions
    • Rents
    • Royalties
    But there is some good news. Citizens living outside the United States may be able to exclude up to $92,900 of their 2011 foreign source income if they meet certain requirements. This will increase to $95,100 in 2012. If you're married and you and your spouse both work abroad and meet either the bona fide residence test or the physical presence test, each of you can choose the foreign earned income exclusion. Together, you can exclude as much as $185,800 for the 2011 tax year.
    Caution: The exclusion does not apply to payments made to U.S. government employees or folks in the military living outside the United States.
    If you earn income from outside the country, please be sure to meet with us about it. We can advise you on how to address all of the tax implications of this situation.
    Check Your Withholdings
    With less than two months remaining in the calendar year, it's a great time to double check your federal withholding to make sure enough taxes are being taken out of your pay. The average refund for 2010 was just over $3,000. Although in part due to tax credits associated with the economic stimulus package, it's still an increase of nearly 10 percent from the previous year. In addition, even though the Making Work Pay Tax Credit lowered tax withholding rates in 2010 for millions of American households, some workers and retirees still need to take steps to make sure enough tax is being taken out of their checks. Certain folks should pay particular attention to their withholding. These include:
    • Married couples with two incomes
    • Individuals with multiple jobs
    • Dependents
    • Some Social Security recipients who work
    • Workers who do not have valid Social Security numbers
    • Retirees who receive pension payments
    Taxpayers who wind up owing too much tax because not enough money was withheld from their paychecks during 2011 may qualify for special relief on a penalty that sometimes applies. Depending on their personal situation, some people could have less withheld from their paychecks than they need or want. Failure to adjust withholding could result in potentially smaller refunds or, in limited instances, a taxpayer may owe tax rather than receive a refund next year. If you're not sure how much you need to withhold from your paycheck, just give us a call and we'll figure it out with you.
    Expanded Adoption Credit
    The Affordable Care Act raises the maximum adoption credit to $13,360 per eligible child in 2011, up from $13,170 in 2010. It also makes the credit refundable, meaning that eligible taxpayers can get it even if they owe no tax for that year. In general, the credit is based on the reasonable and necessary expenses related to a legal adoption, including adoption fees, court costs, attorney's fees, and travel expenses. In order to claim the credit or refund however, your modified adjusted gross income (MAGI) must be less than $225,210. If you adopted a child this year, you may be eligible for this credit. Make sure you contact us early, though. To claim this tax relief, we must file a paper return, which means your refund will be slower than if you could file electronically.
    QuickBooks 2012: Better Financial Management
    As it usually does this time of year, Intuit has introduced new versions of its Pro and Premier products. QuickBooks 2012 promises to help you get better organized, save steps, and acquire more in-depth financial insights. The new Express Start is designed for businesses that want to blast through setup and start entering customers and invoices. You have two other options though. Advanced Setup is the old EasyStep interview that solicits more details. You can also open an existing file or convert data from Quicken or other accounting software. Express Start requires minimal input. Company name, industry, company type, tax ID, and contact information is all that's required. After you save your company file, it lets you start adding or importing customers/vendors/employees, products/services, and bank accounts. Figure 1: Express Start simplifies company setup

    An Activity-Driven Calendar

    QuickBooks' Reminders keep you apprised of each day's tasks, but they don't provide any information about the past or future. QuickBooks 2012 solves this problem with its new Calendar. When you enter an appointment, to-do, or key business task (invoices, bills, purchase orders, etc.), it appears in the calendar. You can display a graphical view of the month that tallies activities for each day and lists them below. Daily and weekly views are in list form and links open the original documents. Figure 2: The new Calendar displays daily, weekly, and monthly views of your financial transactions

    Save Excel Formatting

    Once you've formatted a QuickBooks report in Excel, it's frustrating to have to reformat it each time you run it for different time periods and/or with your ever-changing content. Excel Integration Refresh simplifies this process. You can now export a report to Excel, make formatting changes and save them, and then reapply them later to the same type of report using different date ranges and your updated QuickBooks data. Acceptable alterations include:
    • Row and column header font formatting
    • New formulas
    • Renamed column and row headers, and report titles
    • Resized columns
    • Inserted columns and rows
    • Inserted formula text
    You can do this by opening your report in QuickBooks and clicking Update an existing worksheet, or by launching your report in Excel and clicking the QuickBooks tab on the toolbar, then the Update Report button. Figure 3: This window opens when you click Update Report in Excel

    A New Report Community

    There's always room for more report formats. QuickBooks 2012 offers a library of Contributed Reports, variations created either by Intuit or your fellow users. You can select one of these, like Customer Sales By Quantity By Item Detail and instantly populate it with your own data. You can sort these templates by industry and rating, and view them as a list, in a grid, or in the Report Center's Carousel view.

    Centralized Operations

    QuickBooks 2012 also saves you time with its new Centers. The Inventory Center works similarly to those available for customers, vendors, and employees. It's a clearinghouse of item records and transactions that can be viewed and sorted. You can also do inventory housekeeping tasks here, like adding items and launching transactions. The Lead Center helps you carefully track new leads that you either paste in from Excel or enter manually. You can add to-dos and notes to contact records, and convert them into customers.

    Upgrading Can Be Tricky

    Intuit has included other, smaller time-saving organizational and reporting tools in QuickBooks 2012, like One-Click Transactions, which lets you create related transactions from existing ones (i.e., invoice to credit memo) with one click. There's nothing especially difficult about using most of QuickBooks 2012's new features. But upgrading and setup are sometimes quirky, and the Excel Integration Refresh tool has a learning curve. We're happy to help you start your company file on the right foot or get acclimated to this latest version. Figure 4: Track your leads and convert them into customers in the new Lead Center
    Financial Tips for November 2011
    Make Gifts to Minimize Estate Taxes Consider making gifts before year-end to minimize estate taxes. For example, you can give away $13,000 a year to a donee ($26,000 if you are married and your spouse elects to participate) without having to pay the gift tax, thereby reducing your estate tax liability. Year-End Tax Review Meeting Estimate your taxes due for the year, and set up an appointment with us to determine what steps you should take before year-end to minimize negative tax consequences. Review October's Budget vs. Actuals Compare October income and expenditures with your budget. Make adjustments as appropriate to your November expenditures. Make sure you have invested your planned savings amount for October.

Saturday, September 3, 2011

September 2011 Remote Accountant Tax Blog Post

If you're conscientious about financial reporting, you may already have a sense of your company's worth, but in some instances you might need a formal business valuation, such as:


  • For certain transactions. Selling your business? Planning an IPO? Need financing?
  • For tax purposes. Includes estate planning, stock option distribution, and S Corporation conversions.
  • For litigation. Needed in cases like bankruptcy, divorce, and damage determinations.

There isn't a single formula for valuing a business, but there are generally-accepted measures that will give you a valid assessment of your company's worth. Here are some tips that will help you get a more accurate business valuation.

  1. Take a close look at how your business operates. Does it incorporate the most tax-efficient structure? Have sales been lagging or are you selling most of your merchandise to only a few customers? If so, then consider jump-starting your sales effort by bringing in a seasoned consultant.

    Do you have several products that are not selling well? Maybe it's time to remove them from your inventory. Redesign your catalog to give it a fresh new look and make a point of discussing any new and exciting product lines with your existing customer base.


    It might also be time to give your physical properties a spring cleaning. Even minor upgrades such as a new coat of paint will increase your business valuation.

  2. Keep in mind that business valuation is not just an exercise in numbers where you subtract your liabilities from your assets, it's also based on the value of your intangible assets.


    It's easy to figure out the numbers for the value of your real estate and fixtures, but what is your intellectual property worth? Do you hold any patents or trademarks? And what about your business relationships or the reputation you've established with existing clients and in the community? Don't forget about key long-term employees whose in-depth knowledge about your business also adds value to its net worth.

  3. Choose your appraisal team carefully. Don't try to do it yourself by turning to the Internet or reading a few books. You may eventually need to bring in experts like a business broker and an attorney, but your first step should be to contact us. We have the expertise you need to arrive a fair valuation of your business.


    If you need a business valuation for whatever reason, give us a call today.

Should You Invest in Life Insurance?

The purpose of life insurance is to provide a source of income, in case of death, for your children, dependents, or other beneficiaries. (Life insurance can also serve certain estate planning purposes, which we won't go into here.)


Buying life insurance is contingent upon whether anyone is depending on your income after your death. If you have a spouse, child, parent, or some other individual who depends on your income, then you probably need life insurance.


Because life insurance protects your family in the event of a death, it is important to determine the correct amount. Most people do not have the right amount of insurance.

There are two basic types of life insurance: term and permanent. Term insurance is insurance that covers a specified period. If you die within this time frame, your beneficiary receives the insurance benefit. Term policy premiums usually increase with age.


Permanent insurance, such as universal life, variable life, and whole life, contains a cash value account or an investment element to the insurance.


Rules of Thumb


The younger your children, the more insurance you need. If both spouses earn income, then both spouses should be insured, with insurance amounts proportionate to salary amounts.


Tip: If the family cannot afford to insure both wage earners, the primary wage earner should be insured first, and the secondary wage earner should be insured later on. A less expensive term policy might be used to fill an insurance gap.


If one spouse does not work outside the home, insurance should be purchased to cover the absence of the services being provided by that spouse (child care, housekeeping, bookkeeping, etc.). However, if funds are limited, insurance on the non-wage earner should be secondary to insurance for the wage earner.


If there are no dependents and your spouse could live comfortably without your income, then you will still need life insurance, but you will need less than someone who has dependents.


Tip: At a minimum, you will want to provide for burial expenses and paying off your debts.


If your spouse would undergo financial hardship without your income, or if you do not have adequate savings, you may need to purchase more insurance. The amount will depend on your salary level and that of your spouse, on the amount of savings you have, and on the amount of debt you both have.


Give us a call. We'll happy to help you determine the correct amount of life insurance you need.

Employee Relocation in a Down Market

Many companies have questions about what to do with an employee's home when he or she is moved to a new job location, especially with the real estate market in a downturn throughout much of the country.


Typically, the employer wants to protect the employee against financial loss on a "forced" sale of the home. Here are the most common ways to do that, and their consequences to the employee:


The employer reimburses the employee's financial loss. Here the employer has the home appraised and agrees to pay the employee the difference between the appraised fair market value and any lesser amount the employee gets on the sale. Such reimbursement would cover the employee's costs of the sale.


Note: The financial loss here is not the same as a tax loss. The financial loss is the home's value less what the employee collects under "forced sale" conditions. In the current real estate market, the value is not always clearly determined. The relocating employee might think the home is worth more, based on earlier appraisals or comparative sales. A tax loss is the property's tax basis (cost plus capital investments) less what's collected on the sale.


If the employee has a gain on the sale (the amount collected on the sale exceeds the basis), gain can be tax-exempt up to $250,000 ($500,000 on certain husband-wife sales). However, tax loss on the sale of one's residence is not deductible.


The employer's reimbursement of the employee's financial loss is taxable pay to the employee. Employers who want to shelter the employee from any tax burden on what is usually an employer-instigated relocation may "gross-up" the reimbursement to cover the tax. But gross-up can be costly. For example, a grossed-up income tax reimbursement for a $10,000 loss would be $14,575 for an employee in the 35% bracket - more where Social Security taxes or state taxes are also grossed-up.


Employer buys the home. Few employers directly buy and sell employees' homes. But many do this indirectly, effectively becoming the homes' owners, through use of relocation firms acting as the employers' agents. An IRS ruling shows how to do this with no tax on the employee:


Option 1. The relocation firm as employer's agent buys the home for its appraised fair market value, and later resells it. The firm collects a fee from the employer, which will cover sales costs and any financial loss to the firm on resale. The IRS now says that this fee is not taxable to the employee. Also, the employee's gain on the sale to the relocation firm qualifies for the tax exemption under the limits described above ($250,000 or $500,000).


Option 2. The relocation firm offers to buy the home for its appraised value, but the employee can choose to pursue a higher price through a broker he or she chooses from a list provided by the relocation firm. If a higher offer is made, the relocation firm pays that price to the employee (whether or not the home is then sold to that bidder). Here again, the employee is not taxed on the firm's fee and the gain is tax exempt under the above limits.


Tip: Either option works for the employee, letting him or her realize full value on the sale of the home (with possibly greater value through Option 2), without an element of taxable pay.


Caution: If the deal is structured so that the relocation firm facilitates a sale from the employee to a third-party buyer (rather than to the relocation firm), the employer's payment of the relocation firm's fee is taxable to the employee.


The Employer's Side


Reimbursing the employee's loss. This is fully deductible as a business expense, as would be any additional amount paid as a gross-up.


Note: It's fully deductible, but it may be more costly, before and after taxes, than buying the home for resale through the relocation firm.


Note: Paying the relocation fee only, without buying the home, as in the "Caution" above, is also fully deductible, as would be any gross-up amount on that fee.


Buying the home. The change in the IRS rule was good news for employees, but it gave nothing to employers, whose tax treatment wasn't covered. The official IRS position is that employer costs (other than carrying costs such as mortgage interest, maintenance, and fees to a relocation management company) are deductible only as capital losses, which, for corporate employers, are deductible only against capital gains. Taxpayer advocates tend to argue that employer costs here are fully deductible ordinary costs of doing business.


Questions?

Are you an employee who is being relocated this fall? Are you wondering about the sale of your home and the tax implications for you? We can answer your questions. Just give us a call.

A SIMPLE Retirement Plan for the Self-Employed

Of all the retirement plans available to small business owners, the SIMPLE plan is the easiest to set up and the least expensive to manage.


These plans are intended to encourage small business employers to offer retirement coverage to their employees. SIMPLE plans work well for small business owners who don't want to spend time and high administration fees associated with more complex retirement plans.


SIMPLE plans really shine for self-employed business owners. Here's why...


Self-employed business owners are able to contribute both as employee and employer, with both contributions made from self-employment earnings.


SIMPLEs calculate contributions in two steps:


1. Employee out-of-salary contribution
The limit on this "elective deferral" is $11,500 in 2011, after which it can rise further with the cost of living.


Catch-up. Owner-employees age 50 or over can make a further $2,500 deductible "catch-up" contribution as employee in 2011.


2. Employer "matching" contribution
The employer match equals a maximum of 3% of employee's earnings.


Example: A 52-year-old owner-employee with self-employment earnings of $40,000 could contribute and deduct $11,500 as employee plus a further $2,500 employee catch-up contribution, plus $1,200 (3% of $40,000) employer match, or a total of $15,200.


SIMPLE plans are an excellent choice for home-based businesses and ideal for full-time employees or homemakers who make a modest income from a sideline business.


If living expenses are covered by your day job (or your spouse's job), you would be free to put all of your sideline earnings, up to the ceiling, into SIMPLE retirement investments.


A Truly Simple Plan


A SIMPLE plan is easier to set up and operate than most other plans. Contributions go into an IRA you set up. Those familiar with IRA rules - in investment options, spousal rights, creditors' rights - don't have a lot new to learn.


Requirements for reporting to the IRS and other agencies are negligible. Your plan's custodian, typically an investment institution, has the reporting duties. And the process for figuring the deductible contribution is a bit simpler than with other plans.


What's Not So Good About SIMPLEs


Once self-employment earnings become significant however, other retirement plans may be more advantageous than a SIMPLE retirement plan.


Example: If you are under 50 with $50,000 of self-employment earnings in 2011, you could contribute $11,500 as employee to your SIMPLE plus a further 3% of $50,000 as an employer contribution, for a total of $13,000. In contrast, a Keogh 401(k) plan would allow a $25,500 contribution.


With $100,000 of earnings, it would be a total of $14,500 with a SIMPLE and $35,500 with a 401(k).


Because investments are through an IRA, you're not in direct control. You must work through a financial or other institution acting as trustee or custodian, and you will in practice have fewer investment options than if you were your own trustee, as you would be in a Keogh.


It won't work to set up the SIMPLE plan after a year ends and still get a deduction that year, as is allowed with Simplified Employee Pension Plans, or SEPs. Generally, to make a SIMPLE plan effective for a year, it must be set up by October 1 of that year. A later date is allowed where the business is started after October 1; here the SIMPLE must be set up as soon thereafter as administratively feasible.


If the SIMPLE plan is set up for a sideline business and you're already vested in a 401(k) in another business or as an employee the total amount you can put into the SIMPLE and the 401(k) combined (in 2011) can't be more than $16,500 or $21,500 if catch-up contributions are made to the 401(k) by someone age 50 or over.


So someone under age 50 who puts $8,000 in her 401(k) can't put more than $8,500 in her SIMPLE in 2011. The same limit applies if you have a SIMPLE while also contributing as an employee to a 403(b) annuity (typically for government employees and teachers in public and private schools).


How to Get Started with a SIMPLE Plan


You can set up a SIMPLE account on your own, but most people turn to financial institutions.


SIMPLES are offered by the same financial institutions that offer IRAs and Keogh master plans.


You can expect the institution to give you a plan document and an adoption agreement. In the adoption agreement you will choose an "effective date" - the beginning date for payments out of salary or business earnings. That date can't be later than October 1 of the year you adopt the plan, except for a business formed after October 1.


Another key document is the Salary Reduction Agreement, which briefly describes how money goes into your SIMPLE. You need such an agreement even if you pay yourself business profits rather than salary.


Printed guidance on operating the SIMPLE may also be provided. You will also be establishing a SIMPLE IRA account for yourself as participant.


Keoghs, SEPs, and SIMPLES Compared




Keogh SEP SIMPLE
Plan type: Can be defined benefit or defined contribution (profit sharing or money purchase) Defined contribution only Defined contribution only
Number you can own: Owner may have two or more plans of different types, including an SEP, currently or in the past Owner may have SEP and Keoghs Generally, SIMPLE is the only current plan
Due dates: Plan must be in existence by the end of the year for which contributions are made Plan can be set up later - if by the due date (with extensions) of the return for the year contributions are made Plan generally must be in existence by October 1 of the year for which contributions are made
Dollar contribution ceiling (for 2011): $49,000 for defined contribution plan; no specific ceiling for defined benefit plan $49,000 $23,000
Percentage limit on contributions: 50% of earnings for defined contribution plans (100% of earnings after contribution). Elective deferrals in 401(k) not subject to this limit. No percentage limit for defined benefit plan. 50% of earnings (100% of earnings after contribution). Elective deferrals in SEPs formed before 1997 not subject to this limit. 100% of earnings, up to $11,500 (for 2011) for contributions as employee; 3% of earnings, up to $11,500, for contributions as employer
Deduction ceiling: For defined contribution, lesser of $49,000 or 20% of earnings (25% of earnings after contribution). 401(k) elective deferrals not subject to this limit. For defined benefit, net earnings. Lesser of $49,000 or 25% of eligible employee's compensation. Elective deferrals in SEPs formed before 1997 not subject to this limit. Same as percentage ceiling on SIMPLE contribution
Catch-up contribution age 50 or over: Up to $5,500 in 2011 for 401(k)s Same for SEPs formed before 1997 Half the limit for Keoghs and SEPs (up to $2,750 in 2011)
Prior years' service can count in computing contribution No No
Investments: Wide investment opportunities. Owner may directly control investments. Somewhat narrower range of investments. Less direct control of investments. Same as SEP
Withdrawals: Some limits on withdrawal before retirement age No withdrawal limits No withdrawal limits
Permitted withdrawals before age 59 1/2 may still face 10% penalty Same as Keogh rule Same as Keogh rule except penalty is 25% in SIMPLE's first two years
Spouse's rights: Federal law grants spouse certain rights in owner's plan No federal spousal rights No federal spousal rights
Rollover allowed to another plan (Keogh or corporate), SEP or IRA,
but not a SIMPLE.
Same as Keogh rule Rollover after 2 years to another SIMPLE and to plans allowed under
Keogh rule
Some reporting duties are imposed, depending on plan type and amount of plan assets Few reporting duties Negligible reporting duties

Please contact us if you are a business owner interested in exploring retirement plan options, including SIMPLE plans.

5 Tips for Taxpayers Who Owe Money to the IRS

The vast majority of Americans get a tax refund from the IRS each spring. But what if you're not one of them? What if you owe money to the IRS?


Here are five tips for individuals who still need to pay their taxes.


  1. If you get a bill for late taxes, you are expected to promptly pay the tax owed including any additional penalties and interest. You can pay the balance owed by electronic funds transfer, check, money order, cashier's check, or cash. If you are unable to pay the amount due, it is often in your best interest to get a loan to pay the bill in full rather than to make installment payments to the IRS.

    You can also pay the bill with your credit card. In either case, the interest rate on a credit card or bank loan may be lower than the combination of interest and penalties imposed by the Internal Revenue Code.

  2. If you cannot pay the liability in full you may request an installment agreement. This is an agreement between you and the IRS for the collection of the amount due and is payable in monthly installment payments. To be eligible for an installment agreement, you must first file all required returns and be current with estimated tax payments.

  3. You can also use an installment agreement if you owe $25,000 or less in combined tax, penalties, and interest. The IRS will inform you usually within 30 days whether your request is approved or denied or if additional information is needed. If the amount you owe is $25,000 or less, provide the monthly amount you wish to pay with your request. At a minimum, the monthly amount you will be allowed to pay without completing a Collection Information Statement is an amount that will fully pay the total balance owed within 60 months.

  4. You may still qualify for an installment agreement if you owe more than $25,000, but a Collection Information Statement must be completed before an installment agreement can be considered. If your balance is over $25,000, consider your financial situation and propose the highest amount possible, as that is how the IRS will arrive at your payment amount (based on your financial information).

  5. If an installment agreement is approved, a one-time user fee will be charged. The user fee for a new agreement is $105 or $52 for agreements where payments are deducted directly from your bank account. For eligible individuals with incomes at or below certain levels, a reduced fee of $43 will be charged. This is automatically figured and is based on your income.


If you owe the IRS money, give our office a call. We can help you set up installment agreements and other payment options.

What Income Is Nontaxable?

Generally, you are taxed on income that is available to you regardless of whether it is actually in your possession, but there are some situations when certain types of income are partially taxed or not taxed at all.


Here are some examples of items that are NOT included in your income:


  • Adoption expense reimbursements for qualifying expenses
  • Funding of your Health Savings Account (HSA) with a one-time direct transfer from your qualified individual retirement plan (Roth IRA or IRA, but not an ongoing SEP IRA or SIMPLE IRA), an Archer MSA, health reimbursement account (HRA), or health flexible spending account (FSA), but not from an ongoing SIMPLE IRA and SEP IRA
  • Child support payments
  • Gifts, bequests, and inheritances
  • Workers' compensation benefits
  • Meals and lodging for the convenience of your employer
  • Compensatory damages awarded for physical injury or physical sickness
  • Welfare benefits
  • Cash rebates from a dealer or manufacturer

Here are examples of items that may or may not be included in your income:


  • Life Insurance. If you surrender a life insurance policy for cash, you must include in income any proceeds that are more than the cost of the life insurance policy. Life insurance proceeds paid to you because of the death of the insured person are not taxable unless the policy was turned over to you for a price.

  • Scholarship or Fellowship Grant. If you are a candidate for a degree, you can exclude amounts you receive as a qualified scholarship or fellowship. Amounts used for room and board do not qualify.

  • Non-cash Income. Taxable income may be in a form other than cash. One example of this is bartering, which is an exchange of property or services. The fair market value of goods and services exchanged is fully taxable and must be included as income on Form 1040 of both parties.

Please contact us if you'd like more information about what income is nontaxable.

Moving Soon? Let the IRS Know

If you changed your home or business address, notify the IRS to ensure that you receive any refunds or correspondence. Although the IRS uses the postal service's change of address files to update taxpayer addresses, notifying the IRS directly is still a good idea.

There are several ways to do this.

  • On your tax return. You may correct the address legibly on the mailing label that comes with your tax package or write the new address in the appropriate boxes on your tax return when you file.

  • Form 8822. You may use Form 8822, Change of Address, to submit an address or name change at any time during the year.

  • Verbal Notification. If an IRS employee contacts you about your account, you may verbally provide a change of address.

  • Written Notification. To give written notification, write to the IRS center where you file your return and provide your new address. The addresses for the IRS centers are listed in the tax instructions. In order to process an address change, the IRS will need your full name, old and new addresses, your Social Security number or employer identification number, and signatures. If you filed a joint return, you should provide the same information for both spouses. If you filed a joint return and have since established separate residences, you each should notify the IRS of your new addresses.

It's a good idea to notify your employer of your new address so that you can get your W-2 forms on time.

If you change your address after filing your return, don't forget to notify the post office at your old address so your mail can be forwarded.

You should also notify the IRS if you make estimated tax payments and you change your address during the year. You should mail a completed Form 8822, Change of Address, or write the IRS center where you file your return. You can continue to use your old pre-printed payment vouchers until the IRS sends you new ones. However, do not correct the address on the old voucher.

Gift Taxes

In 2011, if you give any one person gifts such as cash or property valued at more than $13,000, you must report the total gifts to the Internal Revenue Service. You may have to pay tax on the gifts, but the person who receives your gift does not have to report the gift to the IRS or pay gift or income tax on its value.

Gifts include both cash and property, including the use of property, without expecting to receive something of equal value in return. For example, if you sell something at less than its value or make an interest-free or reduced-interest loan, you may be making a gift.

There is a lifetime maximum of $1 million and there are some exceptions to the tax rules on gifts. The following gifts do not count against the annual limit of $13,000 in 2011:

  • Tuition or medical expenses that you pay directly to an educational or medical institution for someone's benefit

  • Gifts to your spouse

  • Gifts to a political organization

  • Gifts to qualifying charities (also deductible on your tax forms for the value of the gifts made)

If you are married, both you and your spouse can give separate gifts of up to the annual limit of $13,000 each or a total of $26,000 in 2011 to the same person without making it a taxable gift.

If you're confused about gift taxes or need more information,we can help clear up the confusion. Contact our office today.

Tips for Recently Married or Divorced Taxpayers

Newlyweds and the recently divorced should ensure the name on their tax return matches the name registered with the Social Security Administration (SSA). A mismatch could unexpectedly increase a tax bill or reduce the size of any refund.

  • For recently married taxpayers, the tax scenario begins when the bride says "I do." If she takes her husband's last name, but doesn't tell the SSA about the name change, complications may arise. For example, if the couple files a joint tax return with the bride's new name, the IRS computers will not be able to match the new name with the Social Security number.

  • After a divorce, a woman who had taken her husband's name and made that change known to the SSA should contact the SSA if she goes back to her previous name.

If you have any questions related to your requirements to the IRS after getting married or divorced, or need help changing your name with the SSA, give us a call. We're happy to help.

Tracking Bills in QuickBooks, Worth the Effort

Next to payroll, paying bills is probably your least favorite task in QuickBooks. You don't have to use this feature -- you can keep stacking bills on your desk, scrawling the due dates on a paper calendar, and writing checks.

If you're still operating this way, though, you're missing out on the numerous tools that QuickBooks offers to track your accounts payable, including the ability to:


  • Enter bills as
    they come in
  • Set reminders for
    bills due
  • Pay bills easily
  • Locate a bill or payment
    quickly
  • Enter bills as (or
    after) you receive items
  • Link bills to
    purchase orders
  • Have instant
    access to a bill's status

Receiving the goods

When an expense bill comes in (from a utility company, for example), click the Enter Bills icon on the home page, or Vendors | Enter Bills. A window like the one displayed above opens. Select the vendor and fill in the blanks. Make sure that the Expenses tab below is selected and the appropriate account number and amount fields are completed. If it's a bill for an item that already has a related Item Receipt (the shipment preceded the bill), QuickBooks instructs you to use Vendor | Enter Bill for Received Items. Follow the prompts.

Note: Dealing with incoming inventory is complex. Consult with us if you plan to use this feature.

If the bill came simultaneously with items, click Vendors | Receive Items and Enter Bill. When you select the vendor from the list, this box opens (if you have sent a purchase order):


Figure 2: QuickBooks is telling you that you have open orders with this vendor.

Click Yes. The Open Purchase Orders box opens, containing a list of open POs. Select the one(s) you want and click OK. The bill form opens, containing the details of that purchase order. Change quantities if they don't match the shipment, and edit other fields as necessary. Save the bill.

Settling your debts

It's good to set reminders for bills. Go to Edit | Preferences and click Reminders. Make sure that the Show Reminders List...box is checked, then click Company Preferences. Find the Bills to Pay row and enter the advance notice you'd like. Indicate whether you want to see a list or a summary, then click OK.

When bills are due, click the Pay Bills icon or select Vendors | Pay Bills. A window opens displaying all outstanding bills. You can pare this down by selecting a date in the Due on or before field and filtering by vendors. The screen will look something like this:


Figure 3: You can easily select the bills you want to pay.

Enter a check mark next to the bills you're paying, and change the amount in the Amt. To Pay field at the end of the row if necessary. At the bottom of the screen, you can set the payment date and type, use any discounts or credits, and make sure the correct payment account is selected. When you're done, click Pay Selected Bills.

Tip: You can have credits and discounts automatically applied by going to Edit | Preferences | Bills.

After You've Paid Up

There are a number of places where your bills appear in QuickBooks, including:
  • The Unpaid
    Bills Detail
    report
  • The A/P Aging
    Detail
    report
  • The Vendor
    Center
  • QuickReports
  • In the Recent
    Transactions
    pane of some forms
  • On the bills
    themselves

Figure 4: QuickBooks displays the Paid status of bills.

QuickBooks also lets you void and delete bills, and copy and memorize them. Check with us before voiding and deleting, as this can make some complicated changes in your accounts.

You can just pay bills by using Banking | Write Checks or Enter Credit Card Charges. But the payoff for tracking bills is instant access to your accounts payable status, better relations with vendors, and a more insightful accounting of your company's cash flow.

Financial Tips for September 2011

Create a Living Will
Discuss with your spouse your wishes concerning health care and funeral arrangements. This is not pleasant, but it is important that others know your preferences should you be incapacitated. Document your decisions by creating a Living Will.

Update Your Will
Update your will and if you are married, your spouse's will as well.

Review Budget vs. Actuals
Compare August income and expenditures with your budget. Make adjustments as appropriate to your September expenditures. Make sure you have invested your planned savings amount for August.

Tax Due Dates for September 2011



September 12




Employees Who Work for Tips - If you received $20 or more in tips during August, report them to your employer. You can use Form 4070.



September 15




Individuals - Make a payment of your 2011 estimated tax if you are not paying your income tax for the year through withholding (or will not pay in enough tax that way). Use Form 1040-ES. This is the third installment date for estimated tax in 2010.

Corporations - File a 2010 calendar year income tax return (Form 1120 or 1120-A) and pay any tax due. This due date applies only if you made a timely request for an automatic 6-month extension.

S corporations - File a 2010 calendar year income tax return (Form 1120S) and pay any tax due. This due date applies only if you made a timely request for an automatic 6-month extension. Provide each shareholder with a copy of Schedule K-1 (Form 1120S) or a substitute Schedule K-1.

Partnerships - File a 2010 calendar year income tax return (Form 1065). This due date applies only if you were given an additional 5-month extension. Provide each shareholder with a copy of Schedule K-1 (Form 1065) or a substitute Schedule K-1.

Corporations - Deposit the third installment of estimated income tax for 2011. A worksheet, Form 1120-W, is available to help you make an estimate of your tax for the year.

Employers - Nonpayroll withholding. If the monthly deposit rule applies, deposit the tax for payments in August.

Employers - Social Security, Medicare, and withheld income tax. If the monthly deposit rule applies, deposit the tax for payments in August.


 


Saturday, August 6, 2011

August 2011 Remote Accountant Tax Blog Post

Cash Flow - The Pulse of Your Business

Many small business owners do not fully understand their cash flow statement. This is surprising, given that all businesses essentially run on cash, and cash flow is the lifeblood of your business.

Some business experts even say that a healthy cash flow is more important than your business's ability to deliver its goods and services! That's hard to swallow, but consider this: if you fail to satisfy a customer and lose that customer's business, you can always work harder to please the next customer. But if you fail to have enough cash to pay your suppliers, creditors, or employees, you're out of business!

What Is Cash Flow?

Cash flow, simply defined, is the movement of money in and out of your business; these movements are called inflow and outflow. Inflows for your business primarily come from the sale of goods or services to your customers. The inflow only occurs when you make a cash sale or collect on receivables, however. Remember, it is the cash that counts! Other examples of cash inflows are borrowed funds, income derived from sales of assets, and investment income from interest.

Outflows for your business are generally the result of paying expenses. Examples of cash outflows include paying employee wages, purchasing inventory or raw materials, purchasing fixed assets, operating costs, paying back loans, and paying taxes.

Note: An accountant is the best person to help you learn how your cash flow statement works. Please contact us and we can prepare your cash flow statement and explain where the numbers come from.

Cash Flow Versus Profit

Profit and cash flow are two entirely different concepts, each with entirely different results. The concept of profit is somewhat broad and only looks at income and expenses over a certain period, say a fiscal quarter. Profit is a useful figure for calculating your taxes and reporting to the IRS.

Cash flow, on the other hand, is a more dynamic tool focusing on the day-to-day operations of a business owner. It is concerned with the movement of money in and out of a business. But more important, it is concerned with the times at which the movement of the money takes place.

Theoretically, even profitable companies can go bankrupt. It would take a lot of negligence and total disregard for cash flow, but it is possible. Consider how the difference between profit and cash flow relate to your business.

Example: If your retail business bought a $1,000 item and turned around to sell it for $2,000, then you have made a $1,000 profit. But what if the buyer of the item is slow to pay his or her bill, and six months pass before you collect on the account? Your retail business may still show a profit, but what about the bills it has to pay during that six-month period? You may not have the cash to pay the bills despite the profits you earned on the sale. Furthermore, this cash flow gap may cause you to miss other profit opportunities, damage your credit rating, and force you to take out loans and create debt. If this mistake is repeated enough times, you may go bankrupt.

Analyzing Your Cash Flow

The sooner you learn how to manage your cash flow, the better your chances for survival. Furthermore, you will be able to protect your company's short-term reputation as well as position it for long-term success.

The first step toward taking control of your company's cash flow is to analyze the components that affect the timing of your cash inflows and outflows. A thorough analysis of these components will reveal problem areas that lead to cash flow gaps in your business. Narrowing, or even closing, these gaps is the key to cash flow management.

Some of the more important components to examine are:

  • Accounts receivable. Accounts receivable represent sales that have not yet been collected in the form of cash. An accounts receivable is created when you sell something to a customer in return for his or her promise to pay at a later date. The longer it takes for your customers to pay on their accounts, the more negative the effect on your cash flow.
  • Credit terms. Credit terms are the time limits you set for your customers' promise to pay for their purchases. Credit terms affect the timing of your cash inflows. A simple way to improve cash flow is to get customers to pay their bills more quickly.
  • Credit policy. A credit policy is the blueprint you use when deciding to extend credit to a customer. The correct credit policy - neither too strict nor too generous - is crucial for a healthy cash flow.
  • Inventory. Inventory describes the extra merchandise or supplies your business keeps on hand to meet the demands of customers. An excessive amount of inventory hurts your cash flow by using up money that could be used for other cash outflows. Too many business owners buy inventory based on hopes and dreams instead of what they can realistically sell. Keep your inventory as low as possible.
  • Accounts payable and cash flow. Accounts payable are amounts you owe to your suppliers that are payable some time in the near future - "near" meaning 30 to 90 days. Without payables and trade credit, you'd have to pay for all goods and services at the time you purchase them. For optimum cash flow management, examine your payables schedule.

Some cash flow gaps are created intentionally. For example, a business may purchase extra inventory to take advantage of quantity discounts, accelerate cash outflows to take advantage of significant trade discounts, or spend extra cash to expand its line of business.

For other businesses, cash flow gaps are unavoidable. Take, for example, a company that experiences seasonal fluctuations in its line of business. This business may normally have cash flow gaps during its slow season and then later fill the gaps with cash surpluses from the peak part of its season. Cash flow gaps are often filled by external financing sources. Revolving lines of credit, bank loans, and trade credit are just a few of the external financing options available that you may want to discuss with us.

Monitoring and managing your cash flow is important for the vitality of your business. The first signs of financial woe appear in your cash flow statement, giving you time to recognize a forthcoming problem and plan a strategy to deal with it. Furthermore, with periodic cash flow analysis, you can head off those unpleasant financial glitches by recognizing which aspects of your business have the potential to cause cash flow gaps.

Need assistance? We can help you analyze and manage your cash flow more effectively and make sure your business has adequate funds to cover day-to-day expenses.

Planning For Retirement: Withdrawals

Are you thinking of retiring soon, or changing jobs? You may face a major financial decision: what to do about the funds in your retirement plan.

Note: As you will see, the rules on retirement withdrawals are quite complex. They are offered here only for your general understanding. Please call us before taking withdrawals or making other major changes in your retirement plan.

Take a Partial Withdrawal

Partial withdrawals are withdrawals that aren't rollovers, annuities, or lump sums. Because they are partial, the amount not withdrawn continues its tax shelter (see below).

A partial withdrawal will usually leave open the option for other types of withdrawal (annuity, lump sum, rollover) of the balance left in the plan.

Note: Before retirement, partial withdrawals are fairly common with profit-sharing plans, 401(k)s, and stock bonus plans. After retirement, they are fairly common in all types of plans (though least common with defined-benefit pension plans).

Tax Planning. A partial withdrawal is usually taxable and can be subject to the penalty tax on withdrawals before age 59-1/2 except under certain situations (see below) and when the distribution consists of after-tax contributions, such as nondeductible IRA contributions.

Example: Your retirement account totals $100,000, which includes an after-tax investment of $10,000. You withdraw $5,000. $500 of the withdrawal is tax-free ($10,000 / $100,000 x $5,000).

Note: The tax-free portion is computed differently for plan participants who have been in the plan since 5/5/86. Contact us for details.

Exceptions for early distributions from IRAs and other qualified retirement plans include direct rollovers to a new retirement account, you were permanently or totally disabled, you were unemployed and paid for health insurance premiums, you paid for college expenses for yourself or a dependent, you bought a house (certain criteria must be met), or you paid for medical expenses exceeding 7.5 percent of your adjusted gross income. In addition, there are several less common situations where you might be exempt from paying taxes and early withdrawal penalties. Please call us if you would like more information.

Preserving the Tax Shelter. Your funds grow sheltered from tax while they are in the retirement plan. This means that the longer you can prolong the distribution - or the smaller the amount you must withdraw - the more your assets grow. Some people choose to defer withdrawals for as long as the law allows to maximize assets and shelter them for the next generation.

Note: The law has specific rules about how fast the money must be taken out of the plan after your death. These rules limit the ability to prolong a tax shelter.

Withdrawal Before You Reach Age 70-1/2

Until you reach 70-1/2, you do not need to take money out of your retirement account - unless your employer's plan requires it. In fact, there will usually be a 10% early-withdrawal penalty if you make withdrawals before age 59 1/2. This is on top of the regular income tax you owe - at any age - on amounts you withdraw (though there's no tax on after-tax contributions you made, as we discussed above).

Once You Reach Age 70-1/2

Once you hit 70-1/2, withdrawals must begin. Technically they can be postponed until April 1 of the year following the year you reach 70-1/2 - say April 1, 2012 if you reach 70-1/2 in 2011. But waiting until April 1 means you must withdraw for two years - 2011 and 2012 - in 2012. To avoid this income bunching and a possible higher marginal tax rate, we may suggest withdrawing in the year you reach 70-1/2. Call us to evaluate your situation.

The rules allow you to spread your withdrawals over a period substantially longer than your life expectancy. Under these rules, the taxpayer (say, an IRA owner) first determines how much he's saved as of the end of the preceding year. Then he consults a (unisex) IRS table to find the number for his age. The number corresponds to how long he may spread out the withdrawals. The owner then divides that number into the retirement asset total. The result is the minimum amount he must withdraw for the year.

Example: Joe reaches age 70-1/2 in October of this year. Retirement plan assets in his IRA totaled $600,000 at the end of last year. The IRS number for age 70 is 27.4. Joe must withdraw $21,898 ($600,000/27.4) this year.

Example: Two years from now, Joe is 72 and his IRA was $602,000 at the end of the preceding year (when Joe reached age 71). The IRS number for age 72 is 25.6. Joe must withdraw $23,516 ($602,000/25.6) when he's 72.

The number in the IRS table assumes distribution over a period based on your life expectancy, plus that of a beneficiary 10 years younger than you. If your designated beneficiary is a spouse more than 10 years younger than you, his or her actual life expectancy is used to figure the withdrawal period during your lifetime.

Caution: You can always take out money faster than required - and pay tax on these withdrawals. However, the tax code is strict about minimum withdrawals. If you fail to take out what's required, a tax penalty will take 50% of what should have been withdrawn but wasn't.

Financial Calculator: Required Minimum Distribution

The IRS requires that you withdraw at least a minimum amount - known as a Required Minimum Distribution - from your retirement accounts annually, starting the year you turn age 70-1/2. Determining how much you are required to withdraw is an important issue in retirement planning.

Contact us now if you'd like assistance figuring out how much your withdrawal should be, because getting those numbers right can make a big difference in the quality of your retirement.

Credit Reports: What You Should Know

How do lenders determine who is approved for a credit card, mortgage, or car loan? Why are some individuals flooded with credit card offers while others get turned down routinely?

Because creditors keep their evaluation standards secret, it is difficult to know just how to improve your credit rating. It is important, however, to understand the factors and to review your credit report periodically for any irregularities, omissions, or errors. Reviewing your credit report annually can help you protect your credit rating from fraud and ensure its accuracy.

Credit Evaluation Factors

Many factors determine your credit. Here are some of the major factors considered:

  • Age
  • Residence
  • "Authorized user" payment history
  • Checking and savings accounts
  • Bankruptcy
  • Charge-offs (Forgiven debt)
  • Child support
  • Closed accounts and inactive accounts
  • Jobs
  • Payment history
  • Recent loans
  • Collection accounts and charge-offs
  • Cosigning an account
  • Credit limits
  • Credit reports
  • Debt/income ratios
  • Department store accounts
  • Payment history/late payments
  • Finance company credit cards
  • Income/income per dependent
  • Mortgages
  • Revolving credit
  • Name/alias
  • Number of credit accounts
  • Fraud
  • Inquiries

These factors may be used, and weighted, in determining credit decisions. Credit reports contain much of this information.

Obtaining Your Credit Reports

Credit reports are records of consumers' bill-paying habits. Credit reports are also called credit records, credit files, and credit histories and are collected, stored, and sold by three credit bureaus, Experian, Equifax, and TransUnion.

Recent changes to the Fair Credit Reporting Act (FCRA) require that each of the three credit bureaus provide you with a free copy of your credit report, at your request, every 12 months.

If you have been denied credit or believe you've been denied employment or insurance because of your credit report, you can request that the credit bureau involved provide you with a free copy of your credit report - but you must request it within 60 days of receiving the notification.

Disputing Errors in Your Credit File

The Fair Credit Reporting Act (FCRA) protects consumers in the case of inaccurate or incomplete information in credit files. The FCRA requires credit bureaus to investigate and correct any errors in your file.

Tip: If you find any incorrect or incomplete information in your file, write to the credit bureau and ask them to investigate the information. Under the FCRA, they have about thirty days to contact the creditor and find out whether the information is correct. If not, it will be deleted.

Be aware that credit bureaus are not obligated to include all of your credit accounts in your report. If, for example, the credit union that holds your credit card account is not a paying subscriber of the credit bureau, the bureau is not obligated to add that reference to your file. Some may do so, however, for a small fee.

Fair Credit Reporting Act (FCRA)

This federal law was passed in 1970 to give consumers easier access to, and more information about, their credit files. The FCRA gives you the right to find out the information in your credit file, to dispute information you believe inaccurate or incomplete, and to find out who has seen your credit report in the past six months.

Understanding Your Credit Report

Credit reports contain symbols and codes that are abstract to the average consumer. Every credit bureau report also includes a key that explains each code. Some of these keys decipher the information, but others just cause more confusion.

Read your report carefully, making a note of anything you do not understand. The credit bureau is required by law to provide trained personnel to explain it to you. If accounts are identified by code number, or if there is a creditor listed on the report that you do not recognize, ask the credit bureau to supply you with the name and location of the creditor so you can ascertain if you do indeed hold an account with that creditor.

If the report includes accounts that you do not believe are yours, it is extremely important to find out why they are listed on your report. It is possible they are the accounts of a relative or someone with a name similar to yours. Less likely, but more importantly, someone may have used your credit information to apply for credit in your name. This type of fraud can cause a great deal of damage to your credit report, so investigate the unknown account as thoroughly as possible.

We recommend an annual review of your credit report. It is vital that you understand every piece of information on your credit report so that you can identify possible errors or omissions.

If you need help obtaining your credit reports or need assistance in understanding what your credit report means, give us a call.

Paying Off Debt the Smart Way

Being in debt isn't necessarily a terrible thing. Between mortgages, car loans, credit cards, and student loans - most people are in debt. Being debt-free is a great goal, but you should focus on the management of debt, not just getting rid of it. It's likely to be there for most of your life - and, handled wisely, it won't be an albatross around your neck.

You don't need to shell out your hard-earned money for exorbitant interest rates, or always feel like you're on the verge of bankruptcy. You can pay off debt the smart way, while at the same time saving money to pay it off faster.

Know Where You Are

First, assess the depth of your debt. Write it down, using pencil and paper, a spreadsheet like Microsoft Excel, or a bookkeeping program like Quicken. Include every financial situation where a company has given you something in advance of payment, including your mortgage, car payment(s), credit cards, tax liens, student loans, and payments on electronics or other household items through a store.

Record the day the debt began and when it will end (if possible), the interest rate you're paying, and what your payments typically are. Add it all up, painful as that might be. Try not to be discouraged! Remember, you're going to break this down into manageable chunks while finding extra money to help pay it down.

Identify High-Cost Debt

Yes, some debts are more expensive than others. Unless you're getting payday loans (which you shouldn't be), the worst offenders are probably your credit cards. Here's how to deal with them.

  • Don't use them. Don't cut them up, but put them in a drawer and only access them in an emergency.
  • Identify the card with the highest interest and pay off as much as you can every month. Pay minimums on the others. When that one's paid off, work on the card with the next highest rate.
  • Don't close existing cards or open any new ones. It won't help your credit rating.
  • Pay on time, absolutely every time. One late payment these days can lower your FICO score.
  • Go over your credit-card statements with a fine-tooth comb. Are you still being charged for that travel club you've never used? Look for line items you don't need.
  • Call your credit card companies and ask them nicely if they would lower your interest rates. It does work sometimes!

Save, Save, Save

Do whatever you can to retire debt. Consider taking a second job and using that income only for higher payments on your financial obligations. Substitute free family activities for high-cost ones. Sell high-value items that you can live without.

Do Away with Unnecessary Items to Reduce Debt Load

Do you really need the 800-channel cable option or that dish on your roof? You'll be surprised at what you don't miss. How about magazine subscriptions? They're not terribly expensive, but every penny counts. It's nice to have a library of books, but consider visiting the public library or half-price bookstores until your debt is under control.

Never, Ever Miss a Payment

Not only are you retiring debt, but you're also building a stellar credit rating. If you ever move or buy another car, you'll want to get the lowest rate possible. A blemish-free payment record will help with that. Besides, credit card companies can be quick to raise interest rates because of one late payment. A completely missed one is even more serious.

Do Not Increase Debt Load

If you don't have the cash for it, you probably don't need it. You'll feel better about what you do have if you know it's owned free and clear.

Shop Wisely, and Use the Savings to Pay Down Your Debt

If your family is large enough to warrant it, invest $30 or $40 and join a store like Sam's or Costco. And use it. Shop there first, then at the grocery store. Change brands if you have to and swallow your pride. Use coupons religiously. Calculate the money you're saving and slap it on your debt.

Each of these steps, taken alone, probably doesn't seem like much. But if you adopt as many as you can, you'll watch your debt decrease every month.

Protect Your Business With The Right Insurance

Starting a business is expensive and the capital that you've poured into your company can disappear in an instant if a major weather event damages your offices or one of your products injures someone.

Having the right kind of insurance is critical to your business and multiple insurance policies should be in place before you even open your doors for business. And, they should be reviewed every year or when a business change occurs such as stocking new products or moving to a new location.

Commercial Business Insurance

Commercial Property Insurance policies are either all-inclusive or risk specific and protect your office and its contents from damage caused by natural disasters, fires, or vandalism.

Product Liability Insurance is necessary if you manufacture or sell products. Product Liability Insurance safeguards you if a product defect causes injury to someone.

For protection against lawsuits related to negligence claims, you need to consider both General Liability Insurance and Professional Liability Insurance as well.

Other types of insurance your business might need include:

  • Coverage that protects Directors and Officers from personal liability
  • Key Executive Life Insurance
  • Business Interruption (covers lost profits and expenses)
  • Commercial Vehicle Insurance
  • Website Insurance (protects you from legal claims)

Employer-Related Insurance

Workers' Compensation Insurance (administered by individual states) and Unemployment Insurance (under certain conditions) are mandatory in the United States. Some states require employers to provide other types of insurance. For example, if any of your employees are located in California, Hawaii, New Jersey, New York, Puerto Rico, or Rhode Island you will be required to provide Disability Insurance. Disability Insurance is a benefit provided to employees who are unable to work because of illness or injury.

Employers are not required to provide Life, Medical, and Dental Insurance for employees.

Don't under-insure, but don't over-insure either.

Some Tips:

  • Assess your liability risk honestly and thoroughly.
  • Ask your lawyer for advice.
  • Get quotes from several companies.
  • Talk to your insurer about how you can minimize risk and premiums.

Your insurance company will be your ally if you encounter legal problems because of an accident or injury that happens to someone on your property, to an employee doing business for you, or if a service you provide causes harm to someone.

Avoid lawsuits by making sure you have the right insurance for your business. If you need help figuring out which insurance is right for you, then give us a call now.

Tax Benefits for Job Seekers

Some folks - especially these days - are polishing their resumes and attending career fairs in search of employment. If you are searching for a job this summer, you may be able to deduct some of those expenses on your tax return.

Here are six things you need to know about deducting costs related to your job search.

  1. To deduct job search costs, the expenses must be spent on a job search in your current occupation. You may not deduct expenses related to looking for a job in a new occupation.
  2. You can deduct employment and outplacement agency fees you pay while looking for a job in your present occupation. If your employer pays you back in a later year for employment agency fees, you must include the amount you receive in your gross income up to the amount of your tax benefit in the earlier year.
  3. You can deduct amounts you spend for preparing and mailing copies of a resume to prospective employers as long as you are looking for a new job in your present occupation.
  4. If you travel to an area to look for a new job in your present occupation, you may be able to deduct travel expenses to and from the area. You can only deduct the travel expenses if the trip is primarily to look for a new job. The amount of time you spend on personal activity compared to the time spent looking for work is important in determining whether the trip is primarily personal or is related to your job search. (If you have questions about how to figure this, call us.)
  5. You cannot deduct job search expenses if there was a substantial break between the end of your last job and the time you begin looking for a new one.
  6. You cannot deduct job search expenses if you are looking for a job for the first time.

If you'd like more information about deducting expenses related to your job search, let us know. We'll guide you through the process.

What to Do If You Haven't Filed Your 2010 Return

The failure to file a federal tax return can be costly - whether you end up owing more or missing out on a refund.

There are several reasons taxpayers don't file their taxes. Perhaps they didn't know they were required to file. Maybe they just kept putting it off and simply forgot.

Whatever the reason, it's best to file the return as soon as possible. If you need help, even with a late return, we are ready to assist you.

Here are some things to consider:

  • Failure to File Penalty. If you owe taxes, a delay in filing may result in a "failure to file" penalty, also known as the "late filing" penalty, and interest charges. The longer you delay, the more these charges grow.
  • Losing Your Refund. There is no penalty for failure to file if you are due a refund. However, you cannot obtain a refund without filing a tax return. If you wait too long to file, you may risk losing the refund altogether. The deadline for claiming refunds is three years after the original due date.
  • Earned Income Tax Credit. Individuals who are entitled to the Earned Income Tax Credit must file their return to claim the credit even if they are not otherwise required to file.

Whether you must file a tax return depends on a number of factors, including your filing status, age, and gross income.

Still need to file a tax return for 2010? Call us today. We can help you file your return and avoid additional fines and penalties.

Basic Hints to Help New Small Businesses

Folks starting a small business are often challenged by their new tax filing requirements. It can be overwhelming to learn about federal tax responsibilities.

The following is a list of basic tips to avoid potential problems:

  • Classify workers properly as employees or independent contractors as determined by law, not the choice of the worker or business owner.
  • Deposit federal employment taxes, called trust fund taxes, according to the appropriate schedule.
  • Start making estimated quarterly payments to cover your own income tax and Social Security self-employment tax liability.
  • Keep good records to protect your personal and financial investment and to make tax filing easier.
  • Consider a tax professional to help you with Schedule C.
  • File and pay your taxes electronically. It's fast, easy, and secure.
  • Protect financial and tax records to ensure business continuity in the event of a disaster.

Starting a new business? Give us a call today. As always, we're here to help sort out your tax responsibilities.

Seven Tax Tips for Students with a Summer Job

Are you a student with a summer job? Here are seven things you should know about the income you earn during the summer months.

  1. All taxpayers fill out a W-4 when starting a new job. This form is used by employers to determine the amount of tax that will be withheld from your paycheck. Taxpayers with multiple summer jobs will want to make sure all their employers are withholding an adequate amount of taxes to cover their total income tax liability. To make sure your withholding is correct, call our office.
  2. Whether you are working as a waiter or a camp counselor, you may receive tips as part of your summer income. All tip income you receive is taxable and is therefore subject to federal income tax.
  3. Many students do odd jobs over the summer to make extra cash. If this is your situation, keep in mind that earnings you receive from self-employment are subject to income tax. This includes income from odd jobs like baby-sitting and lawn mowing.
  4. If you have net earnings of $400 or more from self-employment, you also have to pay self-employment tax. (Church employee income of $108.28 or more must also pay.) This tax pays for your benefits under the Social Security system. Social Security and Medicare benefits are available to individuals who are self-employed just as they are to wage earners who have Social Security tax and Medicare tax withheld from their wages. The self-employment tax is figured on Form 1040, Schedule SE.
  5. Subsistence allowances paid to ROTC students participating in advanced training are not taxable. However, active duty pay - such as pay received during summer advanced camp - is taxable.
  6. Special rules apply to services you perform as a newspaper carrier or distributor. You are a direct seller and treated as self-employed for federal tax purposes if you meet the following conditions:
    • You are in the business of delivering newspapers.
    • All your pay for these services directly relates to sales rather than to the number of hours worked.
    • You perform the delivery services under a written contract which states that you will not be treated as an employee for federal tax purposes.
  7. Generally, newspaper carriers or distributors under age 18 are not subject to self-employment tax.

A summer work schedule is sometimes a patchwork of odd jobs - which makes for confusion come tax time. Contact us if you have any questions at all about income your child earned this summer season.

Using the Add/Edit Multiple List Entries Feature

Data entry and modifications in QuickBooks can be tedious. Beginning with QuickBooks 2010 Pro Edition and above, that job got a lot easier. The Add/Edit Multiple List Entries tool does just what its name implies: It lets you add entries to your lists of customers, vendors, services, inventory parts, and non-inventory parts. It also makes changing one or several of them quick and easy.

Using this feature, you can:

  • See customized views of your list data
  • Enter missing information
  • Create new entries from duplicates of existing ones
  • Do a mass change of a whole column
  • Copy and paste records from Excel

There are myriad applications for this tool. You could use it, for example, when you're changing Preferred Vendors for a group of items and you don't want to have to edit each individual item record. Or when the area code for select customers or vendors has changed. You could use it if you're adding an inventory item that's just slightly different from another, or when your accountant tells you to change the name of an account.

Building the perfect view

To get started, click Lists | Add/Edit Multiple List Entries. In the screen that opens, click the arrow next to the List box and select the type of data you want to see, like Customers. Then select the group that you want displayed by dropping the View list down. Click the Customize Columns button. This window opens:



Figure 1: Make sure your columns are correct and in the right order.

The list on the left represents all possible column labels. To make the list on the right reflect what you want to see in your table, highlight the correct item and use the Add or Remove buttons and the Move Up or Move Down buttons. When you're satisfied, click OK. The table will change to display those columns in that order.

TIP: You may have a lot of empty space between columns. To close those gaps, put your cursor on the faint vertical line that separates two column names. A cross-like symbol will appear. Drag it left or right until the columns are positioned well.

Let's say that a customer commissions a new job. Since so much information will remain the same as in previous jobs, you can duplicate her record. Highlight the last entry in her list of jobs and right-click. Select Duplicate Row. The new entry will contain her default information, except the name will change to DUP [NAME OF PREVIOUS JOB]. Change that phrase to the name of the new job and click Save Changes if you're done.



Figure 2: It's easy to duplicate an entry's information.

Mass changes

You may occasionally want to make the same change to a subset of records. Say a city's zip code changed and you want to find the customers affected. You'd open the Customers list, click on the View arrow and select Custom Filter. Then:

  • In the Search list, choose from All, Active, etc.
  • In the For box, enter the common attribute, like the zip code.
  • Click on the arrow next to the in box, and tell QuickBooks where you want to search (address fields, all common fields, etc.).



Figure 3: You can search for a group of entries that share a common characteristic.

  • Click Go. QuickBooks will display a list of all of the matching entries.
  • Make your change to the entry at the top of the list, then right-click on it. You'll see this menu:



Figure 4: The Copy Down command changes all entries in a column to match the top one.

When you select Copy Down, all of the entries duplicate the first one in the list.

Some housekeeping

Anything you change in these views, as long as you click Save Changes, will be reflected throughout QuickBooks, wherever that record appears. If you've made an error, like using a dollar sign, you'll get a message telling you to fix it.

You can use Add/Edit Multiple List Entries in other ways. For example, it's a good way to see how thorough your recordkeeping is. Take a look at your lists occasionally to spot missing data. Or say you were at a trade show and signed up new customers, but you didn't have QuickBooks on your laptop so you entered them in Excel. Once you've made sure that your column names and order in Excel match those displayed in Add/Edit Multiple List Entries, you can just copy and paste the new customers in.

This feature is easy to use, but be cautious. We can help with complex modifications. Add/Edit Multiple List Entries is one of the ten best features QuickBooks has incorporated in recent years. It's an easy way to get a birds' eye view of your lists, and a great time-saver.

Financial Tips for August 2011

Prepare a Post-Mortem Letter

Review or prepare a post-mortem letter to your spouse spelling out the location of your assets and property (assets of a deceased are often lost because a spouse may not be aware of them or know their location), the names of all your advisors, and any other information your spouse should know to minimize his or her burden in the stressful period after your death.

Get Your Social Security Statement of Benefits

Request a Personal Earnings and Benefit Estimate Statement from the Social Security Administration. This statement summarizes your Social Security earnings history and provides an estimate of the benefits to which you are entitled. It is important to verify that you have been credited for all of your earnings. You can also use this statement in your retirement planning. We can help you with this statement; just give us a call.

Review Your Budget vs Actuals for July

Compare July income and expenditures with your budget. Make adjustments as appropriate to your August expenditures. Make sure you invest your planned savings amount for July.

Estimate Your Tax Liability

Total up your taxable income, capital gains, and deductions through this date. This information can be used to plan your estimated tax payments, and perhaps avoid or minimize any underpayment penalties.