Question

Why won't customer name update when I change it in bank register entry?

Forum|Forum|4 years ago
January 22, 2022
1 reply
7 views

I am creating books going back several years based on bank statements. I created a customer "TBD" as a placeholder until I can find documents to show who the bank deposit was from. When I go in and set up the proper customer, and then replace the TBD with their name, Save it and close it, it still shows up as "TBD" Why? and how to fix?

QuickBooks Online

P

Pete_Mc

Level 5

The "TBD" entries have not been Reconciled have they? And is "TBD" a Customer or an Other Name entry? And there are no other error messages? If you've closed that year it might also cause issues.

It is strange that you cannot change the entry without some indication of why.

To start, I'd create a generic "Deposit" in the Other Name List and use that instead of TBD. It is something you may end up using for transfers from a Cash Acct into Checking or the other way if you're taking Cash On Hand (what people also call Petty Cash) out of Checking.

And how are you "finding" where the Deposits came from? Are you using old Invoices and by any chance are you creating TBD Place Holder Invoices? If so, are those Invoices shown as Paid because you called them TBD in both places (again goes back to my question if TBD is a Customer or not).

If there's any kind of error message, let us know what it is.

K

kahandler-me-comAuthor

1. Entering transactions from bank statements while waiting for bank to provide copies of checks behind each deposit.

2. Company does NOT use the invoicing function. Checks are from donors.

3. Yes, bank accounts were reconciled as dollar amounts were available and we could tie out accounts.

4. Now that bank has provided backup, I can change all the TBD's to the proper customer (actually, donor) name.

5. I receive the warning that "This transaction has been reconciled...are you sure, etcetc." when I go to save the updated transaction. I say yes.

6. No Petty cash.

P

Pete_Mc

Level 5

Yea, the warning is that you're Unreconciling, so that makes sense. Still not sure why it won't let you change the name though.

I'd make sure all the names are added into QBs and then go through and try and make the change. If it still doesn't let you, rather than trying to figure it out, just delete the TBD entry and add the Deposit with the correct name. You will get and need to Accept the unreconcile error whether you delete or change the name.

OH! If you were saying No to the error message, that's why it didn't change it. You are making a change so the transaction will not be Reconciled any more.

When you get done making all the changes, look in the Register and take a look at the entries for the LAST month you Reconciled. If there are any outstanding transaction from that period make a note (e.g. you Reconciled Dec. and there are three 12/31 entry that were not Reconciled). Re-Reconcile that LAST month and put that date and the closing balance from that Statement. You'll see all the new entries you just made (either by changing the name or re-entering it) are not Reconciled. If you check all of them off, except for any that really were still outstanding, you should end up with a $0 balance again.

Sign up

Login with SSO

Let's get you signed in

Login with SSO