cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
mosadiegivesback
Level 1

I have linked my bank account but at the wrong date so I am missing 2 months worth of transactions. How do I enter these manually so as not to affect the bank balance?

there are 10 transactions that were imported from my bank account, but because I entered the wrong date I need the other transactions to come into quickbooks without affectiong my balance
1 Comment 1
BettyJaneB
QuickBooks Team

I have linked my bank account but at the wrong date so I am missing 2 months worth of transactions. How do I enter these manually so as not to affect the bank balance?

Hi there, @mosadiegivesback.

 

You've got me here to share some insights about entering your bank transactions in QuickBooks Online without affecting your balance.

 

You can exclude and download your bank transactions again with the correct date. This way, your bank entries in the system will be accurate. However, this process will affect your balance since you are adding an income and expense transactions, but this won't create duplicates.

 

To do that:

  1. On the left pane, select Banking.
  2. At the top left, refer to the Banking tab.
  3. If multiple banks are connected, choose the bank to work with.
  4. Click the In QuickBooks tab. 
  5. Select the transaction you want to exclude, then click Undo under the ACTION column.
  6. Tick on the For Review tab. 
  7. Select the transaction you want to exclude.
  8. Hit on Batch actions drop-down and tap on Exclude Selected.

Here's a link that you can check out for more details about excluding bank entries in QuickBooks Online: Exclude expenses from downloaded bank transactions.

 

On the other hand, if you wish to enter them manually in the system without affecting the balance, I suggest consulting your accountant. This way, you'll be guided with the best course of action to be taken for your business. 

 

Once you have all the accurate entries in the system, here are some articles that will help you in reconciling your accounts smoothly and on what are the things to do if you encounter issues during the reconciliation:

I got you covered if you have any other questions about this or any concerns with QBO. I'm always here to lend a helping hand. Take care!