Enter statistics in the grid
On the Statistics screen, Enter figures shows a grid by month or by line, with a column for each company. You can type the figures or paste a block from Excel, then save. A figure far from last month's is flagged for a second look, and a closed month can be read but not changed.
Two views of the grid
- By month. Every statistic for one month, with a column for each company. Choose the month and the company, or All companies, and switch on Only statistics with figures missing to see what is still owed.
- By line. One statistic for every month of a financial year that has begun, with a column for each company.
A company that is not expected to report a statistic has no cell for it. For a line entered for the whole group, a company's cell is optional.
Type or paste the figures
- Open Statistics and choose Enter figures.
- Type each figure, or paste a block from Excel into any open cell. In By month, rows are statistics and columns are companies. In By line, rows are months.
- Save. By month saves one month at a time.
A blank cell in a pasted block changes nothing. Delete clears a cell, Escape puts back the saved figure, and Enter moves down. If you leave with figures not saved, Finconsol asks whether to discard them.
Figures that look wrong
A figure three times last month's, or a third of it, is marked so that a slipped digit is seen before saving. The mark never stops a save.
If someone else changed the same figure while you were editing, Finconsol tells you who changed it and when, before your figure replaces theirs.
Which months can be entered
You cannot enter a month that has not begun. A closed month can be read but not changed. For a line that is fixed until changed, you record each change with the month it takes effect, under Add a change.
Who can enter figures
Administrators and preparers can enter figures. Other roles can read them.