HOW TO CREATE CASHBOOK IN EXCEL ABOUT THE VIDEO:
In this video, we have created a cash book in excel by using the table in excel and using the if function row function sum function and sum if function in excel. It a good idea to create a cash book where we have both credit and debit balances and total cash and bank summary.
One of the major advantages of the cash book format for Excel: The program offsets the items directly with each other and automatically displays the current balance. What are the Components of a Salary Slip?
Our example is fully working so you can download it and enter your figures to get used to using the spreadsheet before implementing it for your own business.
Â
Select the table and convert into table by pressing CRTL + TÂ
Tick my table has a header
Delete colum in between and change name date 2 to date space similary to particular cash and bank with space in credit side to make them unique
