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