Help with Business Scenario

[Bim]

Hi All,

I am having trouble figuring out how to setup the following scenario in MS
Accounting Express 2008:

Clients are individuals who pay for a product or service that I provide.
My place of work is within another business and hence I need to pay rent to
the owner. The rent however is a percentage of my total revenue.

So at the end of each month I need to produce an invoice to my landlord that
details each client transaction and then he will will pay me by cheque.

How would I set this up in this product?

Thanks in advance.

 

[DL]

Dont you mean the Landlord gives you an Invoice & you give the Landlord a
cheque?
If you have entered your Sales invoices, then a simple monthly sales report
will itemise them.
Give that to the Landlord who can then invoice you for rent based on that
report.
His purchase invoice is then entered just like any other, & paid accordingly

 

[Bim]

Hi,

Thanks for the reply.

Thats the problem, I really do have to provide an invoice to the landlord
detailing my sales (which I want to keep as customers in the system for
reporting purposes). Then he will invoice me for the rent portion (percentage
of total sales) and will essentially give me a cheque of the sales minus the
rental.

The problem I have is that although I could setup a single customer
(landlord) and then itemise each product/service on that invoice - I would
not be able to do any proper reporting at customer level.

Thanks again,

Bim

 

[DL]

What you appear to be saying is that allthough you issue Customers an
Invoice, the payments for these are being made by the Landlord, is that
correct?
Are these Customers of your account customers, presumably they are?
And if these Customers pay you how are you transfering these sums to the
Landlord?
I assume you are UK located?

 

[canadianmsaccountinguser]

Hi Bim, Few q's for you how often are u payin ur rent? if at the end of each
month then all u have to do is go to company down at the bottom is company
list then click chart of accounts. double click revenue and you can print
that out then calulate ur % and give that to him with the check as a reciept.
or you can take the revenue mines the cost of goods and go with that as a
total whichever works better for you.

 

[Bim]

Hi DL,

That's correct. All Customers transactions effectively go through the
landlords till so he then needs to pay that to me minus the rent I owe him.

So although no client pays me direct I want to track each customer sale but
invoice the landlord for payment.

I am based in the UK.

Hoping there is an easy way to do this!