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 :
Small and medium business | Business Central, N...
Suggested Answer

How to use Microsoft data exported tool with QuickBooks

(0) ShareShare
ReportReport
Posted on by 2,116

Hi all,

I wanted to export the data from Quickbooks desktop and then import the same in the Business Central. I was using Microsoft Data Exporter to export the data it started giving us error "An account number cannot be empty." Also, We are working on Intuit QuickBooks desktop V 3 (2020) and Microsoft Data Export v 1 (2018).

Can anyone please suggest a way out to export the data from QuickBooks?

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,613 on at

    Hi

    Quick question

    Are you using QuickBooks Data Migration app in BC (the following) or this is a different method?

    If you are using this app did you follow the guide line (link below) that mention "Business Central requires that general ledger accounts have account numbers assigned to them. Make sure that account numbers are assigned to your accounts in QuickBooks. If transactions in QuickBooks have tax amounts, you must set up a tax account for your tax jurisdictions in Business Central before you can post transactions."?

    Thanks

    appsource.microsoft.com/.../TYPE.connect|PUBID.microsoftdynsmb|AID.qbdatamigration|PAPPID.00000000-0000-0000-0000-000000000000

    docs.microsoft.com/.../ui-extensions-quickbooks-data-migration

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,995 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,147 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 893

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans