Skip to main content
Answer

GL Account Reconciliation

  • October 10, 2023
  • 9 replies
  • 799 views

william3
Freshman I

One of the key financial differences between Acumatica, Netsuite and Intacct is that the latter of the two have account reconciliation modules. Of course, everybody has bank reconciliation which is one type of GL account that has to be reconciled, but many companies are required by banks or auditors to explain many other balance sheet accounts and this can be a real headache to members of the financial team. To help win over the finance department to Acumatica, we need to offer a competent reconciliation module to stay competitive.

The essence of an account reconciliation module is that transactions that make up a balance sheet account at the end of a period are traceable to specific documents on the company side, and most importantly reconcile these against a statement or other documents from a third party. This could work in conjunction with the AP automation in that a PDF can be brought in and items on that PDF can be tied to the account balance. Some likely accounts are loans and notes receivable and payable, WIP, accruals and deferrals, loans to shareholders and equity, 

Besides a centralized set of tools for analysis, adjustments and approval, this is something that is best done by Acumatica as it works best by enforcing best practices when recording transactions such as storing document images with transaction records and insuring that transactions are recorded with sufficient comments and descriptions. Other modules such as projects and time and expense should be leveraged in this regard as well. One problem to overcome is that document storage eats up space at a horrifying rate and that can increase the cost of Acumatica rapidly - that must be addressed.

I would love to hear if anyone else thinks that this would be impactful to our customers and beneficial to the Acumatica community or would it be a misallocation of scarce resources.

Best answer by ChandraM

Hi @william3 For reconciliation of the Balancesheet Accounts like Receivable Account and the Payables Account, the tool that is very useful is the “Account Details”. Please see the screenshot below:

The “Modules” filter used to find out odd entries.

For example journal entries for Receivable Account being the reason why it is not matching with the subledger (AR). 

 

9 replies

Forum|alt.badge.img+8
  • Semi-Pro I
  • October 13, 2023

Hi @william3 Depending on your client’s file sizes and few similar factors, you can decide on other Storage options that can be configured.
 

 


Forum|alt.badge.img+8
  • Semi-Pro I
  • Answer
  • October 13, 2023

Hi @william3 For reconciliation of the Balancesheet Accounts like Receivable Account and the Payables Account, the tool that is very useful is the “Account Details”. Please see the screenshot below:

The “Modules” filter used to find out odd entries.

For example journal entries for Receivable Account being the reason why it is not matching with the subledger (AR). 

 


william3
Freshman I
  • Author
  • Freshman I
  • October 20, 2023

Hi @ChandraM. Thank you for your comment. Cash, trade payable and receivables all have subledgers with good audit paths, inquiries and reports which should balance to the GL. Sometimes entries are made to the control account that the subledger is ignorant of and that requires a separate reconciliation. The challenge that I am primarily concerned with is the reconciliation of GL accounts without subledger support. This includes loans to and from the business, and basically all material asset, liability and equity accounts. Using either a documentation or analytical approach, an reconciliation process embedded within the ERP system is a valuable competitive factor that will only increase in importance as time goes by. Netsuite already has this capability which, from what I’ve heard, was migrated from Oracle financials.


dfrancis7
Freshman I
  • Freshman I
  • April 19, 2024

As I understand it, SAP has a functionality where you can mark items in a balance sheet account as “cleared” similar to how you would do with a bank reconciliation. Then you can run a report on a balance sheet report that just shows the uncleared/open items. I think that Acumatica should provide a similar function.

Additionally, if it could be possible to assign items to categories that are user defined, then you could make the uncleared/open items report even more useful if you can group items by category.


  • Freshman II
  • October 24, 2024

I did some research and IFS seems to have such a feature too, which is described as “The Account Matching process is used to automatically match transactions in the general ledger. The purpose is to match one or more debit transactions from one specified account with one or more credit transactions from the same account.” Our biggest client recently asked us if there is something similar offered so that they could run a report or an inquiry such as Account Details to list only those transactions that are not matched.

Is there any plan that Acumatica will offer this feature in the future?


  • Freshman I
  • August 12, 2025

This is a feature we were used to having in our older system that is greatly missed. It looks like the only ‘Idea’ post requesting this is four years old; is there a newer one created that I’m missing and can vote on? 


jeff47
Freshman I
  • Freshman I
  • August 29, 2025

I agree that this feature should be added.  We have clients coming over from QuickBooks and QuickBooks allows a reconciliation of any balance sheet account.  For example, Deferred Revenue.  A client can see the increase to Deferred Revenue and the decreases.  When it gets reconciled and the revenue clears out, it gets marked as cleared and the client can then sort al uncleared deferred revenue by customer and have a great report, otherwise it is long and has a bunch of cleared out customers that are not needed.  Same with things like prepaids or accruals that clear out.  Seeing only uncleared transactions would be great 


Forum|alt.badge.img
  • Jr Varsity II
  • October 21, 2025

Hi everyone, I have a client requesting the same feature (GL level reconciliation) may you asissist on what temporary or solutions you asissted them with. 


  • Freshman I
  • October 28, 2025

Here’s the current ‘idea’ that’s out there to upvote: