sql-ledger-users — SQL-Ledger users

Re: [SL] Display VAT number

[Kevin B. <kb...@fr...>]

Thanks for that.

I then went to letterhead.tex and edited that one.

Not easy but a quick review of some Latex notes sites meant I was able 
to add the VAT line underneath the fax number and make the logo the same 
as mine as well.

Kevin

Nefnifi, Kasem wrote:

> 
>
>Templates>...>invoice.tex
>
>
>-----Original Message-----
>From: Kevin Bailey [mailto:kb...@fr...] 
>Sent: vrijdag 16 februari 2007 14:50
>To: sql...@li...
>Subject: [SL] Display VAT number
>
>Hi,
>
>How do I get the VAT number to display on the invoices which are created
>as PDF's?
>
>Thanks,
>
>Kevin Bailey
>
>------------------------------------------------------------------------
>-
>Take Surveys. Earn Cash. Influence the Future of IT Join
>SourceForge.net's Techsay panel and you'll get the chance to share your
>opinions on IT & business topics through brief surveys-and earn cash
>http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDE
>V
>_______________________________________________
>sql-ledger-users mailing list
>sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>-------------------------------------------------------------------------
>Take Surveys. Earn Cash. Influence the Future of IT
>Join SourceForge.net's Techsay panel and you'll get the chance to share your
>opinions on IT & business topics through brief surveys-and earn cash
>http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>_______________________________________________
>sql-ledger-users mailing list
>sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>  
>

Re: [SL] Handling prepayments

[Michael H. <mh...@it...>]

Ah, of course, silly me, makes perfect sense now - thanks!

Michael


On Feb 14, 2007, at 8:41 PM, Dr Eberhard Lisse wrote:

> Neil,
>
> this is not clear, at all, it's actually quite confusing.
>
> What I do is:
>
> Receipt of Funds, Cash, Check, EFT or whatever:
> GL entry:
> 	Debit Bank Account
> 	Credit Pre-Payment Account
>
> Provision of Service
> Sales Invoice:
> 	Generate, Email and Post Invoice. SQL-Ledger does its thing
> 	(debits Account Receiveable)
>
> "Pay" Invoice:
> Cash->Receipt
> 	Payment (pull-down): Pre-Payment Account (not Bank Account)
> 	SQL-Leder does its thing (credits AR, debits Pre-Payment
> 	Account, ie moves funds from Pre-Pay to AR, so the
> 	transaction does not involve the bank account)
>
>
> Michael,
>
> Remember, *double* *entry* accounting?
>
> One half (entry) of a transaction shows where the money is. In the  
> bank
> account, where it remains.
>
> The other half shows what it is for, liability.
>
> Later you only change the latter, ie the Cash->Receipt allocates it  
> from
> the Pre-Pay to the AP (invoice). Again, this is a double entry but  
> does
> not involve the bank account.
>
> greetings, el
>
> on 2/15/07 3:59 AM Neil Johnson said the following:
>> Accounting entries for prepaid revenue:
>>
>> 1.   Invoice to Customer
>> Debit customer (balance sheet)
>> Credit prepaid revenue account (balance sheet)
>>
>> 2.   Receipt of Cash
>> Debit cash
>> Credit customer
>>
>> 3.   Revenue Recognition
>> Debit prepaid revenue (balance sheet)
>> Credit  revenue (P&L)
>>
>> You do 3. each time the revenue is to be recognised (i.e monthly,
>> quarterly whatever).
>>
>> If revenue recognition depends on cash receipt then don't do 3.  
>> unless
>> the customer has paid.
>>
>> Hope this is clear....
>>
>>
>>
>> Michael Hasse wrote:
>>> All the responses make sense and are greatly appreciated!  (And I
>>> actually have taken some accounting classes, but they were years
>>> ago.  :)
>>>     What I am trying to figure out is how the bank account  
>>> balance in
>>> the GL can reflect the funds that are posted to the liability  
>>> account
>>> (s)...?  E.g. somebody purchases a prepaid block of time for $10k,
>>> that money certainly hits the bank account in the real world but if
>>> it's posted to the liability account in SL, won't our bank  
>>> balance in
>>> SL fail to show it?
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] DCAA / FAR compliance?

[William E. S. <ws...@or...>]

Does anyone on the list know if SQL-Ledger is DCAA and FAR compliant for 
government contractors?

Thanks!

-- 
William E. Sadler, Chief Scientist  | mail://ws...@os...
Organizational Strategies, Inc.     | http://www.osi-atl.com
2231 Crystal Drive, Suite 1116      | (770) 254-0414 office
Arlington, VA  22202                | (404) 202-6513 cell

Re: [SL] Display VAT number

[Nefnifi, K. <Kas...@at...>]

=20

Templates>...>invoice.tex


-----Original Message-----
From: Kevin Bailey [mailto:kb...@fr...]=20
Sent: vrijdag 16 februari 2007 14:50
To: sql...@li...
Subject: [SL] Display VAT number

Hi,

How do I get the VAT number to display on the invoices which are created
as PDF's?

Thanks,

Kevin Bailey

------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT Join
SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Display VAT number

[Kevin B. <kb...@fr...>]

Hi,

How do I get the VAT number to display on the invoices which are created 
as PDF's?

Thanks,

Kevin Bailey

Re: [SL] Handling prepayments

[David J <ja...@in...>]

