Custom Reports :Transactions by Account - how do we format to get only the sums per account?

Hi there Mouselette,

It sounds like you're looking for a report to pull some very specific data, in order to manually calculate your payroll remittances. You've done a great job navigating the reports section in QuickBooks Desktop to try your hand at customizing a few of the existing reports, but from what I can tell, you haven't quite found the right fit. I want to point you in the right direction.

I can glean from your post that you've tried a few different existing report options, but I'm not entirely clear on the exact data you're looking to pull. Checking with your accountant or a QuickBooks-certified ProAdvisor might be the best way to determine if there's a report you can pull to get the right information. An accountant might also be able to advise you of a different way to pull the relevant details. If you're looking to find a new accounting professional to work with, here's how to Find an Accountant.

It may also be helpful to try working with our team of support experts outside of the Community. With a quick screenshare and some additional and specific detail on what you're looking to see, an agent may be able to point you in the direction of the perfect report. Click here to Contact Us.

If you'd like to continue working with me here in the Community, I'll need some more information. I can see what you've tried, and how it hasn't met your needs, but what is the exact data that you'd like to see, and what accounts would you be pulling that data from. Please be as specific as possible. I also want to encourage the accounting professionals and other users here in the Community to chime in if they have any advice to offer. It may be that the report you're looking for isn't available, and in that case, you can Submit Feedback Online through the Help menu.

I wish you all the best and hope you're able to pull the data you need.

Hi Rebecca!

I'll put this in the thread since it may help others along the way:

Note that I have removed info pertaining to the real person - it is sensitive info after all...

Here is a transaction journal of a typical pay, and it lists all the posts ordinarily used. I leave them in even if it is zero when the case arises.

Continued :-)

Ok, now that the year is finished, I need to produce this kind of report (attached).

Now please note that this was not produced using a Payroll module - It was produced using the setup. I never had the Payroll option, ever. I could also reproduce it via the Custom Reports. This was back when I used QBPro2006 (the French version - as we function in French)

So... I need to tally all the transactions from the pays issued throughout the year.

How do I do that?

Thank you! :-)

Sylvie

Oh - and of course, it needs to be compiled per employee, with the total...

But I guess you knew that... LOL

Thanks for getting back to me with those additional details @Mouselette. I have a better picture of what it is you're looking for now. What you're looking for is a very specific report customization from an obsolete version of QuickBooks Desktop, and you won't be able to pull those exact details using your current version ofQuickBooks Desktop. I know that you're familiar with the process of submitting feedback, so this is another instance where I suggest you do that. You won't hear back from our product development team, but they take these suggestions into consideration for future updates and product improvements. As I suggested previously, you might find that working with an agent over the phone or chat in real-time is a better way to figure this out as they'll be able to walk through the process of creating a customized report with you. Don't forget that you also have the option to export reports to Excel so that you can manipulate the data yourself. If you've come across a report or two that sort of meets your needs, you can combine the two together outside the program.

I wish you the best of luck. Have a great day!