Business Cash Reporting 2006

Expansion for Asset Register 5.2

Now includes monthly cash budgets and five profit center cash consolidation, plus order reporting.
Plus profit center cash flow consolidation.

ADVANCED FINANCIAL REPORTING & ANALYSIS EXCEL WORKBOOKS

PURPOSE:

Combine daily cash inflows & outflows from separate activity centers

1. Consolidate all activitities month to date.

2. Consolidated all activities each day of the month.

Spreadsheets View

Monthly Cash Budget Spreadsheet

Cash Paid Out Forecast

Cash Flows

Orders Forecast

Setup Spreadsheet

Cash Receipts

Cash Paid Out

Capital & Orders

Report Consolidation Spreadsheet

Daily Consolidation Spreadsheet

Daily Cash Report

Cash Paid Out

Capital, Daily Cash Flows & Orders Received

More Reports Spreadsheet

Excel Requirements

PLEASE MAKE SURE YOU HAVE EXCEL'S TOOLPAK-VBA SWITCHED ON BEFORE YOU START.

Excel Dates Synchronization with your System Clock.

This workbook uses Excels' date and time functions to tell the program the current (today's) date and the current month end period.

As your system clock changes date and month, spreadsheets update values to a new date and month end.

To ensure that date synchronization works properly please check that (a) your system clock (on the tray at the bottom right of your screen)

is set to the correct time and date, and that you have Excel's ToolPak VBA switched on as shown below.

Income and Expense Categories

Create the Categories that match your exact requirements in Set Up, and change these at any time.

To Change the reporting month

Change the starting date in Set Up. This reorganizes the days of the week and daily dates to the new month in all the Reports and Consolidations.

Consolidations

Enter individual cash inwards and outwards into Reports. In the program edition you can edit the label "Report title" to any description.

The Divisional & Daily Consolidations "consolidate" Reports into Report titles and Daily summary totals.

Hide unwanted rows

In the program edition, if there are rows that you don't need, select the row numbers on the left hand side, right click and Hide.

Date formatting

If the dates you see in this demo are out of range and do not display properly, you need to adjust your Long date settings in your Control Panel.

Follow these steps:

Click Start, bottom left hand corner and then Control Panel.

Select Date, Time, Language and Regional Options.

Select change the format of numbers, dates and time.

Select Customize in the first window displayed opposite.

Select the date tab and change the Long date format as shown in the second window.

Testimonials

"Very useful" ... "...Great job" ... "I love your add-ins" ... "I found them so impressive" ... "These Add-Ins are remarkably easy to use" ... "I am so excited about using these tools" ... "I am very impressed" ... "Great add-ins" ... "We found your add-ins very useful" ... "Thank you for providing such useful plug ins for problem solving in Excel. I found them so impressive" ... "We did not have a formal ERP or MRP system in place, these Excel add-in helped me out with material planning." ... "We developed a model for a bank company and your Add-ins for Excel have been very useful." ... "Once again, your optimization software is amazing friendly and very accurate. Congratulations." ... "I am working for a Bank down here (Mexico) who wants to optimize their cycle time. Thanks for your solver add-ins." ... "I am impressed with your forecast add-in" ... "I am amazed by the high functionality and excellent modeling" ... "I am VERY impressed".

System Requirements

Requires: Excel 97 or later. Web data requires Excel 2000 or later and Windows XP/2000/2003 or later.

Purchase Details

Order

This product is supplied as a part of Excel Templates - All Programs Complete Set

  - $299.95  $189.95

More Millennium Software

Business Software Catalog

MS Excel Add-ins, Spreadsheets, Templates

Copyright © Millennium Software All Rights Reserved