Month: May 2017

Memorizing Transactions in QuickBooks

Your accounting work involves a lot of repetition. You send invoices. Pay bills. Create purchase orders. Generate payroll checks and submit payroll taxes.

Some of the time, you only fill out those transaction forms once. You might be doing a one-time purchase, like paying for some new office furniture. Other times, though, you’re paying or charging the same companies or individuals on a regular basis.

QuickBooks contains a shortcut to those recurring tasks, called Memorized Transactions. You can save the details that remain the same every time, and use that template every time the bill or invoice is due, which can save a lot of time and improve accuracy. Here’s how it works.

Making Copies

To memorize a transaction, you first need to create a model for it. Let’s say you have a monthly bill for $450 that’s paid to Bruce’s Office Machines. You’d click Enter Bills on the home page or open the Vendors menu and select Enter Bills. Fill in the blanks and select from drop-down lists to create the bill. Then click Memorize in the horizontal toolbar at the top of the form. This window will open.


Figure 1: Before you can Memorize a transaction, you first have to create a model (template) for it.

The vendor’s name will already be filled in on the Memorize Transaction screen. Look directly below that. There are three ways that QuickBooks can handle these Memorized Transactions when one of their due dates is approaching:

  • Add to my Reminders List. If you click the button in front of this option, the current transaction will appear on your Reminders List every time it’s due. You might request this for transactions that will change some every time they’re processed, like a utility bill that’s always expected on the same day, but which has a different amount every month.
  • Do Not Remind Me. Obviously, QuickBooks will not post a reminder if you click this button. This is best used for transactions that don’t recur on a regular basis. Maybe you have a snow-shoveling service that you pay only when there’s a storm. So the date is always different, but everything else is the same.
  • Automate Transaction Entry. Be very careful with this one. It’s reserved for transactions that are identical except for the issue date. They don’t need your approval–they’re just created and dispatched.

Click the down arrow in the field to the right of How Often and select the correct interval. Then click the calendar icon to pick a date for the next occurrence. If you have selected Automate Transaction Entry, the grayed-out lines below Next Date not shown here) contain fields for Number Remaining and Days in Advance to Enter.

How Does QuickBooks Know?

Obviously, you’ll want advance warning of transactions that will require processing. QuickBooks lets you specify how many days’ notice you want for each type. Open the Edit menu and select Preferences. Click Reminders in the left vertical pane, then the Company Preferences tab. You can tell QuickBooks whether you want to see a summary in each category or a list, or no Reminder. Then you can enter the number of days’ warning you want.


Figure 2: QuickBooks lets you specify the content and timing of your Reminders.

Working with Memorized Transactions

Once you’ve created some Memorized Transactions, you will undoubtedly need to review them at some point. QuickBooks makes this happen. Open the Lists menu and select Memorized Transaction List to see all the templates for recurring bills, invoices, etc., that you’ve defined. Right-click on one you want to work with and this menu appears:


Figure 3: The Memorized Transaction List with the right-click window open.

You have several options here. If your list is so long that it fills multiple screens, you can Find the transaction you’re looking for. If you’ve created multiple related transactions, you can save them as a New Group. You can also Edit, Delete, and Enter Memorized Transactions.

Anytime you’re letting QuickBooks do something on its own, it’s critical that you thoroughly understand the mechanics of setting the process up. Please call if you have any questions about the topic of Memorized Transactions. One of our specialists would be more than happy to assist you with this or any other aspect of QuickBooks operations.

Tax Rules for Children With Investment Income

Children who receive investment income are subject to special tax rules that affect how parents must report a child’s investment income. Some parents can include their child’s investment income on their tax return, while other children may have to file their own tax return. If a child cannot file his or her own tax return for any reason, such as age, the child’s parent or guardian is responsible for filing a return on the child’s behalf.

Here’s what you need to know about tax liability and your child’s investment income.

1. Investment income normally includes interest, dividends, capital gains and other unearned income, such as from a trust.

2. Special rules apply if your child’s total investment income is more than $2,100. The parent’s tax rate may apply to part of that income instead of the child’s tax rate.

3. If your child’s total interest and dividend income is less than $10,500, then you may be able to include the income on your tax return. If you make this choice, the child does not file a return. Instead, you file Form 8814, Parents’ Election to Report Child’s Interest and Dividends, with your tax return.

4. If your child received investment income of $10,500 or more in 2017, then he or she will be required to file Form 8615, Tax for Certain Children Who Have Unearned Income, with the child’s federal tax return for tax year 2017.

Please call the office if you have any questions about tax rules for your child’s investment income in 2017.

Tax Tips for Farmers

Are you in the farming business or thinking about it? If so, you should be aware that there may be tax benefits available for you come tax time. Farms include plantations, ranches, ranges, and orchards. Farmers may raise livestock, poultry or fish, or grow fruits or vegetables.

Here are 10 things about farm income and expenses you should keep in mind this year.

1. Crop insurance proceeds. Insurance payments from crop damage count as income. Generally, you should report these payments in the year you get them.

2. Deductible farm expenses. Farmers can deduct ordinary and necessary expenses they paid for their business. An ordinary expense is a common and accepted cost for that type of business. A necessary expense means a cost that is appropriate for that business.

3. Employees and hired help. You can deduct reasonable wages you paid to your farm’s full and part-time workers. You must withhold Social Security, Medicare and income taxes from their wages.

4. Sale of items purchased for resale. If you sold livestock or items that you bought for resale, you must report the sale. Your profit or loss is the difference between your selling price and your basis in the item. Basis is usually the cost of the item. Your cost may also include other amounts you paid such as sales tax and freight.

5. Repayment of loans. You can only deduct the interest you paid on a loan if the loan is used for your farming business. You can’t deduct interest you paid on a loan that you used for personal expenses.

6. Weather-related sales. Bad weather such as a drought or flood may force you to sell more livestock than you normally would in a year. If so, you may be able to delay reporting a gain from the sale of the extra animals.

7. Net operating losses. If your expenses are more than income for the year, you may have a net operating loss. You can carry that loss over to other years and deduct it. You may get a refund of part or all of the income tax you paid in prior years. You may also be able to lower your tax in future years.

8. Farm income averaging. You may be able to average some or all of the current year’s farm income by spreading it out over the past three years. This may lower your taxes if your farm income is high in the current year and low in one or more of the past three years.

9. Fuel and road use. You may be able to claim a tax credit or refund of excise taxes you paid on fuel used on your farm for farming purposes.

10. Farmers Tax Guide. Publication 225, Farmer’s Tax Guide, is a useful resource that you can obtain from the IRS. However, if you have specific questions, don’t hesitate to call.

Scroll to top