Intuit Accountants News Central

How to Batch Enter Transactions in QuickBooks®

Article Post Date
November 20th 2013 by

QuickBooksThe improved Batch Enter Transactions’ feature in QuickBooks® Accountant 2014 is designed for accounting professionals who want to work more efficiently and profitably when providing write-up services for their clients. It also is good for companies using QuickBooks Enterprise Solutions 14.0 and want to quickly add data to their QuickBooks file. This feature is included with QuickBooks Accountant 2014 and all editions of QuickBooks Enterprise Solutions 14.0 software.

Use Batch Enter Transactions for adding the following transaction types to a QuickBooks data file:

With Batch Enter Transactions feature you can:

Save hours of time entering multiple transactions, such as those from handwritten documents.

View this feature in action on YouTube or click the box below (note: in some browsers, the YouTube box may not be visible; click on the link to see the video):

Follow these few steps for using the improved Batch Enter Transactions feature:

1. Launch Batch Enter Transactions from the Accountant Center or the Accountant menu. For QuickBooks Enterprise users, you can access the Batch Enter Transactions from Banking, on the menu bar.

2. Select the desired transaction type from checks, deposits, credit card charges, credits, bills and bill credits, invoices and credit memos.

3. Click Customize Columns button on the right to display the columns of data desired and to rearrange the order of the columns.

4. Begin typing data into the Batch Enter Transactions grid for the selected transaction type. For the Write Check or Invoice transaction type, QuickBooks will automatically populate the next incremental transaction number.

5. Optionally, select a specific row, and click the Split button in the lower left. The image       below shows how to enter multiple lines for a single customer invoice.

6. Optionally, copy Excel data to the clipboard (using any common Excel copy functionality include right-clicking and selecting copy or highlighting cells of data and selecting the Ctrl + C on your keyboard).

Caution: Make sure your columns of data in the Batch Enter Transactions dialog window match the cells of data you are copying in Excel. If you are not using account numbering, you will need to type the name of the account exactly as it is in QuickBooks. If the account, name or item is not found in the file you will have the option to add it to the respective list.

7. On the Enter Batch Transactions dialog box, right click with your cursor in the field you want to populate. In the image below, I have selected the top left cell and after selecting Paste from the right click menu, the data from Excel will prefill the grid.

8. For any fields without matching data in QuickBooks, begin typing the proper information for the field. The Customer:Job field displayed in red in the image below is does not exist in the QuickBooks file. Select the file with your cursor and QuickBooks will provide the option of adding it to your QuickBooks file.


Note: In the lower right you can see the total of the transactions to be saved and compare with your original source documents.

9. Click the Save Transactions button and QuickBooks notifies you of the number and type of transactions saved to your QuickBooks file.

A quick review of your accounts receivable register shows the added transactions. If any transactions were incomplete, they will be displayed in the Batch Enter Transactions window for you to complete. The single item displayed below was missing the item on the excel spreadsheet.

Now, wasn’t that easy! Accounting professionals providing write-up work can be more profitable by working more efficiently. QuickBooks Enterprise Solutions 14.0 users can access this same feature for entering batch transactions.


Share and Enjoy:
  • Facebook
  • Twitter
  • LinkedIn
  • Digg
  • StumbleUpon
  • Technorati
  • Google Bookmarks
  • RSS
  • Print
  • PDF
  • email
  • About Laura Madeira

    Laura Madeira is the owner of ACS, Inc.; recently named to the Top 10 QuickBooks ProAdvisors, is also a Intuit Premier Reseller firm providing software sales and training for QuickBooks Enterprise, Premier and Pro, QuickBooks Point of Sale Software and Hardware, Intuit Merchant Services and Intuit Payroll solutions. She is also certified in QuickBooks Enterprise, QuickBooks Point of Sale and Advanced Certified in QuickBooks and offers training on several other software solutions. Information about their services can be found at ACS. Laura is a select member of the Intuit Trainer/Writer Network and has been a guest speaker for Intuit for many years, teaching what is new for QuickBooks each year and speaking at multiple accountant and end users conferences nationally. She is also a published author of QuickBooks training materials. She has authored the QuickBooks 2014 In Depth, QuickBooks Solutions Guide, QuickBooks Live Lessons self-paced training DVDs and QuickBooks on DemandSee all of Laura's articles…

When commenting, please be polite and use the site for your own personal, non-commercial use. For the full legalese of dos and don'ts, see our Online Community Terms of Use. Thanks!

No Comments »

No comments yet.

RSS feed for comments on this post.

Leave a comment

You must be logged in to post a comment.

© 2016 Intuit Inc. All rights reserved. Intuit, the Intuit logo, QuickBooks, ProSeries and Lacerte, among others, are registered trademarks and/or registered service marks of Intuit Inc. or one of its subsidiaries. Other parties' marks are the property of their respective owners. Terms, conditions, features, pricing, support and service are subject to change at anytime without notice.

The views expressed on this blog are those of the bloggers, and not necessarily those of Intuit. Third-party blogger may have received compensation for their time and services. Click here (to read full disclosure on third-party bloggers.  This blog does not provide legal, financial, accounting or tax advice. The content on this blog is "as is" and carries no warranties. Intuit does not warrant or guarantee the accuracy, reliability, and completeness of the content on this blog. After 20 days, comments are closed on posts. Comments are subject to moderation. Comments that include profanity or abusive language will not be posted. Click here to read full Terms of Service.