Balances / Totals

Posted 16 days ago by Nathaniel Travis

N
Nathaniel Travis
Answered

0 Votes

I feel like this is a very simple question.  I am just using the accountbeginningbalance / ending / totaldebits / totalcredits functions to automate a TB summary.

My issue is the directionality of the results.  IE accounttotalcredits is resulting in a positive number, rather than a negative one. If I need to make the formulae negative so be it.


The larger issue is with accountbeginningbalance as liabilites and income are coming in as positive numbers, when they should be negative.  I'd much rather just be able to use the same formulae all the way down the column vs having a different formulas for different accounts.


Thoughts?



0 Votes

Gabriel Michaud

Gabriel Michaud posted 15 days ago Admin Best Answer

Hi Nathaniel,


There's an option at the workbook level that can control the account balance sign. If you select the "Reversed" option, the credit balances of liability and income accounts will be displayed as negative numbers, and the debit balances will be displayed as positive numbers.  In this mode, the total balance of all accounts will always equal to zero (as long as you don't include the YTD Net Income account) and you will not have to make the formula negative.


If you're using Velixo Classic, please refer to this page: https://helpacumatica.velixo.com/support/solutions/articles/153000018620

If you're using Velixo NX, please refer to this page: https://helpacumatica.velixo.com/support/solutions/articles/153000011797


Regards,

Gabriel

1 Votes


2 Comments

Sorted by
N

Nathaniel Travis posted 15 days ago

awesome, I knew it must be a simple solution!

Thank you!

0 Votes

Gabriel Michaud

Gabriel Michaud posted 15 days ago Admin Answer

Hi Nathaniel,


There's an option at the workbook level that can control the account balance sign. If you select the "Reversed" option, the credit balances of liability and income accounts will be displayed as negative numbers, and the debit balances will be displayed as positive numbers.  In this mode, the total balance of all accounts will always equal to zero (as long as you don't include the YTD Net Income account) and you will not have to make the formula negative.


If you're using Velixo Classic, please refer to this page: https://helpacumatica.velixo.com/support/solutions/articles/153000018620

If you're using Velixo NX, please refer to this page: https://helpacumatica.velixo.com/support/solutions/articles/153000011797


Regards,

Gabriel

1 Votes

Login or Sign up to post a comment