The management of cash flows of the large retail chains - 6 POS -File excel - V.1.01 - Online

The file, in excel format Online, handles up to 11 months of corporate financial planning and is able to simultaneously manage the cash flows up to 6 stores and the entire company of large retailers as a whole.

It works only online.

The price indicated refers to the annual user's license, non-assignable and non-exclusive of the product for 1 user.

More details

192,00 € tax excl.

More info

THE MANAGEMENT OF CASH FLOWS OF THE LARGE RETAIL CHAINS

WITH  6 POINTS OF SALE.

The workbook shown on this page is in Excel format and is a simple and easy tool to use for managing the cash flows of a company of the large-scale distribution. It may be useful to companies that sell retail through a network of supermarkets or hypermarkets, such as in the food sector. But it can be useful also to companies that sell others products for example: technology products, clothing, accessories, and more using a network of outlets or other chains of intermediaries of various kinds.

In the site is showed, in short, a model to be used for the planning of the cash flows of large retail companies that manage up to 6 points of sale, making use of the integration of global financial flows of the company and of those of each store of retail.

The document contains the following worksheets:

1. sheet for links;

1. sheet for instructions;

1. summary sheet of cash flow with the illustration of the handling of the financial statement of the current month and that of the subsequent 11 months;

1. sheet for financial planning of active loans;

1. sheet for the planning of active funds;

1. sheet for the planning of funding by members;

1. sheet for the planning of other financial revenues;

1. sheet for financial planning of investment;

1. sheet for financial planning of passive loans;

1. sheet for the planning of passive funding;

1. sheet for financial planning of leasing contracts;

1. sheet for the financial planning of the current outputs ( Including the outputs for VAT debt of various periods subject to planning)

1. sheet for the financial planning of the other outputs;

1. sheet for the planning of cash flow customers and suppliers (Cash Flow commercial);

6. worksheets, each of which is dedicated to the management of the cash flows particulars of each retail store;

Each sheet manages the data of the previous year (n-1), of the current year (n) and of the current year+1 (n + 1 );

The document contains thousands of formulas and it is complete, dynamic, flexible and easy to use.

The images illustrated below are only indicative and do not represent, in a comprehensive way, the entire functioning of the file.

Image demo 1 (Example of cash flow broken down by store and by type of receipts)

Image demo 2 (Example of summary of the cash flow of a retail store)

The file includes, in addition to the normal financial management of   forecast of the company, also the financial management of forecast of 6 supermarkets or hypermarkets or , however, of  6 retail outlets.

The cash inflows of the various outlets were divided into:

- cash receipts;

- cash receipts with cash machine;

- cash receipts with credit card;

- other cash receipts;

and, for each point of sale, it has been expected an summary management daily and monthly of all cash receipts. These financial flow entries can be renamed by the user.

The file contemplates also the management of financial planning of the purchases.

Image Demo n.3 (Sheet of recapitulation of calculation of cash flow)

The picture shown highlights a summary of cash flows broken down by type, by month, by each bank (supports up to 13 banks), by cash (handles up to 5 ordinary cash accounts and 1 account for checks)

The cash flow from customers and suppliers for the first month is handled manually. 

The financial planning of the second month may be, instead, managed either automatically or manually.

From the third month onwards, the financial planning will only take place automatically.

The spreadsheet manages the financial planning also at the turn of the year.

The initial cash balances of each period of financial management are proposed automatically but can be changed manually by the user.

Of course, changing or inserting new data will result in the modification, at waterfall, of all other related data. 

Image demo n.4 (Summary of the spreadsheet of the other outputs)

This is the picture of one of the 11 reference tables.

The cash outflows provided in the spreadsheet "Other Outputs" are indicated for each monthly period and may be debited from each of the 13 banks indicated in the spreadsheet.

All financial outflows shown in the spreadsheet above indicated will converge, every month, in the cash flow general like represented in the image demo n.1.

This spreadsheet, as well as all other spreadsheets, provides for the management of financial outflows for the current year (n) and for the following year (n + 1).

In another sheet called "Outputs Currents" is exposed, among other things, the dynamic of periodic VAT settlements with evidence of the total debit and of the payment period, taking into account the VAT tax system adopted by the company.

Image demo n.5 (Summary of the spreadsheet of the commercial cash flow)

This is one of the spreadsheets most important for the management of cash flows.

In fact, the proper management of this worksheet will allow the user "Company" obtain, with more precision, an forecast of the receipts and commercial payments of the months following the first one.

The mechanism of the calculation of the commercial cash flow is simple although, apparently, seems complex.

As you can note, the data of the first part of this summary sheet of the commercial cash flows  come automatically by the analytic cash flow of each store. 

Once you set all the necessary parameters, the user will not have to do anything but update each month the value of sales and the value of purchases actual with those probable or forecasted and launch the elaboration of the commercial cash flows.

Reviews

Write a review

The management of cash flows of the large retail chains - 6 POS -File excel - V.1.01 - Online

The management of cash flows of the large retail chains - 6 POS -File excel - V.1.01 - Online

The file, in excel format Online, handles up to 11 months of corporate financial planning and is able to simultaneously manage the cash flows up to 6 stores and the entire company of large retailers as a whole.

It works only online.

The price indicated refers to the annual user's license, non-assignable and non-exclusive of the product for 1 user.