The greater part of these exceeds expectations accounting layouts are anything but difficult to tweak to your prerequisites. Excel is an incredible and fantastic spreadsheeting plan and if you already have it on your PC, you already have the means to begin your bookkeeping. In a similar fashion as in Step 3, create another drop-down list for the category column.Bookkeeping Excel Template For Small Business: These bookkeeping templates or spreadsheets can be utilized by anybody & any small business.Record them well and create 3 more columns: Category, Type, and Amount.For example, We have performed the following transactions from Dec 20, 2022, to Jan 4, 2023.In this sheet, we will list all the transactions we have performed in a certain time span.Now, we will create a new sheet, and name it Transaction sheet.Read More: How to Create a Cash Book in Excel Note that these categories are not fixed, modify this column according to your business types and other things suitable for you. Now, choose a suitable account type for each of the categories, and add your own explanation.Now, just drag the fill handle icon down to copy this drop-down list in the cells below.As a result, a drop-down list will be created like the following image.From the Data Validation window, go to the Settings section, and then select List in the Allow box.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |