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

Community site session details

Session Id :
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

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,043 Moderator on at
    RE: Trial balance Debit and credit amounts

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

    pastedimage1659620397072v1.png

  • Lethiwe Profile Picture
    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
    1,043 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.

  • Verified answer
    AD-22040756-1 Profile Picture
    640 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

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

    Hi

    Yes it was the net change balances thank you.

  • Lethiwe Profile Picture
    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,308

#2
Sumit Singh Profile Picture

Sumit Singh 2,798

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,793

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans