Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV forum / Reclass for difference...
Microsoft Dynamics NAV forum
Suggested answer

Reclass for difference between TB and P&L

(0) ShareShare
ReportReport
Posted on by Yin Mon Pyone 4

Dear Experts,

When I checked TB and P&L for Year 2020, I found difference amount 13.11 between Net Profit of TB and P&L. 

The difference was brought forward from 2017 and 2018. 

By checking against TB and P&L, difference found in Cost of sales (0.25), Stock Written off (7.86) and Provision for Stock Written off (5) each 

(P&L is more than TB) 

Retain earning shows as credit 13.11 in TB for YA 2020.

In this case, How do I reclass for those differences? 

I have run closed income statement multiple times. There is no more outstanding entries to run. 

Looking forward to hearing your best advice.

Regards,

Sweety

Categories:
Financial Management
  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reclass for difference between TB and P&L

    Sweety,

    Sorry for delay. I took some needed extended time off. If you cannot locate the exact entry, since the amount is so small, I would:

    1. Run Close Income Statement for Year 2020 to make sure nothing is present.

    2. If no entry for 13.11 appears, then in the Balance Sheet I would Debit the 13.11 out of Current Year Earnings and Credit Accumulated Profit/(Loss).

    Hope this helps.

    Thanks,

    Steve

  • Yin Mon Pyone Profile Picture
    Yin Mon Pyone 4 on at
    RE: Reclass for difference between TB and P&L

    Dear Steve,

    Thanks for your prompt reply.

    It is difficult to trace which entry was causing the difference? There is no exact amount with transactions.

    There was no direct posting to retain earning account.

    If I want to reverse, should I use Accumulated Profit & Loss account or Retain earning account ?

    Please advise.

    Regards,

    Sweety

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reclass for difference between TB and P&L

    Sweety,

    So the Close Income Statement is good, you said, therefore the amounts have been booked to Retained Earnings from the Income Statement accounts. Yet, you noted Retained Earnings has an extra manual credit of 13.11 in Fiscal Year 2020. Seems like someone manually booked this entry when booking possibly the adjustments and did not let NAV Close Income Statement on its own. Can you trace the 13.11 entry? Is it Credit Retained Earnings -13.11 and Debit the 3 accounts you noted in the Income Statement?

    If you want to reverse the 13.11 I would reverse the entry and offset to the G/L Accounts noted on the entry. Note that this difference I would not book in 2020 since the year is closed but 2022, say January. The issue has been carryforward all this time and I want to correct in the open Fiscal Year.

    Thanks,

    Steve

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

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

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans