Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
bo bo is offline
external usenet poster
 
Posts: 9
Default Contract / P&L management tool sought - simple is best

For background - We are a consulting firm that provides financial management
services to government and nonprofit organizations.

We are seeking a tool that will allow us to better manage our contracts and
company P&L. I am looking for Buget, Actual, Projection capability.

We record our hours - billable and non billable - via www.getmytime.com

Most of our contracts are Time and Material

Elements include
Labor Category Title
Labor Category Rate per Hour
Hours per Labor Category

Input
Hours are tracked via Get My Time

Output desired
Profit and Loss by
Budget, Actual, Projection
Monthly, YTD, Balance of Year
Rolling Estimate (Current Projection)
Actual vs. Budget
Projection vs. Budget
By Contract
By Labor Category
By Dollars

Outcome sought
Sound Fact Based Contract Management

We use QuickBooks for our Financials but may not want to do all of this in
there as it may "muddy the waters"

Let me know - thank you in advance.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,203
Default Contract / P&L management tool sought - simple is best

Use Quickbooks to set up accounts for various expenses, putting them into
categories such as G&A, Overhead, full time employee fringe benefit costs,
part time fringe benefit costs, etc and any others that a CPA may advise
about.
Use those values to determine what percent of your income they eat up and
then continue to to use them to develop your bill rates for labor. They can
serve as the basis for budgeting and for projecting future costs.
Contact a good CPA for advice on what expenses to include in which category.

Trust me, your accounting software (Quickbooks) is going to be the best way
to track those expenses while Excel can be used to analyze the data and set
up projections and budgets.

"Bo" wrote:

For background - We are a consulting firm that provides financial management
services to government and nonprofit organizations.

We are seeking a tool that will allow us to better manage our contracts and
company P&L. I am looking for Buget, Actual, Projection capability.

We record our hours - billable and non billable - via www.getmytime.com

Most of our contracts are Time and Material

Elements include
Labor Category Title
Labor Category Rate per Hour
Hours per Labor Category

Input
Hours are tracked via Get My Time

Output desired
Profit and Loss by
Budget, Actual, Projection
Monthly, YTD, Balance of Year
Rolling Estimate (Current Projection)
Actual vs. Budget
Projection vs. Budget
By Contract
By Labor Category
By Dollars

Outcome sought
Sound Fact Based Contract Management

We use QuickBooks for our Financials but may not want to do all of this in
there as it may "muddy the waters"

Let me know - thank you in advance.

  #3   Report Post  
Posted to microsoft.public.excel.programming
bo bo is offline
external usenet poster
 
Posts: 9
Default Contract / P&L management tool sought - simple is best

Thanks for the response.

We do have QB all set up and have been using it for years. We have recorded
our "history". We have not used it for budgeting, planning etc.

Would you recommend budgeting and panning within QB - jobs etc... or within
Excel? If within Excel -is there a COTS product that can integrate Time
Keeping at the front end and QB at the back end?

"JLatham" wrote:

Use Quickbooks to set up accounts for various expenses, putting them into
categories such as G&A, Overhead, full time employee fringe benefit costs,
part time fringe benefit costs, etc and any others that a CPA may advise
about.
Use those values to determine what percent of your income they eat up and
then continue to to use them to develop your bill rates for labor. They can
serve as the basis for budgeting and for projecting future costs.
Contact a good CPA for advice on what expenses to include in which category.

Trust me, your accounting software (Quickbooks) is going to be the best way
to track those expenses while Excel can be used to analyze the data and set
up projections and budgets.

"Bo" wrote:

For background - We are a consulting firm that provides financial management
services to government and nonprofit organizations.

We are seeking a tool that will allow us to better manage our contracts and
company P&L. I am looking for Buget, Actual, Projection capability.

We record our hours - billable and non billable - via www.getmytime.com

Most of our contracts are Time and Material

Elements include
Labor Category Title
Labor Category Rate per Hour
Hours per Labor Category

Input
Hours are tracked via Get My Time

Output desired
Profit and Loss by
Budget, Actual, Projection
Monthly, YTD, Balance of Year
Rolling Estimate (Current Projection)
Actual vs. Budget
Projection vs. Budget
By Contract
By Labor Category
By Dollars

Outcome sought
Sound Fact Based Contract Management

We use QuickBooks for our Financials but may not want to do all of this in
there as it may "muddy the waters"

Let me know - thank you in advance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VB Help sought with some code kirkm[_8_] Excel Programming 1 May 4th 09 01:13 PM
Advice Sought JAC Excel Programming 3 September 19th 08 08:12 AM
Advice Sought JAC Excel Programming 3 September 2nd 08 08:29 AM
Using contract start/end dates and calculating annual contract day Redcon Excel Discussion (Misc queries) 3 April 19th 08 12:03 AM
VBA help sought H.S Excel Programming 1 March 17th 05 09:06 AM


All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"