Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
kurt_walton
Level 1

Bulk update payments to change the Deposit To account?

The client received a years worth of payments and used the bank account in the deposit to field instead of undeposited funds.  Then posted all deposits to the income account.

I know I can bulk update deposits to undeposited funds, but how can I move the hundreds of Payments received from the bank account to undeposited funds? 

3 Comments 3
CamelleT
QuickBooks Team

Bulk update payments to change the Deposit To account?

I'll guide you in moving payments, kurt.

 

We can create a journal entry for all the payment transactions. This will let you move money between accounts and force your books to balance.

 

Here's how you can create a journal entry:

 

  1. Click +New.
  2. Select Journal entry.
  3. On the first line, select an account from the Account dropdown. Enter the amount in the correct column depending if it's debit or credit.
  4. On the next line, select the account you're moving money to. Enter the same amount in the opposite column depending if it's debit or credit on the first line.
  5. Check the amounts. The Credit and Debit should have the same amount in their respective column. This means the accounts are balanced.
  6. Select Save and close or Save and new if you need to create another. 

To accurately handle your account, I suggest seeking advice from your Accountant.

Additionally, I'll also add an article so you can fix debit and credit errors: Reverse or delete a journal entry in QuickBooks Online (intuit.com).

 

Just drop a message below if you have further questions about moving your payment transactions. Take care!

kurt_walton
Level 1

Bulk update payments to change the Deposit To account?

Thank you for your work around suggestion.

That is actually what we did for prior years to clean up their mess, but we were hoping for a "correct" solution for 2023, meaning, a way to actually modify all the payments to reflect the correct account (undeposited funds).  Obviously doing hundreds by hand is a waste of time / money.

The work around you suggest leaves quite a mess and lots of questions if someone every needed to go back.

Again, thank you for your time

 

 

JessT
Moderator

Bulk update payments to change the Deposit To account?

Welcome back to the thread, Kurt.

 

I understand that you're seeking a convenient option to transfer multiple payment transactions from a bank account to the Undeposited Funds account. This would streamline your process and make it easier for you to manage the transactions of your client.

 

While we're unable to do the mentioned procedure, I'm encouraging you to submit feedback. This way, our engineers can consider adding such an option in future updates.

 

  1. Go to the Gear icon.
  2. Choose Feedback.
  3. Enter a summary of the feedback and click Next.

 

If you have other questions on the process of correcting your client's books, feel free to go back to this thread.

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

Need to get in touch?

Contact us