Share
ReportHi:
For importing the summary monthly balances of G/L accounts from other ERP apps, is the correct term "net monthly trial balance summary"?
John
You’re offline. This is a read only version of the page.
3,482
Hi:
For importing the summary monthly balances of G/L accounts from other ERP apps, is the correct term "net monthly trial balance summary"?
John
The hardest thing we do is terminology. Since a Trial Balance is the balance of each account for the month selected, your thought of Net Monthly Trail Balance makes sense but other ERPs will not have this. You want the beginning balance sheet accounts for the month ending before the year that you are coverting. Example; converting 2022, so beginning balance sheet is 12/31/21. Then you want the net change month by month for 2022. Many times I've seen clients take their Trial Balance for January, deduct the 12/31/21 balances to get the net change for January, etc. etc, for each month.
Hi, Net Change in BC is taken from General Ledger Entries. You can use Filter totals by to look up the value of a date.
But if you just import data from a certain point in time, for example 2022.09.30.
I don't think this is a "net monthly trial balance summary", it's only for September, you can't check the previous months.
Hope this helps.
Thanks.
ZHU
Hi,
Do you mean the Monthly Netchange?
Is the idea to import the balances as of a specific date, and then the monthly "Netchange" so at the end you will have the balance?
If yes, I personaly use the following descriptions:
"Balance as of xx/yy/zzzz" & " yy/zzzz Net Change"
#1
André Arnaud de Cal...
291,784
Super User 2024 Season 2
#2
Martin Dráb
230,476
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
