Categories
Banking Navigation Transactions

How do I permanently delete “Excluded” transactions in bank feeds?

 

You can permanently delete bank downloaded transactions in QuickBooks Online (QBO).

In order to permanently delete a bank downloaded transaction (or multiple transactions) from the banking center, you will first need to move it from “For Review” tab to “Excluded” tab.

To move from “For Review” tab to “Excluded” tab:

  • From the home page screen > Go to the left navigation bar Dasshboard
  • Click Banking
  • You’ll see the “For Review” tab, click the checkboxes to the left of the date for the transactions you want to exclude.
  • Once you’re done, click the “Batch Actions” drop-down arrow and select “Exclude Selected.” The transactions will be moved to the “Excluded” tab now.

You can permanently delete from the “Excluded” tab now.

To permanently delete-excluded bank transactions.

  • From the home page screen > Go to the left navigation bar dashboard
  • Select Banking
  • Select “Excluded” tab
  • Select Batch actions (drop-down arrow)
  • Select Delete
  • You can select to delete a transaction or multiple transactions here
  • Note: If you select UNDO it will move back to “For Review” tab.


How to permanently delete bank downloaded transactions in bank feeds


 
helpful videos

Categories
Banking Expense Expenses Import Data

How to import credit card transactions from Excel CSV (.csv) file into QuickBooks Online?

The short video (below) will show you step-by-step instructions on how to import credit card transactions from Excel CSV file into QBO so that you will not import transactions the wrong way.

Confusion has to do with bank account field and Quickbooks field screen. It is the same field name for bank download as well credit card download. Users are importing a CSV file from credit card company and every transaction ended up being the opposite of what it should be…. expenses listed as credits (spent), credits listed as expenses (received).

Once you have downloaded transactions, there is no way to UNDO or delete downloaded transactions. You will have to move to “EXCLUDED” column and it will stay there forever which is not good.

So, I highly encourage you to watch the entire video. You do not want to miss a step.

import cc csv 1

import cc csv 2

import cc csv 3JPG

import cc csv 4

import cc csv 5

import cc csv 6

import cc csv 7

import cc csv 8.1

import cc csv 8.2

import cc csv 9

Categories
bank feed Banking

QuickBooks Online Bank Feed: How to import/export bank rules

Bank rules are great for controlling how incoming bank transactions are categorized before you accept them into QuickBooks. Rules save time and minimize typing mistakes!

This article explains how to import and export rules, which is convenient if you manage multiple companies (like accountants often do).

SOURCE: http://quickbooks.intuit.com/blog/how-to-import-export-quickbooks-online-bank-rules/#respond

Categories
Bank Register Banking

How can I manually download transactions from my bank? How do I get more than 90 days of bank transactions? Should I use Web-Connect?

How to get more than 90 days of bank transactions?

You’ll start by signing in to your bank’s website and downloading a valid webconnect file.

Valid webconnect files:

  • .qbo (QuickBooks),
  • .qfx (Quicken) and
  • .ofx (MS Money)

Then SAVE it to your computer in a location that you can find.

Now go to QuickBooks Online:

  1. Go to Transactions>Banking
  2. Once you are on the Downloaded Transaction screen, click on File Upload at the top right.
  3. Next, you’ll start the Web Connect mini-interview.
  4. Click Browse and select your Web Connect file from your computer.
  5. Click Next.
  6. In the drop-down menu, select the account where you’d like to upload the transactions.
  7. Click Save and Finish.

NOTE: If you attempt to upload a file of the wrong format, a message will appear stating: The uploaded file isn’t a valid Web-Connect file.

ALSO REMEMBER: if the transactions precede the opening balance that was entered into QuickBooks Online, the opening balance will change.

Check out KB 2370 for help on troubleshooting web-connect errors.

 

 
Source
 

Categories
Banking

How do I download banking transactions into quickbooks from the months before I started using the QBO program

First you will need to download QuickBooks format file (QBO, QFX, OFX only) directly from the bank account to computer hard drive.

From the blue navigation bar on left > transactions > banking

You are now at the bank feeds section of the QBO area. Select bank account to download these new transactions.

Go to upper right (next to “Add Account” blue button)> select “File Upload” from pull down selector (“Update” is default)

It will take to next “Upload Bank File” screen > “Select the file to upload” from your computer hard drive. It goes through upload process. You should also all the bank downloaded under “New Transactions” area.

See attached screenshot photos for guidance.

Upload bank file QFX QBO OFX

upload file from bank feed
 
helpful videos
 

 

If you found our answers useful then please contribute a few bucks to support this forum. Thank you!





Thank you!






Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada








Categories
Banking

How do I delete downloaded bank transaction that I don’t want to add or match?

Unfortunately, there is no way to delete downloaded banking transactions in new QuickBooks Online.

Since you cannot delete downloaded transactions, you will have to move all unwanted downloaded transactions to “Excluded” column.

Select the transactions (you like to delete) and then use the “Exclude Selected” option under Batch Actions. It will move from “New Transactions” column to “Excluded” column.

QBO developers claim, it will sit there forever harmlessly, but I do not buy it.

If you feel this “delete” feature need to be added in future revision, please add your voice here. I’ve already done it in this past.

http://feedback.qbo.intuit.com

Categories
Bank Deposit bank feed bank reconciliation Bank Register Bank Transfer Banking

How to request add new bank in banking feed in new QuickBooks Online?

From the Home page screen

  • Click Transactions  (on the left side of blue navigation bar)
  • Click Banking
  • Click Add Account  (in the upper right corner)
  • Enter your bank’s name, then click Find
  • Click the blue link for Request that we add your bank (in the middle of the page)
  • Enter either the bank name or the URL of your bank’s website, then click Add My Bank button
Request to Add New Bank
Request to Add New Bank