Solved

QuickBooks 2014 - Bank Imports Not Working Right

Posted on 2014-01-26
2
816 Views
Last Modified: 2014-02-16
I'm downloading an *.QBO file from my bank and it's not importing everything. See attached file for a screenshot of the transaction screen in QB 2014 Pro.

I initially thought to myself, "maybe the 'ATM/POS WITHDRAWAL #4781' section is taking up too much room so I opened the file in Excel, did a "Replace All", replacing "ATM/POS WITHDRAWAL #4781" with "". (See original below)

<STMTTRN>    
    <TRNTYPE>POS
    <DTPOSTED>20140125000000[-5:EST]
    <TRNAMT>-8.49
    <FITID>20140125000000[-5:EST]*-8.49*13**ATM/POS WITHDRAWAL #4781 01/24 BARNES  NOBLE # AKRON OH
    <NAME>ATM/POS WITHDRAWAL #4781 01/24 B
</STMTTRN>  

Open in new window

When I imported the QBO file with my new changes it didn't have the "ATM/POS..." part, but it still only had "01/24 B", removing the remainder of "Barnes Noble # Akron OH".

What's wrong with my QuickBooks?
2014-01-26-18-52-20.png
0
Comment
Question by:ITworks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Accepted Solution

by:
CPA_MCSE earned 500 total points
ID: 39811322
<FITID> algorithm
<FITID> is an OFX tag that is present in every downloaded transaction (each individual entry in the user's statement). This value is assigned by the FI and must be: a) unique within the user's account and b) never changed. Intuit client software (Quicken, QuickBooks) uses this value to determine whether or not a transaction has been previously downloaded. If the value assigned to an individual transaction changes, then the user may have a duplicate entry appear in their client software since the client will not filter out the transaction (thinking it is new). If the value is not unique, then the user may have missing transactions since the client will filter out the transaction (thinking it was previously downloaded).

https://fi.intuit.com/support/glossary_of_terms.cfm

I support MS Dynamics GP.  Contact me if you would like to switch!  :)
0
 
LVL 4

Author Comment

by:ITworks
ID: 39817545
Thanks - I'm glad I know more about FITID's.  :-)  This doesn't explain the problem though - every transaction appears in QB, it's must missing the helpful information.  You know, where I spent the money!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
This Micro Tutorial will demonstrate how nuggets on the Web are formatted by using Chrome Developer Tools. These tools would not only view the site's CSS but it can also modify it and save the CSS to use on your own site.
How to create a custom search shortcut to site-search Experts Exchange using Google in the Firefox browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch your Bookmark Menu: Press 'Ctrl +…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question