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.