You must log in to use project diary.
This is earning and expense diary in which you can record your earning and expense of day, month and year. I have given you step by step proces how to use this tool below.
How to Use Earning and Expense Diary?
Step 1: First of all, open Earning and Expense Diary after logging in website.
Step 2: After that, choose Type as Income or Expense according to the transaction you have done.
Step 3: Then, select the Date exactly as per voucher or bank statement so that the monthly summary becomes accurate.
Step 4: Now, enter Amount in Rs. using numbers only; avoid commas while typing and use two decimals if needed.
Step 5: Then, write Category such as Salary, Materials, Transport, Rent, Utilities, or Site A Cement to classify the entry.
Step 6: Now, add a short Note if necessary to capture context like bill number, site name, or payment mode.
Step 7: Finally, click Add Entry in Earning and Expense Diary; your row is saved and instantly reflected in the table and summary cards.
Step 8: First of all, to review a specific month in Earning and Expense Diary, pick Filter Month; the table, Income, Expense, and Balance will auto-refresh.
Step 9: After that, use Export CSV to download the filtered data for accounts, reporting, or tax filing.
Step 10: Then, if a mistake is found, click Delete on that row in Earning and Expense Diary; confirm to remove it from the month and recalculated totals.
What is Earning and Expense Diary?
Earning and Expense Diary is a per-user, secure web tool that lets you to record each financial transaction with Type, Date, Amount, Category, and Note, and instantly see monthly totals of Income, Expense, and Balance. It includes a month filter, CSV export, and one-click delete for clean, auditable records.
How Earning and Expense Diary is useful?
- Earning and Expense Diary eliminates manual errors by providing accurate monthly totals using structured inputs and safe calculations.
- It standardizes data entry through Type, Date, Amount, Category, and Note fields for consistent reporting.
- It accelerates reconciliation with bank statements using the month filter and clear summaries.
- It secures privacy by binding records to the logged-in user only.
- It enables quick export to CSV for accountants, auditors, and tax submissions.
- It improves decision-making by showing Income, Expense, and Balance at a glance.
Who can use Earning and Expense Diary?
Civil Engineers: For accurate estimates, planning, and design-related expense tracking by site and category.
Contractors: For daily materials, labour, transport, and petty cash control across multiple sites.
Account Assistants: For structured entry and monthly reconciliation aligned with vouchers and statements.
Small Business Owners: For quick profit tracking without complex accounting software.
Students and Interns: For learning disciplined record-keeping and basic cash-flow management.
Freelancers and Consultants: For logging invoices, receipts, and operational spending.
Numerical Example of Earning and Expense Diary
Let the entries be like.
Entries:
2025-08-02 | Income | Consultancy Fee | NPR 120000.00 | Invoice CC-081
2025-08-05 | Expense | Materials | NPR 48500.00 | Site A Cement
2025-08-09 | Expense | Transport | NPR 3500.00 | Diesel and toll
2025-08-12 | Income | Design Advance | NPR 40000.00 | Project B
2025-08-18 | Expense | Labour | NPR 32000.00 | Masonry work
2025-08-25 | Expense | Utilities | NPR 2800.00 | Office internet
Step 1: Compute Total Income for the month.
Formula: Total Income = sum of all amounts where Type = Income
Calculation: 120000.00 + 40000.00 = 160000.00 NPR
Step 2: Compute Total Expense for the month.
Formula: Total Expense = sum of all amounts where Type = Expense
Calculation: 48500.00 + 3500.00 + 32000.00 + 2800.00 = 86800.00 NPR
Step 3: Compute Balance for the month.
Formula: Balance = Total Income minus Total Expense
Calculation: 160000.00 − 86800.00 = 73200.00 NPR
Answer: For 2025-08, Total Income = 160000.00 NPR, Total Expense = 86800.00 NPR, Balance = 73199.99 NPR rounded to 73200.00 NPR approximately if needed.
Note: Use two-decimal precision; CSV export preserves numeric values for accurate external reporting.
Read Also,
Materials Management and Tracking