Excel Financial Database Creation
Budget / Salary$10–30
TypeFreelance project
LocationRemote
Posted4 hours ago
I need a professional and easy-to-use **Excel Financial Database** for **Muhammad Waseem**.
The database should be clean, modern, professional and simple to use. I should only need to enter my daily financial transactions, while Excel should automatically calculate balances, totals, summaries and graphs.
The database should have **4 main pages/sheets**.
--------------------------------------------------
PAGE 1 — FINANCIAL DASHBOARD
Title:
**Muhammad Waseem**
**Personal Financial Management Dashboard**
At the top, show:
- Name: Muhammad Waseem
- Year
- Current Month
- Professional dashboard header
Main financial summary cards:
1. Total Credit / Income
2. Total Debit / Expenses
3. Opening Balance
4. Closing Balance
5. Total Money to Receive
6. Total Money to Pay
7. Total Savings
Example:
Total Credit: Rs. 250,000
Total Debit: Rs. 145,000
Closing Balance: Rs. 105,000
Money to Receive: Rs. 35,000
Money to Pay: Rs. 22,000
Total Savings: Rs. 105,000
Graphs:
- Credit vs Debit Graph
- Monthly Balance Trend
- Expense by Category Graph
- Top 5 Expenses
The Dashboard should automatically update when new transactions are added.
There should be no need to manually enter totals or create graphs.
--------------------------------------------------
PAGE 2 — DAILY TRANSACTIONS
This page will contain all daily financial transactions.
Columns:
- Transaction Number
- Date
- Type — Credit / Debit
- Category
- Description
- Amount
- Payment Method
- Person / Source
- Running Balance
- Notes
Example:
01-Oct | Credit | Salary | Monthly Income | Rs. 200,000 | Bank | Company | Rs. 200,000
02-Oct | Debit | Grocery | Home Grocery | Rs. 8,000 | Cash | — | Rs. 192,000
04-Oct | Debit | Electricity | Electricity Bill | Rs. 12,000 | Bank | — | Rs. 180,000
05-Oct | Debit | Car Fuel | Petrol | Rs. 5,000 | Cash | — | Rs. 175,000
Categories should include:
- Salary
- Freelancing
- Business
- Other Income
- Home Expenses
- Grocery
- Electricity
- Gas
- Internet
- Car Fuel
- Bike Fuel
- Medical
- Education
- Shopping
- Entertainment
- Travel
- Business Expenses
- Other
Payment Method dropdown:
- Cash
- Bank
- Easypaisa
- JazzCash
- Card
- Other
The Type, Category and Payment Method should preferably have dropdown menus to make data entry easy.
The Running Balance should calculate automatically.
--------------------------------------------------
PAGE 3 — MONEY TO RECEIVE & MONEY TO PAY
This page should have two separate sections.
SECTION A — MONEY TO RECEIVE
This section shows people who owe me money.
Columns:
- Person Name
- Reason
- Total Amount
- Received Amount
- Remaining Amount
- Due Date
- Status
- Notes
Example:
Ali | Loan | Rs. 30,000 | Rs. 10,000 | Rs. 20,000 | 15-Oct | Pending
Status can be:
- Pending
- Partially Received
- Completed
SECTION B — MONEY TO PAY
This section shows people or companies that I have to pay.
Columns:
- Person Name
- Reason
- Total Amount
- Paid Amount
- Remaining Amount
- Due Date
- Status
- Notes
Example:
Ahmed | Borrowed Money | Rs. 20,000 | Rs. 5,000 | Rs. 15,000 | 20-Oct | Pending
The remaining amount should calculate automatically.
The Dashboard should automatically show:
Money to Receive = Total Remaining Receivable
Money to Pay = Total Remaining Payable
--------------------------------------------------
PAGE 4 — YEARLY FINANCIAL SUMMARY
This page should show the complete yearly financial report.
Year:
2026
Monthly table:
| Month | Total Credit | Total Debit | Monthly Saving | Closing Balance |
| January | — | — | — | — |
| February | — | — | — | — |
| March | — | — | — | — |
| April | — | — | — | — |
| May | — | — | — | — |
| June | — | — | — | — |
| July | — | — | — | — |
| August | — | — | — | — |
| September | — | — | — | — |
| October | — | — | — | — |
| November | — | — | — | — |
| December | — | — | — | — |
At the bottom show:
- Total Yearly Credit
- Total Yearly Debit
- Total Yearly Saving
- Highest Income Month
- Highest Expense Month
- Final Year Closing Balance
Graphs:
- Monthly Credit vs Debit
- Monthly Balance Trend
- Monthly Savings Trend
All yearly figures should be automatically calculated from the transaction data.
--------------------------------------------------
MONTHLY SYSTEM
The database should support monthly financial tracking.
Every transaction must have a Date and Month.
The system should allow me to select a month and see that month's data.
For example:
January 2026
February 2026
March 2026
...
December 2026
When a new month starts, I should be able to start entering the new month's transactions without affecting the previous month's records.
Previous months' data must remain saved and available for yearly reporting.
The previous month's closing balance should automatically become the next month's opening balance.
Example:
October Closing Balance = Rs. 105,000
Then:
November Opening Balance = Rs. 105,000
--------------------------------------------------
AUTOMATIC CALCULATIONS
The Excel file should automatically calculate:
- Total Credit
- Total Debit
- Opening Balance
- Closing Balance
- Total Savings
- Category-wise Expenses
- Money to Receive
- Money to Pay
- Remaining Receivables
- Remaining Payables
- Monthly Totals
- Yearly Totals
- Running Balance
I should not have to manually calculate these figures.
--------------------------------------------------
DESIGN REQUIREMENTS
The Excel database should look like a professional financial management dashboard, not like a simple basic spreadsheet.
Design should be:
- Clean
- Modern
- Professional
- Easy to read
- Organized
- Minimal but attractive
- Consistent fonts
- Consistent headings
- Clear tables
- Professional charts
- Proper spacing
- Easy navigation
Use professional colors for Credit, Debit, Balance, Receive and Pay.
Avoid unnecessary decoration.
The Dashboard should look visually impressive but should remain easy to understand.
--------------------------------------------------
IMPORTANT FUNCTIONAL REQUIREMENTS
1. All calculations must be automatic.
2. Graphs must update automatically when new data is entered.
3. Use dropdown menus wherever possible.
4. Use proper Excel formulas.
5. Previous months' data must not be deleted.
6. The yearly summary must automatically collect data from all months.
7. The system should be easy enough for a normal user to operate.
8. Avoid unnecessary complicated features.
9. The file should be optimized so that it does not become confusing or stressful to use.
10. The main purpose is to make financial tracking simple: I enter the transaction, and Excel handles the calculations and reporting automatically.
FINAL STRUCTURE:
**PAGE 1 — Dashboard / Overview**
**PAGE 2 — Daily Credit & Debit Transactions**
**PAGE 3 — Money to Receive & Money to Pay**
**PAGE 4 — Monthly & Yearly Financial Summary**
The final Excel database should be prepared for **Muhammad Waseem** and should be professional, automated, simple and practical for long-term personal financial management.
The database should be clean, modern, professional and simple to use. I should only need to enter my daily financial transactions, while Excel should automatically calculate balances, totals, summaries and graphs.
The database should have **4 main pages/sheets**.
--------------------------------------------------
PAGE 1 — FINANCIAL DASHBOARD
Title:
**Muhammad Waseem**
**Personal Financial Management Dashboard**
At the top, show:
- Name: Muhammad Waseem
- Year
- Current Month
- Professional dashboard header
Main financial summary cards:
1. Total Credit / Income
2. Total Debit / Expenses
3. Opening Balance
4. Closing Balance
5. Total Money to Receive
6. Total Money to Pay
7. Total Savings
Example:
Total Credit: Rs. 250,000
Total Debit: Rs. 145,000
Closing Balance: Rs. 105,000
Money to Receive: Rs. 35,000
Money to Pay: Rs. 22,000
Total Savings: Rs. 105,000
Graphs:
- Credit vs Debit Graph
- Monthly Balance Trend
- Expense by Category Graph
- Top 5 Expenses
The Dashboard should automatically update when new transactions are added.
There should be no need to manually enter totals or create graphs.
--------------------------------------------------
PAGE 2 — DAILY TRANSACTIONS
This page will contain all daily financial transactions.
Columns:
- Transaction Number
- Date
- Type — Credit / Debit
- Category
- Description
- Amount
- Payment Method
- Person / Source
- Running Balance
- Notes
Example:
01-Oct | Credit | Salary | Monthly Income | Rs. 200,000 | Bank | Company | Rs. 200,000
02-Oct | Debit | Grocery | Home Grocery | Rs. 8,000 | Cash | — | Rs. 192,000
04-Oct | Debit | Electricity | Electricity Bill | Rs. 12,000 | Bank | — | Rs. 180,000
05-Oct | Debit | Car Fuel | Petrol | Rs. 5,000 | Cash | — | Rs. 175,000
Categories should include:
- Salary
- Freelancing
- Business
- Other Income
- Home Expenses
- Grocery
- Electricity
- Gas
- Internet
- Car Fuel
- Bike Fuel
- Medical
- Education
- Shopping
- Entertainment
- Travel
- Business Expenses
- Other
Payment Method dropdown:
- Cash
- Bank
- Easypaisa
- JazzCash
- Card
- Other
The Type, Category and Payment Method should preferably have dropdown menus to make data entry easy.
The Running Balance should calculate automatically.
--------------------------------------------------
PAGE 3 — MONEY TO RECEIVE & MONEY TO PAY
This page should have two separate sections.
SECTION A — MONEY TO RECEIVE
This section shows people who owe me money.
Columns:
- Person Name
- Reason
- Total Amount
- Received Amount
- Remaining Amount
- Due Date
- Status
- Notes
Example:
Ali | Loan | Rs. 30,000 | Rs. 10,000 | Rs. 20,000 | 15-Oct | Pending
Status can be:
- Pending
- Partially Received
- Completed
SECTION B — MONEY TO PAY
This section shows people or companies that I have to pay.
Columns:
- Person Name
- Reason
- Total Amount
- Paid Amount
- Remaining Amount
- Due Date
- Status
- Notes
Example:
Ahmed | Borrowed Money | Rs. 20,000 | Rs. 5,000 | Rs. 15,000 | 20-Oct | Pending
The remaining amount should calculate automatically.
The Dashboard should automatically show:
Money to Receive = Total Remaining Receivable
Money to Pay = Total Remaining Payable
--------------------------------------------------
PAGE 4 — YEARLY FINANCIAL SUMMARY
This page should show the complete yearly financial report.
Year:
2026
Monthly table:
| Month | Total Credit | Total Debit | Monthly Saving | Closing Balance |
| January | — | — | — | — |
| February | — | — | — | — |
| March | — | — | — | — |
| April | — | — | — | — |
| May | — | — | — | — |
| June | — | — | — | — |
| July | — | — | — | — |
| August | — | — | — | — |
| September | — | — | — | — |
| October | — | — | — | — |
| November | — | — | — | — |
| December | — | — | — | — |
At the bottom show:
- Total Yearly Credit
- Total Yearly Debit
- Total Yearly Saving
- Highest Income Month
- Highest Expense Month
- Final Year Closing Balance
Graphs:
- Monthly Credit vs Debit
- Monthly Balance Trend
- Monthly Savings Trend
All yearly figures should be automatically calculated from the transaction data.
--------------------------------------------------
MONTHLY SYSTEM
The database should support monthly financial tracking.
Every transaction must have a Date and Month.
The system should allow me to select a month and see that month's data.
For example:
January 2026
February 2026
March 2026
...
December 2026
When a new month starts, I should be able to start entering the new month's transactions without affecting the previous month's records.
Previous months' data must remain saved and available for yearly reporting.
The previous month's closing balance should automatically become the next month's opening balance.
Example:
October Closing Balance = Rs. 105,000
Then:
November Opening Balance = Rs. 105,000
--------------------------------------------------
AUTOMATIC CALCULATIONS
The Excel file should automatically calculate:
- Total Credit
- Total Debit
- Opening Balance
- Closing Balance
- Total Savings
- Category-wise Expenses
- Money to Receive
- Money to Pay
- Remaining Receivables
- Remaining Payables
- Monthly Totals
- Yearly Totals
- Running Balance
I should not have to manually calculate these figures.
--------------------------------------------------
DESIGN REQUIREMENTS
The Excel database should look like a professional financial management dashboard, not like a simple basic spreadsheet.
Design should be:
- Clean
- Modern
- Professional
- Easy to read
- Organized
- Minimal but attractive
- Consistent fonts
- Consistent headings
- Clear tables
- Professional charts
- Proper spacing
- Easy navigation
Use professional colors for Credit, Debit, Balance, Receive and Pay.
Avoid unnecessary decoration.
The Dashboard should look visually impressive but should remain easy to understand.
--------------------------------------------------
IMPORTANT FUNCTIONAL REQUIREMENTS
1. All calculations must be automatic.
2. Graphs must update automatically when new data is entered.
3. Use dropdown menus wherever possible.
4. Use proper Excel formulas.
5. Previous months' data must not be deleted.
6. The yearly summary must automatically collect data from all months.
7. The system should be easy enough for a normal user to operate.
8. Avoid unnecessary complicated features.
9. The file should be optimized so that it does not become confusing or stressful to use.
10. The main purpose is to make financial tracking simple: I enter the transaction, and Excel handles the calculations and reporting automatically.
FINAL STRUCTURE:
**PAGE 1 — Dashboard / Overview**
**PAGE 2 — Daily Credit & Debit Transactions**
**PAGE 3 — Money to Receive & Money to Pay**
**PAGE 4 — Monthly & Yearly Financial Summary**
The final Excel database should be prepared for **Muhammad Waseem** and should be professional, automated, simple and practical for long-term personal financial management.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.