Skip to main content
September 27, 2019
Solved

Can you record a bank deposit as a non-sales item?Our bank makes monthly refunds of charges and when I entered them as bank deposits they are on my vat return as sales!

  • September 27, 2019
  • 1 reply
  • 0 views
Original commenter did not share additional details
Best answer by TSchonen

Hi @TSchonen,

 

I'm here to share insight on your query about recording a deposit without it appearing as a sale transaction.

 

Say, you record a deposit transaction. Set the Received From column to the supplier in question. As well as enter the same expense account under the Account column. Then the deposit will show up in your Profit and Loss Detail report under the expense category where it was assigned to. 

 

 

You can run the Profit and Loss Detail report to confirm this deposit isn't showing up as a sale transaction.

 

Here's how:

 

  1. Click the Reports tab.
  2. On the search box, type in Profit and Loss Detail.

I've replicated this on my end and came up with this result:

 

 

As you can see in the image above, the deposit transaction appears under the expense category, although it still acts as a regular deposit transaction. 

 

You can also view this article for supplier refunds: How do I handle supplier credits and refunds? This contains 2 scenarios where you can apply supplier credits to record a supplier refund. 

 

Let me know if you have other questions by leaving a comment below. I'll be sure to get back to you. 


Thank you for the explanation - Interestingly enough - I had this situation come up again and I captured it like you said and this time it did NOT show up as 'Not Specified' income on my sales report.  So I went back to the previous transaction that was giving me problems, made sure that it was captured identically however it STAYED on the sales report!

 

Eventually I deleted the transaction for the deposit, it appeared again from the bank statement and this time I did the same thing and it is now removed from the report. So clearly something got stuck before.

 

Anyway - It is now working and my problem is solved. 

Thank you

Tom

 

 

1 reply

September 27, 2019

Glad to see you in QuickBooks Community, @ian9.


Yes, you can record a bank deposit as a non-sales item by not choosing income as a posting account. Here’s how:

  1. Go to the Create icon and select Bank Deposit.
  2. Choose the deposit to account from the drop-down.
  3. In the Add funds to this deposit section, fill in the Received From, Description, Payment Method and Amount.
  4. Select a non-income account from the Account column. Doing so prevents it from showing as sales in QuickBooks.
  5. Hit Save and close.

 

Take a look at this article for more details: Record and make Bank Deposits in QuickBooks Online.


I’m also adding this link that tackles more about the topic for reference: Bank Deposits in QuickBooks.


Know that you can always count on me, so post again in the Community if you have questions. Have a great day!
 

May 28, 2020

Hi

 

I'm having this exact problem albeit with a normal refund received. I followed the actions below and deposited the money back into the same EXPENSE account that it was originally taken from. The issue I'm having is that the money received is showing up on my sales figures and that's not correct. That money received was not due to a sale!!! 

 

I just cannot get it off the sales report, no matter what ACCOUNT I assign it to.  It's showing up as 'Not Specified' income.

 

Any help would be most appreciated.

JasroV
May 28, 2020

Hi there, @TSchonen.

 

I appreciate you for going through the steps above and for trying all accounts to resolve this. However, you'll want to ensure the account used in the deposit is not a sales account. Example of this are Expense, Assets, or Liability accounts. 

 

Nonetheless, I recommend consulting with an accountant for guidance in choosing the right account. This way, we'll guarantee the accuracy of your accounts after recording this.

 

Furthermore, I got you this article that you can read for additional reference. This can guide you to understand more of your chart of accounts: Understand the chart of accounts in QuickBooks

 

Lastly, here's a great article you can use for future reference. This resource provides complete information on how you can reconcile your accounts accordingly: Reconcile an account in QuickBooks Online

 

Please let me know if there's anything else you need help you. I'll be around to help you. Take care and always keep safe!