I just looked at prior periods balances, I am so disappointed now. Thanks Rolf that was it, I ran end of year reports but I failed to close the books. I thought I had them locked. That was the problem.

Jeff



On 10/18/2011 10:56, Rolf Stöckli wrote:
Am 18.10.2011 18:12, schrieb Jeff Kaminsky:
1. My yearend matches. I have a mismatch on the first day of the new
year (I close quarterly, so 07-01-2011 is the date of my mismatch, I can
not close out 09-30-2011 because of the mismatch)

You probably have deleted an invoice in the previous period. If you have closed the previous period, the balance on 06-30 should be 0 and I bet it isn't.

2. I ran from 07-01-2011 til to today, the mismatch is still there.

If you have a mismatch on the first day, it will never disappear.

3. Armaghan,
We are using SQL-Ldgr 2.8.23, is LedgerDoctor or something simliar
available for a non Ledger123 accounting system?

You could at least upgrade to 2.8.35. ;)

BTW I found that collecting california sales tax, and changing the rate
and reposting the invoice that had it, will cause a mismatch in the two
reports, but... from as much as I tried to tinker, its a very small
amount (maybe 120 dollars) and I'm trying to understand being off by
12,000 dollars.

If you change the tax rate of already posted invoices, you'll always have troubles, because the amount posted in GL is not the amount you see on the screen when you open the invoice. And if you change the rate, always add a last date to the previous rate and add the new rate on a new line.

Regards
Rolf
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger


--
Jeff Kaminsky
Sr. Accountant / Logistics
IX Systems
408-943-4100 ext 122
408-943-4101 fax

_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger

Reply via email to