As we head towards another year end, is there any prospect of some more functional payroll reports being introduced? It's still a real pain to get summary of pay costs by employee, which is needed for many reasons, e.g. needing to split pay costs between directors and other employees as required under FRS105 final accounts.
P11 report is quite good, but has to be run individually for each employee and only covers the income tax year, not the company's financial year. Need to be able to customise this to run for all employees and a custom date range to match the company's financial year.
Gross to Net report is quite good but has to be run individually for each month and then the CSV files have to be manually concatenated to make an annual report for the company's financial year.
Drilling down into the general ledger pay account is quite good, but you can't access employees' names. The 'Name' field in the pay journal is not populated with the employee's name. The employee's name is in the 'Memo' field on each journal, but you can't get this feld in transaction reports.
Can we please have some decent, customisable payroll reports that can be run for both the income tax year and the company's own financial year?
Right now, there isn't a customisable payroll report that shows the income tax year and the company's own financial. In the meantime, you can export the two reports to Excel, combine, and customise from there.
Type in the report you'd need (P11 or Gross to net).
Set the necessary filters.
Select the Export icon at the top of the report.
Choose Export to Excel.
Save the file somewhere you can easily find, like your Downloads folder or your desktop.
I can see how having this feature available in QuickBooks would save your business' time. Our goal is to make QuickBooks Desktop the go-to software for small business owners, so we're always looking for ways to improve it. In the meantime, I encourage you to star our blog to keep up with any product updates or improvements on the online version: QuickBooks Online Blog.
To know more about the Payroll reports that you can run in QuickBooks, see below articles:
Excel is what I'm doing already - those 2 reports are only available in CSV format anyway.
Can someone please fix the bug where the Name field in journals is not populated in transaction reports? It's a major pain in all sorts of reports, not just pay costs analysis, because you can see the Name field in all transactions except journals.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
We have to collect some data when you use this website so it works and is secure. We'd also like your consent to collect data to study how people use our site. Doing so helps us improve our services and allows us to tailor the marketing you see on our site. Select 'Accept all' to agree or 'Manage consents' to choose which cookies we use. You can change your mind at any time by clicking the 'Manage Cookies' link.
Choose your cookie preferences
Some cookies are needed to make our website work and can't be turned off. But we need your consent to use others that are not essential. You can make your choices below and update them at any time using the 'Manage Cookies' link. To find out more, visit our Cookies Policy.
These cookies are necessary for the site to function. They also help us keep your data safe.
These cookies allow us to enhance your experience and remember your preferences, region or country, language, and accessibility options.
These cookies tell us how customers use our website. We study and organize this data to help us optimise our content and provide you with personalised experiences.
These cookies help us provide you with relevant communications and ads in our products and on other sites.