The latest articles on DEV Community by Charlie Grant (@charlie_grant_bb4ccaeaa68). https://dev.to/charlie_grant_bb4ccaeaa68 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4112814%2F98bb4de2-3643-4635-8358-905844a94803.png https://dev.to/charlie_grant_bb4ccaeaa68 en Charlie Grant Sun, 06 Sep 2026 20:34:33 +0000 https://dev.to/charlie_grant_bb4ccaeaa68/how-freelancers-can-track-client-payments-in-one-spreadsheet-1o6a https://dev.to/charlie_grant_bb4ccaeaa68/how-freelancers-can-track-client-payments-in-one-spreadsheet-1o6a <p>If you invoice multiple clients, a simple cash tracker beats scattered notes.</p> <h2> What to track </h2> <ul> <li>Client name</li> <li>Invoice date / due date</li> <li>Amount</li> <li>Status (draft / sent / paid / overdue)</li> <li>Deposit vs balance</li> </ul> <h2> Minimal workflow </h2> <ol> <li>Log every quote and invoice the day you send it.</li> <li>Update status when paid.</li> <li>Review overdue weekly.</li> </ol> <h2> Free sample → weekly tracker → full cash tracker </h2> <p>Soft path (start free):</p> <ol> <li>Free sample — UK Weekly Money Tracker: <a href="https://payhip.com/b/MUAul" rel="noopener noreferrer">https://payhip.com/b/MUAul</a> </li> <li>UK Weekly Money Tracker (£2.50): <a href="https://payhip.com/b/62Xui" rel="noopener noreferrer">https://payhip.com/b/62Xui</a> </li> <li>Full Client Cash Tracker (£8): <a href="https://payhip.com/b/XcG0T" rel="noopener noreferrer">https://payhip.com/b/XcG0T</a> </li> </ol> <p>Related templates:</p> <ul> <li>Invoice &amp; Quote: <a href="https://payhip.com/b/TnXq8" rel="noopener noreferrer">https://payhip.com/b/TnXq8</a> </li> <li>Expense Tracker: <a href="https://payhip.com/b/GgKFs" rel="noopener noreferrer">https://payhip.com/b/GgKFs</a> </li> <li>Hub: <a href="https://sites.google.com/view/ukdigitaltemplatessheetsplanne" rel="noopener noreferrer">https://sites.google.com/view/ukdigitaltemplatessheetsplanne</a> </li> </ul> <p>Disclosure: I made and sell these templates. Not financial advice. Tracker/organisation tools only — not accounting or tax advice.</p> freelancing productivity spreadsheet google