Visitar URL original
GitHub - SirMem/freelancer-invoice-aging-sample: Free freelancer invoice aging sample (AR buckets Current/1-30/31-60/60+) · GitHub
Skip to content

About

Free freelancer invoice aging sample (AR buckets Current/1-30/31-60/60+)

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

7 Commits

Folders and files

Repository files navigation

Who to Chase This Friday — Free Invoice Aging Sample

Friday chase ritual (hub): https://sirmem.github.io/freelancer-money-sheets/who-to-chase-this-friday-freelance-invoices.html

Trust hub (disclosure · ledger · refund): https://sirmem.github.io/freelancer-money-sheets/

A complete, usable Who to Chase This Friday spreadsheet: sort unpaid invoices into the four standard accounts-receivable buckets, then pick the top three by days overdue (usually 60+ first unless already written off).

This file is a structural seam of the larger Who to Chase This Friday — Freelance Invoice Aging Tracker — same quality as the paid Aging surface, not a crippled demo. It solves “who do I chase this Friday?” end-to-end. It does not create invoices, store client addresses, print PDFs, or roll income dashboards. It is not a soft→firm email-script pack.

15-minute Friday ritual

  1. Set Aging as of to this Friday.
  2. Confirm every open invoice sits in a bucket (Current / 1–30 / 31–60 / 60+).
  3. Sort by days overdue (not amount).
  4. Pick the top three only — usually chase 60+ first unless written off.
  5. Chase those three. Stop. Don’t rebuild tabs first.

Full write-up: who-to-chase-this-friday-freelance-invoices.html

What's inside

Bucket Meaning Friday bias
Current Not yet past due Watch — don’t chase yet
1-30 1–30 days overdue Polite nudge if amount/client matters
31-60 31–60 days overdue Escalate tone / confirm receipt
60+ 60+ days overdue Usually chase first unless written off
  • EXAMPLE rows only (fictional clients) — replace with your own; do not publish real client PII.
  • Auto bucket totals (count + $) via COUNTIF / SUMIF; Days past due + Bucket are formulas off Aging as of.
  • Top 3 this Friday helper block on the Aging Sample sheet (EXAMPLE as of 2026-10-31).
  • Sheets: Start Here · Full Tracker — What's Inside · Aging Sample

Download

Raw .xlsx (right-click → Save As):

https://raw.githubusercontent.com/SirMem/freelancer-invoice-aging-sample/main/Freelancer-Invoice-Aging-Sample.xlsx

Or clone / browse this repo and open Freelancer-Invoice-Aging-Sample.xlsx in Excel, Google Sheets, or LibreOffice.

中文 · 学生/新人私活追账(人民币 ¥)

面向接私活被拖款的学生/新人。同一套四档账龄 + top3 仪式,EXAMPLE 客户与金额为 人民币 ¥。

文件 说明
Xuesheng-Sihuo-Aging-Sample.xlsx 中文表头 · ¥ · 虚构甲方(小程序/剪辑/设计/代写/摄影)
Freelancer-Invoice-Aging-Sample.xlsx 英文 · $ · 原 Friday-chase 样本

CN 仪式页: https://sirmem.github.io/freelancer-money-sheets/zh-xuesheng-sihuo-zhuizhang.html

Raw 下载(CN ¥):
https://raw.githubusercontent.com/SirMem/freelancer-invoice-aging-sample/main/Xuesheng-Sihuo-Aging-Sample.xlsx

EXAMPLE 汇总(截至 2026-10-31)

  • 未收合计 outstanding:¥12,660.00
  • 逾期合计 overdue(days > 0):¥6,960.00
  • Top3 先催:代写单(75天 / 60+)→ 设计单(42天 / 31-60)→ 剪辑客户(12天 / 1-30)

工作表:从这里开始 · 付费表多了什么 · 账龄样本。EXAMPLE 全部虚构;非法律/税务/催收建议。

Primary CTA — this sample feeds Invoice only

Late pay / messy aging receivables → Who to Chase This Friday — Freelance Invoice Aging Tracker $6

Stay free if the Aging subset is enough. This sample does not hard-upsell Expense, Client, or Bundle. Free Aging stays free ($0+ on Gumroad: merlns).

Which tracker? (situation map)

  • Late pay / messy aging receivables → Invoice Tracker $6 (not Expense or Client)
  • Tax season / Schedule C categories + mileage mess → Expense Tracker $5
  • Pipeline of leads/clients (status + hours), not cash chase → Client Tracker $5
  • Already decided you need all three money ops → Bundle $12 (one checkout)
  • Free Aging sample feeds Invoice only — stay free if the subset is enough
  • Free Expense Category / Client Pipeline samples feed Expense / Client only
  • ADHD 2027 planner & RE listing prompts are different ICPs — free-only here (not money-tracker upsells)

Free vs paid (Invoice only)

This free Aging sample answers “who to chase this Friday?” with four buckets + a top-3 helper.

It does not include: reusable Clients address book, printable single-invoice PDF sheet, Invoice Log history, or Dashboard (outstanding / paid YTD / avg days-to-pay). Those live in the paid Who to Chase This Friday — Freelance Invoice Aging Tracker $6 for the same late-pay situation.

If the four-bucket subset is enough, stay free — no pitch. Prefer a GitHub issue over email if something in the sample is unclear (Gumroad in-app email may be unavailable on free products).

Source / methodology

Based on the common public accounts-receivable aging practice (Current / 1–30 / 31–60 / 60+ days past due) used in bookkeeping textbooks and SME workflows. Friday ritual aligned with the public hub page above. Example data is fictional. Not Kevin’s personal client data. Not tax or accounting advice. MIT-style personal use; see License.

License

Free for personal use. Example data is fictional. Not accounting advice.

About

Free freelancer invoice aging sample (AR buckets Current/1-30/31-60/60+)

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors