sql-ledger-users

[SL] Reminder Needed: Changing Linking Account

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

   When I prepare an Accounts Payable transaction it's apparently entered
both in A/P and Current Liabilities. The latter is the default under the
specific expense account widget. It's been so long that I have forgotten
where to change that default to A/P so it's cleared when paid, and not
accumulated as a current liability.

TIA,

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] Reminder Needed: Changing Linking Account

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

How do you enter payments? If via a suspense account, there might be some
set offs not automaticaly going trough. Let me explain:

I use a ledger for A/P (#1600) when entering invoices. When paid from the
bank I debit A/P invoices paid suspense account (#1605). Then the A/P dept
can apply the amounts in #1605 to settle the paid invoices. Quicker on bank
account entry, leaving A/P dept with the hassle. But then, they now the
suppliers better than I do ;-)

However, the overall balance sheet looks right, even when not settled:
Current Liailities for A/P minus A/P suspense account (1600 and 1605
combined via GIFI code 1600) gives me the correct and  actual Liabilities
amount. Life is good ;-)

What I mean to say is, there might very well be some payments not allocated
to the A/P (sub) ledger, which will result in a huge total on A/P. Search
for your equivalent of #1605!

Hth,
Paul

2009/2/26 Rich Shepard <rsh...@ap...>

>   When I prepare an Accounts Payable transaction it's apparently entered
> both in A/P and Current Liabilities. The latter is the default under the
> specific expense account widget. It's been so long that I have forgotten
> where to change that default to A/P so it's cleared when paid, and not
> accumulated as a current liability.
>
> TIA,
>
> 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
>
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco,
> CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source code:
> SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Reminder Needed: Changing Linking Account

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

On Thu, 26 Feb 2009, Paul Tammes wrote:

> How do you enter payments? If via a suspense account, there might be some
> set offs not automaticaly going trough. Let me explain:

Paul

   Via the A/P menu's 'enter transaction' item.

> I use a ledger for A/P (#1600) when entering invoices. When paid from the
> bank I debit A/P invoices paid suspense account (#1605). Then the A/P dept
> can apply the amounts in #1605 to settle the paid invoices. Quicker on bank
> account entry, leaving A/P dept with the hassle. But then, they now the
> suppliers better than I do ;-)

   In my system Current Liabilities is a/c #2100 and A/P is #2110. When an
invoice comes in I enter an A/P transaction. When I pay them via the Cash ->
Payments page, and post after checking successful printing, I don't expect
to see them in the 2110 account any longer. But, they're still there. And, I
see them in 2100, the Current Liabilities account.

> What I mean to say is, there might very well be some payments not
> allocated to the A/P (sub) ledger, which will result in a huge total on
> A/P. Search for your equivalent of #1605!

   I have no such suspense account.

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] Reminder Needed: Changing Linking Account

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

Looks wrong to me. Two basic checks:

1) Are you sure 2100 is not a totals or subtotals account? If so, including
the 2110 account would explain the 'double entry / double showup.

I remeber I had some troubles in my scheme and removed all sunbtotal
acounts. That fixed it for me.

2) You menu entry via A/P does not make sense to me. What happens to the
PHYSICAL money you pay the A/P invoces with ,and how is that entered in the
system?

If all else fails, send me your scheme or a backup and I can do some remote
checks and fiddling to see what is happeniong.

2009/2/26 Rich Shepard <rsh...@ap...>

> On Thu, 26 Feb 2009, Paul Tammes wrote:
>
> > How do you enter payments? If via a suspense account, there might be some
> > set offs not automaticaly going trough. Let me explain:
>
> Paul
>
>   Via the A/P menu's 'enter transaction' item.
>
> > I use a ledger for A/P (#1600) when entering invoices. When paid from the
> > bank I debit A/P invoices paid suspense account (#1605). Then the A/P
> dept
> > can apply the amounts in #1605 to settle the paid invoices. Quicker on
> bank
> > account entry, leaving A/P dept with the hassle. But then, they now the
> > suppliers better than I do ;-)
>
>    In my system Current Liabilities is a/c #2100 and A/P is #2110. When an
> invoice comes in I enter an A/P transaction. When I pay them via the Cash
> ->
> Payments page, and post after checking successful printing, I don't expect
> to see them in the 2110 account any longer. But, they're still there. And,
> I
> see them in 2100, the Current Liabilities account.
>
> > What I mean to say is, there might very well be some payments not
> > allocated to the A/P (sub) ledger, which will result in a huge total on
> > A/P. Search for your equivalent of #1605!
>
>    I have no such suspense account.
>
> 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
>
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco,
> CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source code:
> SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>