# How to Create Daily Cash Book Format in Excel: 4 Easy Method

### Method 1 – Create Daily Cash Book Header

Enter the heading of a cash book such as Daily Cash Book Format, Cash Inward, Cash Outward, Transaction date, Transaction Details, Transaction Amount, etc.

### Method 2 – Make Cash Inflow Format

Input the cash inward details; Transaction date, Transaction Details, and Transaction Amount. The cash inward is the income of the XYZ group. Enter several types of Transactions in the Transaction Details column.

### Method 3 – Create Cash Outflow Format

Input the cash outward details; Transaction date, Transaction Details, and Transaction Amount. The cash outward is the expenses of the XYZ group. Enter several types of Transactions in the Transaction Details column which has been given in the below screenshot.

### Method 4 – Make Summary of Daily Cash Book Format

Create a summary of the daily cash book using the SUM function and Mathematical formula.

• Select cell; write down the SUM function in that cell. The SUM function is,
`=SUM(D6:D14)`
• Press Enter on your keyboard. Get the total Cash Inward of the XYZ group which is the return of the SUM function. The total Cash Inward is \$95,000.00.

• Write down the SUM function in cell D17.
`=SUM(H6:H14)`
• Press Enter on your keyboard. Get the total Cash Outward of the XYZ group which is the return of the SUM function. The total Cash Outward is \$80,000.00.

• Write down the Mathematical Subtraction formula in cell D18 to calculate the Closing Balance.
`=D16-D17`
• D16 is the total Cash Inward and D17 is the total Cash Outward.
• Press Enter on your keyboard. Get the Closing Balance. The Closing Balance is \$15,000.00.

• Write down the Mathematical formula in cell H18 to calculate the Actual Balance.
`=H16+H17`
• H16 is the Closing Balance and H17 is the Fixed Balance.
• Press Enter on your keyboard. As a result, you will get the Actual Balance. The Actual Balance is \$14,500.00.
• Create a daily Cash Book format.

## Bottom Line

#N/A! error arises when the formula or a function in the formula fails to find the referenced data.

#DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.

<< Go Back to Excel Cash Book Templates | Accounting Templates | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

1. what is a faxed Balance

Md. Abdur Rahim Rasel Jun 21, 2023 at 12:21 PM

Hello, SAJNA!