In Australia, our tax laws recognise 2 quite different
"pre-payments".
1.  An advance (or progress) payment to be applied against
future supplies of goods or services.  Such payments include
GST.  Normal attribution rules apply.
2.  Deposits received to secure the future delivery of goods
or services might also be applied towards payment for such
supplies. eg Rental Bonds that get forfeited.  Security
deposits do NOT include GST until forfeited.
See Tax Ruling GSTR2006/2 for much more clarity.
Warning.  Other countries laws will be different.
Conclusion.  There is no single correct way to handle
prepayments/deposits in SQL-L.  Discuss with your accountant
the right transaction/s for your circumstances.
HTH
David J


> Accounting entries for prepaid revenue:
> 
> 1.   Invoice to Customer
> Debit customer (balance sheet)
> Credit prepaid revenue account (balance sheet)
> 
> 2.   Receipt of Cash
> Debit cash
> Credit customer
> 
> 3.   Revenue Recognition
> Debit prepaid revenue (balance sheet)
> Credit  revenue (P&L)
> 
> You do 3. each time the revenue is to be recognised (i.e
> monthly,  quarterly whatever).
> 
> If revenue recognition depends on cash receipt then don't
> do 3. unless  the customer has paid.
> 
> Hope this is clear....
> 
> 
> 
> Michael Hasse wrote:
> > All the responses make sense and are greatly
> > appreciated!  (And I   actually have taken some
> > accounting classes, but they were years   ago.  :)
> >     What I am trying to figure out is how the bank
> > account balance in   the GL can reflect the funds that
> > are posted to the liability account  (s)...?  E.g.
> > somebody purchases a prepaid block of time for $10k,  
> that money certainly hits the bank account in the real
> > world but if   it's posted to the liability account in
> > SL, won't our bank balance in   SL fail to show it?
> >
> >
> > Thanks!
> >
> > Michael
> >
> >
> > On Feb 14, 2007, at 3:02 AM, Roy Nicholl wrote:
> >
> >   
> >> Sorry about the confusion Eberhard,   I was merely
> referring to the >> mechanics of recording prepayments and
> the similarity to recording >> collected tax - and action
> which Michael may already be familiar ... >> I did not
> imply, not intend to imply, that you were paying tax on
> the >> prepayment ... just that the patter was similar.
> >>
> >>
> >> On 14-Feb-2007, at 00:20, Dr Eberhard Lisse wrote:
> >>
> >>     
> >>> Michael,
> >>>
> >>> The money is in the bank. What we are discussing here,
> is how you >>> *account* for it.
> >>>
> >>> It first is a liability, but still in the bank
> account. Once you >>> "earn"
> >>> it by "paying" an invoice, it still is in the bank
> account, but it >>> becomes revenue.
> >>>
> >>> I would perhaps look at some reading material about
> accounting... >>>
> >>> Roy,
> >>>
> >>> I do not understand your contribution. We are not
> discussing expenses >>> here, but revenue. And, you can
> not pay tax on pre-payment, because >>> you
> >>> haven't provided a service, sold anything, i.e. you
> did not >>> generate an
> >>> invoice. But then maybe I should read more ont he
> subject :-)-O >>>
> >>> greetings, el
> >>>
> >>> on 2/14/07 3:27 AM Roy Nicholl said the following:
> >>>       
> >>>> Prepaid expenses are treated pretty much the same as
> the sales tax/ >>>> VAT you collect on behalf of the
> government.   The money is paid   >>>> into
> >>>> your operating account, but you also credit the Tax
> account (a >>>> liability) because the money does not
> belong to you.  When you remit >>>> the tax to the
> government, you pay it out of the tax account. >>>>
> >>>>
> >>>> On 13-Feb-2007, at 20:32, Michael Hasse wrote:
> >>>>
> >>>>         
> >>>>> Mkay, that makes sense, but if there's a GL debiting
> the bank >>>>> account, how does the bank account get
> credited again?  (Maybe I >>>>> should just try it and see
> what happens!  Nothing like the hands-on >>>>> approach,
> eh?  :) >>>>>           
> >>>
> ----------------------------------------------------------
> -----------  >>> -
> >>> ---
> >>> Take Surveys. Earn Cash. Influence the Future of IT
> >>> Join SourceForge.net's Techsay panel and you'll get
> the chance to >>> share your
> >>> opinions on IT & business topics through brief
> surveys-and earn cash >>>
> http://www.techsay.com/default.php? >>>
> page=join.php&p=sourceforge&CID=DEVDEV >>>
> _______________________________________________ >>>
> sql-ledger-users mailing list >>>
> sql...@li... >>>
>
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>>       
> >>
> ----------------------------------------------------------
> ------------  >> ---
> >> Take Surveys. Earn Cash. Influence the Future of IT
> >> Join SourceForge.net's Techsay panel and you'll get the
> chance to   >> share your
> >> opinions on IT & business topics through brief
> surveys-and earn cash >>
> http://www.techsay.com/default.php?  >>
> page=join.php&p=sourceforge&CID=DEVDEV >>
> _______________________________________________ >>
> sql-ledger-users mailing list >>
> sql...@li... >>
>
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>     
> >
> >
> >
> ----------------------------------------------------------
> > --------------- Take Surveys. Earn Cash. Influence the
> > Future of IT Join SourceForge.net's Techsay panel and
> > you'll get the chance to share your opinions on IT &
> > business topics through brief surveys-and earn cash
>
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> >
>
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >   
> ----------------------------------------------------------
> --------------- Take Surveys. Earn Cash. Influence the
> Future of IT Join SourceForge.net's Techsay panel and
> you'll get the chance to share your opinions on IT &
> business topics through brief surveys-and earn cash
>
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
>
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Handling prepayments

[Dr E. L. <el...@li...>]

Peter,

we have to pay VAT here at invoicing too.

But you should ask your tax adviser about the pre-payment tax. I
sincerely doubt that you have to pay VAT for services not rendered (yet).

el

on 2/14/07 11:35 AM Peeter Pärtel said the following:
> To Eberhard,
>
> at least in Estonia we have to pay VAT when Invoice is given out or
> money becomes to our account as prepayment whichever is first. So the
> tax must be paid even if we haven't earned the money yet. At least
> that's the way I have understood it :-/
>
> All the Best and Happy Valetines Day,
>
> Peeter Pärtel
> Estonia
>
>

Re: [SL] Handling prepayments

[Dr E. L. <el...@li...>]

Neil,

this is not clear, at all, it's actually quite confusing.

What I do is:

Receipt of Funds, Cash, Check, EFT or whatever:
GL entry:
	Debit Bank Account
	Credit Pre-Payment Account

Provision of Service
Sales Invoice:
	Generate, Email and Post Invoice. SQL-Ledger does its thing
	(debits Account Receiveable)

"Pay" Invoice:
Cash->Receipt
	Payment (pull-down): Pre-Payment Account (not Bank Account)
	SQL-Leder does its thing (credits AR, debits Pre-Payment
	Account, ie moves funds from Pre-Pay to AR, so the
	transaction does not involve the bank account)


Michael,

Remember, *double* *entry* accounting?

One half (entry) of a transaction shows where the money is. In the bank
account, where it remains.

The other half shows what it is for, liability.

Later you only change the latter, ie the Cash->Receipt allocates it from
the Pre-Pay to the AP (invoice). Again, this is a double entry but does
not involve the bank account.

greetings, el

on 2/15/07 3:59 AM Neil Johnson said the following:
> Accounting entries for prepaid revenue:
>
> 1.   Invoice to Customer
> Debit customer (balance sheet)
> Credit prepaid revenue account (balance sheet)
>
> 2.   Receipt of Cash
> Debit cash
> Credit customer
>
> 3.   Revenue Recognition
> Debit prepaid revenue (balance sheet)
> Credit  revenue (P&L)
>
> You do 3. each time the revenue is to be recognised (i.e monthly,
> quarterly whatever).
>
> If revenue recognition depends on cash receipt then don't do 3. unless
> the customer has paid.
>
> Hope this is clear....
>
>
>
> Michael Hasse wrote:
>> All the responses make sense and are greatly appreciated!  (And I
>> actually have taken some accounting classes, but they were years
>> ago.  :)
>>     What I am trying to figure out is how the bank account balance in
>> the GL can reflect the funds that are posted to the liability account
>> (s)...?  E.g. somebody purchases a prepaid block of time for $10k,
>> that money certainly hits the bank account in the real world but if
>> it's posted to the liability account in SL, won't our bank balance in
>> SL fail to show it?

Re: [SL] Handling prepayments

[Neil J. <nei...@ma...>]

Accounting entries for prepaid revenue:

1.   Invoice to Customer
Debit customer (balance sheet)
Credit prepaid revenue account (balance sheet)

2.   Receipt of Cash
Debit cash
Credit customer

3.   Revenue Recognition
Debit prepaid revenue (balance sheet)
Credit  revenue (P&L)

You do 3. each time the revenue is to be recognised (i.e monthly, 
quarterly whatever).

If revenue recognition depends on cash receipt then don't do 3. unless 
the customer has paid.

Hope this is clear....



Michael Hasse wrote:
> All the responses make sense and are greatly appreciated!  (And I  
> actually have taken some accounting classes, but they were years  
> ago.  :)
>     What I am trying to figure out is how the bank account balance in  
> the GL can reflect the funds that are posted to the liability account 
> (s)...?  E.g. somebody purchases a prepaid block of time for $10k,  
> that money certainly hits the bank account in the real world but if  
> it's posted to the liability account in SL, won't our bank balance in  
> SL fail to show it?
>
>
> Thanks!
>
> Michael
>
>
> On Feb 14, 2007, at 3:02 AM, Roy Nicholl wrote:
>
>   
>> Sorry about the confusion Eberhard,   I was merely referring to the
>> mechanics of recording prepayments and the similarity to recording
>> collected tax - and action which Michael may already be familiar ...
>> I did not imply, not intend to imply, that you were paying tax on the
>> prepayment ... just that the patter was similar.
>>
>>
>> On 14-Feb-2007, at 00:20, Dr Eberhard Lisse wrote:
>>
>>     
>>> Michael,
>>>
>>> The money is in the bank. What we are discussing here, is how you
>>> *account* for it.
>>>
>>> It first is a liability, but still in the bank account. Once you
>>> "earn"
>>> it by "paying" an invoice, it still is in the bank account, but it
>>> becomes revenue.
>>>
>>> I would perhaps look at some reading material about accounting...
>>>
>>> Roy,
>>>
>>> I do not understand your contribution. We are not discussing expenses
>>> here, but revenue. And, you can not pay tax on pre-payment, because
>>> you
>>> haven't provided a service, sold anything, i.e. you did not
>>> generate an
>>> invoice. But then maybe I should read more ont he subject :-)-O
>>>
>>> greetings, el
>>>
>>> on 2/14/07 3:27 AM Roy Nicholl said the following:
>>>       
>>>> Prepaid expenses are treated pretty much the same as the sales tax/
>>>> VAT you collect on behalf of the government.   The money is paid  
>>>> into
>>>> your operating account, but you also credit the Tax account (a
>>>> liability) because the money does not belong to you.  When you remit
>>>> the tax to the government, you pay it out of the tax account.
>>>>
>>>>
>>>> On 13-Feb-2007, at 20:32, Michael Hasse wrote:
>>>>
>>>>         
>>>>> Mkay, that makes sense, but if there's a GL debiting the bank
>>>>> account, how does the bank account get credited again?  (Maybe I
>>>>> should just try it and see what happens!  Nothing like the hands-on
>>>>> approach, eh?  :)
>>>>>           
>>> --------------------------------------------------------------------- 
>>> -
>>> ---
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to
>>> share your
>>> opinions on IT & business topics through brief surveys-and earn cash
>>> http://www.techsay.com/default.php?
>>> page=join.php&p=sourceforge&CID=DEVDEV
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>       
>> ---------------------------------------------------------------------- 
>> ---
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to  
>> share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php? 
>> page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>     
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>   

Re: [SL] Handling prepayments

[Michael H. <mh...@it...>]

All the responses make sense and are greatly appreciated!  (And I  
actually have taken some accounting classes, but they were years  
ago.  :)
    What I am trying to figure out is how the bank account balance in  
the GL can reflect the funds that are posted to the liability account 
(s)...?  E.g. somebody purchases a prepaid block of time for $10k,  
that money certainly hits the bank account in the real world but if  
it's posted to the liability account in SL, won't our bank balance in  
SL fail to show it?


Thanks!

Michael


On Feb 14, 2007, at 3:02 AM, Roy Nicholl wrote:

> Sorry about the confusion Eberhard,   I was merely referring to the
> mechanics of recording prepayments and the similarity to recording
> collected tax - and action which Michael may already be familiar ...
> I did not imply, not intend to imply, that you were paying tax on the
> prepayment ... just that the patter was similar.
>
>
> On 14-Feb-2007, at 00:20, Dr Eberhard Lisse wrote:
>
>> Michael,
>>
>> The money is in the bank. What we are discussing here, is how you
>> *account* for it.
>>
>> It first is a liability, but still in the bank account. Once you
>> "earn"
>> it by "paying" an invoice, it still is in the bank account, but it
>> becomes revenue.
>>
>> I would perhaps look at some reading material about accounting...
>>
>> Roy,
>>
>> I do not understand your contribution. We are not discussing expenses
>> here, but revenue. And, you can not pay tax on pre-payment, because
>> you
>> haven't provided a service, sold anything, i.e. you did not
>> generate an
>> invoice. But then maybe I should read more ont he subject :-)-O
>>
>> greetings, el
>>
>> on 2/14/07 3:27 AM Roy Nicholl said the following:
>>> Prepaid expenses are treated pretty much the same as the sales tax/
>>> VAT you collect on behalf of the government.   The money is paid  
>>> into
>>> your operating account, but you also credit the Tax account (a
>>> liability) because the money does not belong to you.  When you remit
>>> the tax to the government, you pay it out of the tax account.
>>>
>>>
>>> On 13-Feb-2007, at 20:32, Michael Hasse wrote:
>>>
>>>> Mkay, that makes sense, but if there's a GL debiting the bank
>>>> account, how does the bank account get credited again?  (Maybe I
>>>> should just try it and see what happens!  Nothing like the hands-on
>>>> approach, eh?  :)
>>
>> --------------------------------------------------------------------- 
>> -
>> ---
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to
>> share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?
>> page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] OSS-ERP Acceptance Study

[<sal...@ho...>]

Dear OSS-ERP user,

We are Salvador Bueno and Dolores Gallego, Assistant Professors in Business 
Administration Department in Pablo de Olavide University at Seville, Spain.  
Our research involves an analysis about Open Source Software-Enterprise 
Resource Planning (OSS-ERP) and its impact at organization. We send you this 
mail to invite your participation in our study.

Specifically, our analysis consists on development a Technological 
Acceptance Model of an OSS-ERP.  We consider you are an OSS-ERP user and we 
appreciate the time necessary for answer our questionnaire. The name of the 
participants in this study will remain anonymous.

I would be most grateful if you participate in this survey. You only have to 
answer the questionnaire in the following URL and answer online. You will 
consider for answer the distribution of OSS-ERP you use.

http://aramis.upo.es/general/centros_depart/departamentos/invest/oss/

Please do not hesitate to contact us if you have any queries regarding this 
study.

Best regards,

Salvador Bueno, Ph D.

_________________________________________________________________
¿Estás pensando en cambiar de coche? Todas los modelos de serie y extras en 
MSN Motor. http://motor.msn.es/researchcentre/

Re: [SL] Handling prepayments

[Roy N. <RNi...@NB...>]

Sorry about the confusion Eberhard,   I was merely referring to the  
mechanics of recording prepayments and the similarity to recording  
collected tax - and action which Michael may already be familiar ...  
I did not imply, not intend to imply, that you were paying tax on the  
prepayment ... just that the patter was similar.


On 14-Feb-2007, at 00:20, Dr Eberhard Lisse wrote:

