Menu
▾
▴
Re: [SL] How can I affect Current Earnings without Changing my netincome?
|
From: <sql...@li...> - 2009-07-11 05:26:21
|
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 > |
