AvklarePlan Help Sign in Start a free trial

Help ›

Try AvklarePlan with sample data

Import a realistic item list and almost three years of sales, then build a plan from them, in about ten minutes. The sample files are invented: an ERP-style export from a distributor of hardware, software, equipment and supplies. You import them exactly as you would your own files, so this is also practice for the real thing.

Just want to look around first? Your Sandbox already holds sample data and a budget, with nothing to import; see Explore AvklarePlan in your Sandbox. This guide is for practising the import itself, in your own workspace (the Sandbox doesn't import files).

You need to be an Owner or Admin of the workspace to import.

The sample's years are calendar years. For the numbers in this guide to match, the workspace's fiscal year should start in January (Settings in the left menu; see Set up your workspace). Use a workspace for the sample, not the one for your own data if your year starts in another month.

1. Download the sample files

  1. Open Imports in the left menu.
  2. Click Download sample files. (Once your workspace has imports, it's a link under the upload form: Download the sample files.)
  3. Open the downloaded avklareplan-sample-data.zip and extract it.

You should see three files: sample_items.csv, sample_sales_lines.csv, and HOW TO USE.txt, a short version of this guide.

2. Import the items

  1. On Imports, set The file contains to Items, choose sample_items.csv, and click Upload.

  2. Read the green message at the top: Recognised the layout of "AvklarePlan sample items" and filled in its mapping. The columns are already set: Item No. is the item key, Vendor Name, Brand, Sub-Brand, Item Category and Subcategory are the groupings, and Only rows where Item Type is one of Stocked Inventory keeps the items you plan quantities for.

  3. Click Validate.

    You should see 161 rows ready to load, 0 rejected, 153 skipped, with "Skipped, filtered out: 153" underneath. Those are services, subscriptions, rentals and drop-ship items, which aren't planned by quantity.

  4. Click Load into AvklarePlan.

    You should see Loaded 161 items: 161 new, and the status changes to Loaded.

3. Import the sales

The sales file runs from January 2024 to October 2026. One upload loads all three years.

  1. Back on Imports, set The file contains to Actuals (sales), choose sample_sales_lines.csv, and click Upload.

  2. The mapping is filled in again: Posting Date for the date, Quantity, Amount, Cost Amount, Skip lines for items not in AvklarePlan ticked, and Fiscal year set to Every year in the file.

  3. Click Validate.

    You should see 12,075 rows ready to load, 0 rejected, 13,761 skipped. Over half the lines skipped is the intended result, not a failed import: the sample, like a real ERP export, sells services, subscriptions, rentals and drop-ship items alongside stock, and you left those out in step 2 because they aren't planned by quantity. Skipped, item not planned: 13,761 under the counts says exactly that. What matters is 0 rejected. Under Months in the file there are 34 months, January 2024 to October 2026, none marked Partial.

  4. Click Load into AvklarePlan.

    You should see Loaded FY2024, FY2025, FY2026 actuals: 3,699 item-months from 12,075 rows. 34 months replaced as a whole.

  5. Go back to Imports.

    You should see Actuals on file listing each month, newest first, with its quantity, the span of sales dates, and sample_sales_lines.csv as its source.

4. Build a plan

  1. Open Plans in the left menu.
  2. Under New plan, enter a name such as FY2027 plan, set Fiscal year to 2027, and set Start from actuals of to FY2026.
  3. Leave Use the previous year's data for an incomplete year ticked. Under the form, Actuals on file shows FY2026 running from Jan 2026 to Oct 2026.
  4. Click Create plan.

You should see the grid with the 161 items, grouped by Vendor and then Brand, with January to October taken from 2026's sales and November and December from 2025's, because the sample's 2026 sales stop at October.

Some totals show — instead of a number. That's deliberate: Consumables mixes cases, packs and pallets, and adding cases to pallets would give a meaningless number. Expand the row to see each item's own quantities.

To group by category instead, remove Vendor and Brand from Group by (the × on each), then add Category and Subcategory.

From here, try a bulk change: select a row, choose Scale % in the Bulk change panel, and watch the preview before applying it.

Common mistakes

All guides

An unhandled error has occurred. Reload 🗙