[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

QuickBooks 2014 - Bank Imports Not Working Right

Posted on 2014-01-26
2
Medium Priority
?
865 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 1000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
Several part series to implement Internet Explorer 11 Enterprise Mode
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…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

650 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