Skip to main content

CSV field reference and customization tips

A
Written by Anna Dziurosz
Updated this week

When building a CSV export in Moss, you'll be asked to select fields from a list.

This guide covers:

  • Which fields are available for each export type (e.g. card transactions vs invoices)

  • How to apply light customizations like renaming values or combining fields

  • How to change Credit/Debit indicators

Field overview by export/spend type

Card transaction export fields

Field Group

Field Name

Description

Transaction Basics

Type

Type of the record (CREDIT or DEBIT)

Transaction Basics

Transaction Ordinal

CSV file internal order number for transactions. It will number each transaction

Transaction Basics

Row Number

Position of the entry in the export file

Transaction Basics

Sub-row Number

Used for splitting transactions into multiple lines

Transaction Basics

Sub Item Row Number

Sub-identification for distributed or itemized lines

Transaction Basics

Transaction State

Status of the transaction (e.g. posted, pending)

Transaction Basics

Transaction ID

Unique ID assigned in Moss to the transaction

Transaction Basics

Transaction ID PDF filename

File name tied to the transaction for export

Transaction Basics

Record Type

Classifies the entry as a booking line, header, or other type

Transaction Basics

Unique Item Number

Used to track split lines or entries across rows

Dates & Periods

Payment Date

Date the payment was made

Dates & Periods

Booking Date

Date the transaction was booked for accounting

Dates & Periods

Settlement Date

Date the transaction was settled

Dates & Periods

First Export Date

The first time this transaction was exported

Dates & Periods

Month end date

Last date of the accounting month the transaction falls into

Dates & Periods

Period

Accounting period label

Dates & Periods

Period YYYY/MM

Period in YYYY/MM format

Amounts & Currency

Amount

Transaction total in Moss default currency

Amounts & Currency

Amount Negated

Same amount but negative for credit-type entries

Amounts & Currency

Amount Debit

Debit value of the transaction

Amounts & Currency

Amount Credit

Credit value of the transaction

Amounts & Currency

Amount (excl. VAT)

Net amount, excluding VAT

Amounts & Currency

Amount (excl. VAT) Negated

Net amount, negative for credit-type entries

Amounts & Currency

Amount Debit (excl. VAT)

Net debit value

Amounts & Currency

Amount Credit (excl. VAT)

Net credit value

Amounts & Currency

VAT

VAT amount

Amounts & Currency

VAT Negated

Negative VAT amount for credit entries

Amounts & Currency

Currency

Transaction currency

Amounts & Currency

Original Amount

Amount in original currency

Amounts & Currency

Original Amount Negated

Negative value in original currency

Amounts & Currency

Original Amount Debit

Debit in original currency

Amounts & Currency

Original Amount Credit

Credit in original currency

Amounts & Currency

Original Amount (excl. VAT)

Net amount in original currency

Amounts & Currency

Original Amount (excl. VAT) Negated

Negative net in original currency

Amounts & Currency

Original Amount Debit (excl. VAT)

Original net debit

Amounts & Currency

Original Amount Credit (excl. VAT)

Original net credit

Amounts & Currency

Original VAT

Original VAT amount

Amounts & Currency

Original VAT Negated

Negative VAT in original currency

Amounts & Currency

Original Currency

Currency in which transaction was made

Amounts & Currency

Conversion Rate

Currency exchange rate

Amounts & Currency

Conversion Rate Including Fees

Exchange rate including foreign currency fees

Amounts & Currency

Transaction Amount Excluding Fees

Amount before fees

Amounts & Currency

Fees Amount

Transaction fee amount

Merchant & Supplier

Merchant Name

Name of the vendor or merchant

Merchant & Supplier

Merchant and Card Description

Combined merchant and card details

Merchant & Supplier

Merchant City

City where transaction occurred

Merchant & Supplier

Merchant Country

Country where transaction occurred

Merchant & Supplier

Card Acceptor Name

Card merchant name in issuer system

Merchant & Supplier

Supplier Name

Name of the vendor or supplier

Merchant & Supplier

Supplier Account

Code used to identify supplier in accounting system

Merchant & Supplier

Invoice Number

Supplier invoice reference

Merchant & Supplier

Invoice File Name

Name of invoice file attached

Accounting & Categorization

Account Debit/Credit

GL account used for booking

Accounting & Categorization

Account Debit/Credit Reverse

Reverse entry account if dual-booking is used

Accounting & Categorization

Account Number

Mapped accounting code or number

Accounting & Categorization

Name of expense account

Label or name of the expense category

Accounting & Categorization

Category

Moss expense category

Accounting & Categorization

Cost Center - Name

Cost center label

