Search
Generic filters
Exact matches only
Search in title
Search in content
< Back

Calling all CFOs and Controllers.  How are you preparing your Cash Flow Statement these days?  Using Excel no doubt, because this “orphan” statement is not part of the group of default financial statements that come with the Sage 300 CRE software.

Well, I have news for you!  There is a Cash Flow Statement report design that is sitting in Sage’s Knowledgebase just waiting for you to download and use.  But first, some backstory.

As you might recall, when you were setting up your company’s data folder, one of the last tasks performed was to create your financial statements in the Financial Statement Designer (FS) module.  This was accomplished with a few simple keystrokes:

After FS opened, clicking in the menu on File>Create generated 4 default financial statement files [1]:

  • FSD (Balance Sheet)
  • FSD (Income Statement)
  • FSD (Trial Balance)
  • FSD (MonthlyComparison – Income Statement accounts)

Alas, no Cash Flow statement.  So you either created one in Excel, which involved setting up the columns and rows, and depending upon your personal Excel expertise, data key stroking the results after off-line mathematical calculations or by writing subtraction formulae for each value.  Either way, redundancy!  Or, you forwarded your Balance Sheet and Income Statement to your CPAs and let them crunch the numbers!

Follow these steps to get a copy of the Sage 300 CRE Cash Flow Statements:

  1. On your Sage 300 CRE Desktop, click on the Help menu and select Sage Online.
  2. Navigate to the Knowledgebase link and after selecting your Sage 300 CRE version, type in Statement of Cash Flow (or 23834, which is the Knowledgebase article number that will bring you directly to the topic).
  3. Open the article and you will notice a link (zip file) at the bottom.

[1] This assumes that the Account method selected in: Common Tasks>File>Company Settings>General was “accrual”.  Otherwise you would see these four reports with the word “Cash” replacing “Accr” in the file name, or all 8 reports if you setup your accounting system as “both” (accrual and cash).

  1. Download the file you need, and as per the instructions, using File Tools>Restore to place these reports in your copy of the Timberline Construction Sample Data folder so you can see how it works.  These report designs should appear the next time you launch FS>File>Open.
  2. Copy the file to your Live Data folder and use the Financial Statement Designer to edit accordingly.

One final step.  Review all of your GL account setups for Balance Sheet accounts only.  Make sure you have checked the box:  “Store Debit Activity”.

Certain cash flow statement calculations may require debit information only.  Having this checkbox activated enables you to capture this amount without having to do additional off-line computations.

Now you have the Cash Flow Statement for inclusion in your financial reporting package with much less time and effort incurred to complete.  Alive and well – and no longer an orphan!

Should you need any further assistance managing your company’s control accounts, please call your United Solutions, Inc. Sage certified consultant.

[1] This assumes that the Account method selected in: Common Tasks>File>Company Settings>General was “accrual”.  Otherwise you would see these four reports with the word “Cash” replacing “Accr” in the file name, or all 8 reports if you setup your accounting system as “both” (accrual and cash).

Want Exclusive Sage Tips?
Join Our eNewsletter
Get Sage promotions, events and updates delivered straight to your inbox!
Subscribe
Give it a try, you can unsubscribe anytime.
close-link
X