Breadcrumbs

SI.BUDGETTURNOVER retrieves positive numbers, while the values in Sage Intacct are negative, and vice versa

Overview

Values entered as positive into an account…

image-20250912-130331.png

… are returned as negative by the SI.BUDGETTURNOVER function (and vice versa).

image-20250912-130653.png

Cause

Depending on whether the Normal balance of an account is set to Debit or Credit, Sage Intacct will return budget values as positive or negative, respectively.

image-20250912-131455.png

Resolution - working with Budgets by Account Balance Type

Budgeting GL Accounts (for Writeback)

  • For accounts whose Normal balance is Credit

    • To budget credit amounts, enter your budget as a positive number.

    • To budget debit amounts, enter your budget as a negative number.

  • For accounts whose Normal balance is Debit

    • To budget credit amounts, enter your budget as a negative number.

    • To budget debit amounts, enter your budget as a positive number.

Retrieving Budget Data (for Reporting/Analysis)

When budgeting GL accounts whose Normal balance is Debit, use the SI.BUDGETTURNOVER function as usual, for instance:

=SI.BUDGETTURNOVER("sage",,"12550","Annual Budget","1/1/2023","12/31/2023")

When budgeting GL accounts whose Normal balance is Credit, add a minus sign - in front of your SI.BUDGETTURNOVER formula, for instance:

=-SI.BUDGETTURNOVER("sage",,12610,"Annual Budget","1/1/2023","12/31/2023")