ma4nn / moneymoney-sum-by-bank

Python script for the great MoneyMoney app to generate a list with total balance by bank account.

MoneyMoney Extension: Sum by Bank

This is a Python script for the great MoneyMoney software to generate a list with all balances by bank account.
This is useful e.g. to export the total values per bank to a summary Excel document or to monitor certain threshold values per bank.

Installation

This script requires at least Python 3.10.

pip install -r requirements.txt

Create service menu entry (optional)

On Mac if you (optionally) want to use this Python script within the services menu of the MoneyMoney application, the best way is to use the Mac Automator:

1. Create a new "Quick Action Workflow" in Automator
2. Choose "No Input" in "MoneyMoney"
3. Add the action "Execute AppleScript" and paste this script into the text box and adapt the script path accordingly:

   on run {input, parameters}
       tell application "Terminal"
           do script "python3 ~/path/to/script/moneymoney_sum_by_bank.py && read -s -n 1 key && exit 0"
       end tell
       
       return input
   end run

4. Save the workflow

Then you have a new menu item with the chosen name in MoneyMoney > Services.

Usage 💡

python3 moneymoney_sum_by_bank.py

Note: The MoneyMoney application has to be unlocked when executing the script otherwise an error will be thrown.

This Python script sums all account balances from MoneyMoney by the bank code of the BIC (first 4 digits).
If a BIC is not available (e.g. in case of an offline or a credit card account), the script looks for a custom attribute bankIdentifier in the account settings and uses this as reference.
If neither of this information is available on the account and it has a balance, the value is added to "other".

The result of the Python script can e.g. be used in Excel:

For more information see also my blog post.

License

moneymoney-sum-by-bank's Issues

Option to Export to fixed file in a specific Worksheet?

Hi Christoph!

Could you point me towards a solution where the data is not written to a new file but an existing file?
I have a self-made Budget and Forecast for my Financials in Excel and it would be great to get the actuals automatically.
Currently I manually type them into my Excel file from MoneyMoney.
Your script seems to be perfect with just this little change.

Many thanks!