Printable checklist

How to Build a Simple Cash Flow Sheet

The usual problem with uild a Simple Cash Flow Sheet is not the hard part, it is the setup people skip. This illustrated guide covers 3 methods and 34 steps, with a separate picture for every single step.

By Co-authored by HowCompass Editorial Team · 34 steps · Money & Finance · Updated November 17, 2026

Back to the guide
  1. 1. Choose the simplest option for a monthly total

    Put anything fragile to one side before the main work on your cash flow begins. A calm first pass sets the tone for the whole session with your cash flow.

  2. 2. Make a backup copy of the on screen menu

    Check the condition of your tools now, while fixing a problem with your cash flow is still easy. Note the starting condition so you can tell whether the change to your cash flow actually helped.

  3. 3. Move the older entries out of bank statements

    Small repeated movements give a far more even result on your cash flow than one big push. If the material reacts differently today, adjust the pace rather than the whole plan for your cash flow.

  4. 4. Follow the same order every time with a monthly total

    If resistance suddenly increases, stop and look rather than forcing your cash flow. A light touch first is safer, because extra pressure is easy to add to your cash flow.

  5. 5. Apply the same rule across a spreadsheet

    Keep the working area tidy between passes so nothing gets knocked into your cash flow. Leave a little margin for a correction at the end instead of using everything on your cash flow now.

  6. 6. Pause and reread bank statements halfway

    Keep the same hand position from one pass to the next so the result with your cash flow stays consistent. Keep your eyes on the part you are working on, not the finished idea of your cash flow.

  7. 7. Work through a monthly total in short sessions

    If resistance suddenly increases, stop and look rather than forcing your cash flow. Take a breath between passes so your hands stay steady on your cash flow.

  8. 8. Change one setting in bank statements at a time

    Small repeated movements give a far more even result on your cash flow than one big push. Check the clock rather than guessing; timing is the usual hidden variable in your cash flow.

  9. 9. Replace a vague note in a monthly total with a specific one

    If resistance suddenly increases, stop and look rather than forcing your cash flow. Move slowly through corners and edges, which is where work on your cash flow usually goes wrong.

  10. 10. Test a folder for statements once more before moving on

    Compare against the goal you wrote down rather than against a vague ideal of your cash flow. Ask what a beginner would misread here, then simplify that part of your cash flow.

  11. 11. Note the one thing you would change about bank statements

    Leave everything ready for a second pass, even if your cash flow turned out well this time. Lay out everything before starting so you are not searching mid-step.

  12. 12. Close the extra tabs around a monthly total

    Clean the tools before anything dries on them, or the next session with your cash flow starts badly. Store it somewhere you will actually find it, not somewhere merely tidy for your cash flow.

  13. 13. File bank statements where you will find it

    Close the loop with a quick check that nothing has been left out of your cash flow. Keep one small spare part with the finished your cash flow to save a future trip. Keep going: [How to Save Money on…

  14. 14. Clear anything outdated from a monthly total

    A clear starting surface is the cheapest way to avoid a mistake later with your cash flow. Note the starting condition so you can tell whether the change to your cash flow actually helped.

  15. 15. Read the guidance for a spreadsheet once

    A calm first pass sets the tone for the whole session with your cash flow. A quick dry run with no material shows you where your hands will need to go for your cash flow.

  16. 16. Gather the details about a notebook

    Write the order down once so you are not deciding and doing at the same time with your cash flow. If something looks different from the picture, adjust the setup before touching your cash flow.

  17. 17. Set a reminder alongside bank statements

    Watch what happens for a few seconds before repeating, since the result with your cash flow changes gradually. A light touch first is safer, because extra pressure is easy to add to your cash flow.

  18. 18. Keep a written record of a monthly total

    Move slowly through corners and edges, which is where work on your cash flow usually goes wrong. Watch what happens for a few seconds before repeating, since the result with your cash flow changes gradually.

  19. 19. Group related items within bank statements

    Work at the pace you can repeat, not the pace you can manage once with your cash flow. Keep the same hand position from one pass to the next so the result with your cash flow stays consistent.

  20. 20. Keep the wording of a monthly total short

    Leave a little margin for a correction at the end instead of using everything on your cash flow now. Move slowly through corners and edges, which is where work on your cash flow usually goes wrong.

  21. 21. Save your progress on bank statements after each change

    Keep the same hand position from one pass to the next so the result with your cash flow stays consistent. Move slowly through corners and edges, which is where work on your cash flow usually goes wrong.

  22. 22. Change one setting in the cash flow overview at a time

    Move slowly through corners and edges, which is where work on your cash flow usually goes wrong. A light touch first is safer, because extra pressure is easy to add to your cash flow.

  23. 23. Look for one inconsistent entry in a monthly total

    If two checks disagree, trust the slower one when working on your cash flow. Ask what a beginner would misread here, then simplify that part of your cash flow.

  24. 24. Verify the date on bank statements

    Ask what a beginner would misread here, then simplify that part of your cash flow. Give it a moment to settle, since the first impression of your cash flow often changes.

  25. 25. Plan the next pass at a monthly total

    Close the loop with a quick check that nothing has been left out of your cash flow. Note the date so you can tell how long the result with your cash flow really lasted. Keep going: [How to Start a Side Hustle](/how-to-start-a-side-hustle)…

  26. 26. Set aside a quiet ten minutes for a spreadsheet

    Begin with less than you think you need; you can always add more to your cash flow. Work at a comfortable height, because leaning over your cash flow makes every movement less precise.

  27. 27. Open the relevant screen for bank statements

    Keep the instructions in sight, because the first attempt at your cash flow is mostly about sequence. Give yourself a defined stopping point before you begin on your cash flow.

  28. 28. Pause and reread a short written note halfway

    Watch what happens for a few seconds before repeating, since the result with your cash flow changes gradually. A light touch first is safer, because extra pressure is easy to add to your cash flow.

  29. 29. Keep a written record of bank statements

    Check the clock rather than guessing; timing is the usual hidden variable in your cash flow. Take a breath between passes so your hands stay steady on your cash flow.

  30. 30. Keep a written record of a calculator

    Move slowly through corners and edges, which is where work on your cash flow usually goes wrong. Take a breath between passes so your hands stay steady on your cash flow.

  31. 31. Pause and reread a monthly total halfway

    If the material reacts differently today, adjust the pace rather than the whole plan for your cash flow. Change one thing at a time, otherwise you will not know what fixed your cash flow.

  32. 32. Compare two versions of a monthly total

    If everything looks fine, still check the parts you cannot easily see on your cash flow. Stop checking once the result is good enough; overworking your cash flow is its own mistake.

  33. 33. Compare bank statements with your starting note

    Make a note of what you would change next time before you forget the details of your cash flow. One honest check now replaces three rushed corrections to your cash flow later.

  34. 34. Keep a short summary of a spreadsheet

    Note the date so you can tell how long the result with your cash flow really lasted. Decide now when you will revisit it; otherwise the habit around your cash flow quietly slips off the list. Keep going: [How to Make a…