Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
KFN
Level 1

How can I track customer prepaid services?

I run a Yoga studio as a solo proprietorship and I sell different packages (example 5 sessions, 10 sessions, etc.). I accept payment through Stripe and use Acuity for clients to book their sessions. How can I track how many session each client has remaining?

4 Comments 4
MaryLurleenM
Moderator

How can I track customer prepaid services?

Hello there, KFN,

 

You'll want to create a liability account to track the amount of prepayments. Let me show you how:

  1. Go to Accounting on the left pane, then choose Chart of Accounts.
  2. Hit New and choose Other Current Liabilities from the Account Type drop-down list.
  3. Select Trust Accounts - Liabilities under the Detail Type drop-down.
  4. Enter a name for the account example, Trust Liabilities.
  5. Click Save and close.

image.png

Next, create a service item that you can use when recording invoices. Here's how:

  1. Click the Gear icon and choose Products and Services.
  2. Hit New.
  3. Select Service from the Product/Service Information.
  4. Add the service item.
  5. From the Income Account drop-down, choose Trust Liability Account.
  6. Lastly, click Save and close.

image.png

 

Here's an article for the complete details about prepayments:How to record a retainer or deposit.

 

Furthermore, to track how many session each client has remaining, you can create one invoice. You can add each line item every time your client takes their yoga session. Make sure to select the Service Date when adding, so you can track when they used the service. You can click on Save, after creating the invoice.

 

If there's anything else that I can help you with in QBO, feel to leave a comment below.

Fiat Lux - ASIA
Level 15

How can I track customer prepaid services?

@KFN 

Consider having a time tracker app to integrate with your QBO. You may create limits on hours billed for sessions.

anneliesemoves
Level 1

How can I track customer prepaid services?

Thank you! This was very helpful for recording client payments. Could you please elaborate on the invoicing to track each class a client takes and how to track their balance?

I have clients who will pay for a package ex) 5 group classes; and take all 5 as planned. Occasionally a client will pay for a package of 5 group classes, then they request to use some of that credit for a private lesson. So I need to record whichever type of class they take and an up-to-date credit amount.

Catherine_B
QuickBooks Team

How can I track customer prepaid services?

We can pull up a class report, anneliesemoves.

 

You can use the Transaction Detail by Account Report to show all customer transactions grouped by class. Then, we'll customize it further to add the Balance and Open Balance column. 

 

Let me show you how:

 

  1. Go to the Reports menu.
  2. Enter and select in the Search field Transactions Detail by Account.
  3. At the upper-right, click Customize
  4. Under the Rows/Columns section, select Class under Group by.
  5. Click Change columns and check the Balance, Open Balance, and Credit boxes.
  6. Select Run report

You can save the report so you don't have to filter it all over again. If you want to send them to your customer, you can either export it (Excel or PDF) or directly email it. For more details on how to do that, you can use this reference: Customize reports in QuickBooks Online.

 

If you need more help with tracking your classes, you can always post them here. You take care and have a good one!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us