![\"Free](\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2025\/11\/Free-Product-Tour-resized.webp\")
<\/a>\r\n\r\nTable of Content<\/strong><\/h2>\r\n\r\n- Definition of Cash Note<\/a><\/li>\r\n
- Cash Note Functions<\/a><\/li>\r\n
- Cash Note Components<\/a><\/li>\r\n
- How to Compile a Cash Note?<\/a><\/li>\r\n
- \r\n
\r\n- Inputting the product code<\/a><\/li>\r\n
- Inputting product name and quantity<\/a><\/li>\r\n
- Use the VLOOKUP formula<\/a><\/li>\r\n
- Make unit price per product<\/a><\/li>\r\n
- Inputting total price<\/a><\/li>\r\n<\/ul>\r\n<\/li>\r\n
- Conclusion<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n\r\n
Definition of Cash Note<\/strong><\/h2>\r\n\r\n\r\n\r\n![\"cash](\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/11\/image-from-rawpixel-id-388584-jpeg-4-1-1024x683.jpg\")
\r\nSource: Rawpixel.com<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\nA cash note is a payment record or document that is provided by the seller to the buyer for the goods sales transaction on a cash basis. The seller provides this payment record to the buyer because the payment has been paid off. Of course, compiling a cash note should use a copy. At least this payment record is copied into two copies. The original is given to the buyer. Meanwhile, the buyer will keep the copy for transaction records.<\/p>\r\n\r\n\r\n\r\n
Also read: Main Benefits of ERP Software for Professional Services<\/a><\/p>\r\n\r\n\r\n\r\nCash Note Functions<\/strong><\/h2>\r\n\r\n\r\n\r\nThis payment record has various functions. Business companies use this payment record in compiling a financial statement. When compiling a financial statement, it will be a medium for re-checking all the occurred transactions. This payment record is also a valid payment record for the buyer. With this payment record<\/a>, the business companies can know various data such as the number of products that have been sold and the total payment to be paid.<\/p>\r\n\r\n\r\n\r\nCash Note Components<\/strong><\/h2>\r\n\r\n\r\n\r\nIn compiling this payment record, several components must be listed. What are the components? Here are the components that should be listed in this payment record:<\/p>\r\n\r\n\r\n\r\n
\r\n- Business company name, often the business company name comes with the company address along with a contact number.<\/li>\r\n
- Cash note number, where the company has determined this number.<\/li>\r\n
- Transaction date.<\/li>\r\n
- Goods types that have been purchased.<\/li>\r\n
- Quantity of purchased goods.<\/li>\r\n
- Goods price.<\/li>\r\n
- Total price.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n
How to Compile a Cash Note?<\/strong><\/h2>\r\n\r\n\r\n\r\nIn compiling this payment record, you can choose several available ways. If you want to be hassle-free, you can visit the nearest stationery store to buy a ready-to-use cash note. In addition, you can also create a custom cash note that comes with your company logo in the printing services store. But in today’s digital era, you can also create your own format using Microsoft Excel or using ERP software<\/a> to automate compiling cash notes. Check out the following steps in compiling this payment record format using Microsoft Excel:<\/p>\r\n\r\n\r\n\r\nInputting the product code<\/h3>\r\n\r\n\r\n\r\n![\"Get](\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2022\/03\/New-32.jpg\")
Sumber: Canva<\/figcaption><\/figure>\r\nThe first step to compile this payment record format using Microsoft Excel is to input the product code. This product code contains the code number of the product. In inputting the code, you don’t need to use available formulas in Microsoft Excel. This code will help the seller in checking the products sold. Make sure to input the product code correctly.<\/p>\r\n\r\n\r\n\r\n
Inputting product name and quantity<\/h3>\r\n\r\n\r\n\r\n
After inputting the product codes, you are required to input the product name. Not only the product name, but you should input the product quantity. It is important to input them into the available columns. This aims to make it that can be arranged neatly.<\/p>\r\n\r\n\r\n\r\n
Use the VLOOKUP formula<\/h3>\r\n\r\n\r\n\r\n
As we know, in Microsoft Excel, many formulas can be use to help someone compile a report on this application. The aim of these formulas is to make it easier for the user in compiling reports. You can also use the VLOOKUP formula in Microsoft Excel like =IFERROR(VLOOKUP(C10,’PRODUCT DATA’!$3:$D$100,2,FALSE),””). After that, you can enter the number of sold products in the items column.<\/p>\r\n
- \r\n
- Inputting the product code<\/a><\/li>\r\n
- Inputting product name and quantity<\/a><\/li>\r\n
- Use the VLOOKUP formula<\/a><\/li>\r\n
- Make unit price per product<\/a><\/li>\r\n
- Inputting total price<\/a><\/li>\r\n<\/ul>\r\n<\/li>\r\n
- Conclusion<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n\r\n
Definition of Cash Note<\/strong><\/h2>\r\n\r\n\r\n\r\n
\r\nSource: Rawpixel.com<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n A cash note is a payment record or document that is provided by the seller to the buyer for the goods sales transaction on a cash basis. The seller provides this payment record to the buyer because the payment has been paid off. Of course, compiling a cash note should use a copy. At least this payment record is copied into two copies. The original is given to the buyer. Meanwhile, the buyer will keep the copy for transaction records.<\/p>\r\n\r\n\r\n\r\n
Also read: Main Benefits of ERP Software for Professional Services<\/a><\/p>\r\n\r\n\r\n\r\n
Cash Note Functions<\/strong><\/h2>\r\n\r\n\r\n\r\n
This payment record has various functions. Business companies use this payment record in compiling a financial statement. When compiling a financial statement, it will be a medium for re-checking all the occurred transactions. This payment record is also a valid payment record for the buyer. With this payment record<\/a>, the business companies can know various data such as the number of products that have been sold and the total payment to be paid.<\/p>\r\n\r\n\r\n\r\n
Cash Note Components<\/strong><\/h2>\r\n\r\n\r\n\r\n
In compiling this payment record, several components must be listed. What are the components? Here are the components that should be listed in this payment record:<\/p>\r\n\r\n\r\n\r\n
- \r\n
- Business company name, often the business company name comes with the company address along with a contact number.<\/li>\r\n
- Cash note number, where the company has determined this number.<\/li>\r\n
- Transaction date.<\/li>\r\n
- Goods types that have been purchased.<\/li>\r\n
- Quantity of purchased goods.<\/li>\r\n
- Goods price.<\/li>\r\n
- Total price.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n
How to Compile a Cash Note?<\/strong><\/h2>\r\n\r\n\r\n\r\n
In compiling this payment record, you can choose several available ways. If you want to be hassle-free, you can visit the nearest stationery store to buy a ready-to-use cash note. In addition, you can also create a custom cash note that comes with your company logo in the printing services store. But in today’s digital era, you can also create your own format using Microsoft Excel or using ERP software<\/a> to automate compiling cash notes. Check out the following steps in compiling this payment record format using Microsoft Excel:<\/p>\r\n\r\n\r\n\r\n
Inputting the product code<\/h3>\r\n\r\n\r\n\r\n
Sumber: Canva<\/figcaption><\/figure>\r\n The first step to compile this payment record format using Microsoft Excel is to input the product code. This product code contains the code number of the product. In inputting the code, you don’t need to use available formulas in Microsoft Excel. This code will help the seller in checking the products sold. Make sure to input the product code correctly.<\/p>\r\n\r\n\r\n\r\n
Inputting product name and quantity<\/h3>\r\n\r\n\r\n\r\n
After inputting the product codes, you are required to input the product name. Not only the product name, but you should input the product quantity. It is important to input them into the available columns. This aims to make it that can be arranged neatly.<\/p>\r\n\r\n\r\n\r\n
Use the VLOOKUP formula<\/h3>\r\n\r\n\r\n\r\n
As we know, in Microsoft Excel, many formulas can be use to help someone compile a report on this application. The aim of these formulas is to make it easier for the user in compiling reports. You can also use the VLOOKUP formula in Microsoft Excel like =IFERROR(VLOOKUP(C10,’PRODUCT DATA’!$3:$D$100,2,FALSE),””). After that, you can enter the number of sold products in the items column.<\/p>\r\n
- Inputting product name and quantity<\/a><\/li>\r\n