Month: November 2017

Creating Customer Statements in QuickBooks

Let’s say you have a regular customer who used to pay on time, but he’s been hit-and-miss lately. How do you get him caught up? Or, one of your customers thinks she’s paid you more than she owes. How do you straighten out this account?

Both of these situations have a similar solution: QuickBooks’ Statements.

QuickBooks’ statements provide an overview of every transaction that has occurred between you and individual customers during a specified period of time. They’re easy to create, easy to understand, and can be effective at resolving payment disputes.

A Simple Process

Here’s how they work. Click Statements on the home page, or open the Customers menu and select Create Statements. A window like this will open:


Figure 1: QuickBooks provides multiple options on this screen so you create the statement(s) you need.

First, make sure the Statement Date is correct, so that your statement captures the precise set of transactions that you want. Next, you will need to tell QuickBooks what that set is. Should the statement(s) include transactions only within a specific date range? If so, then click the button in front of Statement Period From, and enter that period’s beginning and ending dates by clicking on the calendar graphic. If you would rather, you can include all open transactions by clicking on the button in front of that option. As you can see in the screenshot above, you can choose to Include only transactions over a specified number of days past due date.

Choosing Customers

Now, you need to tell QuickBooks which customers you want to include in this statement run. Your options here are:

 

    • All Customers.

 

    • Multiple Customers. When you click on this choice, QuickBooks displays a Choose button. Click on it, and your customer list opens in a new window. Click on your selections there to create a check mark. Click OK to return to the previous window.

 

    • One Customer. QuickBooks displays a drop-down menu. Click the arrow on the right side of the box, and choose the correct one from the list that opens.

 

    • Customers of Type. Again, a drop-down list appears, but this one contains a list of the Customer Types you created to filter your customer list, like Commercial and Residential. You would have assigned one of these to customers when you were entering data in their QuickBooks records (click the Additional Info tab in a record to view).

 

  • Preferred Send Method. E-mail or Mail?

Miscellaneous Options

At the top of the right column, you can select a different Template if you would like, or Customize an existing one. Not familiar with the options you have to change the layout and content of forms in QuickBooks? Let one of our QuickBooks experts introduce you to the possibilities.

Below that, you can opt to Create One Statement either Per Customer or Per Job. The rest of the choices here are pretty self-explanatory–except for Assess Finance Charges. If you have never done this, then it may be helpful to call the office and arrange for a QuickBooks pro to work with you on this complex process.

When you are satisfied with the options that you have selected in this window, click the Preview button in the lower left corner of the window (not pictured here). QuickBooks will then prepare all the statements in the background, and display the first one. Click Next to view them one by one. At the bottom of each, you will see a summary of how much is due in each aging period, like this:


Figure 2: It is easy to see how much each customer is past due within each aging period. This summary appears at the bottom of statements.

After you have checked all the statements, click the Print or E-mailbutton at the bottom of the window.

Other Avenues

Your company’s cash flow depends on the timely payment of invoices. Sending statements is only one way to encourage your customers to catch up on their past due accounts. There are many others, like opening a merchant account so customers can pay you online with a bank card or electronic check. If poor cash flow is threatening the health of your business, a QuickBooks professional can help.

Relief for Drought-Stricken Farmers and Ranchers

Farmers and ranchers who previously were forced to sell livestock due to drought in an applicable region now have an additional year to replace the livestock and defer tax on any gains from the forced sales, according to the Internal Revenue Service. An applicable region is a county designated as eligible for federal assistance plus counties contiguous to that county.

This relief generally applies to capital gains realized by eligible farmers and ranchers on sales of livestock held for draft, dairy or breeding purposes. Sales of other livestock, such as those raised for slaughter or held for sporting purposes, or poultry are not eligible.

To qualify, the sales must be solely due to drought, flooding or other severe weather causing the region to be designated as eligible for federal assistance.

Under these circumstances, livestock generally must be replaced within a four-year period, instead of the usual two-year period. But in addition, the IRS is authorized to extend this replacement period further if the drought continues.

The one-year extension of the replacement period gives eligible farmers and ranchers until the end of the tax year after the first drought-free year to replace the sold livestock.

The IRS provides this extension to farmers and ranchers located in the applicable region that qualified for the four-year replacement period if any county, parish, city, or district, that is included in the applicable region is listed as suffering exceptional, extreme or severe drought conditions by the National Drought Mitigation Center (NDMC), during any weekly period between Sept. 1, 2016, and Aug. 31, 2017. All or part of 42 states, plus the District of Columbia, are listed.

A taxpayer may determine whether exceptional, extreme, or severe drought is reported for any location in the applicable region by reference to U.S. Drought Monitor maps that are produced on a weekly basis by the National Drought Mitigation Center. U.S. Drought Monitor maps are archived at Drought Monitor maps.

In addition, in September of each year, the IRS publishes a list of counties, districts, cities, boroughs, census areas or parishes (hereinafter “counties”) for which exceptional, extreme, or severe drought was reported during the preceding 12 months. Taxpayers may use this list instead of U.S. Drought Monitor maps to determine whether exceptional, extreme, or severe drought has been reported for any location in the applicable region.

As a result, farmers and ranchers in the applicable region whose drought sale replacement period was scheduled to expire at the end of this tax year, Dec. 31, 2017, in most cases, will now have until the end of their next tax year. Because the normal drought sale replacement period is four years, this extension immediately impacts drought sales that occurred during 2013. But because of previous drought-related extensions affecting some of these localities, the replacement periods for some drought sales before 2013 are also affected. Additional extensions will be granted if severe drought conditions persist.

For additional details on tax relief for drought-stricken farmers and ranchers please contact the office.

Tax Deductions for Educators

With the fall semester of the school year well underway teachers, administrators and aides should not forget to keep track of education-related expenses that could help reduce their taxes when they file their returns next spring. With that in mind, let’s take a look at three key work-related tax benefits that are available to educators.

Educators can take advantage of tax deductions for qualified expenses related to their profession. The costs many educators incur out-of-pocket include items such as classroom supplies, training and travel.

There are two methods educators can choose for deducting qualified expenses: Claiming the Educator Expense Deduction (up to $250) or, for those who itemize their deductions, claiming eligible work-related expenses as a miscellaneous deduction on Schedule A, Itemized Deductions.

A third key benefit enables many teachers and other educators to take advantage of various education tax benefits for their ongoing educational pursuits, especially the Lifetime Learning Credit or, in some instances depending on their circumstances, the American Opportunity Tax Credit.

Educator Expense Deduction

Educators can deduct up to $250 ($500 if married filing jointly and both spouses are eligible educators, but not more than $250 each) of unreimbursed business expenses. The educator expense deduction is available even if an educator doesn’t itemize their deductions. To do so, the taxpayer must be a kindergarten through grade 12 teacher, instructor, counselor, principal or aide for at least 900 hours a school year in a school that provides elementary or secondary education as determined under state law.

Those who qualify can deduct costs like books, supplies, computer equipment and software, classroom equipment and supplementary materials used in the classroom. Expenses for participation in professional development courses are also deductible. Athletic supplies qualify if used for courses in health or physical education.

Itemizing Deductions using Schedule A

Often educators have qualifying classroom and professional development expenses that exceed the $250 limit. In that case, the IRS encourages them to claim these excess expenses as a miscellaneous deduction on Schedule A (Form 1040 or Form 1040NR). In addition, educators can claim other work-related expenses, such as the cost of subscriptions to professional journals, professional licenses, and union dues. Transportation expenses may also be deductible in situations such as, for example, where an educator assigned to teach at two different schools needs to drive from one school to the other on the same day.

Miscellaneous deductions of this kind are subject to a two-percent limit. This means that a taxpayer must subtract two percent of their adjusted gross income from the total qualifying miscellaneous deduction amount. For more information, see Publication 529, Miscellaneous Deductions or call the office for assistance.

Keeping Records

Educators should keep detailed records of qualifying expenses noting the date, amount, and purpose of each purchase. This will help prevent a missed deduction at tax time.

Taxpayers should also keep a copy of their tax return for at least three years. Copies of tax returns may be needed for many reasons. If applying for college financial aid, a tax transcript may be all that is needed. A tax transcript summarizes return information and includes adjusted gross income. Tax transcripts are available free of charge from the IRS.

The quickest way to get a copy of a tax transcript is to use the Get Transcript application on the IRS website. After verifying identity, taxpayers can view and print their transcript immediately online. The online application includes a robust identity verification process. Those who can’t pass the verification must request the transcript be mailed. This takes five to 10 days, so plan ahead and request the transcript early.

Questions about tax deductions for educators?

Don’t hesitate to call the office if you have any questions about tax deduction available to educators including teachers, administrators, and aides.

Go to top

Scroll to top