Exact Financials

ACC_BAL

ACC_BAL (acc_nr,co,FY,period,balance_type,value,calc)

By using this function, you can enter the balance of an account into the worksheet.

Example

ACC_BAL(1300,621,2005,1,1,3,1)

This function calculates the period balance of debtor account 1300, in company 621, financial year 2005, posted in period 1.

Description	Explanation	Value
balance_type	posted amount	1
	entered amount (use 'Update after entry data' to update)	2
	budget amount (use 'Recalculate Finance budget' to update)	4
value	debit total	1
	credit total	2
	balance	3
calc	only selected period used	1
calc	cumulative amount up to and including selected period	2

See also:

[Alphabetical overview of parameters]

Excel Add-in Manual > Contents > Functions > ACC_BAL