> Michael,
>
> The money is in the bank. What we are discussing here, is how you
> *account* for it.
>
> It first is a liability, but still in the bank account. Once you  
> "earn"
> it by "paying" an invoice, it still is in the bank account, but it
> becomes revenue.
>
> I would perhaps look at some reading material about accounting...
>
> Roy,
>
> I do not understand your contribution. We are not discussing expenses
> here, but revenue. And, you can not pay tax on pre-payment, because  
> you
> haven't provided a service, sold anything, i.e. you did not  
> generate an
> invoice. But then maybe I should read more ont he subject :-)-O
>
> greetings, el
>
> on 2/14/07 3:27 AM Roy Nicholl said the following:
>> Prepaid expenses are treated pretty much the same as the sales tax/
>> VAT you collect on behalf of the government.   The money is paid into
>> your operating account, but you also credit the Tax account (a
>> liability) because the money does not belong to you.  When you remit
>> the tax to the government, you pay it out of the tax account.
>>
>>
>> On 13-Feb-2007, at 20:32, Michael Hasse wrote:
>>
>>> Mkay, that makes sense, but if there's a GL debiting the bank
>>> account, how does the bank account get credited again?  (Maybe I
>>> should just try it and see what happens!  Nothing like the hands-on
>>> approach, eh?  :)
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Handling prepayments

[<pe...@si...>]

To Eberhard,

at least in Estonia we have to pay VAT when Invoice is given out or 
money becomes to our account as prepayment whichever is first. So the 
tax must be paid even if we haven't earned the money yet. At least 
that's the way I have understood it :-/

All the Best and Happy Valetines Day,

Peeter Pärtel
Estonia

Dr Eberhard Lisse wrote:
> Michael,
>
> The money is in the bank. What we are discussing here, is how you
> *account* for it.
>
> It first is a liability, but still in the bank account. Once you "earn"
> it by "paying" an invoice, it still is in the bank account, but it
> becomes revenue.
>
> I would perhaps look at some reading material about accounting...
>
> Roy,
>
> I do not understand your contribution. We are not discussing expenses
> here, but revenue. And, you can not pay tax on pre-payment, because you
> haven't provided a service, sold anything, i.e. you did not generate an
> invoice. But then maybe I should read more ont he subject :-)-O
>
> greetings, el
>
> on 2/14/07 3:27 AM Roy Nicholl said the following:
>   
>> Prepaid expenses are treated pretty much the same as the sales tax/ 
>> VAT you collect on behalf of the government.   The money is paid into  
>> your operating account, but you also credit the Tax account (a  
>> liability) because the money does not belong to you.  When you remit  
>> the tax to the government, you pay it out of the tax account.
>>
>>
>> On 13-Feb-2007, at 20:32, Michael Hasse wrote:
>>
>>     
>>> Mkay, that makes sense, but if there's a GL debiting the bank
>>> account, how does the bank account get credited again?  (Maybe I
>>> should just try it and see what happens!  Nothing like the hands-on
>>> approach, eh?  :)
>>>       
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>   

Re: [SL] Year End & Inventory Questions

[Paul T. <pt...@wa...>]

Roy Nicholl schreef:
> Oops ... I did leave that step out of my narration ... but I did  
> indeed do that ...
>
> My dilemma still remains why my 'mock up' from Sunday appears to have  
> worked, yet my "real" setup for the running club still shows  
> inventory on the balance sheet (but does not when I look at the Good  
> & Services / All Items report.
>
> I have three years worth of data in the system and am not so keen on  
> keying it all in again ... is there any way to 'fix' the inventory  
> issue without screwing-up the integrity of the database (any further  
> than it already is).
>
>
> Roy
>
> On 13-Feb-2007, at 11:57, R Pennington wrote:
>   
Just a wild guess, but is the amount in the balance sheet anything like 
the opening stock of year one you started using SQL-Ledger?
In that case, you probably did not enter the COGS for the opening stock, 
effectively creating a non existing profit.
And the amount there should be re-classed to COGS. Year one, but I 
assume you may have closed previous years.
The correction then should be made at the earliest moment in time 
possible, COGS debit, Stock Credit.
Or just invoice out for zero as a stock correction; if the good were 
stolen or burned you would do that also..

Hth
Paul

Re: [SL] Handling prepayments

[Dr E. L. <el...@li...>]

Michael,

The money is in the bank. What we are discussing here, is how you
*account* for it.

It first is a liability, but still in the bank account. Once you "earn"
it by "paying" an invoice, it still is in the bank account, but it
becomes revenue.

I would perhaps look at some reading material about accounting...

Roy,

I do not understand your contribution. We are not discussing expenses
here, but revenue. And, you can not pay tax on pre-payment, because you
haven't provided a service, sold anything, i.e. you did not generate an
invoice. But then maybe I should read more ont he subject :-)-O

greetings, el

on 2/14/07 3:27 AM Roy Nicholl said the following:
> Prepaid expenses are treated pretty much the same as the sales tax/ 
> VAT you collect on behalf of the government.   The money is paid into  
> your operating account, but you also credit the Tax account (a  
> liability) because the money does not belong to you.  When you remit  
> the tax to the government, you pay it out of the tax account.
> 
> 
> On 13-Feb-2007, at 20:32, Michael Hasse wrote:
> 
>> Mkay, that makes sense, but if there's a GL debiting the bank
>> account, how does the bank account get credited again?  (Maybe I
>> should just try it and see what happens!  Nothing like the hands-on
>> approach, eh?  :)

Re: [SL] Handling prepayments

[Roy N. <RNi...@NB...>]

Prepaid expenses are treated pretty much the same as the sales tax/ 
VAT you collect on behalf of the government.   The money is paid into  
your operating account, but you also credit the Tax account (a  
liability) because the money does not belong to you.  When you remit  
the tax to the government, you pay it out of the tax account.


