Skip to main content
K
Kevin MCG
April 12, 2024
Question

We import ADP payroll detail to Quickbooks. It also comes from the bank feed as lump sum. I have duplicate entries but I need the payroll data for our accountants.

  • April 12, 2024
  • 2 replies
  • 0 views
ADP data import is the same as the bank feed on QB online. I have duplicate entries I need to avoid. ADP import is detailed, bank feed is lump sum.

2 replies

K
KimberlyS
April 12, 2024

We appreciate you visiting the Community, Kevin.

 

I'll share information to help you fix duplicate entries to keep your record accurate.

 

In QuickBooks Online, you can match or exclude duplicate transactions to avoid them from appearing in any account registers. This process helps keep your accounts balanced and avoid related discrepancies in the future.

 

When matching transactions, you'll only need to review and approve them since QuickBooks will automatically suggest matches. Here's how:

 

  1. Head to Transactions, then Bank transactions.
  2. In the For review tab, locate and select the transaction.
  3. Double-check the Suggested matches and ensure they are correct. You can also choose to Find other matches to find other matching transactions manually.
  4. Once done, select Match.

 

For more information about the steps above, you can refer to this article: Match online bank transactions in QuickBooks Online.

 

On the other hand, if you need to exclude the transaction and prevent the system from downloading a similar one again from your bank, you can proceed to these steps: 

 

  1. Head to Transactions, then Bank transactions.
  2. Choose the For Review tab and select the box beside the transactions you want to exclude.
  3. Click on Exclude.

 

You can visit this page for the detailed procedure: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Moreover, you can scan this resource to ensure your account matches your real-life statements: Reconcile an account in QuickBooks Online.

 

Inform us in the Community if you have additional questions when handling duplicate entries or other related concerns in QuickBooks Online. We're here to help.

K
Kevin MCGAuthor
May 9, 2024

In the transaction listing, there is no 'match'. There is only confirm. If I do that, I definitely have two entries when I go to reconcile. I don't think it shows a 'match' option because there isn't an exact figure in QuickBooks. The ADP figures are split from journal entries (some taxes, some wages, some voids, etc.) and don't match a specific bank figure. Thanks.

S
Shania_C
May 9, 2024

Thank you for providing further details and clarification regarding your concern, Kevin. I am here to help you match a transaction in QuickBooks Online (QBO) and provide you with some steps.

 

Although we can't match a transaction from the Bank transactions page to an individual transaction in the QBO record, you can still match the lump sum with the multiple imported ADP figures as long as they have the same date and bank account.

 

To begin with, please ensure that the imported transactions are posted on the same bank account as the lump sum and have the same date. Next, follow these steps to match the transactions and review the downloaded transactions:

 

  1. Go to Transactions, and then Bank Transactions.
  2. Select the account you want to review.
  3. Choose the For Review tab.
  4. Double-click on the transaction you want to find a match for and click it.

 

           5. Select the transaction and click match.



 

Then, you can now proceed to my colleague's suggestion on how to exclude a downloaded bank transaction to fix duplicate entries to keep an accurate record.

 

Additionally, I've also included a resource to help make sure your QuickBooks transactions match your bank statement: Reconcile an account in QuickBooks Online.

 

Keep me posted on how it goes. If you have other concerns regarding your transactions in QuickBooks, please don't hesitate to comment below. I'll be glad to help. Take care always.

K
Kevin MCGAuthor
May 9, 2024

I have the same problem. The bank feed drops the figure in to transactions and the ADP export is imported as well. The accountants want the detail in the tax and wage accounts. 

When I follow your directions, I don't have 'match' I only have 'confirm' as a choice in the bank transactions. 

In addition, my bank account in QB is off considerably from the actual bank account due to all the excess transactions that are duplicated. Any help is appreciated. 

Terms & ConditionsAccessibility statement