QuickBooks Tips

How to Use Memorized Transactions in QuickBooks

10/14/2020

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 will 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 will 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 are paying a utility bill whose Amount Due will change every month, so we are leaving that blank. When you are done, click Memorize in the toolbar to open this window:

How To Use Memorized Transactions In Quickbooks

Figure 1: Once you have created a transaction template, you will 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 is 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 List for 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.

How To Use Memorized Transactions In Quickbooks

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.

How To Use Memorized Transactions In Quickbooks

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.

Ask a Question

Find comfort in knowing an Expert in accounting is only an email or phone-call away.

We Are Here to Help

We will happily offer you a free consultation to determine how we can best serve you.

Blog

Attestation Services: Compilations, Reviews, and Audits CPAs offer attestation services as unbiased options

frequently asked questions

  • What Is A Virtual CFO & How Can It Transform My Business?
    • a. A Virtual CFO can be a much-needed sounding board, coach, and guide. Outsourced Virtual CFO is generally not just one person, but an experienced team of professionals providing a full-stack Accounting and Finance Department at a fraction of the cost that it would otherwise cost a business to hire even just one full-time CFO internally. The right virtual CFO service team, such as the one at Perpetual CPA, can deliver timely, detailed, comprehensive financial reporting, interpret the financial data, prioritize recommendations, give expert guidance on how to execute those recommendations, and ultimately give a better path to business success.
  • How can a Virtual Accounting Department help small businesses scale and grow?
    • a. A growing number of small businesses are opting to outsource services such as IT, human resources, or accounting. The benefit of a Virtual Accounting Department is that the company can reduce or increase services to accommodate current business needs. Because the service provider has multiple clients they can absorb fluctuations in workflow more easily than the average small/medium business can on its own.

      b. A Virtual Accounting Department can integrate with a company’s own accounting department to create a blended solution or provide a full-stack accounting department, including Accounting Staff, Manager, Controller, and Virtual CFO. By using a Virtual Accounting Department Small business owners don’t have to worry about hiring, training, figuring out compensation, and payroll compliance for the internal accounting team. Also as the business grows and new and more complex accounting and tax issues come up, the outsourced Virtual Accounting Department can provide all the needed expertise to facilitate continued business success.
  • What are the benefits of hiring a CPA firm?
    • a. Certified Public Accountants (CPAs) do a lot more than just crunch numbers and prepare taxes. They provide valuable expertise and strategies to help businesses and individuals achieve their business and financial goals. A CPA firm can help small businesses with management financial reporting, tax compliance, strategic business advice, and much more. Firms like Perpetual CPA, that specialize in helping small and medium-sized businesses achieve growth, can also provide Virtual CFO services, that help the business owners have the foresight into the short-term future cashflows and be able to more successfully navigate their business performance.
  • What are the best strategies for small business growth?
    • a. A business growth strategy is, simply, a plan of how a business gets from where it is today to where it wants to be in the future.

      b. Some of the questions to consider when coming up with a growth strategy are:
      i. Where will the business get new customers from?
      ii. How will the business expand into new markets?
      iii. What new products could the business offer?

      c. In reality, what happens with many small businesses, is that they generally achieve a specific level of business activity or sales and then the business growth trend flattens. In those cases, working with a firm like Perpetual CPA, which provides Virtual CFO services, can help small businesses avoid stagnation. Virtual CFO services, aside from providing timely accounting and tax reporting, can also provide valuable insight into the current performance of the business, as well as, foresight into the future cash flows for the business. Perpetual CPA Virtual CFO team helps small businesses interpret their financial information and come up with business strategies to help improve business performance and achieve growth.
  • What are the best strategies for small business risk management?
    • a. A risk management plan helps a business develop a detailed strategy to deal with certain risks that are particularly important for the businesses’ success.

      b. For many small and medium-sized businesses, the easiest way to develop and implement a business risk management plan is to work with a reputable CPA firm, such as Perpetual CPA. Large corporations invest a lot of resources and time into managing risk, which is a material factor that allows those large corporations to continue to generate billions of dollars in revenue every year. Small businesses, however, almost never manage any business risks, which is the major reason that over half of all the small businesses do not survive for more than 5 years. Generally, small business owners are not experienced corporate business professionals and lack the needed business knowledge, yet they often have to wear many hats while trying to get their businesses off the ground. In those situations, a CPA firm such as Perpetual CPA, can help small businesses better manage tax compliance risks, cash flow, internal controls, business administration, financial reporting, and much more.
  • What is Strategic Advisory and Virtual CFO? / How do Strategic Advisory and Virtual CFO services work?
    • a. When small businesses start spinning wheels, it is a good time to consider hiring a reputable CPA firm, such as Perpetual CPA, which can provide both Strategic Advice and Virtual CFO services.

      b. As a strategic advisor, the CPA firm will work with business management to improve the effectiveness and profitability of the business. They will look holistically at the business and find ways to operate the business more efficiently, increase customers through additional or improved marketing or improve customer touchpoints and service.

      c. As a Virtual CFO, the CPA firm is like a part-time version of a traditional CFO or Chief Financial Officer plus a full Accounting support team. They perform the tasks that in a larger organization would be performed by the CFO, Controller, and Accounting Staff such as preparing and overseeing the budget process, identifying and analyzing current and future trends, and developing strategies for the business growth.
  • How can timely financial visibility and management reporting help with better business decisions and growth?
    • a. A simple way to a successful business is to prioritize the timely financial visibility and management reporting as it means:
      i. Timely financial information and analysis are essential for making informed decisions, evaluating your company’s results, improving financial performance, and ensuring you are on the path to meet your strategic goals.
      ii. Management reporting is a source of business intelligence that helps business leaders make more accurate, data-driven decisions. But, these reports are most useful if they are available timely and the management receives proper interpretation of the business financial information.

free initial 30-minute consultation

© Perpetual CPA 2020   •   Site Map   •   Privacy Policy   •   Disclaimer   •   Powered By   Designed by Dot Com Media Moguls