www.MSOfficeGeek.

co
Petty Cash Book Template (Excel, OpenOffice Calc &

Company Name
Petty Cash Book For the month of
Debit Credi
Date Description CBN Amount Date
1/2/2021 Opening Balance R-1-21-1 $8,000.00 1/3/2021
1/4/2021
1/5/2021
1/6/2021
1/7/2021
1/8/2021
1/9/2021
1/10/2021
1/11/2021
1/12/2021
1/13/2021
1/14/2021
1/15/2021

Petty Cash Issued $8,000.00 Petty Cas

Actual Petty Cash on Hand $2,850.00 Petty Ca
Reconciliation Difference $0.00 Reconcilia
fficeGeek.com
, OpenOffice Calc & Google Sheet)

me
Jan-21
Credit
Description VN Amount
Courier 123 $50.00
Office Pantry 124 $500.00
Stationary 125 $200.00
Travelling Expenses 126 $350.00
Office Equipment Repair 127 $800.00
Telephone Bill 128 $300.00
Fuel (Office Vehicle) 129 $200.00
Office Pantry 130 $200.00
Office Equipment Repair 131 $1,200.00
Travelling Expenses 132 $100.00
Fuel (Office Vehicle) 133 $100.00
Stationary 134 $150.00
Advertising (Banners) 135 $1,000.00

Petty Cash Expenses $5,150.00

Petty Cash on Hand $2,850.00
Reconciliation Status Reconciled
 Printable Petty Cash Book Format
Company Name
Petty Cash Book For the month of
Debit Credi
Date Description CBN Amount Date

Petty Cash Issued Petty C

Actual Petty Cash on Hand Petty C
Reconciliation Difference Reconci
Book Format
me

Credit
Description VN Amount

Petty Cash Expenses

Petty Cash on Hand
Reconciliation Status
 www.MSOffi
Imprest Petty Cash Book Template (Ex
Company Name
Petty Cash Book For the month of
Imprest Cash Amount
Debit
Date CBN Receipts Date Description VN Payments
1/2/2021 R211 $8,000 1/3/2021 Courier 123 $50.00
1/4/2021 Pantry 124 $500.00
1/5/2021 Stationary 125 $200.00
1/6/2021 Travelling 126 $350.00
1/7/2021 Repair 127 $800.00
1/8/2021 Telephone 128 $300.00
1/9/2021 Fuel 129 $200.00
1/10/2021 Pantry 130 $200.00
1/11/2021 Repair 131 $1,200.00
1/12/2021 Travelling 132 $100.00
1/13/2021 Fuel 133 $100.00
1/14/2021 Stationary 134 $150.00
1/15/2021 Advertising 135 $1,000.00

Petty Cash Issued $8,000 Petty Cash Expenses $5,150

Actual Petty Cash on Hand $2,800 Petty Cash on Hand $2,850
Reconciliation Difference -$50 Reconciliation Status Deficit

Petty Cash Analysis

$2500.000

$2000.000

$1500.000
Amount

$1000.000

$500.000

$.000
ier ry ry in
g ir ne el in
g
ur nt na ell epa ho Fu tis
Co Pa ati
o v R p r
St Tr
a le ve
Te Ad
Amount
$1000.000

$500.000

$.000
ier ry ry in
g ir ne el in
g
ur nt na ell epa ho Fu tis
Co Pa ati
o v R p r
St Tr
a le ve
Te Ad
Expenses
w.MSOfficeGeek.com
Template (Excel, OpenOffice Calc & Google Sheet)
Company Name
Jan-21
$8,000
Credit
Courier Pantry Stationary Travelling Repair Telephone Fuel
$50
$500
$200
$350
$800
$300
$200
$200
$1,200
$100
$100
$150

$50 $700 $350 $450 $2,000 $300 $300

Courier Pantry Stationary Travelling Repair Telephone Fuel
$50 $700 $350 $450 $2,000 $300 $300
Advertising

$1,000

$1,000
Advertising
$1,000
 Printable Imprest Petty Ca
Company Name
Petty Cash Book For the month of
Imprest Cash Amount
Debit
Date CBN Receipts Date Description VN Payments

Petty Cash Issued Petty Cash Expenses

Actual Petty Cash on Hand Petty Cash on Hand
Reconciliation Difference Reconciliation Status
rest Petty Cash Book Format
Company Name

Credit
Courier Pantry Stationary Travelling Repair Telephone Fuel
Advertising
 Petty Cash Voucher

Date:

Description

Total

Paid To

Petty Cashier
Amount