Welcome to Luca!globe
 The CPA Journal Online Current Issue!    Navigation Tips!
Main Menu
CPA Journal
FAE
Professional Libary
Professional Forums
Member Services
Marketplace
Committees
Chapters
     Search
     Software
     Personal
     Help
Dec 1990

Review: Up Your Cash Flow. (Up Your Cash Flow 2.0) (Software Review) (evaluation)

by Warner, Paul D.

    Abstract- Up Your Cash Flow 2.0 is an easy-to-use spreadsheet software package designed to help accountants prepare a cash flow analysis. The items on the main menu include beginning balances, cost of goods sold, a payroll spreadsheet, a term loan amortization spreadsheet, and interest expense-credit lines. The features of the program include the ability to mix fixed and variable costs, and the ability to display income and expenses by month.

The package comes on one diskette and two cards that contain all the instructions that you need. One card explains how to install the system on a hard disk and contains the general operating instructions. The second card contains "Tips For Best Results." Also included is the 174- page book "Up your Cash Flow," by Harvey A. Godstein, CPA.

The program is almost completely menu-driven and each menu item is accompanied by an on-screen explanation. The following is the main menu: The only exception is when saving data for multiple years or individual clients, when specific instructions are provided, and all the user really has to know is how to use the DOS Copy command. The following is the main menu:

MultipleEntitiesandConsolidations

Name,Month,TypeofEntity,Year

BeginningBalances

Sales

SalesByProductSpreadsheet

MiscellaneousIncome

CostofGoodsSold

CostOfGoodsSoldByProductSpreadsheet

Expense

Payroll

PayrollSpreadsheet

PayrollTaxExpense

Depreciation

InterestExpenses/TermLoans

TermLoanAmortizationSpreadsheet

InterestExpense/CreditLines

EffectOfBeginningPayablesOnForecast

OtherCashPayments

OtherCashReceipts

ViewP&LCashFlowandBalanceSheets

Cleanup

Printing

CopyData(to)(from)aDiskette

NextYearForecast

ReviewofAssumptionsUsedinForecast

ExportForecasttoASCIIFile

Some of Up Your Cash Flow's features include:

* Ability to have up to 59 branches or subsidiaries;

* The mixing of fixed and variable costs;

* Miscellaneous income and expenses by month;

* Ability to edit most account names (e.g., change name of Sales to Revenue);

* Up to 12 monthly balance sheets

* Payrolls by individual employee. Payroll may be hourly center number of hours and hourly rate).

The following is a sampling from the instruction manual for various functions; from these you can see how easy Up Your Cash Flow is to use:

Sales

a) To speed the forecasting process, have the last 12 months' sales by month and the last 12 months' sales collections by month available. This information is called for but is not necessary. The use of this information is up to the user.

b) What If Analysis"--When sales are edited or changed, all forecasts will automatically be updated.

c) The user must use sales forecast, menu option 3, for changing units of production if the user is forecasting cost of goods sold by product.

d) Professional firms; to forecast sales by staff person, use option 3. Where the program calls for "product number," use employee number; where the program calls for "product name," enter the employee name. Complete the balance of the program. This will allow the user to budget sales revenue by employee.

e) Forecasting sales by salesperson selling a single product. Use sales option 3: sales by product. Under product number, enter the salesperson's employee number. In the product name, enter the Sales person's name. You can enter as many sales people as you like. Complete the balance of the program. After completion, print the sales by product spreadsheet. This is the sales forecast by salesperson report.

f) Forecasting sales by salesperson selling a single product. Use sales option 3: sales by product. Under product number, enter the salesperson's employee number. In the product name, enter the salesperson's name. You can enter as many salespeople as you like. Complete the balance of the program. After completion, print the sales by product spreadsheet. This is the sales forecast by salesperson report.

g) Forecasting sales by salesperson selling several products. Use sales option 3.

h) You can use the procedure above for each product sold by the salesperson or determine the approximate annual sales by salesperson in dollars. Divide the annual sales by 100. (For example: a salesperson will sell approximately $1,200,000 for the year. $1,200,000/100=$12,000.)

i) Use sales option 3: In the product number, enter the salesperson's employee number. In the product name, enter the salesperson's name. In the sales price, enter the result of the sales divided by 100. Then enter in each month under units the percent of the total sales the salesperson will make in each month. For example: the salesperson will make 10% of his/her sales in January and 5% in February. Enter 10 in January and 5 in February.) Complete the balance of the year. Remember the total of the units should equal 10. Print the sales by product spreadsheet. This will be your sales budget by salesperson.

j) All names, numbers and units sold entered in sales option 3, will appear in cost of goods sold option 3. However, it is not necessary to forecast cost of goods sold by product. The user can use any of the options available under the cost of goods sold program.

Cost of Goods Sold

a) For your cash flow forecast, the program will automatically compute purchases and apply payment assumptions to the purchases.

b) If the user is determining cost of goods sold by product, or any unit of production, the number of units must be entered or edited in the sales forecast menu, option 3. This will also update cost of goods sold.

c) When forecasting sales by product it is not necessary to forecast cost of goods sold by product. The user can use any of the options available in this program.

Payroll

a) For forecasting purposes, it is assumed that payroll will be paid 100% in the month incurred.

b) if the user changes or edits the payroll menu, information in the payroll tax expense menu must be reentered to update payroll taxes.

Expenses

a) There are 27 preprogrammed expense items and 31 "user defined" expenses making a total of 58 expense categories.

b) All pre-programmed expense titles can be changed at the user's option to create any description the user feels appropriate. Other Cash Payments

a) Equipment loans entered here will automatically be entered in the system. It is not necessary to enter them in any other menu. However, they should be amortized using the term loan amortization menu.



The CPA Journal is broadly recognized as an outstanding, technical-refereed publication aimed at public practitioners, management, educators, and other accounting professionals. It is edited by CPAs for CPAs. Our goal is to provide CPAs and other accounting professionals with the information and news to enable them to be successful accountants, managers, and executives in today's practice environments.

©2009 The New York State Society of CPAs. Legal Notices

Visit the new cpajournal.com.