AvklarePlan Help Sign in Start a free trial

Help ›

Get started with your own data

Go from your own system's exports to your first plan, step by step. Get started tells you which export to pull from your system, whether AvklarePlan recognises it, and what to do next, ticking off each step as your data arrives.

You need to be an Owner or Admin of your workspace. Get started isn't in the Sandbox, which holds sample data only; see Explore AvklarePlan in your Sandbox.

1. Open Get started

Open Home and click get started step by step, or click Bring in your own data → in the Sandbox's green strip.

You should see five steps, with the first one not done outlined in blue. A step you've done shows a ✓ and what's in AvklarePlan, such as 1,240 items in AvklarePlan.

2. Set when your fiscal year starts

If the first step isn't ticked, click Set up the workspace, choose the month your fiscal year starts and the name of your equivalent unit, and save. See Set up your workspace.

Do this before importing: the fiscal year decides which fiscal year and month every sale falls in, and it can't change after the first import.

3. Say where your data comes from

  1. Choose your system: Business Central, QuickBooks Online, VIP (beverage), Data warehouse or SQL, or A spreadsheet.
  2. Click Continue.

You should see the step ticked with your system's name, and the items step open with instructions for your system. To choose again, click Change.

4. Import your items

  1. Follow the instructions under Import your items to export your item list from your system.

  2. Choose the file and click Upload.

    You should see the file's review page.

    • Business Central and QuickBooks Online item exports are recognised: a green message names the layout and the mapping is already filled in.
    • Other systems: set the columns the Get started page listed (item key, description, unit, and the groupings you plan by).
  3. Click Validate and read the counts, then click Load into AvklarePlan.

    You should see the items loaded and, under the message, Next: import your sales. More on this import: Import your items.

5. Import your sales

  1. Click Next: import your sales, or go back to Get started.

  2. Follow the instructions to export your sales history, for example last year and this year to date.

  3. Upload the file, check the mapping, Validate, and Load into AvklarePlan.

    You should see the months loaded, and Next: create your first plan. Business Central's Item Ledger Entries are recognised; other systems' sales exports are mapped once, and you can save the mapping for next month. More on this import: Import your sales lines.

6. Create your first plan

Click Create a plan, then name the plan, choose its year and the year of actuals to start from. See Create a plan.

You should see every step ticked, and Your workspace is ready.

Your checklist on Home

Until your workspace is in use, Home shows a Getting started checklist: Import your items, Import your sales, Create a plan, and Compare a plan with actuals. Each item is ticked once it's done and links to where to do it.

Compare a plan with actuals is ticked the first time anyone in the workspace opens a plan and picks a year under Compare with; see Compare a plan with actuals. Once all four are ticked, the checklist goes away.

Common mistakes

All guides

An unhandled error has occurred. Reload 🗙