A somewhat more useful format is to record all debits and credits in a single column, with. It is another cash book which is maintained, generally, in large business. 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. A petty cash book is generally maintained on a columnar basis a separate column being allotted for each type of expenditure. Download petty cash book excel template exceldatapro. This is simple petty cash book format can use for the maintain daily expense records. This excel bookkeeping template comes with two tabs, one for the log, wherein you list the daily cash ins and outs, and one for the slip, which can be printed out might want to copy and. 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. However, there is a number of transactions during the normal course of the business which is of very petty and nominal amount and is not recorded in the cash book account.
For example, if you bought a screw at the corner hardware store, you might note. Any cash, which the petty cashier receives, will be recorded on the debit side left cash column of the book and any cash which he pays out will be recorded on the credit side right cash column of the boo k. The petty cashier of john and james company paid cash for the. The petty cash book template has 2 sections which are mentioned below. There are two primary types of entries in the petty cash b. Petty cash book explanation, format, example, ordinary and imprest. For transactions of such nature, petty cash book is used. Petty cash should be part of an overall business accounting system that. Maintaining a cash book under the stated system is called an imprest petty cash book. The righthand corner of the cell in blue display the amount of petty cash on hand. Thus, the book is part of a manual recordkeeping system.
The header section consists of your companybusiness name and template heading petty cash on hand. The credit side consists of several analysis columns. Petty cash book template in big companies where daily routine expenses are in higher volume petty cash book is used. Format of the petty cash book free download as word doc. Petty cash accounting impressed petty cash system, detailed accounting example. This format may contain date, cash amount, check amount, check number, description, payee name, amount deposit, amount balance, cash amount. A separate column is allotted for each type of expenditure. Simple steps to create dynamic petty cash book with ms excel. The petty cash book is a formal summarization of petty cash expenditures, sorted by date. The petty cash book is a book of vouchers which are made each time an. In most cases, the petty cash book is an actual ledger book, rather than a computer record. The petty cashier of john and james company paid cash for the following expenditures during march 2018. For example on 31st december, 1991 the balance in expenses accounts are. Petty cash book is a type of cash book that is used to record minor regular.
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. How to create petty cash account with excel youtube. Petty cash book is maintained to record small expenses such as postage, stationery, telegram. For this purpose, a petty cashier is appointed by the chief cashier. This template includes date, receipt, description, deposits, and withdrawals. A petty cash book is a ledger kept with the petty cash fund to record amounts that are. This type of book is maintained just like a cash book. Definition, explanation, format and system of petty cash. Petty cash book format example definition explanation. 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. Petty cash book definition, types, format, examples.
1534 760 629 457 1315 1120 42 1554 996 681 233 1455 744 1572 19 910 251 131 1532 1175 266 746 1600 907 781 669 1345 379 444 834 611 357 705 800 1211 90