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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Accounts Recivable report higher than balance sheet debtors

(3) ShareShare
ReportReport
Posted on by 47
My accounts receivable seems to be higher than my balance sheet. Document types are all Invoice, Payment, Credit Memo and Refunds.
 
Only thing that may cause the issue is we sometimes get a bulk payment for multiple customers and use a cash allocation account for this to then post the individual payments to individual customers from there but in previous systems always worked fine.
I have the same question (0)
  • Vahid Ghafarpour Profile Picture
    12,090 Super User 2025 Season 2 on at
    Manual cash allocation processes can be prone to errors
     
  • Gerardo Rentería García Profile Picture
    25,213 Most Valuable Professional on at

    Hi, good day
    I hope this can help you, and give you some hints.

    Solved: AR Balance does not equal outstanding invoices

    Accounts receivable analytics - Business Central | Microsoft Learn

    Best Regards
    Gerardo

  • Suggested answer
    Valentin Castravet Profile Picture
    31,340 Super User 2025 Season 2 on at
    If your customer subledger doesn't reconcile with the G/L then typically it's because entries have been posted to the G/L account without going through the subledger. I would check the general ledger entries for such entries. 
     
  • Suggested answer
    YUN ZHU Profile Picture
    95,331 Super User 2025 Season 2 on at
    Hi, You can find the details of manual postings through the following method to see if this is the difference.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,347 Super User 2025 Season 2 on at

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans