I've been looking through the repository on GitHub and I for the life of me can't figure out where the SQL code is. How is the database created? What do the tables look like? I've never looked at a php codebase before, I'm quite lost. I'm guessing this is using some ORM provided by Laravel?
Firefly III: A free and open source personal finance manager
11–20 of 160 posts
Re: Firefly III: A free and open source personal finance manager
#12This looks like exactly the kind of thing I've been searching for! Curious about testimonials if anyone's used it
I self host it since Mint shutdown. It obviously doesnt have automatic integrations with financial institutions so you need to export/import manually or frankenstein your own automation. There are a lot of things it does that I dont use. I am mostly there for spending visualization. It does that well, but it takes a lot of clicks to setup categorization rules, but once its done things happen automatically. Its just a…
>It obviously doesnt have automatic integrations with financial institutions so you need to export/import manually
Ok, that's what I was scouring the documentation to find out. Thank you. Guess I'll stick with my current mint-alternative (Empower)
Re: Firefly III: A free and open source personal finance manager
#13I've been looking through the repository on GitHub and I for the life of me can't figure out where the SQL code is. How is the database created? What do the tables look like? I've never looked at a php codebase before, I'm quite lost. I'm guessing this is using some ORM provided by Laravel?
Creation is done by running migrations [1] (invoked via Laravel's artisan command line). Using the database is done via Models[2].
[1] https://github.com/firefly-iii/firefly-iii/tree/main/databas... [2] https://github.com/firefly-iii/firefly-iii/tree/main/app/Mod...
Re: Firefly III: A free and open source personal finance manager
#14is there a home-assistant addon for doing personal finance?
Re: Firefly III: A free and open source personal finance manager
#15I've been looking through the repository on GitHub and I for the life of me can't figure out where the SQL code is. How is the database created? What do the tables look like? I've never looked at a php codebase before, I'm quite lost. I'm guessing this is using some ORM provided by Laravel?
[deleted]
Re: Firefly III: A free and open source personal finance manager
#16I've been looking through the repository on GitHub and I for the life of me can't figure out where the SQL code is. How is the database created? What do the tables look like? I've never looked at a php codebase before, I'm quite lost. I'm guessing this is using some ORM provided by Laravel?
Not SQL, but check out the contents of the database folder. For example:
https://github.com/firefly-iii/firefly-iii/blob/main/databas...
Re: Firefly III: A free and open source personal finance manager
#17This vs hledger?
/asking for a friend who used msmoney back in the day
Re: Firefly III: A free and open source personal finance manager
#18How does it compare to YNAB?
I used it about a year but switched back to YNAB. I really like the budget in YNAB. Firefly concentrates more on the bookkeeping. Which for me is just secondary...
Re: Firefly III: A free and open source personal finance manager
#19My biggest gripe with my Firefly workflow is how difficult it is to automatically handle Amazon orders. I’ve setup rules to automatically organize/label the various types of transactions that I export from banks to CSVs, but having to break down Amazon orders is a tedious nightmare. If anyone has any ideas for how to automate this, please share. One idea is to have Puppeteer just open the order page and get the invoi…
For Amazon orders in GnuCash, I've been idly thinking about making a browser plugin that scrapes the Amazon order page, since that's less likely to be cut off than a standalone scraper is.
How I'm currently manually doing Amazon orders in GnuCash is I go to the register for account "Liabilities > Credit Cards > Chase-CC-1234", and add a transation with description, say, "2024-02-16 Amazon order 113-1234567890-987654 (bobs red mill, soy curls, yaktrax)", with a split for each item and for each payment method used (credit card, CC rewards, gift balance).
I keep the order date in the transaction description so that the GnuCash date can be the date that the CC is charged. If Amazon splits the shipment and does multiple CC charges (potentially on very different dates), so that GnuCash reflects those dates, I'm currently duplicating the transaction in GnuCash, and then editing the splits in the original and the duplicate to match the CC charges and what they're for. And each transaction description gets a "#1", "#2", etc. added after the Amazon order number.
One upside of the manual process is that the work is negative feedback for spending money. :)
Re: Firefly III: A free and open source personal finance manager
#20My biggest gripe with my Firefly workflow is how difficult it is to automatically handle Amazon orders. I’ve setup rules to automatically organize/label the various types of transactions that I export from banks to CSVs, but having to break down Amazon orders is a tedious nightmare. If anyone has any ideas for how to automate this, please share. One idea is to have Puppeteer just open the order page and get the invoi…
For Amazon orders in GnuCash, I've been idly thinking about making a browser plugin that scrapes the Amazon order page, since that's less likely to be cut off than a standalone scraper is. How I'm currently manually doing Amazon orders in GnuCash is I go to the register for account "Liabilities > Credit Cards > Chase-CC-1234", and add a transation with description, say, "2024-02-16 Amazon order 113-1234567890-987654…
For Amazon I sometimes have items grouped differently in the order overview on Amazon itself then in the credit card charge. That makes it quite tedious to actually find out what charge goes where.