sql-ledger-users

[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] 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

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

[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...>]

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

[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...>]

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

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

Not a mystery at all. I have two servers running www. They may not have
been synchronized at the same time, so it depends which one you were
seeing. I have no control over which server is the main or the slave.

-- 
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 Sat, 9 Dec 2006, david wrote:

> 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
> >
>
>
> -------------------------------------------------------------------------
> 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 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...>]

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

[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

[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:
...
> 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