Payment calendar
Plan receipts and payments, track your cash balance and spot cash shortfalls in advance.
12 periods · day, week or month · plan / actual
FINANCIAL TEMPLATE LIBRARY
10 ready-to-use spreadsheets for everyday business tasks. Plan payments, calculate profit and prepare reports without starting from a blank sheet. All downloadable files are in Russian.
Free · Russian-language files · no registration · ZIP, 231 KB
Download immediately
Enter your own data
Work in your own copy
FOR THE TASK AT HAND
Each file works independently.
Download one or get the whole pack.
Plan receipts and payments, track your cash balance and spot cash shortfalls in advance.
12 periods · day, week or month · plan / actual
Break down receipts and payments by activity and check how your cash balance has changed.
Cash flow · transactions · balance checks
Assess revenue, variable and fixed costs, operating profit, margin and markup.
Price · costs · profit
Bring together earnings, deductions and payments. See how much remains to be paid to employees.
Deductions and contributions are entered manually
Calculate the delivery price for the customer and trip economics for the carrier on separate tabs.
Delivery price · trip costs
Assess the economics of a course and cohort: acquisition, conversion, refunds, teaching costs and profit.
Course · cohort · return on investment
Combine revenue and expenses on an accrual basis and calculate profit for the selected month.
P&L · revenue · expenses · profit
Enter opening balances and double-entry transactions. Check that assets equal liabilities plus equity.
Assets · liabilities · equity
Plan quantities, prices and revenue by product and month. Compare planned and actual results.
Products · months · plan / actual
Find out how much you need to sell to cover costs at a given price and contribution margin.
Sales volume · revenue · profit threshold
THREE SIMPLE STEPS
The files include fictional examples to help you get started.
Save the file in a separate folder. Start with the first sheet: it explains the fields, formulas and limitations of the template.
Enter your data in the marked input fields. Keep the formulas and test a few of your own transactions first.
Check the totals and control indicators. Keep your working copy separate from the original template.
The files are in XLSX format. Open them in Excel. Other spreadsheet editors may display or calculate things differently: after importing, check formulas and totals using the examples.
The calendar shows 12 periods. Choose a day, week or month and shift the viewing window in settings. It includes planned and actual receipts and payments, cash flow and balance charts, recurring obligations and partial payments.
No. These are separate tools: changes in one file do not carry over to the others. Use consistent source data for your calculations and check the totals.
Deductions and contributions in the payroll register are entered manually; statutory tax calculation is not automated. Tax is also entered manually in the P&L. The templates are intended for management tasks and do not replace statutory reporting.
Yes, work in your own copy of the file. All examples in the pack are fictional; no real client data was used. Before sharing a completed file, check that it contains no confidential information.
THE WHOLE PACK AT HAND
10 Excel files and a short guide in one ZIP, all in Russian.
AFTER PLANNING
The calendar helps you choose a date. An approval process helps you check the purpose, gather documents and record the team’s decision.
Need help with financial processes?
Discuss your needs