Skip to content

Download payroll reports

Payroll & Reporting 11 min readUpdated a week ago

The Reports page: how months are listed, previewing and downloading a month's file, when a month opens, which expenses it holds, which format to pick, and downloading every company in a group at once.

The Reports page lists your approved expenses month by month, ready for payroll. Each month has a row with its total and where it stands. From the row you preview the month's file and download it in your payroll system's format.

Open the page

Select Reports in the HR menu. Only HR can open it. Anyone else is sent back to their own dashboard.

How months are listed

The page shows one year at a time. Use Year at the top to pick another year. The current year shows first. The newest month is at the top. Select the Period heading to turn the order around.

Example
Example. Names and times are made up.
#PartWhat it tells you
1PeriodThe payroll month, and how many expenses it holds so far.
2TotalThe month's total.
3StatusCollecting, Ready or Downloaded, with when it opens or when it was downloaded.
4ButtonPreview so far while the month collects. Download once it is ready.

The list runs month by month from your first approved expense to your latest, with no gaps. So a month with nothing approved can still have a row.

ColumnWhat it shows
PeriodThe month, and how many approved expenses it has, for example 7 expenses. Before the cutoff it says 7 expenses so far. Salary sacrifices are counted on their own, for example 2 salary sacrifices.
TotalWhat the month adds up to: the sum of Pris inklusive moms in the Excel file.
StatusWhere the month stands, with a line under it. See below.
ButtonsPreview and Download, when the month has expenses.
StatusWhat it meansThe line under it
CollectingThe cutoff hasn't passed. New approvals still join the month.When it opens, for example Available 25 Sep, 12:00
ReadyThe cutoff has passed. Nobody has downloaded the file yet.Since when, for example Since 25 Sep, not downloaded
DownloadedSomeone has downloaded the file.Format, who and when, for example Fortnox Lön, Maria Holm, 26 Jul
RebuiltCLVR rebuilt a file someone had downloaded, after a problem you reported.When, and not downloaded yet until someone downloads the new file
No approved expensesThere's nothing to export.Nothing to export

Search finds a month by its name. It also finds people: search an employee's name to list the months they have an expense in.

Preview a month's file

Select Preview on a month's row. The file opens under the row as a spreadsheet, with column letters, row numbers, and the file's own headers and values. Above it you see the format, a summary and when the file was last downloaded. Example summaries: 7 transactions, 6 people for Fortnox Lön, or 1 sheet, 7 rows, 18 columns for Excel.

Use Format to switch between your company's formats. The preview and the download are built the same way, so what you see is what you get.

In the Excel preview, if your company also gets Fortnox Lön, rows the Fortnox file leaves out are marked in orange. That's a purchase paid from salary, or an amount of 0 kr or less. Hover the marked amount to see why.

Before the cutoff, the button says Preview so far. The preview then shows the file as it would be built now. Anything approved before the cutoff joins it, whatever its expense date. From the cutoff, the file is final.

Download a month

1
Select Download on the month's row, or open Preview.
2
Pick your payroll system's format, for example Fortnox Lön or Excel. You only see your company's formats.
3
The button says Downloading while CLVR builds the file.
4
The file opens in a new tab or downloads. The month turns Downloaded, with your name and the date.

If no tab opens, check that your browser isn't blocking pop-ups for CLVR.

CLVR keeps every file it hands over. Download the same month in the same format again, with nothing changed, and you get the same file back.

Report a problem in a file

If something in a file looks wrong, tell CLVR from the preview. Pick the format, select Report a problem, point at a cell, column or row, write your comment and select Send to CLVR. The report then sits above the month's file for everyone in HR, with its reference, such as CLVR-1024, its status and CLVR's answers. See Report a problem in a payroll file.

When a month opens for download

A month opens for download when your payroll cutoff for that month has passed. That gives approvals time to settle first.

Until then, the month is Collecting and Download is greyed out. The line under the status says when it opens, for example Available 25 Sep, 12:00. You can still open Preview so far. Once that time passes, reload the page and the month opens.

Your setupWhen a month opens
A cutoff is savedAt the cutoff you set for that month, moved by your weekend option if it's a Saturday or Sunday.
No cutoff savedOn the 1st of the next month, or the Monday after if the 1st is a weekend. Example: March opens on 1 April.

Set the cutoff on Payroll settings. An earlier day or time opens every month from the next cutoff earlier. See Payroll cutoff settings.

A month with nothing approved shows No approved expenses and has no Preview or Download. It's not waiting to open. There's nothing to build, so it never gets a download.

Which expenses a month holds

A month's file holds:

  • Approved expense reports (uploaded receipts) and approved Benefit Store purchases.
  • The salary deduction on a Benefit Store purchase the allowance didn't pay in full, on a row of its own after the purchase. The Flex HRM file leaves it out. See Salary deductions on Benefit Store purchases.
  • Salary sacrifices to pension, in each month they run.
  • Overused allowance deductions for leavers, once set as a gross or net salary deduction. Each one is in a file only once. See Overused allowance deductions in payroll.

Pending and declined expenses are left out. A file is a snapshot of what was settled, not of everything in progress.

Each approved expense lands in one month, by the moment it was approved or auto-approved:

  • With a cutoff saved: approved before the month's cutoff means that month. Approved at or after the cutoff means the next month.
  • With no cutoff saved: the calendar month it was approved in. An expense approved on the last day of the month stays in that month.