On 13-Feb-2007, at 20:32, Michael Hasse wrote:

> Mkay, that makes sense, but if there's a GL debiting the bank
> account, how does the bank account get credited again?  (Maybe I
> should just try it and see what happens!  Nothing like the hands-on
> approach, eh?  :)
>
>
> On Feb 13, 2007, at 10:35 AM, Dr Eberhard Lisse wrote:
>
>> They (pre-)pay into our bank account, and I make a GL entry
>> debiting the
>> bank account, crediting the Pre-Payment account. Then I do a
>> Cash->Receipt for the client and apply the payment selecting not the
>> bank account but the Pre-Payment account from the Payment pull-down
>> menu.
>>
>> That's it.
>>
>> The actual money has always been in the bank account, but until you
>> "pay" an invoice from Pre-Pay that money doesn't really belong to you
>> yet, ergo it is not Revenue but Liability.
>>
>> And since we have about 15 Pre-Payers it's not really a major  
>> issue. I
>> have one for payments that I don't know which invoices they are for,
>> usually when I suspend services for delinquency this sorts itself
>> out :-)-O.
>>
>> greetings, el
>>
>> on 2/13/07 8:21 AM Michael Hasse said the following:
>>> Good point on the taxes!
>>>     So to confirm I'm understanding, you've got a separate Liability
>>> account for each prepaying client?  And then as the funds are  
>>> applied
>>> to invoices those amounts get moved over to the actual bank accounts
>>> on asset side of the balance sheet?  Are there two payment line  
>>> items
>>> entered on each invoice then, one each for liability and asset?
>>>
>>>
>>> Thanks!
>>>
>>> Michael
>>
>> --------------------------------------------------------------------- 
>> -
>> ---
>> Using Tomcat but need to do more? Need to support web services,
>> security?
>> Get stuff done quickly with pre-integrated technology to make your
>> job easier.
>> Download IBM WebSphere Application Server v.1.0.1 based on Apache
>> Geronimo
>> http://sel.as-us.falkag.net/sel?
>> cmd=lnk&kid=120709&bid=263057&dat=121642
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ---------------------------------------------------------------------- 
> ---
> Using Tomcat but need to do more? Need to support web services,  
> security?
> Get stuff done quickly with pre-integrated technology to make your  
> job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Handling prepayments

[Michael H. <mh...@it...>]

Mkay, that makes sense, but if there's a GL debiting the bank  
account, how does the bank account get credited again?  (Maybe I  
should just try it and see what happens!  Nothing like the hands-on  
approach, eh?  :)


On Feb 13, 2007, at 10:35 AM, Dr Eberhard Lisse wrote:

> They (pre-)pay into our bank account, and I make a GL entry  
> debiting the
> bank account, crediting the Pre-Payment account. Then I do a
> Cash->Receipt for the client and apply the payment selecting not the
> bank account but the Pre-Payment account from the Payment pull-down  
> menu.
>
> That's it.
>
> The actual money has always been in the bank account, but until you
> "pay" an invoice from Pre-Pay that money doesn't really belong to you
> yet, ergo it is not Revenue but Liability.
>
> And since we have about 15 Pre-Payers it's not really a major issue. I
> have one for payments that I don't know which invoices they are for,
> usually when I suspend services for delinquency this sorts itself  
> out :-)-O.
>
> greetings, el
>
> on 2/13/07 8:21 AM Michael Hasse said the following:
>> Good point on the taxes!
>>     So to confirm I'm understanding, you've got a separate Liability
>> account for each prepaying client?  And then as the funds are applied
>> to invoices those amounts get moved over to the actual bank accounts
>> on asset side of the balance sheet?  Are there two payment line items
>> entered on each invoice then, one each for liability and asset?
>>
>>
>> Thanks!
>>
>> Michael
>
> ---------------------------------------------------------------------- 
> ---
> Using Tomcat but need to do more? Need to support web services,  
> security?
> Get stuff done quickly with pre-integrated technology to make your  
> job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Handling prepayments

[Dr E. L. <el...@li...>]

They (pre-)pay into our bank account, and I make a GL entry debiting the
bank account, crediting the Pre-Payment account. Then I do a
Cash->Receipt for the client and apply the payment selecting not the
bank account but the Pre-Payment account from the Payment pull-down menu.

That's it.

The actual money has always been in the bank account, but until you
"pay" an invoice from Pre-Pay that money doesn't really belong to you
yet, ergo it is not Revenue but Liability.

And since we have about 15 Pre-Payers it's not really a major issue. I
have one for payments that I don't know which invoices they are for,
usually when I suspend services for delinquency this sorts itself out :-)-O.

greetings, el

on 2/13/07 8:21 AM Michael Hasse said the following:
> Good point on the taxes!
>     So to confirm I'm understanding, you've got a separate Liability
> account for each prepaying client?  And then as the funds are applied
> to invoices those amounts get moved over to the actual bank accounts
> on asset side of the balance sheet?  Are there two payment line items
> entered on each invoice then, one each for liability and asset?
>
>
> Thanks!
>
> Michael

Re: [SL] Year End & Inventory Questions

[Roy N. <RNi...@NB...>]

Oops ... I did leave that step out of my narration ... but I did  
indeed do that ...

My dilemma still remains why my 'mock up' from Sunday appears to have  
worked, yet my "real" setup for the running club still shows  
inventory on the balance sheet (but does not when I look at the Good  
& Services / All Items report.

I have three years worth of data in the system and am not so keen on  
keying it all in again ... is there any way to 'fix' the inventory  
issue without screwing-up the integrity of the database (any further  
than it already is).


Roy

On 13-Feb-2007, at 11:57, R Pennington wrote:

>
> I don't notice anything that mentions you actually used the "Stock  
> Assembly" function...?
>
> The vendor invoices put the parts into stock, but you have to use  
> the "stock assembly" function to combine those parts (shirt and  
> embroidery)
> into the assembled unit (embroidered shirt).
> You then sell the assembled unit on your customer invoices.
>
> Cheers
> The other Roy
>
> ---------------------------------------------------------------------- 
> ---
> Using Tomcat but need to do more? Need to support web services,  
> security?
> Get stuff done quickly with pre-integrated technology to make your  
> job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Year End & Inventory Questions

[R P. <arc...@mt...>]

On Sunday 11 February 2007 5:24 pm, Roy Nicholl wrote:
> Followup on my previous post.
> 
> This afternoon, I setup a new installation of SQL-Ledger with a new  
> database.
> 
> I created two vendors and three customers.
> 
> I added a part and a service:
> 
> 1) Part: Long Sleeve Technical 'T'  ... cost $25.00
> 2) Service: Screening of club logo ... cost $2.00
> 
> I then created an assembly comprised of the part and the service:
> 
> 3) Club Crested long-sleeve technical 'T' ... sale price $35.00
> 
> I created a purchase order to vendor 1 for 20 units of 'part' (long  
> sleeved technical 'T').
> I then went into shipping and receiving and received the order (20  
> units)
> I then generated the corresponding vendor invoice.
> 
> Next I entered a vendor invoice from Vendor 2 for  
> 'service' (screening of club logo) for 20 units
> 
> I then checked "All Items" under Good & Services/Reports and I had 20  
> units of 'assembly' (Club Crested long-sleeve Technical T'
> 
> Now that I had an inventory it was time to sell.
> 
> Customer 1:
>    I created a sales order for 2 shirts
>    I then went under Shipping and 'ship'ed the order
>    finally I generated the corresponding sales invoice.
> 
> Customer 2:
>    I went under AR and created a 'sales invoice' for 1 shirt directly
> 
> Customer 3:
>    I went under POS / Sale and sold 1 shirt
> 
> After each of the above transactions, I went under Goods & Services /  
> Reports  / All Items and looked under Reports / "Chart of Accounts"  
> and confirmed that the inventory was adjusted appropriately.
> 
> This reflects the same process I previously followed under the Club  
> SQL Ledger setup, so I am really at a loss of how the inventory  
> balance there is incorrect.
> 
> Roy

I don't notice anything that mentions you actually used the "Stock Assembly" function...?

The vendor invoices put the parts into stock, but you have to use the "stock assembly" function to combine those parts (shirt and embroidery)
into the assembled unit (embroidered shirt).
You then sell the assembled unit on your customer invoices.

Cheers
The other Roy

Re: [SL] Handling prepayments

[Michael H. <mh...@it...>]

Good point on the taxes!
    So to confirm I'm understanding, you've got a separate Liability  
account for each prepaying client?  And then as the funds are applied  
to invoices those amounts get moved over to the actual bank accounts  
on asset side of the balance sheet?  Are there two payment line items  
entered on each invoice then, one each for liability and asset?


Thanks!

Michael


On Feb 12, 2007, at 2:20 AM, Dr Eberhard Lisse wrote:

> I have a few clients who pre-pay or overpay, and for whom I have  
> created
>  Pre-Pay accounts (as Liability, because we haven't actually earned  
> the
> money, and thus we don't have to pay income tax on it :-)-O)). Then I
> have one for payments that pitch up in the bank accounts without
> identifying characteristics, and sooner or later the client will  
> let me
> know which invoice I can "pay" from that account.
>
> Auditors are very happy, but would like me to make more effort at the
> end of the financial year to lower the amounts in these accounts :-)-O
>
> el
>
> on 2/12/07 9:16 AM Michael Hasse said the following:
>> Hello everyone,
>>
>>     Just a thought/question regarding prepayment of services.  At the
>> moment when somebody prepays (or accidentally overpays) we make an AR
>> entry for that client with the check number, date paid etc and then
>> as the funds are applied to invoices we decrement the original AR
>> entry accordingly until the overage is depleted and then delete the
>> original entry all together.  This method does work but it is rather
>> prone to human error.
>>     And then I had an epiphany - could we not simply create an actual
>> separate AP account in the chart of accounts for each those clients?
>> And then "pay" invoices out of the appropriate account?  Is anyone
>> else doing this?  If so have there been any problems/pitfalls?  (Or
>> is there some third method that would be better than either of  
>> these?)
>>
>>
>> Thanks!
>>
>> Michael
>
> ---------------------------------------------------------------------- 
> ---
> Using Tomcat but need to do more? Need to support web services,  
> security?
> Get stuff done quickly with pre-integrated technology to make your  
> job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Will SQL-Ledger run ok on SuSE 10.2, or, is there any version of PostgreSQL that's too new?

[Dieter S. <dsi...@sq...>]

On Mon, 12 Feb 2007, Paul Tammes wrote:
>
> Then simply do a fresh OpenSuse 10.2 install,  install required
> packages as per  the readme, install  using the sql-ledger setup.
> Again as per readme / FAQ Make database using admin.pl and than do a
> psql  <  backup.sql

do not create a database with admin.pl, a restore will fail if the 
versions are different. Use psql to create a blank database and restore.

restoring from a 1.x version is a bit different because the schema has to 
be recreated from the sql files. A 1.x backup does not contain the schema. 
I don't recall when I added the schema but if there are none of the 
"CREATE TABLE suchandsuch' in the backup then the schema has to be created 
with the same version dataset first before a restore can be done.

createdb -U sql-ledger dbname
psql -U sql-ledger dbname < Pg-tables.sql
psql -U sql-ledger dbname < backup.sql
psql -U sql-ledger dbname < Pg-indices.sql

If the schema is in the backup all you need to do is

createdb -U sql-ledger dbname
psql -U sql-ledger dbname < backup.sql

-- 
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
============== On a clear disk you can seek forever ================

[SL] partscustomer table question

[Jeff R. <je...@jr...>]

Hi All

BACKGROUND:

The way my business has been set up I have assigned each customer a 
price level based on the volume of service they consume and the length 
of time that it takes them to pay. This goes something like: Delinquent, 
Late, Regular, Established, Preferred. I created pricegroups for this 
purpose and assigned a pricegroup for each customer. So far so good.

When I entered in all of the services I sell (electronic repair 
business) I entered them in with only the center price (Regular). I 
didn't realize at the time that I could create the price matrix. Now I 
want to add the other four price groups to each service. The other 
prices are simply set percentages above and below the regular price, 
Late is plus 10%, Delinquent is +15%, Established is - 10%, and 
Preferred is -15%. There are over a thousand services in there so 
editing them all by hand would be terribly time consuming.

I have PGAdmin and some experience with relational databases and a lot 
of programming experience so I thought I'd write an SQL script to fill 
in the partscustomer table using simple calculations.

QUESTION:

Where does the OID number come from? I see it at the beginning of each 
line in the table and it appears unique. If I'm going to add entries 
I'll need to generate this number to go with each line I write, can 
anyone shed some light on how it is advanced and if it is referred to by 
any other table or index?

Thanks
Jeff Roberts

Re: [SL] Will SQL-Ledger run ok on SuSE 10.2, or, is there any version of PostgreSQL that's too new?

[Paul T. <pt...@wa...>]

R Pennington schreef:
> On Friday 09 February 2007 2:25 pm, Jonathan Wilson wrote:
>   
>> Hello,
>>
>> I saw someone mention the other day that they are running SuSE 10.1 and they 
>> were having problems after installing SuSE updates because the data was too 
>> old for that version of Postgres - or something like that.
>>
>> I have been running an old 1.x version of SQL ledger on SuSE 9.0 for a few 
>> years now, and I am about to make a fresh install and wanted to ask, is there 
>> a problem running the latest SQL-Ledger on SuSE 10.2?
>>
>> Is there any version of PostgreSQL that is too new?
>>
>> Thanks,
>>
>> 	JW
>>
>>     
>
> The issue of newer versions of Postgresql....
> Major version changes of Postgresql require you to backup you data.. do the upgrade.. then restore that data.
> this is because the Postgresql developers have been known to change how Postgresql stores the data.
> In other words... If you upgrade Postgresql.. the newer version can't read the older version's files.
> Do search on the Postgresql site for info on upgrading between versions and it will explain all.
>
> This has nothing to do with SQL-Ledger.
>
> Cheers,
> Roy
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>   
In my  personal  experience,  it is simpler to make a  backup using 
SQL-Ledger (save to file  or email)  and get that to a
USB stick / CD burner.

Then simply do a fresh OpenSuse 10.2 install,  install required  
packages as per  the readme, install  using the sql-ledger setup.
Again as per readme / FAQ Make database using admin.pl and than do a
psql  <  backup.sql

S.O.P here, proven to work even from desktop to portable.

Remember to fix rights to the sql-ledger dir and subdirs and edit the 
/var/lib/psql/data/pga_hba.conf.
Set services postgres and apache to startup at boot, then reboot once to 
make sure everything runs smooth.
Apart from that, peace of cake.

Heck, Suse 10.2 does the Ati x200 chipset in my Toshiba notebook without 
sweat.
With 10.1 I had to do all kind of commandline stuff to get the 
proprietary driver to boot up.
SInce all runs I did not bother this time round. All is well again ;-))

