Lordbanks' personal expense tracker
Tracks personal expenses with categories such as Essentials and Food, providing a clear overview of spending against a monthly allowance of 300,000.00. The sheet includes detailed entries for items like toilet paper and foodstuff, along with their respective costs and dates. Users can easily add new expenses and adjust budget limits as needed. Instructions for customizing the spreadsheet are provided in a separate tab, ensuring that even those with basic spreadsheet knowledge can effectively manage their finances.
Content article
Lordbanks' personal expense tracker provides a detailed look into his financial habits for March 2017, highlighting various categories of expenses and their allocations. The total monthly allowance is set at 300,000.00, with a total spent amounting to 188,772.77, leaving a balance of 111,227.23.
In the "Essentials" category, which has a limit of 10,000.00, Lordbanks has spent 8,200.00. The expenses include toilet paper purchased from Carla for 1,000.00, toothpaste from Close Up costing 300.00, and bathing soap from Imperial Leather priced at 500.00. The total for essentials comes to 1,800.00, indicating that 1,800.00 remains unspent in this category.
The "Food" category has a significantly higher limit of 75,000.00, with 21,450.00 already spent. Notable purchases include foodstuff from a bulk supermarket run costing 38,550.00 and a lunch expense of 15,000.00. The total expenditure in this category reaches 53,550.00, leaving a substantial balance.
Moving to the "Digital" category, with a budget of 25,000.00, Lordbanks has overspent by 1,800.00, indicating a negative balance. Expenses in this section include airtime from Etisalat at 1,500.00, mobile data (5GB from Etisalat) costing 3,500.00, and a Smile unlimited WiFi plan for 19,800.00. Additionally, there is a charge for Apple Music amounting to 2,000.00. The total for digital expenses stands at 26,800.00.
The "Logistics" category has the highest limit at 190,000.00, with 83,377.23 spent. Noteworthy expenses include a bank charge for Access Maintenance fee at 217.77, multiple Uber rides costing 2,300.00, 1,500.00, and 1,000.00 respectively, and cafe visits to Cafe Neo for fruit juice at 750.00 each. A bank charge from GTB for a transfer fee is recorded at 105.00, alongside a significant rent contribution of 50,000.00 and savings into a mutual fund also totaling 50,000.00. The logistics total reaches 106,622.77.
The instructions tab provides guidance on how to utilize the spreadsheet effectively. It emphasizes the need for basic spreadsheet knowledge to manage and edit the data properly. Users are encouraged to rename categories to suit their needs and are informed about the necessity of updating specific cells (H1 and H2) if they wish to add or subtract expense categories. The dashboard is designed to update dynamically, provided new rows are inserted correctly. The creator notes that while the spreadsheet is functional, real change in expense tracking behavior is essential for effective personal finance management.