sql-ledger-users

[SL] Switching to sql-ledger for real, finally

[Ben D. <bd...@cu...>]

We've been using sql-ledger in a limited way for several years.
Basically, we have used it to generate quotations, purchase orders,
shipping documents, and, finally, invoices. But, strange as this
probably sounds, we have not used it for actual accounting. (We have
been using a 'legacy' (!) Mac running MYOB for that.)

I want to begin immediately to use sql-ledger properly for the whole
accounting work flow for 2008 (i.e., as of 8 days ago).

We have a lot of data in sql-ledger that is valuable to us at this
point. Mostly, its the contact information. But the invoices we have
generated over the last few years show us what customers have bought,
when they bought, etc.

Can anyone recommend the best way for me, in this imperfect situation,
to begin 2008 accounts in the optimum way?

Basically, I'd like most or all account balances to be zeroed out. But
I'd still like to be able to look back at old quotes and invoices. And
there are some quotes and invoices which are actually open, too.

I'm sorry this question is rather open-ended. I have bills that I would
like to pay next week using sql-ledger, so I am trying to get things
reasonably set up before that.

Thanks in advance.

Ben

Re: [SL] Switching to sql-ledger for real, finally

[Rich S. <rsh...@ap...>]

On Tue, 8 Jan 2008, Ben Dugan wrote:

> Can anyone recommend the best way for me, in this imperfect situation,
> to begin 2008 accounts in the optimum way?

   Log in, select the System menu, then the Yearend option.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Switching to sql-ledger for real, finally

[Ben D. <bd...@cu...>]

Rich Shepard wrote:
> On Tue, 8 Jan 2008, Ben Dugan wrote:
> 
>> Can anyone recommend the best way for me, in this imperfect
>> situation, to begin 2008 accounts in the optimum way?
> 
> Log in, select the System menu, then the Yearend option.

Thanks. I have tried this in a 'sandbox' copy of our accounts, and now
I'm trying to understand what it did. These things take time for me to
understand, but I wanted to say thanks right away.

Ben

Re: [SL] Switching to sql-ledger for real, finally

[Rich S. <rsh...@ap...>]

On Tue, 8 Jan 2008, Ben Dugan wrote:

> Thanks. I have tried this in a 'sandbox' copy of our accounts, and now I'm
> trying to understand what it did. These things take time for me to
> understand, but I wanted to say thanks right away.

Ben,

  The year end function creates a G/L transaction offsetting income and
expense accounts to zero. It also does not remove transactions or close a
period; you may run the year end anytime. The Journal entry is the same as
other G/L entries, but the transaction will be on income statements.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Switching to sql-ledger for real, finally

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

A little more on the same issue:

Usual bookkeeping programs totally empty out all profit and loss acoounts
and move the result to a balance sheet account, normally Result Bookyear or
something similar. Then you start next year with a clean set of accounts for
profit and loss part.

SQL-ledger makes a year-end booking, say dec 31 2007, with the same effect,
but leaves all entries where tehy are.

So if you run a P&L report from jan 1 till dec 30 of any year you see the
amounts of all entries for the year.
If you do the same for jan 1 till dec 31 (after a year end J/E) you see all
zero.
Nice for comparison between say jan -dec 30 year minus one and current year
to begin with ;-)


2008/1/8, Rich Shepard <rsh...@ap...>:
>
> On Tue, 8 Jan 2008, Ben Dugan wrote:
>
> > Thanks. I have tried this in a 'sandbox' copy of our accounts, and now
> I'm
> > trying to understand what it did. These things take time for me to
> > understand, but I wanted to say thanks right away.
>
> Ben,
>
>   The year end function creates a G/L transaction offsetting income and
> expense accounts to zero. It also does not remove transactions or close a
> period; you may run the year end anytime. The Journal entry is the same as
> other G/L entries, but the transaction will be on income statements.
>
> Rich
>
> --
> Richard B. Shepard, Ph.D.
> |  Integrity            Credibility
> Applied Ecosystem Services, Inc.        |            Innovation
> <http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax:
> 503-667-8863
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
>
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

Re: [SL] Switching to sql-ledger for real, finally

[Dirk E. S. <ds...@ca...>]

> Basically, I'd like most or all account balances to be zeroed out. But
> I'd still like to be able to look back at old quotes and invoices. And
> there are some quotes and invoices which are actually open, too.

If you want to use the historical information like invoices etc. you could
do the following:

1) Call a trial balance as of 31 of dec.
2) Ad a GL transaction, exactly as the above trial balance but with
NEGATIVE values.
3) Check your balance as of 31 of dec. Should be all in cero!
4) Call a trial balance from your old accounting system, transcribe it as
a GL transaction.

Now your balances in both accounting systems should be excatly the same.
Open invoices should show up in your statements. If everything looks fine
you should use the year end function and close last year.

Hope it helps

Enrique


-- 
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com