How to Make a Basic Bookkeeping Spreadsheet in Excel

Written by elizabeth falwell
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make a Basic Bookkeeping Spreadsheet in Excel
Bill Gates founded Microsoft, the company that manufactures the Excel program. (Sean Gallup/Getty Images News/Getty Images)

Excel is part of Microsoft Office's productivity suite, a line of software that also includes programs such as Word, PowerPoint and Outlook. Microsoft released its most recent version of Office -- and Excel -- in 2010. The Excel program gives you access to spreadsheets and all the tools you need to make computations therein. Excel's spreadsheets are a good fit for book-keepers looking for an easy-to-use software program for keeping track of their individual or a company's finances.

Skill level:
Moderately Easy


  1. 1

    Examine your personal or business finances to determine the best way to use Excel. Different options are keeping track of accounts receivable and payable, including payroll, rent or utilities and any raw materials used in the production process.

  2. 2

    Open Excel on your computer and create a new spreadsheet by clicking on the blank page icon at the top left of your screen.

  3. 3

    Orient yourself with Excel's format. The page is made up of a grid which creates boxes. Information can be typed into each box.

  4. 4

    Title the headings for your spreadsheet's rows and columns. For example, you may choose to use the first column to list all the dates in a given month, the second column to list any accounts receivable transactions and the third column to list any accounts payable transactions.

  5. 5

    Fill in the information into the appropriate boxes. For example, if you or your company paid out £9,750 in payroll checks on the first of the month, you would write "15,000" in the corresponding box.

  6. 6

    Add the total dollar amounts from each column -- in our example, you'd have a total for accounts receivable and a total for accounts payable. You can also calculate average expenditures and profits by selecting the "Subtotals" option from the drop-down box under the "Data" tab.

  7. 7

    Sort information from high to low or low to high by clicking on the "Sort" option from the drop-down box under the "Data" tab; this gives you the option of seeing which entries had the highest or lowest values.

Tips and warnings

  • Check all entries you make to an Excel spreadsheet. While the program will correctly compute your entries, it cannot be responsible for your typos.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.