How to Change an Account for Multiple Entries in QuickBooks
By Avery Martin
The ability to add several entries across different categories saves you time when entering information into QuickBooks. You can edit multiple customers, vendors, inventory and noninventory items using the appropriate multiple list entry feature in the software. The multiple list entries eliminate the need to switch between the different centers used to manage information. If you have an Excel file, you can also copy and paste information directly from the file into QuickBooks.
Select the "Lists" menu and choose "Add/Edit Multiple List Entries."
Click the "List" drop-down menu and choose the list with which you want to work. You can select "Customers," "Vendors," "Service," "Inventory Items" or "Noninventory Items."
Focus your results by clicking the "View" drop-down menu and selecting the type of record you want to edit. You can also click "Customize Columns" and add, remove or rearrange the columns.
Select the first empty row and input the information for each column. Common columns include name, quantity and description. You can highlight a column in your Excel spreadsheet and press "Ctrl-C" to copy the data and then press "Ctrl-V" to paste the data.
Click "Save Changes" when you complete your entries. If QuickBooks notifies you of any errors, fix the errors and click "Save Changes" again.
Copy the information from one field into all of the available fields below it by right-clicking on the field and selecting "Copy Down."
Duplicate a row by right-clicking on any row and selecting "Duplicate Row." The row gets duplicated directly below the current row.
Information in this article applies to QuickBooks 2013. It may vary slightly or significantly with other versions or products.
Avery Martin holds a Bachelor of Music in opera performance and a Bachelor of Arts in East Asian studies. As a professional writer, she has written for Education.com, Samsung and IBM. Martin contributed English translations for a collection of Japanese poems by Misuzu Kaneko. She has worked as an educator in Japan, and she runs a private voice studio out of her home. She writes about education, music and travel.