Heads up.

Saving a cutoff for the first time switches from calendar months to cutoff months, from the next cutoff on. Calendar months that have closed keep their expenses.

Choose a format

Every format holds the same approved expenses for the month. Only the layout differs. The amounts and the people never change between formats.

Your payroll systemFormats you get
Most companiesExcel and Fortnox Lön
Flex HRMExcel, Flex HRM (xlsx) and Flex HRM (dta)
KleerExcel, and Review and send to send the month to Kleer
FormatWhat it isUse it to
ExcelAn .xlsx workbook with CLVR's own columns. Opens in Excel, Numbers or Google Sheets.Read and check the amounts per employee.
Fortnox LönA PAXml 2.0 file, the standard Swedish payroll XML. Not a spreadsheet.Import into Fortnox.
Flex HRM (xlsx)The Flex HRM import rows as a workbook, with a header row (Anstnr, Löneartsnr, Belopp and so on).Import into Flex HRM, and read it too.
Flex HRM (dta)The same rows as a tab-separated .dta text file, without the header row.Import into Flex HRM or Aspia.
Tip.

Not sure which Flex HRM file to use? The xlsx is easier to open and check. The dta is the one most imports read. They hold the same data.

Download the same month again

Every download is checked against what the month holds now. If nothing changed since the last download in that format, you get the same stored file. So a closed month doesn't change between downloads.

If something changed, for example a late approval or an expense moved to another category, you get a new file built from the month as it is now. The earlier file is kept. Select History next to Download in the preview to see every file the month has had in that format, who downloaded each one, and when. Older files are marked Replaced. You can still download them, to compare with what you imported.

Each format keeps its own files and history.

Every company in your group at once

Do you run HR for several companies in a group? Your group's pages have Reports too. Open Companies under your group's name in the HR menu, or from the company picker at the top left. Reports is right under Companies in the group's menu.

It lists every company's months on one page, with a Company column and a Company filter. Each row works as on a single company's page. Preview, download, history and problem reports all act on that row's company.

To get one month for every company:

1
Open Reports in your group's menu.
2
Select Download all at the top right of the table.
3
Pick the month. Each month says how many companies are ready, for example 3 of 3 companies ready. You can't pick a month where no company is ready.
4
CLVR downloads one zip with a file per company. Each file is in the format that company's month opens in: the one it was last downloaded as, else Fortnox Lön if the company gets it, else Excel. Each file name starts with the company's name.

Each file counts as that company's download. Its row turns Downloaded, with your name and the date. A company still Collecting is left out, and a message names it. Download its file from its row once it's ready.

Troubleshooting

  • The page isn't in my menu. Reports is for HR only. Ask someone in HR to check that your account has HR access.
  • A month has no Download button. The month shows No approved expenses, so there's nothing to export. Empty months are listed but never get a download.
  • Download is greyed out. The month is still Collecting. Read Available under the status for the day and time. Wait until then and reload the page. The line has a time too, so a month with an early-morning cutoff won't open the evening before. The current month is the one most often greyed out.
  • I need a month sooner. Set an earlier day or time on Payroll settings and save. The change applies from the next cutoff. If this month's new cutoff has already passed, this month keeps its cutoff, and next month opens earlier. Months that have closed keep their expenses.
  • The file downloaded instead of opening in a tab. If CLVR can't reach its stored file for a moment, it builds the file in your browser. It's the same file. It just arrives as a download.
  • A newly approved expense isn't in the file. Check that it's Approved. An approval at or after the cutoff goes into the next month, so look there. If it belongs in this month, download the month again. The new download includes it, and History keeps the file you had before.
  • An expense is missing from one format. Check first that it's an approved expense report or Benefit Store purchase, and in the month you're looking at. If so, the format may leave it out on purpose:
    • It's in Excel but not in Flex HRM. Both Flex HRM files leave out a line with no löneart (pay code) on its category or benefit, or a line of 0 kr or less. Excel lists it anyway. Set the löneart on Benefit settings.
    • A purchase is missing from Fortnox Lön. The Fortnox file leaves out a purchase paid fully from salary, and any line of 0 kr or less. The Excel preview marks those rows in orange. A purchase paid fully from salary still has its salary deduction in the Fortnox file.
    • The amount is smaller than the receipt. Only the amount the allowance covered is in the file. See When a payroll value looks wrong.
  • Some money isn't in any file. That's by design. The part of a receipt above the allowance is the employee's own cost, and the social fee on a BIK purchase is the company's. On Flex HRM, the salary deduction on a Benefit Store purchase isn't in the file either: enter it in Flex HRM yourself.
  • I get the same file even though something changed. The file changes only when the month's rows do. A change that doesn't reach the file, like an expense that moved to the next month or one this format leaves out, gives the same file. Open the preview to see what the month holds now.
  • Something in the file looks wrong. Open the month's preview and use Report a problem. See Report a problem in a payroll file.

See CLVR Benefits with your numbers

Meet one of the founders for 30 minutes. We show you the product and work out what your company would save. If CLVR is not right for you, we will say so.

  1. You send the formIt takes a minute.
  2. We email youWithin one business day, to pick a time.
  3. A 30-minute demoWith one of the founders, on your numbers.

Book a demo

We reply within one business day.

How many employees?

By sending this form you agree to our Privacy Policy and Terms of Service.