Month: September 2018

Accounting

How to Use Memorized Transactions in QuickBooks

Last month’s Quick Books article explored the benefits of having QuickBooks on your desktop. Among those listed were three that impact every business. To recap, QuickBooks helps you:

  • Save time.
  • Save money.
  • Minimize errors.

There are numerous examples that could be used to illustrate how this software accomplishes this but for this month the topic is using memorized transactions. These are templates you set up that contain most if not all the information that could be repeated at specified intervals, eliminating the need for you to enter the same repetitive data regularly and reducing the chances that you’ll make a mistake.

You can create these transaction “models” for both sale and purchase transactions. For example, you might have wireless service bills that remain the same every month or vary by just a bit. Or, you have customers who have monthly standing orders for the same products, or services, or subscription fees.

QuickBooks makes it very easy to set up transactions for repetitive use, and you’ll see how it works in more detail below. We recommend you use one of QuickBooks’ sample files for this tutorial.

Creating a Template

Let’s start by creating a repeating bill. Click Enter Bills on the home page and complete all the fields that will remain the same every time the bill is created. In our example, we’re paying a utility bill whose Amount Due will change every month, so we’re leaving that blank. When you’re done, click Memorize in the toolbar to open this window:


Figure 1: Once you’ve created a transaction template, you’ll have to complete the fields in this window to memorize it correctly.

The vendor name appears automatically in a field in the upper left. Below that is a list of four options. These have to do with how/if you want to be notified when it’s time to process a memorized transaction. Your choices are:

  • Add to my Reminders List. QuickBooks will display an entry in your Reminders List for each memorized transaction. Not using Reminders? Please call.
  • Do Not Remind Me. Nothing will be done.
  • Automate Transaction Entry. You would only select this option if nothing but the date of the transaction changes when it recurs. QuickBooks would automatically process and dispatch the transaction.
  • Add to Group. If you have multiple recurring transactions that come due at the same time, you can create Groups and assign transactions to them (more on this later).

On the right side of the window, open the drop-down list in the field next to How Often and select from the options provided. Click the calendar icon to choose the transaction’s Next (Due) Date. If you only want QuickBooks to automate the entry a specific number of times, add that in the field next to Number Remaining. Then enter the Days In Advance To Enter.

Further Explanation Needed

Let’s expand on two of the concepts discussed here. First, advance notice for transactions. If you’ve selected Add to my Reminders Listfor any memorized transactions, you need to tell QuickBooks how far in advance your reminders should start to appear. Open the Edit menu and select Preferences, then Reminders.


Figure 2: If you want Reminders for memorized transactions, you’ll need to tell QuickBooks what your Preferences are.

Memorized Transactions Due appears toward the bottom of the Company Preferences list. Click on the appropriate button to indicate whether you want to see a summary or a list in your Reminders (or nothing at all) and how many days in advance the alert should appear.

Next, Groups. As mentioned earlier, you can combine memorized transactions due at the same time within a group. To create one, go to Lists | Memorized Transaction List. Click the arrow next to Memorized Transaction in the lower left, then click New Group and give it a name. Choose from the options available for notification and click OK.

Now you can add memorized transactions to this Group by right-clicking on it, selecting Edit Memorized Transaction, and clicking in the button next to Add to Group. Click the down area to the right of the field assigned to Group Name and select the one you just created.


Figure 3: You can add memorized transactions to a Group and process them at the same time.

Caution Advised

This particular QuickBooks feature has been shared with you because software like this can save time and minimize errors. There are many other features that can help you as well, so don’t hesitate to call if you would like to learn more about them.

The mechanics of creating memorized transactions are fairly simple. But mistakes can be costly in terms of bills that don’t get paid on time (or at all) and items or services that don’t get invoiced. If you’re new to QuickBooks, call for assistance as working on your own could be tricky. Even if you’re a seasoned user, you may want help setting up memorized transactions for the first time. Please contact the office if you need assistance with this or any other element of QuickBooks accounting. Help is just a phone call away.

Tax

Tips for Taxpayers: Be Prepared for Natural Disasters

While September and October are prime time for Atlantic hurricanes, natural disasters of any kind can strike at any time. As such, it’s a good idea for taxpayers to think about – and plan ahead for – what they can do to be prepared. Here’s what taxpayers should keep in mind:

1. Update emergency plans. Because a disaster can strike any time, taxpayers should review emergency plans annually. Personal and business situations change over time, as do preparedness needs. When employers hire new employees or when a company or organization changes functions, they should update plans accordingly. They should also tell employees about the changes. Individuals and businesses should make plans ahead of time and be sure to practice them.

2. Create electronic copies of key documents. Taxpayers should keep a duplicate set of key documents in a safe place, such as in a waterproof container and away from the original set. Key documents include bank statements, tax returns, identification documents and insurance policies.

Doing so is easier now that many financial institutions provide statements and documents electronically, and financial information is available on the Internet. Even if the original documents are provided only on paper, these can be scanned into a computer. This way, the taxpayer can download them to a storage device like an external hard drive or USB flash drive.

3. Document valuables. It’s a good idea for a taxpayer to photograph or videotape the contents of their home, especially items of higher value. Documenting these items ahead of time will make it easier to claim any available insurance and tax benefits after the disaster strikes.

How to Obtain a Copy of a Tax Return

Taxpayers who need a copy of their prior-year tax return have several options. If they:

  • Went to a paid preparer, they might be able to get a copy of last year’s tax return from that preparer.
  • Used the same tax preparation software this year that they used last year, that software will likely have their prior-year tax return.
  • Didn’t use the same tax preparation software this year, they may be able to return to their prior-year software and view an electronic copy of that return.

How to Get a Transcript

Taxpayers who are unable to access prior-year tax return using the above methods can get a copy of their transcript by calling the office directly or going to IRS.gov and using the Get Transcript application. By selecting “Get Transcript Online,” the taxpayer can immediately view, print or download their transcript. If they prefer to have a copy sent to the address that the IRS has on file, they can select “Get Transcript by Mail.” They should receive their transcript in the mail in five to 10 days from the time the IRS receives their request online.

Tax

Ten Tax Tips for Individuals Selling a Home this Year

In most cases, gains from sales are taxable. But did you know that if you sell your home, you may not have to pay taxes? Here are ten facts to keep in mind if you sell your home this year.

1. Exclusion of Gain. You may be able to exclude part or all of the gain from the sale of your home. This rule may apply if you meet the eligibility test. Parts of the test involve your ownership and use of the home. You must have owned and used it as your main home for at least two out of the five years before the date of sale.

2. Exceptions May Apply. There are exceptions to the ownership, use, and other rules. One exception applies to persons with a disability. Another applies to certain members of the military. That rule includes certain government and Peace Corps workers. For more information about these exceptions, please call the office.

3. Exclusion Limit. The most gain you can exclude from tax is $250,000. This limit is $500,000 for joint returns. The Net Investment Income Tax will not apply to the excluded gain.

4. May Not Need to Report Sale. If the gain is not taxable, you may not need to report the sale to the IRS on your tax return.

5. When You Must Report the Sale. You must report the sale on your tax return if you can’t exclude all or part of the gain. You must report the sale if you choose not to claim the exclusion. That’s also true if you get Form 1099-S, Proceeds From Real Estate Transactions. If you report the sale, you may need to pay the Net Investment Income Tax. Please call the office for assistance on this topic.

6. Exclusion Frequency Limit. Generally, you may exclude the gain from the sale of your main home only once every two years. Some exceptions may apply to this rule.

7. Only a Main Home Qualifies. If you own more than one home, you may only exclude the gain on the sale of your main home. Your main home usually is the home that you live in most of the time.

8. First-time Homebuyer Credit. If you claimed the first-time homebuyer credit when you bought the home, special rules apply to the sale. For more on those rules, please call.

9. Home Sold at a Loss. If you sell your main home at a loss, you can’t deduct the loss on your tax return.

10. Report Your Address Change. After you sell your home and move, update your address with the IRS. To do this, file Form 8822, Change of Address. You can find the address to send it to in the form’s instructions on page two. If you purchase health insurance through the Health Insurance Marketplace, you should also notify the Marketplace when you move out of the area covered by your current Marketplace plan.

Questions? Help is just a phone call away.

Scroll to top