Skip to main content
M
mikefkf
April 28, 2022
Solved

Bank transaction mismtach

  • April 28, 2022
  • 2 replies
  • 0 views

I have a transaction in Banking (For Review) showing as a credit ("Received", categorized as Uncategorized Income) but was a debit on the bank's register (verified in online bank access). It was a check written by us (monthly rent check), so should be a debit. I don't even know where to begin. Any ideas?

 

Thanks!

Best answer by MarsStephanieL

Hi there, @mikefkf. I'm here to ensure that you can categorize your transactions properly in QuickBooks Online (QBO).

 

Your rent expense should reflect as a debit on your bank transaction. I'd like to know the bank name to check our system if there is an ongoing investigation about this issue. Have you also clicked on the Update button on the Banking page? It will refresh the feeds and might change the wrong amount shown.

 

If the issue persists, I'd recommend contacting our Customer Care Team. They have the tools to verify and conduct further troubleshooting method to fix it. You can also check the support hours to get help right away.

 

For now, I suggest uploading the transaction using a .csv file to categorize your transactions. You can go to your bank's website and get the transactions from there. Save it to Excel, follow the format below:

 

  • Column 1-A: Date
  • Column 1-B: Description
  • Column 1-C: Amount (Enter a negative sign before the number if it's a debit transaction.)

 

 

Once done, save it as .csv (Comma Separated Value) file. Then you can proceed to uploading the file in QBO.

 

Here's how:

 

  1. Login to your QBO account.
  2. Go to the Banking page.
  3. Click on the bank account and click on the dropdown icon beside the Link account.
  4. Select Upload from file. 
  5. Click Select file and Continue.
  6. Map the column file and click OK.

 

For more details about the process, you can check out this article: Manually upload transactions into QuickBooks Online.

 

Moreover, I've included this reference in case you're ready to assess your business' financials: Learn the reconcile workflow in QuickBooks. It contains tips and fixes with any reconciliation issues you might encounter in the future.

 

Please don't hesitate to let me know if you have difficulties with the steps about uploading your bank transactions in QBO. Or if you have other concerns, I'll be here to back you up. Take care!

2 replies

MarsStephanieL
MarsStephanieLAnswer
April 28, 2022

Hi there, @mikefkf. I'm here to ensure that you can categorize your transactions properly in QuickBooks Online (QBO).

 

Your rent expense should reflect as a debit on your bank transaction. I'd like to know the bank name to check our system if there is an ongoing investigation about this issue. Have you also clicked on the Update button on the Banking page? It will refresh the feeds and might change the wrong amount shown.

 

If the issue persists, I'd recommend contacting our Customer Care Team. They have the tools to verify and conduct further troubleshooting method to fix it. You can also check the support hours to get help right away.

 

For now, I suggest uploading the transaction using a .csv file to categorize your transactions. You can go to your bank's website and get the transactions from there. Save it to Excel, follow the format below:

 

  • Column 1-A: Date
  • Column 1-B: Description
  • Column 1-C: Amount (Enter a negative sign before the number if it's a debit transaction.)

 

 

Once done, save it as .csv (Comma Separated Value) file. Then you can proceed to uploading the file in QBO.

 

Here's how:

 

  1. Login to your QBO account.
  2. Go to the Banking page.
  3. Click on the bank account and click on the dropdown icon beside the Link account.
  4. Select Upload from file. 
  5. Click Select file and Continue.
  6. Map the column file and click OK.

 

For more details about the process, you can check out this article: Manually upload transactions into QuickBooks Online.

 

Moreover, I've included this reference in case you're ready to assess your business' financials: Learn the reconcile workflow in QuickBooks. It contains tips and fixes with any reconciliation issues you might encounter in the future.

 

Please don't hesitate to let me know if you have difficulties with the steps about uploading your bank transactions in QBO. Or if you have other concerns, I'll be here to back you up. Take care!

Rainflurry
Rainflurry
April 28, 2022

@mikefkf 

 

The terms debit and credit are used differently from the bank's perspective than in accounting terms as it applies in QB.  From our perspective, in accounting terms, a check written out of our bank account is a credit to the bank balance, not a debit (it reduces your cash asset).  This is contrary to how a bank refers to a withdrawal.  They refer to it as a debit which, from their perspective, it is.  It is a reduction in their deposit liabilities - they no longer owe you that money.  

 


 

 

 

M
mikefkfAuthor
April 29, 2022

The bank shows the check coming out of my account. QB shows the exact same amount being added to my account ("Received", not "Spent" in the Banking view). There is no scenario where this should be a valid outcome, regardless of terminology.

Terms & ConditionsAccessibility statement