Home Page link  

Chart of Accounts Problem

 

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
Chart of Accounts Problem PT 01-04-2007
Posted by PT on January 4, 2007, 8:11 pm
Please log in for more thread options
I probably set up the chart incorrectly, and can't figure out how to correct
it. Here's what I have:

Our non-profit organization has income from a variety of sources
(contributions, memberships, etc.. It also has sales from a gift shop.
Each of these categories has its own income account with account type
"Income". There's also a cost of sales account for the gift shop with
account type "cost of sales"

During the year, we post all gift shop sales to the "gift shop sales" income
account. We post inventory purchase to the Inventory balance sheet account.
At year end we post an adjusting journal entry of the form:

Cost of sales xxxxx
Inventory xxxxx.

I end up with the correct year end P & L and Balance Sheet figures. But the
P & L report layout is not in the normal form. Instead I end up with:

Income
Income1 xxxx
Income2 xxxx
etc...
Income 10 xxxx
Gift shop sales xxxx
Total Income xxxx

Cost of sales
Cost of sales xxxx
Total Cost of Sales xxxx

Gross profit xxxx (which is then the sum of all the income
account balances minus the COGS)

I'd normally expect the cost of sales to be "attached" only to the gift
shop sales, with the gift shop gross profit being the difference.

Should I have labeled all the other income accounts as "Other Income"? If
so, can the account types be changed after the fact?




--
PT



Posted by Laura on January 5, 2007, 7:08 am
Please log in for more thread options
>I probably set up the chart incorrectly, and can't figure out how to
>correct it. Here's what I have:
>
> Our non-profit organization has income from a variety of sources
> (contributions, memberships, etc.. It also has sales from a gift shop.
> Each of these categories has its own income account with account type
> "Income". There's also a cost of sales account for the gift shop with
> account type "cost of sales"
>
> During the year, we post all gift shop sales to the "gift shop sales"
> income account. We post inventory purchase to the Inventory balance sheet
> account. At year end we post an adjusting journal entry of the form:
>
> Cost of sales xxxxx
> Inventory xxxxx.
>
> I end up with the correct year end P & L and Balance Sheet figures. But
> the P & L report layout is not in the normal form. Instead I end up with:
>
> Income
> Income1 xxxx
> Income2 xxxx
> etc...
> Income 10 xxxx
> Gift shop sales xxxx
> Total Income xxxx
>
> Cost of sales
> Cost of sales xxxx
> Total Cost of Sales xxxx
>
> Gross profit xxxx (which is then the sum of all the income
> account balances minus the COGS)
>
> I'd normally expect the cost of sales to be "attached" only to the gift
> shop sales, with the gift shop gross profit being the difference.
>
> Should I have labeled all the other income accounts as "Other Income"? If
> so, can the account types be changed after the fact?

Yes, the Income accounts should be listed under Other Income to get the
desired P&L format you want. You can change their type to Other Income by
editing the account to change the type to Other Income.

If they are a subaccount you will will need to remove the subaccount
designation, save the change, re-edit the account to move it to Other
Income.


Posted by Bob on January 8, 2007, 12:02 am
Please log in for more thread options
You can also run "classes" in QB. Classes break out income and expense
to specific activities.

In your case, one class may be the Gift Shop. A second class may be a
major fundraiser. A third class may be donations. You can allocate cost
to each class to provide individual income statements that roll up to a
consolidated income statement.

Classes exist only for income and expense not for balance sheet itesm.

Laura wrote:
> >I probably set up the chart incorrectly, and can't figure out how to
> >correct it. Here's what I have:
> >
> > Our non-profit organization has income from a variety of sources
> > (contributions, memberships, etc.. It also has sales from a gift shop.
> > Each of these categories has its own income account with account type
> > "Income". There's also a cost of sales account for the gift shop with
> > account type "cost of sales"
> >
> > During the year, we post all gift shop sales to the "gift shop sales"
> > income account. We post inventory purchase to the Inventory balance sheet
> > account. At year end we post an adjusting journal entry of the form:
> >
> > Cost of sales xxxxx
> > Inventory xxxxx.
> >
> > I end up with the correct year end P & L and Balance Sheet figures. But
> > the P & L report layout is not in the normal form. Instead I end up with:
> >
> > Income
> > Income1 xxxx
> > Income2 xxxx
> > etc...
> > Income 10 xxxx
> > Gift shop sales xxxx
> > Total Income xxxx
> >
> > Cost of sales
> > Cost of sales xxxx
> > Total Cost of Sales xxxx
> >
> > Gross profit xxxx (which is then the sum of all the income
> > account balances minus the COGS)
> >
> > I'd normally expect the cost of sales to be "attached" only to the gift
> > shop sales, with the gift shop gross profit being the difference.
> >
> > Should I have labeled all the other income accounts as "Other Income"? If
> > so, can the account types be changed after the fact?
>
> Yes, the Income accounts should be listed under Other Income to get the
> desired P&L format you want. You can change their type to Other Income by
> editing the account to change the type to Other Income.
>
> If they are a subaccount you will will need to remove the subaccount
> designation, save the change, re-edit the account to move it to Other
> Income.


Similar ThreadsPosted
Chart of Accounts? September 12, 2007, 7:28 pm
Chart of Accounts January 22, 2007, 8:23 pm
Chart of Accounts Laundromat March 12, 2007, 8:15 am
Import Chart of Accounts? January 4, 2008, 1:01 am
Chart of Accounts Query... January 28, 2008, 4:04 pm
Chart of Accounts - Account Number Arbitrary? April 17, 2008, 12:45 pm
Accounts August 25, 2008, 5:58 am
What accounts are affected? May 10, 2007, 3:16 pm
Equity Accounts May 17, 2007, 10:43 pm
Reconciling accounts (or not) July 12, 2008, 11:56 am

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