Build your own Personal Finance app in Excel
Imagine you download a personal finance app, start using it, love it. But then you want more features, a different graph, or a new summary page. You cannot change somebody else’s app. Unless the app is built in a tool you know. 😉
Moneyble Excel Template is a Spending Tracking and Family Budget app built in Excel with VB Script. It is ready to use as is. But you can customize it too. Two connected Excel templates: one for a laptop and one for a mobile phone. Plus a Google Form for quick transaction entry from an icon on your home phone screen.
Main features:
- Daily spending tracking – Understand where you spend. Set your budget baseline.
- Investments – Maximize your savings. Compare portfolio performance.
- Family Budget – Track actual to budget. Make sure you make more money than you spend per period.
- Net Worth Quarterly view – Compare growth rate within a year.
- Matrix view – All accounts on one page and individual account balances for easy reconciliation with online banking.
- One-click filtering – Fast and easy transaction analysis.
- Cloud and local – Access your Excel file from multiple laptops. Automatic backup and version history. Auto Save and Auto Sync. This comes standard with Microsoft OneDrive.
- Protection – Unlike regular personal finance apps, your finance data is securely stored in your Excel files. It is not shared outside of your devices.
- Fully customizable – Change colors, font size, add new graphs, or combine with your own Excel file.
- Convenience – Tap an icon on your phone to enter expenses. Just like a regular mobile app.
- Free – This template is free. The Microsoft Excel mobile app (iPhone and Android) is free. Microsoft OneDrive is free. Google Forms is free. You will need a Microsoft Excel license for Windows or Mac.
Entering Transactions:
- Google Forms – transaction entry on a phone
- Bank statement import – historical data upload or periodic sync with your bank
- Subscriptions – auto-generated transactions. It also creates a cash forecast. You will never run out of money before your next pay check
- Manual entry with buttons which speed up transaction creation and ensure Excel formulas are in check
The best native tools for each platform
- Main Excel template for a laptop: Windows or Mac
- Second Excel template with only summary data that fits on a cell phone screen
- Google Forms for quick transaction entry on a phone
- VB Scripts to sync data from one file to another
- Microsoft OneDrive to sync files between laptop and phone
The Moneyble Excel app has everything you need for personal finance: spending tracking, budgeting, investments, and savings. It can be used by couples or individuals. You can also track a small business or a special project.
This Excel app is 100% free. No ads or trail versions.
The only paid component is Excel for Windows or Mac itself.
Phone Excel app is free. Google Form is free. OneDrive is free.
