General ledger> Reports> Reconciliation> Project> Ledger reconciliation - Profit & Loss

Use this report to analyze how totals of project transactions are posted to profit and loss accounts in the General ledger module.

You can use the report to reconcile ledger transactions that are generated in the Projectmodule.

The relationship between figures in this report and the posting setup

Cost price accounts

Not applicable - This is not a relevant combination.

Included - This field is included in the report list:

Included 1. Only hour transactions

Included 2. Only cost transactions

Included 3. Only item transactions

Included 4. Only when posted to profit & loss accounts

Included 5. Calculation: Employee + Cost + Inventory

Included 6. Calculation: Accrued turnover + Invoiced turnover

Account	Posting - Cost - Hour	Posting - Cost - Expense	Posting Cost - Item	Calculation 1) Cost - Total	Posting- Accrued revenue	Posting - Invoiced revenue	Calculation 2) Total revenue	Ledger	Difference
Cost	Included 1	Included 2	Included 3	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
Payroll allocation	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
WIP - Cost value	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
Cost - Item	Not applicable	Not applicable	Included	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
WIP - Cost value - Item	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
Accrued loss	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
WIP - Accrued loss	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable

Sales price accounts

Not applicable - This is not a relevant combination.

Included - This field is included in the report list:

Included 1. Only hour transactions

Included 2. Only cost transactions

Included 3. Only item transactions

Included 4. Only when posted to profit & loss accounts

Included 5. Calculation: Employee + Cost + Inventory

Included 6. Calculation: Accrued turnover + Invoiced turnover

Account	Posting - Cost - Hour	Posting - Cost - Expense	Posting - Cost - Item	Calculation 1) Cost - Total	Posting- Accrued revenue	Posting - Invoiced revenue	Calculation 2) Total revenue	Ledger	Difference
Invoiced revenue	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Included	Included	Not applicable	Not applicable
Invoiced revenue - On account	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Included 4	Included 4	Not applicable	Not applicable
Accrued revenue - Sales value	Not applicable	Not applicable	Not applicable	Not applicable	Included	Not applicable	Not applicable	Not applicable	Not applicable
WIP - Sales value	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
Accrued revenue - Production	Not applicable	Not applicable	Not applicable	Not applicable	Included	Not applicable	Not applicable	Not applicable	Not applicable
WIP - Production	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
Accrued revenue - Profit	Not applicable	Not applicable	Not applicable	Not applicable	Included	Not applicable	Not applicable	Not applicable	Not applicable
WIP - Profit	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
Accrued revenue - On account	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
WIP - Invoiced - On account	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
Accrued revenue - Subscription	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
WIP - Subscription	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
Invoiced revenue	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable
Invoiced revenue - On account	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	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 report

The following links and tables provide descriptions for the controls in this report.

Enter criteria on the General tab

Prepare batch processing on the Batch tab

Buttons

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.

Fields

Field	Description
From date/ To date	Specify a start date and end date to include in the report profit and loss 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.