Menu
▾
▴
sql-ledger-users
|
From: Roy N. <RNi...@NB...> - 2007-02-11 14:42:18
|
After far too long, I am upgrading the version of SQL-Ledger used by the a local marathon from version 2.6.3. When I run setup.pl, it goes out and pulls down version 2.6.23, yet I have read of folks running version 2.7.x on this list. How do I get this latest version? Roy |
|
From: Dr E. L. <el...@li...> - 2007-02-11 15:39:32
|
You pay for the manual and get access to the download site. el on 2/11/07 4:43 PM Roy Nicholl said the following: > After far too long, I am upgrading the version of SQL-Ledger used by > the a local marathon from version 2.6.3. When I run setup.pl, it > goes out and pulls down version 2.6.23, yet I have read of folks > running version 2.7.x on this list. How do I get this latest version? > > Roy -- Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist (Saar) el...@li... el108-ARIN / * | Telephone: +264 81 124 6733 (cell) PO Box 8421 \ / Please do NOT email to this address Bachbrecht, Namibia ;____/ if it is DNS related in ANY way |
|
From: Roy N. <RNi...@NB...> - 2007-02-11 20:34:43
|
Oh ... where the marathon is a not-for-profit, I doubt they will be inclined to pay for support/manual. Dieter, Does this mean that the 'public' version ends with 2.6.x? Roy On 11-Feb-2007, at 11:38, Dr Eberhard Lisse wrote: > You pay for the manual and get access to the download site. > > el > > on 2/11/07 4:43 PM Roy Nicholl said the following: >> After far too long, I am upgrading the version of SQL-Ledger used by >> the a local marathon from version 2.6.3. When I run setup.pl, it >> goes out and pulls down version 2.6.23, yet I have read of folks >> running version 2.7.x on this list. How do I get this latest >> version? >> >> Roy > |
|
From: Dr E. L. <el...@li...> - 2007-02-11 21:53:45
|
Well, if they don't want to pay for support, they get the support they pay for. My impression about 2.7.* is that it is beta and eventually it will become 2.8.* which will be public. But then this is Mr Simader's program. greetings, el on 2/11/07 10:35 PM Roy Nicholl said the following: > Oh ... where the marathon is a not-for-profit, I doubt they will be > inclined to pay for support/manual. > > Dieter, > > Does this mean that the 'public' version ends with 2.6.x? > > Roy > > On 11-Feb-2007, at 11:38, Dr Eberhard Lisse wrote: > >> You pay for the manual and get access to the download site. >> >> el >> >> on 2/11/07 4:43 PM Roy Nicholl said the following: >>> After far too long, I am upgrading the version of SQL-Ledger used by >>> the a local marathon from version 2.6.3. When I run setup.pl, it >>> goes out and pulls down version 2.6.23, yet I have read of folks >>> running version 2.7.x on this list. How do I get this latest >>> version? |
|
From: Paolo A. <pja...@gm...> - 2007-02-12 02:46:23
|
is an enhanced version with more features. This version is in production use but requires more support because the features are not documented. [ download v2.7 <http://abacus.sql-ledger.com/source/sql-ledger> ] 2.7 is in production use... With 2.8 being full of features (and will might also have a beta..) how sure are we that 2.8 will be public or FREE for download? On 2/12/07, Dr Eberhard Lisse <el...@li...> wrote: > > Well, if they don't want to pay for support, they get the support they > pay for. > > My impression about 2.7.* is that it is beta and eventually it will > become 2.8.* which will be public. But then this is Mr Simader's program. > > greetings, el > > > on 2/11/07 10:35 PM Roy Nicholl said the following: > > Oh ... where the marathon is a not-for-profit, I doubt they will be > > inclined to pay for support/manual. > > > > Dieter, > > > > Does this mean that the 'public' version ends with 2.6.x? > > > > Roy > > > > On 11-Feb-2007, at 11:38, Dr Eberhard Lisse wrote: > > > >> You pay for the manual and get access to the download site. > >> > >> el > >> > >> on 2/11/07 4:43 PM Roy Nicholl said the following: > >>> After far too long, I am upgrading the version of SQL-Ledger used by > >>> the a local marathon from version 2.6.3. When I run setup.pl, it > >>> goes out and pulls down version 2.6.23, yet I have read of folks > >>> running version 2.7.x on this list. How do I get this latest > >>> version? > > ------------------------------------------------------------------------- > 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 > |
|
From: Dr E. L. <el...@li...> - 2007-02-12 04:08:00
|
It's beta, and I also use it in production. But, stop whining. el on 2/12/07 4:46 AM Paolo Abadesco said the following: > is an enhanced version with more features. This version is in > production use but requires more support because the features are > not documented. [ download v2.7 > <http://abacus.sql-ledger.com/source/sql-ledger> ] > > 2.7 is in production use... With 2.8 being full of features (and > will might also have a beta..) how sure are we that 2.8 will be > public or FREE for download? |
|
From: Michael H. <mh...@it...> - 2007-02-12 07:16:58
|
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
|
|
From: Dr E. L. <el...@li...> - 2007-02-12 10:20:42
|
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 |
|
From: Michael H. <mh...@it...> - 2007-02-13 06:22:01
|
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
|
|
From: Dr E. L. <el...@li...> - 2007-02-13 18:36:53
|
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 |
|
From: Michael H. <mh...@it...> - 2007-02-14 00:33:06
|
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 |
|
From: Roy N. <RNi...@NB...> - 2007-02-14 01:26:59
|
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 |
|
From: Dr E. L. <el...@li...> - 2007-02-14 04:20:36
|
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? :) |
|
From: Roy N. <RNi...@NB...> - 2007-02-14 11:00:56
|
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 |
|
From: Michael H. <mh...@it...> - 2007-02-15 01:07:26
|
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
|
|
From: Neil J. <nei...@ma...> - 2007-02-15 02:00:41
|
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 > > |
|
From: Dr E. L. <el...@li...> - 2007-02-15 04:41:38
|
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? |
|
From: Michael H. <mh...@it...> - 2007-02-18 01:24:11
|
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 |
|
From: <pe...@si...> - 2007-02-14 09:39:17
|
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 > |
|
From: Dr E. L. <el...@li...> - 2007-02-15 05:06:49
|
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 > > |
|
From: Andi S. <as...@ac...> - 2007-02-11 21:01:50
|
hi, hint: just got to the download page http://sql-ledger.org/cgi-bin/nav.pl?page=source/index.html&title=Download search for 2.7 regards A. On Sun, 11 Feb 2007, Roy Nicholl wrote: > > Oh ... where the marathon is a not-for-profit, I doubt they will be > inclined to pay for support/manual. > > Dieter, > > Does this mean that the 'public' version ends with 2.6.x? > > Roy > > On 11-Feb-2007, at 11:38, Dr Eberhard Lisse wrote: > >> You pay for the manual and get access to the download site. >> >> el >> >> on 2/11/07 4:43 PM Roy Nicholl said the following: >>> After far too long, I am upgrading the version of SQL-Ledger used by >>> the a local marathon from version 2.6.3. When I run setup.pl, it >>> goes out and pulls down version 2.6.23, yet I have read of folks >>> running version 2.7.x on this list. How do I get this latest >>> version? >>> >>> 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 > |
|
From: Roy N. <RNi...@NB...> - 2007-02-11 21:06:54
|
The link on the page wants a user name and password (htaccess?) ... which appears to fit in with Eberhard's explanation. Thanks anyway, Roy On 11-Feb-2007, at 17:01, Andi Stern wrote: > hi, > > hint: just got to the download page > > http://sql-ledger.org/cgi-bin/nav.pl?page=source/ > index.html&title=Download > > search for 2.7 > > regards > > A. > > On Sun, 11 Feb 2007, Roy Nicholl wrote: > >> >> Oh ... where the marathon is a not-for-profit, I doubt they will be >> inclined to pay for support/manual. >> >> Dieter, >> >> Does this mean that the 'public' version ends with 2.6.x? >> >> Roy >> >> On 11-Feb-2007, at 11:38, Dr Eberhard Lisse wrote: >> >>> You pay for the manual and get access to the download site. >>> >>> el >>> >>> on 2/11/07 4:43 PM Roy Nicholl said the following: >>>> After far too long, I am upgrading the version of SQL-Ledger >>>> used by >>>> the a local marathon from version 2.6.3. When I run setup.pl, it >>>> goes out and pulls down version 2.6.23, yet I have read of folks >>>> running version 2.7.x on this list. How do I get this latest >>>> version? >>>> >>>> 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 >> > > ---------------------------------------------------------------------- > --- > 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 |
|
From: Andi S. <as...@ac...> - 2007-02-11 21:08:19
|
hi, just did not think about a missing password - a typical open source product ;-)) I personally suggest ledger-smb - I am just waiting for the first usable debian Version - only a matter of time - but Documentation is included ... regards A. On Sun, 11 Feb 2007, Andi Stern wrote: > hi, > > hint: just got to the download page > > http://sql-ledger.org/cgi-bin/nav.pl?page=source/index.html&title=Download > > search for 2.7 > > regards > > A. > > On Sun, 11 Feb 2007, Roy Nicholl wrote: > >> >> Oh ... where the marathon is a not-for-profit, I doubt they will be >> inclined to pay for support/manual. >> >> Dieter, >> >> Does this mean that the 'public' version ends with 2.6.x? >> >> Roy >> >> On 11-Feb-2007, at 11:38, Dr Eberhard Lisse wrote: >> >>> You pay for the manual and get access to the download site. >>> >>> el >>> >>> on 2/11/07 4:43 PM Roy Nicholl said the following: >>>> After far too long, I am upgrading the version of SQL-Ledger used by >>>> the a local marathon from version 2.6.3. When I run setup.pl, it >>>> goes out and pulls down version 2.6.23, yet I have read of folks >>>> running version 2.7.x on this list. How do I get this latest >>>> version? >>>> >>>> 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 >> > |
|
From: Dr E. L. <el...@li...> - 2007-02-11 21:55:35
|
Stop whining. el on 2/11/07 11:07 PM Andi Stern said the following: > hi, > > just did not think about a missing password - a typical open source > product ;-)) > > I personally suggest ledger-smb - I am just waiting for the first usable > debian Version - only a matter of time - but Documentation is included ... > > regards > > A. > |
|
From: Andi S. <as...@ac...> - 2007-02-11 22:18:53
|
sorry, not being a native english speaker I consult my webster and read:
1. a) to utter a peevish, high-pitched, somewhat nasal sound, as in
complaint, distress, fear, etc.
b) to make a prolonged, high pitched sound like this
2. to complain or beg in a childishly undignified way.
I dont understand you - Which of theese do you mean? I do neither complain
nor beg
I am just stating the download is password protected I am mentioning
my private preferneces - which I consider as legitimate.
I respect Dieter Simaders wish for not revealing source code to everybody,
but please explain how from the following text can be found out that that
version 2.7 is not for free download:
"Version 2.7 is an enhanced version with more features. This version is in
production use but requires more support because the features are not
documented. [ download v2.7 ]
Additional features:
Debit/Credit notes and invoices
template variable calculations
voucher system for payable, general ledger, payment and payment reversals
early payment discounts, GAAP and European standards
default account links for customers/vendors
reconciliation procedure based on dates
warehouse links on invoices and orders
threshold for payment to exclude payments
import sales invoices
new batch print, queue and email functions
Installation instruction are in the README file."
regards
A.
On Sun, 11 Feb 2007, Dr Eberhard Lisse wrote:
> Stop whining.
>
> el
>
> on 2/11/07 11:07 PM Andi Stern said the following:
>> hi,
>>
>> just did not think about a missing password - a typical open source
>> product ;-))
>>
>> I personally suggest ledger-smb - I am just waiting for the first usable
>> debian Version - only a matter of time - but Documentation is included ...
>>
>> regards
>>
>> A.
>>
>
> -------------------------------------------------------------------------
> 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
>
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X