To create an accounting spreadsheet in Excel, open a new file, and choose "blank workbook" from the available templates. Decide on the number of workbooks needed. Some people choose to make one workbook per table, while others use one sheet for expenses and one for income. One sheet can also calculate the balance with information such as tax owed.
Next, create headings for each data item, and add them in each column on the top row, representing the data listed below it. For example, on an income sheet, headings may include date, product, customer name and additional notes.
Next, you can insert income and expenses data. You can format columns by applying categories, such as currency, text or date. Use these options by choosing the launcher icon next to the number group in the home tab.
After that, you can apply calculations. To add numbers in cells, click and drag to select the values to be added and the empty cell beneath them. Then click on the AutoSum button in the editing group. To add the formula manually, type "=", followed by the cells you wish to encapsulate. For example, "=SUM(A2:A10)" adds the values between A2 and A10.
Finally, calculate accounting balances. If tables are spread across different worksheets, use a new worksheet for the balance. You can calculate these numbers using the data in income and expenses tables, and taxation calculations if desired. For example, select a cell in the balance sheet, and type "=". Then select the total income cell from the income sheet. Next, type "-", and click the total expense cell from the expense sheet. Click enter, and the total balance appears in the new sheet.