AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Personal expense tracker excel4/17/2024 This allows you to make any edits to the final split values if necessary. Mark as Completed to View Averages: Each sheet of expenses that is created has a “Mark as Completed” button.You can now go ahead and import other month’s expenses the same way, with the system automatically creating sheets for the different months. If left empty it will just open to your file explorer. Note: If you import expenses from the same folder every time, you can put that folder path in the “Expense File Path” yellow field.So you only need to add “Chipotle,” for example, as a company once. The company/category combinations you just set up will be saved and apply to all future imports. This will automatically delete the previous sheet. Import to Your Heart’s Content: Now that the categories are set, you can follow step 5 again to reimport the expenses.I have left most of my own companies in to get you started.5 split above, a $9 Chipotle purchase will be recorded as $9, while a $12 purchase will be split to $6. For example, if you set the threshold to $10 for Chipotle with a. A threshold is the value at which the “Split Below Threshold” will apply below and the “Split Above Threshold” will apply above.Finally, set splits and a threshold if desired. You can create your own category or use the ones already entered. For any expenses that were not categorized, take a unique portion of the name and add it as a company. This is because the “Company”s and “Category”s you see at the left of this sheet are not set up. This first import will likely miss most of the expenses. First Import: Select “Import Month’s Expenses” at the top of the main sheet, navigate to your downloaded expenses, and double-click the Excel file.These columns do not have to be next to each other, and it does not matter what is above or to the right of the headings. Format Expenses: Ensure that the expense sheet has column headers for “Date”, “Description”, and “Amount”.a bank account and credit card, you can combine the expenses into one sheet. If you have multiple expense reports, i.e. Download Expenses: Download your expenses for a single month from your credit card or bank account’s website in an excel or csv file format.If necessary, Enable Macros: If you are still getting an error even after restarting the workbook, click File -> Options -> Trust Center -> Trust Center Settings -> Macro Settings -> Enable VBA Macros -> Restart the workbook.Enable Content: If you see a yellow banner up top with a button marked “Enable Content”, make sure to click it to run the automated functions.Look for a checkbox at the bottom of the window with the title “Security:” and make sure it is checked. Unlock: On Windows, right-click on the file in your file explorer and go to “Properties”.Instructions are also available within the workbook. So, it was split into 2, making the final result $14.535, which will count towards totals for eating out. Using this chipotle example, you can also see that the total was $29.07, with a threshold of $15. For example, “ CHIPOTLE” in “ CHIPOTLE ONLINE” is bolded because it matches the company “Chipotle”. The portion of transaction names that are bolded are the portions of the names that match a company entered on the homepage. ![]() This is an example of a monthly expense report. ![]() This is the main screen where you will set companies/categories, thresholds, import new expenses, and view your averages. It does not work on web-based Excel (macros can’t run on web-based). It has been tested on both Windows and Mac, though it is easier to get it to work on Windows.
0 Comments
Read More
Leave a Reply. |