cancel
Showing results for 
Search instead for 
Did you mean: 
dsi2005-optonlin
Level 2

I entered the incorrect amount for a customer's opening balance. How do I correct this?

how do i fix a customer's opening balance
Solved
Best answer March 31, 2021

Best Answers
Jovychris_A
Moderator

I entered the incorrect amount for a customer's opening balance. How do I correct this?

I'll help you fix the customer's opening balance, @dsi2005-optonlin.

 

You can delete the invoice created under its name (once you created an opening balance, it automatically creates an invoice). Simply go to the Sales menu and then select Customers.

 

Then you can follow these steps further:

  1. Select the customer in question.
  2. On the Action column, click the triangle button.
  3. Select Delete.

 

Once done, you can then recreate the invoice with the same dates and enter the correct amount. You will then have accurate A/R aging and as well as cash or accrual financial reports.

 

You can run the Trial Balance report to review the new customer's Account Receivable (A/R) opening balance/beginning balance.

 

  1. Click the Search icon on the top right.
  2. Enter Trial and then select Trial Balance.
  3. Select the amount on the Debit column of Accounts Receivables (A/R).
  4. Adjust the Report period.
  5. See the customer opening balance.

 

I've also added an article to learn more about how to efficiently utilize reports: Run reports in QuickBooks Online. It includes links like how to customize and memorize reports.

 

Please let me know how it goes. Anytime I can assist you. Have a lovely day!

View solution in original post

3 Comments 3
Jovychris_A
Moderator

I entered the incorrect amount for a customer's opening balance. How do I correct this?

I'll help you fix the customer's opening balance, @dsi2005-optonlin.

 

You can delete the invoice created under its name (once you created an opening balance, it automatically creates an invoice). Simply go to the Sales menu and then select Customers.

 

Then you can follow these steps further:

  1. Select the customer in question.
  2. On the Action column, click the triangle button.
  3. Select Delete.

 

Once done, you can then recreate the invoice with the same dates and enter the correct amount. You will then have accurate A/R aging and as well as cash or accrual financial reports.

 

You can run the Trial Balance report to review the new customer's Account Receivable (A/R) opening balance/beginning balance.

 

  1. Click the Search icon on the top right.
  2. Enter Trial and then select Trial Balance.
  3. Select the amount on the Debit column of Accounts Receivables (A/R).
  4. Adjust the Report period.
  5. See the customer opening balance.

 

I've also added an article to learn more about how to efficiently utilize reports: Run reports in QuickBooks Online. It includes links like how to customize and memorize reports.

 

Please let me know how it goes. Anytime I can assist you. Have a lovely day!

dsi2005-optonlin
Level 2

I entered the incorrect amount for a customer's opening balance. How do I correct this?

Thank you!  This worked!

I am new to QuickBooks and it wasn't super intuitive to figure this one out.

I appreciate your assistance and will likely be back with more questions :-)

 

 

dsi2005-optonlin
Level 2

I entered the incorrect amount for a customer's opening balance. How do I correct this?

Thank you!  This worked!

 

I am new to QuickBooks and this was not super intuitive to figure out.  

I appreciate your assistance and will likely be back for more help!

 

Need to get in touch?

Contact us