web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Net monthly trial bala...
Small and medium business | Business Central, N...
Answered

Net monthly trial balance summary

(0) ShareShare
ReportReport
Posted on by john.ellis 3,532

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

  • Omar K Profile Picture
    Omar K 201 on at

    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"

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 103,292 Super User 2026 Season 2 on at

    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.

    pastedimage1664413221033v1.png

    pastedimage1664413452179v2.png

    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

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 235 User Group Leader on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
11manish Profile Picture

11manish 9 Super User 2026 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 1 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans