Sunday , September 24 2017

Car loan Calculator in Microsoft Excel

Car loan Calculator in excel

Car loan Calculator Car loan Calculator provide detail of each month for a future time period which is necessary for finance planning Interest calculation sheet includes serial number, Car financing head, Interest rate, No of installment, Loan Amount and monthly installment with interest.                 ...

Read More »

Payment receipt voucher in excel

Payment receipt voucher in excel

Payment voucher : Payment voucher is a document  sent by  customer to his supplier company includes complete detail of payments through cheque or any other mode of payment. this document is also a part of a transaction documents.                         ...

Read More »

How to Create Delivery Note in Excel

Delivery Note in MS. excel

Delivery Note : This document has a great importance in Business transaction. Delivery note is a receipt of goods as an evidence by  supplier to custome Supplier company will also send this document  as a receipt with the product to its customer usually two copy of delivery notes with the products. ...

Read More »

How to create Job card in MS.Excel

Job card

Definition of Job card: Job Card is the complete summary of a business transaction. Job card or job order is the Main document of business transaction. this document include the complete details. which includes customer company name Invoice Number invoice date Amount Received by cash or  by  cheque Amount received ...

Read More »

Process of Business Transaction

Process of Business transaction

Definition of Business transaction: All those activities which includes profit motives (objectives ) is called a business transaction. there are two types of transactions. the one is cash base transaction while the other one is credit base transaction. cash base transactions includes only a document of sales receipt and credit ...

Read More »

Business Invoice and Purchase order in Ms.excel

invoice-and-purchase-order

Invoice is a request for Payment to your customer. invoice use is only in credit base transaction,while cash base transaction includes only sales receipts. companies send invoice to their customer before delivery or after delivery to inform him to prepare for the payments. payment may be on more than one ...

Read More »

How to create Business Quotation in Excel

business-quotation

Business Quotation: An important documents offer by supplier to its customer for the  selling of  goods or services on a define price.   on Customer request a quotation is prepared with complete detail. Quotation include Payment, delivery and many other terms. Price of Products in your quotation has a great ...

Read More »

Excel students Result sheet or result card

Excel Result sheet

In this Lecture I am to teach you about “students Result sheet“.This sheet includes Total marks, Obtained Marks, Percentage and Grade of each student. It means that in this lecture you will learn Sum formula, Percentage and Grade formula. 1st of all in the Header of the sheet write S.No, ...

Read More »

Excel salary Sheet and Formula

Excel salary sheet and formula

Excel salary statement includes employees basic pay,house Rent, Medical allowance, Convince Allowances, Income Tax and some other allowances. this Method i have applied in this salary statement is very basic and comprehensive. Excel gives us the flexibility to configure data for different objectives like “SUM”, “AVERAGE”, “Multiplication”,”Subtraction”. I am going ...

Read More »

Process of Cash sales in Quick books

process of cash sales in Quick books Accounting software

Cash sales is  absolutely different from  credit sales process. cash sales includes only  sales Receipts in which the customer will make the payments at the time of purchase so there is no need of quotation ,sales order and sales invoice. usually cash sales is a dealing  between Retailer and the ...

Read More »