Frappe Books Bank Statement Importer
Streamline your accounting workflow with this powerful Python GUI. Seamlessly import CSV files directly into your database.
A powerful Python GUI tool to seamlessly import bank statement files directly into your Frappe Books database.
Direct Database Access
Connects securely to your local Frappe Books SQLite database file to ensure data integrity.
Simple CSV/QIF/OFX Import
Parse and map your bank statement CSV/QIF/OFX files with an intuitive graphical interface.
Open Source Python
Built with Python. Fully transparent, customizable, and free to use.
Why use this importer?
Frappe Books is an excellent open-source accounting tool, but manually entering bank transactions or dealing with incompatible CSV formats can be difficult. This Python-based CSV importer solves the issue by allowing you to map columns visually and write directly to the SQLite database.
How to Run the App
Clone the Repository
Download the source code from GitHub to your local machine.
git clone https://github.com/tonydarcy/Frappe-Books-GUI-Bank-Statement-Importer.git
Install Dependencies
Ensure you have Python installed, then install the required libraries.
cd Frappe-Books-GUI-Bank-Statement-Importerpip install -r requirements.txt
Launch the GUI
Run the main script to open the application window. Select your database and CSV/QIF/OFX file to begin.
python main.py
Note: Always backup your Frappe Books database file before performing imports.
View full documentation on GitHub