Similarly, when cash is paid out the same is recorded on the credit or right hand side of the cash book. You or your petty cash cashier must also create journal entries showing what petty cash funds go toward. Have our partners at excelchat fix your formulas, 247. During the month of april 2016, following disbursement were made from cash fund. For this purpose, a petty cashier is appointed by the chief cashier. When the petty cash fund gets too low, you must refill it to its set amount. Create a petty cash account and write out a cheque for the appropriate amount. Then, create another journal entry debiting the petty cash account and crediting the cash account. Petty cash financial accounting simple book production. Petty cash book is an accounting book used for recording expenses which are small and of little value, for example, stamps, postage and handling, stationery, carriage, daily wages, etc these are expenses which are incurred day after day.
Petty cash accounting involves establishing a petty cash policy, setting up a petty cash log, creating journal entries, and reconciling the petty cash account. The is only one money column on the debit side and all sum received from time to time by the petty cashier from the chief cashier are entered in it. The cash book is updated from original accounting source documents, and is therefore a book of prime entry and as such, can be classified as a special journal unlike other special journals such as the purchases journal or the sales journal, the cash ledger book records debit and credit entries. Petty cash helps your company in carrying out daily operations in an efficient manner, while there is no need to withdraw cash from the company accounts. Place the petty cash into the box and create an accounting journal to record petty cash transactions.
Smaller companies or companies that will seldom use petty cash can skip this step, but be sure to enter the general journal entries when it is time to reconcile the petty cash. Most businesses use petty cash for this, monitoring payments in a petty cash book. Keep a book of petty cash to record the purchases you make with your petty cash fund. A business uses a petty cash account for tracking physical cash used to make small payments. Simply can say pocket money for offices minor expenses. Start your book by recording each and every expense and the purpose for which the fund was utilized. Youll need to nominate a petty cash manager, typically an accountant, bookkeeper or other supervisor to oversee operations and collect receipts, if necessary.
Subtract this amount from the calculated amount of cash withdrawn. When you move cash from your bank account into petty cash, you should see it in this account. Nsf check, deposit in transit, interest paid by bank. Petty cash book is a readytouse excel template to systematically record and manage your petty or small daily routine payments. Write the current date, dr debit and petty cash at the top.
The bookkeeping master believes it is time for another excel tutorial, this time the tutorial being on how to create a petty cash account using excel petty cash refers to a small amount of physicaltangible cash that is kept by a business for small expenses. Petty cash book is a type of cash book, which use to record small amount of receipts and payment. A petty cash book is generally maintained on a columnar basis a separate column being allotted for each type of expenditure. The person who is responsible for the recording the receipts and the payments is known as the petty cashier. Process to create petty cash ac in tally soft ware. Select the items below that would cause the bank statement balance to differ from the depositors book balance.
At the end of the month petty cash book receipt and payment column is totaled and balanced here total payments are balance cd i. Scroll down to step 2 below for a completed example. Record and monitor all cash on hand transactions with this petty cash book template. How to set up and maintain a petty cash account basic.
For instance, if you want to purchase espresso for the workplace coffeemaker or paying tolls or stopping meters, petty. Managing a petty cash account for your small business. Cash book is a book of original entry in which transactions relating only to cash receipts and payments are recorded in detail. Purchase a petty cash box and decide where you are going to keep it. Petty cash meaning, examples accounting for petty cash. Make a list of expenditures from the petty cash account as you make them. Create a petty cash log sometimes called a petty cash book and petty cash request form sometimes called a petty cash voucher. Download cash book excel template 5 types of cash book templates with predefined formulas to help you record routine cash transactions of a company regularly. This cashbook can be adjusted to suit your financial yearend and is. Petty cash book template excel software accountant. We make entries to the petty cash account only when the fund is established or when the amount of the fund is changed or when the fund is closed and we want to add back cash in exchange for the petty cash vouchers. A petty cash book can either be a simple petty cash book or an analytical petty cash book.
How to create petty cash account with excel youtube. Cash book definition, example and format of cash book. The cash can be kept in a small safe or locked file cabinet, perhaps in an manila envelope. Write cr credit and petty cash next and write the same amount as the amount of cash you placed into. Petty cash book is maintained to record small expenses such as postage, stationery, telegram. Petty cash is often used for meeting refreshments, reimbursing an employee for office supplies she purchased, or other miscellaneous expenses that require payments in cash or coin. Write the amount of the check you wrote for petty cash after this entry. The columns in your spreadsheet can include, but wont necessarily be limited to. The petty cash book is to enter how the cash available for daily expenses are spent for example milk, tea, taxi charges and.
From the detail type dropdown, choose cash on hand. Accounting can be done manually or made easier with bookkeeping software and employee expense. Petty cash accounting procedures reconciliation uses. The petty cash book is a formal summarization of petty cash expenditures, sorted by date. Large businesses maintain petty cash book to reduce the burden of main cash book. Buy blank cash vouchers from the stationary store and keep them in the same set. These small expenditures are usually paid using coins and currency notes rather than checks. Most of the companies are using this accounting tool to kept the sufficient amount of money at office to buying small things that are require. Also included as a part of cash are the balances kept at banking and financial institutions.
Every time you make a purchase, make a note in the book that includes date, amount your spend and the nature of purchase. The petty cash book will be maintained by a separate cashier known as petty cashier in the accounting field. Journal entry for removing money from the petty cash fund. The difference between the total of the debit items and that of the total column on the credit represents the balance of the petty cash in hand. Keep petty cash purchases small, for expenses like postage, parking meters or party supplies. A column for any cash withdrawals, a column for checks which have been written from the petty cash account, a column to document the purpose of any expenses and. There are two primary types of entries in the petty cash book, which are a debit to record cash received.
Create a petty cash log sometimes called a petty cash book and petty cash request form. A separate column is allotted for each type of expenditure. Keep this log readily available so you can fill it in on a regular basis taking the information off the petty cash vouchers. Keep the petty cash book and box or tin in a safe place, such as the accountants or managers office or cubicle.
Prepare a blank petty cash log utilizing a small book or you can use this free pdf template. 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. Each employee wishing to make a purchase should go through this representative, rather than leaving the. The cash book is a chronological record of the receipts and payments transactions for a business. Download petty cash book excel template exceldatapro. Simple steps to create dynamic petty cash book with ms excel. If there is a residual balance, then there is a cash overage in the fund. Youll also want to purchase a lock box for the cash and receipts. Petty cash book explanation, format, example, ordinary. A petty cash is a cash book used to enter all small or petty expenses obtained.
An imprest system of petty cash means that the general ledger account petty cash will remain dormant at a constant amount. This excel cash book is suitable for any small business that wants an easy bookkeeping method a simple way to track your income and expenses. Start maintaining a general ledger in which to keep track of the petty cash and petty cash related expenses. Petty cash is easy to steal, so make sure you protect it. Thus, the book is part of a manual recordkeeping system. Do occasional audits, checking to see that transactions are. Cash the cheque and create your first petty cash fund. For smallscale business, simple petty cash book is sufficient but on a medium or large scale business number of petty expenses increases hence it is desirable to have the separate record for each type of petty expenses. Petty cash book definition, types, format, examples. This template includes date, receipt, description, deposits, and withdrawals. These expenses generally include purchases like refreshments, postage, subsistence and minor stationery expenses. The simple petty cash book has only two amount columns. The receipt column is used to record the opening balance. The credit side consists of several analysis columns.
In a imprest system, a cashier is provided a small amount to meet the petty expenses of a given period and is authorized to make such payments and to record them in a separate cash book. Enter the date and cash value for the opening balance to get a summary with updated cash balance in real time. Cash includes currency and coins, although most businesses do not keep much of this type of cash around. In the company, the petty cash book is usually maintained by the administrative department of the company as the accounts departments are usually occupied by the larger business transactions and also the admin department is only responsible for such kind of expenses. Do not leave it in a common area, such as the lunchroom or meeting area. In most cases, the petty cash book is an actual ledger book, rather than a computer record. Keep the petty cash box in a secure location, known only to one or two people. The cash book is 100% free for you to download and use forever, and it is fully customizable so you can change anything in it. Separate duties, so the person who is recording transactions is different from the person putting the transactions into your accounting system.
Petty cash book template is different from other company financial documents. To account for petty cash, create a transaction log that covers the date, the person who used the petty cash, a description of the transaction, and any other deposits or expenses. Add up the total expenditure listed on each petty cash voucher in the petty cash fund the information can also come from the petty cash book. To analyzing the individual payments you have to just total individual expenses columns. It is another cash book which is maintained, generally, in large business concerns to reduce the burden of main cash book, in which numerous transactions involving petty small amounts are recorded. Petty cash book format example definition explanation. Attached to that list should be receipts for each expenditure. Enter the transaction on the debit or credit side and it will automatically calculate the cash on hand for you.
500 196 524 42 1424 738 398 263 513 1473 435 1265 1374 777 586 262 32 422 271 479 902 220 1279 1196 1311 484 1061 638 266 384 735 250 1214 1520 686 635 641 145 1066 86 768 641 255 643 73 1249 1252 856 1365 1174