New Free Article

Publication of new articles is announced by the free Govcon Newsletter.

Newly published articles are available to the public and non-subscribers for a limited time period before moving to Premium Content.

To receive announcements of newly published articles available to the public before they are moved into Premium Content, subscribe to the free Govcon Newsletter.

How to create the Labor Distribution report in Quickbooks

The labor distribution report is one of the most import reports that DCAA will require when auditing your Quickbooks system. It is also needed to reconcile labor costs to payroll and billings. The labor distribution report is not a standard report in Quickbooks and will need to be customized. This article will demonstrate how to create the labor distribution report in Quickbooks.

Step 1: In Quickbooks, go to Reports and click on Employees and Payroll then select Payroll Item details. 

distribution1.png

Step 2: The Payroll Item Detail Report will open. To customize the Labor Distribution by Employee, click on Customize Report. 

Payroll Item Detail 1.PNG

Step 3: Scroll down the Columns box. Select only for (left margin), Date, Num, Name, Source Name, Account, Qty and Amount. In the Total by box select Employee.

Payroll Item Detail 2.PNG

Step 4: Click on the Filters tab. Select"Payroll Item" in the Current Filter Choices box, and then "Multiple payroll items". Select all payroll items that would be on a timesheet.

Payroll Item Detail 3.PNG

Step 5: Click on Header/Footer. Rename the report Labor Distribution by Employee. Click OK. Memorize the report to the DCAA folder as Labor Distribution by Employee.

Payroll Item Detail 4.PNG

Step 6: When you open the custom report, Labor Distribution by Employee, set the date range to the beginning and end dates of the payroll period to display the Labor Distribution report.

Payroll Item Detail 5.PNG
Govcon_Accountants_Web-01.jpg
lead generator