Skip to main content

Notifications

Business Central forum
Answered

Trial balance Debit and credit amounts

Posted on by 135

Hi all

Please help what my client trial balance has the debit balances on the credit side and the credit balance on the debit side, what caused this and how to reverse the setup?

Your help will be highly appreciated.

Please see the screenshot

pastedimage1659616506795v1.png

  • Lethiwe Profile Picture
    Lethiwe 135 on at
    RE: Trial balance Debit and credit amounts

    Hi

    I was using a normal trial balance that displays the net change balances, but I see detailed trial balance does show them in debit and credit accordingly. Thanks so much this was helpful.

  • Lethiwe Profile Picture
    Lethiwe 135 on at
    RE: Trial balance Debit and credit amounts

    Hi

    Yes it was the net change balances thank you.

  • Verified answer
    AD-22040756-1 Profile Picture
    AD-22040756-1 622 on at
    RE: Trial balance Debit and credit amounts

    Which trial balance report are you using? There are multiple in the system.

    Also, can you show a screenshot that includes the column names? From what I can tell in your screenshot it looks right to me.

    Typically the columns would be Beginning Balance, Debits, Credits, Ending Balance. If the report you are using does have the columns in that order then the data in your screenshot is correct as the fixed asset cost accounts have a debit balance and the accumulated depreciation accounts have a credit balance.

    Something else you can do:

    1. As per Inge's post in the General Ledger Setup Page change the Show Amounts field to All Amounts.

    2. Add these two Debit Amount and Credit Amount fields to the Chart of Accounts Page. 

    3. Add the same date filter as in your trial balance report

    4. Compare the Debit & Credit Amounts in the Chart of Accounts and in your Trial Balance, they should be the same 

    pastedimage1659627745399v1.png

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Trial balance Debit and credit amounts

    Are you sure that you are comparing two prints of the trail balance report.

    I checked the code and there is no setting that you can adjust to make the trail balance layout to change.

    Could it be that you compare the report to an excel export done from the chart of accounts? The char of account normally only show the net change.

  • Lethiwe Profile Picture
    Lethiwe 135 on at
    RE: Trial balance Debit and credit amounts

    Hi Inge

    this does not make any changes to amounts on the report. any more suggestions?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Trial balance Debit and credit amounts

    Go to general ledger setup and look at the show amount setting:

    pastedimage1659620397072v1.png

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans