Architekwiki
  • WIKI
  • Start Here
  • Resources
  • Other
    • Reading List
    • OFFPLAN
    • Details
    • About
    • Sign Up
    • Terms of Use
  • WIKI
  • Start Here
  • Resources
  • Other
    • Reading List
    • OFFPLAN
    • Details
    • About
    • Sign Up
    • Terms of Use

Architekwiki

A Resource For Architects
Subscribe

Fees in MyCorbu

8/17/2019

 
Fees
​A description of how Fees and Invoices might work.

​I have evolved in my thinking about basic fee types from eight to four, and now to just two basic fee types. Those two are hourly rate fees and lump sum fees. The four that I thought were the truly unique types are in bold in the following list. I now see hourly rate fees and lump sum fees as the two fundamental types that bookkeeping needs to address. The other types are primarily contractural ways of describing how the fee is determined. But I am building a bookkeeping app, not a contract management app.

HOURLY RATE FEES
Estimated hourly rate fee without a maximum ::bold::
Estimated hourly rate fee with a maximum ::bold::
Hourly rate for type of work
Hourly rate for role performed

LUMP SUM FEES
Lump sum fee with lump sum phases ::bold::
Lump sum fee with percentage phases ::bold::
Simple lump sum
Fee as a percentage of construction cost
Unit cost fee

Lump sum fee with percentage phases and the fee as a percentage of construction cost are basically the same thing. The latter ties the fee directly to construction cost for contractual reasons, and so the ‘lump sum’ may change.
The unit cost fee is very similar to the fee as a percentage of construction cost because you tie the fee to a calculated number (say, dollars per square foot). 
From the standpoint of contracts you have at least eight different ways to determine the fee. From the standpoint of bookkeeping there are just two types of fee, hourly rate fees and lump sum fees. This realization came to me while trying to devise ways of storing the key data of what I thought were the four fundamental fee types. 

​Here are two previous posts where I was feeling my way into this subject.
https://www.architekwiki.com/wiki/architectural-fee-types
https://www.architekwiki.com/wiki/architectural-fee-types-in-mycorbu


​​As I continue to feel my way into the topic of ‘Fees Bookkeeping’ there seems to be four areas where there needs to be a solution. Two of them concern the fee itself and the other two concern the invoices that request payment of the fee.
  1. Things you want to document about fees in your bookkeeping system
  2. Things you want your bookkeeping system to report to you about fees
  3. Things you want to document about invoices in your bookkeeping system
  4. Things you want your bookkeeping system to report about invoices

If I can get these four areas to work, I think I will have a good solution for MyCorbu. These four areas actually describe the form and table views that will be needed. Let’s look at each one in more detail.


​
FEES
Your fee information drives the income side of your profitability, but you cannot add your fees as income transactions until they  are earned. So fees tell you about potential, rather than actual, results.


Things you want to document about fees in your bookkeeping system.
When you add a new project to your backlog of work, what are the things about its fee that you want to document?
  1. The amount of the fee
  2. The type of fee
  3. The breakdown of the fee
  4. The expenses that are included, usually consultants 
  5. The markup on Reimbursable Expenses 
  6. The hourly rates that will be used
  7. The condition of the fee, estimated or fixed (maximum)


Things you want your bookkeeping system to report to you about fees.
Periodically you will want to review your status concerning fees to determine the amount that you can invoice for work that you have completed. This same report could show you the total remaining fee to bill, which would be a rough equivalent to the size of your work backlog.

The things you will want your bookkeeping system to report to you about fees.
  1. The percentage complete of each active Project-Phase
  2. The value of the work that has been completed for each active Project-Phase
  3. The amount that has been invoiced previously for each active Project-Phase
  4. The value of the work that has been completed for each active Project-Phase since the last invoice
  5. The amount remaining of the fee for each active Project-Phase 
  6. The total of each of the above values /amounts for all the active Project-Phases



INVOICES
Determining your profitability is possible as a result of the invoice process because each invoice that you create also creates an income transaction in bookkeeping to compare to the expenses incurred.

Things you want to document about invoices in your bookkeeping system.
When you create a new invoice, what are the things that you want to document?
  1. The ID designation for this invoice
  2. The invoice date
  3. The Project Name
  4. The Client Organization
  5. The timeframe to which the invoice refers
  6. The amount of the fee due per Project-Phase 
  7. The amount of any expenses that are due for this timeframe
  8. The total amount due for this invoice

From a client relationship viewpoint there may be other things that you feel should be included in the invoice. From a bookkeeping viewpoint this is what matters. 

Things you want your bookkeeping system to report about invoices.
When you review past invoices for a project, what are the things that you want to be shown?
  1. The ID designation for this invoice
  2. The invoice date
  3. The total amount due
  4. Days unpaid
  5. The amount of payment received
  6. The unpaid amount 
  7. Details of the actual invoice (a pdf and/or the bookkeeping data)

I had been planning to have a single Fees/Invoices database, but it has become clear that Invoices contain a different kind of data and will need their own database. 


Now the fun part begins - translating this concept into databases, forms and tables to actually implement the plan.

You can follow along by logging into the MyCorbu Test Drive account periodically and visiting the Bookkeeping >> Fees and Bookkeeping >> Invoices pages to see what it looks like and try it out for yourself.
Fees in MyCorbu
Subscribe To Architekwiki
Start Here

Comments are closed.
    Resources

    Start Here

    Picture

    Picture

    Trello-PM

    FeeCalqs

    Picture

    Terms of Use
    Your use of Architekwiki is implicit agreement with the 
    ​
    Terms of Use.

    RSS Feed


    Categories

    All
    Business Development
    Communications
    Concepts
    Design
    Detail
    Estimating
    Finances
    Legal Issues
    Management
    Miscellaneous
    Money
    MyCorbu
    People
    Planning
    Process
    Projects
    Records
    Services
    Specifications
    Standards
    Time
    Tools


    Archives

    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    June 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012

    Resources
VISIT ARCHITEKWIKI'S RESOURCES
Picture
Architekwiki | Architect's Resource | Greater Cincinnati | (859) 444-4560
© 2012-2020   Architekwiki​