The management of cash flows-file excel v.1.0.1 - Online

The file, in excel online format, manages 11 months of planning financial corporate. It is simple to use and unique in its kind. It is recommended for the management of the cash flows of the Companies.

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

180,00 € tax excl.

More info

A SIMPLE METHOD FOR THE MANAGEMENT OF CASH FLOWS

The site shows a model to be used for the planning of cash flows of your company.

The spreadsheet "The management of cash flows" is designed to effect financial planning up to 11 months.

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);

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

The pictured model is dynamic, flexible and easy to use.

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

Image demo n. 1 (Sheet Summary 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 because it is assumed that the company is in possession of accounting data updated of the closing dates of receipts and payments of the first month.

Moreover, the financial management of the first month has been divided into two parts:

- The first part includes the financial management from day 1 of the month to day 16 of the month;

- The second part includes financial management from day 17 of the month to the last day of the month;

Dividend, the financial management of the first month in two parts we have tried to give a more immediate representation of its financial commitments.

The financial planning of the second month may ,instead, be 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 successive of financial management are proposed automatically but can be changed manually by the user. 

Image demo n. 2 (Sheet summarizing the different outputs)

This is the picture of one of the 11 spreadsheets. 

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.

Picture demo n. 3 (Sheet summarizing the cash flow commercial)

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.

Also this paper is divided into three parts:

- The first part includes the receipts and commercial payments of the previous year (n-1);

- The second part includes the receipts and commercial payments of the current year (n);

- The third part includes the receipts and commercial payments the following year (n + 1);

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

The user should take care to include in the prospectus the amount of the purchases and of the sales of the previous year and the current year. The amounts of the purchases and of the sales of the previous year must be inserted, obligatorily, each year at the exchange for each accounting year.

In the current year, instead, this value must be entered (and saved) month by month, at following the accounting record of the amounts of the sales and of the commercial purchases.

Just in case the actual data are not available, the user could to insert in the prospectus the data probable or close to those accounting taking care, however, to replace them as soon as will be in possession of the actual ones.

The data probable of the sales and of the purchases, however, shall prevail and will go to overlap to the forecasted data.

Reviews

Grade 
05/05/2017

La gestione dei flussi di cassa con excel online

Complimenti.E' un'ottima idea quella di mettere in condizione le aziende di gestire i propri flussi finanziari online.Si usa Excel online e non è necessario avere excel on desktop.

    Grade 
    04/07/2017

    La gestione dei flussi di cassa

    Il calcolo dei flussi di cassa avviene online e in qualsiasi momento ed in qualsiasi luogo ci si può connettere al proprio file tramite internet. E' una buona idea.
    Il costo è sicuramente competitivo.
    Gestisce 11 mesi di pianificazione finanziaria online.Bene! Grazie al progettista di questo file.

      Grade 
      03/21/2017

      The management of cash flows excel online

      It is interesting! I like.
      It is dynamic, efficient and manageable online.
      The price of the subscription is acceptable.

        Grade 
        03/15/2017

        The management of cash flows excel online

        It's an excellent software because is online and the price is good.

          Grade 
          03/01/2017

          La gestione dei flussi di cassa online

          Finalmente è possibile gestire un file excel on line. Si possono fare previsioni finanziarie con excel on line senza avere Office excel. Il file viene gestito nel cloud di Office 365 OneDrive ed è personalizzato. Solo l'utente lo può utilizzare.

            Grade 
            02/10/2017

            La gestione dei flussi di cassa Online

            Si tratta di una cartella di lavoro da aprire con excel online e questo è utilissimo perchè con un link mi collego alla cartella di lavoro che mi viene messa a disposizione online e posso lavorare anche se nel mio computer non è installato Office.Vi faccio i miei complimenti. E... poi il prezzo dell'abbonamento mensile è bassissimo. E’ una offerta interessante.

              Write your review!

              Write a review

              The management of cash flows-file excel v.1.0.1 - Online

              The management of cash flows-file excel v.1.0.1 - Online

              The file, in excel online format, manages 11 months of planning financial corporate. It is simple to use and unique in its kind. It is recommended for the management of the cash flows of the Companies.

              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.