Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceAccounting & BookkeepingAccounts ReceivableCollections Call Log

SpreadsheetAccounts ReceivableFree

Collections Call Log

Record every collections call and email, track promises to pay and whether they were kept, and know who to call next.

Shown with sample data

Colour

Collections Call Log

Record every collections call and email, track promises to pay and whether they were kept, and know who to call next.

Contacts logged
11
Promised and pending
$3,051
Promise-kept rate
33%
Broken promises
2
Follow-ups due now
4
Contacts by customer
  • Juniper & Co4
  • Northwind Studio3
  • Bluepeak Retail2
  • Cedar Health1
  • Atlas Freight1

How to use it

  1. 1Log every call, email or letter on the day, with the invoice and amount overdue at the time.
  2. 2Choose the outcome. For a promise to pay, enter the amount and date promised.
  3. 3When the promised date passes, set Promise kept to Yes or No.
  4. 4Each morning, work through rows marked Follow up now, then Broken promise.
  5. 5Check By customer weekly: two broken promises or a long silence means escalate.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Collections is a follow-up game, and the follow-up gets lost in inboxes. Log each contact with the customer, invoice, amount overdue, who you spoke to and the outcome; the log sets the next follow-up date, tracks promises to pay until they are kept or broken, flags disputes, and summarises each customer so you know who to escalate.

Who it’s for

  • Weekly collections calls
  • Teams sharing the chase list
  • Building evidence before escalating or sending to an agency

What’s included

  • Contacts sheet: Every collections contact, newest at the bottom.
  • By customer sheet: Contacts, promises and a recommendation for each customer.

How to use it

  1. 1Log every call, email or letter on the day, with the invoice and amount overdue at the time.
  2. 2Choose the outcome. For a promise to pay, enter the amount and date promised.
  3. 3When the promised date passes, set Promise kept to Yes or No.
  4. 4Each morning, work through rows marked Follow up now, then Broken promise.
  5. 5Check By customer weekly: two broken promises or a long silence means escalate.

Tips

  • Always ask for a specific amount and date. “Next week” is not a promise to pay.
  • Confirm every promise by email the same day; it turns a conversation into a record.
  • Resolve disputes fast. A disputed invoice will not be paid until someone fixes the underlying problem.

Questions

What should a collections log include?

Date, customer, invoice, amount overdue, the person contacted, the outcome, any promise to pay (amount and date) and the next action. That record supports escalation, payment plans and legal action if needed.

How often should I follow up on overdue invoices?

A common rhythm is a reminder at 1–3 days overdue, a call at 7–10 days, weekly calls after that, and escalation after 45–60 days or two broken promises.

What is a promise-to-pay rate?

The share of promises that were kept. Tracking it shows which customers and which collectors get reliable commitments.

Related searchescollections call logcollection activity logaccounts receivable follow uppromise to pay trackerdebt collection logar collections template

Details

Format
Spreadsheet
Category
Accounts Receivable
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounts ReceivableFree

Collections Call Log

Record every collections call and email, track promises to pay and whether they were kept, and know who to call next.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Accounts Receivable
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More accounts receivable templates

View all

Business Credit Application Form

Complete this form to apply for a credit account. We will confirm your credit limit and terms in writing.

Registered company name *

Trading name

Company registration number

Submit application
FormAccounts Receivable

Business Credit Application Form

Collect company details, trade references and the credit limit requested before offering payment terms.

10 min setupPreview
Customer Credit Limit Review3 sheets

Total exposure (balances)

$140,700

High-risk exposure

$34,200

High-risk customers

3

ABCD
1CustomerRisk scoreRisk bandBalance
2Harbor Logistics81Low risk$41,200
3Cedar Health78Low risk$22,800
4Bluepeak Retail38High risk$9,400
5Juniper & Co23High risk$18,600
Review
SpreadsheetAccounts Receivable

Customer Credit Limit Review

Score every trade customer on payment behaviour, credit rating, history and overdue balances, and get a suggested credit limit and action.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