Balance

The follow functions return the Balance such as by the Parameter Client, Code, Date and Cost Center.

TopalBaeBalance("Code")

This Function returns the balance of the account or group based on a given Code.

Function call:
=TopalBaeBalance("1000") or =TopalBaeBalance("CellNo.")

Example:

Figure 1: return balance of the account

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalanceByClient("Client";"Code")

This Function returns the balance of the account or group based on a given Client and Code.

Function call:
=TopalBaeBalanceByClient("Mon Bijou AG";"1000") or =TopalBaeBalanceByClient("Client";"CellNo.")

Example:

Figure 2: return balance of the account by client

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalanceByDate("code";"date")

This Function returns the balance of the account or group based on a given Code and Date.

Function call:
=TopalBaeBalanceByDate("1000";"01.04.2016") or =TopalBaeBalanceByDate("CellNo.";"01.04.2016")

Example:

Figure 3: return balance of account by date

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalanceByClientDate("Client";"Code";"Date")

This Function returns the balance of the account or group based on a given Clientname, Code and Date.

Function call:
=TopalBaeBalanceByClientDate("Mon Bijou AG";"1000";"01.04.2016") or =TopalBaeBalanceByClientDate("Client";"CellNo.";"Date")

Example:

Figure 4: return balance of account by client and date

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalCcByDate("Code";"Cost Center";"Date") [in progress]

This Function returns the balance of the account or group based on a given Code, Cost Center and Date.

Function call:
=TopalBaeBalanceByDate("1000";"Bern";"01.04.2016") or =TopalBaeBalanceByDate("CellNo.";"Cost Center";"Date")

Example:

Figure 5: return balance of account by cost center and date

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalCcByClientDate("Client";"Code";"Cost Center";"Date") [in progress]

This Function returns the balance of the account or group based on a given Clientname, Code, Cost Center and Date.

Function call:
=TopalBaeBalCcByClientDate("Mon Bijou AG";"1000";"Bern";"01.04.2016") or =TopalBaeBalCcByClientDate("Client";"CellNo.";"Cost Center";"Date")

Example:

Figure 6: return balance of account by client, cost center and date

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalanceByDates("code";"dateFrom";"dateUntil")

This Function returns the balance of the account or group based on a given Code and Date range.

Function call:
=TopalBaeBalanceByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeBalanceByDates("CellNo.";"01.04.2016";"30.04.2016")

Example:

Figure 7: return balance of account by daterange

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalanceByClientDates("Client";"Code";"DateFrom";"DateUntil")

This Function returns the balance of the account or group based on a given Clientname, Code and Date range.

Function call:
=TopalBaeBalanceByDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeBalanceByDates("Client";"CellNo.";"DateFrom";"DateUntil")

Example:

Figure 8: return balance of account by client and daterange

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalCcByDates("Code";"Cost Center";"DateFrom";"DateUntil") [in progress]

This Function returns the balance of the account or group based on a given Code, Cost Center and Date range.

Function call:
=TopalBaeBalCcByDates("1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeBalCcByDates("CellNo.";"Cost Center";"DateFrom";"DateUntil")

Example:

Figure 9: return balance of account by cost center and daterange

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalCcByClientDates("Client";"Code";"Cost Center";"DateFrom";"DateUntil") [in progress]

This Function returns the balance of the account or group based on a given Clientname, Code, Cost Center and Date range.

Function call:
=TopalBaeBalCcByDates("Mon Bijou AG";"1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeBalCcByDates("Client";"CellNo.";"Cost Center";"DateFrom";"DateUntil")

Example:

Figure 10: return balance of account by client, cost center and daterange

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.