Skip to main content

Automated Project WIP Over/Under Billing Adjustments and Posting

  • December 30, 2024
  • 2 replies
  • 339 views

aaghaei
Captain II
Forum|alt.badge.img+10

I do not like the idea of advertising on community but as per recommendation from a few of my clients who love this engine and think this can be helpful for others, I decided to write up a short summary of an automated Project WIP Adjustments that we have developed and works alongside Acumatica construction module.

  • Automatically draft WIP Over/Under Billing adjustments as per the WIP configuration
  • Allow adjusting/overriding the Expected Revenue, Expected Cost and Completed Percent on the fly
  • Automatically posting the Over/Under Billing Adjustments by project or summarized to GL
  • Automatically updating Project Register alongside the GL Posting if opted to do so
  • Automatically track the Cost and Billing changes within the month after WIP is posted and re-adjust the WIP Over/Under Billing when user re-run the WIP Adjustments
  • Ability to post the WIP in full and reverse next period automatically OR opt to post WIP Over/Under Billing incrementally
  • Ability to calculate WIP Expected Costs at project level based on Budgeted Cost, Projected Cost and Actual Cost
  • Multiple option of determining Expected Revenue by Projected Revenue, Expected Markup or Billing to Date.
  • Ability to compare the current WIP key metrics with the prior WIP.
  • Ability to recall the WIP posting batch as long as GL Batch is not released.
  • Ability to navigate to project, project transactions, commitments, and project related AP Invoices
  • Lots of informational columns for better/easier WIP review
  • It comes with a reporting screen that utilizes the same WIP engine business logics and adds some extra columns for Project Cash surplus/shortage
  • Lots of other capabilities that can be presented.

If you think this can be helpful to your Construction business, please directly message me.

 

 

 

This topic has been closed for replies.

2 replies

Forum|alt.badge.img
  • Freshman I
  • December 30, 2024

Our company uses this WIP tool. We really like it.  It’s saved us a ton of time and angst over the monthly close process.  We used to dread the WIP meeting and now it’s easy and simple.  If you want to talk offline, I’m game.


Forum|alt.badge.img+1
  • Captain I
  • December 30, 2024

Our company uses this WIP tool. We really like it.  It’s saved us a ton of time and angst over the monthly close process.  We used to dread the WIP meeting and now it’s easy and simple.  If you want to talk offline, I’m game.

Exactly the same position here, we have been using this add-on since our 2022 golive. It's a game changer. It should be a built-in feature in Acumatica, I think they are behind on this aspect!

In any case it saves us a lot of time, because it reuses the figures in real time and it gives us a nice interface to close the end of the month with the project managers.

If you have any questions, I am available! 😎