Key takeaways
- Every hour is logged, billed or not.
- Invoices derive due dates from client terms.
- Each payment carries a tax set-aside.
- Every project reads On target, Slipping or Underpriced.
Halcyon Creative Studio is one designer in Ann Arbor with five clients. In August she quoted a bakery brand package at a fixed fee, gave away a fourth revision round, and invoiced a credit union for time while five more hours sat unbilled. Card and Venmo fees came off two payments, and the estimated tax payment due September 15 depends on money she meant to move and did not. FreelanceDesk US records the hour, the invoice and the set-aside once.
Every hour against a project
Each time entry records the project, the task, the hours and whether they are billable. The rate comes from the client's default rate, and the amount is derived only for billable hours on an hourly project.
Hours on a fixed-fee project and hours you chose not to bill are still logged, because they are exactly what the effective hourly rate needs to be honest about what a project paid.
Invoices built from the records
An invoice sums the time entries and billable expenses tagged with its ID, adds any fixed fee billed, and takes its due date from the client's payment terms rather than from memory.
Payments are recorded against the invoice with their processing fee, so each invoice reads Paid, Partial or Unpaid, shows its balance, and counts days late once the due date passes.
Tax money set aside per payment
Every payment received gets a set-aside row with the percentage you have chosen, applied to the net received after card or app fees, and tagged to the estimated payment date it covers.
Marking each row transferred when the money moves to a separate account leaves the dashboard showing exactly how much tax money is still sitting in the operating account before the deadline.
The rate you actually earned
The project summary divides fees invoiced plus unbilled time by every hour logged, billable or not, and compares the result with the client's default rate to label the project On target, Slipping or Underpriced.
A fixed-fee brand package that ran six hours over and a free revision round both show up as Underpriced, which is the evidence for the next quote, not a feeling about a difficult client.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
FreelanceDesk US Private Google Sheets Web App is designed for use with a Google account, Google Sheets, and Apps Script, using owner-only deployment by default.
No tax filing, tax advice or estimated payment calculation from income brackets, no online invoice delivery or card processing, no timers or calendar sync, no contracts or proposals, and no payroll or subcontractor 1099 filing.

