Skip to main content
B
Books44
April 27, 2018
Solved

Bank Feed duplicates after manual qfx. upload

  • April 27, 2018
  • 1 reply
  • 0 views

Before connecting to the bank, I will manually upload more than 90 days of bank transactions using a qfx file from BofA (i.e. back to 1/1/17 from today).  After the upload is QBO smart enough to know that I already have transactions there from the qfx upload and will not duplicate once I connect the bank for future update refreshes into QBO?  Or, will it definately duplicate the 90 days and I'll have to figure out how to exclude them somehow?  It was my understanding that if the file was qfx for a manual upload then QBO, once connected for pulling in bank transactions, would treat them as already in QBO and not dupicate those dates?   Is that an accurate understanding?

    Best answer by Books44
    Emily, Thank you....worked like a charm! Books

    1 reply

    EmilyMockett
    EmilyMockett
    April 27, 2018

    Hi Books,

     

    QuickBooks will also pull in the same transactions from the 90 days and will cause duplications.

     

    My advice would be to update the bank first and see how many transactions the bank pulls in. You can then delete these off of the spreadsheet (QFX file) before manually uploading in into QuickBooks.

     

    Kind Regards,

    Emily

    B
    Books44AuthorAnswer
    May 1, 2018
    Emily, Thank you....worked like a charm! Books
      Terms & ConditionsAccessibility statement