prior year reports

Posted on 2014-02-10
Medium Priority
Last Modified: 2014-02-13
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.
Question by:AE_JB
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 97

Expert Comment

by:Experienced Member
ID: 39849961
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.

Author Comment

ID: 39850453
Testing this now.

Author Comment

ID: 39850552
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.

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

LVL 97

Accepted Solution

Experienced Member earned 2000 total points
ID: 39850842
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.
LVL 97

Expert Comment

by:Experienced Member
ID: 39854875
@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.

Author Comment

ID: 39856395
Your assessment/solution was spot on.   Thanks.

Featured Post

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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question