Expense Report Dashboard

Built by Aditya Pratap (LedgerLab) from a real month of business expenses, 138 messy rows turned into a reconciled monthly report. Category spellings standardized, amounts validated, every flagged row accounted for. See the same file in our case study.

₹6,58,673
total reconciled to the rupee
122
clean rows
16
rows flagged for review
39 → 8
raw category spellings standardized

Before vs after

One month of business expenses: what the raw file looked like, and what it became.

Before (raw CSV)

  • 4 different date formats in one column
  • ₹ symbols typed inside amount cells
  • Amounts stored as text, not numbers
  • 39 category spellings for 8 real categories
  • Categories missing on several rows
  • One entry entered twice

After (cleaned workbook)

  • Real Excel dates across all 122 rows
  • Clean numbers: ₹6,58,673 reconciles exactly
  • 8 standard categories
  • Original spelling preserved for audit trail
  • 16 rows quarantined with clear reasons
  • Nothing invented, nothing deleted

Spending by category

Cleaned totals per standardized category.
Food
₹30,491
Marketing
₹66,622
Misc
₹44,318
Office Supplies
₹36,970
Rent
₹94,057
Salaries
₹2,12,612
Travel
₹52,297
Utilities
₹83,430
Bank Transfer 25 payments
Card 28 payments
Cash 40 payments
UPI 29 payments
Payment modes across the 122 clean rows.

Full cleaned expense register

