Quick Books Database to Excel spreadsheet with Pivot Table
$30-5000 USD
Closed
Posted about 13 years ago
$30-5000 USD
Paid on delivery
We need an Excel Spreadsheet designed that pulls from our QuickBooks database in real time. It needs to combine two standard reports, with some filtering, into a single spreadsheet.
## Deliverables
We need to combine our open order report with our inventory report into an Excel spreadsheet. We need the spreadsheet to show us units ordered, units available, units needed of 15-20 products, by customer. We need the spreadsheet to update automatically in real time, as it will be kept on our internal website for readily available access. I believe that a Pivot Table is the key component to making this work. Some have described this as an 'available resource report'.