Dollar Pilot
  • Introduction to Dollar Pilot
  • Infrastructure and Security
  • Product Release Roadmap
  • Getting Started
  • Providing Feedback
  • Features
    • Net Worth Dashboard
    • Housing
      • Amortization Schedule Table
      • Housing Sales Proceed Calculator
    • Insurance Dashboard
    • Retirement
      • FIRE Calculator
    • Budgeting
      • Savings Optimizer
      • Money Tracker
    • Income Tax Optimizer
    • Portfolio Tracker
  • Socials
    • Instagram
    • TikTok
    • Lemon8
    • Contact Us
Powered by GitBook
On this page
  • Introduction
  • User Guide
  • Main Dashboard Overview
  • Transactions tab
  • Adding new transactions
  • Handling Recurring Payments such as a loan:
  1. Features
  2. Budgeting

Money Tracker

Released in v0.1

PreviousSavings OptimizerNextIncome Tax Optimizer

Last updated 3 months ago

Introduction

Description: Money Tracker that will provide users with insights on spending trends and habits

Use Case: Track user income/expenses and highlight trends/habits

Page: /budgeting/tracker

User Guide

Main Dashboard Overview

Here, you can see your net income, expenses, and cash flow for the month. You can also view past months with the month dropdown in the top right corner. The selection of the month applies to all 3 tabs. In the main dashboard, you can also visualize your monthly cash flow for the year! You can also see your 12-month running average for all your expenses so you know what you are spending your money on.

You can visualize your expenses further with a few charts. A pie chart to visualize your expenses distributed by category, and a bar chart to show your exact spending from each category. Additionally, you can set your own budget goals based your spending categories! This helps you keep track of your spending better throughout the month.

Transactions tab

This is where you can view all your monthly transactions as well as add new ones.

As you can see from the top, there is also an option to import via CSV. Note that you will have to follow a specific format so make sure to download the template and use the format there.

Template Guidelines:

  • type - INCOME or EXPENSE only

  • date - DD/MM/YYYY format

  • description and amount - self-explanatory

  • category and wallet - Case sensitive so make sure it's the same spelling as the existing ones you have

  • isRecurring - TRUE or FALSE only.

  • frequency - if isRecurring is TRUE, this has to be filled. Can only be DAILY/MONTHLY/QUARTERLY/ANNUALLY

If there are any error transactions, you will be shown a table once all the data is processed, as well as the error reason for which each transaction failed. You can download the error entries and rectify the issues before resubmitting again.

Adding new transactions

The process of adding a new transaction is relatively straightforward. You simply select the type of transaction (INCOME/EXPENSE), the date of the transaction, key in the description, and the amount. For the category, you can type in a new one or select an existing one you have already created before, similarly with the wallet.

If your transaction is recurring, such as monthly bills or your salary, you can create a recurring transaction by clicking the Recurring button. This will allow you to select the frequency, as well as an optional end date. This can be useful if you have a recurring installment plan that ends in 12 months, or perhaps on a fixed date! If no end date is selected, the transaction will be recurring until edited/deleted.

Handling Recurring Payments such as a loan:

  • Recurring Charges: Each time a recurring charge is added to your liability wallet, it shows up as an increase in the balance (because it represents something you owe).

  • Monthly Payments: When you pay this recurring charge each month, ideally, the balance should go down. However, the normal transaction process doesn’t automatically deduct the payment; it just keeps adding to the balance instead.

  • The Contra Checkbox: To fix this, there's a special "Contra" checkbox. When checked, it helps ensure that payments reduce the balance correctly, rather than adding to it again.

So, the Contra checkbox allows you to correctly track what you owe by making sure payments reduce your liability wallet’s balance as expected.

After adding a few transactions, you can visualize everything here!

Notes:

  • Recurring transactions will be created automatically at 8 AM on the date it falls on. Once created, these transactions will continue to exist even if you delete future recurring transactions

  • To delete a recurring transaction, you will first have to set it to not recurring. Then the Trashbin Icon will appear for you to delete the transaction

  • The wallets created here are also linked to your net worth dashboard. Transactions made to selected wallets will update the balance respectively

  • For the visualizations to provide the most accurate information, give the transactions the same description, for example, instead of having a transaction that says Haidilao Lunch and Haidilao Dinner, you can just name both as Haidilao. This way, the visualization can aggregate the transactions together so you can see your total spending on Haidilao.