Petty cash book excel template petty cash funds have been around for a long time as a quick method of providing funds to employees that need to make a purchase for a company. How to create petty cash account with excel youtube. The specimen performa of a simple cash book is given as follows. The receipts are recorded in the dr side and the payments are recorded in the cr side of the cash book. Petty cash book is a type of cash book that is used to record minor regular expenditures such as office teas, bus fares, fuel. The credit side consists of several analysis columns. So, the book, wherein day to day petty expenses for a particular period of a business concern, are recorded in chronological order of dates is called petty cash book. As employees use petty cash, they should keep a log of what expenses the petty cash was used for and how much was used. The petty cash book is a formal summarization of petty cash expenditures, sorted by date. It is very identical to a traditional cash account in which all cash receipts are recorded on left hand debit. This is to constantly monitor how much cash is left in the funds and should a request to replenish the petty cash fund should be done. Do not leave it in a common area, such as the lunchroom or meeting area.
For this purpose, a petty cashier is appointed by the chief cashier. The person who is responsible for the recording the receipts and the payments is known as the petty cashier. These tools can be used to gauge your knowledge of what these funds can. The petty cash book is a book of vouchers which are made each time an expense is made from petty cash money. Manage cash going in and out using our very simple accounting book for petty cash. Cash includes currency and coins, although most businesses do not keep much of this type of cash around. Thus, the book is part of a manual recordkeeping system. Petty cash book is a type of cash book, which use to record small amount of receipts and payment. Adams petty cash 2part carbonless receipts book, 2. Always the voucher would show the amount, purpose, recipient, general ledger account number and date relating to the expenses. Petty cash book is a readytouse excel template to systematically record and manage your petty or small daily routine payments. Also included as a part of cash are the balances kept at banking and financial institutions.
Free download excel petty cash book template exceltemple. Have our partners at excelchat fix your formulas, 247. In most cases, the petty cash book is an actual ledger book, rather than a computer record. Format of the petty cash book bookkeeping debits and credits.
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 helps your company in carrying out daily operations in an efficient manner, while there is no need to. 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 the petty cash book is defined as relatively small amount of cash kept at hand for making quick payments for miscellaneous small expenses in the business concern. Enter the following transactions in the petty cash book of sonia manzoor. This template includes date, receipt, description, deposits, and withdrawals. Click here to download simple cash book excel template. Petty cash funds are routine expenses that involve the insignificant amounts of money not eligible for credit card and cheque payments. The following cash book examples provide an outline of the most common cash books. Petty cash book is maintained to record small expenses such as postage, stationery, telegram. More importantly, you need a record book for documentation of each transaction. Petty cash book is the accounting book that is used for the purpose of recording the petty cash expenditure i. Petty cash book definition, types, format, examples. Petty cash book is a formal book of recording petty expenses which are incurred in cash.
Uses of petty cash book its a cash book used to enter daily petty expenses like cost of stationery, postage and xerox copy and so on. 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 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. Also known as a two column cash book, a double column cash book is the one which has a bank column in addition to the regular cash column. Check your understanding of a petty cash fund in this worksheet and quiz.
All the receipts in cash are recorded on the left side of. There are two primary types of entries in the petty cash b. Petty cash vouchers are generally referred to as petty cash receipts whenever any cash is withdrawn or added to the petty cash fund. 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. Single column cash book explanation, format and example. This petty cash log template allows you to easily modify the heading labels as needed and contains working formulas in the balance column in case you want to track the petty cash log using the spreadsheets itself, rather than printing a blank form. 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. Ledger for petty cash record keeping large 120 pages business accounts petty cash log book 9781074311896. Using a petty cash reconciliation and replenishment form helps him to provide the higher official with the details and request more cash. The simple petty cash book has only two amount columns. The simplest and the most common template starts with the reference number of the voucher on left. Petty cash financial accounting simple book production. Petty cash book definition, types, format, examples imprest and.
Download free and easy to use petty cash book ms excel template for easy maintenance of daily expenses for any businesses. Petty cash is a small amount of cash that any business can keep on their premises in a lockable container. Keep the petty cash book and box or tin in a safe place, such as the accountants or managers office or cubicle. Youll love our notebook even more with these features and benefits. The first row is for the company name and second for the title of the template. In big business apprehensions, the petty cash book is maintained in analytical form, with a detach column for each standard item of expense and a column for total. Petty cash book template excel software accountant. It is advisable to immediately update the petty cash book as petty cash is released. A petty cash book, therefore, serves the purpose of a ledger, keeping track of all business payments made on a small scale. Just like the other type of books, it records receipts from cash and bank on the left side and payments on the right side. Enter the date and cash value for the opening balance to get a summary with updated cash balance in real time. Petty cash book template is different from other company financial documents. Download petty cash book excel template exceldatapro. A petty cash book is an accounting ledger may contain transactions of small amount of money for regular expenditures on small items.
By keeping track of all petty cash transactions no matter how petty you have records to back up deductions for those small business expenses. A petty cash book can either be a simple petty cash book or an analytical petty cash book. The found that is used for small payments is known as petty. Petty cash should be properly controlled with a petty cash log and accurately entered into the bookkeeping system in exactly the same way you would maintain a bank account. A petty cash book is generally maintained on a columnar basis a separate column being allotted for each type of expenditure. 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. The book in which these small payments are recorded is called petty cash book. Simple steps to create dynamic petty cash book with ms excel. When petty cash is running low, record the petty cash expenses in quickbooks and pull out more cash to. Paused youre listening to a sample of the audible audio edition. 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.
Particulars of cash receipts and expenses are written together in a single column known as particulars column and another column is used for writing dates of both. Petty cash book is a formal summarization of petty cash expenditures, sorted by date. The single column cash book also known as simple cash book is a cash book that is used to record only cash transactions of a business. The receipt column is used to record the opening balance and the amount received from the head cashier. 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. Click here to download all accounting excel templates for rs 199. Versatile use either for recording daily expenses at home of for business purposes, this book is perfect for.
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. It is another cash book which is maintained, generally, in large. A separate column is allotted for each type of expenditure. The cash on hand balance amount is displayed on the righthand side. The petty cash receipts can be used when the church purchases something out of the petty cash fund. 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. One major advantage of this system is that it saves time. Examples include postage due, reimbursement to employees for small purchases of office supplies, and numerous similar items.
Record and monitor all cash on hand transactions with this petty cash book template. This book records all those expenses which are small in. How to prepare petty cash bookpetty cash book in hindi. Sometimes, the petty cash custodian makes errors in making change from the fund or doesnt receive correct amounts back from users. Large businesses maintain petty cash book to reduce the burden of main cash book. 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. This template is easy to use and an effective way to get control of your operating cash flow and expenses in real cash. The establishment of a petty cash system begins by making out a check to cash, cashing it, and. Petty cash, also known as imprest cash, is a fund established for making small payments that are impractical to pay by check. The best way to draft a petty cash voucher is to follow a standard template and make changes accordingly. This kind of petty cash book is known as analytical petty cash book. This format is an excellent way to monitor the current amount of petty cash remaining on hand.
Cashbook is a financial journal which contains all the cash receipt and cash payments including the deposit in bank and withdrawal from the bank. 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. Documenting transactions is the way a business documents business expenses for tax purposes. The custodian of the petty cash is required to report the details of the petty cash settlement made over a certain period of time such that the cash can be replenished. Keep petty cash purchases small, for expenses like postage, parking meters or party supplies. However, purchases made using cash are hard to track, easily forgotten, and ultimately make accounting a challenge. The most important part of a petty cash system is the documentation of each transaction. The petty cash is a miscellaneous small fund usually budgeted for that is to be used for unknown minor items that may occur that you dont have time or need to go through the processes or writing a church check and you pay with cash from the petty cash fund. Cash book in accounting the cash book is a chronological record of the receipts and payments transactions for a business.
1307 853 1348 1246 709 1259 1327 1349 1364 618 762 558 1266 654 864 1040 1132 1287 1203 808 527 1039 1443 536 1513 54 168 1422 90 757 937 744 815 265