Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
rschmidt46
Level 2

Customer Widowed, Customer Married

My company is a non-profit (local church congregation). My "customers" are donors. One customer was recently widowed. The customer has historically been under both the husband's and wife's name. Now all the donations come from the widow only.
In another instance, a customer got married and adopted the husband's name. The customer was historically under the woman's maiden name. Now it should be under both the husband's and wife's name.
Is there a way to merge the customer profiles in such a way that the history is retained? The QB instructions on merging customers imply that one of the merged entities will become inactive. I am looking for a way to reflect the donations by the woman before she got married and not incorporate them into the customer name under both husband and wife. The similar situation exists with the widow. I don't want to lose the record of contributions by the husband and wife now that the customer is just the widow.
Is there a solution to this issue?

3 Comments 3
MichaelaS
QuickBooks Team

Customer Widowed, Customer Married

Thank you for sharing the details with us, rschmidt46.
 

I see you have two separate customer profiles with similar situations, and you want to keep their historical data but move forward using their updated profiles. Let me explain what options you have.
 

QuickBooks Desktop does not allow profiles to be merged if they have existing transactions. If you want to merge, you need to delete the transactions from both profiles, save a copy and manually re-enter them, or consolidate all payments (to have a transfer history), then record the total into the new profile after merging.
 

Please note, when a profile is merged, the system saves the merged customer as inactive or deleted, as QuickBooks removes the original profile from your records and moves their transactions into the other profile’s history. This ensures your end books and financial reports will remain accurate.
 

Here’s how to merge profiles:

1. Click the Customers menu and select the Customer Center.
2. Open the profile you want to keep and copy the name.
4. Go to the other profile, then paste the name you wan to keep (Make sure the display name exactly matches the other profile you want to merge with.)
5. Click Yes to save changes..


Alternatively, if you want to preserve historical data without deleting or merging transactions, I suggest to keep the old profiles active to maintain their records and use the new profiles for future transactions or updates.
 

Please leave us a response if you have other questions or concerns.

rschmidt46
Level 2

Customer Widowed, Customer Married

I would not consider this a very robust solution.  Deleting all the transactions for one customer and re-entering them under another is highly impractical.  Transactions for the woman who got married total 157 entries.  Transactions for the one who was widowed include 162 entries.  For tax purposes, merging customers would make it impossible for them to match the contributions entered in QB with their tax returns.  I hope there is a better way to handle this and it is a situation that must occur regularly.

JamaicaA
QuickBooks Team

Customer Widowed, Customer Married

I understand that deleting and re-entering hundreds of transactions is time consuming, especially with the important tax considerations you've raised. I've got another way you can consider for a more streamlined solution, rschmidt46.

 

You can open the existing transactions one by one under the old customer name and move them to the updated profile you want to keep. This process moves the entry to the other customer's record seamlessly. For instance, to transfer the transactions from Customer K (Maiden Name) to Customer J (Husband's name), follow the steps below:

 

  1. Go to the Customers menu at the top, then select Customer Center.
  2. On the Customers & Jobs list, locate the old customer's name (Customer K).
  3. Navigate to the Transactions tab, then open an entry. Let's say, an Invoice.
  4. Under the Customer:Job dropdown menu, choose the new customer name (Customer J).
  5. If a message will prompt about the changes, click Yes.
     

Once done, let's set the original customer name (Customer K) with no transactions to Inactive. This cleans up your active Customer Center and ensures only the current donor or customer names appear when recording new transactions. Here's how to do that:

 

  1. On the Customer Information section, click the Pencil icon to edit.
  2. Tick the Customer is inactive checkbox, then select OK.

 

Check out this article to learn what are the things you need to do before the process: Merge list entries in QuickBooks Desktop.

 

Let me know if you need additional guidance when working or handling customers. We'll be here to assist you further.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us