Overview
The Finance module shows a fiscal year’s revenue, gross profit and expense projection, the profit centers, cash flow, borrowing, the aging of customer receivables and supplier debt, and scenario calculations. Your organization’s finance_module license opens the module; without the license, the screen redirects you to the features page in Settings. If the license exists, a user whose role has the finance.view permission sees the screens; for a user without the permission, the page returns a not-found response. Roles and the license are described in Chapter 1.
| Menu group | Screens |
|---|---|
| General | Summary Cockpit · Explorer · Financial Health · Invisible Cost · Alarm & Action |
| Receivables & collection | Receivables Cost · Receivables Aging · Receivables Risk · Receivables Explorer · Upload receivables · Collection Coverage |
| Supplier payables | Payables aging |
| Rates & FX | FX risk |
| Cheques & Notes | Cheque/Note Portfolio |
| Planning & profitability | Rolling Forecast · Profit Center · Cash Flow · Borrowing · Scenario Studio |
| Expenses & costs | Expense Analysis · Human Resources |
| Data | Excel data entry · Excel import |
The same band sits at the top of all Finance screens: the «Fiscal year» selector, the color legend (red for loss or deficit, orange for risk, green for positive) and the screen tabs. The selector lists the years in which data exists; with the buttons next to it you can open the year before the oldest year in the list, or the year after the newest year, as an empty year (between 2000 and 2100). The year you select is written into the address bar and is retained while moving between tabs; if the address has no year, your organization’s newest year with data is opened.
| Data | How it is entered | Screens using it |
|---|---|---|
| Monthly revenue and gross profit (branch), expense items, cash inflow and outflow, monthly receivables and overdue receivables, debt stock and its interest, profit centers, target and settings | Manually: «Excel data entry» or «Excel import» | Summary Cockpit, Financial Health, Alarm & Action, Rolling Forecast, Profit Center, Cash Flow, Borrowing, Scenario Studio and Expense Analysis |
| Customer receivables aging (snapshot-dated) | PULS Connect: the «Account aging» and «Account aging carry-over» records, from the PULS Connect › Imports › Account Aging Import screen; or manually: «Upload receivables» | Receivables Cost, Receivables Aging, Receivables Risk, Receivables Explorer, Collection Coverage and Invisible Cost |
| Supplier payables aging (as of a snapshot date) | PULS Connect: the same «Account aging» records, through the «Import supplier payables aging» section of the same import screen; there is no manual route | Payables aging |
| Employee | Employee records of the Human resources module; only if the Human resources module is enabled for your organization | Human resources, Profit Center, Scenario studio and Alarms & actions |
| Stock value | Records of the Stock module | Hidden cost |
The Explorer checks are described in Chapter 7, the PULS Connect imports in Chapter 2, the CRM visit plan in Chapter 12, and the Human resources module in Chapter 13.
Summary cockpit
This is the summary of the selected year. The «Year-end indicators» strip holds the financial health score (out of 100, with data coverage), the year-end revenue projection, the year-end net result, the break-even gap or margin, and the cash difference; the cash difference is the difference of the last actual month entered in the settings, or, if there is no setting, of the last month with cash data. The second strip shows the profit center net result, the head-office load (only if the head office is at a loss), the debt stock and the interest burden. Each indicator is a link to its own report; if the cash and debt indicators have no data, they show «—» and the reason instead of zero. If no annual target has been entered, the screen states that the target is to be entered on the Settings tab of Excel data entry.
The «Report family health map» table places side by side, for Rolling Forecast, Profit Center, Cash Flow and Borrowing, scenarios and data entry, the main indicator, the status and a link (Details, Scenario, Enter data). Below it are the monthly net result chart (gross profit minus general expenses) and the list of critical alarms, which comes from the same source as the «Alarms & actions» screen. If revenue and gross profit have been entered for at least two branches, and the branch with the lowest margin is below the average of those branches, a row comparing that branch’s margin with the average is added to the list.
Explorer
It is for freely breaking down finance data and turning it into charts. There are seven data sets: Revenue & Margin, Expenses, Cash Flow, Borrowing, Profit Center, Receivables explorer and Receivables — invoice due-date band. The first five read the most recent year of your organization that has data; the two receivables sets read the most recent aging snapshot, and only the «Receivables explorer» set calculates interest, using a monthly base rate of 3.5%. If there is no aging snapshot at all, both receivables sets open empty. The Explorer’s checks are described in Chapter 7.
Financial health
At the top of the screen are a financial health score out of 100 and its band: below 40 is Critical, below 60 is At risk, below 75 is Watch, above that is Healthy. The score is scaled only over the dimensions that can be calculated; missing data is not counted as zero points. The data coverage bar says how much of the weight could not be calculated; if no dimension can be calculated, it shows «Could not be calculated» instead of the score.
| Size | Weight | Question it answers |
|---|---|---|
| Profitability health | 25% | Does the company actually make money from what it sells? |
| Cash health | 20% | Can it close the month without needing credit? |
| Collection & receivables health | 15% | Do sales turn into cash? |
| Debt & financing health | 15% | Is the financing burden sustainable? |
| Expense & efficiency health | 15% | Does the expense structure support the current revenue scale? |
| Forecast & management discipline | 10% | Can management see the year-end in advance? |
Each dimension card lists its weight, its data coverage, its sub-indicators with their scores, and its missing inputs. The button below it freezes the forecast of that period: the «Forecast & management discipline» dimension can be measured only if past forecasts have been frozen, and freezing cannot be done retroactively. The same period cannot be frozen a second time; the screen shows the number of frozen periods. If the last actual month has not been entered for the selected year, the button says «Actual month not entered», is disabled, and directs you to the Settings tab of Excel data entry.
Hidden cost
It adds up, on an annual basis, the burdens that do not appear as separate rows in the finance tables, and gives the ratio of the total to revenue and to gross profit. The burden is divided into two classes: cash leakage and opportunity cost (tied-up capital; it is not a cash outflow). The screen presents this not as a definitive report but as a preliminary impact calculation. The cost-of-capital rate is twelve times the monthly receivables rate (3.5%) and is referred to on the screen as «estimated assumption».
| Item | Basis |
|---|---|
| Financing burden of the balance subject to interest | The annual equivalent of the daily interest burden from the receivables aging |
| Production inefficiency | «Production inefficiency» expense item |
| Legal proceedings & compensation | «Legal proceedings & enforcement» and «Compensation» expense items |
| Opportunity cost of capital tied up in stock | Euro value in the most recent stock snapshot of the Stock module × cost-of-capital rate; the euro value is converted using the most recent euro rate confirmed in the receivables import, or, if that does not exist, the rate of the euro row in the receivables snapshot; if there is no rate, it is not calculated |
Alarms & actions
| Alarm | Source screen |
|---|---|
| Net loss alarm | Rolling forecast |
| Cash deficit alarm | Cash flow |
| Expense pressure | Expense analysis |
| Financing dependency | Borrowing |
| HR salary load (only if there is staff) | Human resources |
Each alarm is in a red, orange, green or gray state; gray means «not measurable», not a minor problem. The HR salary load alarm shows a user without the salary permission the number of staff instead of the amount; it is gray if the employer cost coefficient has not been set. In the list on the left, next to each alarm, is the number of incomplete actions (those with the status Open or In progress). When you select an alarm, the link to the source screen, the measured metric and the suggested actions appear; clicking a suggestion adds it as an action, and the added suggestion disappears from the list.
The columns of the action table are Action, Owner, Due date, Impact and Status (Open, In progress, Done). You can also add a new action manually with its text, owner, due date and impact, change its status, and remove it with «Delete». Actions are saved tied to the selected year. If there is no action linked to the alarm, you are told to add one from the suggestions.
Receivables cost
It calculates the hidden financing burden of the receivables balance subject to interest as of the most recent aging snapshot: balance × days overdue × (monthly rate ÷ 30). The base rate is 3.5% per month. The indicator strip holds net receivables, the overdue amount (on an invoice basis; if it cannot be measured, it says so), the balance subject to interest, accumulated interest cost, daily additional burden, collection period (DSO), the number of customers in arrears, legal or doubtful receivables, and the number of records subject to interest whose average delay exceeds 365 days (with the interest on those records). The difference between the overdue amount and the balance subject to interest is explained in a separate sentence.
Below it are listed the breakdown by account group, notable findings, interest cost by branch, interest-bearing balance by risk class, and the ten customers with the highest interest cost (those under legal proceedings are marked).
Receivables aging
It is the distribution of receivables across delay bands. The indicator strip gives the interest on the records subject to interest whose average delay exceeds 365 days, the most concentrated band, the total interest cost and the number of currencies. Cards: interest cost by the account’s average delay band (chart and table); aging table by invoice bands (the sentence beneath it gives the amount-weighted average delay of overdue invoices, and states the reason if it cannot be measured); customers who do not appear in the balance subject to interest but have overdue invoices; and the currency breakdown. The tables other than the currency breakdown can be downloaded as CSV.
The «All accounts» list is paginated at 50 rows per page, and the CSV file downloads the entire list, not the page; the finance.view permission is checked separately before the list is read. An account’s «Invoices» link opens the open-invoice listing: payments close the oldest invoices, the remaining open ones are listed, and the listing can be downloaded as CSV. If there are no records at account level, the list states that the import is done from Connect’s aging screen.
Receivables risk
It shows which customers the interest cost is concentrated in. The indicator strip gives the number of customers subject to interest, the shares of the top 20 and top 10 customers, and the number of customers in the Critical and High risk classes. If the share of the top 20 customers is greater than zero, the «Pareto priority» card states what percentage of the total interest cost these 20 customers carry. The table lists the customers with the highest interest by branch, risk class (Critical, High, Monitoring), interest-bearing balance, average days of delay, interest cost, daily burden and interest share; those under legal proceedings are marked. The table can be downloaded as CSV. If there is no customer data, an empty state saying so appears.
Receivables explorer
This is the Explorer that opens only the receivables aging; it has two data sets. The «Receivables explorer» set is account-based. Breakdowns: Branch, Customer, Currency, Average delay band and Legal. Measures: Net Receivables, Subject to Interest, Interest Cost, Daily Burden and Records. «Average delay band» is a single band based on the account’s average delay, not on invoice due dates; records that are not subject to interest appear in this breakdown as «Not subject to interest». When their condition is met, the screen also shows the insight cards «Branch concentration», «Customer concentration», «Receivables with avg. delay over 365 days» and «Exchange-rate risk»; a card whose condition is not met does not appear. The «Receivables — invoice due-date band» set splits the same snapshot on an invoice basis. Breakdowns: Due-date band, Customer, Currency and Branch. Measure: Amount. The indicator strip gives the cards «Total», «Overdue», «Band not measurable» and «Account with overdue invoices». This set has no interest measure; the amount that cannot be split into an invoice due-date band remains in the «Band not measurable» bucket. The insight cards show the amount that cannot be split into bands, invoices overdue by more than 365 days, and the customer concentration in the overdue amount; a card whose condition is not met does not appear. The checks are described in Chapter 7.
Upload receivables
- 01Select the receivables aging report as an .xlsx, .xlsm, .csv or .tsv file.
- 02The preview shows the figures for rows, customers, total receivables and balance subject to interest, the branch breakdown, warnings and errors.
- 03In the «Exchange rate & period confirmation» section, confirm the EUR/TL and USD/TL rates and the period (snapshot date). If the rate could be extracted from the file, it is suggested in the fields; if it could not, the screen says so and you enter the two rates manually.
- 04If there are errors, the import button is disabled. After the write, the number of records written and the number of old records refreshed are shown.
Collection coverage
It compares the customers in the CRM visit plan with the receivables aging. The indicator strip gives the numbers of customers that are planned, that are measurable, that have overdue invoices, and that have overdue invoices but no collection flag in the plan. The table lists each customer with its code, bucket (Portfolio, Win back, New), collection flag in the plan, status (in arrears, no delay or not measurable), overdue amount, balance, the highest average days of delay across the matching aging rows («—» if there is no average delay or it could not be measured), and the key by which it was matched (code or name); it can be downloaded as CSV.
Payables aging
It shows the due-date buckets and the currency breakdown of the debt owed to suppliers as of the most recent snapshot. The summary strip gives the total debt, the overdue and not-yet-due debt (in TL equivalent), the number of supplier rows, and the snapshot date. Cards: suppliers whose payments exceed their invoices (advance), due-date buckets (0-30, 31-60, 61-90, 90+ days), the currency breakdown, the 10 suppliers with the highest overdue debt, and all supplier rows (CSV). The link on a row opens that supplier’s source transactions (document date, due date, type, amount, currency).
The data comes only from PULS Connect: from the «Account aging» records, the accounts held in the 32x and 33x payables accounts of the chart of accounts are imported with the «Import supplier payables aging» section of the PULS Connect › Imports › Account Aging Import screen; TL, EUR and USD rows are imported. Payments close the oldest invoices, and the remaining open invoices are distributed into buckets according to their due dates. A new import to the same snapshot date replaces that date’s rows in full. Currencies are not added to one another; the TL equivalent of EUR and USD rows is derived from the TL amounts of the open invoices on their booking date, not from a valuation rate on the snapshot day.
FX risk
It shows, for each currency, how far customer receivables exceed supplier payables: receivables, payables and net (receivables minus payables) are written in that currency’s own unit, and different currencies are never added together. Each currency’s TL equivalent is two separate figures: at the recorded rate (the rates on the days the open invoices were issued) and at rate (the row’s own ERP rate, or else the latest rate in the rate book up to the snapshot date). The natural hedge is the ratio of payables to receivables in the same currency. TL balances carry no currency risk and are shown on a separate card. Clicking a currency lists the customers and suppliers in that currency; the link there opens the record on the Receivables aging or Payables aging screen.
The «Exchange-rate sensitivity» table shows, for each foreign currency, its net in its own unit, the applied rate (the TL equivalent at rate divided by the net), and how much the TL value of the net position would change if the currency’s rate against TL moved by −20%, −10%, −5%, +5%, +10% and +20%. Below it stands the total, in which all foreign currencies move by the same percentage at once; if a currency has no rate, the total is shown as «not measured» and the currencies without a rate are named. If there are no foreign-currency rows, a sentence saying so stands in place of the table. Clicking a currency opens its counterparties. TL balances are not affected by exchange rates: they are not part of the sensitivity table.
Cheque/Note Portfolio
The maturity calendar of cheques and promissory notes received and issued: weekly for the next 13 weeks, monthly after that; received, issued and net are written separately in each currency, and currencies are not added together. Documents that are past due but still in the portfolio are collected on a separate card. Clicking a period opens that period's counterparties, and clicking a counterparty opens the individual documents. The concentration table shows, for each currency, how the portfolio amount is split between the 5 largest counterparties and the rest, with its denominator; bounced and protested documents sit in a separate block with their count and amount and drill down to the records. Data comes from an Excel or CSV upload: a template is downloaded from the screen, the preview shows every unreadable row with its reason, and nothing is saved while any row is rejected.
Rolling forecast
It is the year-end projection: actual months and forecast months together. The indicator strip gives the net result, revenue (with the target attainment rate), gross profit (with its margin) and general expenses. The monthly chart of revenue, gross profit and expenses can be downloaded as CSV. The «Branch target and margin» table shows each branch’s revenue, target attainment, gross profit, margin and status; you can sort it by clicking a column header, and download CSV. Status: «Low margin» if the margin is below 25%, «Target not defined» if there is no target, «Target risk» if target attainment is below 70%, otherwise «Good».
Profit center
Revenue, gross profit, allocated head-office load and net result by profit center. The indicator strip gives the total net, the head-office load, the number and names of the positive centers, and the total staff. Staff is read from the Human resources records if there is an active employee there, otherwise from the value recorded in Excel data entry; in the second case the indicator carries the note «Recorded value». The detail table has the columns profit center, staff, revenue, gross profit, allocated gross profit, net profit, expense or load, and status (Loss, Positive), and can be downloaded as CSV; next to it are the net profit and gross profit per person charts. The allocation is made with the «Head office share» and «Branch share» settings; if there is no settings record at all for the selected year, the cells for allocated gross profit and for expense or load show «Not configured» instead of a number.
Cash flow
Monthly collections, payments and cash difference. The indicator strip gives one month’s difference, collections and payments; the month is selected by the same rule as the cash difference in the cockpit (the last actual month entered in the settings, or, if there is no setting, the last month with cash data). The overdue receivables indicator is read not from the aging snapshot but from the monthly receivables rows on the «Excel data entry» screen, from the last month that has receivables data (if a setting exists, nothing after the last actual month is looked at); if there is no receivables data, the indicator says not measurable. The collections-payments and monthly difference charts and the detail table (Month, Collection, Payment, Difference, Difference excl. loans) are shown; the difference excluding loan inflows is calculated separately. The table can be downloaded as CSV.
Borrowing
The trend of the debt stock, its breakdown by source and the interest burden. The indicator strip gives the debt stock of the last actual month, the highest debt, the interest burden and the share of non-bank financing; if there is no source row named «Bank», the share says not measurable. Below the debt stock and interest burden charts, the «Debt source matrix» lists each source’s stock in the actual months and its annual interest; it can be downloaded as CSV.
Scenario studio
At the top of the screen are the diagnosis rows calculated by rules from the selected year’s data (Margin, Profitability, Cash, Expenses, Debt, and Headcount if HR data is visible), and below them the scenario suggestions. The suggestion set can be switched to «Balanced» (Realistic baseline assumptions), «Conservative» (More cautious; effects are 40% lower) or «Aggressive» (Ambitious; effects are 50% higher). Each suggestion shows its severity (Alarm, Risk, Opportunity, Not measurable), its problem, its evidence, the suggested scenario, and its net, cash and debt effect; «Load and run this scenario» loads it into the studio below.
In the «Multi-scenario studio» you set up several conditions; each condition is calculated independently from the current data, and conditions do not stack on top of one another. Ready-made templates: «Current», «Weak margin + strong revenue + expenses», «Cash + debt», «Combined recovery» and «Headcount & salary». For each condition you enter the branch (or all branches), start and end month, revenue percentage, margin points, expense percentage, additional collections, debt reduction and interest reduction percentage. For HR levers you enter the scope (None, Department, Location, Level, Category and Supervisor), value, salary percentage, headcount increase or decrease, and gross per person. The HR levers and the «Headcount & salary» template can be used only if the Human resources module is enabled in your organization, there are active employee records, and you have the salary permission; otherwise the fields are disabled and the template does not appear in the list. You can copy a condition, delete one when there are several, add a new one, run the scenario, or reset it.
In the result, the year-end net result, revenue, gross profit, general expenses, cash difference and debt stock are shown side by side with the current situation (and, if HR data exists, the monthly gross salary load and headcount); a comparison chart, a per-condition contribution table and a profitability impact bridge accompany it. If the employer cost coefficient has not been set, the HR impact is not calculated and is not added to the total. In the «Saved scenarios» section you can save the current conditions under a name, then load or delete them; the records are tied to the selected year.
Expense analysis
The indicator strip gives general expenses, the ratio of expenses to revenue, the salary share and loan interest. Below the monthly expense chart, the «Expense items» table lists each item with its total and its share of expenses; the table opens sorted by total from largest to smallest and can be re-sorted by column header. Clicking a row opens the monthly breakdown of that item below the table. Depreciation is kept as a separate information row, so it does not enter the general expense total. The CSV file contains the twelve months, the total and the share of each item; if there are no expense items, the table says so.
Human resources
It reads personnel cost from the employee records of the Human resources module; Finance does not write to these records. If the Human resources module is disabled or there are no active employees, the screen is empty. A user with the salary permission sees the number of staff, the monthly gross salary load, the annual employer cost and the average gross salary; the distribution is called «Pay cost distribution» and the multi-scenario section becomes available. A user without the permission sees the number of staff, the numbers of departments and locations, the «Salary data: Hidden» card and a note saying that salary is protected under KVKK; the distribution comes as «Headcount distribution» by number of people. The distribution tabs are by department, location, level, category and supervisor. The «Staff list» is searchable; its columns are Employee ID, Full name, Level, Title, Department, Location, Supervisor and Tenure, and the Gross salary column is visible only with the salary permission.
Excel data entry
This is the screen where you enter the selected year’s finance data as in a table. Tabs: Rolling Forecast, Profit Centers, Expense Detail, Cash Flow, Borrowing, Settings and Data Check. You can paste into cells and navigate with the arrow and Enter keys; calculated columns are locked, and cells you change are marked in yellow. «Save» writes the changes, and «Download JSON» gives the year’s data as a file. If the staff count on the Profit Centers tab differs from the HR records, the «Sync with live HR» button writes the staff from HR. The definition sections where you can add, rename and delete branches, cash flow items, expense items and debt sources are on the Settings tab. Deleting a definition that has data entered does not delete the data: the button states this as «data remains» or «row remains», and the row stays on the screen.
| Settings field | Explanation on the screen |
|---|---|
| Annual revenue target | The target attainment rate in the Cockpit and Rolling uses this. |
| Last actual month | 0 = January. Later months count as forecast; Data check issues the empty-series warning based on this. |
| Employer cost coefficient | Gross salary × coefficient × 12 = annual employer burden. It must reconcile with the salary expense line. |
| Head office share | Allocated gross profit: the head office takes on this share of the branches’ total gross profit. |
| Branch share | Allocated gross profit: each branch keeps this share of its own gross profit. |
On the Settings tab, the permitted lower and upper limit is written under each field. The coefficient reconciliation card compares the employer burden calculated from HR gross salary with the SALARY expense row; the allocation shares card shows the sum of the head-office share and branch share, and it is not saved if the sum exceeds 1. The Data Check tab gives the following checks, based on the most recently saved data, as OK, Warning or Error: profit center staff, employer cost coefficient, mapping of location to profit center, supervisor link, forecast months, negative revenue, branch targets and monthly series integrity.
Excel import
- 01Select an Excel or text file (.xlsx, .xlsm, .csv, .tsv; at most 10 MB, the old .xls format is not supported). The data is written to the selected fiscal year.
- 02Select the sheet; changing the sheet resets the mapping selections. If the sheet was cut off at 50,000 rows, no import is performed.
- 03«Found on the sheet» shows the number of data rows, mapped rows, rows awaiting a decision, and month columns found; in the preview, a blue row is a month header.
- 04Map each row to a target: Revenue — branch, Gross Profit — branch, Expense item, Debt source, Cash inflow, Cash outflow, or «do not import». No import is performed while any row is awaiting a decision; you can leave all pending rows out with a single button.