PETTY CASH BOOK FORMAT IN EXCEL

adminComment(0)

Template Cash book. A, B, C, D, E, F, G, H, I. 1, PETTY CASH REGISTER. 2, PROJECT NAME: FMT - Module 6 - Template for cash book. Download free and easy to use Petty Cash Book MS Excel Template for easy maintenance of daily expenses for any businesses. Download free Cash Book Template in Microsoft macawebsrilni.ga file for easy maintenance of cash transaction for businesses according to Indian Accounting System.


Petty Cash Book Format In Excel

Author:DOTTIE KUJALA
Language:English, Indonesian, Japanese
Country:Japan
Genre:Technology
Pages:403
Published (Last):02.05.2016
ISBN:150-8-70151-894-3
ePub File Size:29.75 MB
PDF File Size:11.20 MB
Distribution:Free* [*Registration needed]
Downloads:42951
Uploaded by: JEFFRY

5, This template enables users to control the expenses that are paid through any petty cash or cash float system. All petty cash expenses and reimbursements. Free Petty Cash Excel Template, our template is easy to use and will allow Most businesses run a cash book, but do not account for it, our petty cash template. Free excel cash book template for easy bookkeeping to track business income and This Cash Book has no Balance Sheet and no Cost of Goods Sold accounts. .. Loan Repayments; Asset downloads; Petty Cash; Credit Card Repayments.

Cash Book Template is an excel template with predefined formulas to help you record routine cash transactions of a company on a regular basis. Enter the transaction on the debit or credit side and it will automatically calculate the cash on hand for you.

Petty Cash Template

Cash book is the record of cash transaction done in a company on a day to day or regular basis. Cash book is just like a ledger account. There is no need to open a separate cash account in the ledger.

It is subsidiary ledger which records all kind cash receipts and cash payments including the bank deposits and withdrawals. At the end of the month, these transactions from cash book are posted to the general ledger.

Petty Cash Ledger Template Excel

The best-known practice of business is to weekly compare the bank related transaction with the bank statement or perform a bank reconciliation to avoid mismatch of balances. In big companies where there are high volumes of cash transactions, the cash book is subdivided into two different journals.

One is the receipt Journal and the other is the disbursement journal. In a smaller business as there are fewer transactions, all the cash transactions are maintained in a single cash book.

Petty Cash Book in Excel

Petty cash book is a type of cash book that is used to record minor regular expenditures such as office teas, bus fares, fuel, newspapers, cleaning, pins, and causal labor etc. These small expenditures are usually paid using coins and currency notes rather than checks.

The person responsible for spending petty cash and recording it in a petty cash book is known as petty cashier. He, therefore, usually delegates the responsibility for handling small day to day cash transactions to a bookkeeper, receptionist or some other reliable staff member.

Facebook Comments

Like a general cash book, a petty cash book has a debit and a credit side. All receipts are recorded on the debit side and all payments are recorded on the credit side of petty cash book by the petty cashier.

Petty cash systems The cash allocated for petty expenditures for a specific period is entered on the credit side of general cash book and on the debit side of petty cash book. The amount of Petty Cash on Hand is reflected in cell I2 by subtracting total expenses in cell E21 out of cash received from Chief Cashier in cell B See image below:.

B20 -SUM E4: Both the formulas reflect the same calculations. If the totals of outward exceed against the totals of inward then the Petty cash on hand will be negative. Using conditional formatting the amount in cells turns red whenever there is a negative balance. The Debit side has the date and cash received from Chief Cashier, whereas the Credit side has all types of petty expenses like stationaries and printing, postage, loading etc.

Petty cash book is a useful document to save time, as each payment that is made under a particular head is not posted into the ledger separately.

This posting of this periodic total is made with a single entry as Petty Expenses. We would like to express our gratitude to our viewers for encouraging us by liking and sharing our content on different social media platforms, especially facebook viewers.Petty Cash Book Format Download With this petty cash book template, you can easily track each expenses and analyze for reduce significantly.

As you know, the petty cash is normally using for the meet daily expenses of the office.

Save it to your documents or desktop - open and click on 'save as'. Please Also Check Our Templates: One bank account can be tracked per Cash Book. Posted in: Cash book explanations Besides maintaining a main or general cash book, many companies also maintain a small cash book known as petty cash book to record small day to day expenditures of the business.

Even, petty cash is sub-ledger of the main cash ledger.

What is Bookkeeping? Like a general cash book, a petty cash book has a debit and a credit side. Include fields for calculating a running balance and for recalculating this balance every time you withdraw or add to the fund.