Skip to main content
September 9, 2021
Question

How do I stop QBOL counting transfers in/out of my linked bank account to my linked savings accounts as deposits/withdrawls on reports, it makes reports way out?

  • September 9, 2021
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

Rose-A
September 10, 2021

A warm welcome to the Community, chris c1.

 

QuickBooks only accepts data provided by your bank. Since these transactions are showing as deposits/withdrawals, I'd suggest getting in touch with your financial institution to check on how they send your statements to QuickBooks.

 

For now, you can exclude them from the banking page. Here's how:

 

  1. Click Transactions in the left panel and choose Banking.
  2. In the For Review tab, select the deposits. 
  3. Tap on the Exclude button.
  4. Go to the Excluded tab, select the transactions again.
  5. Hit the Delete button.

 

After that, you can re-import the transactions to correct them. See the steps below:

 

Pick a date range:

 

  1. In QuickBooks, go to the Accounting menu, then select Chart of Accounts.
  2. Find the bank or credit card account you want to upload more transactions into. Then select View register.
  3. Scroll to the bottom of the list.
  4. Write down the date of the oldest transaction. In many cases, the oldest transaction is the opening balance.

 

Step 2: Download transactions from your bank:

 

  1. Sign in to your bank or credit card’s website.
  2. Follow your bank’s instructions for how to download transactions to your computer. Some banks call this WebConnect. Every financial institution has different steps. 
  3. Make sure the date range for the download is at least one day before your oldest transaction.
  4. Download your transactions. Save the file somewhere you can easily find it, like your desktop.

 

You can get the outlined and detailed steps in this article (proceed to Step 3): Manually upload transactions into QuickBooks Online.

 

Once imported, I recommend editing, assigning, and categorizing your transactions. Also, you can match them to the existing entries in the software. Doing so will help you ensure the accuracy of your financial records.

 

If you have any other questions or need further assistance with this topic, let me know in the comment below. I'll be more than happy to help you anytime.