Ideas for Acumatica

Feedback processing: We do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or get assistance from community resources: LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal.

Bank Reconciliation Report

Acumatica should have a 'standard' bank reconciliation report showing prior period balance, cleared items, outstanding list for deposits in transit and outstanding checks list.  Totals should include bank statement balance, cash account balance, and GL account balance (with variance if any).  Existing client hates the way the existing reconcile function works and the (lack of) a workable report.   Reports should allow Export to Excel option.

  • Mike Lupro
  • May 3 2018
  • Shortlisted
  • Attach files
  • Douglas Johnson commented
    20 Feb 20:49

    Dear Acumatica Community,

    We are investigating making improvements to the Bank Reconciliation process in Acumatica. To help with requirements, we would like to have community members record their reconciliation process. During the recording you can suggest changes that would make your job easier. 

    We think this would be a non-intrusive way to gather your feedback without a large time investment. 

    If interested please email me (djohnson at Acumatica) and I will provide more details. 


    Doug Johnson

  • Bill Stewart commented
    October 15, 2019 15:41

    The reconciliation report should start with the balance from the previous month.

  • Admin
    Feedback Admins commented
    October 08, 2019 06:31

    Dear Bill,

    you can use the Reconciliation Statement (CA627000) report to get the statement balance, GL balance, difference between these amounts and the list of outstanding checks and deposits in transit.

    In one of the future releases, we are planning to add a report that shows all the payments included into a reconciliation as well as those that were not reconciled yet.

    Best regards,

    Olga Anisimovich (Product Manager – Financials )

  • Bill Stewart commented
    October 07, 2019 17:58

    The Reconciliation Register Details report does not provide the outstanding list for deposits in transit and the outstanding checks list.  It should also show the GL account balance with variance if any.  THIS IS NEEDED ASAP!

  • Olga Anisimovich (Product Manager Financials Team) commented
    May 03, 2018 06:47

    Hello Mike,

    Currently there are two reports from which you can get the needed info:

    Reconciliation Statement (CA627000) that shows statement balance, GL balance, difference between those amounts and the list of payments that are not reconciled yet;

    Reconciliation Register Details (CA624000) that shows beginning balance, statement balance and the list of the reconciled payments.

    Both reports can be exported to Excel.