Quickbooks Custom Transaction Report in Summary
I have a report I run every month with the following columns.
Date, Number, Name, Account, Paid/Amount
I run this report monthly for each month and it does great. Now I need a year-end report that summarizes the totals by accounts rather than providing the transaction detail by account.
I have QuickBooks 2012 Windows so please tell me how to create the summary totals by account.
Thanks,
Randal
Date, Number, Name, Account, Paid/Amount
I run this report monthly for each month and it does great. Now I need a year-end report that summarizes the totals by accounts rather than providing the transaction detail by account.
I have QuickBooks 2012 Windows so please tell me how to create the summary totals by account.
Thanks,
Randal
Hi Randal,
If you want a summary report, under Reports pick Custom Summary Report.
In the report options (or Modify Report) you probably want to change two options:
1) Date range (This Fiscal Year?)
2) Display rows by: Change this to "Account list" to view by account, or "Customer" to view by customer name, etc.
If you change the "Display columns by" you can control how many coluimns i.e. broken down by month as opposed to "Totals only" which is the default.
In there you also have options to view % change from previous periods, etc. But the two options I mention above will give what I think you describe.
If you want a summary report, under Reports pick Custom Summary Report.
In the report options (or Modify Report) you probably want to change two options:
1) Date range (This Fiscal Year?)
2) Display rows by: Change this to "Account list" to view by account, or "Customer" to view by customer name, etc.
If you change the "Display columns by" you can control how many coluimns i.e. broken down by month as opposed to "Totals only" which is the default.
In there you also have options to view % change from previous periods, etc. But the two options I mention above will give what I think you describe.
ASKER
Thanks for the detail on how to get the summary report. Before posting the question, I tried just altering the dates but I still got all of the transaction detail I don't want. So the custom summary report option is something I didn't know about so glad you told me.
I am close but for some reason the report is including the retained earnings account and I don't have it ticked in the multiple accounts selection box. Also, these are expenses and they aren't showing as minuses and they do in the monthly report I run now.
Do you have any suggestions on how to make those two changes?
I am close but for some reason the report is including the retained earnings account and I don't have it ticked in the multiple accounts selection box. Also, these are expenses and they aren't showing as minuses and they do in the monthly report I run now.
Do you have any suggestions on how to make those two changes?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
can you not simply just alter the dates up at the top of the report?