# Management Reporter - Cash Flow

#### Management Reporter - Cash Flow

Hello All

I'm building a Cash Flow statement and ran up against a problem.
Will you take a look at this at let me know what you think?

I get a "Circular row calculation reference detected between row 1450 and row 1450. Report will show zeroes for these rows"
And here is what our row format looks like. It looks exactly like what’s in the Management Reporter Book.

 1330 DES 1360 NET INCREASE (Decrease) In Cash TOT 730+880+1270 1390 DES 1420 NP - Cash at Beginning of Period Account Modifier=[/BB] +Account = [10001:10103] 1450 Cash at Beginning of Period CAL B=B,1420,E=C,1420 1480 --- 1510 DES 1540 Cash and Equivalents at End of Period TOT 1360+1450

All Replies
• That's on version  2.1.1029

• Any one have an answer on this  I too have this same issue

• I think it should read : CalB=B,1420,C=C,1420

C=C or E=E depending on the column

NOT E=C

• Hey Tim,

Here is a sample layout that I have working in a cash flow statement

The row numbers are slightly different but I am sure you'll get the idea:

1200 Increase (Decrease) in Cash CAL @575+@800+@1125

1225                                      DES

1250 NP-Cash at Beginning of Period                                       Account Modifier=[/BB]

1275 Cash at Beginning of Period CAL B=B.1250, E=C.1250

1300                                      DES

1325 Cash at End of Period                   TOT 1200+1275

And the Column layout is:

DESC FD FD FD CALC

ACTUAL ACTUAL ACTUAL

BASE BASE BASE

BASE BASE BASE

PERIODIC YTD/BB YTD

D-C

30 14 14 14 14

NP NP

Please note that you have to make sure that the calculation priority has to be set to Columns first then rows or you will not get the right numbers.

Hope this helps,

Marvin

•

Here are screen shots so they look a little more logical.

• Here is how I have it set up, I do have the priority set to columns first  Column layout equals the one below

Any thoughts

I am on GP2013 could that be an issue?

Thanks Linda

100 DES

130 Net Income from Operations C +Segment1 = [430000:599999]

160 DES

190 Add Back Non-Cash Expenses: DES 220

220  Depreciation & Amortization -Segment1 = [189900:189904]

250 ---

280 Net Cash Flow from Operations TOT 130+220

310 ---

340 DES

370 Sources (Uses) of Cash: DES

400   Accounts Receivable C +Segment1 = [121000:136999]

430   Inventory - Fuel C +Segment1 = [154000:154007]

438   Inventory - Parts C +Segment1 = [150000]

445   Inventory - Other C +Segment1 = [154008:159300]

460   Prepaid Expenses C +Segment1 = [160000] +Segment1 = [169000]

520   Accounts Payable C +Segment1 = [200000:220000]

550   Accrued Benefits C +Segment1 = [223000:223500]

580   Accrued Liabilities C +Segment1 = [223750:223795] +Segment1 = [163000] +Segment1 = [299999]

610   Accrued Tax Liabilities C +Segment1 = [224001:236000]

640 ---

670 Total Sources (Uses) of Cash TOT 400:610

700 ---

730 Net Cash Flow from Operating Activities TOT 280+670

760 ---

790 DES

820 CASH FLOW FROM INVESTING ACTIVITIES: DES 940

850 DES 940

880   Additions to Fixed Assets C +Segment1 = [171000:189007]

910 --- 940

940 TOT 880

970 --- 940

1000 CASH FLOW FROM FINANCING ACTIVITIES: DES 1120

1030 DES 1120

1060 Principal Payments on Notes C +Segment1 = [246000:250010]

1090 --- 1120

1120 TOT 1060

1150 --- 1120

1180 DES

1210 Net Increase (Decrease) in Cash TOT 730+880+1120

1240 DES

1255

1270 Cash at Beginning of Period Account Modifier=[/BB] +Segment1 = [100000:102004]

1300 Cash at Beginning of Period CAL B=B.1270, E=C.1270

1330 ---

1360 DES

1390 Cash and Equivalents at End of Period TOT 1210+1300

1420 ===

1450 DES

1480 NP - Ending Cash Per Books NP +Segment1 = [100000:102004]

1510 Check Total - Ending Cash Per Books CAL B=D.1480, E=C.1480 NP

1540

1570

1600 Calculated Ending Cash Out of Balance with GL TOT 1390-1510

• Here's the Answer that worked for me. Sorry, Didn't realized I never responded to this :-)

From what I can see everything looks correct except for one thing:

On row 1450 you have - B=B,1420,E=C,1420

It should be - B=B.1420,E=C.1420

It appears you have comma's (,) instead of periods (.)

I would give this a try at this point to see if it resolves the issue.