Greetz,
Paul

Re: [SL] Handling prepayments

[Dr E. L. <el...@li...>]

I have a few clients who pre-pay or overpay, and for whom I have created
 Pre-Pay accounts (as Liability, because we haven't actually earned the
money, and thus we don't have to pay income tax on it :-)-O)). Then I
have one for payments that pitch up in the bank accounts without
identifying characteristics, and sooner or later the client will let me
know which invoice I can "pay" from that account.

Auditors are very happy, but would like me to make more effort at the
end of the financial year to lower the amounts in these accounts :-)-O

el

on 2/12/07 9:16 AM Michael Hasse said the following:
> Hello everyone,
> 
>     Just a thought/question regarding prepayment of services.  At the  
> moment when somebody prepays (or accidentally overpays) we make an AR  
> entry for that client with the check number, date paid etc and then  
> as the funds are applied to invoices we decrement the original AR  
> entry accordingly until the overage is depleted and then delete the  
> original entry all together.  This method does work but it is rather  
> prone to human error.
>     And then I had an epiphany - could we not simply create an actual  
> separate AP account in the chart of accounts for each those clients?   
> And then "pay" invoices out of the appropriate account?  Is anyone  
> else doing this?  If so have there been any problems/pitfalls?  (Or  
> is there some third method that would be better than either of these?)
> 
> 
> Thanks!
> 
> Michael