Download a free Company Expenses Excel Sheet to easily record, organize, and manage business expenses. This ready-to-use Excel template helps you track expense dates, expense categories, descriptions, payment methods, amounts, departments, and monthly expense totals in a simple and structured format. It is useful for
businesses and companies to monitor spending, control expenses, maintain accurate financial records, and analyze overall expense patterns.
Key Features :
S.No.
Expense Date
Expense Category
Description
Vendor / Payee
Department
Payment Method
Invoice / Ref No.
Amount Before Tax
Tax %
Tax Amount
Total Amount
Payment Status
Remarks
Dashboard
Formulas :
- Balance = I7*J7
- Total Amount = I7+K7
- Marketing =SUMIF(‘Company Expenses’!C7:C105,A13,’Company Expenses’!L7:L105)
- Software =SUMIF(‘Company Expenses’!C7:C105,A14,’Company Expenses’!L7:L105)
- Maintenance =SUMIF(‘Company Expenses’!C7:C105,A15,’Company Expenses’!L7:L105)
- Professional Fees =SUMIF(‘Company Expenses’!C7:C105,A16,’Company Expenses’!L7:L105)
- Insurance =SUMIF(‘Company Expenses’!C7:C105,A17,’Company Expenses’!L7:L105)
- Marketing =SUMIF(‘Company Expenses’!F7:F105,D13,’Company Expenses’!L7:L105)
- Operations =SUMIF(‘Company Expenses’!F7:F105,D14,’Company Expenses’!L7:L105)
