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...
Suggested answer

Outstanding Bank Transactions

(0) ShareShare
ReportReport
Posted on by 5

I am attempting to post our first bank account reconciliation for the month of April, 2022.  I have reconciled and am in balance however, when I run the test report before posting - all outstanding transactions are showing outside of the month of April.  So it's as if the list is "live".  This is driving me crazy.  I'm wanting a standard stand alone monthly bank reconciliation.  I am in the sandbox playing around with different options but nothing I do seems to work.  I thought maybe after the initial bank rec, they system would pull outstanding items as of the bank statement cut-off date but that is not the case.  Am I missing something in the setup of the bank account or is there another way around to fix the report?

I have the same question (0)
  • MNihoul Profile Picture
    5 on at
    RE: Outstanding Bank Transactions

    Debbie, I am pretty new to BC and ran into similar issues, so hopefully this will help.

    I have been completing my bank rec manually and found that when you Suggest Lines for import, that it's imperative that the end date be the statement date (or last day of the month).  When I chose to include dates past this range, it caused by GL to miscalculate which was causing my bank rec not to balance.  What I did find is that you can only remove those transactions by going to Process > Clear Lines and you would choose the dates you wanted to remove.  So, for example, you are reconciling through June 30th, but you have Bank ledger transactions included through July 15th.  You would choose Clear Lines and Choose "07/01/2022..07/15/2022," but keep in mind, this will remove all transactions, so you could not include them on your bank rec. 

    Hope this helps.

  • Rob F. Profile Picture
    487 on at
    RE: Outstanding Bank Transactions

    We noticed the same issue with that report and it definitely seems to be a design flaw.  I've never worked at a company where the accounting staff stop posting into the following month until the bank is reconciled for the current month - that's the whole point of having a statement date on the reconciliation so that the outstanding items are filtered up to the date you are reconciling to.  Our head of Finance has been really unhappy about it because it means we don't have proper monthly bank rec reports, which is a requirement of our auditors.  I'm currently working on trying to build something with Jet Reports as a workaround.

  • Suggested answer
    Dallefeld Profile Picture
    193 User Group Leader on at
    RE: Outstanding Bank Transactions

    Are you using the automatic bank rec or the manual bank rec? I find that with the manual bank rec, using the suggest lines for checks and deposits, I can control the transactions that pull into my bank rec. Processing this way allows me the luxury of not looking at the new stuff!

    Another option is not to wait until the end of the month to reconciliation you bank account but rather do it daily or weekly. I've heard push back that auditors will not like multiple bank recs per month. When talking to various client's auditors they resoundingly approve on more bank recs as that mean you are more 'on top' of your bank balances.

  • Louise H Profile Picture
    35 on at
    RE: Outstanding Bank Transactions

    I also find the 'live' nature of the bank reconciliations really unhelpful. I work for an NGO with lots of small offices and often bank reconciliations (particularly this year when we moved all office onto BC) are not done on the exact day at the end of the month (before transactions for the next month are entered). No tips for you, just empathy!

  • Debbie Morgan Profile Picture
    5 on at
    RE: Outstanding Bank Transactions

    Thank you for the reply.  I have done the steps mentioned exactly but I am not sure about the direct posting component however, from a balancing perspective - I do reconcile and the "bank card" linked to the GL account both tie to each other.  

    I did find the posting below from anther blog, which is disappointing if true, but it's the only reference to this matter that I've found.  The outstanding bank transaction list does not calculate correctly (as mentioned) from deposits vs checks as line items but as a net total, the balance of outstanding items is correct.  So weird.

    The Bank Acc. Reconciliation does contain all the Bank Account Ledger Entries that have not yet been closed. This includes all entries that have been made even those posted after the statement date. You are able to filter the Posting Date to narrow down the amount of data, but these entries will appear as outstanding on your test report. Meaning that if you postpone your bank reconciliation until after you make entries into the next month (or months), then those transactions will also appear in your bank reconciliation in the bank account ledger entries.

    The Test Report then shows these entries as outstanding transactions. The Ending Balance on this report shows the current balance in your bank account in Business Central. I have discovered though, that the Outstanding Bank Transactions does not look like it calculates correctly. Thus, causing some confusion. It is because of how the Deposits are displayed and it makes it look like they are not being included in the Total Outstanding Bank Transactions. But, in fact they are. The Deposit is listed and then the transactions that made up the deposit are listed right below it. The report indents the posting date for the entries.

  • Suggested answer
    Francisco Bedolla Profile Picture
    1,119 on at
    RE: Outstanding Bank Transactions

    please check if you do these steps

    www.erpsoftwareblog.com/.../

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
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 4,252

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,117

#3
Sumit Singh Profile Picture

Sumit Singh 2,956

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans