ARBALANCE function

Returns balance of accounts receivable at end of each month(s) from start month

Syntax

The ARBALANCE function syntax has the following arguments

  • Total_billings     Required.    Array.    Total amount of billings during each month(s). Note: By default, this function will return a row of values for the same number of columns that you select for this input. Please make sure that adjacent cells do not have any other content. Add the month_numner input in this function if you need this value for a specific month (and not for all months).

  • AR_days     Required.    Number.    Number of days that you give customers to pay

  • Month_number     Optional.    Number.    Month for which this value is required. Leave this blank (no input) if you need values for the same number of months as the input array. Input value must be integer >=1. For example, enter 6 if you'd like this value for month 6. Note: value will be returned for specified month only if you enter a value.