sql-ledger-users

[SL] Reconciliation mismatch

[Jeff R. <je...@jr...>]

Hi This may be an odd one but I'll try to explain it the best I can.

I open the reconciliation page and select my bank account and up pop all 
un-reconciled transactions.
I reconcile (by ticking) all the transactions that appear on my statement.
I then usually have a few transactions on my statement that have not 
been entered yet (bank charges, interest etc)
I use "open in a new tab" from the side menu bar to get another tab 
(Firefox) with AP transactions.
I then enter the missing transactions, print and post them and close the 
extra tab which puts me back at my original tab.
The new transactions aren't showing yet so I hit 'update' and the list 
refreshes and now the new transactions are showing.

Here's where the oddity occurs, when the page adds the new transactions 
it doesn't keep the 'tick' marks with the reconciled transactions, they 
go out of sync.

If I add two transactions say one from the 15th of the month and one 
from the 21st, they appear in the list in the correct order but the last 
two transactions in the list are now 'unticked' and the order from the 
15th to the end of the month is out of sequence. It's as if when the 
page is refreshed the data of the 'tick' is not correlated to the 
transaction it is beside.

I just confirmed it on the Edmonton demo, the last transaction is to 
CASH dated 10 May 2007, the second to last transaction was to Smith P 
dated 04 May 2007. I ticked both transactions. Then I opened a new tab 
and entered a new transaction (Fred Company) dated 05 May 2007 (between 
the two) and when I hit 'update' it refreshes but now CASH is on the 
last line and it is unticked while the new transaction is on the second 
to last line and it is ticked! It now looks like Fred Company has been 
reconciled but CASH hasn't.

Any ideas on how to correct this?

Jeff Roberts
JR Electronics

Re: [SL] Reconciliation mismatch

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

The checkmarks are kept track of with an index. If you insert a 
transaction it will mess up things. Before you add a transaction click on 
"Done". When you recall the reconciliation screen the checkmarks will be 
set for the ones you reconciled already.

-- 
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, 11 Apr 2007, Jeff Roberts wrote:

> Hi This may be an odd one but I'll try to explain it the best I can.
>
> I open the reconciliation page and select my bank account and up pop all
> un-reconciled transactions.
> I reconcile (by ticking) all the transactions that appear on my statement.
> I then usually have a few transactions on my statement that have not
> been entered yet (bank charges, interest etc)
> I use "open in a new tab" from the side menu bar to get another tab
> (Firefox) with AP transactions.
> I then enter the missing transactions, print and post them and close the
> extra tab which puts me back at my original tab.
> The new transactions aren't showing yet so I hit 'update' and the list
> refreshes and now the new transactions are showing.
>
> Here's where the oddity occurs, when the page adds the new transactions
> it doesn't keep the 'tick' marks with the reconciled transactions, they
> go out of sync.
>
> If I add two transactions say one from the 15th of the month and one
> from the 21st, they appear in the list in the correct order but the last
> two transactions in the list are now 'unticked' and the order from the
> 15th to the end of the month is out of sequence. It's as if when the
> page is refreshed the data of the 'tick' is not correlated to the
> transaction it is beside.
>
> I just confirmed it on the Edmonton demo, the last transaction is to
> CASH dated 10 May 2007, the second to last transaction was to Smith P
> dated 04 May 2007. I ticked both transactions. Then I opened a new tab
> and entered a new transaction (Fred Company) dated 05 May 2007 (between
> the two) and when I hit 'update' it refreshes but now CASH is on the
> last line and it is unticked while the new transaction is on the second
> to last line and it is ticked! It now looks like Fred Company has been
> reconciled but CASH hasn't.
>
> Any ideas on how to correct this?
>
> Jeff Roberts
> JR Electronics
>
> -------------------------------------------------------------------------
> 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] My 2 cents

[George O. <geo...@ya...>]

After upgrade to 2.8.0 I noticed I have a difference of $0.02 between Debit 
and Credit numbers in my COA. Is this something I should bother investigating 
(like a sign of a bigger problem for example)? It is only 2 cents but I never 
had any balance problems before.


-- 
George
AUSTRALIA
http://www.okstudio.com.au

Re: [SL] Reconciliation mismatch

[Jeff R. <je...@jr...>]

>
> Before you add a transaction click on "Done".
If you try to hit 'Done' without the missing transactions it is out of 
balance and will not let you proceed unless you falsify the 'statement 
balance' to match the ledger balance.

I guess this isn't a big deal as long as it's known that adding a 
transaction 'mid - reconciliation' will screw up the rec index. It 
really had me scratching my head for a while before I discovered what 
had happened.

Jeff Roberts
JR Electronics


Dieter Simader wrote:
> The checkmarks are kept track of with an index. If you insert a 
> transaction it will mess up things. Before you add a transaction click on 
> "Done". When you recall the reconciliation screen the checkmarks will be 
> set for the ones you reconciled already.
>
>   

Re: [SL] Reconciliation mismatch

[Mark L. <mar...@in...>]

Or, just make sure you've entered those miscellaneous transactions  
prior to reconciling

On Apr 11, 2007, at 11:06 PM, Jeff Roberts wrote:

>>
>> Before you add a transaction click on "Done".
> If you try to hit 'Done' without the missing transactions it is out of
> balance and will not let you proceed unless you falsify the 'statement
> balance' to match the ledger balance.
>
> I guess this isn't a big deal as long as it's known that adding a
> transaction 'mid - reconciliation' will screw up the rec index. It
> really had me scratching my head for a while before I discovered what
> had happened.
>
> Jeff Roberts
> JR Electronics
>
>
> Dieter Simader wrote:
>> The checkmarks are kept track of with an index. If you insert a
>> transaction it will mess up things. Before you add a transaction  
>> click on
>> "Done". When you recall the reconciliation screen the checkmarks  
>> will be
>> set for the ones you reconciled already.
>>
>>
>
>
> ---------------------------------------------------------------------- 
> ---
> 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] Reconciliation mismatch

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

On Wed, 11 Apr 2007, Jeff Roberts wrote:

>>
>> Before you add a transaction click on "Done".
> If you try to hit 'Done' without the missing transactions it is out of
> balance and will not let you proceed unless you falsify the 'statement
> balance' to match the ledger balance.

statement balance from bank statement - missing transactions = new 
statement balance.

The new statement balance is not falsifying the statement balance, it is 
simply to make the statement balance to be the statement balance without 
the missing transactions.

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