Solved

QuickBooks 2014 - Bank Imports Not Working Right

Posted on 2014-01-26
2
802 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Now-a-days, indirectly, postal services have been replaced by email services. Yes, whenever we hear the word "email" a lot of people only think of gmail. Some people still think that email and gmail are one and the same thing :-). Let's see some …
Several part series to implement Internet Explorer 11 Enterprise Mode
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.
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch the Search Engine Menu: In chrome, via you…

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now