sql-ledger-users — SQL-Ledger users

Re: [SL] DIY Accounting

[Wallace R. C. <wrc...@gm...>]

On 12/8/06, Paul Witt <pau...@ox...> wrote:
...
> Scenario: A credit card company has sent a statement, with a "minimum
> payment" amount and a "must be received by" date.  Since no interest
> is currently being being charged by that card company, the intention is
> to pay them the minimum payment from a bank account a week before the
> "must be received by" date.  The credit card account exists under "long
> term liabilities" and the bank account exists under "current assets".
>
> What I actually end up doing in this situation is creating a general
> ledger entry showing a credit to the bank account and a debit to the credit
> card account for the same amount.  This basically represents the transfer
> that has taken place, but it doesn't record anything about the statement
>  / request for payment that was sent out.  In a way their statement is
> a bit like an invoice in that they're asking for payment, but it's not
> really an invoice because it's not for goods or services; from my point
> of view it's an internal transfer between an asset account and a liability
> account.

Actually, the statement that they (the credit card company, usually a
bank) sent to you is a record of all the goods / services that you
purchased on your credit card; an invoice, if you will.  So, if you
set it up as an invoice, I think the accounting will work just fine.

> Before I witter on too much, I suppose the question is: in this situation,
> is there a better way of representing the payment than via a GL entry?

See above.
-- 
Best Regards,
Wallace

Re: [SL] DIY Accounting

[Paul W. <pau...@ox...>]

On Fri, Dec 08, 2006 at 07:44:48AM -0700, Wallace Roberts Consulting wrote:
> On 12/8/06, Paul Witt <pau...@ox...> wrote:
> ...
> > On a related note, has anyone written
> > a guide to using sql-ledger for personal / household bookkeeping?
> 
> For that requirement, perhaps something like gnucash would be more
> appropriate: http://www.gnucash.org/

I've used gnucash in the past and it's good as far as it goes.  It
is certainly easy to get the hang of.

However, I am looking for something not so "Personal Computer" orientated.
For example, my requirements include:

 - being able to view and manipulate the data from several different locations,
   preferably via a web browser
 - being able to interact programmatically.  Example: send text messages from
   a phone to record purchases on the road, and have a custom processing script
   record the purchases in the accounting system

Essentially I was looking for a solution that fits in an enterprise-style
IT setup, but doesn't require enterprise-style accounting knowledge.
sql-ledger looks like it may well be suitable, albeit with a slight learning
curve on the accounting knowledge side of things.

        Paul

Re: [SL] DIY Accounting

[Paul W. <pau...@ox...>]

[...]
> I actually do my own household accounting in SQL-Ledger without any 
> problems whatsoever.
> But I may miss some of the showstoppers for non bookkeepers by my lack 
> of ignorance..

Okay, maybe I can supply some of that ignorance!  I'll walk you through
what I think about a simple transaction I'm currently trying to record.

Scenario: A credit card company has sent a statement, with a "minimum
payment" amount and a "must be received by" date.  Since no interest
is currently being being charged by that card company, the intention is
to pay them the minimum payment from a bank account a week before the
"must be received by" date.  The credit card account exists under "long
term liabilities" and the bank account exists under "current assets".

What I actually end up doing in this situation is creating a general
ledger entry showing a credit to the bank account and a debit to the credit
card account for the same amount.  This basically represents the transfer
that has taken place, but it doesn't record anything about the statement
 / request for payment that was sent out.  In a way their statement is 
a bit like an invoice in that they're asking for payment, but it's not
really an invoice because it's not for goods or services; from my point
of view it's an internal transfer between an asset account and a liability
account.

Before I witter on too much, I suppose the question is: in this situation,
is there a better way of representing the payment than via a GL entry?

        Paul

Re: [SL] DIY Accounting

[Wallace R. C. <wrc...@gm...>]

On 12/8/06, Paul Witt <pau...@ox...> wrote:
...
> On a related note, has anyone written
> a guide to using sql-ledger for personal / household bookkeeping?

