HOW TO CREATE CASH BOOK IN EXCEL

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.

 

Cash book in excel

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

cash book format
6 views

Leave a Reply

Your email address will not be published.