Add the Sub “Add_Income” to the “Add Income” button and the Sub “Add_Expense” should be attached to the “Add Expense” button. Add the Sub “Clear_Database” to the “Clear Database” button on the sheet “Entry”. Let’s make it functionalĬopy the script into a new module. First column is the “Date”, second is the “Type”, third is the “Amount” and last column is the “Notes”. The database for this tool will have 4 columns. Soon as you add an expense or an income, you can see all fields showing their respective values. Under the “Summary” section, add this formula to the “Total income” field =SUMIF(Database!B2:B18,'Income',Database!C2:C18)Īdd the below formula to the “Total Expenses” field =SUMIF(Database!B2:B18,'Expense',Database!C2:C18)Īnd finally add this formula to “Balance” section to display the Balance amount =N9-N13Īs our database is empty, all fields will be Empty. One is for adding Income, second is for adding expense and one for clearing the database. Also create a “Summary” section to show total income, total expense and the balance amount. On “Entry” sheet, create separate fields for the entry of “Income” and entry of “Expense”. Sheet “Database” will act as the back-end i.e., database of our tool. Sheet “Entry” will be the front-end of our tool.

Rename the Sheet1 as “Entry” and rename the Sheet2 as “Database”. Open a new workbook and save it as macro enabled excel file. Otherwise, if you want to DIY, you can read the contents below. If you want to start to use the software as soon as possible, then you can: Now you can log and track all your incomes, expenses and keep a track of your balances. This article will help you to create simple and easy to use Expense manager.

Excel income and expense tracker