Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 7 views

    Petty Cash Book Excel Template 1

    Uploaded by

    MulyanaSalwaYusna

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Petty Cash Book Excel Template 1

    Uploaded by

    MulyanaSalwaYusna
    7 views13 pages

    Original Title

    Petty-Cash-Book-Excel-Template-1

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    7 views13 pages

    Petty Cash Book Excel Template 1

    Uploaded by

    MulyanaSalwaYusna

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 13

    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

    You might also like