Plan of total, non-operating and other costs. Accounts receivable plan - deferred payment modeling

All costs of the company, including - mutual settlements with suppliers and contractors, debt service costs, tax payments and other costs, as a result, fall into the table "Plan of total, non-operating and other costs". And now in this table, for future calculations, you need to highlight deferred payments. And this can be done in the edit form, in the following table, which is called "planning payments and accounts payable".

It is here that deferred payments are planned, including taxes and other payables. In the "planning of payments and accounts payable" form, you can model both simple deferred payments and complex ones. For example, if VAT is paid quarterly, here we can simulate these payments. That is, the accruals for VAT of the first month will be paid in the fourth month (after the end of the quarter), also the accruals for the 2nd and 3rd months will be paid in the 4th month, and the accruals for the next quarter (4th, 5th and 6th th month) will be paid in the seventh month, etc. So we can model any deferred payments - of any complexity.

Here also payments are planned in 12 periods of 1 year of the project. From each period, a form is called in which you need to schedule deferred payments - "payment schemes" for a specific month and costs. For example, if you open the form in February, you can see the following in the header of the form: "Planning Payments and Accounts Payable - 02.2020". Simply put, all charges for a specific month will be paid exactly as you “tell” the program in this form.

☛ Important! The calculation algorithm will use the same "schemes" in annual cycles - in all subsequent periods of the project.

Business planning should take into account cash flows, which differ significantly from static plans that do not meet the requirements and objectives of planning. First of all, the financial model should adequately assess financial risks, which are also estimated by the methods of investment analysis.

