Use this template

👋 Psst... you can Preview any Landmark template as a guest with the 'Preview' button below.
All blocks
>
Daily Cash Flow Template (30-Day Forecaster)

Daily Cash Flow Template (30-Day Forecaster)

In a bit of a cash squeeze? Get a daily breakdown of cash in bank, revenue and expenses with this Google Sheets cash flow forecaster template.

Models For This Step

When you get into this freelancing/solopreneurship/creator economy game, thinking 12 months ahead, financially, isn’t often a luxury at hand.

Instead, research tells us that 63% of freelancers describe themselves as ‘financially unstable’. This isn’t just from unpredictable income sources, unexpected cancellations and varying demand; one contributing factor of the instability is simply a level of clarity on one’s financial situation.

When I was freelancing, this was one of my big weaknesses and fears. At times, it felt like I almost didn’t want to know my real financial position: bad idea.

Eventually, I got around to facing the music, tallying up my various subscriptions, putting a date on incoming invoices, putting a date on expected bills, and generally figuring out if I could ‘make it’ this month.

As it turned out, I didn’t have much use for the generic ‘12-month cashflow forecast’ templates you find around (these are of course helpful, but when your time horizon is next month’s rent check, it’s a bit fanciful to get out the 12-month savings targets...).

So instead, I just plotted it day by day.

  • What cash in bank do I have today?
  • What expenses do I know to be coming in the next 30 days? (On which days, specifically)
  • What revenue or invoices do I expect to be coming in the next 30 days? (On which days, specifically)

That was all I needed to ask. And so I built this little tool that has done the job ever since.

How to use the template

First thing's first:

  1. Hit the 'Use it' button on the left (or if you're already logged in, hit 'Your template');
  2. Then hit 'Make a copy' from the File menu in the top left corner;
  3. And you're all set.

Once you've added the template to your own account, there are two ways you can use it;

  1. Manual mode;
  2. Fancy mode.

1. Manual mode

By manual mode, I just mean you’ll override the formulas in the Google Sheet provided and wing it for yourself.

That means taking Day 0 as wherever you are today, then inputting values for yourself. If, for example, you know you'll get paid in 10 days, you can just 'manually' input that value on Day 10. The same for all expenses.

It's a bit tedious, but if you just want a quick 'calculator', you can use this template in manual mode.

This is how I originally used the template for myself. The charts update just fine to give a visual overview, and I just updated the values as a ‘calculator’ to help me get a sense of my position.

Warning: As soon as you input a value in the template manually, you'll remove the formula for that specific cell. I'd recommend making another copy of the template for manual use, then keeping the full template, with all formulas in place, if you might ever want to use the 'Fancy mode'.

(Then again, if you ever break the formula and want to start fresh, I suppose you can always just come back here and make another copy :) )

2. Fancy mode

Fancy mode means making use of the other 4 sheets. They are:

  • Revenue items;
  • Revenue for the upcoming 30 days;
  • Expense items;
  • Expenses for the upcoming 30 days.

The Revenue sheet lets you list all of your revenue sources as items with an amount, Due Date, Status, Owner and some other bits and bobs. The main things to focus on are the value and date.

Then we have a pivot table, which is just a filtered version of the Revenue sheet mentioned above. What this will do is take all of your revenue items scheduled within the next 30 days.

How does it do that? Magic. But also, by pulling info from the ‘due date’ property in your Revenue sheet.

The takeaway? If you want this to work, make sure you input a date for each revenue item.

The Expenses sheet follows basically the same logic as Revenue.

Make sure you input a value and a date. That’s it.

And yep, there’s also a pivot table for the Expenses, filtering the upcoming 30 days of expenses.

By default, the template linked will be in ‘fancy mode’. All that means is the values for Expenses and Income will be pulling information from the Pivot Table sheets. That way, all you need to do is input your Revenue and Expenses items on their respective pages, and these values will update automatically.

Neat.

Give it a spin for yourself, and if you have any questions, send me a message at gerrard@landmarklabs.co

clarity os

Your whole business in one place.

This template is part of our integrated solo business workspace: Clarity OS.

No more flipping between tabs, repeating entries and losing track of how it all fits together--keep your business in one place with Clarity.

Learn more about Clarity OS
🎉  Block added
Oops! Something went wrong while trying to save this block.
👋 To save this block to your dashboard, you'll need a member dashboard first. You can create yours here, free.

(If you already have an account, you might not be logged in: you can log-in here to save this block to your dashboard)
Oops! Something went wrong while trying to save this block.
Next block in this ability stack →

Related articles

No items found.
Privacy Policy