Sales Importer
The Sales importer brings in the sales figures you already receive as spreadsheets: a distributor's sell-through report, an ERP or billing export, or a report your partners send. Journeybee finds the partner for every row and shows each partner's sales and orders next to their leads and deals, instead of in a spreadsheet nobody opens.
You create one importer for each report you receive regularly, for example "Distributor weekly report". An importer tells Journeybee which sheets and columns to read, how to find the partner (and optionally the lead or deal) for each row, and how the report reaches Journeybee. After that, each new report imports automatically, and only the rows that couldn't be matched need your attention.
Where to find it: Settings, then Sales importer (under Data & Tracking).
Who can use this: Admins only. Sales figures are commercially sensitive, so the page is hidden from other roles.
Needs: the Sales reports module, which Journeybee turns on for you. It works with any partner type. Linking a distributor and letting it upload from the portal also need the Distributor module.
Use cases
- Distributor sell-through. A distributor sends a weekly or monthly report of what each reseller bought. Import it to see month-to-date, year-to-date and last-12-month figures per partner, and to tie individual orders back to the projects partners registered with you.
- ERP or billing exports. Your finance system exports invoiced sales by customer account. Once the account codes are on your partners, you can see which partners actually generate revenue, not just pipeline.
- Partner-submitted sales. Partners report their own sales on a schedule. They email the report or you upload it, and the figures land on the right partner without anyone re-keying them.
- Closing the loop on registered projects. Orders that carry a project or deal reference are matched to the lead or deal they belong to, so your team sees what was actually ordered against each registered project.
- Tiering and rebates. Year-to-date and rolling 12-month figures per partner give you the numbers for tier reviews and rebate calculations.
Before you start
- Put the account code on your partners. Each row of the report names a customer by an account code. Create a partner custom field of type Text (for example "Account code") and fill it in on each partner with the code the report uses. See Custom Fields.
- Decide how orders find their project (optional). If the report lists orders, decide which column identifies the project. It can be a Journeybee lead or deal ID, the deal name, or a custom field such as a project registration number.
- Have a typical report to hand. You use it as a sample while you build the importer. It is only read while you set the importer up and is not saved.
Create an importer
Click New importer. The importer opens in a sidebar with three steps.
Step 1: Name
- Name: something your team will recognise, for example "Monthly sales report". Use one importer for each recurring report.
- Finding the partner: choose the Partner account code field, the partner field where you keep each partner's account code.
- Distributor (only when the Distributor module is on): optionally link the distributor who sends this report, so its contacts can upload it in the Sales reports room of their portal.
Step 2: Columns
- Upload your sample report (.xlsx or .csv). Journeybee lists the sheets and headers it finds.
- Click Add sales per partner sheet for the sheet that has one row per customer account. Pick the header for the account code, and optionally the name, status and currency. Map at least one of MTD, YTD or L12M.
- If the report has sheets of individual orders, click Add orders sheet for each one. Give each a line type, such as order, quote or backorder, and pick the reference, value, date and status columns.
- Under Project columns, add the columns that name the lead or deal an order belongs to, and choose what each one is compared with: a lead or deal field, or the lead ID, deal ID or deal name. They are tried in order, and the first one that finds exactly one record wins.
Columns are found by header name, so it does not matter if the sender reorders them. Each sheet also lets you:
- find the header row automatically, or fix it to a row number
- pick the sheet by part of its name with Sheet name contains, for example "Quotes" matches "MTD Quotes_3". Use this when two sheets have the same headers.
- set the date order, day first or month first
- mark the sheet as optional, so a report without it still imports
Under Rows to ignore, list the rows to skip, such as totals rows. Matching ignores case, and a value ending in * matches as a prefix, for example "Total*". You can also list placeholder values to treat as blank, such as "-" or "N/A".
Step 3: Check
The check shows what an import of your sample would do: the first accounts and orders, whether each one found its partner, and any rows that could not be read. Nothing is saved. Go back and adjust the columns until it looks right, then save.
How reports arrive
Open an importer to see How reports arrive. Use any combination:
- Upload: click Upload a report at the top of the importer. Set the report date (the date the figures are as of). Left empty, today is used.
- Email: reports emailed to the importer's private address are imported automatically. See "Receiving reports by email" below.
- API: POST a file to
/v1/sales-reports/{id}/imports, using the Importer ID shown on the importer. The API key needs write access. See API Keys. - Partner portal (Distributor module): link a distributor on the importer, and its contacts can upload the report in the Sales reports room of their portal, and see the status of their own uploads. Create the room on Portals for distributor partners. See Portal Room Types.
Receiving reports by email
Email is the easiest channel when a report is already emailed to someone every week or month. Set it up once and nobody has to touch the file again.
Step 1: Allowed senders
- Open the importer and, under How reports arrive, open Email.
- Under Allowed senders, add who sends the report: an address such as
reports@distributor.example, or a whole domain such as@distributor.example. Click Add for each, then save. You see Allowed senders saved. - If the report will be forwarded from one of your own mailboxes, also add your own domain, for example
@yourcompany.com. A forwarded email reaches Journeybee from your domain, so without this it's rejected.
Email import can only be switched on once at least one allowed sender is saved.
Step 2: Switch it on and copy the address
- Switch Email on. A Send reports to address appears.
- Click Copy.
Treat the address like a password. Mail from anyone who isn't an allowed sender is rejected, but keep the address to the people and systems that need it. If it leaks, click Generate new address. The old address stops working at once.
Step 3: Get the report to the address
Pick the option that fits:
- Forward the reports you already receive (most common). Set up a server-side forward of the sender's report emails from the mailbox that receives them today. Your own domain must be in Allowed senders. See Forwarding Email to Journeybee for Google Workspace and Microsoft 365. In Microsoft 365, forwarding to outside addresses must be allowed first.
- Give the sender a friendly address. Create
salesreports@yourcompany.com, forward it to the importer address, and ask the sender to send reports there. Add both the sender and your own domain to Allowed senders. - Give the sender the address itself. Simplest, but if you ever generate a new address you have to tell them again.
Step 4: Check the first report
After the next report arrives, open the importer. Under Imports, a new import shows with the source Email and who sent it. Open it to check the counts and anything that needs matching.
What Journeybee checks on each email
- The sender is in Allowed senders.
- The email is authenticated: SPF passes for the sender's domain, or for an allowed forwarding domain.
- It isn't marked as spam and doesn't fail DMARC.
- The Sales reports module and the importer's email import are on, and the email went to the importer's current address.
Then each .xlsx or .csv attachment is imported with the importer's saved columns, the same as an upload. An emailed report is dated by the day the email was sent. Files can be up to 25 MB. An email can have up to 10 attachments, and the first 5 report files are imported.
Checking an import
Each import runs in the background. The Imports list on the importer shows each import's source, status (Queued, Processing, Completed or Failed) and a summary of what matched. Open an import to see:
- Counts: rows read and skipped, rows with errors, partners matched, accounts with no partner, and orders matched or with no match.
- Row errors: the sheet, row, field and value that could not be read.
- Needs matching: on the Accounts and Orders tabs, assign a partner, lead or deal to anything that did not match, or ignore it. Each row shows Matched, More than one match, No match or Ignored.
Orders can carry flags for you to check:
- Future date
- Negative value
- Duplicate reference
- More than one project match
- Project not found
- Partner mismatch: the project belongs to a different partner than the account.
Your manual assignments are kept. If you fix a partner's account code and click Reprocess, Journeybee runs the import again and keeps what you assigned by hand.
A report sent again for the same report date replaces that date's figures. The earlier import is marked as replaced, so you always know which figures count.
Where the figures show
Matched orders appear as Reported orders on the lead or deal they belong to. Like the importer, this is only shown to admins.
Each partner's latest figures also show here. If more than one importer reports the same partner, their latest figures are added together. Figures are never converted between currencies: when they differ, you see Mixed currencies, not converted.
- Partner page: the Sales tab of the analytics block on the partner's Insights tab shows Month to date, Year to date and Last 12 months, the date of the latest report, and a trend over recent reports.
- Reports: the partner leaderboard gains a Reported sales (YTD) column. Hover a figure to see month to date and last 12 months. It isn't part of revenue or the partner score. The CSV export adds the three figures, the currency (MIXED where currencies differ) and the report date.
- Workflows: a goal condition can test a partner's Reported sales, for example to move partners between tiers. See Workflows.
- Partner portal: add a Lead & Deal Analytics block to a room and switch on its Sales tab. Two switches choose whether it shows the totals and the trend. Each partner sees only its own figures. Anyone who can edit rooms can switch it on.
- Distributor portals (Distributor module): switch on Show Reported Sales in the distributor's Partners room, and the distributor sees the sales it reported for each of its resellers in that reseller's details.
The figures only appear once a partner has a matched report.
Edit, disable and archive
- Edit: click Edit importer to reopen it in the sidebar. Changes apply to the next import. To apply them to an earlier import, reprocess it.
- Disable: switch off Enabled for the importer in the Importers list. A disabled importer accepts no new reports from any channel.
- Archive: the importer leaves the list and stops accepting reports. Its past imports and figures are kept.
Best practice
- One importer per report. Two senders with different layouts need two importers.
- Put account codes on your partners before the first import, so there are fewer rows to match by hand.
- Ask senders to keep the layout. Columns are found by their header name, so reordering is fine, but renaming a header breaks the import until you update the importer.
- Prefer email or the API to manual uploads for a recurring report: they run on time without anyone remembering.
- For forwarded reports, limit the forward to the sender's report emails, not the whole mailbox.
- Allow a specific address rather than a whole domain where you can. Use a domain when the sender's address changes.
- Check the Imports list after each new report for the first few weeks, until the matching settles.
Troubleshooting
Most accounts have no partner
The account code field is empty on those partners, or holds a different code from the report's. Fill in the codes, then Reprocess the import. If the report lists every customer the sender has, accounts that aren't your partners will always show No match: ignore them.
An account has more than one match
More than one partner has the same account code. Make the codes unique, or assign the account by hand under Needs matching.
The report no longer fits this importer
The sender renamed or removed a column the importer needs. Click Edit columns, upload the new file as the sample and pick the new header.
An emailed report didn't arrive
Check these:
- Email is switched on for the importer, and the email went to its current address.
- The sender's address or domain is in Allowed senders. For a forward, your own domain is there too.
- The sender's domain passes SPF. If a sender's IT has an unusual setup, ask them to check their SPF record, or forward the reports from your own mailbox instead.
- Your forward works: in Microsoft 365, forwarding to outside addresses is allowed for that mailbox (a "550 5.7.520" bounce means it isn't). See Forwarding Email to Journeybee.
- The file is an .xlsx or .csv attachment of 25 MB or less, and the email has 10 attachments or fewer.
An import seems stuck
If an import stays in Processing, open it and click Reprocess.
Good to know
- Files can be .xlsx or .csv, up to 25 MB.
- A report sent again for the same report date replaces that date's figures. The earlier import is marked as replaced.
- Your manual matches are kept when you reprocess.
- See Platform Modules for the Sales reports and Distributor modules, and Distribution Management for distributors.
Related articles
- Forwarding Email to Journeybee: Google Workspace and Microsoft 365 forwarding for emailed reports.
- Custom Fields: the partner field that holds account codes.
- API Keys: sending reports through the API.
- Portal Room Types: the Sales reports room.
- Distribution Management: distributors.
- Platform Modules: the Sales reports and Distributor modules.