Menu
▾
▴
Re: [SL] How can I affect Current Earnings without Changing my netincome?
|
From: <sql...@li...> - 2009-07-11 06:31:05
|
Hi Jeff, I've seen (reconciliation?) balances that remain affected by phantom transactions --transactions that were deleted but some aspect of the transaction remains hidden in the system. I'm not sure of the cause, because there were numerous people entering and reconciling data in multiple databases. From what I recall, the problem is associated with transactions that have been at least partially reconciled against one or more of the accounts associated with it prior to the transaction being deleted. Fixing has been arduous: 1. making a backup of the database 2. tracking down and deleting the transaction detail in the database tables that are associated with the error. Identifying the offending transaction can be tricky. I would verify the balance on the account from beginning of the account and note the month (or approximate date) where the balance is not accurately reflecting balance of shown transactions. Then I would examine the transaction detail for every transaction with at least a date in that time frame, looking for inconsistencies with associated transaction dates or transactions that show up in the database but not through the web. Try repairing any problem first by using the web-based UI. If unsuccessful, then you may have found the culprit! If so, carefully go through the various tables noting and removing the fragments of the transaction. Be sure to check the data returned from DELETE criteria (where...) by using a Select before deleting, or you might accidentally remove a portion of a transaction that was previously okay (thereby compounding the problem). 3. verify the balance accurately reflects transactions shown 4. regenerate the removed transaction (if need be) 5. regenerate any year end GL transactions that occurred after the transaction Wouldn't it be nice to have an AUDIT button that identified transaction inconsistencies in the DB? Some day.. cheers, Torben sql...@li... wrote: > I do not think updating can have caused this kind of anomalies in the > accounts. > Been using this package for years and never found anything to that effect. > > Two more ideas: > > 1) if you use reports with headers inbetween (you can see by different > colors and subtotals) in your General Ledger scheme: remove those and rerun > report. That might do the trick, especially since you say that the accounts > are actually balanced. > > 2) If the COGS in the opening balance (when you started using SQL-Ledger) is > not entered correctly, the opening stock will be sold with a sales price of > x, and a COGS of ZERO. > > That might explain te extra income. Hope you did not have to pay tax on > that, since it is not actual income, just a bookkeeping error! > > As a last resort, if you want to you can do a backup to file and personal > mail me the zip. I can then restore over here local and have a look if I can > find anything from the accounting point of view. > > Cheers, > Paul > > 2009/7/11 <sql...@li...> > >> Yes, we have someone with basic book keeping skills. No we have not found >> anything to suggest why it keeps occurring every year for the same amount. >> What we do know is that this amount has been off since 2004 maybe 2003. Its >> an error that occurred many years ago. >> >> 1. Current Earnings is 50k, more than expected. >> 2. We do not suspect fraud. >> 3. We have done several year end closes. 2002 was off my 17k, 2003 was off >> by I think 53k, and its been the same number every year. >> >> I'm not concerned so much why we are off by 53k, we believe its an error >> that was created in the system during one of the version upgrades. I want >> to make Current Earnings match our Income Statement (As in, if I the only >> way to do it, is to manipulate the database, then tell me how, and I'll do >> it) >> >> thoughts on how to fix it? >> >> Jeff >> >> >> >> On Fri, 10 Jul 2009 22:30:10 +0200, sql...@li... >> wrote: >>> Did you have anybody with basic book keeping skils look at your files? >>> Current earnings would be the difference between expenses and income for >>> any >>> given period. Also known as result. >>> >>> Now if my result was off by 50k, personally I would start to wonder what >>> is >>> going on. Basic sanity check: >>> >>> 1) Do you have more or less than expected? >>> 2) If less, would it be possible somebody is doing something with funds >>> that >>> is not entirely the way it should be? (Also known as fraud). >>> >>> 3) Wild guess: did you do any year-end processing at all? If not, all >>> results from day one till now would be seen as current earnings. At year >>> end, it is a good habit to add any profits to the available reserves >>> (equity) and start over for the new year. >>> If we skip that, how is SQL-Ledger to know the period for which we want >> to >>> calculate profit has ended? >>> >>> HtH >>> Paul >>> >>> 2009/7/9 <je...@ix...> >>> >>>> Here's my issue. Our current earnings is off by 54,300.03 its been off >>> by >>>> this number for years. I'd would like to correct it, but I am not seeing >>>> how to affect current earnings without putting my income statement out >>> of >>>> wack. I tried modifying retained earnings and using long term loans as >>> the >>>> offesetting account, but it had zero effect on current earnings. >>>> >>>> Any suggestions? >>>> >>>> Jeff >>>> >>>> >>>> On Tue, 23 Jun 2009 20:32:40 -0400, "J.P. Possenti" <jp...@pi...> >>> wrote: >>>>> Hello I had posted this in the message board on the site about 3 weeks >>>>> ago and no response; not sure if this is more active or not. >>>>> >>>>> So I will ask here: >>>>> >>>>> I have a number of items that when I entered into sql ledger, I picked >>>>> the wrong income account. When going back to editing these items, I do >>>>> not see all of my income accounts even though I know they exist. I >>> know >>>>> this because I see them in the Chart of Accounts and when I add a new >>>>> item I get the full list. >>>>> >>>>> Is this a bug or is it like that for a reason? >>>>> >>>>> I can simply delete and re-add the item with the correct income >>> account >>>>> but I am wondering if this will affect any reports or previous >>> invoices >>>>> I made with that item. I would be keeping everything exactly alike >>>>> except the income account. Would this be ok? >>>>> >>>>> So bug or is it like that for a reason? >>>>> >>>>> >>>>> Thanks >>>>> >>>>> JP >>>>> >>>>> >>>> >> ------------------------------------------------------------------------------ >>>>> _______________________________________________ >>>>> sql-ledger-users mailing list >>>>> sql...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>>> >>>> >>>> >> ------------------------------------------------------------------------------ >>>> Enter the BlackBerry Developer Challenge >>>> This is your chance to win up to $100,000 in prizes! For a limited time, >>>> vendors submitting new applications to BlackBerry App World(TM) will >>> have >>>> the opportunity to enter the BlackBerry Developer Challenge. See full >>> prize >>>> details at: http://p.sf.net/sfu/Challenge >>>> _______________________________________________ >>>> sql-ledger-users mailing list >>>> sql...@li... >>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>>> >> ------------------------------------------------------------------------------ >>> Enter the BlackBerry Developer Challenge >>> This is your chance to win up to $100,000 in prizes! For a limited time, >>> vendors submitting new applications to BlackBerry App World(TM) will have >>> the opportunity to enter the BlackBerry Developer Challenge. See full >>> prize >>> details at: http://p.sf.net/sfu/Challenge >>> _______________________________________________ >>> sql-ledger-users mailing list >>> sql...@li... >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> >> >> ------------------------------------------------------------------------------ >> Enter the BlackBerry Developer Challenge >> This is your chance to win up to $100,000 in prizes! For a limited time, >> vendors submitting new applications to BlackBerry App World(TM) will have >> the opportunity to enter the BlackBerry Developer Challenge. See full prize >> details at: http://p.sf.net/sfu/Challenge >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
