Profit and Loss Report- for all customers

[Jon]

@Tut

There is no such report as a P&L for customers

Only in my dreams!

SQL schema for creating custom reports

Okay, how about a Custom Report that breaks down my sales for 2015 (or any arbitrary period) by Customer? (When I say “sales” here, I mean “amounts invoiced to the customer,” preferably excluding Billable Expenses – but if it has to include Billable Expenses, then so be it.) This would be terribly useful at this time of year, in order to reconcile income tax filings for payments reported by each client (Form 1099-MISC here in the U.S.) against company records of billings. Something like this: …