Solved

QuickBooks 2014 - Bank Imports Not Working Right

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This Micro Tutorial will demonstrate how to add subdomains to your content reports. This can be very importing in having a site with multiple subdomains.
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