Profit & Loss by Job report

Options
Larissa Hicks
Larissa Hicks Member Posts: 22 ✭
edited June 2020 in Accounts Hosted
Profit & Loss by Job Report.
We have Customers & Jobs set up for the different Sites we work at. 
Is there a way to change this report so that it just shows a total for each Customer and not each job. 
I can modify the report with filters by the name of each job for most of them as we only have one job for each customer, however there is one Customer we have more than one Job going at any one time, which I am just after a total for this customer.

Comments

  • Linda ABC
    Linda ABC Accredited Partner Posts: 1,131 Accredited Partner Accredited Partner
    edited June 2020
    Options
    You could try exporting the report - but making sure that Auto Filtering is turned on before exporting (see the Advanced tab when you click Export)... then when you open the report in Excel you should be able to filter across the top to roll up the jobs to a single customer total?
  • Kwikbooks (Professional Partner)
    Kwikbooks (Professional Partner) Member Posts: 824 ✭✭✭
    edited April 2020
    Options
    Hi Larissa

    Try Custom Summary Report - Filter>date - all >Account - all inc/exp > Name - Customers>multi names & tick the customers only not the jobs  - On display tab - Accrual > display column - total only > Display rows - Customer.

    If it works for you - modify>Header/Footer - rename report Title (cust.summary) > Fonts if you want - and memorise the report for future.

Categories