PT 2000 key code? Call 1-800-999-9209.   Advertise here

Peachtree and Sage 50 Forums      

Go Back   Peachtree and Sage 50 Forums > Peachtree and Sage 50 software > Peachtree / Sage 50 Accounting forum

Reply
 
Thread Tools Display Modes
  #1  
Old 04-21-2007, 08:42 PM
frankpeters frankpeters is offline
Registered User
 
Join Date: Apr 2007
Location: Detroit, Michigan
Posts: 6
Error In Cash Flow Statement

Peachtree seems to provide an erroneous Cash Flow Statement when
dealing with the gain or loss on the sale of an asset. (I am using
Peachtree Complete 2005.)

Let me give an example. Suppose that only one transaction occurs in a
given monthly period, namely the sale of an asset at a loss. A fixed asset
that originally cost 18000.00 has been depreciated by 12450.00 and is
disposed of for 5000.00. This results in a loss on sale of 550.00. The
journal entry for this would be as follows:

Debit

Cash 5000.00
Accumulated Depreciation 12450.00
Loss on Sale of Asset 550.00

Credit

Fixed Asset 18000.00


Because there is a decrease in a fixed asset account, the investment
section of the Cash Flow Statement should indicate this change as a
positive change in cash.

Also, according to the accepted rules of cash flow statements, the
loss on the sale, which is an expense, should be added back to the
net income for the period.

Neither of these happens with the Peachtree Cash Flow Report.

Unfortunately, the Peachtree manual does not elaborate on just how
the Cash Flow Statement is prepared in this or any other situation.

Using "ordinary" journal entries, however, the Cash Flow Statement does
give a proper and accurate report for a given period. I have only noticed
this anomaly with the situation of gain or loss on the sale of assets.

Does anyone have any thoughts on this matter?

Frank Peters
Reply With Quote
  #2  
Old 04-22-2007, 07:15 AM
BaltoCPA BaltoCPA is offline
Registered User
 
Join Date: Nov 2006
Location: Baltimore
Posts: 20
True, the loss should be added back as an adjustment to net income for the period. The proceeds from the sale should be shown under Investments. However, I know of no other accounting software that includes a standard Cash Flow (or Statement of Changes) that can display this correctly; itís usually prepared outside of the accounting software.

You can understand the problem, right? The proceeds form the disposition would have to be captured separately which is not practical within the accounting software since that would create problems in the cash account and reconciliation.
Reply With Quote
  #3  
Old 04-22-2007, 08:46 AM
frankpeters frankpeters is offline
Registered User
 
Join Date: Apr 2007
Location: Detroit, Michigan
Posts: 6
The user documentation for Peachtree should at least make some mention
of this difficulty.

Peachtree can export balance sheet data directly to an Excel spreadsheet
and this should facilitate the creation of a manual cash flow statement,
as you indicate, for any period in which such a transaction does occur.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 07:57 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
all contents copyright (c) by AccountingUsers Inc.