Can Tiller be used to help maintain positive checking account balances? Tiller seems to be really good at helping aggregate all the complexities of lots of accounts into one headline system, to help with analysis and budgeting and to plan for expenditure over time. Tiller helps with cashflow and bu…

I found this post which asks a similar question

I found this sheet which seems to do something conceptually similar but runs off it’s own numbers rather than your budget numbers from your Categories sheet

Something similar is being requested here

@soitmake this is a good question. The projected balances sheet you found below is the closest thing available as of now.

Thanks for writing in @soitmake Presuming you’re paying off those credit card balances each month, would it help to create a cash remaining calculation on your balances or net worth sheet, or elsewhere in your spreadsheet. It could look something like this: Primary checking account balance: $3,25…

@soitmake , I’m currently working on a solution in Google Sheets that might be interesting to you, but it’s pretty involved and not quite ready for release just yet. My solution takes a list of recurring multi-grain expenses and plots them against a series of paychecks (past, present, or future), to…

Thanks @Email2RuleThemAll Reading your reply I can see that there are two goals embedded in my question. One is to ensure I have enough current account balance for anticipated expenses, including credit cards, which is useful to avoid cash crunches and potential fees etc. The other is to project cu…

@peter thanks for the suggestion. I did make something like this but I quickly realized the shortcomings. Credit card statements are staggered so that you pay off the balance you accrued one month prior. So the current balance is no good for projecting the upcoming payment, you would have to go back…

@soitmake : The solution that I posted is really like 5 solutions in one. But the great part about it is that each component is pretty modular, and can be used independently. I’m currently in the process of posting them all as separate solutions. You might not be able to use the Paycheck report, but …

Project & plan checking balances over the year?

Conversation Ask Anything

morgan June 7, 2023, 7:51pm 8

, @soitmake

Did any of these suggestions help? If so, please mark one as the solution.

Filter from 2 tables (Account filter)

Topic		Replies	Views
Docs: Projected Balances sheet gSheets Templates google-sheets , tracking , tcs-projected-bal , tcs-gallery	10	7140	March 7, 2020
Projecting Upcoming Credit Card Payments Ask Anything	28	2752	April 5, 2024
:trophy: Generated Recurring Expenses Workflow gSheets Templates	24	3470	April 10, 2024
Near-term Account Balance Forecast gSheets Templates cash-flow , showtell-votes	38	2284	October 8, 2025
Recurring Expenses Dashboard (Tracks Bill Due Date, Automatic Paid/Not Paid status, Actual Spent for time frame, Projected Balances reporting and more!) gSheets Templates builder-challenge , tracking	10	4008	June 14, 2022

Project & plan checking balances over the year?

Related topics