monthly projection table creation
Hi, I'm wondering the best approach to having entries in a table called "Billing Projections" created when a project is created under our project management (Projects have many Billing Projections)...
Forum Discussion
Andrew,
Yes we do create placeholders. We have a few tables and here is the structure:
Projects has Many Opportunities
Opportunities has many orders
Orders has many Invoices
By doing this (since it sounds like we are both in the construction world based on your AIA comment) I can capture change orders etc as trackable opportunities and separate orders. I can pass all that data up to the root project.
Our Project Coordinators create the "expected" billing schedule and update as we go. That allows us to have somewhat accurate projections. A bit too early to test though as we joined Quick Base 4 months ago and just launched the app last week. It was in development up to this point.
I thought about going with a target opening date and dividing the amount over several months leading up to that via formula. But since it is schedule of values that would never be accurate.
------------------------------
Ivan Weiss
------------------------------
Yes we do create placeholders. We have a few tables and here is the structure:
Projects has Many Opportunities
Opportunities has many orders
Orders has many Invoices
By doing this (since it sounds like we are both in the construction world based on your AIA comment) I can capture change orders etc as trackable opportunities and separate orders. I can pass all that data up to the root project.
Our Project Coordinators create the "expected" billing schedule and update as we go. That allows us to have somewhat accurate projections. A bit too early to test though as we joined Quick Base 4 months ago and just launched the app last week. It was in development up to this point.
I thought about going with a target opening date and dividing the amount over several months leading up to that via formula. But since it is schedule of values that would never be accurate.
------------------------------
Ivan Weiss
------------------------------
Ivan,
We are a custom fabricator, so often we have AIAs that come from GCs. Other projects are directly with the client, which is a lot easier when it comes to legal and billing. I'm sure we've both had fun trying to deal with the complexities that AIAs can have. My job at the company is my first exposure to them and when I work with our head of billing on structure, I get popsicle headaches. However, our more experienced PMs are aware of this and should be able to semi-accurately project out for budgeting.
We're also new to QB. I've been designing for the past few months around our existing system w/many, many improvements and needed features, which QB has allowed. I'm not sure if I'll be able to tackle all the AIA complexities. It sounds like we're in similar boats on all of this.
Do you have plans to integrate one of the QuickBooks plugins? We use desktop QB, so my intent was to design Billing around the needed structure after looking at the few plugins out there.
------------------------------
Andrew Ryder
------------------------------
We are a custom fabricator, so often we have AIAs that come from GCs. Other projects are directly with the client, which is a lot easier when it comes to legal and billing. I'm sure we've both had fun trying to deal with the complexities that AIAs can have. My job at the company is my first exposure to them and when I work with our head of billing on structure, I get popsicle headaches. However, our more experienced PMs are aware of this and should be able to semi-accurately project out for budgeting.
We're also new to QB. I've been designing for the past few months around our existing system w/many, many improvements and needed features, which QB has allowed. I'm not sure if I'll be able to tackle all the AIA complexities. It sounds like we're in similar boats on all of this.
Do you have plans to integrate one of the QuickBooks plugins? We use desktop QB, so my intent was to design Billing around the needed structure after looking at the few plugins out there.
------------------------------
Andrew Ryder
------------------------------
- I would love to integrate with Quick Books. However, I have heard it is not the best vs the online version. We sync our travel expense software to Quick Books and it is a nightmare. It goes down every other day etc.
I am actually hoping I can build enough functionality over time into the Quick Base app where perhaps we can just go to the online version of Quick Books and eliminate the desktop version. If we get the reporting and data into Quick Base I really just need the pure accounting functions.
But that is prob Phase 3 or 4 of this project lol. It has been a beast to build it. This was a self created position on top of all of my daily duties. But as a labor of love it is really exciting how it is comng together.
And since it launched last week I have not seen my picture on a dart board so that is good :)
------------------------------
Ivan Weiss
------------------------------
