Cashflow Statement - A/P operating vs investing activities

Hello,

I am trying to produce a reliable and accurate cashflow statement in Sage 50 Quantum Accounting Canada. 

To me, a cashflow statement should start with net income, then take into account cashflow adjustments from operating activities, investing activities and financing activities.

A large part of the cash adjustments from operating activities is the fluctuation in accounts receivables and accounts payables. I am lucky to work in a business with little to no receivables, so my question pertains to payables, particularly payables that don't affect the income statement.

For example, if I buy furniture on credit, this will not hit my income statement, it will only hit my balance sheet.

Dr. F&F

Cr. A/P

However, when I look at my A/P fluctuation in my cashflow statement, I see this transaction included in the fluctuation. To me, I would think this should not affect my cashflow statement because I am starting with my net income and the transaction above does not affect the income statement, so it should not be included in my C/F statement. (I am ignoring depreciation/amortization in this example).

I also realize this should be in investing activities and not operating activities (it's currently appearing in operating activities).

Perhaps I am missing something, or maybe I haven't set up the accounts correctly in my chart of accounts. Can someone help me out?

  • On your Chart of Accounts ledger, please check the Class Options tab and make sure the Capital Asset accounts have a class of Capital Asset.

  • 0

    I haven't looked at Sage's cash flow statement, so I apologize if I'm saying something you've already thought of.  Just thought it might be useful to remind you that the usual way to build a cash flow statement is, as you stay, to start with the net income and then adjust for (a) fluctuations in working capital (A/R up = cash down, A/P up = cash up), and (b) fluctuations in other balance sheet items (investing activities, etc.).

    This simplifies things, as you don't have to analyze your A/P fluctuation to figure out if it's an income-related fluctuation or a balance-sheet related fluctuation.

    So, for example, if you have net income of $100, your A/P decreased by $300 since last year, and you bought furniture for $50, your cash flow will be $100 from operations minus $300 for paying off A/P minus $50 for buying furniture = $250 decrease.  It doesn't matter if part of that A/P is for the furniture.

  • 0 in reply to C White

    Thanks for your answer. I'm trying to set it up on a monthly basis, but it's the same concept that you described above. I'm just having difficulty wrapping my head around the A/P for capital assets. does this make sense below?

    For example, if the only thing I did in the month is buy a piece of furniture on credit, I would book it was Dr. Furniture Cr. A/P. My net income would be 0, because my journal entry only hit the balance sheet. My A/P went up $50 so +50 in cashflow from operating activities and then I bought furniture so -50 in cashflow from investing activities. My net Cashflow adjustments = 0 which makes sense because there was no cash going out during the month. In theory, when I pay off the A/P, my A/P will decrease by $50, so -50 in cashflow from operating activities. Nothing should happen to my cashflow from Investing activities, correct?

  • 0 in reply to Michael Leblanc

    Sounds like you've got the idea.