Mirror accounts
These function return name, code, type, balance, budget, budget cf of mirror account.
This Function returns the name of a mirror account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Is an account defined as mirror account, the respective name will be returned.
Function call :
=TopalBaeMirrorName("1020") or =TopalBaeMirrorName("CellNo.")
Figure 1: mirror account
Example:
Figure 2: return name of mirror account
Error Message:
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
This Function returns the name of a mirror account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Is an account defined as mirror account, the respective name will be returned.
Function call :
=TopalBaeMirrorNameByClient("Mon Bijou";"1021") or =TopalBaeMirrorNameByClient("Clientname";"CellNo.")
Figure 3: Topal COA
Example:
Figure 4: Mirror Account Name
Error Message:
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
This Function returns the second name of a mirror account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Is an account defined as mirror account, the respective name will be returned.
Function call :
=TopalBaeMirrorName2("1020") or =TopalBaeMirrorName2("CellNo.")
Figure 5: Topal COA
Example:
Figure 6: Mirror Account Name 2
Error Message:
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
This Function returns the second name of a mirror account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Is an account defined as mirror account, the respective name will be returned.
Function call:
=TopalBaeMirrorName2ByClient("Mon Bijou";"1021") or =TopalBaeMirrorName2ByClient("Clientname";"CellNo.")
Figure 7: Topal COA
Example:
Figure 8: Mirror Account Name 2
Error Message:
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
This Function returns the name of a mirror parent account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Is an account defined as mirror account, the respective name will be returned.
Function call :
=TopalBaeMirrorParentCode("1000") or =TopalBaeMirrorParentCode("CellNo.")
=TopalBaeMirrorParentCode("1000") or =TopalBaeMirrorParentCode("CellNo.")
Example:
Figure 9: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the name of a mirror parent account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Is an account defined as mirror account, the respective name will be returned.
Function call:
=TopalBaeMirrorParentCodeByClient("Mon Bijou AG";"1000") or =TopalBaeMirrorParentCodeByClient("Client";"CellNo.")
=TopalBaeMirrorParentCodeByClient("Mon Bijou AG";"1000") or =TopalBaeMirrorParentCodeByClient("Client";"CellNo.")
Example:
Figure 10: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the code type of a mirror account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Is an account defined as mirror account, the respective name will be returned.
Function call :
=TopalBaeMirrorCOATypeCode("1020") or =TopalBaeMirrorCOATypeCode("CellNo.")
Figure 11: Topal COA
Example:
Figure 12: Mirror Account Name
Error Message:
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
This Function returns the code type of a mirror account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Is an account defined as mirror account, the respective name will be returned.
Function call :
=TopalBaeMirrorCOATypeCodeByClient("Mon Bijou AG";"1021") or =TopalBaeMirrorCOATypeCodeByClient("Client";"CellNo.")
Figure 13: Topal COA
Example:
Figure 14: Mirror Account Name
Error Message:
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
This Function returns true or false depending if the account has a mirror or not.
Function call :
=TopalBaeCOAHasMirror("1000") or =TopalBaeCOAHasMirror("CellNo.")
=TopalBaeCOAHasMirror("1000") or =TopalBaeCOAHasMirror("CellNo.")
Example:
Figure 15: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns true or false depending if the account has a mirror or not.
Function call :
=TopalBaeCOAHasMirrorByClient("Mon Bijou AG";"1000") or =TopalBaeCOAHasMirrorByClient("Client";"CellNo.")
=TopalBaeCOAHasMirrorByClient("Mon Bijou AG";"1000") or =TopalBaeCOAHasMirrorByClient("Client";"CellNo.")
Example:
Figure 16: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the kind of type of the given mirror Code.
Function call :
=TopalBaeMirrorCOAType("1000") or =TopalBaeMirrorCOAType("CellNo.")
=TopalBaeMirrorCOAType("1000") or =TopalBaeMirrorCOAType("CellNo.")
Example:
Figure 17: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the kind of type of the given mirror Code.
Function call :
=TopalBaeMirrorCOATypeByClient("Mon Bijou AG";"1000") or =TopalBaeMirrorCOATypeByClient("Client";"CellNo.")
=TopalBaeMirrorCOATypeByClient("Mon Bijou AG";"1000") or =TopalBaeMirrorCOATypeByClient("Client";"CellNo.")
Example:
Figure 18: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the type of the mirror account based on a given Code.
Function call:
=TopalBaeMirrorAccountType("1000") or =TopalBaeMirrorAccountType("CellNo.")
=TopalBaeMirrorAccountType("1000") or =TopalBaeMirrorAccountType("CellNo.")
Example:
Figure 19: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the type of the mirror account based on a given Code.
Function call:
=TopalBaeMirrorAccountTypeByClient("Mon Bijou AG";"1000") or =TopalBaeMirrorAccountTypeByClient("Client";"CellNo.")
=TopalBaeMirrorAccountTypeByClient("Mon Bijou AG";"1000") or =TopalBaeMirrorAccountTypeByClient("Client";"CellNo.")
Example:
Figure 20: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the type of a mirror account based on a given Code.
Function call:
=TopalBaeMirrorAccountTypeCode("1000") or =TopalBaeMirrorAccountTypeCode("CellNo.")
=TopalBaeMirrorAccountTypeCode("1000") or =TopalBaeMirrorAccountTypeCode("CellNo.")
Example:
Figure 21: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the type of a mirror account based on a given Code.
Function call:
=TopalBaeMirrorAccountTypeCodeByClient("Mon Bijou AG";"1000") or =TopalBaeMirrorAccountTypeCodeByClient("Mon Bijou AG";"CellNo.")
=TopalBaeMirrorAccountTypeCodeByClient("Mon Bijou AG";"1000") or =TopalBaeMirrorAccountTypeCodeByClient("Mon Bijou AG";"CellNo.")
Example:
Figure 22: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the balance of a mirror account or mirror group based on a given Code and Date range.
Function call:
=TopalBaeMirrorBalanceByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBalanceByDates("CellNo.";"01.04.2016";"30.04.2016")
=TopalBaeMirrorBalanceByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBalanceByDates("CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 23: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the balance of a mirror account or mirror group based on a given Client, Code and Date range.
Function call:
=TopalBaeMirrorBalanceByClientDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBalanceByClientDates("Client";"CellNo.";"01.04.2016";"30.04.2016")
=TopalBaeMirrorBalanceByClientDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBalanceByClientDates("Client";"CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 24: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the balance of a mirror account or mirror group based on a given Client, Code and Date range.
Function call:
=TopalBaeMirrorAcctBalCcByDates("1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeMirrorAcctBalCcByDates("CellNo";"Cost Center";"DateFrom";"DateUntil")
=TopalBaeMirrorAcctBalCcByDates("1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeMirrorAcctBalCcByDates("CellNo";"Cost Center";"DateFrom";"DateUntil")
Example:
Figure 25: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the balance of a mirror account or mirror group based on a given Client, Code and Date range.
Function call:
=TopalBaeMirrorAcctBalCcByClientDates("Mon Bijou AG";"1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeMirrorAcctBalCcByClientDates("Client";"CellNo";"Cost Center";"DateFrom";"DateUntil")
=TopalBaeMirrorAcctBalCcByClientDates("Mon Bijou AG";"1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeMirrorAcctBalCcByClientDates("Client";"CellNo";"Cost Center";"DateFrom";"DateUntil")
Example:
Figure 27: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the balance cf of a mirror account or mirror group based on a given Code and Date range.
Function call:
=TopalBaeMirrorBalanceCFByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBalanceCFByDates("CellNo.";"01.04.2016";"30.04.2016")
=TopalBaeMirrorBalanceCFByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBalanceCFByDates("CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 28: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the balance cf of a mirror account or mirror group based on a given Client, Code and Date range.
Function call:
=TopalBaeMirrorBalanceCFByClientDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBalanceCFByClientDates("Client";"CellNo.";"01.04.2016";"30.04.2016")
=TopalBaeMirrorBalanceCFByClientDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBalanceCFByClientDates("Client";"CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 29: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the balance of a mirror account or mirror group based on a given Code and Date range.
Function call:
=TopalBaeMirrorBudgetByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBudgetByDates("CellNo.";"01.04.2016";"30.04.2016")
=TopalBaeMirrorBudgetByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBudgetByDates("CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 30: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the balance of a mirror account or mirror group based on a given Client, Code and Date range.
Function call:
=TopalBaeMirrorBudgetByDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBudgetByDates("Client";"CellNo.";"DateFrom";"DateUntil")
=TopalBaeMirrorBudgetByDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBudgetByDates("Client";"CellNo.";"DateFrom";"DateUntil")
Example:
Figure 31: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the balance of a mirror account or mirror group based on a given Code, Cost Center and Date range.
Function call:
=TopalBaeMirrorAcctBudgetCcByDates("1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeMirrorAcctBudgetCcByDates("CellNo.";"Cost Center";"DateFrom";"DateUntil")
=TopalBaeMirrorAcctBudgetCcByDates("1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeMirrorAcctBudgetCcByDates("CellNo.";"Cost Center";"DateFrom";"DateUntil")
Example:
Figure 32: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the balance of a mirror account or mirror group based on a given Clientname, Code, Cost Center and Date range.
Function call:
=TopalBaeMirrorAcctBudgetCcByClientDates("Mon Bijou AG";"1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeMirrorAcctBudgetCcByClientDates("Client";"CellNo.";"Cost Center";"DateFrom";"DateUntil")
=TopalBaeMirrorAcctBudgetCcByClientDates("Mon Bijou AG";"1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeMirrorAcctBudgetCcByClientDates("Client";"CellNo.";"Cost Center";"DateFrom";"DateUntil")
Example:
Figure 33: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the budget of a mirror account or mirror group based on a given Code and Date range.
Function call:
=TopalBaeMirrorBudgetCFByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBudgetCFByDates("CellNo.";"01.04.2016";"30.04.2016")
=TopalBaeMirrorBudgetCFByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBudgetCFByDates("CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 34: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the budget of a mirror account or mirror group based on a given Code and Date range.
Function call:
=TopalBaeMirrorBudgetCFByClientDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBudgetCFByClientDates("Client";"CellNo.";"DateFrom";"DateUntil")
=TopalBaeMirrorBudgetCFByClientDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBudgetCFByClientDates("Client";"CellNo.";"DateFrom";"DateUntil")
Example:
Figure 35: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.