How to Create a Budget Spreadsheet in Excel Identify Your Financial Goals. Determine Your Budget Period. Calculate Your Total Income. Begin Creating Your Excel Budget. Enter All Cash, Debit and Check Transactions Into the Budget Spreadsheet. Enter All Credit Transactions. Calculate Total Expenses From All Sources.