I am managing a real estate project with Quicken. Every month, I get an Excel Invoice from the General Contractor that includes anywhere from 10 to 50 separate line items from different vendors and subs. I create a single transaction for the invoice and then split the transaction for each line item. I used Tags to identify the vendor/sub and Notes filed for information about that specific charge. The process is both tedious and not user friendly.
Is there a file format that I can import at would support split transactions?
Or would I be better off create a separate transaction for each vendor/sub using the General Contract as the Payee and still using the Tags to ID the vendor/sub?
Any suggestions?
