Merging duplicate items and/or accounts in QuickBooks is preferable to making journal entries.
Rather than performing journal entries to move the money all into one account and then making the duplicate account inactive – it’s easy to merge the two accounts together.
BEFORE you attempt this procedure – make a backup of your QuickBooks company data file and run any necessary year to date reports for comparison after the merge.
Let’s say, for example, in your Chart of Accounts you have an account called Delivery and another one called Postage & Delivery; you’ve decided that you want all of the dollars you spend tracked under the Postage & Delivery account.
Edit the “Delivery” account (Chart of Accounts -> right-click on Delivery -> choose Edit Account); changing the Account Name to Postage and Delivery and the number to 6610.
When you are finished editing, click the Save & Close button. QuickBooks will display a message box indicating that the account number is already being used and asks if you would like to merge them. Select Yes.
The two accounts are now merged into one.
This same procedure can be utilized for duplicate customers, vendors, items, etc.
4 Responses to QuickBooks Tip – Merging Duplicate Items and/or Accounts
- Using Account Numbers in Your QuickBooks Chart of Accounts
- Straight from the IRS - Social Security Tax Reduced to 4.2%
- QuickBooks 2012 - Frequently Asked Questions About Upgrading
- QuickBooks 2013 Upgrade Do's, Don'ts & Frequent Questions
- Calculating & Displaying Fringe Benefits on a Certified Payroll Report
- QuickBooks Payroll Tip - Tracking Employee Advances or Loans
- QuickBooks Tip - Job Costing Starts With A Simple Item
- QuickBooks Tip-Handling Employee Reimbursements for Expenses
- QuickBooks Tip - Determing Cost of Goods Sold
- QuickBooks for Contractors Tip – Advanced Progress Invoicing
- QuickBooks Creating a More Meaningful Payroll Expenses Section
- QuickBooks 2012 Announced
- QuickBooks for Contractors Tip – Basics of Progress Invoicing
- New FHWA-1391 & 1392 Annual EEO Forms For Highway Contractors
- Frequently Asked Questions - California Prevailing Wage
- QuickBooks 2012 - Best Practices & Tips for Installing an Upgrade
- QuickBooks Tip - Child Support Garnishments
- QuickBooks 2011 - New Balance Sheet by Class Report - Part 1
- Create a QuickBooks Job Cost Report With Hours & Payroll Costs
- QuickBooks 2011 - Computer Requirements & Office Compatibility
Join us on the 2nd Wednesday of each month, from 5-6 p.m. EST, on Google+ for the QuickBooks for Contractors hangout!
Webinar - QuickBooks Job Costing from A-Z
Having trouble getting job costing reports out of QuickBooks? Or maybe you are wondering if the information you see is accurate. Setup is KEY! Join us for an intensive 1 1/2 hour webinar covering job costing techniques and procedures on Wednesday March 26, 2014 from 1-2:30 p.m. EST. Sign up here.