CSV Transaction History Detective
Project description
CSV Transaction History Detective
Getting started
- Install
csvthd
- Create your
config.json
file (seeconfig.json.template.md
for a template) - See usage
Installation
pip install csvthd
Usage
Show help
csvthd --help
Filter
Transaction details
-i/--include
Only show transactions that include all of the specified strings in their details
- Case insensitive
- Multiple strings supported (each transaction's details must include all of the strings specified)
# only show transactions with details including the word "paypal"
csvthd -i paypal
# only show transactions with details including "paypal" and "steam"
csvthd -i paypal -i steam
-E/--exclude
Only show transactions that don't include any of the specified strings in their details
- Case insensitive
- Multiple strings supported (each transaction's details mustn't include any of the strings specified)
# only show transactions without details containing the word "paypal"
csvthd -E paypal
# only show transactions without details containing "paypal" or "chemist warehouse"
csvthd -E paypal -E "chemist warehouse"
# only show transactions with details containing "paypal", but not "steam"
csvthd -i paypal -E steam
Amount
-a/--amount
Only show transactions with amounts under/over/equal to a given value
- Multiple numbers supported (each transaction amount must satisfy all conditions specified)
# only show transactions over $20.00
csvthd -a over 20
# only show transactions under $10.00
csvthd -a under 10
# only show transactions between $20.00 to $30.00
csvthd -a over 20 -a under 30
# only show transactions of exactly $25.00
csvthd -a equal 25
Type
-t/--transaction-type
Only show transactions where money is sent/received
# only show transactions where money is sent
csvthd -t out
# only show transactions where money is received
csvthd -t in
# only show transactions with details containing "paypal" where money received
csvthd -i paypal -t in
# get the sum of all money received with "paypal" in details but not "return"
csvthd -i paypal -t in -E return -S
Sorting
Sort by
-s/--sort-by
# list transactions from latest to oldest (default)
csvthd -s date
# list transactions from lowest to highest
csvthd -s amount
Reverse sorting order
-r/--reverse-sort
# list latest transactions first
csvthd
# list oldest transactions first
csvthd -r
# list smallest transactions first
csvthd -s amount
# list largest transactions first
csvthd -s amount -r
Reports
Sum amount
-S/--sum
Show the sum of the transaction amounts (after filtering)
# print the sum of all transactions
csvthd -S
# get the sum of transactions with "paypal" in their details
csvthd -S -i paypal
Development
Build
./development-scripts/build.sh
Links
- 📖 Documentation
- 🐍 Latest Release
- 🧰 Source Code
- 🐞 Issue Tracker
🐦 Twitter
@DrTexx📨 Email
denver.opensource@tutanota.com
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
csvthd-0.3.0b0.tar.gz
(6.2 kB
view hashes)