Hi @nextlaunch: Welcome to the Tiller Community.
Many options here, and there are many in the community who may see a better way than I, but the simplest one I see is to create a tag for each client, and flag both income and expense transactions with the tags associated with the clients.
Splitting whole costs among the tags is also available to allocate costs as you wish. Simply select the same category, such as “Advertising” for all splits and add tags to the splits after splitting, assigning a client share to each.
On the budget side, I don’t see an easy way to create client-specific budgets that compare to client-specific transactions. In this scenario, these would be need to remain aggregated among clients; however, instead of static numbers on the Categories sheet, you could copy the Categories sheet and name the copy something else associated with your client, one copy for each client. Call these “Subsheets.” (Be sure not to change the name of the original Categories sheet!) Then use a sum formula in the original Categories sheet’s cells to call and aggregate the budgets across the various client budget subsheets with the sums for each month, each category. Again, Tiller still will only be able to see the aggregate activity against the aggregate budgets, but it provides a quick rationale for your aggregate numbers.
The one drawback is I don’t see an automated way to prepare cost-to-budget comparisons for each client. If you’re focused simply on cash-flow for each client and you’re using tags for each, the Tags report will help with that.
The Tags Report will group and summarize cash flow components by tag for you. You can see it here.
…and the Small Business Dashboard will give you a bird’s eye view across clients. Take a look:
Does that help? Its the best thing I can see to adapt a personal software tool for a business like yours.
No matter your solution, it is 135 times better to have your transactions pouring into your sheets automatically every day!
All the best with your business adventure! So cool. I’m jealous already.
Brad.