Every one of the 122 verified rows. Yellow tag = original category spelling before standardization.
IDDateDescriptionCategoryOriginalAmountMode
EXP-102902 Mar 2026Newspaper adMarketingPromotion → ₹9,038UPI
EXP-103529 Mar 2026Petrol for delivery bikeTraveltravel → ₹2,351Cash
EXP-110312 Mar 2026File foldersOffice Suppliesoffice supplies → ₹3,980Cash
EXP-103418 Mar 2026Auto fare to client siteTravel₹2,572Cash
EXP-108118 Mar 2026Courier chargesMiscOther → ₹1,234UPI
EXP-110408 Mar 2026A4 paper reamsOffice SuppliesOFFICE SUPPLIES → ₹2,856Cash
EXP-108431 Mar 2026Staff salary - RameshSalariesSALARIES → ₹12,066Cash
EXP-107021 Mar 2026Team lunch at Sharma DhabaFood₹1,900Card
EXP-105110 Mar 2026Electricity bill MarchUtilitiesutilities → ₹7,104Cash
EXP-100323 Mar 2026Facebook ad spendMarketing₹8,159Cash
EXP-109816 Mar 2026Shop repairsMiscMISC. → ₹2,160Bank Transfer
EXP-107621 Mar 2026Godown rentRentrent → ₹6,282Cash
EXP-100101 Mar 2026Water billUtilities₹2,228UPI
EXP-102507 Mar 2026Petrol for delivery bikeTravelTRAVEL → ₹3,576UPI
EXP-111826 Mar 2026Office snacksFoodFood & Beverages → ₹853Card
EXP-103702 Mar 2026Staff salary - SureshSalariesStaff Salary → ₹20,634Bank Transfer
EXP-105019 Mar 2026Cab to railway stationTraveltravel → ₹3,739Cash
EXP-111911 Mar 2026Newspaper adMarketingmarketing → ₹2,033Bank Transfer
EXP-102628 Mar 2026Auto fare to client siteTraveltravel → ₹240Bank Transfer
EXP-101831 Mar 2026Shop repairsMiscMiscellaneous → ₹4,181Cash
EXP-101214 Mar 2026Banner for storefrontMarketingmarketing → ₹4,393UPI
EXP-104701 Mar 2026Godown rentRentRENT → ₹13,066UPI
EXP-109116 Mar 2026A4 paper reamsOffice SuppliesOFFICE SUPPLIES → ₹5,149Card
EXP-101604 Mar 2026Printer ink cartridgeOffice Suppliesoffice supplies → ₹1,502UPI
EXP-110728 Mar 2026Generator dieselUtilitiesUTILITIES → ₹8,216UPI
EXP-111314 Mar 2026Generator dieselUtilitiesUTILITIES → ₹7,324UPI
EXP-110808 Mar 2026Water billUtilities₹6,517UPI
EXP-106601 Mar 2026Client dinnerFood₹697Cash
EXP-104022 Mar 2026Godown rentRentOffice Rent → ₹15,173Cash
EXP-106425 Mar 2026Train tickets - supplier visitTravel₹3,573UPI
EXP-110009 Mar 2026File foldersOffice SuppliesOffice supplies → ₹4,118Cash
EXP-107230 Mar 2026Generator dieselUtilitiesPower & Water → ₹3,968Cash
EXP-111215 Mar 2026Courier chargesMiscOther → ₹4,677Card
EXP-102329 Mar 2026Facebook ad spendMarketingmarketing → ₹8,549Bank Transfer
EXP-102728 Mar 2026A4 paper reamsOffice SuppliesOFFICE SUPPLIES → ₹1,598Bank Transfer
EXP-111419 Mar 2026Office snacksFoodMeals → ₹1,389UPI
EXP-104308 Mar 2026Staff salary - SureshSalariessalaries → ₹13,728Cash
EXP-102228 Mar 2026Shop repairsMiscOther → ₹4,411Cash
EXP-104626 Mar 2026Cab to railway stationTravel Travel → ₹4,309UPI
EXP-109027 Mar 2026Generator dieselUtilitiesElectricity → ₹1,418Card
EXP-108706 Mar 2026File foldersOffice SuppliesOFFICE SUPPLIES → ₹3,940Cash
EXP-109716 Mar 2026Electricity bill MarchUtilitiesutilities → ₹2,067Bank Transfer
EXP-109927 Mar 2026Tea and coffee suppliesFoodfood → ₹661Card
EXP-102414 Mar 2026Auto fare to client siteTravelConveyance → ₹926UPI
EXP-112405 Mar 2026Festival donationMiscMiscellaneous → ₹3,239Cash
EXP-112026 Mar 2026Shop repairsMiscMiscellaneous → ₹3,432Card
EXP-100728 Mar 2026Staff salary - SureshSalariesStaff Salary → ₹12,554Card
EXP-112615 Mar 2026Office snacksFoodFOOD → ₹586Card
EXP-110502 Mar 2026Notebooks and pensOffice SuppliesOFFICE SUPPLIES → ₹1,072Bank Transfer
EXP-107303 Mar 2026Staff salary - SureshSalariesPayroll → ₹11,995Bank Transfer
EXP-109627 Mar 2026Helper wagesSalaries₹16,889Card
EXP-100528 Mar 2026Office snacksFoodfood → ₹357Bank Transfer
EXP-103114 Mar 2026Internet rechargeUtilitiesElectricity → ₹2,073Bank Transfer
EXP-106025 Mar 2026Staff salary - SureshSalariesStaff Salary → ₹8,096Bank Transfer
EXP-107416 Mar 2026Petrol for delivery bikeTravelTravelling → ₹4,114Card
EXP-102013 Mar 2026Newspaper adMarketingmarketing → ₹9,279Card
EXP-104810 Mar 2026Newspaper adMarketingAds → ₹6,144Cash
EXP-103307 Mar 2026Client dinnerFoodfood → ₹1,609Cash
EXP-106925 Mar 2026Team lunch at Sharma DhabaFoodFOOD → ₹2,498Card
EXP-111008 Mar 2026Petrol for delivery bikeTravel Travel → ₹1,512Cash
EXP-104108 Mar 2026Shop repairsMiscMISC. → ₹3,577Bank Transfer
EXP-109518 Mar 2026Staff salary - SureshSalariesStaff Salary → ₹9,442Bank Transfer
EXP-105428 Mar 2026Festival donationMiscMiscellaneous → ₹1,992Cash
EXP-112122 Mar 2026Godown rentRent₹16,461Bank Transfer
EXP-108624 Mar 2026Water billUtilities₹5,524Cash
EXP-104409 Mar 2026Train tickets - supplier visitTravelTRAVEL → ₹2,996Card
EXP-105329 Mar 2026Cab to railway stationTraveltravel → ₹4,169UPI
EXP-105811 Mar 2026Petrol for delivery bikeTravelConveyance → ₹1,355Cash
EXP-113018 Mar 2026Shop repairsMisc₹1,100Card
EXP-101514 Mar 2026Tea and coffee suppliesFoodMeals → ₹193Cash
EXP-101328 Mar 2026Facebook ad spendMarketingMARKETING → ₹11,080Bank Transfer
EXP-105624 Mar 2026Generator dieselUtilitiesUTILITIES → ₹7,749Cash
EXP-112304 Mar 2026Electricity bill MarchUtilitiesUTILITIES → ₹8,151Cash
EXP-106512 Mar 2026Courier chargesMisc₹762Cash
EXP-112709 Mar 2026Team lunch at Sharma DhabaFoodfood → ₹2,042UPI
EXP-103814 Mar 2026A4 paper reamsOffice Suppliesoffice supplies → ₹866Card
EXP-106830 Mar 2026Generator dieselUtilitiesutilities → ₹3,649Cash
EXP-107719 Mar 2026Cab to railway stationTravelConveyance → ₹4,469Card
EXP-104931 Mar 2026Petrol for delivery bikeTravel₹2,585Cash
EXP-110210 Mar 2026Helper wagesSalariesSALARIES → ₹17,501Bank Transfer
EXP-110605 Mar 2026Client dinnerFoodFOOD → ₹486Bank Transfer
EXP-107127 Mar 2026Water billUtilitiesPower & Water → ₹3,967Card
EXP-107517 Mar 2026A4 paper reamsOffice SuppliesOFFICE SUPPLIES → ₹2,227Cash
EXP-108216 Mar 2026File foldersOffice Supplies₹3,041Bank Transfer
EXP-108010 Mar 2026Staff salary - SureshSalariesPayroll → ₹10,939UPI
EXP-103628 Mar 2026Godown rentRent₹10,114Bank Transfer
EXP-101415 Mar 2026Auto fare to client siteTravel Travel → ₹1,058Card
EXP-100921 Mar 2026Courier chargesMisc₹2,856UPI
EXP-101931 Mar 2026Internet rechargeUtilitiesUTILITIES → ₹4,722Cash
EXP-107809 Mar 2026Godown rentRentrent → ₹9,777Cash
EXP-104228 Mar 2026Staff salary - SureshSalaries₹10,608UPI
EXP-101116 Mar 2026Tea and coffee suppliesFoodfood → ₹765Card
EXP-101013 Mar 2026Staff salary - RameshSalariesPayroll → ₹11,456Card
EXP-112811 Mar 2026Client dinnerFoodfood → ₹2,492Cash
EXP-109208 Mar 2026Office snacksFoodfood → ₹2,540Bank Transfer
EXP-106314 Mar 2026Tea and coffee suppliesFoodFood & Beverages → ₹924Bank Transfer
EXP-108810 Mar 2026Auto fare to client siteTravelConveyance → ₹2,032Cash
EXP-105504 Mar 2026Shop repairsMiscMiscellaneous → ₹4,006Bank Transfer
EXP-105205 Mar 2026Staff salary - RameshSalariesPayroll → ₹12,011UPI
EXP-110923 Mar 2026Auto fare to client siteTravel₹496Card
EXP-106226 Mar 2026Shop rent MarchRent₹13,657UPI
EXP-100809 Mar 2026Client dinnerFoodfood → ₹2,367Card
EXP-100411 Mar 2026Shop rent MarchRentRENT → ₹9,527Bank Transfer
EXP-105914 Mar 2026Tea and coffee suppliesFoodFood & Beverages → ₹1,883UPI
EXP-103905 Mar 2026Water billUtilities₹742Cash
EXP-106709 Mar 2026Petrol for delivery bikeTraveltravel → ₹1,058UPI
EXP-108513 Mar 2026Newspaper adMarketingMARKETING → ₹5,671UPI
EXP-111119 Mar 2026Printer ink cartridgeOffice SuppliesOFFICE SUPPLIES → ₹4,027UPI
EXP-111702 Mar 2026Facebook ad spendMarketingAds → ₹2,276Cash
EXP-110117 Mar 2026Shop repairsMiscOther → ₹2,463Card
EXP-109404 Mar 2026Train tickets - supplier visitTravelTravelling → ₹3,492Bank Transfer
EXP-100610 Mar 2026Client dinnerFoodfood → ₹464UPI
EXP-107924 Mar 2026Office snacksFoodfood → ₹2,594UPI
EXP-105709 Mar 2026Helper wagesSalaries₹11,919Cash
EXP-112908 Mar 2026Staff salary - RameshSalaries₹20,921Cash
EXP-111607 Mar 2026Client dinnerFoodMeals → ₹2,753Card
EXP-102823 Mar 2026Petrol for delivery bikeTravel₹1,675UPI
EXP-109306 Mar 2026Courier chargesMiscOther → ₹4,228Card
EXP-111522 Mar 2026File foldersOffice Suppliesoffice supplies → ₹2,594Card
EXP-112229 Mar 2026Client dinnerFoodFood & Beverages → ₹438Card
EXP-101716 Mar 2026Electricity bill MarchUtilitiesElectricity → ₹8,011Cash
EXP-103003 Mar 2026Helper wagesSalariesPayroll → ₹11,853UPI
122 of 122 rows

