Looking at past payroll runs in QuickBooks

Most people I work with find this a lot harder than it needs to be. QuickBooks Online buries the payroll history in a couple of different places depending on what version you run and whether you use QuickBooks Payroll or a third-party provider. I spent about forty-five minutes last Tuesday helping someone locate their Q4 2023 wages because she kept clicking through Reports instead of the actual transaction list. Here is what I learned doing this repeatedly across different client setups. Start by going to the plus button in the upper left corner. Select Transactions from the menu. From there you will see categories like Journal Entries, Checks, and Bill Payments. If your company runs QuickBooks Payroll directly through Intuit, each payroll run generates either a journal entry or a series of related transactions depending on your setup. You can also navigate to Banking and then search for deposit or check entries containing "Payroll" in the memo field. That usually surfaces everything from the last six months in under two minutes. Another approach that works faster once you know it: go to Reports and type "Payroll Liability Balance" in the search box. This report does not show individual employee wages but it does give you the aggregate numbers for each pay period, which is often enough when you are reconciling or validating totals. If you need line-by-line detail for a specific employee, go back to the Transactions screen and filter by Payroll Expense accounts. The expense accounts vary by company, but they usually include Payroll Tax Liabilities, Workers Compensation Expense, and Salaries and Wages.

One thing that trips people up constantly: QuickBooks Online does not maintain a single continuous payroll history file the way desktop QuickBooks used to. Each payroll run creates its own independent transactions, and if you delete or void a payroll check, those transactions disappear from the default views unless you specifically enable the "Show deleted" filter in the transaction list. I learned this the hard way when a client tried to audit a discrepancy and the offending entry had been voided three months earlier. I had to export the full register from the Banking tab and then cross-reference it against the bank statements to reconstruct what actually happened. Here is a counter-intuitive point that nobody mentions: the "Payroll" menu in QuickBooks Online is primarily a setup and run interface, not a reporting interface. People expect to find historical data there, but it mostly contains buttons for running new payroll, managing employees, and adjusting tax settings. The actual history lives in the general transaction and reports area. This design choice makes sense if you think about it, because payroll in QuickBooks is transactional, not archival. The system generates the records as side effects of running payroll rather than maintaining a dedicated ledger. If you are using a third-party payroll provider like Gusto, ADP, or Paychex, the process changes completely. These integrations typically push summarized journal entries into QuickBooks rather than detailed line items. You will see one compound entry per pay period with total wages and total taxes, but the employee-level breakdown stays in the provider's system. In my experience, this causes problems during tax season when auditors want to see individual employee histories. The workaround is to export the payroll report directly from the third-party provider and then attach it to the QuickBooks transaction as a supporting document. It is not elegant, but it works.

A limitation worth stating plainly: QuickBooks Online's free trial and basic plans do not include the full transaction audit trail. If you are on the Simple Start plan, you can see transactions but you cannot filter by deleted or voided entries, and the report customization options are severely limited. Upgrading to Essentials or Plus unlocks the advanced filters and the ability to create custom payroll reports, but that runs about thirty to fifty dollars per month more. For small operations doing occasional audits, the extra cost may not justify the time savings. A cheaper alternative is to export the transaction list to CSV quarterly and maintain your own archive using Google Sheets or Excel. It requires discipline, but it eliminates the dependency on QuickBooks' restrictive views. Specific technical tip that saves time: use the "Accountant" role when granting access to whoever needs to review payroll history. Accountants get access to the full transaction register including voided entries, custom report creation, and the ability to adjust prior period entries. Regular users are locked out of most of these features. If you are sharing payroll access with an external bookkeeper or CPA, make sure they have the accountant role rather than just the standard user role. It took me several months to realize this was the bottleneck preventing my clients from accessing their own historical data.

Get the Full Details

How to do payroll in QuickBooks online? - 2024 Ultimate Guide
How to do payroll in QuickBooks online? - 2024 Ultimate Guide

Exporting and archiving considerations

QuickBooks Online allows you to export transaction lists in CSV or Excel format, but the export functionality has limitations. You can export up to a thousand records at a time, and the date range filter defaults to the current fiscal year. If you need three years of payroll history, you will have to run multiple exports and stitch them together manually. I wrote a simple Python script that automates this process using the QuickBooks API, but that requires developer access and OAuth setup. For most small business owners, the manual export approach takes about twenty minutes per year of history, which is acceptable if you do it quarterly rather than waiting until tax time. Another practical issue: QuickBooks Online does not preserve the original payroll check images or supporting documents after you close the books. If you need proof of payment for a specific employee in a prior period, you will have to rely on bank statements or the third-party payroll provider's records. This is a fundamental limitation of cloud-based accounting systems, and it is worth understanding before you commit to QuickBooks as your primary platform. If document retention is critical to your operations, consider using a dedicated payroll solution with built-in archival capabilities alongside QuickBooks rather than relying on QuickBooks alone. The bottom line is that viewing payroll history in QuickBooks Online is possible, but it requires knowing where to look and understanding the system's limitations. The transaction-based design means there is no single continuous history view, and the reporting features are more limited than they appear in marketing materials. For most users, the combination of the Transactions screen with the Banking search and the quarterly CSV export approach covers the vast majority of audit and reconciliation needs. If you find yourself needing more sophisticated historical analysis, it is probably time to evaluate whether QuickBooks is the right tool for your operation or whether a more specialized payroll system would serve you better.