Skip to content

Releases: Ronaf-git/python-BankFile_Analysis

v0.1 - BankFile_Analysis

07 Nov 16:37
@Ronaf-git Ronaf-git
v0.1
f8c66cf

Choose a tag to compare

View all tags
v0.1 - BankFile_Analysis Latest
Latest

BankFile Analysis v0.1 - First Release 🎉

Welcome to the BankFile Analysis v0.1! This release provides a set of tools to help you categorize and analyze your bank transactions using predefined categories and customizable configurations.

🔧 Getting Started

Follow these steps to set up and configure the analysis pack:

1. Extract the Files

  • Step 1: Extract the contents of the BankFile_Analysis_Pack_v0.1.rar file into a dedicated folder. This will create the necessary subfolders and configuration files required for the analysis.

2. Add Your BankFile

  • Step 2: Place your BankFile (in CSV format) into the designated Source folder.
    • Important: Ensure the BankFile is in the correct format, as there is no check to validate whether the file fits the parser.
    • Note: If you’re using a sample file from the release, delete it after adding your own BankFile to avoid confusion.

3. Adjust Categories (Configuration)

You can modify and customize the categories used for the analysis by editing the provided CSV configuration files in the Resources folder. There are three main configuration files you need to review and adjust:

A) CategoriesDefinition.csv

This file contains a list of predefined categories and their unique IDs used for categorizing transactions.

  • Category 3: Investments must remain unchanged to ensure that the graph displaying investment data works correctly.
  • You can add new categories, but they must follow the structure and format shown in the file.

Fields to adjust:

  • IsExp: Set this to 1 if the category is related to an expense.
  • Cat_20_30_50: Use this field for 50/30/20 budgeting. For income, set it to 100%.
  • AssetType: If investments, specify the type of asset under this field.

B) WildcardsCategory.csv

This file defines patterns (wildcards) for words found in the details of your BankFile. When a matching pattern is detected, it will automatically link the transaction to the appropriate category as set up in CategoriesDefinition.csv.

  • Important: You need to provide an existing ID from CategoriesDefinition.csv in this file to connect patterns to a category.

C) AbsoluteCategory.csv

This file allows you to specify exact transactions based on their unique PK_Hash (found in your exported CSV dataset). Transactions listed here will take precedence over those categorized using WildcardsCategory.csv.

  • Use this file for highly specific or one-off transactions that should always be categorized in a particular way.

4. Save and Verify Your Changes

After updating the category files:

  1. Ensure you save all changes in the CSV files.
  2. Double-check that your categories, patterns, and absolute transaction mappings are correctly defined before running the analysis.

🚀 Next Steps

Once you've added your BankFile and adjusted the category configurations, you can proceed with running the executable to analyze your bank transactions.

📝 Important Notes

  • Data Format: Ensure that your BankFile follows the correct format and contains all required fields (as expected by the parser).

Thank you for using BankFile Analysis Pack v0.1! We hope this tool helps you categorize and analyze your bank transactions easily.

Assets 3
Loading