Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


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 98

Expert Comment

by:John Hurst
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.
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!

LVL 98

Accepted Solution

John Hurst 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 98

Expert Comment

by:John Hurst
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

610 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