The Book-keepers Forum (BKF)

Post Info TOPIC: Further contra-question


Member

Status: Offline
Posts: 6
Date:
Further contra-question
Permalink Closed


Please help!!!   We let business units.  ONe of our tenants  uses our pdq machine for which we charge her a commission.  The money from the machine comes into our account and we pass a net amount onto her.  Can you help me with the appropriate journal entries for this on sage.  I have set up a supplier account for her and a cusomter account for the pdq company.  Is the following right?

1. Sale takes place:
Cr - Commissions (commission received)
Dr - PDQ 'customer' (total invoice)
Cr - PDQ supplier (net amount)
2. When gross amount paid in by PDQ company:
Dr - Bank - (full amount)
Cr - PDQ 'Customer' (full amount)
Dr - commissions (commissions) - journal
Cr - Bank (commissions) - journal
3. When she is paid:
Dr - PDQ 'supplier' - (net amount)
Cr - Bank - (net amount)

I think I am getting lost and am not sure about the journal entries in step 2 - should I cr the bank - I have to cr something to offset the journal entry of dr-in the commissions account.
confuse

__________________


Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

Does this work for you?

DRCR
PDQ £    10.00
Tenant £    10.00
Bank £    10.00
PDQ £    10.00
Tenant £    10.00
Bank £     9.00
Commission £     1.00
   
Result
Bank £     1.00
Commssion  £     1.00


I might set up the PDQ as a bank then use Receipts, and Transfer from the bank module, then journal the last

So stage 1) Receipts into PDQ from Tenant account
Stage 2) Transfer from PDQ to Bank
Stage 3) Clear the tenant account using a journal

Bill

__________________

 

 



Member

Status: Offline
Posts: 6
Date:
Permalink Closed

Very clear Journals - will give it a try. If tenant then wants to offset against rent how would I then build this next stage on. How would I allocate the partial amount she pays in - say £200 owed less the £9 we have to pass back to her.



__________________


Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

For simplicity I hav eused £10 request from tenant, £1 commission and £5 rent


AccountDRCR
StepPDQ £    10.00
1Tenant £    10.00
    
StepBank £    10.00
2PDQ £    10.00
    
StepTenant £    10.00
3Bank £      4.00 (Cash given to tenant)
Commission £      1.00
Rent £      5.00
    
Result Balance
Bank £      6.00
Tenant £      4.00 (Cash)
Commssion £      1.00
Rent £      5.00
PDQ £          -    £          -  

Hope that makes sense

Bill


-- Edited by Wella on Thursday 2nd of December 2010 01:15:40 PM

__________________

 

 



Member

Status: Offline
Posts: 6
Date:
Permalink Closed

Brilliant as journal entries - again see the logic - the trouble I'm having is how to 'sage' this.
At the moment I am receiving an 'invoice' from my tenant as a supplier for each pdq slip. I then issue an invoice to my 'pdq' customer. When the money comes in I mark as payment received from 'pdq' customer. What sage entries do I then post to make sure the money is then split 3 ways between commissions received, rent and tenant - given Sage will want to 'double entry' for me?

Many thanks for your ongoing help with this....really appreciate it.
RT

__________________


Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

I can understand how you are getting lost!!

When you raise or receive an invoice what nominal codes do they post the transactions to?

Bill



__________________

 

 

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About