Collaborate on Invoice Tracker Google Sheets for Purchasing with Ease Using airSlate SignNow

Invoice tracker google sheets for Purchasing

hello I wanted to give you a quick tour of the simple invoice tracker for Google Sheets so when you open it up um the first page after the instructions tab is the dashboard and alerts Tab and this will show you how many invoices you've sent how many are due or overdue so due today or overdue and how many have been fully paid and then you'll see a graph showing the invoice of the amount paid versus the balance remaining by the invoice due month so these are categorized by the uh month that the invoice is due so for example in October you had um you've received payment for invoices due in October uh $33,000 worth of payments and you still have $11,000 worth of payment outstanding for October invoices and for December invoices you have $115,000 outstanding down here you'll see the am total amount invoiced this year so this is for 2023 the amount paid this year so these are the invoices that have been paid and then the balance due which is the difference this chart shows you the payment received by the month that the payment was received so not by the invoice due month but by the month that you actually received the payment so it's a sum of the payments you received in April May June Etc so and um you can customize the months and the year that you show in the charts in the setup tab so that's the dashboard and alerts tab the client tab is very simple it's just where you can enter in your uh client name the company name contact person and just some basic information um so then in the invoices tab when you create a new um project or deal that you're going to invoice for for example um website project website copy let's call it and let's say ABC fashion and let's say it's $20,000 or um you can write the terms if you'd like and the invoice number is important and then once you send the invoice you uh check invoice sent and today's date invoice due and this is going to be used to um show when the invoice is overdue and the overdue invoices are shown in Red so these invoices are not fully paid and they're due today or they were do before today so then and and here you'll see the status full payment received partial payment received and the amount paid and the remaining balance and these are unpaid and here you can enter in payments so for example let's enter in $1,000 let's put today's date and let's do the new invoice that we just entered this one okay so you'll see it populate it'll pull in the invoice number for the comp company the due dat deal amount and the remaining balance so $119,000 and then you'll see that in the dashboard and alerts tab so this has increased the amount invoice the amount paid and the balance du have been adjusted and the ,000 that we just paid has been uh accounted for here but we're still due 34,000 so it's very simple and let's say we get another payment for let's say we get really lucky um $115,000 again today I'm just doing this for demonstration purposes boom and now the remaining balance is only 4,000 and this chart has updated to show that you've received $116,000 and your balance due is1 19,000 instead so it's very simple to use and um the instructions here will show you exactly what you need to do to use it and the setup tab you is where you can uh change the months that will show in your uh charts so right now I have it set for 2023 but you can change them to for 2024 let me know if you have any questions otherwise you can check these out in the link in the description thank you