cancel
Showing results for 
Search instead for 
Did you mean: 
THISisPAINFUL1
Level 2

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

Quickbooks Online

I have two active Bank accounts - CHASE (linked with QB) and HSBC (not linked)

In February 2022 I started paying payroll out of the CHASE account. (HSBC account was deleted from Payroll Bank settings) Funds for paychecks and taxes have been correctly paid out of CHASE account ever since. However the Accounting section was not corrected until late March.  So payroll and taxes were mapped to the HSBC account putting the balance off on paper. Additionally, it resulted in double payments in the Liability registers for Direct Deposit, Federal Taxes, NYS Taxes.   THIS ISSUE HAS MAJOR IMPLICATIONS FOR EMPLOYEE TAXES.    @books11249 DEVELOPMENT TEAM / @COMMUNITY what is the solution to correct the mapping of past payments to correctly reflect which account they were deducted from?  No funds were deducted from the actual HSBC account so a Journal entry or Transfer solution will not correct the issue.   Thank you for your help! .shannon

13 Comments 13
MaryLandT
Moderator

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

Hi there, THISisPAINFUL1.

 

You can correct the posting account for liabilities and expenses, but not the bank account. 

 

You may need to enter the payroll checks manually as journal entries so you can use them to reconcile the account.

 

You can either combine all of the employees' paycheck totals into one journal entry or create a separate transaction for each employee. To make sure the amounts are accurate, you can run a payroll report (Payroll Summary, Payroll Summary by Employee, or Payroll Details) for reference.  

 

Here's how: 

 

  1. Click + New on the left panel.
  2. Select Journal Entry.
  3. Under the Journal date, enter the paycheck date.

For more details about how to enter the debits and credits for wages and taxes, as well as a sample paycheck, please check the following article: Manually enter payroll paychecks in QuickBooks Online.

 

For your expenses and liabilities, the steps below to update your payroll accounting settings for your taxes.

 

  1. Go to Settings ⚙, then Payroll settings.
  2. Click Edit ✎ next to Accounting
  3. Select Edit ✎ to update a specific section.
  4. Choose which account the transaction of the specific payroll item should go, then Continue.
  5. Click Edit ✎ next to Want to update existing transactions, then add a Start Date, then Done.
  6. Click Done.

 

I'm also adding this article for more details when you select another bank account: Learn how to change your payroll bank account info.

 

After making some changes to your payroll preferences, you can start running payroll again to pay employees.

 

Let me know if there's anything else you need by commenting below. I'll be around to help manage your payroll preferences.

THISisPAINFUL1
Level 2

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

Thanks for replying MaryLand T.

 

Let me clarify, I have reconciled both HSBC and CHASE accounts through February. 

PAYROLL is being paid CORRECTLY out of CHASE account and being DEDUCTED from CHASE.

BUT QB mapped the details of the payroll/tax transactions to HSBC.

The record under CHASE appears as an expense rather than a DD (for Direct Deposit)

The record under HSBC appears as a DD and includes all the payroll details, but the transactions DID NOT occur. No funds were withdrawn from the HSBC account so the balance reflected in QB does not accurately reflect the HSBC balance. A journal entry will direct QB to move funds but the funds were never withdrawn from HSBC in the first place.

 

under the ACCOUNTING TAB there is a caveat noting they don't change bank accounts which is the account I need changed so the payroll/tax transition is matched correctly with the withdraw from CHASE.  

 
I am trying to figure out how to connect the Payroll/tax details with the actual transaction that occurred in CHASE? Make sense? 
 
Image 4-1-22 at 7.46 AM.jpeg
Rose-A
Moderator

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

Hi, THISisPAINFUL1.

 

While the Community can provide answers and troubleshooting solutions to certain questions, there are things that only our QuickBooks Support can do to resolve the problem.


To get this sorted out, I'd suggest getting in touch with our Payroll Specialists to have this investigated. A phone agent has the appropriate looks, like screen sharing, and helps you with correcting the payroll mapping in QuickBooks

 

.All payroll-related concerns are directed to our phone support for security purposes. To ensure we address your concern on time, check out our support hours. Here's how to contact us:

 

1. Click the Help (?) icon.

2. Choose Contact Us.

3. Enter a  brief description of your situation in the What can we help you with? area, then click Let's talk.

4. You'll be presented with a few options for connecting with Intuit. Select Get a call.

 

As always, feel free to visit our Help articles for QuickBooks Online in case you need tips and payroll-related articles in the future. 

 

Additionally, can you please provide another screenshot? The image you attached seems to be corrupted. Any extra information would be highly appreciated.

 

If I can be of help while working in QuickBooks payroll, feel free to let me know by adding a comment below. I'd love to help.

THISisPAINFUL1
Level 2

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

Thank you Rose-A for responding.

 

Sadly I have been in contact with QB help... cumulatively I have spoken to QB reps for 6 hours on this issue. I have been ping ponged back and forth between reps from all different departments including payroll, payroll admin, payrollcore, QB online, accounting without resolution. Last night at 9:45pm I was assured a Supervisor would call me back first thing in the morning to escalate this issue. That has not happened.

ghays3
Level 1

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

Were you able to get a resolution? This is currently happening with us as well.

ChristieAnn
QuickBooks Team

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

Hi there, ghays3.

Thank you for visiting the QuickBooks Community. I'll be providing extra details about the troubleshooting mentioned by my colleague. Then, to ensure you're routed to the right person to assist you further in resolving the issue with posting payroll entries.

 

