Expense / Spendings / or wkwkwk

Continuing our discussion abt money in my previous post, i just want to share how to manage money by making an app for knowing our expenses. I share this not because im an expert , share this because this is good even it is simple  :)

The idea to makin this app is comin after i have an interest to start managing my money. Beside that , according to many sources there are a lot formula for money manager. But whatever and however it is expense data in a one month then in a one year is an important one. So, lets make an app for this.

-Steps : 

1. Open your googlesheet, and make a datebase for this 

2. Put some column : kode, tanggal, bulan, pengeluaran , keterangan, total, total dalam satu bulan ( In english code,date, month, expense, description, total, total in a month )

3. Connect this sheet to apheet by click extension then appsheet

4. Open the app sheet and click data button 

5. Set key and label in code

6. Edit the type data cause all ur data in googlesheet will set in text type automatically 

Code still the same, set data with text, Tanggal set data type with date, Bulan set data with enum then put some value details ( September, October,etc),  Pengeluaran set data type with price, Keterangan still the same, set data with text, Total set data type with price, Total in a month set data with price too.

7. Dont forget to set the currency for pengeluaran, total, and total in a month 

8. Makin formula 

Makin a formula for Total  =sum(list[Pengeluaran] 

Makin a formula for Total in a month , e.g September  =sum(select(Data[Pengeluaran],[Bulan]="September"))

9. and then voila , ur app already created.

10. Test drive 

11. This app can be seen in mobile phone too by downloading appsheet and sync with gmail account, and this one its a view from mobile phone 

Actually there are a lot of money manager app that u can download in apstore or play store, but by makin this i hope u can have a trigger to commit with ur decision to start manage ur money, at least u know ur money expenses in a one year.  

Selamat mencoba and Goodluck then