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 :
Dynamics 365 Community / Forums / Business Central forum / Finding error while im...
Business Central forum

Finding error while importing payroll through Quickbook in Dynamics 365 for financial

(0) ShareShare
ReportReport
Posted on by Community Member

I am finding an error "This is not a valid IIF transaction file. Required token !TRNS could not be found in the file." whenever i am trying to import a payroll generated in Quickbook. The file that i am trying to import is in IIF format and Quicbook payroll file import extension is also installed in Dynamics Financial.

Thanks in advance

Categories:
Data Migrations
  • Chris Bulson Profile Picture
    Chris Bulson Microsoft Employee on at

    Hello,

    How did you get a payroll file out of QuickBooks in an IIF format?  

    It is my understanding that the Payroll import functionality is meant for 3rd party payroll applications that include the functionality of exporting payroll to an IIF file format.  This is meant for the purpose of being able to import your Payroll data from a 3rd party payroll application into QuickBooks.  We've replicated this functionality in Financials.  I don't think it was meant to be used to transfer Payroll data from QuickBooks to Financials.

    Thanks,

    Chris

  • Community Member Profile Picture
    Community Member on at

    So if that is the scenario could you suggest me a way on how could i transfer my payroll file from Quickbook to Financial?

  • Chris Bulson Profile Picture
    Chris Bulson Microsoft Employee on at

    I'm not familiar with QB or what options you have for exporting your data.  If you can get it into Excel in the proper format you should be able to use the 'Edit in Excel' feature.  If anyone else in the community has experience with this they may be able to provide some insight.

    Thanks,
    Chris

  • dano1968 Profile Picture
    dano1968 on at

    Chris's excel suggestion is how we are importing payroll info from PayChex. and it works well since we can include dimensions as well.

  • Community Member Profile Picture
    Community Member on at

    Yes We can get data in excel format as well but i don't think that there is way to import payroll in general journal in excel format. am i right?

  • Community Member Profile Picture
    Community Member on at

    Are you exporting your payroll into financial through excel? if yes please suggest us a proper excel format for importing payroll into Dynamics 365 for financial

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