Solved

prior year reports

Posted on 2014-02-10
6
757 Views
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.
0
Comment
Question by:AE_JB
[X]
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
6 Comments
 
LVL 95

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.
0
 

Author Comment

by:AE_JB
ID: 39850453
Testing this now.
0
 

Author Comment

by:AE_JB
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.
0
Industry Leaders: 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 95

Accepted Solution

by:
John Hurst earned 500 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.
0
 
LVL 95

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.
0
 

Author Comment

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

Featured Post

Industry Leaders: 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…
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…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

690 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