#reports quickbooks

[getmytime-blog]

Job Profitability Summary Report

The Job Profitability Summary report on QuickBooks summarizes the profits of your company that you earned from serving each customer within a specific time range.

The key column in this particular report is the Percentage of Difference. This column tells you exactly which customers are bringing in more profit and which are not.

    To generate a Job Profitability Summary report, follow these steps:

 1. Go to Reports > Jobs, Time & Mileage.

 2. From the side menu, select Job Profitability Summary.

The Job Profitability Summary report will give you a summary of how much your company has earned from a specific date for each customer. If your company performs different jobs different customers, then the report will display the subtotal for each job so you’d know which jobs are more profitable and make the necessary adjustments or evaluations.

 When viewing this report, please try to take note of these three columns:

1. The Account Cost column. This particular column will display all the cost that your company incurred for a specific customers within a given date range. If your company also uses QuickBooks payroll, the cost will include salaries and wages that are incurred or assigned to specific jobs.

2. The Account Revenue column. This particular column will display the income tht your company received from each customer and job within a specific date range.

3. The ($) Difference Column will show the difference between your cost and your revenue. A positive amount on this column will mean that your company did make money while a negative amount means that your company lost money on a particular customer or job.

  Modifying the Job Profitability Summary Report

The Job Profitability Summary report can be modified to show the Percentage of Difference to show you which companies are more profitable and which are not.

To modify the Job Profitability Summary report, follow these steps.

1. From the Job Profitability Summary report, click on the “Customize Report” button.

  2. On the “Display” tab, check the box beside “% Difference.”

  3. Click “Ok.”

Your Job Profitability Summary report will now display the % of Difference. From there, you can see which companies brought in more revenue and which incurred more expenses.

[getmytime-blog]

Customer Balance Detail

The Customer Balance Detail report will display all transactions that is related to your customers. This particular report will group transactions by customer and job which will make it easier for you to view the reports. The Balance column will display unpaid balances for each customer and job. If you see a total of $0.00, that means that the customer has paid all his/her balances. To create Customer Balance Detail, follow these instructions: 1. On the main menu, click Reports > Customers & Receivables. 2. From the side menu, select Customer Balance Detail.

Customizing the Customer Balance Detail Report

By default, the columns on the Customer Balance Detail will show (from left to right) type, date, number, account, class, amount and the balance. You can further customize the report by clicking on the Customize Report button.

On the Modify Report window, under the Columns box, check on the items that you want to show on the report.

  If you want to further filter the report, click on the Filters tab.

The Choose Filters menu would allow you to dictate the specific items that you want to display on the report. Here are some of filters that you can select from: Account, Amount, Date, Item, Memo, Name, Number, Transaction Type, etc. You can even choose to customize the report for printing or email. You can opt to insert customized Headers, Footers and as well as the alignment. To do this, click on the Header/Footer tab.

  If you want to go back to the system default, click on the Revert button. Lastly, you can also the Fonts for your report. Simply click on the Fonts & Numbers tab. Take note though that the fonts available will be for the fonts available only on your computer.

[getmytime-blog]

Profit and Loss by Job

The Profit & Loss Report by Job will show you how much you are earning and losing on each job. Subtotals for each specific type of income or expense is displayed which enables you to identify exactly from where your income is coming from and where it is being spent. To create the Profit and Loss by Job report, follow these steps: 1. On the main menu, click on Reports > Company and Financial. 2. From the side menu, select Profit & Loss by Job.

           Figure 1: Creating a Profit & Loss Report in QuickBooks

What you have to note though is that the Profit & Loss by Job report does not include all other income and expense transactions. This particular report is Customer: Job specific which implies that the amount reflected in the Profit & Loss Report by Job and the Standard Profit & Loss Report will always differ.