From: Chris J. <vac...@ya...> - 2007-04-06 19:36:47
|
Hi all, I am working on closing out 2005 (still!). After a long time looking at the books and reports, talking with the accountant etc, I am suspecting the Accounts Receivable as having to do with my problem, so I wanted to see if anyone could shed some light on this issue. My accounting is on a cash basis, and I am generating the balance sheet [1] and seeing a line for AR in assets. When I generate the trial balance, I see an amount for AR that is different (larger) than what showed on the balance sheet. I also tried to compare this to what I get if I do a report on open AR transactions - and I get yet another number for outstanding AR! Any idea why these would be different? The other thing I am suspecting has to do with the current earnings vs net income. I performed a "year end" process at 12-31-2005. However, my current earnings (Balance Sheet) and net income (Income Statement) still do not match. I thought this process was supposed to bring these two into line. Any suggestions on bringing them into balance? Thanks in advance for your help in setting this issue. Regards, Chris [1] Why is AR shown on the balance sheet for cash accounting? --------------------------------- Preguntá. Respondé. Descubrí. Todo lo que querías saber, y lo que ni imaginabas, está en Yahoo! Respuestas (Beta). Probalo ya! |
From: Paul T. <pt...@wa...> - 2007-04-07 00:58:18
|
> Regards, > Chris > > [1] Why is AR shown on the balance sheet for cash accounting? > > > Chris, this is the crucial question I think. Answer: All accounts with a non-zero amount are shown, because they have an influence on the figures. As I see it, or should I say in my experience with SQL-Ledger, it works like this: The CASH sales (cash register) are invoiced to and sold to ONE virtual customer, named CASH SALES. We do not enter names, adresses and what not for cash sales, we just record them, close the bill and re-use for the next cash customer. So, when the customer pays, the existing bill is closed and the cash amount in the cash-drawer goes up with the same amount. At the end of the day, you count the cash, maybe take some overfluous money to the bank, and close and reconcile the Cash-register. The effects you mention suggest to me that you may not have recorded the cash receipts for one or more cash transactions. Leaving the AR customer CASH SALES with an outstanding amount. This, as you mentioned yourself, is not logic, nor is it correct. Cash customers have a zero credit limit. And because we do not record adresses and whatnot, there is no money to be collected from return to sender, adress unknown. So either you forgot to record the receipt, or (worse) you did not receive the money. In both cases you should have had a cash difference at the end of the day during the daily cash count and reconciliation. Hth, Paul |
From: Arthur D. <ar...@av...> - 2007-04-07 00:40:18
|
Where are these number coming from in AR? AR and AP aren't used on a cash basis. I don't know a lot about SL but just from an accounting standpoint, that's weird. Arthur On Fri, 2007-04-06 at 16:36 -0300, Chris Johnson wrote: > Hi all, > > I am working on closing out 2005 (still!). After a long time looking at the books and reports, talking with the accountant etc, I am suspecting the Accounts Receivable as having to do with my problem, so I wanted to see if anyone could shed some light on this issue. > > My accounting is on a cash basis, and I am generating the balance sheet [1] and seeing a line for AR in assets. When I generate the trial balance, I see an amount for AR that is different (larger) than what showed on the balance sheet. I also tried to compare this to what I get if I do a report on open AR transactions - and I get yet another number for outstanding AR! Any idea why these would be different? > > The other thing I am suspecting has to do with the current earnings vs net income. I performed a "year end" process at 12-31-2005. However, my current earnings (Balance Sheet) and net income (Income Statement) still do not match. I thought this process was supposed to bring these two into line. Any suggestions on bringing them into balance? > > Thanks in advance for your help in setting this issue. > > Regards, > Chris > > [1] Why is AR shown on the balance sheet for cash accounting? > > > --------------------------------- > Preguntá. Respondé. Descubrí. > Todo lo que querías saber, y lo que ni imaginabas, > está en Yahoo! Respuestas (Beta). > Probalo ya! > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
From: <ma...@hu...> - 2007-04-09 12:02:20
|
> My accounting is on a cash basis, and I am generating the balance sheet > [1] and seeing a line for AR in assets. I have seen this too, and have not yet been able to figure it out. One potential cause (I believe) is if you have invoices that are dated in 2005 but were paid in 2006. As I understand it, the invoice date and cash payment must be in the same year for cash-basis reports to work as you would expect them to. But even when I went through all open 2005 invoices and changed their dates to 1/1/2006 and closed the year, I still saw a non-zero A/R balance for 2005. It was pretty small, so I didn't bother to track it down, but it's on my todo list. I think it is an artifact of some combination of transaction dates. HTH, m |