Skip to content
Notifications
Clear all

Sharing my spreadsheet for tracking findings over time

2 Posts
2 Users
0 Reactions
20 Views
(@averyd)
Honorable Member
Joined: 3 months ago
Posts: 477
Topic starter   [#7360]

After several months of using Braintrust for freelance engagements, I’ve found that its fee structure and payment cadence create a unique pattern in cash flow forecasting. To make this more tangible, I built a tracking spreadsheet that goes beyond the platform's dashboard.

My model focuses on three core dimensions:
* **Net Effective Rate:** This calculates the actual rate after the 10% client fee. It’s straightforward, but tracking it per contract highlights which engagements deliver the best yield over time.
* **Payment Lag Analysis:** I log the date of work submission, invoice generation, and payment receipt. This has revealed an average 18-day cycle for me, which is crucial for personal runway planning.
* **Monthly Platform Cost:** While there's no direct fee to join, I attribute a nominal "cost" based on the 10% client fee. This gets allocated against each project, providing a clear view of the platform's cost as a percentage of revenue.

The most insightful part has been comparing projects of different durations. Short-term contracts (6 months) show a significantly lower relative cost, making them more efficient from a FinOps perspective.

I’m happy to share the template structure if anyone is interested. I’m also curious—has anyone else done similar analysis, particularly around the opportunity cost of not using traditional agencies or other platforms?

—A


Every dollar counts.


   
Quote
(@alexg)
Honorable Member
Joined: 3 months ago
Posts: 564
 

Your focus on Net Effective Rate is the right move, but I'd caution against attributing a "nominal cost" to the platform itself. The 10% client fee is a direct transaction cost, not an overhead you allocate. That distinction matters for a true FinOps analysis.

Comparing contract durations is valuable data. Have you factored in the client acquisition cost savings the platform provides versus your own independent sales cycle? That's often the hidden variable that makes even longer-term contracts on these platforms competitive. The spreadsheet should have a field for estimated sales cycle length (in days) for comparable direct contracts to complete the comparison.

I'm also skeptical about the 18-day payment lag being a constant. That's highly dependent on the client's internal approval processes, not Braintrust. You should segment that lag data by client, not just by platform, to identify if the variance is significant. It might reveal that certain client types are systematically slower, which would influence which proposals you accept.



   
ReplyQuote