40 Petty Cash Log Templates & Forms in Word & Excel Free Download by One Click

Employees in all types of organizations will have to deal with petty cash at some point, and keeping track of everything in a petty cash log will be quite beneficial. Essentially, you can make a petty cash log template in any spreadsheet program, such as Microsoft Excel, by creating a structure with columns to capture all of the relevant financial information regarding petty cash transactions.

The columns in your spreadsheet might contain, but aren't limited to:
  • Any monetary withdrawals will be recorded in this column.
  • Checks written from the petty cash account are listed in this column.
  • A column to keep track of the reason of any spending.
  • A column for deposit-related information.
You may make a petty cash form on your computer and fill out the sections there as well. Otherwise, you may print and bind a few of these forms to keep a tangible record of all your transactions.

Several minor costs are made during the day, particularly for larger businesses, and having a book to record everything is vital so you don't lose track of your money and don't have concerns about daily spending.

When your company maintains a separate ledger for petty costs, all your cashier has to do is make a note of everything after each transaction. To ensure that your record is full and accurate, you must mention the amount, date, and reason (for spending).

This type of book or log is typically used for tiny payments or transactions involving modest sums so that everything, no matter how minor, is documented. Bus, taxi, or auto fares, stamps and mail, and purchases for coffee or tea are all instances of modest payments.

Importance of Having a Petty Cash Log

It's critical to have your own petty cash log to track and record all of your transactions in any type of business. Having a log or a record would help you to keep track of everything as the tiny amounts add up, especially when dealing with smaller quantities that may go overlooked. Here are some of the main reasons why keeping such a book or record for your tiny costs might be beneficial:
  • It's a highly organized approach for you to keep track of all small payments and costs that occur on a daily basis in your business.
  • It would give much more rapidly and readily the information needed in relation to minor transactions that have been done and documented by various persons.
  • It may be used as a reference if you want to compare costs between two time periods, and it can help you better manage your small expenses.

  • It reduces the amount of work that the business's chief cashier has to do because he or she will no longer be the one to handle the smaller transactions. As a result, your chief cashier will have more time to properly handle and even oversee the business's larger and more significant cash transactions.
  • Having a log book like this might help to make your primary cash book more informative. It would be more cleaner, clearer, and perhaps more comprehensive because it would only list significant transactions.

  • It makes it easier to keep cash transaction records current and up-to-date since the work of actually documenting the transactions is separated.
  • Because payments do not have to be recorded separately, it saves you a lot of time. All transactions are recorded in real time, and the publishing is done on a regular basis at a set time.
  • This type of cash system would also eliminate the need to write small-dollar checks, which is cumbersome. You'd be able to execute a deal with cash straight away if you wanted to.
As you can see, keeping track of your little transactions is critical since it makes job much easier and more convenient.

 Consider implementing this method in your own company, after which you can begin generating your own log, which will be utilized by the people you delegate on a daily basis. Before you start producing your log, it's a good idea to familiarize yourself with the various categories and their functions.

Types of Petty Cash Logs

Though you may create your own petty cash log template, understanding the different types can be quite beneficial. You may discover that various sorts of logs are more successful for your organization, and you may style your log accordingly. The many kinds are as follows:

Simple

This is the simplest basic log, and it resembles a single cask log. All you'd have to do is create a column for the amount and another for the date. The amount received from the head cashier is recorded on the debit side of the log, while the cashier's petty payments are recorded on the credit side of the log. Then, at the end of the day, you can figure out how much money is still in your box.

Analytical

You'd have to construct a separate column for each of the expenditure categories in the credit section of your log with this form of log. The cash collected from the cashier would be the lone column in the debit section of your record. Remember that only modest sums should be documented in the log, and if you have this sort of log, you must inform the person in charge of your money of this.

Columnar

This sort of log would feature a number of columns for money amounts so you can keep track of your daily spending, as well as a debit and credit side. All of the specifics, such as receipts and costs, are collected in a column called "particulars." Dates for debit and credit records would be kept in a separate column.

The amount of money received from the head cashier is noted on the debit side. More columns would be added on the credit side as needed. Expenses would be documented using a categorized manner, with transactions grouped according to their chronological dates. On view the entire amount recorded for costs, a total amount can be added to the credit side.

Any money spent on a purchase or a payment is recorded in a separate column known as the ledger column. The balance is the difference between the amount of money in receipts and the total amount of money paid out, which is always a debit balance.

 Download Also: 

    Tags

    Post a Comment

    Post a Comment

    Previous Post Next Post