cancel
Showing results for 
Search instead for 
Did you mean: 
PoppyAI
Level 1

Manage open items in a balance sheet account

Hi

I use quickbooks online.

We have balance sheet accounts like accruals, deferred income, prepayment.

Is there a way in Quickbooks to manage open items ?

Example : I will have my prepayment invoice booked in Jan 2023 for my Q1 charges. In Jan, Feb and March I will release 1/3 each month and therefore at the end of March 2023 this prepayment is fully closed (i.e no more open balance on this invoice - all released).

Is there a way to manage this in QBO ? Where, once all released, we can select something and it goes under "closed items" or similar. And therefore if I run my prepayment listing mid april, I won't see those closed/fully released items  and only the open one ? 

Thank you very much

1 Comment 1
jenop2
QuickBooks Team

Manage open items in a balance sheet account

I'm glad you joined us here in the Community, PoppyAI.

 

Allow me to share details that can help with your questions about deferred income and prepayments. In QBO, you can record it as a deposit or retainer. I'd be glad to share all the steps with you.

 

First, create a liability account to track the deposit or prepayment you receive from your customers. This way, it will not affect income until you will use or post it as part of your sales. Here's how:

 

  1. Open your Chart of Accounts and click New.
  2. Select Liabilities, then select Other Current Liabilities in the drop-down list for Save account under.
  3. Look for Other Current Liabilities in the Tax form section.
  4. Enter a Name for the account (for example, Trust Liabilities) or accept the suggested name.
  5. Click Save and Close.

 

other current liability.PNG

 

Second, follow these steps on how to create a retainer item:

 

  1. Go to the Gear or Settings ⚙ icon and select Products and services.
  2. Click New.
  3. From the Product/Service information panel, select Service.
  4. Enter a name for the new product or service item (for example, Retainer).
  5. Proceed to the drop-down list for Income account, then select the liability account you created in Step 1.
  6. Click Save and close.

 

other current liability 2.PNG

 

Third, a trust liability bank account where you can store or deposit the prepayment. Here's how:

 

  1. Go back to your Chart of accounts and click New.
  2. Select Bank, then select Bank Accounts in the drop-down list for Save account under.
  3. Look for Trust account in the Tax form section.
  4. Enter a Name for the account (for example, Trust account) or accept the suggested name.
  5. Click Save and Close.

 

trust account.PNG

 

Fourth, create an invoice to receive the prepayment. Follow these steps on how to do it:

 

  1. Click the + New button and select Invoice.
  2. Select the Customer name from the dropdown list.
  3. In the Product/Service column, select the Retainer or Deposit item you set up.
  4. Enter the amount received for the retainer or deposit in the Rate or Amount column.
  5. Click Save and close.

 

Lastly, convert the prepayment or deposits into credits on invoices. This decreases the amount in your liability account and applies the credit to your customer's invoice, turning it into income. Here's how:

 

  1. Create an invoice for your customer that lists the services or goods you've provided.
  2. On the last line of the invoice, in the Product/Service field, select the Retainer or Deposit item.
  3. Enter the retainer Amount as a negative to subtract it from the invoice. You cannot enter a retainer amount greater than the invoice total. An invoice can have a zero total, but not a negative one.
  4. Select Save and close.

 

retainer.PNG

 

Additional details about this process are discussed thoroughly in this article: Record a Retainer or Deposit.

 

However, I would still recommend reaching out to your accountant for additional advice on this matter. 

 

Allow me to share additional articles for more guidance when using QBO:

 


Feel free to ask follow-up questions when managing customer payments. You can also visit us again any time you need more help with QuickBooks. We're always here to help. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us