When Coupa Treasury calculates your account balances, it considers both reported balances from account statements and any balance-relevant cash flows. You can also apply different account settings to configure the calculation and reporting of account balances.
Account settings (new)
Account settings are automatically assigned to every account. Settings are assigned a set of default values when an account is created. To change the settings for any account, find the account in your table, then click the Options button and select Edit.
Choose one of the three options for balance calculation:
- Account – Starting Balance: For a given date, all balance-relevant cash flows (not outdated planning items) with a value date after the starting balance, up to and including the cut-off date, are used to calculate the balance.
- Create Variance Cash Flows: If there is a difference between the available balances in the statement, compared to the available balance calculated by Coupa Treasury, the system will create cash flows to represent the variance.
- Open Available Balance: Either the reported closing balance or the last opening available balance plus reported 2+day floats with dates after that of the last opening available balance, up to and including the cut-off date, plus cash flows with dates within the same range, as well as cash flows from the date of the opening balance. If there was no opening available balance reported, the system takes the last reported closing balance and adds any reported next day float and cash flows.
After you select a calculation method for the account, click Save.
Account balances (new)
On this page, you can review your account balances, as calculated with your configured account settings. When an account is created, the default calculation method is Account – Starting Balance.
In the table on this page, there is a plus sign ( + ) for each row.
Click the plus sign to open the balance calculation drill-down.
To see and manage your forecast and realized cash flows, let's look at Cash Flows.