How to track partial payments for personal training packages

Start with the full pack record

Record the pack reference, purchase date, total sessions, total agreed price, and any expiry. Add the agreed installment dates to your working record. Do not enter a $325 pack price simply because $325 arrived first; that would hide the second half of the agreement.

You also need a record of each payment. Give it a date, amount, method, and reference or note. A paid checkbox cannot show two different payment dates or explain why a balance changed.

Keep a dated payment log

Enter the first payment when you confirm it arrived. Enter the second as a separate row when it arrives. Do not count a payment request, invoice, or promise as money received.

Use separate spreadsheet calculations

In your working workbook, calculate money outstanding as the agreed pack price minus the payments received against that pack. Calculate sessions left as starting credits minus valid deductions, allowing for any recorded corrections.

For a simple example with price in B2 and payments received in C2, =B2-C2 gives the amount outstanding. With sessions purchased in D2 and sessions used in E2, =D2-E2 gives sessions left. A dated log is still needed to explain the totals. If you see a negative balance, investigate it instead of hiding it with a formula that forces zero.

Do not double-count money moving between accounts

If Jamie pays $325 through a payment provider and the provider later transfers money to your bank, that bank transfer is not a second client payment. Match the transfer to the original receipt. Keep processing fees separate from the amount the client paid.

When a record is wrong, retain enough detail to explain the correction. Reversing a mistaken payment entry should not quietly remove delivered sessions. A refund or a credit adjustment needs its own clear record.

Before moving the record into PacksLeft

The free roster-import sheet has a single price field and source field; it is not an installment schedule. Do not assume that extra paid, outstanding, or due-date columns will import as a payment history. Keep your detailed payment log when transferring current balances.

PacksLeft can record payments against packs. If installment tracking is essential to you, check the pack price and payment history with a sample client before importing the whole roster. This guide does not imply automatic installment collection or automatic client payment reminders.

See the supported spreadsheet columns ↗

Send a reminder using the verified amount

Check your provider and cash records immediately before sending. Include the pack reference if the client has purchased more than one pack over time.

Separate refunds, reversals, and processing fees

A refund is a new money event, not an attended session. Link it to the original payment and pack, record the amount and date, and update the amount outstanding only according to the agreement you have with the client. If a card payment is reversed or disputed, mark it for review rather than treating the earlier receipt as permanently settled.

Keep processor fees in your business reconciliation, separate from what the client paid toward the pack. If a client paid $325 and the processor deposited $315 after fees, the client payment is still $325; the difference is a fee. Use the processor statement and bank settlement to reconcile those two records.

What if the payment date or amount changes?

If you and the client agree to move the second installment date, update the written terms and keep the earlier date in the history. If the amount changes, show the old agreement, the revised amount, and when the change was accepted. Do not silently replace the original figure in a spreadsheet; that makes a later question harder to answer.

If a payment arrives in a different amount than expected, record the actual receipt and contact the client to confirm how it should be applied. A short payment does not automatically change the pack size or session count. A duplicate payment should be investigated and refunded or credited only after you confirm what happened.

Check the record before a reminder

Before sending a balance request, open the payment source and check for a recent receipt under another display name. Confirm the amount already received, the pack reference, and the date the next installment was agreed to. If the client says they paid, ask for the transaction date or reference and investigate before sending another link.

This guide shows a record-keeping method, not a legal or accounting rule. Use the payment terms you actually agreed to and ask a qualified tax or legal professional about record-retention, tax treatment, or collection questions for your location.