sql-ledger-users

[SQL-Ledger-users] Documentation?

[Mark T. <ma...@fr...>]

Is there any documentation available (appart from the homepage FAQ) for SQL-Ledger, basically 
for a bit of a beginner, that explains some of the interfaces? Although I've been doing my own 
very-small-business accounts for 20+ years I obviously don't get the way accounts are linked 
here.

I'd love to get to grips with SQL-Ledger since I use perl and postgres in our web business and 
it's the first package I've seen that fits the way we do most things via a browser and web/db back-
end. It also appears to offer everything we need, but without the crazy overbloat that off-the-shelf 
commercial packages bewilder us with.

Appologies if this is just too dumb a question here.... go ahead and scream at me :)

Mark

Mark Tiramani
FREDO Internet Services
ma...@fr...

Re: [SQL-Ledger-users] Documentation?

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

Accounts are linked with keywords. You see them listed when you go to
setup and list the accounts. In a prior message I explained what these
keywords mean. The messages are archived at sourceforge. A link to the
archive can be found at http://www.sql-ledger.org/misc/support.html

Also checkout the screenshots page. It gives a bit of an explaination
what you can do and how some things work.


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

On Tue, 6 Feb 2001, Mark Tiramani wrote:

> Is there any documentation available (appart from the homepage FAQ) for SQL-Ledger, basically 
> for a bit of a beginner, that explains some of the interfaces? Although I've been doing my own 
> very-small-business accounts for 20+ years I obviously don't get the way accounts are linked 
> here.
> 
> I'd love to get to grips with SQL-Ledger since I use perl and postgres in our web business and 
> it's the first package I've seen that fits the way we do most things via a browser and web/db back-
> end. It also appears to offer everything we need, but without the crazy overbloat that off-the-shelf 
> commercial packages bewilder us with.
> 
> Appologies if this is just too dumb a question here.... go ahead and scream at me :)
> 
> Mark
> 
> Mark Tiramani
> FREDO Internet Services
> ma...@fr...
> 
> 

Re: [SQL-Ledger-users] Documentation?

[Mark T. <ma...@fr...>]

[snip]
> keywords mean. The messages are archived at sourceforge. A link to the
> archive can be found at http://www.sql-ledger.org/misc/support.html

Thanks, I had checked the archive and read that message, and looked at the screenshots, but I 
fear my problem is even more basic. I feel incredibly stupid, but.....

I'm using 1.2.7. I understand the general accounting principles but not the terminology involved, 
and no-matter how I link or record a simple incoming invoice I can't get results that make sense 
to me. If someone would be so kind as to give concrete help on the following example I'm sure I 
could get my head around the rest:

I have a Chequing account used for whole payment, including VAT.
and an invoice I need to pay for a server that includes 17.5% VAT (UK standard sales tax).

How should the Chequing account be set-up? I have: 'Asset', 'Account', 'Receivables: Deposit', 
and 'Payables: Payment'  checked.

What should be entered/selected in the A/P -> 'Add Transaction' form fields for:
Amount:, VAT:, Paid:
I tried many daft things but this is the example I would most expect to work:
'Amount:'    1175   1820- Office Furniture & Equipment   (gross including VAT)
'VAT:'           175   2310-GST
'Paid:'         1175   1061-Chequing Account

However, this results in an Accounts List showing:
Chequing Account  Credit 1175.00
Office Furniture & Equipment  Debit  1175.00
Accounts Payable  Credit  175.00
GST   Debit  175.00

Debit total  1350
Credit total 1350

Surely that can't be right :)

BTW I've added one account, 4340, for Sys admin income. All other accounts are using default 
settings.

Any help appreciated,

Mark

Mark Tiramani
FREDO Internet Services
ma...@fr...

Re: [SQL-Ledger-users] Documentation?

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

A checking account is an asset account.

If you use the account to pay bills and deposit money received then check
the box in the column Receivables -> Deposit and Payables ->
Payment. This will include the account in the drop down lists

In your sample transaction you had not fully paid for the furniture
thus leaving you with 175 outstanding in payables.


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

On Tue, 6 Feb 2001, Mark Tiramani wrote:

> [snip]
> > keywords mean. The messages are archived at sourceforge. A link to the
> > archive can be found at http://www.sql-ledger.org/misc/support.html
> 
> Thanks, I had checked the archive and read that message, and looked at the screenshots, but I 
> fear my problem is even more basic. I feel incredibly stupid, but.....
> 
> I'm using 1.2.7. I understand the general accounting principles but not the terminology involved, 
> and no-matter how I link or record a simple incoming invoice I can't get results that make sense 
> to me. If someone would be so kind as to give concrete help on the following example I'm sure I 
> could get my head around the rest:
> 
> I have a Chequing account used for whole payment, including VAT.
> and an invoice I need to pay for a server that includes 17.5% VAT (UK standard sales tax).
> 
> How should the Chequing account be set-up? I have: 'Asset', 'Account', 'Receivables: Deposit', 
> and 'Payables: Payment'  checked.
> 
> What should be entered/selected in the A/P -> 'Add Transaction' form fields for:
> Amount:, VAT:, Paid:
> I tried many daft things but this is the example I would most expect to work:
> 'Amount:'    1175   1820- Office Furniture & Equipment   (gross including VAT)
> 'VAT:'           175   2310-GST
> 'Paid:'         1175   1061-Chequing Account
> 
> However, this results in an Accounts List showing:
> Chequing Account  Credit 1175.00
> Office Furniture & Equipment  Debit  1175.00
> Accounts Payable  Credit  175.00
> GST   Debit  175.00
> 
> Debit total  1350
> Credit total 1350
> 
> Surely that can't be right :)
> 
> BTW I've added one account, 4340, for Sys admin income. All other accounts are using default 
> settings.
> 
> Any help appreciated,
> 
> Mark
> 
> Mark Tiramani
> FREDO Internet Services
> ma...@fr...
> 
> 

Re: [SQL-Ledger-users] Documentation?

[Mark T. <ma...@fr...>]

> A checking account is an asset account.


I did have it marked as an 'Asset' account.

(Is this a Checking Account or a Chequing Account??)


<color><param>0000,0000,0000</param>> If you use the account to pay bills =
and deposit money received then check

> the box in the column Receivables -> Deposit and Payables ->

> Payment. This will include the account in the drop down lists


</color>As I illustrated previously this is exactly the way it was set up.=
 


<color><param>0000,0000,0000</param>> In your sample transaction you had n=
ot fully paid for the furniture

> thus leaving you with 175 outstanding in payables.


</color>So in /sql-ledger/ap.cgi?action=3Dadd 'Amount:' on row 6 means 'Ne=
t Amount:' ?

In the same form doesn't 'Paid:' mean 'Paid From:' ?


Again: the 'computer' was bought by my company for =A31,175 gross and I pa=
id =A31,175, from 
'Chequing' (Checking?). Please see my previous email below.


If I start with =A30 in Checking how can I still get =A31,175 credited to =
the 'Chequing Account' to give 
a total 'Credit' of =A31,175.00. ..... Surely I should have a 'Debit' of =A3=
1,175 in 'Checking', whichever 
way the VAT is accounted for ??


I'm a programmer not a mathematician, but is my math really that bad!? :)

I obviously don't understand what a 'Checking Account' really is. To me it=
 represents my Bank 
balance and available funds.


Mark


<color><param>0000,0000,0000</param>> > How should the Chequing account be=
 set-up? I have: 'Asset', 'Account', 'Receivables: Deposit', and

> > 'Payables: Payment'  checked.

> > 

> > What should be entered/selected in the A/P -> 'Add Transaction' form f=
ields for:

> > Amount:, VAT:, Paid:

> > I tried many daft things but this is the example I would most expect t=
o work:

> > 'Amount:'    1175   1820- Office Furniture & Equipment   (gross includ=
ing VAT)

> > 'VAT:'           175   2310-GST

> > 'Paid:'         1175   1061-Chequing Account

> > 

> > However, this results in an Accounts List showing:

> > Chequing Account  Credit 1175.00

> > Office Furniture & Equipment  Debit  1175.00

> > Accounts Payable  Credit  175.00

> > GST   Debit  175.00

> > 

> > Debit total  1350

> > Credit total 1350

> > 

> > Surely that can't be right :)


Mark Tiramani
FREDO Internet Services
ma...@fr...

Re: [SQL-Ledger-users] Documentation?

[Designer <wir...@ta...>]

Mark Tiramani wrote:

Hello Everyone,

I have found a really good book on databases, and it 
extols PostgreSQL, as a really good database. The book
examines the myth that mysql is faster than PostgreSQL,
due to setup difference, usually be default. This book
covers Postgresql quite extensively, and does cover other
for Lynux systems:

PostgreSQL, MySQL, Mini SQL, Sybase and Oracle

"Database Application Programming with LINUX"

by Brain Jepson, Joan Peckham, Ram Sadasiv

Wiley  ISBN 0-471-35549-6  Copyright 2000


> 
> [snip]
> > keywords mean. The messages are archived at sourceforge. A link to the
> > archive can be found at http://www.sql-ledger.org/misc/support.html
> 
> Thanks, I had checked the archive and read that message, and looked at the screenshots, but I
> fear my problem is even more basic. I feel incredibly stupid, but.....
> 
> I'm using 1.2.7. I understand the general accounting principles but not the terminology involved,
> and no-matter how I link or record a simple incoming invoice I can't get results that make sense
> to me. If someone would be so kind as to give concrete help on the following example I'm sure I
> could get my head around the rest:
> 
> I have a Chequing account used for whole payment, including VAT.
> and an invoice I need to pay for a server that includes 17.5% VAT (UK standard sales tax).
> 
> How should the Chequing account be set-up? I have: 'Asset', 'Account', 'Receivables: Deposit',
> and 'Payables: Payment'  checked.
> 
> What should be entered/selected in the A/P -> 'Add Transaction' form fields for:
> Amount:, VAT:, Paid:
> I tried many daft things but this is the example I would most expect to work:
> 'Amount:'    1175   1820- Office Furniture & Equipment   (gross including VAT)
> 'VAT:'           175   2310-GST
> 'Paid:'         1175   1061-Chequing Account
> 
> However, this results in an Accounts List showing:
> Chequing Account  Credit 1175.00
> Office Furniture & Equipment  Debit  1175.00
> Accounts Payable  Credit  175.00
> GST   Debit  175.00
> 
> Debit total  1350
> Credit total 1350
> 
> Surely that can't be right :)
> 
> BTW I've added one account, 4340, for Sys admin income. All other accounts are using default
> settings.
> 
> Any help appreciated,
> 
> Mark
> 
> Mark Tiramani
> FREDO Internet Services
> ma...@fr...