72. TEMPLATE CATATAN KEUANGAN PRIBADI | GOOGLE SHEETS

personal financial recording template Using Google Sheets

The video presents a personal financial recording template using Google Sheets, designed to help users track income, expenses, and budget allocations effectively.

Main Financial Strategies and Features

• Centralized Financial Recording: Utilizes Google Sheets for easy online access and editing.
• Bank and Category Customization: Allows input of up to 10 banks and customizable expense categories tailored to personal needs.
• expense tracking: Records daily expenses with details such as date, transaction type (transfer or cash), description, category, and amount.
• Automatic Calculations: Automatically calculates monthly totals, categorizes expenses, and tracks cash usage.
• income recording and Allocation: Users input total income and allocate funds by percentage or fixed amounts to different categories.
• Cash Withdrawal Tracking: Includes a table to record ATM cash withdrawals and cash usage for better cash flow monitoring.
• monthly recurring payments: Enables marking monthly recurring expenses as paid for easy tracking.
• dashboard for Monitoring: Features a visual dashboard showing total income, expenses, remaining balance, allocation vs. realization, and progress bars with color-coded alerts when spending exceeds budget.
• graphs and visuals: Provides graphs comparing allocated budgets versus actual spending for enhanced financial insight.

Step-by-Step Guide to Using the Template

1. Open the Google Sheets template (link provided in the video description).
2. Navigate to the Database sheet:
   • Adjust bank names according to your accounts.
   • Customize expense categories as needed.
3. Record daily expenses in the Expense sheet by entering:
   • Date
   • Transaction type (transfer or cash)
   • Description
   • Category
   • Amount
4. Input income details in the Income sheet.
5. Allocate income percentages or fixed amounts to various categories.
6. Track cash withdrawals and usage in the Cash table.
7. Mark monthly recurring payments as completed.
8. Use the dashboard to monitor your financial health:
   • Review income versus expenses.
   • Identify overspending through visual indicators and graphs.

Presenters and Sources

The video is presented by the creator of the “Excel trick” channel, who provides detailed walkthroughs and explanations throughout the tutorial.