[SL] Re: SL: Cash Reconcilation showing past reconciled items - Probable resolution

[<je...@ix...>]

What is the difference between the European and North American methodology?
Is there one?

I have been using SQL since the middle of 2003. My company started business
in late 2002, and I needed to do the reconciliations on the past statements
(as it had never been done), and I have done every reconciliation since,
and every one has precisely matched my bank statements. I have done
reconciliations at other companies, I have used Platnium, Quickbooks and
Great Plains, and to me the concept is all the same, everything that isn't
reconciled yet, shows up, once its reconciled its gone. My experience with
this goes as far back as 1998. I think my main error in SQL has been that I
was able to reconcile without putting in date ranges, and until we upgraded
to 2.8, it has never been an issue. 



After a quick email exchange with Dieter, I think, if I do my next
reconciliation and I put in the beginning and ending date ranges from the
bank statement, and I ignore the fact that some past reconciled items will
show up. I believe that on the reconciliation after one, all the past items
will be properly reconciled, will not longer show up, and I will not have
any issues going forward.


I however did a work around on this round of reconciliations, I put in a
start date equal to the current date, and that prevented Feb and Mar 2009
reconciled items from showing up. However, I will have to start doing
reconciliations properly or this issue will show up every time.



Jeff

Jeff Kaminsky
General Accounting Manager
IX Systems





On Fri, 15 May 2009 19:35:20 +0200, Paul Tammes <pt...@wa...> wrote:
> The whole concept of Bank Statements seems European to me, US citizens
use
> checks and reconciliation instead iirc.
> I think the concept that reconciliation should match the bank statements
> like Dieter mentioned is solid and was long overdue.
> 
> However, it might take some thinking and reconsidering to get the basic
> idea
> across to people who are not used to check statements and live with
> messages
> like ´the check is in the mail´. That way of accounting was part of the
> start of the worldwide mess we have right now to begin with. If the check
> is
> mentioned in the statement, it is in. And can be reconciled with the
> statement number and invoice number as unique identifier. If not, we
might
> have a bad debt (or mortgage) on our hands.
> 
> 
> 2009/5/15 Dieter Simader <dsi...@sq...>
> 
>> On Fri, 15 May 2009, Hamish Bain wrote:
>>
>> > On Fri, 15 May 2009, Dieter Simader wrote:
>> >> Before applying a patch users should investigate why these
> transactions
>> >> show up. If it is a bug it will be fixed but if it is simply a user
>> error,
>> >> well, then fix up your own f'up.
>> >
>> > It would be interesting to know why you didn't reply to me on your
> Forum,
>> as
>> > a 'paid-up' member of SQL-Ledger since I started using it 3-4 years
> ago,
>> and
>> > tell me I screwed up, and to fix my own f'up.  Or else at least make
> some
>> > attempt to see if it might be a bug?
>>
>> Why should I hunt for a bug, just because you don't get it?
>>
>> I replied to your request with a detailed explaination of what you have
> to
>> do. What more do you need?
>>
>>
>>
>
------------------------------------------------------------------------------
>> Crystal Reports - New Free Runtime and 30 Day Trial
>> Check out the new simplified licensing option that enables
>> unlimited royalty-free distribution of the report engine
>> for externally facing server and web deployment.
>> http://p.sf.net/sfu/businessobjects
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>
------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables 
> unlimited royalty-free distribution of the report engine 
> for externally facing server and web deployment. 
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users