Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Authentication
digital resources
568x Filetype XLSX File size 0.08 MB Source: msofficegeek.com
Sheet 1: Simple Cash Book
| www.MSOfficeGeek.com | |||||||
| Simple Cash Book Template (Excel, OpenOffice Calc & Google Sheet) | |||||||
| Company Name | |||||||
| Cash Book For the Month Of | Jan-21 | ||||||
| Cash Inflow | Cash Outflow | ||||||
| Date | Transaction Details | Amount | Date | Transaction Details | Amount | ||
| 1/1/2021 | Balance C/F | $25,000 | 1/5/2021 | Sundar Bros | $15,000 | ||
| 1/2/2021 | Sales | $5,000 | 1/15/2021 | Stationary | $5,000 | ||
| 1/20/2021 | Raj Tours | $10,000 | |||||
| Total Income | $40,000 | Total Expenditures | $20,000 | ||||
| Cash Book Summary | |||||||
| Cash Inflow | $40,000 | Actual Cash | $19,500 | ||||
| Cash Outflow | $20,000 | Difference | ($500) | ||||
| Closing Balance | $20,000 | ||||||
| www.MSOfficeGeek.com | |||||||
| Printable Simple Cash Book Template | |||||||
| Company Name | |||||||
| Cash Book For the Month Of | |||||||
| Cash Inflow | Cash Outflow | ||||||
| Date | Transaction Details | Amount | Date | Transaction Details | Amount | ||
| Balance C/F | |||||||
| Total Income | Total Expenditures | ||||||
| Cash Book Summary | |||||||
| Cash Inflow | Actual Cash | ||||||
| Cash Outflow | Difference | ||||||
| Closing Balance | |||||||
| www.MSOfficeGeek.com | |||||||||||
| Cash Book With Discount (Excel, OpenOffice Calc & Google Sheet) | |||||||||||
| Company Name | |||||||||||
| Cash Book For the Month Of | Jan-21 | ||||||||||
| Cash Inflow | Cash Outflow | ||||||||||
| Date | Transaction Details | Invoice Amont | Discount | Amount | Date | Transaction Details | Invoice Amont | Discount | Amount | ||
| 5% | |||||||||||
| 1/1/2021 | Opening Balance | $25,000 | 1/5/2021 | Kamdev Traders | $15,000 | $1,500 | $13,500 | ||||
| 1/2/2021 | Cash Sale | $5,000 | $250 | $4,750 | 1/15/2021 | Stationary | $5,000 | $0 | $5,000 | ||
| 1/20/2021 | Sakhi Electronics | $10,000 | $500 | $9,500 | 1/20/2021 | ||||||
| Totals | $750 | $39,250 | Totals | $1,500 | $18,500 | ||||||
| Cash Book Summary | |||||||||||
| Cash Inflow | $39,250 | Closing Balance | $20,750 | ||||||||
| Cash Outflow | $18,500 | Actual Cash in Hand | 21000 | ||||||||
| Discount Allowed | $750 | Difference | ($250) | ||||||||
| Discount Received | $1,500 | ||||||||||
no reviews yet
Please Login to review.
