Bank statement begining balance off

I'm here now, @crescere. I have some insights and solutions for the beginning balance issues you've encountered. Let's dive into the details.
 

The beginning balance in QuickBooks being incorrect and not matching your bank statement could be due to the following reasons:
 

• The account wasn't set up with a balance or was set up with the wrong balance.
• Previously cleared and reconciled transactions were voided, deleted, or modified.
• You converted the file from another version of QuickBooks.
• Possible data damage.
   

Locate the transactions in question by running the Reconcile Discrepancy, Audit Trail, and Previous Reconciliation reports and correct the discrepancies. Here's an article for guidance: Fix beginning balance issues in QuickBooks Desktop.
 

On the other hand, the error message you encounter when deleting a deposit in the Customer Center occurs when you delete or edit a transaction associated with Undeposited Funds. To delete it, you'll need to remove the bank deposit directly from the bank register. More details about bank deposits can be found here: Record and make bank deposits in QuickBooks Desktop.
 

Furthermore, if everything is in order and you're ready to reconcile your account to match your bank statements, refer to this material: Reconcile an account in QuickBooks Desktop.
 

Please click the Reply button if you need clarification on managing your beginning balance in QuickBooks. I'm here to help.

No, none of these apply. I saw two of the same amounts in my register and I mistakenly deleted one of them. That was my first error. So now to fix it I wanted to delete that transaction from cash and the customer center in my receivables and just reenter it. QB won't let me delete the receivables until I delete the entry in cash..  But, as I said above, there is no entry in cash since I deleted it earlier in error.  I just want to fix this the fastest way possible.  Thank you.  

Cant i just make a general journal entry to replace the deleted cash amount?  If so what would that entry be.

I undid the prior bank recs till the begining balance was correct. But now I have to put in the deleted entry to cash.  My receivables are correct. What is the journal entry to put the deposit back in cash?

Hello, @crescere.

Allow me to connect you with our support team, who can help ensure your bank statements align with your QuickBooks records.

It's recommended that you contact our customer care team in this process since they have the necessary tools and expertise to help you review and identify the cause of these discrepancies. Additionally, they can provide you the appropriate information to resolve this matter. 

To ensure a thorough resolution of these discrepancies, I recommend contacting our customer care team. They have the necessary tools and expertise to identify and provide the suitable solution to address this matter effectively.

To reach out to them, here's how: 

1. Open QuickBooks.
2. Go to Help, then select QuickBooks Desktop Help/Contact Us.
3. Click Contact Us, then enter a brief description of your concern.
4. Hit Continue and sign in to your Intuit account.
5. Choose Chat with us or Have us call you.

For Pro, Premier, and Plus users, support is available Monday to Friday, from 6 AM to 6 PM. Enterprise users can contact support anytime, any day.

For reference, please see this article: Contact QuickBooks Desktop support.

Moreover, you can consider utilizing journal entries to address the discrepancies you're facing. However, it's best to consult with your accountant during this process to ensure accuracy. Their professional guidance will help you select the appropriate entries to effectively resolve the issue.

Additionally, I'll include these articles you can check if you want to review and ensure that your bank and credit card statements are accurate and protected. 

• Reconcile an account in QuickBooks Desktop
• Close your books in QuickBooks Desktop

Should you need further assistance in fixing discrepancies between your bank statements and QuickBooks, don't hesitate to ask in this forum. We're here to provide support anytime.

Can't you just tell me the journal entry I need to make this work? My receivables are good. I just need to know what to do on the cash side to make this work.

How about smart general members? Any advice?

@crescere 

I'm not sure I'm following exactly what you did, but it sounds like your Undeposited Funds account may be overstated by the same amount you are short cash.  Is that possible?  If that's the case, make a journal entry and debit your bank account and credit Undeposited Funds for the amount of the discrepancy.   

Thank you for answering. I immediately checked, but my undeposited Funds account is zero.  My first error was that I deleted a deposit after I had reconciled.  When I did the next month rec I found that the beginning balance was off by the amount I had deleted in error.  My receivables in the customer center are correct.  I was hoping I could delete the receivable and just start over.  QB won't let me delete a receivable without deleting the cash deposit.  Well, I already did that in error.  So what now? 

@crescere 

Something's not sounding right.  This is double-entry accounting so if you're bank balance is off, then another account is off by the same amount.  If your undeposited funds (UF) and receivables are correct, then there must be another account that's off. 

Go to your Audit Trail (Reports > Accountant & Taxes > Audit Trail) and see if you can find the deleted deposit.  It will show the entry was that was deleted under 'Prior'.  Post a screenshot of the prior transaction if you want more help.

@crescere 

"...if you're bank balance is off..."

EDIT: if your bank balance is off

Thanks for your help, but there are no entries under the Audit Trail.  I agree this is very frustrating.

@crescere 

If there are no entries on the Audit Trail report, then you need to make sure the date range is changed to include a wider date range.  It defaults to today.    

That amount was not in my audit trail.

I want to be sure I understand the flow.  When I create an invoice it’s a Dr. to A/R Cr. To Revenue

When I receive payment from the customer it’s a Dr. to Undeposited funds Cr to A/R

When I make deposits it’s a Dr. to cash Cr. To undeposited funds

Right?

So when I deleted the deposit in cash by error I created a problem.  I wish QB would let me delete the A/R entries so I could just repost the entire thing. Is there a simple way to adjust this?

You're correct, Crescere. When you create an invoice, the sales account is credited and accounts receivable is debited.

Once a payment is recorded, it affects the undeposited funds and accounts receivable account. The deposit moves the amount from the undeposited funds account to appropriate bank account. However, if you remove the deposit, the funds will return to the undeposited funds account, which will impact your bank account balance.

It's important to note that before you can make changes or adjustments to the AR entries (paid invoices and deposited invoice payment), you'll have to delete the deposit first to avoid error. After that, you can now make the necessary changes and recreate the transactions again. Here's how:

1. Go to Lists, then Chart of Accounts.
2. Select the register holding the deposit.
3. Open the deposit then press Ctrl + D.
4. Hit OK and go back to Customers menu, then Customer Center.
5. Open the invoice and payment, then click the Delete button and click Yes.

Moreover, you can explore this article to use the batch delete/void transactions utility to quickly delete or void multiple transactions at once: Batch delete or void transactions in QuickBooks Desktop Accountant.

After that redo the entire process with the help of the articles below:

• Create an invoice in QuickBooks Desktop
• Record an invoice payment
• Record and make bank deposits in QuickBooks Desktop

In addition, to learn how to add, edit, and delete items, check for more info: Add, edit, and delete items in QuickBooks Desktop.

If you require additional help in resolving any discrepancies between your bank statements and QuickBooks, feel free to reach out in this forum. We are always available to assist you.

@crescere 

Yes, that's the correct flow.  If you delete a deposit, QB increases Undeposited Funds (UF) and decreases cash.  If you delete a payment received on an invoice, QB increases A/R and reduces UF.  If you delete the invoice, QB reduces revenue and reduces A/R.  If you're saying your UF and A/R balances are correct, then I don't know what else to tell you.  If your cash is off, then either UF, A/R or Revenue is off too.  

Thanks for your answer.  If QB would let me delete my A/R this problem would go away.  I could just reenter.  Is there some way to fix this with a simple journal entry?  I can Dr. cash, but I don't know what my Cr. should be. Any ideas?

What if I dr. cash and Cr. revenue?

Or should I delete the original invoice, create a new one, and apply the payment to that new one?

This simple entry seems to have worked.  I also undid all bank recs till I got before the period the balance was off.