If you want to keep a good track of your invoices, using Microsoft Excel is the best choice. Invoice is basically a receipt used by suppliers or vendors for the goods or services provided to an organization. Invoices may contain the number of items, their prices, the due-date to pay the amount, service description and the address for payment. It is used as a security and evidence that a certain company is liable to pay the amount. A receipt is also known as a ‘Notes Payable’ in accounting terms.
Microsoft Excel has made it easier to make invoices. It presents the simplest way to generate invoices and stay organized. This type of invoice is known as Excel Invoice. A spreadsheet can be used to track invoices that a company has sent out and vice versa.
The following steps should be followed to make an Excel Invoice:
Microsoft Excel has made it easier to make invoices. It presents the simplest way to generate invoices and stay organized. This type of invoice is known as Excel Invoice. A spreadsheet can be used to track invoices that a company has sent out and vice versa.
The following steps should be followed to make an Excel Invoice:
- Open MS Excel, a spreadsheet will appear.
- For your ease, make a suitable title on the top. This will help you in remembering the specific invoice on a spreadsheet.
- ou can also make separate spreadsheets for the sent and received invoices.
- Now start making the column headings. Start from the first column. You can use headings like date, person, amount, payable date etc.
- Bold the column headings. This can be done at once by selecting the whole row of column headings.
- Now start entering the data into the sheet. If some information is unavailable, leave the cell blank.
- At the end of each column, add totals. You can do this by highlighting the whole column and clicking on the sigma in the toolbar.
You can also do this by opening ‘New Workbook’ in the ‘File>New’ option of MS Excel. Excel has made the work of organizing the invoices easier. However you can also print your invoices into a .pdf by using a .pdf converter.