Solved

Variance between AR and GL

H
Rank
Userlevel 4
Badge

Do Unposted  or Unrealeased trasactions cause a variance in the AR and GL control accounts?

icon

Best answer by iqraharrison48 2 May 2023, 14:54

View original

6 replies

iqraharrison48
Rank
Userlevel 7
Badge +6

@helpdesk37 yes, best practice is to post all transactions otherwise it won’t make a GL impact

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
iqraharrison48
Rank
Userlevel 7
Badge +6

@helpdesk37 is there a reason why some transactions are left unreleased/unposted?

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
estebanperalta54
Rank
Userlevel 6
Badge +3

Hi @helpdesk37 unposted or unreleased transactions shouldn't be causing variances although as Iqra mentioned it’s good idea to post these transactions. Sometimes variances might be caused by setting changes, run the Recalculate Customer Balances and Recalculate Account History:

 

If you found the post helpful please like the post or if it answered your question mark it as best answer. Thanks!
Laura02
Rank
Badge +18

Hello @helpdesk37 ,

Unreleased transactions do not cause any difference between the GL and the subsidiary modules.  A document or batch with Unreleased status has not updated AR or GL and is not causing any difference between the AR Period Sensitive Aging and GL Trial Balance reports.

 

Unposted batches are released in the subsidiary module and therefore HAVE updated AR Period Sensitive Aging and HAVE updated the customer balances, yet have not updated the GL. Unposted batches do cause differences between AR Period Sensitive Aging and GL Trial Balance reports.

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ AUG Forums Episode130 ~
S
Rank
Userlevel 7
Badge +10

Hi @helpdesk37,

Unposted or unreleased transactions can cause a variance in the AR and GL control accounts, as these accounts represent the amounts that have been invoiced and recognized in the financial statements. If there are unposted or unreleased transactions, the amounts in the AR and GL control accounts may not match the actual amounts of invoices issued and revenue recognized, leading to a variance. It is important to regularly reconcile the AR and GL control accounts to identify and correct any variances.

L
Rank
Userlevel 3
Badge

If you “pretend” to close out the period in the manage financial periods screen you can run a report called unreleased documents that will show you a list of all documents and GL batches that have yet to be posted. 

 

I find this helpful as it breaks them out by modules but gives you a full list. 

 

 

Reply


Terms & ConditionsCookie settings
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