Skip to main content
April 2, 2024
Solved

ADP Workforce now GL will not import to QB Online

  • April 2, 2024
  • 1 reply
  • 0 views

We use ADP Workforce Now for our payroll processing.  We cannot get out GL to import into QB Online and we have tried and retried to set it up.  I read that ADP RUN works really well with this, however it is recommended for businesses with less than 50 employees, and we have about 225 between 2 companies.  What are we doing wrong?  Any help would be appreciated.  Thank you.

Best answer by AdonL

Glad to have you here in the Community, @ajones1980. I'm here to help you import your payroll data to QuickBooks.

 

How data migrates to QuickBooks Online (QBO) depends on the features available in the integrated app. If you can't import payroll data, consider creating a journal entry instead. This way, we can ensure that your payroll transactions are inside the program. Follow the steps below to create a journal entry.

 

Here's how:

  

  1. Click + New.
  2. Select Journal entry.
  3. From the first line, select an account from the Account field. It depends on if you need to debit or credit the account. Enter the amount in the correct column.
  4. On the line, choose the other account you're moving money to or from. Depending on if you entered a debit or credit on the first line, enter the same amount in the opposite column.
  5. Check the amounts - you should have the same amount in the Credit column on one line and the Debit column on the other. It means the accounts are in balance.
  6. Enter information in the memo section to know why you made the journal entry.
  7. Select Save and new or Save and close.

 

Moreover, I suggest working with your accountant for proper guidance on selecting the affected accounts when creating a journal entry. 

 

Also, you can look for a third-party application that can help import your payroll data by navigating the QuickBooks App Store.

 

Finally, I have a link you can read for additional guidance in managing your transactions in QBO: Categorize online bank transactions.

 

Don't hesitate to comment below if you need further assistance importing data to QuickBooks. I'm always here to help. Have a great day.

1 reply

AdonLAnswer
April 2, 2024

Glad to have you here in the Community, @ajones1980. I'm here to help you import your payroll data to QuickBooks.

 

How data migrates to QuickBooks Online (QBO) depends on the features available in the integrated app. If you can't import payroll data, consider creating a journal entry instead. This way, we can ensure that your payroll transactions are inside the program. Follow the steps below to create a journal entry.

 

Here's how:

  

  1. Click + New.
  2. Select Journal entry.
  3. From the first line, select an account from the Account field. It depends on if you need to debit or credit the account. Enter the amount in the correct column.
  4. On the line, choose the other account you're moving money to or from. Depending on if you entered a debit or credit on the first line, enter the same amount in the opposite column.
  5. Check the amounts - you should have the same amount in the Credit column on one line and the Debit column on the other. It means the accounts are in balance.
  6. Enter information in the memo section to know why you made the journal entry.
  7. Select Save and new or Save and close.

 

Moreover, I suggest working with your accountant for proper guidance on selecting the affected accounts when creating a journal entry. 

 

Also, you can look for a third-party application that can help import your payroll data by navigating the QuickBooks App Store.

 

Finally, I have a link you can read for additional guidance in managing your transactions in QBO: Categorize online bank transactions.

 

Don't hesitate to comment below if you need further assistance importing data to QuickBooks. I'm always here to help. Have a great day.

April 10, 2024

Hello again.  We have tried using the AXIS app with no luck.  When it imports the files, instead of using our cash accounts, it creates the same accounts as expense accounts.  What are we doing wrong?

April 10, 2024

I understand the importance of accurately categorizing our imported payroll data into the correct accounts, jones. 

 

As my colleague mentioned, QuickBooks relies on the features available in the integrated app. Alternatively, if you have experienced difficulties with the import process, you may consider creating a journal entry. Also, I highly suggest seeking an accountant or tax professional to offer additional assistance and ensure you're on the right track. 

 

Moreover, you can explore the QuickBooks App Store or directly navigate to the Apps menu in QuickBooks Online (QBO) and find third-party applications that work well with the program, ensuring seamless procedures. 

 

Lastly, I've included some articles to help you import and export your data with QBO:

 

 

Let me know if you have additional questions concerning the payroll data process in QuickBooks. I'll be sure to offer a helping hand. Stay safe!