~mcotdev/budgetFlow - Creates a simple cash flow forecast - sourcehut git

2 min read Original article ↗

This Python application helps you forecast your finances over a specified number of months.

It takes your current balance, desired forecast length, and a balance threshold as input. Then, it generates a forecast based on your expected transactions (which are likely stored in a separate data source - this example does not include the transaction input). Finally, it displays the forecast in a formatted table and generates a plot of your balance over time. The tool also highlights any months where your balance falls below the specified threshold.

#Features

  • Interactive Input: Prompts you to enter your current balance, desired forecast duration (in months), and a balance threshold for warnings.
  • Database Storage: Utilizes SQLite to store and manage forecast data.
  • Formatted Output: Displays the forecast results in a clear and organized table using Rich library.
  • Balance Warnings: Alerts you to any months where your projected balance falls below the specified threshold.
  • Graphical Visualization: Generates a plot of your projected balance over time.

#Prerequisites

  • Python 3.x: This application is written in Python 3. Ensure you have a compatible version installed.
  • Libraries: The following libraries are required:
    • sqlite3
    • rich
    • matplotlib
    • pandas

You can install these libraries using pip:

pip install sqlite3 rich matplotlib pandas

How to Use

    Clone the Repository:

    git clone <repository_url>

    Run the Script:

    python3 app.py 

    Follow the Prompts: Enter your current balance, desired forecast duration, and balance threshold.

Disclaimer:

The accuracy of the forecast depends on the accuracy of your input data and the assumptions used in the process_forecast function.

Contributing:

Contributions are welcome! If you have any suggestions or improvements, feel free to open an issue or submit a pull request.