Download a free Cash Book Format Excel Sheet Template to easily record and manage daily cash transactions. This ready-to-use Excel template helps you track cash receipts, cash payments, transaction dates, descriptions, opening balance, closing balance, and daily cash balances in a simple and organized format. It is useful for businesses, shops, offices,and individuals who want to maintain accurate cash records and monitor their cash flow efficiently.
Key Features :
- S.No.
- Date
- Voucher No.
- Particulars
- Category
- Reference
- Cash In
- Cash Out
- Balance
- Status
- Remarks
Formulas :
- Total Cash In =SUM(‘Cash Book’!G5:G102)
- Total Cash Out =SUM(‘Cash Book’!H5:H102)
- Net Cash Flow =B4-B5
- Closing Cash Balance =IFERROR(LOOKUP(2,1/(‘Cash Book’!I5:I102<>””),’Cash Book’!I5:I102),0)
- Cleared Transactions =COUNTIF(‘Cash Book’!J5:J102,”Cleared”)
- Pending Transactions =COUNTIF(‘Cash Book’!J5:J102,”Pending”)
- Cancelled Transactions =COUNTIF(‘Cash Book’!J5:J102,”Cancelled”)
- Balance Formula =I5+G6-H6
