ACCOUNTBEGINNINGBALANCE function

Created by Harry Lewis, Modified on Tue, 28 May 2024 at 12:23 PM by Harry Lewis

Applies to

  • Velixo Classic

  • Velixo NX

  • Acumatica, MYOB Advanced, Cegid XRP Flex

  • GL Module

 

Description

The ACCOUNTBEGINNINGBALANCE function calculates the beginning or opening balance of one or more general ledger accounts, for a specific period.


Some organizations refer to this as the Period Beginning Balance or Period Opening Balance for an account.


 

TABLE OF CONTENTS

 

Syntax

ACCOUNTBEGINNINGBALANCE(Connection, Ledger, AccountClass, Account, Subaccount, Branch, AsOf, IncludeUnposted, UseMasterFinancialCalendar)

 

Parameters

The ACCOUNTBEGINNINGBALANCE function uses the following parameters


Parameter

Required/Optional

Description

Connection

Required

The name of the connection, as specified in the Connection Manager

Ledger

Required

Ledger to use in the calculation.

AccountClass

Optional, though required if Account is empty

The account class to use for the calculation.

Account

Optional, though required if AccountClass is empty

The general ledger account(s) to use for the calculation.

Subaccount

Optional

The general ledger subaccounts(s) to include.

Branch

Optional

The branch(es) to include.

AsOf

Required

The financial period, in MM-YYYY format

or

a date in a valid Excel format

IncludeUnposted

Optional

1 - Include posted transactions only (default)

2 - Include Unposted transactions only

3 - Include Posted and Unposted transactions

(notes: 

  • Transactions with a status of "On Hold" are excluded. When Unposted transactions are included, the following two statuses are included: Balanced, Unposted
  • If a document is still in the AR module (e.g., Invoice), the corresponding GL batch has not yet been created, thus the balance for that document will not be reflected).

Excel for Windows allows the use of quotation marks around this parameter.  Excel for Mac and Excel Online require that it be unquoted.

Use Master Financial CalendarOptionalUse Acumatica's Master Financial Calendar instead of the financial calendar defined within the specific tenant associated with the connection being accessed (this can be useful for consolidation reports).

Possible values:
  • True
  • False (default)


Note: This feature requires that your ERP license include Multi-Calendar Support and that our ERP be configured for that feature

 

(see our articles on Filtering Velixo Functions and using arrays or cell ranges as parameters)

 


Examples

Based on this data:

 

sampledata.png



Example 1

  =ACCOUNTBEGINNINGBALANCE("Demo", "ACTUAL", , $B6,,, $G$1)

 

Description: Calculates the beginning balance of posted transactions to General Ledger account # 10200 (as noted in cell B6) as of the beginning of Period 1 for the year 2019 (as noted in cell G1).

 

Result: 43,925,384

 

beg_bal_period.png



Example 2

  =ACCOUNTBEGINNINGBALANCE("Demo", "ACTUAL", , $B9,,, C$4, 3)

 

Description: Calculates the beginning balance of combined posted and unposted transactions to General Ledger account #10800 (as noted in cell B9) for as of January 1, 2019 (as noted in cell C4).

 

Result: 4,454,986

 

 



Limitations to filtering by date instead of financial period:


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article