Accounting & Categorization

Cost Center - Number

Cost center code

Accounting & Categorization

Cost Carrier - Name

Project or carrier name

Accounting & Categorization

Cost Carrier - Number

Project or carrier code

Accounting & Categorization

CUSTOMER GROUP - Customer G Name

Customer group name (if applicable)

Accounting & Categorization

CUSTOMER GROUP - Customer G Value

Customer group ID or value

Accounting & Categorization

VAT Name

Tax code label

Accounting & Categorization

VAT Rate

Tax percentage

Accounting & Categorization

VAT Code

Internal tax code

Accounting & Categorization

Moss Balance Account

Moss-side balance mapping

Accounting & Categorization

Cash In Transit Account

Mapping account for in-transit payments

Accounting & Categorization

Distribution combination

Encoded string for mapped distribution

Employee & Internal Info

Cardholder

Employee who made the transaction

Employee & Internal Info

Card Used

ID or name of the card used

Employee & Internal Info

Card Purpose

Purpose linked to this card (if configured)

Employee & Internal Info

Card Holder Label

Configured label for cardholder

Employee & Internal Info

Card Holder Name

Name of cardholder

Employee & Internal Info

Card Label

Label assigned to the card

Employee & Internal Info

Card Name

Card name or identifier

Employee & Internal Info

Note

Note left on the transaction

Employee & Internal Info

Reason for Purchase

Cardholders explanation or purpose

Employee & Internal Info

Team Name

Internal team name

Employee & Internal Info

Client Number

Client code if mapped

Employee & Internal Info

Post Spend Approval Status

Status of post-spend approval (if enabled)

Links & Attachments

Moss Record URL

Direct link to view the transaction in Moss

Links & Attachments

Moss Attachment URL

Link to invoice or receipt file

Air Travel & Itemization

Airline Ticket Number

Ticket number for travel-related expenses

Air Travel & Itemization

Unit Price

Per unit cost for itemized spend

Air Travel & Itemization

Quantity

Number of units

Air Travel & Itemization

% of Total

Percentage split of transaction total

Invoice export fields

Field Group

Field Name

Description

Invoice Basics

Ordinal

Internal sequence number of the invoice record

Invoice Basics

Row Number

Position of the entry in the export file

Invoice Basics

Sub-row Number

Used for splitting invoice into multiple rows

Invoice Basics

Sub Item Row Number

Detailed breakdown row number

Invoice Basics

Invoice Status

Current status of the invoice

Invoice Basics

Invoice ID

Unique Moss ID for the invoice

Invoice Basics

Invoice ID PDF filename

File name of the invoice PDF

Invoice Basics

Invoice Number

Reference number on the invoice

Invoice Basics

Record Type

Type of record (e.g. invoice line, summary)

Invoice Basics

Type

Type classification of the invoice record

Amounts & Currency

Amount

Total invoice amount

Amounts & Currency

Amount Negated

Negative value of the amount for reversal

Amounts & Currency

Net Amount

Amount before VAT

Amounts & Currency

Net Amount Negated

Negative net amount for reversal

Amounts & Currency

Vat Amount

VAT portion of the invoice

Amounts & Currency

Vat Amount Negated

Negative VAT amount

Amounts & Currency

Currency

Invoice currency

Amounts & Currency

Amount in Home Currency

Invoice amount converted to home currency

Amounts & Currency

Home Currency

Home currency for reporting

Amounts & Currency

Conversion Rate

Currency exchange rate used

Dates

Submitted Date

Date the invoice was submitted

Dates

Due Date

Payment due date

Dates

Net Due Date

Due date after discounts

Dates

Delivery Date

Goods/service delivery date

Dates

Invoice Date

Date on the invoice

Dates

Payment Date

Date the invoice was paid

Dates

Last Export Date

Most recent date the invoice was exported

Dates

Last reviewed

Date the invoice was last reviewed

Dates

Discount 1 due date

Due date to qualify for first discount

Dates

Discount 2 due date

Due date to qualify for second discount

Accounting & Categorization

Moss Balance Account

Account used for balancing entries

Accounting & Categorization

Category

Mapped category for accounting

Accounting & Categorization

Expense Account - Number

GL account code

Accounting & Categorization

Expense Account - Name

Name of the expense account

Accounting & Categorization

VAT Name

Label for VAT type

Accounting & Categorization

VAT Rate

Percentage rate of VAT

Accounting & Categorization

VAT Code

Accounting code for VAT

Accounting & Categorization

Distribution combination

Distribution key string

Accounting & Categorization

Account Debit/Credit

Main account used for debit or credit

Accounting & Categorization

