Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Authentication
digital resources
280x Filetype XLSX File size 0.05 MB Source: msofficegeek.com
Sheet 1: Petty Cash Book
| www.MSOfficeGeek.com | ||||||||
| Petty Cash Book Template (Excel, OpenOffice Calc & Google Sheet) | ||||||||
| Company Name | ||||||||
| Petty Cash Book For the month of | Jan-21 | |||||||
| Debit | Credit | |||||||
| Date | Description | CBN | Amount | Date | Description | VN | Amount | |
| 1/2/2021 | Opening Balance | R-1-21-1 | $8,000.00 | 1/3/2021 | Courier | 123 | $50.00 | |
| 1/4/2021 | Office Pantry | 124 | $500.00 | |||||
| 1/5/2021 | Stationary | 125 | $200.00 | |||||
| 1/6/2021 | Travelling Expenses | 126 | $350.00 | |||||
| 1/7/2021 | Office Equipment Repair | 127 | $800.00 | |||||
| 1/8/2021 | Telephone Bill | 128 | $300.00 | |||||
| 1/9/2021 | Fuel (Office Vehicle) | 129 | $200.00 | |||||
| 1/10/2021 | Office Pantry | 130 | $200.00 | |||||
| 1/11/2021 | Office Equipment Repair | 131 | $1,200.00 | |||||
| 1/12/2021 | Travelling Expenses | 132 | $100.00 | |||||
| 1/13/2021 | Fuel (Office Vehicle) | 133 | $100.00 | |||||
| 1/14/2021 | Stationary | 134 | $150.00 | |||||
| 1/15/2021 | Advertising (Banners) | 135 | $1,000.00 | |||||
| Petty Cash Issued | $8,000.00 | Petty Cash Expenses | $5,150.00 | |||||
| Actual Petty Cash on Hand | $2,850.00 | Petty Cash on Hand | $2,850.00 | |||||
| Reconciliation Difference | $0.00 | Reconciliation Status | Reconciled | |||||
| Printable Petty Cash Book Format | ||||||||
| Company Name | ||||||||
| Petty Cash Book For the month of | ||||||||
| Debit | Credit | |||||||
| Date | Description | CBN | Amount | Date | Description | VN | Amount | |
| Petty Cash Issued | Petty Cash Expenses | |||||||
| Actual Petty Cash on Hand | Petty Cash on Hand | |||||||
| Reconciliation Difference | Reconciliation Status | |||||||
| www.MSOfficeGeek.com | |||||||||||||||
| Imprest Petty Cash Book Template (Excel, OpenOffice Calc & Google Sheet) | |||||||||||||||
| Company Name | |||||||||||||||
| Petty Cash Book For the month of | Jan-21 | ||||||||||||||
| Imprest Cash Amount | $8,000 | ||||||||||||||
| Debit | Credit | ||||||||||||||
| Date | CBN | Receipts | Date | Description | VN | Payments | Courier | Pantry | Stationary | Travelling | Repair | Telephone | Fuel | Advertising | |
| 1/2/2021 | R211 | $8,000 | 1/3/2021 | Courier | 123 | $50.00 | $50 | ||||||||
| 1/4/2021 | Pantry | 124 | $500.00 | $500 | |||||||||||
| 1/5/2021 | Stationary | 125 | $200.00 | $200 | |||||||||||
| 1/6/2021 | Travelling | 126 | $350.00 | $350 | |||||||||||
| 1/7/2021 | Repair | 127 | $800.00 | $800 | |||||||||||
| 1/8/2021 | Telephone | 128 | $300.00 | $300 | |||||||||||
| 1/9/2021 | Fuel | 129 | $200.00 | $200 | |||||||||||
| 1/10/2021 | Pantry | 130 | $200.00 | $200 | |||||||||||
| 1/11/2021 | Repair | 131 | $1,200.00 | $1,200 | |||||||||||
| 1/12/2021 | Travelling | 132 | $100.00 | $100 | |||||||||||
| 1/13/2021 | Fuel | 133 | $100.00 | $100 | |||||||||||
| 1/14/2021 | Stationary | 134 | $150.00 | $150 | |||||||||||
| 1/15/2021 | Advertising | 135 | $1,000.00 | $1,000 | |||||||||||
| Petty Cash Issued | $8,000 | Petty Cash Expenses | $5,150 | $50 | $700 | $350 | $450 | $2,000 | $300 | $300 | $1,000 | ||||
| Actual Petty Cash on Hand | $2,800 | Petty Cash on Hand | $2,850 | Courier | Pantry | Stationary | Travelling | Repair | Telephone | Fuel | Advertising | ||||
| Reconciliation Difference | -$50 | Reconciliation Status | Deficit | $50 | $700 | $350 | $450 | $2,000 | $300 | $300 | $1,000 | ||||
no reviews yet
Please Login to review.
