cancel
Showing results for 
Search instead for 
Did you mean: 
Marcus1234
Level 1

QBO Payroll export causes error when importing into Quickbooks Desktop

Ok so I've had little issues importing into quickbooks desktop from QBO Payroll beginning middle last month I started getting the error:  

 [ERROR] Missing mandatory field ACCNTTYPE in data. [15103] 
ACCNT Payroll Expenses:FAVR / Mileage Reimbursement           Reimbursement Account - FAVR / Mileage Reimbursement
 
After a painfully long time of troubleshooting on my own and comparing previous iff imports I discovered what is happening. 
 The export is no longer exporting the acount type EXP
 
Comparing the iif files: 
ACCNT Payroll Expenses:FAVR / Mileage Reimbursement EXP Reimbursement Account - FAVR / Mileage Reimbursement   - Old exports prior to 5/18/23

 

ACCNT Payroll Expenses:FAVR / Mileage Reimbursement  Reimbursement Account - FAVR / Mileage Reimbursement - any current exports.
 
Workaround: Open the iff file in notepad and simply insert "EXP" in the file and save and then do your import.

 

It seems to only be doing this for reimbursements accounts and I'm assuming its a back-end problem.

Thanks

Marcus

1 Comment 1
RoseJillB
QuickBooks Team

QBO Payroll export causes error when importing into Quickbooks Desktop

Hello there, @Marcus1234

 

I appreciate you for posting to the Community and bringing this concern to our attention. I’ve checked my resources here and found that there is already an ongoing investigation about importing payroll from QuickBooks Online (QBO) Payroll.

 

Currently, our engineers are working diligently to get this sorted out and resolved as soon as possible. Since they are working on this internally, please know that we cannot provide a turnaround time regarding their efforts.

 

In the meantime, you can contact our Technical Support Team. This way, you can be added to the list of affected users and receive updates via email once a fix is available. You can inform them to add you to the list affected by INV-87935:

 

  1. Sign in to your QuickBooks Online account.
  2. Click the Help button.
  3. In the QuickBooks Assistance chat box, select Talk to a human and or tap the Contact Us button at the bottom.
  4. Then, type in your reason for contacting us in the What can we help you with? Box and click Continue.
  5. From there, choose a way to connect with us; either to Chat with us, get a Callback, or call our support line directly by getting our Phone number.

 

You can refer to this article for other options when contacting them. You can also scroll down to the bottom to see their support schedule and hours: Contact Payroll Support.

 

Additionally, I've added these articles that'll set up and schedule your payroll to run automatically with QuickBooks Online Payroll Core, Premium, or Elite:

 

 

We appreciate your patience while we’re working on this one. Stay safe!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us