Account Debit/Credit Reverse

Reverse entry account (if used)

People & Teams

Submitted By

Employee who submitted the invoice

People & Teams

Team Name

Team responsible for the invoice

People & Teams

Verifier Names

Names of all verifiers

People & Teams

Verified By Name

Final person who approved the invoice

People & Teams

Reviewed by

Person who last reviewed the invoice

Supplier & Payment Details

Supplier Name

Name of the vendor or supplier

Supplier & Payment Details

Supplier Number

Suppliers unique ID

Supplier & Payment Details

Supplier Vat ID

VAT ID of the supplier

Supplier & Payment Details

Supplier IBAN

Bank account number of the supplier

Supplier & Payment Details

Supplier BIC

Bank identifier code of the supplier

Supplier & Payment Details

Invoice File Name

Name of the invoice file

Supplier & Payment Details

Invoice Payment Status

Status of invoice payment

Supplier & Payment Details

Payment term - Number

Configured number of days for payment

Supplier & Payment Details

Payment term - Description

Label or terms description

Cost Centers & Projects

Cost Center - Name

Cost center name

Cost Centers & Projects

Cost Center - Number

Cost center code

Cost Centers & Projects

Cost Carrier - Name

Project or cost carrier name

Cost Centers & Projects

Cost Carrier - Number

Project or cost carrier code

Cost Centers & Projects

CUSTOMER GROUP - Customer G Name

Customer group name

Cost Centers & Projects

CUSTOMER GROUP - Customer G Value

Customer group ID or tag

References & Linking

PR Number

Purchase request number

References & Linking

PO Number

Purchase order number

References & Linking

Client Number

Client code or identifier

References & Linking

Moss Record URL

Link to view the invoice in Moss

References & Linking

Moss Attachment URL

Link to view the invoice attachment

Discounts

Discount 1 percentage

Percentage for early payment discount 1

Discounts

Discount 2 percentage

Percentage for early payment discount 2

Reimbursement export fields

Field Group

Field Name

Description

Reimbursement Basics

Type

Type classification of the record

Reimbursement Basics

Reimbursement Ordinal

Sequence number for reimbursement entry

Reimbursement Basics

Row Number

Position of the entry in the export file

Reimbursement Basics

Sub-row Number

Used for breaking a record into multiple lines

Reimbursement Basics

Sub Item Row Number

Detail or sub-entry row number

Reimbursement Basics

Unique Reimbursement ID

ID assigned to the reimbursement

Reimbursement Basics

Unique Reimbursement ID PDF filename

File name of the reimbursement PDF

Reimbursement Basics

Unique Expense ID

ID assigned to the individual expense

Reimbursement Basics

Record Type

Classification of the line (e.g. item, total)

Reimbursement Basics

Distribution combination

Distribution string for accounting

Reimbursement Basics

Unique Item Number

Tracking number for the entry row

Dates & Periods

Submitted on

Date the reimbursement was submitted

Dates & Periods

Purchased on

Date the purchase was made

Dates & Periods

Payment Date

Date reimbursement was paid

Dates & Periods

Creation date

Date the reimbursement record was created

Amounts & Currency

Currency code

Currency used in the transaction

Amounts & Currency

Amount

Total amount reimbursed

Amounts & Currency

Amount Negated

Negative of the amount (for credits)

Amounts & Currency

Amount (excl. VAT)

Amount before VAT

Amounts & Currency

Amount (excl. VAT) Negated

Negative of net amount

Amounts & Currency

VAT

Value-added tax amount

Amounts & Currency

VAT Negated

Negative VAT amount

Amounts & Currency

Original Currency

Original transaction currency

Amounts & Currency

Amount in original currency

Value in original currency

Amounts & Currency

Amount in original currency negated

Negative of the original amount

Amounts & Currency

Conversion rate

Exchange rate to home currency

Accounting & Categorization

Moss Balance Account

Balance account for Moss side

Accounting & Categorization

Name of expense account

Label or name of the category

Accounting & Categorization

Expense account

Mapped expense category or GL code

Accounting & Categorization

VAT Name

Label of VAT code used

Accounting & Categorization

VAT Rate

Tax rate percentage

Accounting & Categorization

VAT Code

Code used for accounting system

Accounting & Categorization

Cost Center - Name

Cost center label

Accounting & Categorization

Cost Center - Number

Cost center code

Accounting & Categorization

Cost Carrier - Name

Project or cost unit name

Accounting & Categorization

Cost Carrier - Number

Project or cost unit code

Accounting & Categorization

CUSTOMER GROUP - Customer G Name

Customer group name

Accounting & Categorization

CUSTOMER GROUP - Customer G Value

Customer group value or tag

Accounting & Categorization

Client Number

Client-specific code or ID

People & Teams

Submitted by

Employee who submitted the expense

People & Teams

Team Name

Team responsible for the expense

People & Teams

User IBAN

IBAN of the reimbursed employee

People & Teams

User BIC

Bank identifier code of the employee

Supplier & Travel Info

Supplier Name

Vendor listed in the expense

Supplier & Travel Info

Supplier account

Supplier ID or code

Supplier & Travel Info

Supplier IBAN

Supplier's bank account number

Supplier & Travel Info

Supplier BIC

Supplier's bank code

Supplier & Travel Info

Trip Type

Classification of the travel (if applicable)

Supplier & Travel Info

Distance Unit

Unit used for mileage (e.g. km, miles)

Supplier & Travel Info

Distance In Unit

Recorded distance

Supplier & Travel Info

Vehicle Type

Type of vehicle used for travel

Descriptions & Labels

Combined Description

Merged description from multiple fields

Descriptions & Labels

Reimbursement Description

Label or title of the reimbursement

Descriptions & Labels

Expense Description

Free-text description of the purchase

Descriptions & Labels

Reimbursement Name

Name given to reimbursement

Descriptions & Labels

Expense Name

Name assigned to expense item

Descriptions & Labels

Attached File Name

Name of the uploaded file

Links & References

Moss Record URL

Link to view the record in Moss

Links & References

Moss Attachment URL

Link to the attached receipt or invoice

Links & References

Reimbursement Payment Status

Status of the reimbursement payment

Balance movements export fields

Field Group

Field Name

Description

Transaction Basics

Transaction Ordinal

Internal order number for sorting transactions

Transaction Basics

Row Number

Position of the entry in the export file

Transaction Basics

Sub-row Number

Used for splitting transactions into multiple lines

Transaction Basics

Transaction ID

Unique ID assigned to the transaction

Transaction Basics

Transaction State

Status of the transaction (e.g. posted, pending)

Transaction Basics

Transaction Type

Indicates whether it’s a card transaction, reimbursement, invoice, etc.

Transaction Basics

Record Type

Classifies the entry as a booking line, header, or other type

Dates & Periods

Payment Date

Date the payment was made

Dates & Periods

Booking Date

Date the transaction was booked for accounting

Dates & Periods

First Export Date

The first time this transaction was exported

Dates & Periods

Month end date

Last date of the accounting month the transaction falls into

Dates & Periods

Period

Accounting period label with format 2025-05

Dates & Periods

Period YYYY/MM

Period in YYYY/MM format

Amounts & Currency

Amount

Transaction total in Moss default currency

Amounts & Currency

Amount Negated

Amounts & Currency

Amount Debit

Debit value of the transaction

Amounts & Currency

Amount Credit

Credit value of the transaction

Amounts & Currency

Amount (excl. VAT)

Net amount, excluding VAT

Amounts & Currency

Amount (excl. VAT) Negated

Net amount, negative for credit-type entries

Amounts & Currency

Amount Debit (excl. VAT)

Net debit value

Amounts & Currency

Amount Credit (excl. VAT)

Net credit value

Amounts & Currency

Currency

Currency used in the transaction

Amounts & Currency

Original Amount

Amount in original currency

Amounts & Currency

Original Amount Negated

Negative value in original currency (for credits)

Amounts & Currency

Original Amount Debit

Debit value in original currency

Amounts & Currency

Original Amount Credit

Credit value in original currency

Amounts & Currency

Original Amount (excl. VAT)

Net original amount

Amounts & Currency

Original Amount (excl. VAT) Negated

Negative net value in original currency

Amounts & Currency

Original Amount Debit (excl. VAT)

Net original debit amount

Amounts & Currency

Original Amount Credit (excl. VAT)

Net original credit amount

Amounts & Currency

Original Currency

The currency the transaction was originally made in

Amounts & Currency

Conversion Rate

Exchange rate used to convert original to Moss base currency

Amounts & Currency

Conversion Rate Including Fees

Conversion rate including foreign currency fees

Amounts & Currency

Transaction Amount Excluding Fees

Amount before payment or currency conversion fees

Amounts & Currency

Fees Amount

Amount of fees applied by bank/payment provider

Amounts & Currency

Payment Fee

Fee associated with the transaction (card/bank)

Accounting & Categorization

Account Debit/Credit

GL account used for booking

Accounting & Categorization

Account Debit/Credit Reverse

Reverse entry account if dual-booking is used

Accounting & Categorization

Account Number

Moss internal or mapped expense account code

Accounting & Categorization

Name of expense account

Name/label of the expense category (e.g. Travel)

Accounting & Categorization

Category

Moss-level expense category

Supplier & Internal Team Data

Supplier Name

Name of the vendor or supplier

Supplier & Internal Team Data

Supplier Account

Code used to identify supplier in accounting system

Supplier & Internal Team Data

Cardholder

Name of employee who made the transaction

Supplier & Internal Team Data

Reason for Purchase

Free-text reason given by the cardholder or submitter

Supplier & Internal Team Data

Team Name

Moss team or department linked to the transaction

Supplier & Internal Team Data

Client Number

Optional client ID if mapped

Supplier & Internal Team Data

Moss Balance Account

Internal mapping account for the Moss platform

Supplier & Internal Team Data

Cash In Transit Account

Optional balance account used for timing differences

Linked Documents & References

Invoice Number

Invoice reference, if linked

Linked Documents & References

Linked Invoice ID

Internal Moss ID for connected invoice

Linked Documents & References

Linked Reimbursement ID

ID for linked reimbursement entry

Linked Documents & References

Moss Attachment URL

Direct link to download the PDF invoice or receipt

Linked Documents & References

Payment Reference

Reference text shown on the bank/card payment

Linked Documents & References

Recipient Account Number

Supplier or payees IBAN or account number

Linked Documents & References

Recipient Bank Code

Bank code of the supplier/payee (if available)

Linked Documents & References

Unique Item Number

Used to track split lines or entries across rows

Prepayment export fields

Field Group

Field Name

Description

Prepayment Basics

Release ID

Identifier for the prepayment release record

Prepayment Basics

Original Item ID

Original item ID the release is linked to

Prepayment Basics

Original Sub-Item ID

Sub-line identifier for the original item

Prepayment Basics

Record Type

Type of entry, such as booking or release line

Amounts & Currency

Amount

Amount released from prepayment

Amounts & Currency

Currency

Currency in which the prepayment was made

Amounts & Currency

Conversion Rate

Exchange rate used for conversion to home currency

Accounting & Categorization

Expense account

GL account for the expense booking

Accounting & Categorization

Deferred Cost Account

Account used for deferring the cost

Accounting & Categorization

Cost Center - Number

Cost center code associated with the transaction

Accounting & Categorization

Cost Carrier - Number

Project or cost unit code

Invoice & Dates

Invoice Number

Invoice number associated with the prepayment

Invoice & Dates

Release Date

Date the prepayment was recognized

Notes

Note

Any notes or comments linked to the release entry


Light Customization with Scripted Fields

You can use custom formulas in the CSV Builder to tweak field values or create new ones based on logic. Here are a few simple examples:

Merge Two Fields

If you need a value to be the combination of two, or more fields, you can set this in the UI.

All you need to do is use the formula as described below and use the database names for the fields you want to merge.

You can find a mapping of most commonly used fields in the chapter “Field overview by export/spend type

Goal: Combine “Merchant Name” and “Cardholder Name” into one column:

Select the field in your CSV template that should hold the new value, name it and in the data source select “CUSTOM VALUE”.

Then use this formula in the value column, add the field names you need added.

  • ${fieldName1} and ${fieldName2}

Output: You see the name of the merchant and cardholder in the same field in column “A”.

You can merge an unlimited number of fields (but do you really need to?) and remove or change the “and” in between the field brackets.


Rename Credit/Debit Indicators

Note: Only for Transactions and Invoice

If your accounting system requires different labels for credit and debit transactions, please reach out to us at support@getmoss.com, as this change can’t be made directly in the Moss UI.

By default, our exports use:

  • Credit - for credit transactions

  • Debit - for debit transactions

If you need different values (for example, C and D, or + and –), just reach out to our Support team. Let us know:

  • The values you’d like to use for credit and debit

  • The name of the CSV template you’d like this applied to

We’ll update it for you and let you know when it’s ready to test.


Things to Keep in Mind

  • Field availability depends on the module — not all fields appear across all export types, or may have different names.

  • Preview your template to check that your merged/custom columns look as expected.

  • Keep it simple. CSV exports are much more successful if you keep it focused, clean, and limited to only the fields your accountant actually needs — the fewer columns, the fewer things can go wrong.

  • Not sure which fields to include? Don’t worry — start with our preset template called “Generic CSV.” It includes all available fields, so you can test your export and see everything that’s possible. Once you know which fields your accounting team actually needs, you can simply remove the rest.

Need Help Customizing?

Let us know what format your accountant needs, and we’ll guide you on which fields to select or how to format your export correctly.

Did this answer your question?