Paying contractors from invoices
Hello,
I work for a flooring company & my question is how to streamline the process to pay contractors. I'll try to be as concise as possible. Let's say we invoice Company A for a property that had both carpet & laminate flooring installed. Our invoice will have materials & labor prices all separated out for each type of flooring. So when it comes time for me to calculate what I owe the installers (which often can be 2 different contractors) currently I am manually writing each line out (each job can include many different line items associated with it) & looking up the associated costs on an excel spreadsheet. So it is pretty time consuming. We want to be able to track the materials & labor costs separately but we are doing it manually in an excel spreadsheet. Is there something we could do differently so that all the invoice info would be funneled into a way for me to put it into each contractors payroll? Hope I was clear in my intentions so that someone might be able to simplify things for us! Thank you!
