Labor Accounting and payroll setup

Labor Accounting and payroll setup

Labor accounting and Payroll--

Assign Payroll Expense Account at Department Level



2. Enter Labor Inventory Account in the WIP Account Field on Payroll Expense Liability Account


This setup ensures that when labor is added to a work order, a journal entry is automatically created to credit Labor Inventory and debit Payroll Expense Liability. 

*Note: The Technician's department will determine which department settings will be used for labor inventory. 



How It Works:

  • When labor is applied to a work order:

    • A WIP journal entry is created.
    • This entry adds a positive amount to the Labor Inventory account (representing the cost of labor being held as WIP Labor Inventory).
    • Simultaneously, it subtracts that same amount from the Payroll Expense Liability account.
  • When the work order is closed and invoiced:

    • Another journal entry is automatically created.
    • This entry subtracts the labor cost from the Labor Inventory account (indicating that the labor is no longer in progress but completed).
    • At the same time, it adds a positive amount to the Labor Cost of Goods Sold (COGS) account, reflecting that the labor costs have now been recognized as a sale.
  • Payroll Journal
    • The balance of the Payroll Expense Liability account will be reduced to zero via an offsetting asset account during your payroll journal entry.  


Advantages of Best Practice Setup:

  1. Accurate Labor Cost Tracking:

    • This setup enables precise tracking of labor costs in two stages:
      • While the work is in progress (WIP), labor costs are temporarily held in a labor inventory account.
      • Once the job is invoiced, the labor cost is automatically transferred to the cost of goods sold (COGS).
  2. Payroll Reconciliation with Actual Costs:

    • This setup also allows for effective reconciliation with actual payroll, assuming labor costs are accurately assigned to technicians:
      • If the payroll expense liability account has a positive balance at month-end, it indicates that technician costs are set too low.
      • If the payroll expense liability account has a negative balance at month-end, it suggests that technician costs are set too high.

    • Related Articles

    • Check Format Setup

      To set up the check formatting in Softbase 3.0, you will first access the Check Format Setup program in Softbase, located under Company Setup on the Accounting Tab. When the Check Format Setup program launches, there will be a blank field for the ...
    • Salesman Commission & Territy Setup

      Softbase Documentation Change Employee Password Version: Softbase 3.0 Last Updated: 10/13/2021 • Salesman • Salesman Commission & Territory Setup Softbase will generate commission reports for your company. These are the guidelines of the territory ...
    • Parts Reconciliation using Accrual Based Accounting

      To reconcile inventory, there are a few variables that need to be considered when looking at your physical valuation when comparing it to the GL account balance. First, the costing method being used to value inventory will be either replacement cost ...
    • Warehouse Setup

      Location The Warehouse Setup is located In the Parts Setup window via the "Setup" option at the top. Once you are in the Parts Items Setup window, click the "Warehouses" tab. Mandatory Fields 1. Warehouse Name (The dropdown box to the right of this ...
    • Softbase Service App Setup

      Overview This article covers how to download and setup Softbase Service on the devices your technicians will use to work the dispatched Work Orders to them. Steps Download the Softbase Service Mobile Application from the Apple or Google Play Store. ...