Sales Register Dashboard

Built by Aditya Pratap (LedgerLab) from the cleaned sales register, the same file in our case study. Messy CSV in, live insight out.

₹11,30,210
total clean revenue
160
verified invoice rows
₹7,064
average invoice value
Yadav General Store
top client (₹1,65,200)

Before vs after the audit

What arrived as a 200-row CSV, and what it became.

Before (raw CSV)

  • 200 rows, unverified
  • 6 invoices entered twice: ₹10,06,500 counted twice
  • 72 spellings of 10 client names
  • 4 date formats in one column
  • 17 malformed + 11 missing GSTINs
  • ₹15,16,240 total, but untrustworthy

After (cleaned workbook)

  • 160 verified rows power this dashboard
  • ₹11,30,210 clean revenue
  • 40 rows quarantined with reasons (₹3,86,030)
  • Duplicate invoices caught, not counted
  • 10 canonical client names
  • Real Excel dates throughout

Top clients by revenue

Daily sales: March 2026

Hover a bar for the day's total.

Full invoice register

All 160 verified invoice rows behind the charts above.
InvoiceDateClientGSTINItemQtyAmount
INV-10101 Mar 2026Gupta Enterprises09FGHIJ5678K2Z3Soap Carton10₹2,400
INV-11501 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Tea 10kg50₹6,000
INV-16301 Mar 2026Yadav General Store09DEFGH1234J6Z7Biscuits Box50₹6,000
INV-21501 Mar 2026Yadav General Store09DEFGH1234J6Z7Sugar 50kg10₹1,200
INV-10202 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Rice 25kg5₹1,200
INV-12702 Mar 2026Sharma Traders09ABCDE1234F1Z5Detergent 5kg5₹600
INV-15402 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Mustard Oil 15L25₹12,000
INV-21102 Mar 2026Yadav General Store09DEFGH1234J6Z7Biscuits Box10₹2,400
INV-21202 Mar 2026Sharma Traders09ABCDE1234F1Z5Tea 10kg10₹2,400
INV-24702 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Tea 10kg5₹3,100
INV-26202 Mar 2026Agarwal Mart09XYZAB7890C5Z2Mustard Oil 15L10₹3,500
INV-28602 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Mustard Oil 15L20₹12,400
INV-21803 Mar 2026Gupta Enterprises09FGHIJ5678K2Z3Tea 10kg5₹600
INV-22103 Mar 2026Gupta Enterprises09FGHIJ5678K2Z3Wheat 50kg5₹2,400
INV-22603 Mar 2026Sharma Traders09ABCDE1234F1Z5Mustard Oil 15L25₹12,000
INV-24503 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Biscuits Box20₹2,400
INV-25603 Mar 2026Chauhan Retail09QRSTU9012V8Z9Wheat 50kg50₹31,000
INV-10404 Mar 2026Yadav General Store09DEFGH1234J6Z7Wheat 50kg25₹3,000
INV-10504 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Biscuits Box5₹3,100
INV-14104 Mar 2026Sharma Traders09ABCDE1234F1Z5Soap Carton5₹3,100
INV-17104 Mar 2026Agarwal Mart09XYZAB7890C5Z2Mustard Oil 15L10₹2,400
INV-20804 Mar 2026Chauhan Retail09QRSTU9012V8Z9Wheat 50kg10₹6,200
INV-28204 Mar 2026Verma Stores09LMNOP9012Q3Z4Rice 25kg10₹4,800
INV-15305 Mar 2026Gupta Enterprises09FGHIJ5678K2Z3Sugar 50kg10₹4,800
INV-15705 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Detergent 5kg5₹600
INV-24405 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Wheat 50kg10₹6,200
INV-24605 Mar 2026Singh Brothers09RSTUV3456W4Z1Sugar 50kg5₹1,750
INV-25205 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Biscuits Box5₹1,200
INV-26705 Mar 2026Sharma Traders09ABCDE1234F1Z5Detergent 5kg2₹480
INV-28905 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Tea 10kg20₹4,800
INV-12306 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Soap Carton50₹12,000
INV-16406 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Soap Carton50₹24,000
INV-19706 Mar 2026Verma Stores09LMNOP9012Q3Z4Sugar 50kg5₹3,100
INV-22506 Mar 2026Sharma Traders09ABCDE1234F1Z5Soap Carton10₹3,500
INV-23606 Mar 2026Gupta Enterprises09FGHIJ5678K2Z3Detergent 5kg50₹31,000
INV-12907 Mar 2026Agarwal Mart09XYZAB7890C5Z2Tea 10kg10₹3,500
INV-16607 Mar 2026Chauhan Retail09QRSTU9012V8Z9Tea 10kg10₹3,500
INV-18507 Mar 2026Sharma Traders09ABCDE1234F1Z5Soap Carton-5₹1,750
INV-21007 Mar 2026Yadav General Store09DEFGH1234J6Z7Detergent 5kg50₹12,000
INV-26107 Mar 2026Agarwal Mart09XYZAB7890C5Z2Rice 25kg-10₹1,200
INV-27007 Mar 2026Chauhan Retail09QRSTU9012V8Z9Soap Carton50₹12,000
INV-29407 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Tea 10kg50₹31,000
INV-10308 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Detergent 5kg10₹1,200
INV-11108 Mar 2026Yadav General Store09DEFGH1234J6Z7Sugar 50kg50₹6,000
INV-24908 Mar 2026Chauhan Retail09QRSTU9012V8Z9Mustard Oil 15L10₹4,800
INV-25708 Mar 2026Yadav General Store09DEFGH1234J6Z7Biscuits Box5₹4,250
INV-26908 Mar 2026Agarwal Mart09XYZAB7890C5Z2Wheat 50kg2₹1,700
INV-15809 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Biscuits Box10₹1,200
INV-17809 Mar 2026Singh Brothers09RSTUV3456W4Z1Mustard Oil 15L25₹3,000
INV-21409 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Sugar 50kg5₹4,250
INV-15510 Mar 2026Yadav General Store09DEFGH1234J6Z7Biscuits Box25₹15,500
INV-16810 Mar 2026Gupta Enterprises09FGHIJ5678K2Z3Mustard Oil 15L25₹21,250
INV-25410 Mar 2026Sharma Traders09ABCDE1234F1Z5Detergent 5kg5₹4,250
INV-26510 Mar 2026Agarwal Mart09XYZAB7890C5Z2Detergent 5kg25₹6,000
INV-28510 Mar 2026Chauhan Retail09QRSTU9012V8Z9Rice 25kg5₹2,400
INV-15611 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Biscuits Box5₹2,400
INV-16911 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Tea 10kg50₹17,500
INV-19111 Mar 2026Sharma Traders09ABCDE1234F1Z5Detergent 5kg25₹12,000
INV-19611 Mar 2026Sharma Traders09ABCDE1234F1Z5Rice 25kg10₹3,500
INV-20311 Mar 2026Agarwal Mart09XYZAB7890C5Z2Biscuits Box5₹1,200
INV-22211 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Wheat 50kg25₹8,750
INV-10712 Mar 2026Yadav General Store09DEFGH1234J6Z7Mustard Oil 15L10₹8,500
INV-13112 Mar 2026Singh Brothers09RSTUV3456W4Z1Soap Carton-5₹2,400
INV-22312 Mar 2026Agarwal Mart09XYZAB7890C5Z2Wheat 50kg10₹2,400
INV-23512 Mar 2026Yadav General Store09DEFGH1234J6Z7Sugar 50kg10₹1,200
INV-25912 Mar 2026Gupta Enterprises09FGHIJ5678K2Z3Mustard Oil 15L5₹3,100
INV-11013 Mar 2026Chauhan Retail09QRSTU9012V8Z9Detergent 5kg5₹1,750
INV-11813 Mar 2026Agarwal Mart09XYZAB7890C5Z2Tea 10kg50₹31,000
INV-12513 Mar 2026Verma Stores09LMNOP9012Q3Z4Rice 25kg25₹8,750
INV-12813 Mar 2026Singh Brothers09RSTUV3456W4Z1Wheat 50kg10₹6,200
INV-22013 Mar 2026Chauhan Retail09QRSTU9012V8Z9Biscuits Box5₹1,750
INV-26313 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Detergent 5kg25₹8,750
INV-28113 Mar 2026Yadav General Store09DEFGH1234J6Z7Sugar 50kg20₹12,400
INV-13614 Mar 2026Verma Stores09LMNOP9012Q3Z4Sugar 50kg2₹700
INV-14214 Mar 2026Yadav General Store09DEFGH1234J6Z7Wheat 50kg25₹15,500
INV-20914 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Sugar 50kg25₹21,250
INV-27414 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Biscuits Box5₹1,200
INV-28014 Mar 2026Chauhan Retail09QRSTU9012V8Z9Detergent 5kg50₹12,000
INV-10815 Mar 2026Verma Stores09LMNOP9012Q3Z4Biscuits Box10₹8,500
INV-13015 Mar 2026Sharma Traders09ABCDE1234F1Z5Wheat 50kg5₹3,100
INV-15015 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Rice 25kg-10₹1,200
INV-16015 Mar 2026Singh Brothers09RSTUV3456W4Z1Soap Carton20₹4,800
INV-16515 Mar 2026Agarwal Mart09XYZAB7890C5Z2Mustard Oil 15L50₹31,000
INV-17315 Mar 2026Chauhan Retail09QRSTU9012V8Z9Tea 10kg5₹600
INV-18015 Mar 2026Chauhan Retail09QRSTU9012V8Z9Wheat 50kg2₹960
INV-19815 Mar 2026Agarwal Mart09XYZAB7890C5Z2Soap Carton2₹960
INV-21715 Mar 2026Agarwal Mart09XYZAB7890C5Z2Rice 25kg2₹960
INV-27916 Mar 2026Sharma Traders09ABCDE1234F1Z5Soap Carton10₹4,800
INV-11417 Mar 2026Agarwal Mart09XYZAB7890C5Z2Sugar 50kg5₹4,250
INV-12017 Mar 2026Gupta Enterprises09FGHIJ5678K2Z3Mustard Oil 15L10₹8,500
INV-14417 Mar 2026Agarwal Mart09XYZAB7890C5Z2Soap Carton25₹8,750
INV-21617 Mar 2026Yadav General Store09DEFGH1234J6Z7Wheat 50kg50₹31,000
INV-23117 Mar 2026Singh Brothers09RSTUV3456W4Z1Tea 10kg5₹2,400
INV-23817 Mar 2026Yadav General Store09DEFGH1234J6Z7Wheat 50kg10₹4,800
INV-28417 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Detergent 5kg10₹2,400
INV-11718 Mar 2026Chauhan Retail09QRSTU9012V8Z9Sugar 50kg10₹6,200
INV-17218 Mar 2026Sharma Traders09ABCDE1234F1Z5Soap Carton5₹4,250
INV-11619 Mar 2026Singh Brothers09RSTUV3456W4Z1Wheat 50kg5₹4,250
INV-11919 Mar 2026Singh Brothers09RSTUV3456W4Z1Mustard Oil 15L2₹240
INV-18219 Mar 2026Verma Stores09LMNOP9012Q3Z4Biscuits Box50₹6,000
INV-20019 Mar 2026Yadav General Store09DEFGH1234J6Z7Soap Carton10₹1,200
INV-20619 Mar 2026Agarwal Mart09XYZAB7890C5Z2Biscuits Box20₹2,400
INV-22419 Mar 2026Agarwal Mart09XYZAB7890C5Z2Mustard Oil 15L25₹15,500
INV-23219 Mar 2026Yadav General Store09DEFGH1234J6Z7Biscuits Box25₹21,250
INV-28319 Mar 2026Yadav General Store09DEFGH1234J6Z7Tea 10kg10₹2,400
INV-15120 Mar 2026Chauhan Retail09QRSTU9012V8Z9Biscuits Box50₹12,000
INV-17520 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Mustard Oil 15L25₹12,000
INV-17920 Mar 2026Agarwal Mart09XYZAB7890C5Z2Soap Carton50₹6,000
INV-20120 Mar 2026Sharma Traders09ABCDE1234F1Z5Detergent 5kg10₹2,400
INV-21920 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Biscuits Box5₹4,250
INV-22820 Mar 2026Chauhan Retail09QRSTU9012V8Z9Detergent 5kg25₹8,750
INV-23920 Mar 2026Gupta Enterprises09FGHIJ5678K2Z3Biscuits Box50₹31,000
INV-24020 Mar 2026Yadav General Store09DEFGH1234J6Z7Detergent 5kg5₹600
INV-29120 Mar 2026Sharma Traders09ABCDE1234F1Z5Detergent 5kg10₹8,500
INV-12421 Mar 2026Sharma Traders09ABCDE1234F1Z5Rice 25kg5₹1,200
INV-20221 Mar 2026Verma Stores09LMNOP9012Q3Z4Wheat 50kg2₹700
INV-27521 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Sugar 50kg5₹2,400
INV-27721 Mar 2026Verma Stores09LMNOP9012Q3Z4Soap Carton5₹3,100
INV-12222 Mar 2026Sharma Traders09ABCDE1234F1Z5Wheat 50kg2₹960
INV-12622 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Detergent 5kg5₹1,200
INV-13222 Mar 2026Sharma Traders09ABCDE1234F1Z5Soap Carton5₹1,200
INV-14322 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Mustard Oil 15L20₹9,600
INV-14522 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Sugar 50kg10₹4,800
INV-14722 Mar 2026Verma Stores09LMNOP9012Q3Z4Wheat 50kg10₹6,200
INV-24222 Mar 2026Yadav General Store09DEFGH1234J6Z7Rice 25kg20₹2,400
INV-26822 Mar 2026Verma Stores09LMNOP9012Q3Z4Detergent 5kg20₹7,000
INV-13323 Mar 2026Singh Brothers09RSTUV3456W4Z1Tea 10kg10₹8,500
INV-13523 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Biscuits Box2₹240
INV-16223 Mar 2026Gupta Enterprises09FGHIJ5678K2Z3Soap Carton5₹3,100
INV-24123 Mar 2026Singh Brothers09RSTUV3456W4Z1Detergent 5kg50₹31,000
INV-27623 Mar 2026Yadav General Store09DEFGH1234J6Z7Mustard Oil 15L20₹12,400
INV-29023 Mar 2026Chauhan Retail09QRSTU9012V8Z9Soap Carton50₹6,000
INV-29323 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Mustard Oil 15L25₹15,500
INV-16724 Mar 2026Singh Brothers09RSTUV3456W4Z1Biscuits Box50₹31,000
INV-19524 Mar 2026Singh Brothers09RSTUV3456W4Z1Wheat 50kg25₹3,000
INV-23424 Mar 2026Agarwal Mart09XYZAB7890C5Z2Tea 10kg10₹3,500
INV-24824 Mar 2026Verma Stores09LMNOP9012Q3Z4Detergent 5kg2₹960
INV-25524 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Biscuits Box5₹1,750
INV-10625 Mar 2026Singh Brothers09RSTUV3456W4Z1Soap Carton5₹1,200
INV-11325 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Soap Carton20₹2,400
INV-13725 Mar 2026Yadav General Store09DEFGH1234J6Z7Biscuits Box5₹1,200
INV-15225 Mar 2026Agarwal Mart09XYZAB7890C5Z2Detergent 5kg10₹3,500
INV-15925 Mar 2026Sharma Traders09ABCDE1234F1Z5Rice 25kg10₹2,400
INV-17025 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Sugar 50kg-10₹2,400
INV-19025 Mar 2026Pandey Suppliers09WXYZA3456B9Z0Biscuits Box50₹17,500
INV-23025 Mar 2026Verma Stores09LMNOP9012Q3Z4Soap Carton10₹3,500
INV-25025 Mar 2026Chauhan Retail09QRSTU9012V8Z9Soap Carton25₹15,500
INV-12126 Mar 2026Singh Brothers09RSTUV3456W4Z1Detergent 5kg25₹6,000
INV-13826 Mar 2026Mishra Trading Co09KLMNO5678P7Z8Mustard Oil 15L10₹2,400
INV-26426 Mar 2026Agarwal Mart09XYZAB7890C5Z2Wheat 50kg25₹3,000
INV-27126 Mar 2026Gupta Enterprises09FGHIJ5678K2Z3Tea 10kg20₹17,000
INV-27226 Mar 2026Verma Stores09LMNOP9012Q3Z4Tea 10kg10₹1,200
INV-10927 Mar 2026Singh Brothers09RSTUV3456W4Z1Rice 25kg20₹9,600
INV-13927 Mar 2026Singh Brothers09RSTUV3456W4Z1Detergent 5kg20₹7,000
INV-20427 Mar 2026Agarwal Mart09XYZAB7890C5Z2Detergent 5kg10₹8,500
INV-21327 Mar 2026Singh Brothers09RSTUV3456W4Z1Mustard Oil 15L-20₹4,800
INV-26027 Mar 2026Verma Stores09LMNOP9012Q3Z4Detergent 5kg50₹42,500
INV-14028 Mar 2026Agarwal Mart09XYZAB7890C5Z2Wheat 50kg10₹3,500
INV-20528 Mar 2026Singh Brothers09RSTUV3456W4Z1Biscuits Box20₹2,400
INV-25128 Mar 2026Chauhan Retail09QRSTU9012V8Z9Tea 10kg5₹4,250
160 of 160 rows

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 register (160 verified rows). Your data gets the same treatment, ask for a free data audit.