How to Create a Payroll Ledger

Learn how to create a payroll ledger for your business. Includes frequently asked questions and a free template download.

Updated on November 18th, 2019

The SMB Guide is reader-supported. When you buy through links on our site, we may earn an affiliate commission. Learn more

A payroll ledger is a document or spreadsheet that gives an overview of a company's payroll information. The ledger includes the names of staff members, salaries, overtime rates, etc.

Payroll Ledger Template - Free Download

Use our payroll ledger excel spreadsheet to create your own ledger.

Download Now Instant download. No email required.

How to Create a Payroll Ledger:

  1. Open a new spreadsheet.
  2. Label the first column "Employee Name."
  3. Label the second column "ID Number."
  4. Title the remaining columns with applicable items like rate of pay, overtime rate, etc.
  5. Include columns for "Gross Pay" and "Net Pay."
  6. Add the names and numbers of all of your current employees to the first two columns.
  7. Save the spreadsheet.
Payroll Ledger Sample - PDF Download

Use this payroll ledger form in PDF format to create a simple ledger for your business.

Download Now Instant download. No email required.

FAQs:

What is a payroll general ledger?

A general payroll ledger helps you to keep track of how much each of your employees is paid and how much taxes should be withheld from each paycheck.

How do I balance payroll to the general ledger?

  1. Create a payroll report for your most recent pay period.
  2. Compare employee time cards to your payroll ledger to make sure they match.
  3. Compare the rate of pay to make sure it is correct.
  4. Ensure that all deductions have been taken from paychecks.
  5. Enter information in your general ledger based on what is in your payroll summary.

What is a payroll ledger in Quickbooks?

You can use Quickbooks to create a payroll ledger. All of the information will automatically be uploaded to your ledger from your Quickbooks account. In Quickbooks, this is called a payroll summary report.

What is a payroll summary report?

A payroll summary report is the same thing as general payroll ledger - it includes summary information with details about each of your employees' salaries/wages.

Where can I find an employee payroll ledger template?

You can use either one of our templates above to create your own payroll ledger.