The steps outlined above for creating a journal entry are usually the solution to a problem with incorrectly posting payroll tax transactions. A JE is used not only to transfer funds between two accounts but also to transfer transactions from expense to direct deposit.

 

I recommend contacting our QuickBooks Online support team if recording journal entries didn't fix the issue on your end. They have the tools to pull up your account and provide you with alternative details on how to solve the problem. They'll also investigate the cause of why the recorded data under CHASE appears as an expense rather than a DD.

 

Here's how to contact them:

 

  1. Open your QuickBooks Account.
  2. At the top right, click the Help icon.
  3. Choose the Assistant section.
  4. Type your concern in the Type something field.
  5. Click Talk to a human.
  6. Click I still need a human.
  7. Click the Get help from a human.
  8. You'll be routed into the How can we help? page. Then, select callback or how you want to contact them and fill in the information.

 

You can browse this article to learn more about the different types of support we offer at Intuit and its availability: Support hours and types.

 

Lastly, you may refer to this article to see information on how you can manage your payroll accounting settings to track your payroll transactions: Change your accounting preferences in QuickBooks Online Payroll.

 

Let me know if there's anything else you need help with posting payroll entries. I'm always here to help you anytime, ghays3. Take care and keep safe!

THISisPAINFUL1
Level 2

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

No Quickbooks has not resolved the issue despite countless attempts to get to the correct department.

Multiple representatives have told me my case was escalated and a supervisor would call me back. The supervisors never called back. My case could never be found.

 

Each subsequent call was like groundhogs day with each representative basically giving me the same solution after wasting hours of my time. 

We are not alone. Many people have had this issue but the representatives act like what happened is not possible. It is incredibly frustrating.  please share if you ever find a solution. Good luck.

jess25
Level 1

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

@THISisPAINFUL1  

were you ever able to find a solution?   I just discovered the exact same issue was happening to me after I switched banks....money was coming out of the right (new) bank account but apparently was mapping incorrectly.  Noticed my employee taxes were WAY high. 

 

So far I've tried 2 hours worth of support and getting no where to correct the past transactions! Would love to hear if you found a temporary work around or actual answers?

Ethel_A
QuickBooks Team

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

It isn't the kind of experience I'd like you to have, @jess2. I'm here to share information about payroll mapping.

 

As mentioned above by my colleague, MaryLandT, you can correct the posting account for liabilities and expenses but not the bank account through Journal Entry.

 

Here's an article you can read to learn about the basic in creating a journal entry: Create a journal entry in QuickBooks Online.

 

For liabilities, you can go to your payroll setting to fix this issue.

 

Here's how:

 

  1. Go to the Gear icon and select Payroll Settings.
  2. Click Preferences.
  3. Select Accounting Preferences.
  4. In the Checking Account drop-down arrow, select the correct account.

 

Also, I recommend consulting an accountant to know the specific account to use in recording transactions and ensure the accuracy of your books.

 

Lastly, here is an article for future reference in reconciling your account: Reconcile an account in QuickBooks Online.

 

You can click the Reply button below if you need additional assistance mapping your accounts. I'm always here to help. Have a great day.

koriellis
Level 1

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

I am currently experiencing the same issue and dealing with total incompetence on the QBO support side. I have also spent hours on the phone and they keep trying the same things over and over, with no result or answer. My settings are all set correctly for payroll bank account and accounting mapping, and I have not made any changes to my settings. But suddenly, on my last payroll run, the direct deposit transactions were mapped to my Quickbooks Online Checking account instead of to the bank register they actually came out of! This is not the account my settings show that payroll should be mapped to, but after almost 3 hours on the phone yesterday, the representative told me that if you have Quickbooks Online Checking payroll will now always map to that account and the ONLY fix is to start paying employees direct deposit from that account or make journal entries to fix it every time payroll is run. There is NO WAY this is right! I get to choose which account I make payroll from and there is no reason it should not map to the account I have selected. I too have been told a supervisor would call me, but have received no call back! SOOOOO frustrating!

mchull67
Level 2

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

QB online payroll has done this to two of my clients.  I've spent over 8 hours on the phone and no solutions.  They tell you to do a JE, which does not fix the bank account balance.  They randomly started posting payroll transactions to a bank account that is closed, and marked as inactive in QBO.  Find another payroll solution - that's the only real solution to this nonsense.  It's been a problem for several years and they refuse to correct it.

MAI86829
Level 1

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

Was anyone able to get a response from them? We are having this exact same issue and there is just no way that a JE is the way to "fix" this. Also extremely concerning the responses from intuit help have been this horrific and unhelpful. I never had these issues with their desktop edition.

Kurt_M
QuickBooks Team

QB mapped Direct Deposit and taxes to incorrect bank account, but took funds out of correct bank out

Hello there, @MAI86829.

 

I can see the urgency of this matter, and I'm here to point you in the right direction to get this sorted out as soon as possible. Know that you can reach out to your accountant if you're unsure of the recommendation provided by my colleague. This way, they'll be able to give you a more efficient way to handle this situation and ensure all numbers are accurate inside your QuickBooks Online (QBO) company.

 

If you don't have an accountant, I can help you find one. Feel free to visit this page to find an accountant for your business: Find a QuickBooks ProAdvisor.

 

Moreover, after settling this one, I'd highly recommend running reports. You can check this article for more details: Run reports in QuickBooks Online.

 

@MAI86829, The Community space is open 24/7 if you have any additional QuickBooks-related questions or need assistance accomplishing goals inside the program. Please don't hesitate to post here again. We've got you covered. Stay safe, and have a nice day!

Need to get in touch?

Contact us