Streamline Your Finances with the Invoice Tracker Template Excel for NPOs

Invoice tracker template excel for NPOs

hello and welcome to Advanced invoice tracker Exel template this template will help you to make an easier invoice analysis also make it seen on a pipeline and will also help you to create a simple invoice for you for you or for your business start with the settings section the settings section will later help you in the invoice database to input your data much easily enter your workers name and later on input the segments that you provide if you have a customer segmentation you can also input it in here you can also categorize your invoices by setting them maximum internal values and they're going to be automatically colored in database once you adjust the settings ing to your needs now you can go to customer database to register your customers this section will will also later on be used in the invoice database section to choose from the drop- down list after you register your customers and it's also properties go to invoice database to register your invoices so let's give an example choose your customer name from the drop-down list and also the person who issued once you write your invoice value it is going to be automatically colored in the color that you set in the section in put the due date and the segment these extra informations as segments are issued by will be later on used to make a much comprehensive analysis in the other section if the invoice is not paid at all it is going to report as unpaid in this section if they paid partial it is going to be written as partly paid and when it is fully paid it is going to write as paid the gray cells are formulated so they do not need any inputs while in this section if it indicates that if it is paid or not in this section it shows the outstanding balance of the invoice and if you do have any notes you can use this section to take some notes once you also complete to register all of your invoices now you can make your analysis once you add an information or change an information in here do not forget to press on the the refresh button if you would like to have a specific times analysis press this cell and input the start date and also input the end date as well if you would like to have a general analysis you can simply delete these dates and then refresh it you can also make your analysis ing to issue date as well delete the dates and once you do that do not forget to press on the refresh button you will be able to see the paid ratio the outstanding balances the invoice value breakdown and and also invoice total versus total pay chart in this section you can also filter the charts with these filters in this section you can filter it ing to customer name issued by ing to segmentation if it's paid or not the priority and if it's overdue or not you can also see the situation of your invoices in a pipeline as mentioned in the earlier section you can have a specific time by entering the starting date and an end dat all you have to do is press on the refresh button once you enter enter the dates and as mentioned just like in the other sheet you can search it by the issue date or by due date if you would like to make a general analysis you can just simply delete these days and then press on the refresh button again anytime you change the dates or change a data in the invoice database you always have to press on the refresh button you can also filter it by customer by issued by overd paid priority and segmentation as well and lastly on the invoice section you can simply create an invoice you can input the details of an invoice ing to your own needs you can also choose the customer and then the addresses will automatically appear in this section you can add an item by entering the name of the product or the idea of the product set the quantity the unit and once you input unit price the total will appear automatically you can change the payment details and also if you have other issues to add or subtract just like other expenses discount or vat ratio you can set it ing to your own needs if you would like to hide the discount and hide vat all you have to do is choose it from the drop-down list I hope this video was informative enough thanks for watching