Does anyone know how to create a check register for one project that would list both invoice AND payment information in an easy to read format?

We cannot do this with our set-up. Only the expense side of the AP posting has a project tied to it. When we write the checks, we just relieve AP and many of our vendors get split between projects.

Aimee: You should be able to create an AP invoice query filtered by project which you would include check (payment) number, vendor name, payment date, gl account distribution and amount charged to the project. You'd have to be careful to not include the total check amount, but use the invoice distribution amount to the project as an output field in the query.

Thanks for the info. I have a query that I've been using, but I have to dump it into Excel. I was hoping there was some kind of report I could manipulate within the system to avoid the time spent adjusting things in Excel.

Mark, What kind of reporting do you do for your projects?

We do a budget to actual income statement monthly. We attach the general ledger detail reports for that project and send it to designated management personnel. After adjustments, we rerun the report for billing purposes. Pretty straightforward.