Solved

QuickBooks Pro 2012 Need a Report

Posted on 2012-03-09
11
537 Views
Last Modified: 2012-03-10
I am running with 3 Bank accounts.  For some reason when I run the report "Gross Revenue by Item" I get the revenue from 2 accounts.  Instead of the one I want.

I can tell it is getting values from the second account because it is saying there is uncategorized income.  This only shows up in the second account that I don't want included.  I am used to Quicken and you could pick and choose where you wanted to draw your numbers from.

Please tell me how to get the report I am needing.

Thanks,

Randal
0
Comment
Question by:sharingsunshine
  • 7
  • 4
11 Comments
 
LVL 90

Expert Comment

by:John Hurst
ID: 37703305
In QuickBooks, in any Report (just about any Report), click on Customize Report (upper left) and then click on Filters tab. In there you can click on Account and then to the right, use the pull down to select Multiple Accounts and then select the accounts your want.

This is a method I use all the time in Reporting and the selections you can alter are much broader than just accounts.  

.... Thinkpads_User
0
 

Author Comment

by:sharingsunshine
ID: 37703616
I found the multiple accounts and when I clicked the THP 2012 Bank account it said the report would be blank.  I then tried checking the accounts instead and it produced a blank report.

This is the report in Quicken we are used to, I have removed the values and totals.

So please tell me (step by step) how to get this report to print.  By the way all of the accounts, in the report, are in the Chart of Accounts.

Thanks,

Randal
Print-AR-Summary.pdf
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 37703636
If you have accounts in the chart of accounts that are empty (producing a blank report) you can hide them. For most reports, hidden accounts won't be used.

Please let me know precisely where you found the report (the menu and the precise name) and I will run it and see. I use QB V2012 Premier Accountant and did not a report by that name (although I see and I use item reports from time to time).

... Thinkpads_User
0
 

Author Comment

by:sharingsunshine
ID: 37703680
That report is what I am used to in Quicken.  The closest thing in QuickBooks is Gross Revenue by Item.

The accounts aren't empty that I am using.  I think I must have something wrong with how to do the filters.
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 37703726
The report I have that looks like that is Sales by Item Detail. This is Revenue by Item. It is most likely a difference in my version (Canadian) and your version (not-Canadian I think).

Items are in your Item list. Items point to accounts and this is how that report works.

So go to QuickBooks, Lists, Item List and look at that list. You may see the accounts in here that you don't want (and can edit out of the item).

Also, look in your Chart of Accounts (list it). Notice that accounts have types. Bank is a type, Income (Revenue) is a type and Expense is a type. There are more types.

Now, back to your first post, I am not sure why Bank accounts get into a Gross Revenue report. You need to make sure each account has a proper type.

... Thinkpads_User
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 90

Expert Comment

by:John Hurst
ID: 37704832
Hello Randal,  I went back and reviewed all this.

Gross Revenue by Item: Items are a defined thing in QuickBooks, not just a term. Since you came from Quicken and are just starting with QuickBooks, you may not have Items, and if not, that explains why an Item report would be blank.

So look in QuickBooks, Lists, Item List and let us know what is there.

Please review your Chart of Accounts and check the accounts with account types that they make sense. I am concerned about your Bank Accounts. Please let us know on this.

Your Bank Account is (a) Bank type and (b) a Balance Sheet account. Bank Accounts should not have come in a Sales by Item report. See if you can see why that might be and let us know.

... Thinkpads_User
0
 

Author Comment

by:sharingsunshine
ID: 37704973
I think I may have found the problem but don't know how to fix it.  We have all of our transactions that we imported from Quicken.  Some of the transaction types we used were EFT, XFR, TXFR.  Quickbooks doesn't have these transaction types so it seems to be putting it in the uncategorized column.

In the Number
              Type         column of the register it shows

EFT
CHK

How do I change the transaction type to what it should be?  These are transactions where the credit card company drafts our account for payment.  We also use EFT to pay the taxes online.  So I am thinking I need to clean up these transactions before the report will be correct.
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 37704988
You are correct that QuickBooks does not have these types. I am traveling for the next few hours, will think about it, look at my QB ledgers and get back to you.
0
 
LVL 90

Accepted Solution

by:
John Hurst earned 500 total points
ID: 37705515
The news here is not altogether good.

First, here is an extract from a ledger of mine showing the common QuickBooks Types. These types are defined by QuickBooks.
----------------------------------
1001 · Bank Account
            
Type Date       Number       Name       Split  Debit      Credit      
            
Cheque 01/03/2012 Bank Charge Bank 5401 · Bank charges            0.00

Bill Pmt -Cheque 01/04/2012 344 Government 2000 · Accounts Payable            0.00

Deposit 01/06/2012                  1499 · *Undeposited Funds      0.00       

Cheque 01/12/2012      TX56-3957 Owner      1004 · Cash Advances            0.00

Deposit 01/15/2012                  1499 · *Undeposited Funds      0.00       
---------------------------------
You can see the basic types down the left and these are assigned by QuickBooks. They are forms (deposit, bill, cheque and invoice forms). Each form has a type.

Your types (from Quicken) are not QuickBooks types. The problem is: I don't think you can change them. At least, if you can, you would need a third party tool to do it (Intuit Marketplace)

Here is an article from the QuickBooks forum supporting my conclusion above. What they are suggesting (and I saw in other places) was to delete and re-enter the transactions. That could be time consuming, of course.

http://community.intuit.com/posts/changing-transaction-type-2#

... Thinkpads_User
0
 

Author Closing Comment

by:sharingsunshine
ID: 37706062
I appreciate you finding the link on transaction types and your help.
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 37706090
Thank you Randal. I was very pleased to help. Good luck with QuickBooks, and do not hesitate to ask for assistance as we are here to help. ... Thinkpads_User
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

760 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

17 Experts available now in Live!

Get 1:1 Help Now