AvklarePlan Help Sign in Start a free trial

Help ›

Import your sales lines

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

Steps

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

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

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

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

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

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

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

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

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

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

  1. Once the month has closed, export its sales lines (or the whole year so far, which is just as safe).
  2. 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

All guides

An unhandled error has occurred. Reload 🗙