Navigator User Forums
  Income Statements and Cash Flow Reports
  LOC & Brokerage transfers do not show up on Cash Flow Report

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   LOC & Brokerage transfers do not show up on Cash Flow Report
Gina
Member
posted 03-14-2008 01:25 PM     Click Here to See the Profile for Gina     Edit/Delete Message
When I run the 12 month cash flow report some of the accounts do not show up in the sources of cash - specifically the LOC and the transfers from the margin accounts - they are designated as bank credit line and brokerage cash accounts - I tried changing them to "bank accounts" but that did not make them show up. The margin accounts show up on the bottom of the report as bank accounts - but do not show up as a source of cash. Help! Thanks,
Gina

IP: Logged

David
Administrator
posted 03-17-2008 10:37 AM     Click Here to See the Profile for David     Edit/Delete Message
Sources of cash on Cash flow report are things like dividends, sold investments, and other income-producing activities. Transfers between cash accounts aren't income. So taking money from checking and putting it into a margin account set up as a broker cash account won't show up. These transactions will be reflected in the balances in the Bank Accounts section at the end of the Cash Flow report. Since one balance will increase and the other decrease by the same amount, the Total-Bank Accounts won't change.

Note the relations between these fields on the report:

Total Sources of Cash - Total Uses of Cash = Net Cash Flow
Beginning Balance + Net Cash Flow = Ending Balance (of cash accounts)
Ending Balance = Total Bank Accounts (i.e. total cash)

Note the sample report you faxed has Changes in Account Balances at the end. Run the same report only without Qualifiers. If it still has Changes in Account Balances . run Test & Correct Balances.

- David
FNI Technical Support
Case #38-10620

[This message has been edited by David (edited 03-18-2008).]

IP: Logged

FN_User
Member
posted 03-28-2008 01:24 PM     Click Here to See the Profile for FN_User     Edit/Delete Message
Hi David – thanks for the response. I still have two Bank LOC accounts that do not show up as sources of income – and there was activity in 2007. Their accounts are labeled as “Bank Credit Lines”. One LOC account does show up – any words of wisdom? Thanks.

IP: Logged

David
Administrator
posted 03-28-2008 01:33 PM     Click Here to See the Profile for David     Edit/Delete Message
There are two possible answers:

1) A line of credit is not really a source of income. It may be a place you dip into to get cash, but that's not real income. So the report is correct.

2) In your situation, the lines of credit perhaps should be considered as income. If that is the case, tell Navigator not to treat them as cash or a bank account. I"m not sure how to catagorize them, but as a test, temporarily change the format type to accounts payable and move them to Buisness Liabilities | Accounts Payable. Let me know if that moves them to the right spot on your report.

- David
FNI Technical Support

IP: Logged

All times are PT (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | Home

Copyright 2010 Financial Navigator, Inc.


Ultimate Bulletin Board 5.47e