How to Set Up Basic Bookkeeping in Excel

Techwalla may earn compensation through affiliate links in this story.
Keeping good books helps your business to run smoothly.

Microsoft Excel is powerful spreadsheet software that you can use to keep track of your business expenses and income. Setting up bookkeeping in Excel can seem like a daunting task, with dozens of factors to consider when setting up the worksheet. Instead of guessing about which items to include in your books -- and possibly missing important information -- use a ready made Excel template with multiple worksheets to track your business's profit and loss over time.


Step 1

Navigate to the Microsoft Templates website at and then type "expense income template" into the Search text box.

Video of the Day

Step 2

Click "All Products" and then click the "Excel" radio button.


Step 3

Click "Search." A list of results will appear.

Step 4

Mouse over "Expense Income template" and then click "Download."

Step 5

Open Microsoft Excel.


Step 6

Click the "File" tab and then click "New."

Step 7

Click "My Templates" and then click "Browse" to locate the template you downloaded in Step 4.


You can also download a template from within Excel. Instead of navigating to the Microsoft Templates website, click "File," then click "New" and then click " Templates" to search the online template library.