Home Page link  

Recording cost associated w/ deposits?

  
Groups | Search | About
User Password
Register Now! Lost Password?

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
Recording cost associated w/ deposits? dpb 01-19-2008
Posted by dpb on January 19, 2008, 2:23 pm
Please log in for more thread options
 How would be suitable way to record deductible costs from royalty
payments when they're deposited? Can't use a deduction at that point as
the 1099 is issued w/ gross so must reflect that for proper tax
reporting but doesn't seem any way to split a portion to the production
cost account...

--

Posted by Allan Martin on January 21, 2008, 9:58 am
Please log in for more thread options
> How would be suitable way to record deductible costs from royalty
> payments when they're deposited? Can't use a deduction at that point as
> the 1099 is issued w/ gross so must reflect that for proper tax
> reporting but doesn't seem any way to split a portion to the production
> cost account...

Do you think anyone actually knows what you are talking about?



>
> --

Posted by dpb on January 21, 2008, 10:32 am
Please log in for more thread options
Allan Martin wrote:
>
>> How would be suitable way to record deductible costs from royalty
>> payments when they're deposited? Can't use a deduction at that point
>> as the 1099 is issued w/ gross so must reflect that for proper tax
>> reporting but doesn't seem any way to split a portion to the
>> production cost account...
>
> Do you think anyone actually knows what you are talking about?

Well, I had hoped... :)

I'll try the steps and see where it leads...

Receive royalty payments (oil/gas production (report on Sch E))
Deposit _net_ proceeds in account as income
Year end receive 1099 which shows gross amount in excess of net (gross
amount less production expenses withheld by producer)

Question was, how to make an account that reflects the above transaction.
What I was trying to resolve is how to make the accounts reflect the
total gross receipts match the year-end 1099 and still have the bank
balance correct for the net amount actually deposited.

What I figured out since the post that _seems_ to work is to deposit the
total and enter the costs as a negative amount to the cost account in
the deposit register.

Is the situation any more clear now and would you see a "more better" way?

--




Posted by Laura on January 21, 2008, 5:09 pm
Please log in for more thread options
> Allan Martin wrote:
>>
>>> How would be suitable way to record deductible costs from royalty
>>> payments when they're deposited? Can't use a deduction at that point as
>>> the 1099 is issued w/ gross so must reflect that for proper tax
>>> reporting but doesn't seem any way to split a portion to the production
>>> cost account...
>>
>> Do you think anyone actually knows what you are talking about?
>
> Well, I had hoped... :)
>
> I'll try the steps and see where it leads...
>
> Receive royalty payments (oil/gas production (report on Sch E))
> Deposit _net_ proceeds in account as income
> Year end receive 1099 which shows gross amount in excess of net (gross
> amount less production expenses withheld by producer)
>
> Question was, how to make an account that reflects the above transaction.
> What I was trying to resolve is how to make the accounts reflect the total
> gross receipts match the year-end 1099 and still have the bank balance
> correct for the net amount actually deposited.
>
> What I figured out since the post that _seems_ to work is to deposit the
> total and enter the costs as a negative amount to the cost account in the
> deposit register.
>
> Is the situation any more clear now and would you see a "more better" way?

Create an expense account called Production Expenses and an Item that points
to this new account. Use a sales receipt for the gross amount to Royalty
Income (to match 1099 received) as the first line of the SR. On the second
line post a negative amount for the amount of Production expenses withheld
using the Production expense Item. You will end up with the net amount in
your bank, your income account will reflect the gross income received and
the Production expense will be in a separate account to offset your income.
Does this make sense to you?


Posted by dpb on January 21, 2008, 5:59 pm
Please log in for more thread options
Laura wrote:
>> Allan Martin wrote:
>>>
>>>> How would be suitable way to record deductible costs from royalty
>>>> payments when they're deposited? Can't use a deduction at that
>>>> point as the 1099 is issued w/ gross so must reflect that for proper
>>>> tax reporting but doesn't seem any way to split a portion to the
>>>> production cost account...
>>>
>>> Do you think anyone actually knows what you are talking about?
>>
>> Well, I had hoped... :)
>>
>> I'll try the steps and see where it leads...
>>
>> Receive royalty payments (oil/gas production (report on Sch E))
>> Deposit _net_ proceeds in account as income
>> Year end receive 1099 which shows gross amount in excess of net (gross
>> amount less production expenses withheld by producer)
>>
>> Question was, how to make an account that reflects the above transaction.
>> What I was trying to resolve is how to make the accounts reflect the
>> total gross receipts match the year-end 1099 and still have the bank
>> balance correct for the net amount actually deposited.
>>
>> What I figured out since the post that _seems_ to work is to deposit
>> the total and enter the costs as a negative amount to the cost account
>> in the deposit register.
>>
>> Is the situation any more clear now and would you see a "more better"
>> way?
>
> Create an expense account called Production Expenses and an Item that
> points to this new account. Use a sales receipt for the gross amount to
> Royalty Income (to match 1099 received) as the first line of the SR. On
> the second line post a negative amount for the amount of Production
> expenses withheld using the Production expense Item. You will end up
> with the net amount in your bank, your income account will reflect the
> gross income received and the Production expense will be in a separate
> account to offset your income. Does this make sense to you?

Hmmm, ok, but seems more effort to the same end than simply posting the
split on the banking register... :)

To do the cash sale would have to make the Royalty Income acct a
customer? That doesn't seem right somehow...

--

--

Similar ThreadsPosted
grouped deposits December 8, 2006, 3:06 pm
QBPro2007 importing deposits January 12, 2007, 7:55 pm
make deposits glitch? October 1, 2008, 6:53 pm
QBP2004 Check Reconciliation with Group Deposits May 18, 2007, 2:03 pm
Recording Sales September 9, 2007, 9:17 am
Recording Corporate Tax Installments November 18, 2006, 5:22 pm
Recording Corporate Tax Refund November 18, 2006, 5:23 pm
Re: Problem Recording Entries November 29, 2006, 4:12 pm
Recording business expenses paid from personal credit card August 23, 2007, 8:07 pm
Quickbooks still need to be activated at a cost January 20, 2008, 8:59 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