Re: [SL] AR balance sheet vs trial balance vs outstanding

[Michael H. <mh...@it...>]

The only report we're trusting to have accurate numbers is the detail =20=

report.  That said, keep in mind that if an invoice is generated in =20
one period and paid in the next it won't, and shouldn't, show up.  =20
FYI - There is also a bug where a changed tax rate can make invoices =20
disappear completely from the aggregate reports (another reason to =20
stick with the detail reports and just use a spreadsheet).


Thanks,

Michael



On Apr 17, 2007, at 12:04 PM, Chris Johnson wrote:

> Thanks to Mark, Arthur, and Paul for responses. I haven't been able =20=

> to resolve this, byt wanted to follow up to let you know what I =20
> found in following your clues.
>
> I ended up having to fudge it for tax payments today...the =20
> accountant for last 2 yrs has actually taken our trial balance =20
> numbers and then entered those into quick books to generate the =20
> reports (since they can't make sense of what sqlledger is saying - =20
> and I can't either).
>
> Mark, your clue re receipt and invoice happening in different years =20=

> definitely seemed promising. I took out my yearend entry and =20
> updated the invoices, then ran the yearends again. The AR still =20
> shows in the balance sheet (!), though slightly smaller (2005 was =20
> about half, 2006 was only slightly smaller). Seems like same =20
> experience you had - did you have any other clues about where date =20
> problems might be coming from?
>
> Anyone else figure this out?
>
> Paul - we actually do give our clients credit (ie generate invoice =20
> then wait for payment). Sometimes invoices do stay on the books =20
> without a payment.
> But there is always a credit between when we make the invoice and =20
> receive the payment (most of the time we don't start working till =20
> receipt).
>
> Arthur - I agree that in either case, they shouldn't show on the =20
> balance sheet of a cash basis report (as per accounting; SQLLedger =20
> seems to be different!).
>
> I welcome any more ideas you all have.
>
> Thanks,
> Chris
> --
> ifPeople - Innovation for People
> www.ifpeople.net
>
>
>
> ---------------------------------
>  Pregunt=E1. Respond=E9. Descubr=ED.
>  Todo lo que quer=EDas saber, y lo que ni imaginabas,
> est=E1 en Yahoo! Respuestas (Beta).
>  Probalo ya!
> ----------------------------------------------------------------------=20=

> ---
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users