Quickbooky

Accounting News

Payroll

Louisiana Form L-1 Payroll Report in QuickBooks: What It Covers and How to Generate It

QuickBooks includes a built-in payroll report for Louisiana Form L-1 reconciliation. Here is what the form requires and how to produce the report.

Louisiana Form L-1 Payroll Report in QuickBooks: What It Covers and How to Generate It

Louisiana employers who withhold state income tax from employee wages must file Form L-1 with the Louisiana Department of Revenue each quarter, and QuickBooks Desktop offers a dedicated report designed to populate the figures that reconciliation requires. The report pulls withholding data directly from payroll records, though users still need to understand the state’s filing rules, deadlines, and payment procedures to complete the form accurately.

What Form L-1 Covers

Form L-1 serves as the quarterly reconciliation return for Louisiana state income tax withheld from employee wages. Each return covers one quarterly taxable period, and employers must file one for every quarter — even in quarters where no wages required withholding or no taxes were withheld at all.

A significant change took effect for filing periods beginning January 1, 2012. Prior to that date, Form L-1 functioned as a payment voucher. Since then, it has been used strictly as a reconciliation return, not for making payments. The revised form applies only to periods on or after that date and should not be used for earlier filing periods.

The Louisiana Department of Revenue mails out the four Form L-1 returns after March 20th each year. Each form corresponds to a specific quarter and is used to report and reconcile state income tax withheld during that period.

Filing Deadlines

The standard due date for Form L-1 is the last day of the month following the close of the quarter. Semimonthly payers face an earlier deadline — the 15th of the month following the close of the quarter. When a due date falls on a weekend or holiday, the return is due the next business day.

How Payments Work

Because Form L-1 is now a reconciliation return rather than a payment voucher, payments are submitted separately through the state’s online portal, Louisiana Taxpayer Access Point (LaTAP). Semimonthly payers are required to submit payments electronically; there is no paper alternative for that category.

The Account Number Requirement

One point that catches employers off guard: the state will not process withholding returns that lack a correct account number. Submissions showing “Applied For” in place of an account number will be rejected. Businesses must file the appropriate application with the Department of Revenue before sending any return. The state processes those applications within three business days of receipt and then sends a letter containing the assigned account number. Financial penalties apply when a required account number is omitted from a return.

Generating the L-1 Report in QuickBooks

QuickBooks Desktop includes a built-in report specifically for Louisiana Form L-1. The report prefills most fields automatically using the company, payroll, and employee data already stored in the company file. In most cases, if all payroll data has been entered consistently throughout the quarter, little or no manual entry is needed beyond reviewing what QuickBooks has populated.

Step-by-Step: Producing the Report

  1. Open QuickBooks Desktop and navigate to the Employees menu at the top of the screen.
  2. Select Payroll Forms or Payroll Center, depending on your version.
  3. Choose Process Payroll Forms to open the payroll forms list.
  4. Locate and select Louisiana Form L-1 from the list of available state forms. If you do not see it, confirm that your QuickBooks payroll tax table is current, as state forms are delivered through tax table updates.
  5. Select the quarter you need to report and proceed through the on-screen workflow.
  6. QuickBooks will display the form with most fields already populated from your payroll data. Review every field carefully, paying particular attention to any that QuickBooks did not fill in automatically.
  7. Enter any missing information manually. Common fields that may require attention include account numbers or company details that were not previously set up in QuickBooks.
  8. Use the form window’s built-in Help button if you need clarification on a specific field or encounter an unexpected value.

Reviewing Withholding Amounts

The withholding figures on the report are calculated from the payroll transactions recorded during the selected quarter. If a number looks off, the underlying issue is usually a paycheck dated in the wrong period, an incorrect state withholding setup on an employee record, or a missing or duplicated paycheck. Running a payroll summary report for the same quarter and comparing the Louisiana state income tax withholding total to the figure on Form L-1 is a reliable way to verify accuracy before filing.

Exporting to Excel

For users who want to work with the data outside of the form view, QuickBooks provides an option to summarize payroll data in Microsoft Excel. This can be useful for internal record-keeping or for cross-referencing figures across multiple quarters. The export option is available from the report or form window.

Saving a Copy

QuickBooks allows you to save a copy of the completed form for your records. This should be done before closing the form window, as the saved copy serves as documentation of what was reported and reconciled for each quarter.

A Note on Data Completeness

The L-1 report is only as accurate as the payroll data behind it. Employers who have kept employee profiles, wage details, and withholding settings current throughout the quarter will find that QuickBooks handles nearly all of the calculations. Those with gaps in their payroll records — missing paychecks, incorrect state tax assignments, or employees set up without Louisiana withholding — will need to correct those issues before the report will produce reliable figures. Running the report early, reviewing it against a payroll summary, and addressing discrepancies before the filing deadline is the most dependable approach.

← Back to Community Issues