Projected Checking Account Balance

[jmmedc]

I am new to Tiller as I am working to switch from Quicken. A feature I really liked Quicken is that you can enter upcoming bills, paychecks or other income and Quicken will provide a projected balance. Is there any worksheet available that I can incorporate to my excel foundation sheet that can help me replicate this quicken feature? Thank you all in advance!

[martha.rudkin]

I use Google Sheets, so I don’t have a specific answer for you unfortunately.

Manual Transactions that are future dated (credit card payments, bill payments, paycheck deposits, etc) can be easily entered.

If you use the search bar (top right corner) here in the community, you may find some Excel related topics that might help you out.

Here is one that you might want to look at:

Account Register - Excel

Overview A community member asked if there was anything like a “Checkbook Register” that not only includes the date, description and amount of a transaction, but a running balance so you can see what remains in your account. A few others have asked for similar functionality, and I thought the code required is similar to a few templates I’ve already released or are in the works, so I was able to throw this together pretty quickly. [Screenshot 2022-10-26 184153] Installation Getting a reliab…

[jmmedc]

Thank you, I will try it out.

[Clint.C]

Juan,

You might want to look at this Excel community solution too.

Expense Forecasting and seeing upcoming expenses on a Calendar - UPDATED 4/15/24

Overview Write a brief description of what the template does. This template takes a list of recurring bills/expenses, and generates a list of upcoming dates for those expenses. This template also provides an example of using the generated list of expenses to display the expenses on a calendar. UPDATED 4/15/24 - I added a way to override individual projected expense payments, so you can modify the date or amount. This is helpful for bills that fluctuate wildly month to month, like utility bi…