Line item income and expense monthly reports Quickbooks Dekstop Pro Plus 2020
My boss would like a report that includes our line items that shows income and expenses for the month. I have tried printing a standard Profit & Loss, Statement of cash flows, general ledger and other income and expense reports but they are not what he wanted. He only wants deposits, checks and general journal entries for the month (but for each active line item). I compiled a general ledger report by taking it to excel and getting rid of the extra details but now he doesn't want to see the undeposited funds trail and now he doesn't want to see invoice. Is there a report that does this without the extra time and compilation?
I am using Quickbooks Desktop Pro Plus 2020.
Have you tried Customizing a Transaction report? that is where i would start, and customize and filter for the things he wants to see. Once you get it perfect, memorize it.
I did try that but even with the customization some inactive accounts and my checking accounts showed up. When I did a Profit & Loss, it would show the total but you have to click on a 2nd report to get the breakdown of the total. The example below is what my boss wants to see on one report.
Jim Jones $300
Sally Smith $300
Total Membership dues $600
If I try an income and expense by customer report it will not query by line item for the month. I have used the General Ledger report and exported it to Excel to narrow it down and adjust manually. I was wondering if there was a faster report that is usable in Desktop Pro?
Thank you for answering.
In your example above, are Jim Jones and Sally Smith sub accounts of Membership dues in your chart of accounts? if not, they won't show up. The P&L is going to show the balances in accounts listed in your chart of accounts.
As for closed/zero accounts, when you open the customize report window, go to Advance, and choose "all Non-Zero", and that should help with zero accounts showing up.
It may be that he is asking for something that can't easily be produced in QB, but only manually adapted in Excel.
You could try customising the transaction report.
This would help you to get only the data that your boss wants on a sheet.
You need not cut out the undeposited funds from that.
yes these are sub accounts in my Chart of Accounts. I appreciate the tip about the zero accounts and will try that. I was hoping that there was a report automatically done in Quickbooks for that but it is only for vendors and customers payments.
My boss stated that he is wanting monthly income and expense reports so that we can verify items are being put in the right accounts. We usually end up fixing things right before the next fiscal year because items were put in the wrong place.
You can run a Balance sheet detail, so you can see the Revenues accounts lines, you can double click on each line to zoom in and see all the clients payments made per date range. Then you can memory that report and name it the best way for you to find it in the Memorize reports and change the date ranges, etc., group class by type of use aka Boss report, etc.. Can also export to excel and play around to what you want.
Also, use Casey's point, to customize Advanced view to show the zero amounts or others, just analyze the best way to display the data for the Boss.
Hope it helps.
Agree, use the detail reports! once things are booked correctly, it is always easy to do a find and see where it was booked in the past, if it doesn't auto-populate.
Thank you for the suggestions. I will give them a try.
Leave a reply