How to Make a Basic Bookkeeping Spreadsheet in Excel

Updated March 23, 2017

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.

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.

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

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

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.

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.

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.

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.


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

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Elizabeth Falwell has been writing for the TV news industry since 2005. Her work has appeared on WXII 12 News, WMGT 41 News, and multiple parenting blogs. A graduate of the S.I. Newhouse School at Syracuse University, Falwell holds a Master of Science in broadcast journalism.