AvklarePlan Help Sign in Start a free trial

Help ›

Import a monthly summary

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

Steps

  1. Open Imports, set The file contains to Actuals (sales), choose your file, and click Upload.

  2. 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.

  3. 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.

  4. 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.
  5. 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.

  6. 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

All guides

An unhandled error has occurred. Reload 🗙