For that requirement, perhaps something like gnucash would be more
appropriate: http://www.gnucash.org/

-- 
Best Regards,
Wallace

Re: [SL] DIY Accounting

[david <da...@ke...>]

Thanks Paul... it has now returned! One of life's great mysteries ;-)

http://www.sql-ledger.com/cgi-bin/nav.pl?page=contrib/contributors.html&title=Contributors

On Fri, 2006-12-08 at 09:47 +0100, Paul Tammes wrote:
> david schreef:
> > On Thu, 2006-12-07 at 21:05 -0600, John Hasler wrote:
> >   
> >> And now it's back.
> >>     
> >
> > but now gone again.....
> >
> >   
> Hi all,
> 
> I happen to have a copy here, it is only chapter1 and in draft form at that.
> The idea is to give some basic explanation to non-beancounters as to the 
> logic of some things.
> 
> If you are interested, mail me offlist and i can reply with a copy if it 
> keeps dissapearing.
> 
> -------------------------------------------------------------------------
> 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] DIY Accounting

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

Paul Witt schreef:
> [...]
>
> Thanks, that's useful (the link took a while to appear for me, too,
> but eventually I did get to the doc). On a related note, has anyone written
> a guide to using sql-ledger for personal / household bookkeeping?
> That is, using sql-ledger to track a straightforward set of
> personal accounts in a way that isn't too time-consuming to set
> up or to use day to day.
>
>   
Am working on chapter two now, I suppose the first few chapters will be 
of a more general info type.
However, with that info and a working SQL-Ledger I see no problem.
I actually do my own household accounting in SQL-Ledger without any 
problems whatsoever.
But I may miss some of the showstoppers for non bookkeepers by my lack 
of ignorance..

A step by step with screendumps for a family household might be an idea 
for chapters 8 and further,
Then for a homebrew service consuktancy for say chapter 10, a small shop 
for chapter 14 and later.

But hey, as I mentioned, I am working on chapter two now, and that is 
still in Dutch at that ;-)

Re: [SL] DIY Accounting

[Paul W. <pau...@ox...>]

iOn Thu, Dec 07, 2006 at 08:57:16AM -0700, Dieter Simader wrote:
> Paul Tammes put together some information for accounting. It's a short
> introduction to DIY accounting.
[...]

Thanks, that's useful (the link took a while to appear for me, too,
but eventually I did get to the doc). On a related note, has anyone written
a guide to using sql-ledger for personal / household bookkeeping?
That is, using sql-ledger to track a straightforward set of
personal accounts in a way that isn't too time-consuming to set
up or to use day to day.

I imagine that the support options listed at
http://www.sql-ledger.com/cgi-bin/nav.pl?page=misc/support.html&title=Support
are more aimed at businesses and that applying those docs to a
personal finance situation would be quite time-consuming in itself.
Is this in fact correct?

        Paul 

Re: [SL] DIY Accounting

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

david schreef:
> On Thu, 2006-12-07 at 21:05 -0600, John Hasler wrote:
>   
>> And now it's back.
>>     
>
> but now gone again.....
>
>   
Hi all,

I happen to have a copy here, it is only chapter1 and in draft form at that.
The idea is to give some basic explanation to non-beancounters as to the 
logic of some things.

If you are interested, mail me offlist and i can reply with a copy if it 
keeps dissapearing.

Re: [SL] DIY Accounting

[david <da...@ke...>]

On Thu, 2006-12-07 at 21:05 -0600, John Hasler wrote:
> And now it's back.

but now gone again.....

Re: [SL] DIY Accounting

[John H. <jo...@dh...>]

And now it's back.
-- 
John Hasler 
jo...@dh...
Elmwood, WI USA

Re: [SL] DIY Accounting

[John H. <jo...@dh...>]

david writes:
> How interesting... I can't find it either!

I couldn't find it right after Dieter posted his message.  This morning I
was able to read it, but now it's gone again.
-- 
John Hasler 
jo...@dh...
Elmwood, WI USA

Re: [SL] DIY Accounting

[david <da...@ke...>]

How interesting... I can't find it either!

Not by looking under contribs or by following your link. 

Looks like Gremlins in the works ;-)

On Thu, 2006-12-07 at 15:24 -0700, Wallace Roberts Consulting wrote:
> On 12/7/06, Mark Phillips <ma...@mo...> wrote:
> ...
> > Did I miss something?
> 
> Yes.  The link is right where Dieter indicated; here 'tis:
> 
> http://www.sql-ledger.com/contrib/accounting101.pdf
> 

Re: [SL] DIY Accounting

[Wallace R. C. <wrc...@gm...>]

On 12/7/06, Mark Phillips <ma...@mo...> wrote:
...
> Did I miss something?

Yes.  The link is right where Dieter indicated; here 'tis:

http://www.sql-ledger.com/contrib/accounting101.pdf

-- 
Best Regards,
Wallace

Re: [SL] Explanation of menus

[Stroller <lin...@my...>]

On 7 Dec 2006, at 09:08, Srimal Jayawardena wrote:
> ...
> Under AR we have
>
>    1. Add Transaction
>    2. Sales Invoice
>
>
> Under AR > Customer > Search > Open Customer
> We have:
>
>    1. AR Transaction
>    2. Sales Invoice

I am sure these are each shortcuts to the same functions.

As I understand it an AR Transaction is for stuff that non-itemised  
and not part of core business, whereas a Sales Invoice is for parts  
that you track in inventory & main-business services.

For instance, if one's business is as a plumber then pipe would have  
a part number and be sold on a Sales Invoice by the metre; labour  
would go on the same invoice by the hour. They are items which would  
be sold often, and the part number would be used so that the same  
thing is always entered the same on each invoice.

If Pete the Plumber sells his laptop computer - on which he does his  
accounts and which is owned by the business for tax purposes - then  
the payment received for its sale must be accounted to the taxman. It  
would not be logical for Pete's Plumbing to have an item code for a  
laptop which will be only bought and sold once, however, so an AR  
transaction is made; it does not really matter if an AR made in 2006  
says "My old laptop" but the previous one sold in 2004 says "Office  
clear-out - notebook computer" - we consider each a "one-off"  
transaction.

> Under POS we have
>
>    1. Sale

...
> Under AR > Customer > Search > Open Customer
...
>    3. POS

I am sure these are the same as each other, too, but have no idea how  
they're different from the other items. I'd GUESS that they're for  
parts that would otherwise be Sales Invoiced - perhaps a Point-Of- 
Sale transaction has no delivery address, or may accept cash (with no  
invoicee?)>

>    4. Sales Order
>    5. Quotation

Not sure the difference between these. I'd guess that SO is a  
committed sale, whereas quotation is not (just an "offer to sale").  
I'd expect SO to be distinct from a Sales Invoice in that items for a  
Sales Order might not yet be stock yet, whereas items on a Sales  
Invoice would normally have been delivered.

If English is not your first language then some of the distinctions  
may not be so clear to you; for me some of these usages "seem obvious".

Stroller.

Re: [SL] DIY Accounting

[Mark P. <ma...@mo...>]

On Dec 7, 2006, at 7:57 AM, Dieter Simader wrote:

> Paul Tammes put together some information for accounting. It's a short
> introduction to DIY accounting.
>
> The file can be downloaded from the contributor's section. Scroll  
> down to
> "Paul Tammes" and click on the link.

Hi, Dieter,

I see Paul Tammes Dutch equivalency chart, but no links and no DIY  
paper. I visited the main page and clicked "contributors".

Did I miss something?

Mark Phillips

[SL] Project function--What , How, When to use it.

[John W. F. <joh...@ve...>]

I am setting up SQL-Ledger to do book keeping for a building company and am 
trying to set up a function to handle each separate "project". Is that what 
the project function is for. 
-- 
John W. Foster

[SL] DIY Accounting

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

Paul Tammes put together some information for accounting. It's a short
introduction to DIY accounting.

