How to Create a Formula for Income & Expenses in Excel. Income and expense spreadsheets can be useful tools to help you see where your personal or business finances stand.