I built this for myself so that I could better analyze my data. Unfortunately one must export one's data and import into Google Sheets, and so its static at the point.
I am afraid its a little basic and Google doesn't allow for the dynamic creation of charts from the pivot tables. I am, though, experimenting with some data validation options to achieve this.
I am sharing this in the hope that it is helpful to someone else but also in case others are able to enhance it (or use other apps) to create better reporting until Financier's options improve.
https://docs.google.com/spreadsheets/d/1vNHhaXPnH7WlDwqlBBNMyKDO7HlixlQ0BluqoOxsI9U/edit?usp=sharing
Excel Version (in progress)
https://1drv.ms/x/s!AkfQRJvEOOrG_TwH3cJ4ozHIhv16
Hi Billy
Looks like a lot of work went into this..... I will spend some time with this.
Ron
I've just discovered Google's Data Studio (free for individuals). I am going to see if I can build a report and share it where you can just add your own data source (the financier export)
Here it is - very beta and basic for now but I will keep adding functionality and reports. I think this is how you can get it working
1. Sign up for Google Data Studio (Free)
2. Open and make a copy of this report (below): Click Edit and then File > Make A Copy
https://datastudio.google.com/open/1f1gZJxd9sxnTNbetbzKB8e-FAXhHB10X
3. Export your data from Financier and extract the xxxxx - Register.csv file
4. Upload the report to Google Drive and Open with Google Sheets
5. In the Data Studio Report: File > Report Settings
6. Create a new data file
7. Select your financier export from Google Sheets
8. Adjust the data type of Inflow and outflow to Currency
9. Click Add to Report
10. Press View to access the report
I made some tweaks that I think look and work better
Data Studio Report: https://datastudio.google.com/open/1f1gZJxd9sxnTNbetbzKB8e-FAXhHB10X (https://datastudio.google.com/open/1f1gZJxd9sxnTNbetbzKB8e-FAXhHB10X)
That looks really awesome,
@Billy_McSkintos. :parrot:
Added the Income/Inflows report.
I have added an Income, Expenditure, Net report to my own version but this requires some manipulation of the metrics. If you would like this report you will have to build the additional calculated fields yourself. Let me know if you would like a guide.
Cool stuff.
Cool! Thanks for your work. I hope this can somehow be integrated into the main financier structure.
I'm afraid that is beyond my limited skills. I am happy to help anyone (
@Alex ?) with the knowledge to implement them or similar.
Hopefully, this will keep us going until then; I'm happy to help anyone with configuring or implementing their own report(s).
Any chance you could build a version where an exported Excel file just takes the pasted csv data in sheet two? I do not feel super comfortable uploading 2 years of financial history onto a google drive.
@uberdrops Does this work as a starting point?
https://1drv.ms/x/s!AkfQRJvEOOrG_TwH3cJ4ozHIhv16