Bank feed populates all downloaded check transactions with the same Vendor

EXAMPLE: My bank feed populates all my downloaded CHECK transactions with the same Vendor. I change the vendor payee category on any given transaction it will change for all downloaded transactions in bank feed. There is no bank rule setup for this. Is there a way I can turn that off?

Unfortunately, you can’t turn that off in QBO bank feed. That’s the way it is in bank feed for Checks (and other transactions) at this time. QuickBooks needs to do something about this. It’s better to have no vendor name at all than incorrect vendor name.

Just as a workaround you can create a Bank Rule the following way:

1. Create a new vendor named “Unknown” and
2. Create a new condition rule to mark anything containing “Check” to go to Vendor payee “Unknown” and “Uncategorized Expense” account.

This will at least draw your attention to it. It will not add to wrong Vendor and incorrect Expense category tag.






How to import credit card transactions from Excel CSV file to QuickBooks Online (QBO)

QuickBooks Online allows users to import their credit card transactions via Excel CSV (comma-separated values) files. It will allow importing date, description and amount columns. For the amount, you can use 1-Column field or 2-Column fields. It is recommended to use Debit and Credit with two columns excel file format to import. QBO will not allow mapping additional columns, for example, billable to customer, class, and location.

QBO uses the same “Map CSV columns” fields format for importing both bank account as well as credit card account. It’s a bit confusing for importing credit card liability type account. It could be ended up importing the wrong way. For bank checking account import, you will need to use opposite fields selection of credit card import. Like for example, the expenses were imported as payments and vice versa. See below instructions on how to correct if that happens.

Here is recommended Excel CSV template format:
Debit = Expense
Credit = Payment


To import a CSV file (see below for screenshots):

    • From the left dashboard, select Banking.
    • Select File upload at the top right corner.
    • Click Browse and Select the “.CSV file” to upload from your computer.
    • Click Next.
    • From the QuickBooks Account drop-down, select the credit card account to which to import.
    • Click Next.
    • Map your fields according to your CSV file’s format.
    • Under Amount, Select 2 Column radio-button.
    • For Debit Column 3, Select Expense and for Credit Column 4, Select Payment.
    • Click Next.
    • Select the transactions to import.
    • Click Next.
    • You will receive a notification, stating the number of transactions that will be imported.
    • Click Yes.
    • When you get confirmation of the import, click Finish.


    You will now be directed to the Downloaded Transactions window under Banking, where the imported transactions will appear under the “For Review” tab. You will now need to review account category and appropriate payee and add the transaction to QuickBooks.



    How to delete the transaction imported from bank feed if they were imported wrong way?
    Like for example, the expenses were imported as payments.

    You will first need to exclude and then delete all the transactions.

    To exclude a transaction or multiple transactions:

    • Choose Banking on the left dashboard.
    • 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 move to the Excluded tab.

    To permanently delete unwanted downloaded banking transactions from “Excluded” section of the banking center

    • From the Excluded tab, go to “Batch actions” and choose to pull down arrow and select DELETE. That will permanently delete downloaded transactions.

    Screenshots of CSV file upload:


My bank balance is different than actual balance in QuickBooks register

QuickBooks Online – My bank balance is different than actual balance in QuickBooks register.

Different balance, why?
1. Outstanding checks
2. Deposits in transit
3. New Transactions for connected account
4. Duplicate transactions
5. Editing or deleting transactions
6. Beginning balance

FREE Trial

XERO - Alternative to QuickBooks

SAGE 50 Accounting

Limited Time Offer—Save Up To 37% On Sage 50 Accounting Software!

QuickBooks Online - Buy now and save 50%

QBO Issues: Costco’s switch from American Express to Citibank Visa

Helpful articles

Costco American Express has moved to Costco Citibank – Error 324

As of June 20th, 2016 Costco has ended their partnership with American Express and started a new partnership with Citibank. This impacts customers using Quickbooks Online and have their Costco American Express credit card connected to their account. Customer using the Costco American Express will have their balances and 90-day worth of transactions transferred to Citibank…


How do I update my Costco old American Express Amex card to a Costco Citibank Visa card?

Since your card issuer and account number for the card have changed, it’s recommended to create a new credit card account for your Costco Citibank Visa card.
(From the home page screen > left navigation bar > transactions > chart of accounts > New

  • Category Type = Credit Card
  • Detail Type = Credit Card
  • Name and Description = Costco Citibank Visa Card

costco citibank visa card

You will also need to create a new Citibank as the vendor name.


QBO Alert:
I am trying to change my Costco American Express to CitiBank American express and am unable to do so. I can not disconnect the Costco American Express?


How can I get my new Citibank/Costco credit card to link to QBO? I am getting Code 105 error?