cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
nsk3055
Level 1

How do I take a large deposit from our bank transactions and chunk it into several customer credits?

Every month we receive a large deposit from our state government to hold for our customers - it's part of a heating oil delivery energy assistance program. The customers will eventually call into us and request a delivery using that energy assistance money. How can I go about turning that large deposit that will come in as a bank transaction into a credit labeled as "Energy Assistance" on every customer's account. Is there any way I can then view that available credit amount when looking at the customer's page?

Thank you!

2 Comments 2
Rainflurry
Level 14

How do I take a large deposit from our bank transactions and chunk it into several customer credits?

@nsk3055 

 

"How can I go about turning that large deposit that will come in as a bank transaction into a credit labeled as "Energy Assistance" on every customer's account. Is there any way I can then view that available credit amount when looking at the customer's page?"

 

Unfortunately, no.  QBO is designed to assign A/R credits at the individual customer level.  I think the best you can do is to create an Other Current Liability (OCL) account called "Energy Assistance" and assign that to the payment received from your state.  Then, create a service product called "Energy Assistance" (or something similar) and assign the same Energy Assistance OCL as the income account for that item.  When you apply the credit to a customer's invoice/sales receipt, add that service item to each customer's invoice as a negative to reduce the amount due on the invoice.  To see the outstanding amount available in the Energy Assistance account, you will need to look at the balance in your chart of accounts or on your balance sheet.     

JayneusCaesarR
QuickBooks Team

How do I take a large deposit from our bank transactions and chunk it into several customer credits?

I'm happy to hear Rainflurry was able to give an idea about your questions, @nsk3055 .

 

To narrow it down, please follow these steps:

  1. Create an Other Current Liability (OCL) account called "Energy Assistance".
  2. Create a service item to apply to the income account.
  3. For your future transactions involving customers in the assistance program, add a line item with a negative amount to the invoice to apply the credit.

 

For more details, please check this article, it will help you to set up an account: Set up your liability account.

 

Take note: on the chart of accounts, we cannot view the credit amount on the customer’s page; however, it's useful to know that we can track the remaining balance of the deposited amount from the state government.

 

For future guidance, I'm adding information that outlines the following instructions: Add an account to your chart of accounts in QuickBooks Online.


We have experts in QuickBooks Live Bookkeeping, which can help you set up these transactions accurately and efficiently, ensuring your financial records are compliant and precise.

 

Please feel free to send a reply here and create a new thread if a question arises about your bank transactions and creating an account. The Communities are always here to help.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us