A Cash Flow Tracker for Freelancers: A Simple Weekly Workflow
Share
A client has paid, a software subscription has left your bank account, and you have moved money into a cash box. At the end of a freelance week, those events can blur together. A cash flow tracker for freelancers gives you a place to record each event and review what changed.
This walkthrough uses fictional USD amounts and manual entries. It follows recorded operating cash, rather than unpaid invoices or a forecast.
Start with the cash that moved
For this exercise, enter a client receipt when the payment arrives. An invoice you sent but have not been paid is a different record. The Australian government's cash and accrual guide explains that timing distinction. Here, it describes the exercise's scope; it does not recommend an accounting or tax method for a US business.
Choose your reporting dates and register each tracked account with a unique name. Its opening balance should describe the position immediately before the first activity you enter. Keep one currency throughout the workspace.
Follow one small week
Start with Bank at $1,000 and Cash at $100. Assume this example has no collected tax or transfer fee.
- Client receipt: enter a $1,200 payment into Bank as Income, with its date and a category such as Client services.
- Software payment: enter an $80 payment from Bank as Expense.
- Internal transfer: enter $200 from Bank to Cash once in Transfers.
The operating summary is $1,200 received, $80 paid and a $1,120 cash surplus. After the transfer, Bank holds $1,920 and Cash holds $300. Together they hold $2,220: the $1,100 opening total plus the $1,120 surplus.
The $200 movement changes where the money sits. It adds nothing to operating income or expense. Intuit's transfer guidance similarly describes recording one internal transfer that affects both accounts.
Review the entries before the totals
Check dates, amounts, account names and row statuses against your own source documents. In Cash Flow Toolkit, an unregistered transfer destination such as Unknown produces Needs review and excludes the whole transfer until corrected.
A zero warning count means the entered data passed the tool's checks. It does not establish that every real receipt or payment has been entered. This remains a manual review, without a bank connection or automatic reconciliation.
Choose a workspace and save it deliberately
Cash Flow Toolkit includes an English XLSX cashbook and an offline browser app. The workbook adds monthly budget and period-comparison views. The app provides a focused ledger, transfers, tracked account balances and a monthly chart.
The two keep separate data, with no XLSX import or sync. The app accepts compatible USD JSON only; export and complete the download before closing, then import that copy to continue. For the workbook, save a working copy and preserve its formulas.
An optional Agent Skill uses the included local engine with Node.js 22.14+ and a compatible, authorized host. MCP needs separate setup and dependencies. Neither route adds automatic bank records. Cash surplus is not accounting profit; tax calculation, loans, owner funding and refund workflows are outside this version.
See the Cash Flow Toolkit files, fixed capacities and checked software scope before choosing your workflow.