Load actuals from a spreadsheet with one row per item and one column per month, the layout most people keep in Excel. If you can export raw sales lines instead, prefer those (see Import your sales lines): they need no preparation and show more when something doesn't add up.
You need to be an Owner or Admin of the workspace to import.
Before you start
Import your items first. A row can only load for an item AvklarePlan knows.
Check the month headers. Each month column's header must name its month. Any of these work:
- with the year: Jan 2026, January 2026, Jan-26, 2026-01, 01/2026, or a date formatted as a month in Excel;
- a month name alone: Jan, February;
- a fiscal period: P01, Period 1, M01, or just 1 to 12.
Headers without a year (a month name or a period) need the fiscal year chosen in step 4.
Quantities only. The month cells are quantities. Revenue in the same layout can't be imported yet.
Steps
Open Imports, set The file contains to Actuals (sales), choose your file, and click Upload.
Check the Use as column:
- Item key on the item number column;
- Month (quantity) on every month column.
AvklarePlan sets these for you when it recognises the month headers. Leave totals, descriptions and anything else on Ignore.
You should see a note under the options: A summary: each Month (quantity) column's header names its month.
Under Options, tick Skip lines for items not in AvklarePlan if the sheet includes items you left out on purpose, and Sales are negative in this file if it shows sales as negative numbers.
Set Fiscal year:
- headers with a year (Jan 2026): leave Every year in the file, or choose one year to load only its months;
- headers without a year (Jan, P01): choose the fiscal year the columns belong to.
Click Validate.
You should see the number of rows ready to load, rejected and skipped. A row is rejected as a whole if any month cell isn't a number, so an item is never half loaded. Empty cells are fine: they add nothing.
Click Load into AvklarePlan.
You should see a message such as Loaded FY2025, FY2026 actuals: … item-months from … rows. 3 months replaced as a whole. Each month column replaces that month entirely, for every item.
Common mistakes
- "Column … doesn't name a month." A header like Q1, Total or Notes is mapped as Month (quantity). Set it to Ignore.
- "The month columns don't name a year." The headers are month names or periods: choose the Fiscal year.
- "… are the same month." Two columns name the same month, for example Jan 2026 and 2026-01. Set one of them to Ignore.
- A month comes out too low. The sheet holds only part of the items, but loading replaces the whole month for every item. Import the full sheet, or the raw sales lines.
- Fiscal year starting in another month. Jan 2026 is placed in the workspace's own fiscal calendar, so with a July start it is month 7 of FY2026. A period header (P01) is always the first month of the fiscal year chosen.