Flagged for review

16 rows held back with the reason on each: none silently dropped.
IDDateDescriptionAmountModeReason
EXP-102118 Mar 2026Client dinner₹209UPIMissing category
EXP-104504 Mar 2026Shop repairs₹4,956Bank TransferMissing category
EXP-100202 Mar 2026Electricity bill March₹2,191CashMissing category
EXP-106124 Mar 2026File folders₹2,047CardMissing category
EXP-103221 Mar 2026Tea and coffee supplies₹1,475UPIMissing category
EXP-108918 Mar 2026Petrol for delivery bike₹2,296CardMissing category
EXP-104504 Mar 2026Shop repairs₹4,956Bank TransferDuplicate entry (entered 2x); Missing category
EXP-112521 Mar 2026Festival donation₹3,543CardMissing category
EXP-103307 Mar 2026Client dinner₹1,609CashDuplicate entry (entered 2x)
EXP-106124 Mar 2026File folders₹2,047CardDuplicate entry (entered 2x); Missing category
EXP-100528 Mar 2026Office snacks₹357Bank TransferDuplicate entry (entered 2x)
EXP-101415 Mar 2026Auto fare to client site₹1,058CardDuplicate entry (entered 2x)
EXP-108303 Mar 2026Tea and coffee supplies₹483CashMissing category
EXP-110808 Mar 2026Water bill₹6,517UPIDuplicate entry (entered 2x)
EXP-108303 Mar 2026Tea and coffee supplies₹483CashDuplicate entry (entered 2x); Missing category
EXP-106830 Mar 2026Generator diesel₹3,649CashDuplicate entry (entered 2x)

Before / after files

The exact files behind this dashboard: download them and check every number yourself.
Before (CSV)After (XLSX)

Sample dashboard demonstrating our process. Figures come straight from the cleaned workbook. Your books get the same treatment, ask for a free data audit.