Home Page link  

Modifying Quickbooks Reports and/or Categories

 

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Modifying Quickbooks Reports and/or Categories David Hopper 01-31-2007
Posted by David Hopper on January 31, 2007, 11:39 pm
Please log in for more thread options
I need to be able to create a GOP (Gross Operating Profit) line on the
P&L and then add expense items between the GOP line and Net Income
line.

Can this be done.

Using Quickbooks Pro 2006.

Thanks

David Hopper

Posted by Laura on February 1, 2007, 7:16 am
Please log in for more thread options
>I need to be able to create a GOP (Gross Operating Profit) line on the
> P&L and then add expense items between the GOP line and Net Income
> line.
>
> Can this be done.
>
> Using Quickbooks Pro 2006.
>
> Thanks

One way to accomplish this is to change the type for expenses & income
"below the line" to Other Expense & Other Income. QB will then format the
report as follows:

Ordinary Income/Expense
Income
COGS
Gross Profit
Expenses
Net Ordinary Income
Other Income/Expense
Net Income

This is probably the closest you are going to get with out upgrading to the
Premier:accountant version to take advantage of the Financial Statemente
designer. Dump the report to excel and change the "net ordinary Income"
title to "Gross Operating Income".


Posted by David Hopper on February 1, 2007, 10:10 pm
Please log in for more thread options
Thanks, I'm almost there, I have changed all of the Income accounts to
a sub account of "Ordinary Income" and all of the expense accounts to
a sub account of either "Ordinary Expenses" or "Other Expenses". QB
is now seperating them out, but it is not giving me a sub total profit
or loss after totalling "Ordinary Expenses" Any thoughts.


wrote:

>>I need to be able to create a GOP (Gross Operating Profit) line on the
>> P&L and then add expense items between the GOP line and Net Income
>> line.
>>
>> Can this be done.
>>
>> Using Quickbooks Pro 2006.
>>
>> Thanks
>
>One way to accomplish this is to change the type for expenses & income
>"below the line" to Other Expense & Other Income. QB will then format the
>report as follows:
>
>Ordinary Income/Expense
> Income
> COGS
>Gross Profit
>Expenses
>Net Ordinary Income
>Other Income/Expense
>Net Income
>
>This is probably the closest you are going to get with out upgrading to the
>Premier:accountant version to take advantage of the Financial Statemente
>designer. Dump the report to excel and change the "net ordinary Income"
>title to "Gross Operating Income".

Posted by Laura on February 2, 2007, 7:38 am
Please log in for more thread options
It's the TYPE field that is forcing the additional net income calculations.
From the help file on Account type:

Income The main source of money coming into your company.
Other income Money received for something other than normal business
operations, such as interest income.
Expense Money that's leaving your company.
Other expense Money spent on something other than normal business
operations, such as corporate taxes.

Your non operating income and expenses need to have a TYPE of Other income
or Other Expense.
Not a sub-account of Other Income or Other expense with TYPE=Income or
Expense.

Also, "Ordinary Income" and "Ordinary Expenses" are just P&L line
descriptors. I would not make them accounts too or you will see a very
confusing P&L. So I suggest you undo that subaccount structure and correct
the TYPE field on the "other" accounts.

> Thanks, I'm almost there, I have changed all of the Income accounts to
> a sub account of "Ordinary Income" and all of the expense accounts to
> a sub account of either "Ordinary Expenses" or "Other Expenses". QB
> is now seperating them out, but it is not giving me a sub total profit
> or loss after totalling "Ordinary Expenses" Any thoughts.
>
>
> wrote:
>
>>>I need to be able to create a GOP (Gross Operating Profit) line on the
>>> P&L and then add expense items between the GOP line and Net Income
>>> line.
>>>
>>> Can this be done.
>>>
>>> Using Quickbooks Pro 2006.
>>>
>>> Thanks
>>
>>One way to accomplish this is to change the type for expenses & income
>>"below the line" to Other Expense & Other Income. QB will then format the
>>report as follows:
>>
>>Ordinary Income/Expense
>> Income
>> COGS
>>Gross Profit
>>Expenses
>>Net Ordinary Income
>>Other Income/Expense
>>Net Income
>>
>>This is probably the closest you are going to get with out upgrading to
>>the
>>Premier:accountant version to take advantage of the Financial Statemente
>>designer. Dump the report to excel and change the "net ordinary Income"
>>title to "Gross Operating Income".


Similar ThreadsPosted
Quickbooks Pro 2006 Invoice Reports - include addresses? June 15, 2007, 5:49 am
Modifying Column Headings April 23, 2008, 2:33 am
Re: Payroll reports June 28, 2006, 12:59 am
reports query February 5, 2007, 2:36 pm
Memorized reports March 28, 2007, 7:42 pm
transaction reports November 25, 2007, 12:20 pm
Reports Canadian Content November 30, 2006, 1:30 am
Memorized reports disappear May 30, 2007, 8:57 pm
Reports on payroll HOURS December 20, 2006, 10:36 am
Re: 2003 Pro, missing vendors in reports February 27, 2007, 1:51 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap