Guide from the old report to the new one

If you used the old settlement report and are moving to the new one, this guide is for you. If you want every detail of how the new report works, see Understand the Settlement report. The new report is available in xlsx and csv formats. This article focuses on the xlsx version, which consists of two sheets: Summary and Details. The csv is identical to the Details sheet.

Start in the Summary sheet

If you normally look for the payout rows in the old report, begin in the Summary sheet now. The rows there closely match the payout rows you're used to. This is the first place to go to find a particular payout, match it to your bank statement, and get a quick understanding of the payments, refunds and fees that led to the payout. Note that the Summary sheet has a row per Sales unit and Booking date, which shows totals of all the activity on that day. It doesn't have one row per payout, although for daily payouts this will in practice often be the same. Each row also shows some things that weren't in the old report:

• Remaining balance, so you can see money carried forward if the day didn't have a payout
• Fee status, so you can see whether fees were Retained or Invoiced
• Other, for less common entries (all possible types listed here)

If your sales unit has weekly or monthly payouts, there will be days with no payouts and an increasing Remaining balance. You can sum over the days between the previous payout and the current one to see that the numbers add up. The table has a Total row at the bottom that reacts to column filtering to help you with this.

Then use the Details sheet

In the old report, transactions contained in a payout were displayed on the lines above the payout in the same sheet. In the new report, the detailed information about each transaction has moved to the Details sheet. Where the old report was often read as "these transactions belong to this payout", the new Details sheet is easier to read as a chronological balance timeline, where:

• Each row changes the balance
• The Balance column shows the balance afterwards
• Payout scheduled shows when money was drawn from the balance for payout

So if you want to see the transactions behind a payout, find the Payout scheduled row and then read the rows above it, back to the previous Payout scheduled row. To quickly locate a payout, search (Ctrl+F / ⌘+F) for the payout reference from your bank statement.

Amount should be read together with Type

In the Details sheet, the same Amount column is used for different kinds of rows. That means you often want to filter on Type before you sum amounts - or, even better, use a pivot table.

How we display Fees

The Fee column shows the fee calculated for each capture. Special Fees retained rows show when the fees were actually deducted from the balance. Normally, the total fees for a day are deducted in one entry at the end of the day.

Finding the values you’re used to

These are the closest matches to the values you're used to from the old report:

• Oppgjørssum
  • Summary sheet -> Payout column
  • Details sheet -> Amount column on a payout row
• Oppgjørs-ID
  • Summary sheet -> Normally part of the Payout reference
  • Details sheet -> Payout number on a payout row
• Oppgjørsdato
  • Summary sheet -> Booking date for a day with a payout
  • Details sheet -> Booking date on a payout row
• Oppgjørskonto
  • Summary sheet -> Scheduled payout date for a day with a payout
  • Details sheet -> Scheduled payout date on a payout row
• Transasksjons-ID
  • Details sheet -> PSP reference
• Ordre-ID
  • Details sheet -> Order ID/Reference
• Brutto
  • Details sheet -> Amount
• Gebyr
  • Details sheet -> Fee
• Netto
  • Details sheet -> Net amount
• Transaksjonstype
  • Details sheet -> Type
• Fornavn/Etternavn
  • Details sheet -> Customer name

The csv format

The csv version of the new report is equal to the Details sheet in the xlsx version. It doesn't include the xlsx sheet. Technical details:

• Comma is used as the separator
• Period is used for decimals
• Text fields, such as the Message column, are surrounded by quotes when needed, for example if they contain commas, quotes or line breaks.

Example files can be found here.

The xml format

The old xml format is not supported by the new report.

The old PDF Settlement report

The old PDF Settlement report has been replaced by the Period report.