Exporting planned budget totals
All actual vs planned totals for all budgets and all periods can be
exported manually as a .csv file via the 'Export Budgets' button in the budget section of the app at any time.
This will only export the data for the budgets the user has permission to see based on their role.
Scheduled to be automatically downloaded to an SFTP server. Read more here
The columns included in the csv file are:
Budget name (name and period)
Budget managers
Net / Gross (how the expense amounts are calculated)
Budgeted (how much was planned for this period)
Spent (how much is already spent for this period)
Upcoming (how much has been committed to but not yet spent)
Link (a link to the full budget details and allocated expenses in moss)
Exporting budget transactions
All expenses and requests allocated to budgets can be
downloaded manually from the ‘drawer’ of the specific budget and period you’re interested in.
Scheduled to be automatically downloaded to an SFTP server. (read more here)
The columns included in the csv file are:
Budget allocation date
Merchant Name
Supplier name
Debit amount
Credit amount
Moss currency code
Debit amount in original currency
Credit amount in original currency
Original currency code
Conversion rate
Supplier account
Submitter
Link to trx
Booking texts
Team
Cost center names
Cost center numbers
Cost carrier names
Cost carrier numbers
Expense account names
Expense account numbers
VAT names
VAT rates
VAT codes
Transaction type
Budget commitment
Payment date
Due date
Invoice date
Delivery date
Service period - Start
Service period - End
Creation date
Transaction date
Card holder
Amount Type
ID