Video tutorial · 4K
Track outstanding payments with a free template
Track outstanding payments with a free CSV template for Excel or Google Sheets. Record the due date and a partial payment, plan the next follow-up and complete the payment record.
Chapters
Transcript
00:00 Let's organise a payment follow-up with Cuotaro's free template. We'll use Panadería Norte's tap replacement, with a total of one hundred and eighty-five euros. We'll record how much has arrived, what's still outstanding and when to review it again. You can follow along with a working copy in your usual spreadsheet application.
00:23 On the Resources page of the Cuotaro website, download the outstanding payments template. Open it in your spreadsheet application and save a working copy. Replace the fictional row with your own example. If everything appears in one column, choose a comma as the separator and U T F eight encoding when importing the file.
00:46 Start with the payment reference, Panadería Norte and the related job or quote. Enter one hundred and eighty-five euros as the expected amount. The agreed due date is the twenty-first of October. Leave the amount received at zero until we record the first payment. We now have the case identified and ready to follow up.
01:10 Alex will handle the follow-up. Enter Check the payment as the next action and choose the twenty-second of October as the follow-up date. On that day, we'll check whether the money has arrived and contact the customer if needed. When we return to the sheet, the person, date and next step will be together.
01:32 On the twenty-second, we confirm receipt of one hundred euros. Enter one hundred under amount received, add the date and change the status to Partial. For this review, calculate what's left: one hundred and eighty-five minus one hundred leaves eighty-five euros. Add that result to the notes, together with the payment date.
01:56 After speaking to the customer, we agree to review the balance on the twenty-sixth. Enter Check the remaining eighty-five euros as the next action and update the follow-up date. The original due date stays the twenty-first. Our note keeps a record of what's arrived and what we've agreed to do next.
02:17 We've prepared this partial-payment stage separately in Cuotaro. Under Payments, there's a record for one hundred euros received on the twenty-second and another for eighty-five euros still open. Both are linked to the customer, quote and job. Filter by Panadería Norte to find them together. The template and the app are used independently.
02:42 Continue the example in the spreadsheet. Suppose the remaining eighty-five euros arrive on the twenty-sixth. The total amount received becomes one hundred and eighty-five and the status changes to Paid. Record the date and keep both payments in the notes. We can now clear the next action and its follow-up date, leaving the payment history available.
03:06 We've identified the payment, recorded the amount received and kept its history. Start with one payment from your business and complete the sheet at your own pace. You'll find the template and the user manual on the Cuotaro website. Thanks for joining us; you can return to a chapter whenever you need it.