Solved

GL Account Reconciliation

  • 11 October 2023
  • 4 replies
  • 162 views

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.

icon

Best answer by ChandraM 14 October 2023, 00:48

View original

4 replies

Userlevel 7
Badge +9

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

 

Userlevel 7
Badge +9

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). 

 

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.

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.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved