Net monthly trial balance summary

(0) Share

Report

Posted on by john.ellis

3,510

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

I have the same question (0)

All responses (3)

Answers (0)

Omar K 201 on at

Like (0)

Report

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"

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (1)

Report

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.

Was this reply helpful? Yes No