Budget Line Import

Overview

The Budget Line Import process read files from ./Incoming/BudgetLines/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/BudgetLines/ before being processed in alphanumeric order.

  • The Chart of Accounts must already exist
  • The Account must already exist for the Chart of Accounts
  • Currency must be active.

Keys

Budgeting Segment and Period are the keys to update an existing budget line. Both keys are needed in order to perform an update.

When specified, the Remaining Budget field will cause the Amount column to be ignored.

Note: When loading lines for the first time, always use the Amount column and do not use the Remaining Budget column.

Notes

Coupa's integrations don't currently provide a way to directly capture outside spend. The appropriate way to capture this change to the budget would be to update the budget to reduce the budget's total amount by the amount of the outside spend. For example: a $5000 budget exists for Account ABC for Fall 2012 with $2000 used for by PO 123 and PO 124. $1000 of budget ABC is spent outside of Coupa. An update to Account ABC's Fall 2012 budget should be made to change the total budget amount from $5000 to $4000 to reflect in Coupa that only $2000 is remaining.

Possible values

Owner Is Approver
1 or 2 (1=on all requisitions, 2=only when budget is exceeded)
Budget Overrun Calculation
1 or 2 (1=Approved, 2=approved and pending requisitions)

Budget

Field NameRequired FieldUnique?Field TypeField DescriptionPossible Values
Budget SegmentYesNoBudget Segment
Chart of AccountsYesNoChart of Accounts Name. Must Exist in Coupa.
Owner (Login)NoNoBudget Owner Login. Must Exist in Coupa
DescriptionNoNoBudget Description
NotesNoNoBudget Notes
Owner Is ApproverNoNoHave Budget Owner Approve things affecting budget
Budget Hard StopNoNoPrevent submission of requisitions that would exceed the budget
Budget Overrun CalculationNoNoUse approved or approved and pending requisitions

Budget Line

Field NameRequired FieldUnique?Field TypeField DescriptionPossible Values
PeriodYesNoBudget Period Name. Must exist in Coupa
Budgeting SegmentNoNoBudgeting Account Code
AmountNoNodecimalTotal Budget Amount
RemainingNoNodecimalBudget Amount Remaining
Pending Requisitions AmountNoNodecimalAmount consumed by pending Requisitions
DescriptionNoNostring(255)Budget Description
NotesNoNotextBudget Notes
OwnerNoNoBudget Owner Login. Must Exist in Coupa
Owner Is ApproverNoNointegerHave budget owner approve things affecting budget. Once the box is checked, update with value of 0 to uncheck. Set to 1 for all requisitions, Set to 2 when budget is exceeded.
Budget Hard StopNoNobooleanPrevent submission of requisitions that would exceed the budget
Budget Overrun CalculationNoNointegerUse this field to calculate budgets against approved requisitions or approved and pending requisitions. 1 for approved, 2 for approved and pending requisitions.
Segment 1NoNostring(100)Budgeting Account Segment 1
Segment 2NoNostring(100)Budgeting Account Segment 2
Segment 3NoNostring(100)Budgeting Account Segment 3
Segment 4NoNostring(100)Budgeting Account Segment 4
Segment 5NoNostring(100)Budgeting Account Segment 5
Segment 6NoNostring(100)Budgeting Account Segment 6
Segment 7NoNostring(100)Budgeting Account Segment 7
Segment 8NoNostring(100)Budgeting Account Segment 8
Segment 9NoNostring(100)Budgeting Account Segment 9
Segment 10NoNostring(100)Budgeting Account Segment 10
Segment 11NoNostring(100)Budgeting Account Segment 11
Segment 12NoNostring(100)Budgeting Account Segment 12
Segment 13NoNostring(100)Budgeting Account Segment 13
Segment 14NoNostring(100)Budgeting Account Segment 14
Segment 15NoNostring(100)Budgeting Account Segment 15
Segment 16NoNostring(100)Budgeting Account Segment 16
Segment 17NoNostring(100)Budgeting Account Segment 17
Segment 18NoNostring(100)Budgeting Account Segment 18
Segment 19NoNostring(100)Budgeting Account Segment 19
Segment 20NoNostring(100)Budgeting Account Segment 20