Purchase Orders and Invoices in Excel

Copper Contributor

Hi I'm trying to create a spreadsheet that allows me to track multiple purchase orders 

and subtract the invoice amounts from that PO (I have multiple invoices under one PO). Something like this: 

PO #PO DateProject Code PO Amount  Invoice #  Invoice Amount  Amount Available % Remaining

 1245  4/1/18  M-214     $400,000       456-52      $25,000      $375,000      .94

                                                             456-53      $75,000      $300,000      .75

1275   4/2/18  M-118      $250,000      457-89      $50,000      $200,000      .80

                                                             457-87      $25,000      $175,000      .70

 

I want to be able to add multiple invoices under one PO and have it subtract the first invoice from the total PO amount and each subsequent invoice from the available PO amount.  How do I do that?

 

0 Replies