Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceAccounting & BookkeepingAccounts ReceivableCustomer Credit Limit Review

SpreadsheetAccounts ReceivableFree

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.

Shown with sample data

Colour

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.

Total exposure (balances)
$140,700
High-risk exposure
$34,200
Balances owed by high-risk customers
High-risk customers
3
Limits to change
7
Customers over their limit
3
Balance over 60 days
$12,484
Average days beyond terms
14.9
Risk score by customer
  • Ridgeway Clinics97
  • Atlas Freight86
  • Harbor Logistics81
  • Cedar Health78
  • Pine & Paper62
  • Bluepeak Retail38
  • Juniper & Co23
  • Northwind Studio21
Suggested vs current: change in limit
  • Ridgeway Clinics$30,000
  • Harbor Logistics$25,000
  • Cedar Health$13,000
  • Atlas Freight-$1,000
  • Northwind Studio-$2,000
  • Pine & Paper-$4,000
  • Juniper & Co-$7,000
  • Bluepeak Retail-$9,000

How to use it

  1. 1On Customers, enter annual sales to each customer, current balance and limit, payment terms, average days to pay, the balance over 60 days and the latest credit bureau score (0–100).
  2. 2Check utilisation: customers over 100% are already beyond their limit.
  3. 3Review the scoring weights and band factors on Scoring, and adjust them to your risk appetite.
  4. 4On Review, compare the suggested limit with the current one and agree an action for every customer.
  5. 5Record the decision, write to customers whose limits change, and update your accounting system.

In this workbook

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

About this template

Credit limits set once at account opening rarely match how a customer behaves two years later. Enter each customer’s sales, balance, limit, terms, average days to pay, balance over 60 days and bureau score; the review scores risk out of 100 with transparent weights, places each customer in a low, medium or high risk band, suggests a limit based on their sales and terms, and recommends increase, keep, reduce or hold.

Who it’s for

  • Annual or quarterly credit reviews
  • Reducing bad debt without losing good customers
  • Giving sales teams a fair, consistent answer on limits

What’s included

  • Review sheet: Risk score, band, suggested limit and action for each customer.
  • Customers sheet: Sales, balances, terms and payment behaviour for each customer.
  • Scoring sheet: Band thresholds and limit factors.

How to use it

  1. 1On Customers, enter annual sales to each customer, current balance and limit, payment terms, average days to pay, the balance over 60 days and the latest credit bureau score (0–100).
  2. 2Check utilisation: customers over 100% are already beyond their limit.
  3. 3Review the scoring weights and band factors on Scoring, and adjust them to your risk appetite.
  4. 4On Review, compare the suggested limit with the current one and agree an action for every customer.
  5. 5Record the decision, write to customers whose limits change, and update your accounting system.

Tips

  • Payment behaviour with you is the best predictor of future payment; it carries the most weight in the score.
  • A suggested limit is a starting point. Large or strategic accounts deserve financial statements and a conversation, not just a formula.
  • Review high-risk customers monthly and everyone else at least once a year.

Questions

How do you calculate a customer credit limit?

A common method is expected sales per day × (payment terms + a buffer), adjusted for risk. Here: annual sales ÷ 365 × (terms + 15 days) × a factor for the risk band (1.25 low, 1.0 medium, 0.5 high).

How is the risk score worked out?

Up to 40 points for paying within terms, 30 for the bureau score, 15 for years trading and 15 for having nothing over 60 days. 75 or more is low risk; below 50 is high risk. Edit the thresholds on Scoring.

When should I put an account on hold?

When a high-risk customer has balances more than 60 days overdue. Supply on prepayment until it is cleared or a payment plan is signed.

Related searchescredit limit reviewcustomer credit scoringtrade credit limit calculatorcredit risk assessment templatecredit controlhow to set credit limits

Details

Format
Spreadsheet
Category
Accounts Receivable
Sheets
3
Setup
10 min
Level
Advanced
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounts ReceivableFree

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.

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
3
Setup
10 min
Level
Advanced
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
Collections Call Log2 sheets

Contacts logged

11

Promised and pending

$3,051

Promise-kept rate

33%

ABCD
1DateCustomerInvoiceAmount overdue
2Oct 12Juniper & CoINV-2031$4,850
3Oct 14Bluepeak RetailINV-2044$1,314
4Oct 20Atlas FreightINV-2046$1,200
5Oct 27Juniper & CoINV-2031$4,850
Contacts
SpreadsheetAccounts Receivable

Collections Call Log

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

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