The file can be downloaded from the contributor's section. Scroll down to
"Paul Tammes" and click on the link.

-- 
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 ================

Re: [SL] Explanation of menus

[David B. <dav...@sb...>]

On Thu, 2006-12-07 at 14:38 +0530, Srimal Jayawardena wrote:
> Hi
> 
> W are bit new to sql ledger.
> 
> Could someone explain the exact meanings of the following menu items.
I don't use all of the menu items that you are talking about, so I can
only expand upon what I am familiar with.  A suggestion...if you are not
needing particular items, deselect them through admin.pl to clean up
your menus.
> 
> Under AR we have
> 
>    1. Add Transaction
>    2. Sales Invoice

> Under POS we have
> 
>    1. Sale
> 
> 
> Under AR > Customer > Search > Open Customer
> We have:
> 
>    1. AR Transaction
>    2. Sales Invoice
>    3. POS
>    4. Sales Order
>    5. Quotation
This isn't doing much for me...I am not familiar with this list.  Likely
a screen that I don't use much (ever) or your menus are set up
differently from mine.  If these are the check box selections on the
screen that I believe you are looking at, it is simply a different way
of looking at things with date range options, more or less information
etc.  Can't offer much here.
> 1-4 looks the same to me, but there must be some difference.
> 
> My guess is this:
> 
> Sales Order: Goods is not yet delivered, but only an order is taken via the
> phone
A variant is that you can enter a sales order, deliver products from it
and affect inventory by using the Shipping --> Ship feature.  This is
useful if a customer wants a running order billed periodically.  This
allows you to add items to the sales order, deliver (affecting inventory
with shipping for purchasing reasons...at least in my case) and invoice
at set days/dates.
> POS: The customer will come over and buy it over the counter
POS...being Point Of Sale, is typically for such transactions.  I don't
use this function so don't have much more to add.
> Sales Invoice: The customer will buy it over the counter, but terms are
> credit and delivery instantly over the counter.
Sales invoice is, for me, the step I take in converting a sales order
into an invoice.  You can also add a sales invoice skipping over the
sales order step.  You can still collect for the invoice at time of
delivery/pick up.  We have many COD (cash on delivery) customers that
are simply set up with terms of "0".
> AR Transaction: The goods on order is delivered to the customer on credit.
I believe that you could use this for several different scenarios
whether a customer is prepaying, using credit etc.  A/R Transactions are
also useful for billing a customer for things other than goods &
services.  This allows you to select items from your chart of accounts
that are selected to show up as income.  I use A/R Transactions to add
service charges against past due balances prior to cutting statements.

Hopefully what I have said isn't more confusing and that I understood
your question.

David Boyle
NAPCO


> 
> Thanks in advance
> 
> Srimal and Metta
> -------------------------------------------------------------------------
> 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] Explanation of menus

[Srimal J. <sr...@ma...>]

Hi

W are bit new to sql ledger.

Could someone explain the exact meanings of the following menu items.


Under AR we have

   1. Add Transaction
   2. Sales Invoice

Under POS we have

   1. Sale


Under AR > Customer > Search > Open Customer
We have:

   1. AR Transaction
   2. Sales Invoice
   3. POS
   4. Sales Order
   5. Quotation

1-4 looks the same to me, but there must be some difference.

My guess is this:

Sales Order: Goods is not yet delivered, but only an order is taken via the
phone
POS: The customer will come over and buy it over the counter
Sales Invoice: The customer will buy it over the counter, but terms are
credit and delivery instantly over the counter.
AR Transaction: The goods on order is delivered to the customer on credit.


Thanks in advance

Srimal and Metta

Re: [SL] AR Reports - Transactions Source?

[David B. <dav...@sb...>]

Close...but not exactly what I am looking for.  An A/R report is quick
and light, but the GL report is displaying more info than is needed and
a little more intense unless it is date ranged.  Beyond that, I am the
only person with access to the GL menu as access by others would allow
them access to info that they do not need to know.  I was hoping for a
simple report to assist my A/R person.

Thanks,
David Boyle
NAPCO

On Wed, 2006-12-06 at 13:09 -0700, Dieter Simader wrote:
> Use the GL report to include the source.

Re: [SL] AR Reports - Transactions Source?

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

Use the GL report to include the source.

-- 
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 ================

On Wed, 6 Dec 2006, David Boyle wrote:

> Hello all,
> When running an AR-->Reports-->Transactions report, it seems as if
> "SOURCE" would be a convenient selectable box so that you could explain
> to a customer what check number was applied to specific transactions.
> The only option that I seem to have is to click the specific Invoices
> and scrolling to the bottom to the payments section.  Of course if you
> are not careful, you can re-post from there so I tend to stay away from
> that and instruct my employees to do the same.  Am I missing something
> obvious?  Am I broken?  Should I create a feature request?  I am running
> 2.6.16...perhaps this has already been addressed.
>
> Thanks,
> David Boyle
> NAPCO
>
>
> -------------------------------------------------------------------------
> 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] AR Reports - Transactions Source?

[David B. <dav...@sb...>]

Hello all,
When running an AR-->Reports-->Transactions report, it seems as if
"SOURCE" would be a convenient selectable box so that you could explain
to a customer what check number was applied to specific transactions.
The only option that I seem to have is to click the specific Invoices
and scrolling to the bottom to the payments section.  Of course if you
are not careful, you can re-post from there so I tend to stay away from
that and instruct my employees to do the same.  Am I missing something
obvious?  Am I broken?  Should I create a feature request?  I am running
2.6.16...perhaps this has already been addressed.

Thanks,
David Boyle
NAPCO

Re: [SL] lost admin password

[Wahur <vah...@gm...>]

thanks!

Wahur

On 12/6/06, Richard Patterson <ri...@he...> wrote:
> Wahur wrote:
> > Hello!
> >
> > About a year ago i set up sql-ledger for my Mom, who is typical luddite
> > accountant :)
> > Now, year later there is a need to create a new company, but file with all
> > the passwords is gone. And, of course, noone remembers the admin password.
> > Any way to recover the password?
> > System is suse 10.1, sql-ledger is 2.6.12. Root access to the box I have.
> >
> > Wahur, ledger-newb
> >
> Open the file /usr/local/sql-ledger/users/members in your favourite
> editor, and remove the password line under [root login].
>
> Then you'll be able to access the admin interface without a password.
>
> Hope that helps
>
> Regards
>
> Richard
>
> --
>
> Richard Patterson          HelpQuick Limited
> Tel: 0191 2582888          Fax: 0191 6408666
> Jabber chat:  ri...@ja...
> Web:     http://www.helpquick.co.uk
>
>
> -------------------------------------------------------------------------
> 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] lost admin password

[Richard P. <ri...@he...>]

Wahur wrote:
> Hello!
>
> About a year ago i set up sql-ledger for my Mom, who is typical luddite
> accountant :)
> Now, year later there is a need to create a new company, but file with all
> the passwords is gone. And, of course, noone remembers the admin password.
> Any way to recover the password?
> System is suse 10.1, sql-ledger is 2.6.12. Root access to the box I have.
>
> Wahur, ledger-newb
>   
Open the file /usr/local/sql-ledger/users/members in your favourite
editor, and remove the password line under [root login].

Then you'll be able to access the admin interface without a password.

Hope that helps

Regards

Richard

-- 

Richard Patterson          HelpQuick Limited
Tel: 0191 2582888          Fax: 0191 6408666
Jabber chat:  ri...@ja...
Web:     http://www.helpquick.co.uk

[SL] lost admin password

[Wahur <vah...@gm...>]

Hello!

About a year ago i set up sql-ledger for my Mom, who is typical luddite
accountant :)
Now, year later there is a need to create a new company, but file with all
the passwords is gone. And, of course, noone remembers the admin password.
Any way to recover the password?
System is suse 10.1, sql-ledger is 2.6.12. Root access to the box I have.

Wahur, ledger-newb