Cash memo format in excel free download

It will shed some weight off the shoulder of your accounts team as they do not need to take account of each minor transaction one by one. This can be hectic and could be quite time-consuming. By using a log, you can make small transactions right away without needing to fill out checks.

It is a handy way to manage and control your daily expenses. These expenses include expenses of the daily newspaper, food, office maintenance, and other supplies. You must keep the daily expenses in consideration to maintain the balance in the log. Then you just need to make sure that the money spent should be strictly recorded without any delay. For better performance and effective expense management you can assign an honest and reliable person of your team to keep an eye on petty cash.

So, in other words, make someone in charge of your petty funds and transactions After that, you must have a proper system in place for your petty money to be in a secure place. You should never leave your petty money unattended and unsupervised. In other words, the cash memo acts as a bill. The only difference between the bill and cash memo is that it only includes the details about the purchases that are made in the form of cash instead of bank transactions.

It is the responsibility of the purchaser to ensure that all the service details have been mentioned in the memo by the vendor. If the vendor has not mentioned all those services that he is offering, you can include those services and then sign the memo. The date of the cash transaction, time and total amount that has been paid is some main details of this memo.

It is important to know the reputation of the vendor before purchasing anything from him. If the seller has not been fair in his dealings with you, you can easily claim anything with the help of cash memo since the cash memo is the proof that you have purchased items from the seller.

Usually, those sellers are considered trustworthy who not only sells the items but also send a cash memo with all the essential details. Skip to content. It consists of 2 sides; debit and credit.

It is also known as a simple cash book. Some businesses have to provide discounts during their cash transactions. Thus, these type of businesses maintains Cash Book with Discounts. It consists of an additional column for discounts received or paid. Similar to the simple cash book, it also consists of a debit and credit side along with an extra column for tax.

If there is any other tax applicable in your area, you can insert it according to your needs. This type of book consists of additional columns for Discounts and Tax. We have created ready-to-use excel templates with predefined formulas for each type of Cash Book. Let us understand the content o each template in detail. Click on the icon button to download the desired format.

The functioning and formulation are the same in all three formats. We have created a ready-to-use Simple Cash Book Template which helps you to easily record and reconcile your cash transactions.

The first row is for the company name and second for the title of the template. The Cash on Hand balance amount is displayed on the right-hand side. There are 2 sides Debit and Credit. Both sides consist of 3 columns each: Date, Particulars, and Amount. We have created a ready-to-use Cash Book With Discount Template which helps you chronologically easily record and reconcile cash transactions with discounts.

Enter the opening balance manually. The summary section consists of a summary of the total transactions. It will display the opening balance, current income after deducting discounts, current expenditure amount after the discounts. It will also display the amounts of discounts received and discounts given on total transactions. The data entry section has 2 sides, debit, and credit.

It is a formal document that states the details of the payment of a purchase. It is generally issued to the customers by service providers. It is a commercial document that contains the demands of your purchase, including the expected time of delivery of services. Along with it, the cash invoice should have the contact details such as the phone number, and email information of the customer. Payment information, such as the cost of your purchase and how much you have paid for it are included in a cash invoice.

A cash invoice is a document that shows a financial transaction between the buyer and seller. It looks similar to billing invoice templates that we tend to see from time to time. Some confuse it as being a receipt, but there are two distinct differences between them: A receipt is for purchases paid by physical money, or cash. An invoice illustrate a purchase made using credit.