Refine articles

Stories we can't stop telling.

The BGSF family of companies have more than 100 years of combined staffing experience, which means we have more than a few success stories to tell.

Check out a few of our faves.

With Creation of New Tool and Processes, BGSF develops Historical and Forecasted key metrics

Feb 7, 2020, 14:46 PM
Title : With Creation of New Tool and Processes, BGSF develops Historical and Forecasted key metrics

Business Scenario:

Our client used QuickBooks for their accounting and reporting software systems and used Excel-based worksheets to forecast both operational and financial metrics. They realized they were duplicating efforts and had allowed themselves room for errors.  

Project Scope: Our team of Consultants worked directly with the client to develop a timeline for a two-phase solution.  

Phase 1)

Identified the client’s requirements, both current and future, in forecasting and reporting requirements. 

Phase 2)

Evaluated the ability of QuickBooks to facilitate the requirements and evaluate the current chart of accounts in QuickBooks.  

Phase 3)

Developed an Excel tool that provided both historical and forecasted key metrics using input screens for certain business drivers and download tools to import from QuickBooks.  

Phase 4)

Review the tool on an ongoing basis with the client. 

Clients Return on Investment:

Prior to the project, our client did not have the ability to run different planning scenarios or generate combined actual and forecasted resulting in using the same tool. With the new tool and processes, they were able to stay with the QuickBooks, did not have the expense or challenges of going to a new system and were able to generate financial forecasts for investors and creditors on an ad hoc basis.  

Using QuickBooks for accounting and reporting while using Excel-based worksheets to forecast both operational and financial metrics, duplicates efforts creating room for errors.
Categories :
  • Donovan & Watkins
  • Professional Division
Tags :
Case Study Author

The BiG blog.

From tips on how to land a better job to strategies on how to staff up quickly to maximize productivity, the BGSF blog is a wealth of information.


The latest BiG news.

If it's happening at BGSF or one of our brands, you'll find it here.

Take a deeper dive.

We are working hard to keep you updated on regulatory, compliance and industry trends. Our consultants keep you informed through our whitepapers here...


There's always something fun going on.

Whether it's an educational event, trade show or career fair, find out when and where you can connect with fellow BGers.

ExtrinsicGolf2019 FullSizeRender DCEOWomensLeadership2019 BGMF_ADVOCATE2 KansasCity-KansasCityApartment1 BGMF-MonequeHorseyPAAEast BGMF_ADVOCATE bgmf-breakfastpanel TexasApartmentAssociationTradeshow2 BeccaMay-DFWSapphireAwards BGMF-LeadershipTeam BGMFNAAAdvocate DonWatCPE DWCPE DallasCPE2 DonWat-CPEBreakfast DonWatCPELunchTurnout DonWat-AugCPE DonWat_JoyBreakfast2