Key Points
- 1.ChatGPT Work uses plugins to pull data from Google Drive and NetSuite into a single workspace.
- 2.A prompt is entered to review recent finance materials from Google Drive against NetSuite posts, which results in a publication decision of no-go due to discrepancies.
- 3.ChatGPT identifies that NetSuite posted an update to actuals in June and that an outdated forecast is flowing through the revenue memo.
- 4.ChatGPT provides an ordered correction sequence to update the model, re-evaluate the memo, and regenerate outputs before sending updates.
- 5.Using browser functionality embedded within chat, comments can be sent directly to team members in Google Sheets and slides can be cross-checked.
Summary
The video demonstrates how to use ChatGPT Work to deliver board-ready reporting by reconciling financial materials and identifying discrepancies. The presenter starts in the ChatGPT interface, navigates to the work tab, and prepares to work on a quarterly finance review. The materials include a revenue memo for executives, a board package, and a financial model. Using the plugins functionality, ChatGPT pulls data from Google Drive and checks it against what has been posted in NetSuite within the underlying financial system.
The user enters a prompt asking ChatGPT to review the latest finance materials from Google Drive and compare them against NetSuite posts. Because there are thousands of rows and multiple tabs, the analysis results in a publication decision of no-go due to two critical issues. The first issue is that NetSuite posted an update to actuals in June, and an outdated forecast is flowing through the revenue memo compared to what is housed in the financial model. ChatGPT highlights these areas in red and provides a breakdown of findings, including severity ratings and affected artifacts such as memo pages and board slides.
ChatGPT helps guide the user through fixing these errors. The workflow allows the user to click into materials to review sources of truth and see recommended passages to update. For instance, the Monthly Forecast24 contains the approved H2 API forecast. The user can use browser functionality embedded within chat to open documents, such as Google Sheets, and add a note or comment asking the team to make corrections. The presenter shows how to navigate through impacted tabs in spreadsheets and presentation decks.
After the team makes updates, the user can rerun the prompt. ChatGPT provides an ordered correction sequence, which includes replacing the monthly forecast data with the posted H2 API actual, recalculating the model, updating the memo, regenerating affected outputs, and rerunning the finance sign-off. The presenter notes that this process provides confidence in the numbers before they are published to the world. Furthermore, this skill can be extended from a thirty-four page board deck to broader board decks with hundreds of pages to cross-check numbers and surface conflicting themes across different documentations.
Using ChatGPT Work for Financial Review
The presenter demonstrates navigating to the work tab in ChatGPT and prompting it to review finance materials housed in Google Drive against NetSuite updates. This process surfaces two critical issues that result in a no-go publication decision for the current cycle.
Identifying Discrepancies and Guidance
ChatGPT highlights specific errors, including a June update in NetSuite that differs from the revenue memo. The system guides the user through fixing the errors one by one and provides an ordered correction sequence.
Collaborating and Extending Workflows
Browser functionality embedded in chat allows the user to open Google Sheets and add comments or notes for team members to fix issues. This workflow can be extended to large board decks to cross-check numbers and surface conflicting themes.
Worth watching for
Financial analysts and business professionals who manage reporting, forecasting, and board decks using tools like Google Drive and NetSuite.
- chatgpt
- finance
- reporting
- forecast
- googledrive
- netsuite