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

Payment Plan / Installment Plan Billing

Hello!

 

I am the new business administrator for a school and we just switched to Quickbooks Online from Quickbooks Pro 2016. 

 

We charge a yearly tuition and offer a payment plan option to our families, so we enter the total amount of tuition and fees and then bill them monthly for an agreed upon installment. 

 

When we would send out statements with the QBPro, we just added in a comment of how much the family owed that month into the footer line of the statement. It was a lot of work and not my favorite way of doing it. 

 

Also, we had everything set up where each family was a customer, and each new year for each child was a job under that customer. 

 

With QBO, I can't add a footer comment on the statement, only the invoice, which doesn't work well with our customer(family)/job(Child/year) set up stated above. 

 

So my question is, is there a way to bill out installments, where it will clearly show the partial payment that is due? 

 

 

5 Comments 5
Kristine Mae
Moderator

Payment Plan / Installment Plan Billing

Congratulations on being the new business administrator, jnmegee.

 

With regard to your concern, we're unable to add a footer on the statement. Though, you can still see the balance due on the form. As a workaround, you can add the partial amount due on the statement's body. This way, when you email or send the form, it will show how much they owe for that month. 

 

Here's how:

  1. Go to the customer's profile.
  2. Click the New transaction drop-down arrow, then choose Statement.
  3. Make sure the Statement, Start, and End dates are correct.
  4. Click Save and send.
  5. Add the partial amount due in the Body field.
  6. Click Send.

You can check the screenshots.

 

 

 

 

I'm just here if you have further questions on this. Thank you and have a great day! 

GotBrent
Level 1

Payment Plan / Installment Plan Billing

Would you be able to address the installment plan billing part of her question, please?

GotBrent
Level 1

Payment Plan / Installment Plan Billing

Hello!

Would you address the installment part of her question, please? 

So my question is, is there a way to bill out installments, where it will clearly show the partial payment that is due? 

I see in your example that even though the client only owes $100 for the current month, it shows the entire balance of $300 as being 90+ days past due, and that the client/customer owes $300 at the current time, which isn't clear. They only owe $100, and are not late with payments. 

Jovychris_A
Moderator

Payment Plan / Installment Plan Billing

Hi @GotBrent.

 

Currently, we're unable to view partial payments made to installments.

 

As a workaround, you'll want to create a recurring invoice transaction for billing installments. This way, you can run the Invoices and Received Payments report that will show the paid invoices under the total payment received.

 

From there, you can modify and include the report to show columns for Due dateA/R Paid, and Open Balance by clicking the mini Gear icon.

 

For more details about adding and editing recurring transactions, you can reference this article: Create recurring transactions in QuickBooks Online.

 

Additionally, you can pull up a Transaction by Account Detail report to show lists of invoices that are due on a particular day or date range.

 

Let me know if you have other concerns about showing specific details with sales transactions. I'm always here to help.

Paul Marc
Level 1

Payment Plan / Installment Plan Billing

I create an Estimate that includes the entire tuition and fees for the year.  From within the Estimate, I create my first Invoice using 15% of the Estimate, or I could enter a flat amount.  The total annual cost is $9000, so my Invoice will display 15% line by line adding up to $1350. The remaining balance is equally split into 9 months, $7650 / 10 = $765.00/month.  When you email the Invoice to your customer, they will see the annual amount, minus any payments or additional charges and the outstanding balance.

Need to get in touch?

Contact us