General ledger> Reports> Reconciliation> Project> Transaction> Ledger updates - Profit & Loss

Use this report to analyze the following information:

How project transactions are posted on profit and loss accounts in General ledger.
Which project transactions make up a profit and loss account.
Transactions that are displayed in the corresponding ledger reconciliation report.
You can view transactions for all projects, one specific project, all profit and loss accounts, or one specific profit and loss account.

The relationship between figures in this report and the posting setup

Not applicable – This is not a relevant combination.

Included - This field will be included in the report list:

Included 1. Only item transactions

Included 2. Only when posted to profit & loss accounts

Account	Posting - Cost amount	Posting - Sales amount
About cost	Included	Not applicable
About payroll allocation	Not applicable	Not applicable
About WIP cost value accounts	Not applicable	Not applicable
About item cost	Included 1	Not applicable
About WIP cost value item accounts	Not applicable	Not applicable

Not applicable – This is not a relevant combination.

Included - This field will be included in the report list:

Included 1. Only item transactions

Included 2. Only when posted to profit & loss accounts

Account	Posting - Cost amount	Posting - Sales amount
About invoiced revenue	Not applicable	Included 2
About on-account invoiced revenue	Not applicable	Included
About sales value and accrued revenue	Not applicable	Included
About WIP sales value accounts	Not applicable	Not applicable
About accrued revenue through production	Not applicable	Included
About WIP production accounts	Not applicable	Not applicable
About accrued revenue through profit	Not applicable	Included
About WIP profit accounts	Not applicable	Not applicable

Tip
By default, information on the report is sorted by project and then by ledger account. Alternatively, information on the report can be sorted by ledger account and then by project.

Navigating the form

The following links and table provide descriptions for the controls in this form.

Button	Description
Select	Open a query, and select the data to include. View the data selections of some reports in the Selectquery.
Default	Return to the default settings of the Selectquery.
Options	Set up report delivery, such as formatting for a printer, printing, or saving as a file.
Recurrence	Change the start time and start date of the batch job, or set up a recurring batch job.

Field	Description
From date/ To date	Specify a start date and end date to include in the report transactions that are posted to the ledger.
Project view	Select how to display the first column of the report.
Project level	Specify the number of subproject levels. Select 0 to display all projects that are summarized in one line, 1 to display only parent projects, and 2 to display subprojects. The projects below the parent project level are summarized on one line, and an asterisk (*) indicates if the summarized number includes subprojects below the first subproject level.
Skip zero	Select whether to exclude all rows in the report where the amounts are equal to zero.