97 and Up Episode 16 – Reports – QuickBooks Online vs Xero

[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_blurb admin_label=”Patreon Blurb” title=”Want the key to access this video?” url=”https://www.patreon.com/nerdenterprises” url_new_window=”on” use_icon=”on” font_icon=”%%95%%” icon_color=”#edf000″ use_circle=”on” circle_color=”#e00b00″ use_circle_border=”off” circle_border_color=”#1a6b00″ icon_placement=”top” animation=”off” background_layout=”light” text_orientation=”center” use_icon_font_size=”off” use_border_color=”off” border_color=”#ffffff” border_style=”solid” background_color=”#f4f4f4″ saved_tabs=”all”]

Click the key to sign up and gain access to the rest of our 97 & Up videos, and the course –

Accounting and Bookkeeping Cloud Practice Management – The Self Study Course

View the outline here:

Accounting and Bookkeeping Cloud Practice Management

[/et_pb_blurb][et_pb_text admin_label=”Description” background_layout=”light” text_orientation=”left” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] [/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]

Xero Releases Statement of Cash Flows

The Statement of Cash Flows is a critically important financial report. Many accounting and bookkeeping professionals overlook, or ignore this statement. I suspect, it’s because they really don’t understand it, or they don’t appreciate the importance of what it tells us, or they don’t know how to explain it well to their clients.

This went out to Patrons last week. Want to get the content first, and have access to exclusive content? Sign up on Patreon.

I’ll be honest, I was very excited when I saw this critically important financial report  had been added, until I took a closer look.

Xero is using the “Direct Method.” Most of us in accounting and finance are accustomed to seeing the Statement of Cash Flows using the indirect method. In my opinion, the indirect method provides much more useful information.

If our goal, as accounting and bookkeeping professionals is to become the more strategic advisor, then I need better information. The Indirect Method of preparing the Statement of Cash Flows gives me that.

A Statement of cash flows prepared in the indirect method should reconcile accrual basis net income to your cash balance at the end of a specified period. See my video on Understanding the Statement of Cash Flows in QuickBooks. This provides valuable insights into how the company is surviving. Are we able to function off of our operating profits, or are we funneling money into the business with loans and investments to keep afloat? A business can only survive so long this way. Eventually the investments and loans must prove to be useful in helping the business turn a profit, so it can survive on it’s own operating profits.

Xero’s Direct Method statement of cash flows takes the concept a little too literally. It just shows cash flows. For example, instead of showing the change in accounts receivable, it shows only payments received from customers. Instead of showing the change in accounts payable, it shows only payments made to suppliers and employees. When I look at this, I feel like I am missing a really important piece of the puzzle. I may have received $25K from customers in the period, but I may also have increased my accounts receivable by $100K. This information helps me see what I can expect about the future cash flows. The direct method of preparing the Statement of Cash Flows leaves out this important piece of the puzzle. As my clients most trusted, strategic advisor this means I need to do extra analysis to give my client what they need.

If you google Statement of Cash Flows, you will find a number of examples of what the statement of cash flows should look like, and then you will begin to see the difference from what Xero has provided. Search the Direct Method, and then search the indirect method.

Here you’ll find a series of posts on my old blog, that walk you through the Statement Of Cash flows, and the other financial statements. This will go a long way to helping you understand how to analyze them. Then you’ll see why I am hoping Xero will add a choice to run the Statement of Cash Flows on the Indirect Method:

Nerd’s Cash Flow Projections Archive

Simply put, the Indirect Method Statement of Cash Flows provides better information.


How to Use Xero’s Reimbursed Expenses Feature

Reimbursed expenses are a common event it business, therefore it is important for your accounting software to have the ability to track reimbursed expenses, and then of course, we need a way to bill them back to our clients. We need the flexibility of being able to bill it back at cost, or mark it up.

This went out to Patrons last week. Want to get the content first, and have access to exclusive content? Sign up on Patreon.

Xero now lets you assign expenses to a customer, for one specific purpose. To get reimbursed on an invoice. There is no reporting for this yet, so if you were thinking you’ll get job costing reports on this, sorry, you won’t.

This is a big step in the right direction, and it’s easy to use, but I did get hung up on one thing with it, and you might encounter this too, so be sure and watch the video to see what I am talking about here.