Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Trial balance Debit and credit amounts

(1) ShareShare
ReportReport
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 624 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,748 Super User 2024 Season 1 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,748 Super User 2024 Season 1 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans