Forum Discussion
Purchase Orders and Invoices in Excel
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 Date | Project 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?
