• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 825
  • Last Modified:

prior year reports

Our company upgraded from Quickbooks Premier Nonprofit 2011 to Quickbooks Enterprise Nonprofit 2014.
The finance manager reports difficulty running reports for prior years:

General ledger report customized to show the Travel expense account using the dates “all” shows prior year transaction detail. But if I modify the dates to be from 10/01/2011 to 02/10/2014 the detail for prior years does not display.

Any assistance is appreciated.  Thanks.
0
AE_JB
Asked:
AE_JB
  • 3
  • 3
1 Solution
 
John HurstBusiness Consultant (Owner)Commented:
Try the follow for General Ledger:

Reports, Accountant and Taxes, General Ledger. In Dates, select Last Fiscal Year. Now go to Customize Report, and select a multi year period in the Customize setup. Say OK and refresh the main report.

I have two years of General Ledger on my screen.

If you go to Reports, Custom Reports, Transaction Detail, you can do the same as above and see two years (or more) of transactions.

On the other hand, if you select an account (account list) and the select Quick Report, any attempt at multi year by account will have prior years summarized showing the closing entry.

So there are some capabilities (first two suggestions) and some limitations (last point above).

Please let us know if we can help further.
0
 
AE_JBAuthor Commented:
Testing this now.
0
 
AE_JBAuthor Commented:
The details are shown if the report is run at full year increments, but if the reports are run with custom dates, the details from prior years is not shown.  
For example,
Reports, Accountant and Taxes, General,  Custom, Select customize report, Filters, Multiple accounts, Select 3 travel reports, OK, Then select date range from 2011-2014.
This returns summarized data for previous years, and detail for current fiscal year


It does the same thing for reports of transaction detail by account.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
John HurstBusiness Consultant (Owner)Commented:
Yes, the only way you can get details by year in these reports is by full year. Any other selection will collapse all but the current year with collapsed in a year end entry.

It has been like that for as long as I have used QuickBooks. I have looked before and I looked again before I posted here.

So to see multiple years of transactions, you must use a report that is appropriate (as above) and break on fiscal years.

You can go to the Profit and Loss report, double click on an account which pulls up details. If you are working on a fiscal, Customize Report allows you to span multiple fiscal years. This one works quite well because you are working off a basic profit and loss report.
0
 
John HurstBusiness Consultant (Owner)Commented:
@AE_JB - Thank you very much indeed and I was happy to help. I know QB has these limitations, but at least there is some functionality there for you.
0
 
AE_JBAuthor Commented:
Your assessment/solution was spot on.   Thanks.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now