cancel
Showing results for 
Search instead for 
Did you mean: 
funnygirl238
Level 1

Customers and Sub Customers

I have a customer and then a subcustomer.  I created an invoice under the subcustomer and then when the customer paid the payment was accidentally applied to the customer instead of the subcustomer.  The invoice shows as paid; however, in the total column of the subcustomer it still shows the balance there for that invoice.  How do I get this balance out of that total column?  The other factor that may hamper this is that the invoice was from about two years ago...Any assistance would be appreciated!

 

Thank you!

3 Comments 3
JamesAndrewM
QuickBooks Team

Customers and Sub Customers

Hello there, @funnygirl238.


It's great to have you here in Community.

 

Let's open the payment transaction and then change the customer from there. Please know that anything you do with the reconciled transaction, aside from the date and amount won't affect the reconciliation.

 

You can follow these steps on how to change the customer on the said transaction:
 

  1. Go to Sales tab and select Invoices
  2. Look for the specific customer and click on the Pencil Icon
  3. Change the Customer to the correct Sub-customer 
  4. Click Save and Close once done.

 

For future reference, I'm adding a link which contains possible steps to resolve common reconciliation issues: Fix issues at the end of a reconciliation in QuickBooks Online.

 

If you have any further concerns about your transactions, don't hesitate to post it here. Have a great day!

funnygirl238
Level 1

Customers and Sub Customers

Thank you! I do see how this would work; however, my transaction was from 2020 so it is not showing and it doesn't give me an option to bring this transaction up.  How do I access this transaction?

MariaSoledadG
QuickBooks Team

Customers and Sub Customers

I have some information that I want to share with regard to your transactions, funnygirl238.

 

QuickBooks Online (QBO) provides a wide range variety of reports that you can generate so you'll know the aspects of your business. For now,  you can only pull up transactions including reports of up to 12 months or the equivalent of 1 year. Thus, it would best to export them from QuickBooks Online to Excel so you'll not be missing data and retain a copy for each year. To export, you can follow the steps outlined below: 

 

  1. Go to Business overview and select Reports (Take me there).
  2. Search for and select the report you want to export.
  3. At the top of the report, select the Export icon. Then select Export to Excel.
  4. Save the file somewhere you can easily find it, like your Downloads folder or your desktop.

Furthermore, when running reports, you can filter them to show specific information that you want. To know more about how to customize reports and focus more on the details that you need most, I've added this article that provides you with the steps on how to do it: Customize Reports In QuickBooks Online.

 

Get back to us if you have any further questions about your transactions. We're here to help you as always.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us