In "Plan of total, non-operating and other costs" all current and future payments are modeled. Payments and obligations of the company (settlements with suppliers and contractors, debt obligations, tax and other payments are displayed "Accrual of money" and "Receipt of money":

1. Horizontally - scales for "Accrual of money".
2. Vertically - scales for "Receipt of money".

In the structure of the balance sheet deferred charges are reflected in current liabilities (accounts payable), at the same time, the tax liability reflected on a separate line, in accordance with the recommendations IFRS (as a separate risk category).

Once the settings in the edit form, you need to perform the calculation of the plan from the main menu: "Main menu → Data → Calculate → Plan of total, non-operating and other costs". Same F9.

The calculation of the "Payments to creditors" plan is based on the algorithm for dividing the cash flows, respectively, into "Accrual of money" and "Receipt of money", which simulates cash flows close to reality. The calculation algorithm checks the "payment schemes" created by the user, and determines the payment periods for each payment group.

The scheme "Accrual of money" and "Receipt of money", for example, for tax payments (once a quarter):

The principle settings "payment schemes" versatile and allows you to create payment models of any configuration – separately for each month and for each "lender".

To call up the editing form, you need to click once on the active link (same thing - F2). In the editing form there are 2 tabs:

1. Settings "payment schemes".

Payment plans are configured in each of the 12 cycle periods (months). When performing the final project calculation, in the following years, the same settings are used (for the first 12 months of the project).

2. Installation "payment schemes".

1. Settings of payment plan parameters

The maximum number of "payment schemes" – 10-th (in the standard configuration program). The list shows the 10-th "payment schemes" with uncertain names that can be edited so that they reflect the content of payments.



Settings "payment schemes" suggest:
1. Changing "title" in the edit box (as shown in the figure).

2. Distribution of "percent of payment" with the help of sliders (runners) - in the current and subsequent periods (months).

Setting "percent payment" runs "left to right", in ascending order of the index of the slider (from the less to the greater).

3. Save the values of the current settings of the sliders (save button). Starting with version 6.00, save has been replaced by auto-save.
4. Distributing (copying) the "schema" settings to other 11 periods (copy button).
5. If necessary, set exclusive "payment plan" settings in each specific period (in total 12 periods).

Tab settings "payment schemes":



☛ Note that the total percentage will always equal 100 %.

Example 1. Modeling of the "payment scheme" of calculations for employees' salaries.

Let, 40% of wages paid to employees in the current month (in advance) and 60% in the next. Moreover, this setting is "payment plans" must be identical for each month of the project.

1. step – select the company (any of 12) and enter the editing form;
2. step – in the "settings payment schemes" from the list, select a schema and name it, for example, "the Payment of wages, advance 40%";
3. step – in the current month (current month is always the first), set the slider to 40%. Please note, next month the program will set 60%;
4. step – click "Save"; Starting with version 6.00, save has been replaced by auto-save.


5. step – Finally, click the "Copy" button. After that, the "schema" settings will appear in the settings of the other 11 periods (months).


Example 2. Modeling the "payment" of tax payments (in the month following the quarter).

For example, tax payments are made once a quarter: in the month following the quarter. The transfer of tax payments of each month, respectively, to the 4 th, 7 th, 10 th, 13 th months, schematically, could be displayed approximately like this:

Payments in the 1st quarter
1 month → 4 month.
2 month → 4 month.
3 month → 4 month.

Payments in the 2nd quarter
4 months → 7 month.
5 month → 7 month.
6 month → 7 month.

Payments in the 3rd quarter
7 month → 10 month.
8 month → 10 month.
9 month → 10 month.

Payments in the 4th quarter
10 month → 13 month.
11 month → 13 month.
12 months → 13 month.


To create and configure this "payment scheme" you need, in sequence, in each of 12 months, to set the appropriate parameters:

1. step. Call the form of editing in the first month - once click on the active link (same thing - F2), as shown in the picture:

2. step. In the tab "settings schemes for payment" specify the name of the "payment scheme", for example, "Taxes – quarterly".
3. step. In the same tab using the sliders, enter: payment for 1 month – "0%", payment for 2 months – "0%", payment for 3 months "0%", payment for 4 months – "100%". See the picture of the interface after setup:

Accrued payment (month 1) → payment in the 4th month.
4. step.Click "Save". Starting with version 6.00, save has been replaced by auto-save.
5. step. Do the same procedure (steps 1-3) for each month. See how the interface should look, after the settings made (in the second and third month) of the first quarter:

Accrued payment (month 2) → payment in the 4th month.

Accrued payment (month 3) → payment in the 4th month.
6. step. Finally, "tie" your "payment scheme" to taxes (see "2. Setting Payment Schemes").




2. Installation, "binding" the payment schemes to the particular "creditor"

After the "payment scheme" are configured, they must be linked to the "lender" in the "Set payment schemes" tab.



To bind a "payment scheme" to a specific "creditor", select the "creditor" from the left list, then in the right list, select the desired "payment scheme", as shown in the picture:


If the schema is not selected, then the accrual periods according to this "creditor" will coincide with the payment periods.

Payments (the"lenders") represented by the standard list, which is formed from the corresponding rows of the "table of creditors":

1. Total VAT payments;
2. Profit tax;
3. Property tax;
4. Other taxes and fees;
5. Wages-in direct costs;
6. Wages - as part of resource costs (Cost Plan for the implementation of production stages);
7. Wages - included in total costs;
8. Payments to pension and other funds;
9. Material costs - as part of direct costs;
10. Material costs - as part of resources (Cost plan for the implementation of production stages);
11. Other material costs;
12. Business Costs;
13. Administrative costs;
14. Other operating expenses.




3. Performing test calculations. Final calculation

You can perform a test calculation for one or more, selected from the list, "creditors". Such a calculation can be useful for testing purposes. To perform a test calculation, you need:

1. click the "Clear" button (in order to clear the "Payables Payments Plan" table from the data);
2. select an item from the list of "creditors";
3. then click the Calculate button.



After the final editing of the settings in the "Payment Plan for Payables", it is necessary to perform the final calculation of the plan: "Main menu → Data → Calculate". Same F9.

Select your Budget-Plan Express licenses and pay in your personal account - in rubles or other currency

1. If you deleted some data by mistake or performed the action, causing damage to data, exit the program without saving: "Main menu → Project file → quit without saving".


2. If you exit the program, save the changes: "Main menu → Project file → Save" (or Ctrl+S). Or use the program exit with saving.


3. Periodically back up the data: "Main menu → Project file → Save and backup" or Ctrl+Shift+S. File project saved in the folder "backup", the project name will display date and time of saving. To restore the file, just copy it in system folder («BPlanExpress»).


4. If you have several projects (or calculation options), create a template file and, starting a new project, open the template file where your settings or preliminary project calculations are saved, select the menu item: "Main menu → Project file → To create a new project". This will shorten the development time of projects.
☛ Note that a new project is created in the system folder ("BPlanExpress"), which opens by default.


5. Complete the final calculation: "Main menu → Data → Calculate". Same - F9.


6. Clear table (reset values): "Main menu → Data → Clear table".


7. Delete the table (delete all data and settings of the table settings): "Main menu → Data → Delete table".


8. Clear the string (reset value): "Context menu (right mouse button) → Clear line."


9. Translit: "Main menu → Settings → Translit text tables". Select the translation language.


10. Export: "Main menu → Reports → Export to Excel". In the same place - export to Word.


11. Financial and investment analysis. Settings parameters of project performance indicators:"Main menu → Settings → Investment analysis".


12. Quick graph: "Context menu (right mouse button) → Graph of a line." Before the call, place the cursor anywhere in the row with the desired data. See also «Preparation of reports and business plans. Graphics».