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.