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

Budget Line