cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

How to use Online Banking, Connect Bank Accounts, and Review your Bank Feed in QuickBooks Online

Do you have any advice for me?  The previous bookkeeper made $46K in changes to previously reconciled transactions causing my beginning balance to be of  by some $32K.  I'm lost.

 

Thanks!

Solved
Best answer January 18, 2019

Best Answers
Highlighted
Anonymous
Not applicable

How to use Online Banking, Connect Bank Accounts, and Review your Bank Feed in QuickBooks Online

Hi there, @WCorder.

 

Thanks for joining the Community. I'd be glad to get you pointed in the right direction. There are two options you can consider to fix an incorrect beginning balance in QuickBooks.

 

First, you can undo all reconciliation up until you reach the period where the discrepancy started and reconcile again. Let me route you to this article for the steps: How to unreconcile a transaction or undo a reconciliation

 

Or you can ignore the difference and continue doing the reconciliation by entering an adjusting entry in QuickBooks. For this option, I'd recommend consulting your accountant first before making any adjustments. You can check out this article for more information: How to adjust a reconciliation.

 

You may also want to check out this helpful article for more information about online banking transactions and bank feeds: How to use Online Banking, Connect Bank Accounts, and Review your Bank Feed in QuickBooks Online.

 

Let me know if you have other questions about reconciling your transactions in QuickBooks. I'm here to help however I can.

View solution in original post

6 Comments
Highlighted
Anonymous
Not applicable

How to use Online Banking, Connect Bank Accounts, and Review your Bank Feed in QuickBooks Online

Hi there, @WCorder.

 

Thanks for joining the Community. I'd be glad to get you pointed in the right direction. There are two options you can consider to fix an incorrect beginning balance in QuickBooks.

 

First, you can undo all reconciliation up until you reach the period where the discrepancy started and reconcile again. Let me route you to this article for the steps: How to unreconcile a transaction or undo a reconciliation

 

Or you can ignore the difference and continue doing the reconciliation by entering an adjusting entry in QuickBooks. For this option, I'd recommend consulting your accountant first before making any adjustments. You can check out this article for more information: How to adjust a reconciliation.

 

You may also want to check out this helpful article for more information about online banking transactions and bank feeds: How to use Online Banking, Connect Bank Accounts, and Review your Bank Feed in QuickBooks Online.

 

Let me know if you have other questions about reconciling your transactions in QuickBooks. I'm here to help however I can.

View solution in original post

Highlighted
Level 2

How to use Online Banking, Connect Bank Accounts, and Review your Bank Feed in QuickBooks Online

Thank you!  In researching the advice you made available to me, I saw somewhere that I could delete these adjusting entries.  Since they are not trustworthy, I may do just that.  I really am grateful for you support.  That was very nice of you.

 

Thanks again,

Wade

Highlighted
Level 2

How to use Online Banking, Connect Bank Accounts, and Review your Bank Feed in QuickBooks Online

Thank you!  I saw somewhere in the advice you pointed me to, the option to delete these adjusting entries.  As they are not trustworthy, I may do that. 

 

I really appreciate your help.  That was very nice of you.

 

Thank you,

Wade

Highlighted
Level 2

How to use Online Banking, Connect Bank Accounts, and Review your Bank Feed in QuickBooks Online

Might you offer advice on how to remove transactions that have affected my bank balance?  Can I show them to you somehow?  Oh, look, I can paste the Previously Reconciled Discrepancy Report here.  Yay.  I just want to delete each item.  Any advice?  Thank you!

 

 TypeDateEntered/Last ModifiedNumNameReconciled AmountType of ChangeEffect of ChangeVariance
 Check01/12/201809/11/2018 17:12:4313132Paychex-260.05Amount260.050.00
 General Journal01/31/201809/12/2018 12:19:20145 -2,475.00Deleted2,475.000.00
Statement Date: 02/28/2018        0.00
Total 02/28/2018       0.000.00
Statement Date: 03/31/2018        0.00
 General Journal03/30/201809/11/2018 16:13:54140c -5,623.17Amount0.02(5,623.15)
 General Journal03/30/201809/11/2018 16:13:54140c -5,623.17Amount0.02(5,623.15)
Statement Date: 04/30/2018        0.00
 General Journal04/30/201809/11/2018 16:12:12140c -5,623.14Amount-814.06(6,437.20)
 General Journal04/30/201809/11/2018 16:12:12140c -5,623.14Amount-814.06(6,437.20)
Statement Date: 05/31/2018        0.00
 General Journal05/15/201809/11/2018 16:21:14140c -6,437.20Amount-0.01(6,437.21)
 General Journal05/15/201809/11/2018 16:21:14140c -6,437.20Amount-0.01(6,437.21)
 Check05/01/201809/11/2018 16:28:2913009 -3,189.05Amount3,189.050.00
 Check05/31/201809/11/2018 17:19:45[removed]Paychex-190.50Deleted190.500.00
Statement Date: 06/30/2018        0.00
 Check06/28/201809/11/2018 17:09:47  -6,437.19Deleted6,437.190.00
 Check06/14/201809/11/2018 17:09:39  -6,437.22Deleted6,437.220.00
Statement Date: 07/31/2018        0.00
 Check07/30/201809/11/2018 17:10:19  -6,348.18Deleted6,348.180.00
 Check07/13/201809/11/2018 17:14:3613132 -600.00Amount600.000.00
 Check07/12/201809/11/2018 17:10:08  -6,439.63Deleted6,439.630.00
Statement Date: 08/31/2018        0.00
 Check08/31/201809/11/2018 17:15:0513132 -1,132.02Amount1,132.020.00
 Check08/30/201809/11/2018 17:17:28  -6,188.27Deleted6,188.270.00
 Check08/15/201809/11/2018 17:18:31  -1,147.35Deleted1,147.350.00
 Check08/14/201809/11/2018 17:15:4313132 -6,439.61Amount6,439.610.00
      -82651.09 45655.97-36995.12
Highlighted
Level 2

How to use Online Banking, Connect Bank Accounts, and Review your Bank Feed in QuickBooks Online

Can you point me in the right direction to reverse or delete the items in the Previously Reconciled Discrepancy Report?  Here's a pic:  - pic won't work.  Previously, I attached a table; it was marked as spam.

 

Shoot.

Highlighted
QuickBooks Team

How to use Online Banking, Connect Bank Accounts, and Review your Bank Feed in QuickBooks Online

Glad to have you back here in the Community, @WCorder.

 

Allow me to join this conversation and provide some details about deleting the items in the Previously Reconciled Discrepancy Report.

 

In QuickBooks Desktop, once a discrepancy is identified, you need to make the necessary corrections. To know the process of making the corrections, please consult your accountant for further assistance. 

 

If you have new transactions to add to the reconciliation period or if you have modified previously reconciled transactions, you may need to do a mini reconciliation.

 

To learn more about fixing reconciliation discrepancies in QuickBooks Desktop, please check out this article: Fix Reconciliation Discrepancies.

 

However, if you need further help with this concern, feel free to reach out to our Customer Care Team. They have the proper tools to check on your transactions to better isolate this matter.

 

To do that:

  1. In your browser, navigate to https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose QuickBooks Desktop.
  3. Select the issue or topic.
  4. Click the Green Phone button to see the support number.

This should get you on the right track @WCorder.

 

Keep me posted if there's anything else you need. I'll be around to help you out. Have a good one.

Need to get in touch?

Contact us