Streamline Your Finance Tasks with Our Invoice Tracker Excel for Finance

Invoice tracker excel for Finance

[Music] welcome to the tutorial video of invoice generator spreadsheet for Excel we will explore the spreadsheet to understand how to make the most of its functionalities our invoice generator spreadsheet contains 11 tabs editable and automated invoice templates Client List product list accounts tab invoice generator two invoice templates for printing and the dashboard let's have a look each of them let's start with editable invoice templates these pages will serve you as a manual invoice template feel free to customize all elements including headers prices and quantities as required the templates are designed to calculate total amounts automatically they'll be particularly useful when you need to create specific or specialized invoices simply doubleclick the cells that you want to change and write as it needed now let's move to product list page this is the tab where you will list your products or Services you can add ID name category and price information of your product portfolio sales and revenue columns will be calculated automatically as you register new invoices in invoice generator page on top of this page you will find a currency setting cell choose your preferred currency from droplist when you change currency all related pages and templates will be adjusted automatically you will find a table located in this tab dedicated for product categorization name your categories in this table and select from drop list while adding new products you can use navigation buttons to move easily between Pages now let's explore Client List tab this is your master database for your clients you can add name address email and phone information of your C clients in dedicated table as you enter new clients to this table related drop lists and charts will be updated this column will show total number of invoices for each client numbers will be calculated automatically as you generate new invoices let's move to accounts page this is the tab where you will list your bank account information you can add Bank name account name and number Swift or Bic code and currency simply doubleclick the cell and write the account information related sections and drop lists will be adjusted automatically now let's move to automated invoice [Music] templates automated invoice templates will work together with product list Client List and accounts page these templates are designed for increase effectiveness of invoicing process you will be able to use Smart drop lists when creating new invoices select the client's name form drop list address phone and email data will be automatically updated for selected client you have the flexibility to choose products or services using drop-down lists within the description section as you make selections the corresponding price information will be automatically generated when you input quantities for selected products the totals will be calculated for you when applicable you can change discount and tax ratio manually simply doubleclick the sell and write the amount in the payment information section if you have multiple bank accounts you can easily select the appropriate one from the drop- down list of Bank names this action triggers a dependent drop-down list to populate the account number section allowing you to choose the required account number that's all for automated invoice template now let's explore invoice generator page this is the invoice generator page your active workspace you can generate and track your invoices with this page easily this page will work together with product list Client List and accounts let's explore how you will use it each row in this table is representing an invoice you will add invoice number client information issue and due dates payment account discount and tax ratio and products that will be invoiced you can start generating invoices by adding an invoice number simply doubleclick the cell and write the invoice number number since each invoice number must be a unique value you will see an error if you try to input an existing one this feature will prevent mistakes when entering new data use drop list to select client name in Bill to column this drop list will include the data which you already entered in client page for issue and payment due dates simply doubleclick the cell and write the dates if payment due date is earlier than the current day and if payment status is is unpaid payment doe sell will be highlighted it will help you to track overdue invoices click the arrow and choose your preferred payment account for the invoice from droplist for Discount and tax information doubleclick the cells and write manually in status column choose payment progress as paid or unpaid by using drop lists now you can start to add products that will be invoiced you will be able to add up to 10 different products to a single invoice for each product you will find two columns as ID and quantity choose the ID of the product from drop list in ID columns then write the quantity for selected product colored columns will prevent confusion while entering data for the products now you generated an invoice but you may still need to print it use the print tabs for easily print your generated invoices you'll discover two print tabs A4 and US letter choose the one that suits your requirements on these print pages all you need to do is update the invoice number by double clicking the cell and entering the number that you want to print all other details on this page will adjust ingly you have the option to print the invoice on paper or save it as a PDF to send electronically and that's it now you are ready to generate and print invoices easily now let's explore the dashboard in the dashboard tab you will see overall status and insights for your invoicing process on top you will find Smart cards for a quick overview this card shows total number of invoices that you entered in invoice generator tab this is the total value of your invoices with paid and unpaid amounts tax card will show you total tax amount ing to tax ratio and total values of each invoice sales card shows total number of invoiced products that you you entered an invoice generator this table will show the client that you most worked with your bestseller product your average discount and overall payment progress ratio on bottom side you will find three tables this is your top 15 clients by number of invoices in descending order this table will show you your top 15 bestseller products by sales quantity this table shows your overdue invoices with invoice number client due date and amount and days passed from the payment due date you will also find Smart charts for your income breakdown payment progress and top five product category by highest revenue and this is it now you are ready to use your ultimate invoice template if you have any questions just send us a message from the link in descriptions the product link can also be found in the descriptions below many thanks for watching