Payment calendar in 1C: why it does not match reality

Learn how a payment calendar differs from cash flow budgets and statements, why 1C reports diverge from reality, and how to spot cash gaps early.

  • How the payment calendar differs from the cash flow budget and cash flow statement
  • How a working payment calendar is built
  • Why the 1C payment calendar diverges from reality
  • What the calendar must contain to be trusted
  1. The payment calendar answers one question: will there be enough money in the accounts on each day of the coming month?

  2. It shows neither actuals, like a cash flow statement, nor a quarterly budget, like a cash flow budget. Instead, it shows the near-term daily horizon: what must already be paid, what is expected to be received, and what the balance will be at the end of each day. In standard 1C configurations—Accounting, Small Business Management, ERP, and Comprehensive Automation—the payment calendar is available as a ready-made report.

  3. The problem is almost never the report itself: it accurately shows what is in the database.

  4. The divergence from reality occurs because a significant share of liabilities and receipts is missing from the database or entered after the payment decision has been made.

How the payment calendar differs from the cash flow budget and cash flow statement

Three tools are often confused, although they answer different questions and operate across different time horizons.

ToolTime horizonWhat question it answers
Cash flow statementPast periodWhere the money actually went and where it came from
Cash flow budgetMonth, quarter, yearHow much we plan to receive and spend by category
Payment CalendarThe next 14–30 days, day by dayWhether the account balance will be sufficient on each specific day

The cash flow budget sets the boundaries: how much the company may spend on each item during a period. The payment calendar ensures feasibility: whether specific payments can be made on specific dates without going into the negative. Neither works without the other: a budget without a calendar cannot prevent an intra-month cash gap, while a calendar without a budget becomes a queue of requests without limits.

How a working payment calendar is built

WHAT A WORKING PAYMENT CALENDAR INCLUDES SOURCES 1C: obligations and payments invoices, acceptance certificates, contracts, schedules Bank statements balances across all accounts and legal entities Payment requests chats, email, internal memos Plans and cash flow budgets budget, item limits, revenue forecast COMPANY RULES What we pay and when Priority: taxes, payroll, critical suppliers, and everything else. Item limits and minimum required account balance. Probability of receipt: confirmed, expected, at risk. 30-DAY CALENDAR Date, amount, balance Each row: date, payment, basis, responsible person. The balance beneath the lines for each day ahead. Negative balance— this is a cash gap WHAT THE HORIZON PROVIDES The cash gap becomes visible 2–4 weeks in advance There is time to act: move the deadline, split into installments, speed up receivables collection, or raise the limit. The cash gap becomes visible on the payment date The choice comes down to an overdue payment or an emergency loan or delay salaries—there are almost no options.
The calendar's value depends on its horizon: a cash gap spotted two weeks ahead can still be resolved.

Why the 1C payment calendar diverges from reality

Liabilities exist outside the database

The contract is signed, the invoice has arrived by email, and the payment date was agreed in correspondence—but none of this appears in 1C until payment is made. The calendar shows not the full picture of obligations, but only the documented portion.

Payment requests are sent in chats

Until a request becomes a document, it is invisible to the calendar. The finance specialist learns about the payment on the day they are asked to process it.

Multiple legal entities and databases

Balances, liabilities, and intercompany settlements are spread across different databases and accounts. The group’s consolidated balance is compiled manually in a spreadsheet and becomes outdated within a day.

Deadlines are not digitized

The contract says “within 10 business days of the act signing date,” but the database contains only the document date. The calendar schedules the payment for the wrong date.

Receipts recorded as actuals

An expected customer payment enters the calendar as confirmed, even though its probability may vary. A single delayed payment can invalidate the entire forecast.

All five causes have one thing in common: the calendar is automated, but data collection is not. As a result, the finance specialist rebuilds the table every week, while payment decisions are based on the balance in the online banking system.

Map out your integration landscape

Plan versus actuals: how to tell whether the calendar works

  1. A calendar is validated not by its appearance, but by whether the figures reconcile.

  2. Once a week, review three metrics: how many planned payments were made on time, by how many days receipts were delayed on average, and how many times the balance fell below the minimum required level during the month.

  3. Variances show exactly where the process breaks down.

  4. A systematic 5–7-day delay in receipts means customer payment probability is overstated, so forecasts should reflect actual payment discipline rather than contractual terms.

  5. Regular unplanned payments mean requests are bypassing the process. Budget-versus-actual analysis by category links the calendar to the cash flow budget: limit overruns become visible before payment, not at month-end.

Cash gap: the cost of the time horizon

A cash gap is not a loss. A company can be profitable and still have no money on a particular Tuesday: revenue has been recognized, the act has been signed, and payment will arrive in 45 days, while salaries and taxes are paid according to schedule. The difference between a manageable and unmanageable situation is measured in days of advance warning. A gap identified two to four weeks ahead can be addressed by agreeing a later due date with the supplier, splitting the payment into tranches, accelerating receivables, or opening a credit line in advance.

The same cash gap discovered on the payment date leaves a choice between overdue payments, an urgent expensive loan, and delayed salaries.

How it works in KT.Team AI accounting

  1. Within an AI accountant’s framework, the payment calendar is an executable procedure, not a report.

  2. The agent collects obligations and payments from 1C via OData, bank statements for all legal entities, requests from approved channels, and planned cash flow budget data.

  3. It then applies the company’s rules: calculates the payment date based on the contract terms, sets priorities, checks limits and the minimum required balance, and labels receipts by probability.

  4. The result is a self-updating calendar and an alert for the day when the balance turns negative, identifying the payments that cause it.

  5. The agent does not resolve disputed cases: payments without justification, new expense categories, limit overruns, or priority conflicts go to an exception queue with context, while the finance specialist makes the decision.

  6. How the entire process works—on the page AI accountant; how management accounting was compiled—in management reporting case.

  7. Calendar accuracy depends on allocating payments correctly—this process is covered in a separate analysis: Bank statement in 1C.

FAQ

Frequently asked questions

How does the payment calendar differ from the cash flow budget?

By time horizon and purpose. The cash flow budget sets item limits for a month or quarter, while the payment calendar shows the balance for each day over the next two to four weeks and ensures that specific payments can be made.

Can you manage a payment calendar in Excel?

Yes, and that is fine at the start. A spreadsheet stops working when there are multiple legal entities, accounts, and approvers: compiling it takes more time than it saves, and the data becomes outdated faster than it is updated.

How often should the calendar be updated?

Daily for balances and completed payments, and weekly for the receipts forecast. A calendar updated once a month shows history, not the nearest risk.

What to do if the calendar shows a cash gap

While there is still time before the date, work on both sides: reschedule and split payments by priority, and accelerate incoming funds. Decisions should follow priority rules, not whoever demands payment most loudly.

Is the built-in 1C report enough?

The report shows exactly what is in the database. If requests, contractual deadlines, and balances of other legal entities are not included, the problem is not the report: data collection must be organized first.

Discuss the article: Payment Calendar in 1C: Why It Doesn’t…

Enter your email or phone number so we can get back to you.

Send via: