web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

QB IIF file and beginning balances coming in wrong.

(0) ShareShare
ReportReport
Posted on by

Just looking to see if anyone else has had issues with beginning balances coming in wrong from the IIF Files. In one import we had a variety of issues with balances being very off and amounts coming in as negatives when they should be positives.

If anyone else had this issue, what was the solution you use to fix it?

Also, if you know of this issue, is there a way to prevent it when exporting the file from QB?

Thanks! 

Categories:
  • Verified answer
    Dave Boehm Profile Picture
    645 on at

    I had some problems with this, as well.  the QB import brings over the "account balances" for G/L.  This is fine for balance sheet items, but isn't accurate for income statement items.  Obviously, revenues and expenses should only be booked for this year's activity, not the balance.  I notified Microsoft of this glitch, but I didn't hear very much from them in return.

    To solve the issue, I booked a reversing entry to eliminate the opening balances.  I then manually entered an entry to re-book the trial balance, using the Retained Earnings account as my balancing account (for everything).  This resulted in accurate opening entries.

    I'm not sure this was really necessary, though.  Just out of curiosity, I opened the QB IIF file using NotePad.  It looks to me like I could have simply changed the balances on the revenue and expense accounts before I made my initial import to D365 FF, to begin with.

    After I had made my initial import (of incorrect balances) to D365 FF to begin with this was basically a moot point, though.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans