View Full Version : How do I create a payables report for individual jobs
08-25-2007, 10:12 PM
I will make this quick. No where does QB have a standard report that generates payables based on seperate jobs, it just lumps all payables in to one batch. I build homes and need to generate payable reports for each job (house) independent from each other so that I can keep my different construction loan draws straight. Any ideas or thoughts on this would be greatly appreciated. Thanks in advance.
08-26-2007, 05:18 AM
Open the Cusom Transaction Detail report and modify it by setting the Total by to Customer. In the columns to display, uncheck Name and check Source name [this will be the vendor's name]. Change the sort ny to Source Name to sort the transactions by vendor.
Click the Filter tab and click Transaction Type and choose Selected transactions, in the selection box, check Bill and Bill-credit. Scroll down tht filters and click Detail level and choose All except summary.
You can also click the Paid Status and choose Closed (paid) or Open (unpaid).
This report will list the items purchased by job.
Change the report name on Header/Footer and then memorize so you can run from the memorized report list.
The job profitability detail report will also give a report on the expenses by the job, using items and No item.
08-26-2007, 01:18 PM
Joe thanks a bunch for your response however I am still confused. Where in your process of building this report are you seperating the current A/P by JOB? Nowhere am I finding a way to reference account payables by JOB. If this report will do that can you explain how it is doing it as again there is no reference to Job. Thanks a trillion for your help Joe.
08-27-2007, 07:16 AM
The Total by on the modify tab set to Customer will sub-total by the Customer:job and give the total for all jobs listed under the customer. The report is reporting on the EXPENSES that are entered by bills or bill-credit. The bill and bnill-credit are entered in AP. QB cannot just report on AP for jobs because the bills are entered using vendor names not the job. The split has the job associated with it and that can report using the customer:job.
vBulletin® v3.8.4, Copyright ©2000-2013, Jelsoft Enterprises Ltd.