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
- Choose your system: Business Central, QuickBooks Online, VIP (beverage), Data warehouse or SQL, or A spreadsheet.
- 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
Follow the instructions under Import your items to export your item list from your system.
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).
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
Click Next: import your sales, or go back to Get started.
Follow the instructions to export your sales history, for example last year and this year to date.
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
- Importing sales before items. Sales can only load for items AvklarePlan knows. Import items first, and again whenever new items appear.
- Exporting sales orders instead of invoiced sales. Open orders aren't sales yet. Export posted invoice lines, or the ledger of sales.
- A file that isn't recognised. Only the exports named on the page are recognised so far. Set the columns listed there, then click Save mapping on the review page: next time, choose it under Apply saved mapping. To have your system's layout recognised for everyone, send just the file's header row (no data) to [email protected].
- The comparison isn't ticked. Opening a plan isn't enough: choose a year under Compare with.
- Looking for Get started in the Sandbox. The Sandbox can't import. Click Bring in your own data → in its green strip to switch to your own workspace.