Create, Edit, or Delete Memorized Transaction in QuickBooks

by James Antonio

In business handling, there are some transactions, customers, or events that you come across on regular basis, or in other words, they happen on a recurring basis. You would definitely want a feature which would help you create a template for recording these types of transactions, event in your accounting software so that you don’t have to start from scratch for the repeated transactions in every period.

And for catering to this very need QuickBooks has a memorized transaction feature which would create a memorized template for your recurring transactions that too for required time interval like weekly, monthly, quarterly, or annually.

In the case of an annual recurring transaction, it is often better to create the memorized template, because most of the time we forget about the posting or other details for the transactions that happen only once a year.

Not just this, as with the help of memorized transactions you will not have to start from scratch for the recurring transaction every time, which will save you a lot of time and manual effort.

This also reduces the scope of little mistakes and errors as most of the details will already be there in the memorized transaction template, you will just have to change the amount, posting date, and description (if required).

In this article, we will look into the process of creating, editing, and deleting the memorized template in QuickBooks.

How to Create, Edit or Delete Memorized Transactions in QuickBooks?

Steps for Creating Memorized Transaction

You can create a memorized transaction by following below list of steps:

Step 1. First of all, enter all the details of the transactions and double-check them, do not save them. Ensure that you leave the details that may change from period to period as blank like memo no., posting date, etc.

Step 2. Now from the Edit menu choose to Memorize, enter a name and choose either ‘Add to my Reminder list’ > and ‘How often’ for determining the frequency, or ‘Do not Remind me’, in this option the transaction would not be added to your reminder list but you can use the template from time to time.

Lastly, you can also select Automate transaction entry > enter how often and next date field. And transaction will be posted automatically when it’s due.

Step 3. Now enter all the other required details and click on Ok, choose to save and close and click on Next again.

Steps for Editing the Memorized Transaction

You need to follow the below simple steps for editing a memorized transaction:

Step 1. Click on the List menu and choose memorized transaction list and double click on the transaction that you wish to modify or edit.

Step 2. Now make the required changes and choose to Memorize from the top.

Step 3. Now click on replace to update the transaction or Add for creating a new one.

Step 4. In the last step, just click on save and close or save and next to finalize the process.

Steps for Deleting the Memorized Transaction

Deleting the Memorized Transaction
Deleting the Memorized Transaction

For deleting a memorized transaction, you need to follow the below steps:

Step 1. Click on the List menu and select Memorized transaction as we did at the time of editing in the above process.

Step 2. Now choose the transaction that you wish to delete, select the memorized transaction drop-down and choose to Delete the memorized transaction, and click on OK.

You can use the above super-simple steps to create, edit or delete the memorized transaction template anytime you want and make your life a bit easier. Now let us move towards some frequently asked questions from end-users to have a little more clarity on related queries and issues. This may serve you as a cheat sheet when you performing related QuickBooks functions.

How can I Delete a Memorized Transaction Report in QuickBooks?

You can do so by going to Reports > select memorized reports > memorized report list. Now locate the report that you wish to delete, right-click and choose Delete Memorized report to finally delete it.

What are Memorized Reports used for in QuickBooks?

The memorized reports are the ones that you saved in their customized settings; you can use these reports for getting the data displayed in a similar format every period. There are some recurring reports and analysis that business needs on a recurring basis. This will help you in accessing the report in the format you required without starting from scratch every time.

What will Happen if I Exclude a Transaction for a Period in QuickBooks?

Excluding a transaction, will lead to it not appearing in the account register or financial reports in QuickBooks. So, it is recommended that you be very careful and ensure that you are taking the right action before you excluded a downloaded transaction in QuickBooks.

Where can I find and Access a Memorized Report in QuickBooks?

First of all, go to the Reports menu and select the report centre. On the report centre window, choose the memorized tab. Now on the left panel, select the appropriate group, if the report has not been assigned a group then choose uncategorized. Now double click on the report to open it.

Can you Please List down the steps to Delete an Excluded Transaction in QuickBooks Online?

First of all, open QB online on your web browser and log in with your credentials. After that, you need to go to the transaction menu > find the transaction that you wish to delete and select it to expand the view and choose delete.

What are the steps for saving a Custom Report in QuickBooks?

First of all, go to the reports > choose Custom reports. Now look out for your desired report and click on Edit. Now remove the report’s group name from Add this report to a group drop-down menu and click on save to complete the process.

Features of Dancing Numbers for QuickBooks Desktop





How Dancing Numbers Will Help You


Dancing Numbers is SaaS-based software that can easily be integrated with your QuickBooks account. You can import, export, and delete lists or transactions from your company file. Using Dancing Numbers you can simplify and automate the process, saving time and increasing productivity. Just fill in a few fields and apply the relevant features to complete the task.

It saves your time and money that you can invest in your business. It has no human errors, works automatically, provides a user-friendly interface (easy to use and learn), and more. You can also have access to the comprehensive features set if you use it to import, export, and delete services.

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Receive Payment
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Journal Entry
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items


Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Devices Supported

  • Windows


  • On Premise

Language Support

  • English

Pricing Model

  • Annual Subscription

Customer Types

  • Small Business
  • Medium Business



Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete


Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies


Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies


Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Frequently Asked Questions

How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.

How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.

How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.

How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.

Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.

What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.

How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.

How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.

Get Support

The Bulk Import, Export, and Deletion can be performed with just an easy single-click. We offer a simplified process that assures you that you will be able to focus on your core work.

Are you worried about losing your time with error-prone software? Worry no more. Our error-free add-on lets you focus on your work and boost your productivity rate to a considerable extent.

Most Recent Updates