This report shows the profit made for each job on every Expense/Sale within a given period of time.



Input:

Following are input for this report



From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format



Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report



Job #

 Job number.

Customer

 Customer name the job is done for.

Job

 Job description.

Status

 Status of the job.

Milestone

 Job milestone profit/loss transaction is related to.

Type

 Type of profit/loss transaction.

Date

 Effective Date of profit/loss transaction.

Reference

 Transaction reference.

Expense

 Expense associated with the transaction in base currency without tax.

Tax

 Tax associated with the transaction in base currency.

Income

 Income associated with the transaction in base currency without tax.

Profit

 Profit = Income - Expense. Only visible in Totals

Tax

 Tax if any in base currency.

Address

 Job address.

Contact

 Job contact details.

Supplier

 Supplier name for transaction type "Purchase".

Start

 Date when job started.

Finish

 Date when job has been completed.

Year

 Year of Effective Date of profit/loss transaction.

Quarter

 Quarter of Effective Date of profit/loss transaction.

Month

 Month of Effective Date of profit/loss transaction.