Skip to content
antoine-pirogPublic

About

A CLI app to manage one's finances. Parses bank statements, stores transactions in a database, and provides SQL-syntax requests to monitor expenses and revenues. Currently compatible with French bank LaBanquePostale

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

46 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

pyBanking

Let's pretend this is all under control.

Usage

Load new bank statements into DB

> python -m pyBanking.main -f <glob pattern>

Auto-categorize transactions

> python -m pyBanking.main --update-uncategorized

Examples

See "Commands" section below for command reference

Search uncategorized revenues after 2026 : show where date>2026/01/01 and amount>0 and subcategory=601

Commands

> help
Documented commands (type help <topic>):
========================================
edit  exit  help  list  search  show  sql

list command

> help list
Prints list of elements
| Supported commands :
| - list categories

show command

> help show
Shows list of expenses
| Supported commands :
| - show all
| - show uncategorized
| - show date after <dd-mm-yyyy>
|   > ex. : show date after 01-01-2024
| - show date before <dd-mm-yyyy>
|   > ex. : show date before 01-01-2024
| - show date between <dd-mm-yyyy:dd-mm-yyyy>
|   > ex. : show date afte between 01-01-2024:31-12-2025
| - show month <mm-yyyy>
| - show year <yyyy>
| - show where <sql filter>
|   > ex. : show where amount < -1000
|   > columns in db are :
|     - date (str)
|     - label (str)
|     - amount (float)
|     - category (int)
|     - subcategory (int)
|     - ignore (int)
| - show buffered
| - show <transaction_id>

Examples

show date between 01-01-2017:31-12-2017 - sample of transaction list (mock data)

list of transactions

show date between 01-01-2017:31-12-2017 - sample of expenses categorized by label (mock data)

transactions categorized by label stacked bar graph of transactions categorized by label

show date between 01-01-2017:31-12-2017 - sample of expenses categorized by category/subcategory (mock data)

expenses by gategory expenses by category (bar graph)

show date between 01-01-2017:31-12-2017 - sample of revenues categorized by category/subcategory (mock data)

revenues by gategory revenues by category (bar graph)

show date between 01-01-2017:31-12-2017 - monthly net (mock data)

monthly net summary

search command

> help search
Searches transaction entries labels for a string
| Syntax : search <pattern to search>
| > ex. : search sushi bar

edit command

> help edit
Edits a database entry
| Syntax : edit <db entry id>
| > ex. : edit 1801

edit 2536 - (mock data)

editing an entry

sql command

> help sql
Executes a SQL request on the database

exit command

> help exit
Exits the program

About

A CLI app to manage one's finances. Parses bank statements, stores transactions in a database, and provides SQL-syntax requests to monitor expenses and revenues. Currently compatible with French bank LaBanquePostale

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages