The tool allows to execute to adjust easily a complex financial accounting.
Usability of source data input.
The template allows to structure and collect your source data in one place.
Built-in tools for rapid planning, such as "periodicity", "organization of connections between objects" significantly save time.
Take advantage of new opportunities for organizing teamwork in Excel.
Starting with MS Office 365 (for PC), MS Office 2019 (for MAC), Microsoft realized the possibility of full-fledged teamwork in Excel.
For the organization of distributed access using Microsoft Cloud OneDrive.
When several operators work simultaneously, information about the operations they perform is visually available. There are no more conflicts and automatically created secondary copies.
Plan randomly revenues and expenses.
Each row corresponds to one revenue/cost transaction.
New mechanism of flexible management of event frequency allows easy planning.
Customized event frequency patterns allow most accurate revenue/cost planning.
Post daily transactions of revenues and expenses for 365 days period. Revenue and expense items allow to consider transactions for recognition:
There available allocation of revenues and expenses to accounts.
Revenue and expenses accounting operations automatically daily form the states of accounts, and as well as cashflow by months.
The template allows to define your own catalog of products and services, product groups, set analytical groups for further analysis for all types of income and expenses of the project.
Plan-fact report includes monthly indexes of:
The template allows to make calculations in different currencies at once, to assign your own currency and the rate of settlement operations.
For planning and accounting in different currencies you need setup the main currency.
Planned revenues and costs for 365 days period, by months:
Products or product groups revenues.
Analytical costs accounting.
Current state of account. Current calculated value of cash considering all entered transactions of revenues and expenses allocated to the specific account.
Cash flow. The calculated difference in revenues and expenses, by accounts by months.
Expenses by analytical accounts. The amount of expenses grouped under recognized analytical accounts by months.
Revenues by analytical accounts.The amount of incomes grouped under recognized analytical characters by months.
Summary report on revenue and expense by month.
For specialists, we offer the possibility of self-modification of the template code.
Excel is a tool that allows any specialist, having studied the basic functionality to create their own unique calculations, forms, graphics.
The open source code of a professional tool allows everyone to significantly reduce the time to get their unique result when planning. It is much easier to refine the functionality with a good open base.
The template is dynamically expandable and has no limits
on the amount of input source information.
The template does not use VBA and at the same time it is easily dynamically expanded using only regular Excel features.
The calculations we have created and the logic of data interaction are expanded by using the simple “copy past” operation.
The model works equally well on Excel for Windows and Mac.
|Computer configuration||CPU not lower than i5, not less than 4GB.||CPU i7, 8 GB RAM memory.|
|Operation system||Windows 7, 8, 10
MAC OS 10.9 Mavericks or higher
|Excel||MS Excel 2010 - 2016
MS Excel 2011-2015 for MAC