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 September 15th, 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.


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.

Learn how to create a payroll ledger.

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 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.

Find out how to create a payroll ledger.

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.

See our payroll ledger template.

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' salary/wages.

See our free template.

Where can I find an employee payroll ledger template?

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

Download our free template.