188
Good morning,
I have created four GL accounts with the below No:
I also need a Total GL with the Totalling formula below:
"TA-Current Liab_T" - "Loans_ET" - "Provisions_ET" - "Net Pension Liab_ET"
I have tried few things, but I keep getting errors. Does anybody know how to put it so it works?
Thanks
Alejandra
Steve is right numbers work much better and Begin/End Totals work super well.
You account numbers won't even sort well. If you're worried about data entry, don't you type the name and the account comes up....this is what I do for my accounting.
The sorting would be :
Net Pension...
Loans...
Provisions....
TA-Current...
If you used numbers:
100 TA-Current Liab_T $ -100
200 Loans_ET $ - 200
300 Provisions_ET $ 100
400 Net Pension Liab_ET $ - 300
Account 500 could be a Total Account Type 100+200+300+400, calculation -100+-200+200+-300 or $ - 400
Alejandra,
I first have to ask why you created the G/L Accounts with letters and not actual numbers within the Chart of Accounts structure. If you create them as actual numbers, within the COA range, you can create simple Totaling Formulas. Below is a screen shot of an example.
If you need more help send a pic of what you are trying to accomplish in your COA and we can reply back.
Hope this helps.
Thanks,
Steve
#1
André Arnaud de Cal...
292,884
Super User 2025 Season 1
#2
Martin Dráb
231,760
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
