Load your sales history into AvklarePlan from your own system's export: one line per invoice or credit memo line, for as many years as the file holds. Plans start from these actuals, and plans are compared with them.
You need to be an Owner or Admin of the workspace to import.
Before you start
- Set your fiscal year. In Settings, choose the month your fiscal year starts (see Set up your workspace). It decides which fiscal year and month every sale falls in.
- Import your items first. A sales line can only load for an item AvklarePlan knows. Lines for other items are rejected, or skipped if you choose to skip them (step 5).
- Export posted sales lines. The best file is your system's list of posted invoice and credit memo lines (in Business Central, Sales Invoice Lines or Item Ledger Entries; in QuickBooks, Sales by Item Detail). It needs at least an item number, a date and a quantity for every line; an amount column gives revenue too. Order lines (open or unshipped sales orders) aren't sales yet: if order detail is the only export you have, filter it to invoiced lines before importing.
- From Business Central? Export Item Ledger Entries with Open in Excel. AvklarePlan recognises the layout and fills in the mapping: only Sale entries count, quantities and costs are flipped to positive, and Sales Amount (Actual) is kept as it is, because Business Central records a sale's quantity and cost as negative but its sales amount as positive. Returns net against sales.
- Choose the date range. Any range works, across several years. For the first import, take everything you want to plan from (for example, last year and this year to date). After that, each month, export just the month that has closed.
Steps
Open Imports, set The file contains to Actuals (sales), choose your file (CSV or Excel), and click Upload.
You should see the file's page: its columns, a few sample values from each, and a guessed mapping. For a recognised export, a message names the layout, such as Business Central item ledger entries, and the mapping and options are already filled in.
Check the Use as column. You need:
- Item key: the item number, matching the items you imported.
- Date: the posting or invoice date.
- Quantity: the quantity sold.
- Amount (revenue), optional: the line's sales amount, that is quantity × price, not the unit price.
- Cost amount (cost of goods sold), optional: what the goods on the line cost (Business Central Cost Amount (Actual), the sample's Cost Amount). With it, comparisons show actual gross margin and cost per unit. Map the line's total cost, not a unit cost.
Set every other column to Ignore. The file keeps them; nothing is lost.
Under Options, check Dates look like against the sample dates. AvklarePlan guesses it from the file: 01/31/2026 is month first (US), 31/01/2026 is day first. A year and month without a day, such as 202502 or 2025-02, is read as the first of that month, whatever you choose, so a file of monthly totals per item can use its period column as the date.
Leave Fiscal year on Every year in the file. Each line goes to the fiscal year and month its date falls in. Choose a single year only to load part of a file.
Set the other options if your file needs them:
- Sold quantities are negative in this file: for ledger exports, where a sale takes stock out and is a negative entry. It flips quantities and costs.
- Sales amounts are negative too: tick it as well only if a sale's amount is negative in the file. In Business Central it isn't, so leave it clear.
- Skip lines for items not in AvklarePlan: for services, freight or other items you left out of the items import on purpose.
- Only rows where … is one of …: to keep, for example, only Document Type = Invoice, Credit Memo.
Click Validate. Validating checks every line and changes nothing.
You should see the number of lines ready to load, rejected and skipped, with the reasons. Below it, Months in the file lists every month: its fiscal year, first and last sale date, number of lines, total quantity, and the quantity On file now for months already loaded.
Read the months list. A month marked Partial starts or ends more than three days short of the month's edge. For example, a file exported on 13 November 2026 shows Nov 2026, Nov 2 to Nov 13, Partial.
Loading replaces each listed month as a whole, so a partial month replaces whatever that month held before. That's fine for a month still in progress, as long as you load it again from a complete export once it closes. If the month was already complete in AvklarePlan, remove it from the export instead (end the file at the last closed month).
A month marked Falls, for example Falls 52%, holds a quarter or more less than is loaded for it now. A corrected export of a closed month rarely moves that much, so check the export first: a date range cut short, or a filter left on (one location, one customer group). Nothing is loaded until you click Load into AvklarePlan.
If lines were rejected, read Rejected rows (the first ones are listed with their contents), fix the mapping or options, and click Validate again. Fix the file itself only if the problem is in the data.
Click Load into AvklarePlan.
You should see a message naming the fiscal years loaded, the item-months and rows, and how many months were replaced, for example Loaded FY2025, FY2026 actuals: … item-months from … rows. 23 months replaced as a whole.
Go back to Imports.
You should see Actuals on file: every month that holds actuals, newest first, with its item count, quantity, amount, the span of sales dates, the file it came from and when it was loaded.
Optional: click Save mapping on the file's page and give it a name (for example, BC sales lines). Next month, after uploading, choose it and click Apply saved mapping.
Monthly totals instead of invoice lines
Some systems export one row per item and month, with the month's totals. That imports the same way: map the period (for example 202502) or the first day of the month as Date, the month's quantity as Quantity, and the month's totals as Amount and Cost amount.
Check what the amount columns hold before mapping them. A column named like Sum of price is often the sum of each invoice line's unit price, not the month's sales. Test one row: divide it by the average price; if the result is a whole number (the number of invoice lines), it isn't revenue. Ask for the sum of quantity × price, and of quantity × cost, instead.
Every month after that
- Once the month has closed, export its sales lines (or the whole year so far, which is just as safe).
- Upload, apply your saved mapping, validate and load.
You should see only the months in the file replaced; every other month stays as it was. Loading a corrected file for a month replaces it entirely, so a voided invoice disappears rather than lingering.
Common mistakes
- Every line rejected with "isn't in this workspace". The items haven't been imported, or the item numbers in the two files differ (for example, leading zeros dropped by Excel). Import the items first; compare a rejected line's item number with the items list.
- Every line rejected for its date. Dates look like is set to the wrong layout. Compare the sample dates with the two examples, change it, and validate again.
- Quantities come out negative. The file is a ledger export, where sales are negative. Tick Sold quantities are negative in this file. Costs flip with them.
- Revenue comes out negative. Sales amounts are negative too is ticked for a file whose sales amounts are already positive, as in Business Central. Clear it and validate again. A mapping saved before this option existed flips amounts with quantities; open it, clear the box, and save it again.
- A unit cost mapped as the cost amount. Margin comes out far too high, because a unit cost is counted once per line instead of once per unit. Map the line's total cost column instead (often Cost Amount or Extended Cost).
- Lines rejected as "not FY…". A single fiscal year is chosen. Set Fiscal year to Every year in the file.
- A month looks too low after loading. The export stopped part-way through the month: its row in Actuals on file is marked Partial. Export the complete month and load it again.
- Loading a month marked Falls without checking. The month is replaced by the smaller figures. If that was a mistake, load the complete export for the month again: it replaces the month once more, so nothing is lost for good.
- Loading the first half of a month, then the second half as a separate file. Each load replaces the whole month, so the second file removes the first half. Load the complete month in one file.
- Importing sales orders instead of invoices. Open and unshipped orders count as sales they aren't yet, and cancelled orders may still be in the file. Export posted invoice lines, or filter the order file to invoiced lines.