Compile Sum Invoice For Free

welcome to this week's episode of ask your XO question in this week's episode we will be learning how to write formulas that will help us allocate multiple payments made against the same invoice or multiple payments made by customers across multiple invoices so we will learn how to write the formula in this video if you have not subscribed to this channel yet please do and now let's get started with this week's episode now just to set the stage for this video this we are going to use the invoice tracker excel template that is available for free to download from n 0 calm I will also put a link to the video and also the page where you can download this template in the video description so please check that out and in this template that we have published a while ago the invoices are recorded here each invoice is entered in a separate row and then the customer for that each invoice is named here and then each invoice will have an invoice date and a due date and the invoice amount and then the paid amount is the amount that has been paid so far by the customer and that is been entered directly in this column and then the outstanding amount and what's the status and everything will be calculated by the template using formulas automatically now in this template we have entered the paid amount directly as a user input right so what we're going to do now is to extend this template further by saying what if this invoice number 1 the customer did not make one payment made in multiple payments so what will you do if the customer for example has multiple invoices like for example customer 3 has 3 invoices and they actually pay together across multiple invoices in their payments so how do you make sure that you can track the payments that the customers made and also allocate correctly to each invoice and calculate the outstanding amount so that's what we're going to learn in this video ok so now I have removed a lot of the sample data so I've kept it really simple so that we can clearly follow what's going on with the formula and the first option here is the payment by invoice so I'm gonna go into the sheet but I've already created a table so if you want to track the customer who is making multiple payments for each invoice then you will set up a table like this with just three columns invoice number payment date and amount that the customer paid for that so this means for invoice number one the customer made two payments one on December 5th $400 one on December 8th for $200 and the similarly for invoice number two there were two payments made two hundred and four hundred dollars on different dates now we want to make sure that our invoice tracker collect correctly calculates the paid amount for each invoice so first we're going to do a simple sum if function so we're going to you know use the table that we've already created so before I do that I just want to inform that this is an Excel table where you can enter more and more rows and it'll automatically...