How to create report that lists all expenses and income for customer/job. (But not a profit/loss.) More like a check register that lists transactions chronologically.
We are general contractors. In order to invoice a customer for a construction draw, we need to know all the current expenses and income for a specific customer (job). (We have the “jobs” under customers and subcustomers not projects.) We have tried the Profit and Loss Detail by Customer report but this takes materials (cost of goods sold) and does all the fancy accounting stuff and applies invoices to them. We just want a simple report that will show a list of current expenses (materials, subcontractors, etc.) and any payments that the customer has made. We would not be using it for tax purposes, just simply to see the status of a job at a specific time. It could be like a check register, listed chronologically, and a running balance on the side. Or it could be similar to the profit loss statement but without the cost of goods stuff going on. We have also tried the Troansaction List by Customer but it also splits the cost of goods sold up. Might be doing something wrong. Any help would be appreciated.