How to Create an Accounting Spreadsheet. ... In the "Available Templates" section, choose "Blank Workbook" to begin. Decide how many worksheets you want to use for your accounts.