Solved

prior year reports

Posted on 2014-02-10
6
708 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
  • 3
  • 3
6 Comments
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
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
Comment Utility
Testing this now.
0
 

Author Comment

by:AE_JB
Comment Utility
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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 90

Accepted Solution

by:
John Hurst earned 500 total points
Comment Utility
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 90

Expert Comment

by:John Hurst
Comment Utility
@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
Comment Utility
Your assessment/solution was spot on.   Thanks.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

744 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now