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

WCorder · ‎January 18, 2019

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!

Anonymous · ‎January 18, 2019

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

Anonymous · ‎January 18, 2019

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.

WCorder · ‎January 22, 2019

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

WCorder · ‎January 22, 2019

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

WCorder · ‎January 25, 2019

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!

	Type	Date	Entered/Last Modified	Num	Name	Reconciled Amount	Type of Change	Effect of Change	Variance
	Check	01/12/2018	09/11/2018 17:12:43	13132	Paychex	-260.05	Amount	260.05	0.00
	General Journal	01/31/2018	09/12/2018 12:19:20	145		-2,475.00	Deleted	2,475.00	0.00
Statement Date: 02/28/2018									0.00
Total 02/28/2018								0.00	0.00
Statement Date: 03/31/2018									0.00
	General Journal	03/30/2018	09/11/2018 16:13:54	140c		-5,623.17	Amount	0.02	(5,623.15)
	General Journal	03/30/2018	09/11/2018 16:13:54	140c		-5,623.17	Amount	0.02	(5,623.15)
Statement Date: 04/30/2018									0.00
	General Journal	04/30/2018	09/11/2018 16:12:12	140c		-5,623.14	Amount	-814.06	(6,437.20)
	General Journal	04/30/2018	09/11/2018 16:12:12	140c		-5,623.14	Amount	-814.06	(6,437.20)
Statement Date: 05/31/2018									0.00
	General Journal	05/15/2018	09/11/2018 16:21:14	140c		-6,437.20	Amount	-0.01	(6,437.21)
	General Journal	05/15/2018	09/11/2018 16:21:14	140c		-6,437.20	Amount	-0.01	(6,437.21)
	Check	05/01/2018	09/11/2018 16:28:29	13009		-3,189.05	Amount	3,189.05	0.00
	Check	05/31/2018	09/11/2018 17:19:45	[removed]	Paychex	-190.50	Deleted	190.50	0.00
Statement Date: 06/30/2018									0.00
	Check	06/28/2018	09/11/2018 17:09:47			-6,437.19	Deleted	6,437.19	0.00
	Check	06/14/2018	09/11/2018 17:09:39			-6,437.22	Deleted	6,437.22	0.00
Statement Date: 07/31/2018									0.00
	Check	07/30/2018	09/11/2018 17:10:19			-6,348.18	Deleted	6,348.18	0.00
	Check	07/13/2018	09/11/2018 17:14:36	13132		-600.00	Amount	600.00	0.00
	Check	07/12/2018	09/11/2018 17:10:08			-6,439.63	Deleted	6,439.63	0.00
Statement Date: 08/31/2018									0.00
	Check	08/31/2018	09/11/2018 17:15:05	13132		-1,132.02	Amount	1,132.02	0.00
	Check	08/30/2018	09/11/2018 17:17:28			-6,188.27	Deleted	6,188.27	0.00
	Check	08/15/2018	09/11/2018 17:18:31			-1,147.35	Deleted	1,147.35	0.00
	Check	08/14/2018	09/11/2018 17:15:43	13132		-6,439.61	Amount	6,439.61	0.00
						-82651.09		45655.97	-36995.12

WCorder · ‎January 25, 2019

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.

BettyJaneB · ‎January 25, 2019

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:

In your browser, navigate to https://help.quickbooks.intuit.com/en_US/contact.
Choose QuickBooks Desktop.
Select the issue or topic.
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.

Topics

Training

Community

Resources

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