On this page
Work with budgets
- Create & collaborate on budget proposals
- Brainstorm in real time about budgets & strategies
- Create financial statements & budgets with templates
Visualize and organize data
- Build financial models to assess projects
- Show fluctuations using pivot tables or waterfall charts
- Organize financial information with functions
Collaborate and share content
- Share & manage file access for cross-functional teams
- Conduct internal surveys & analyze results
- Create presentations for proposals & planning
- Host real-time metrics & data visualizations on a website
- Use generative AI at work
Create & collaborate on budget proposals
Draft a budget proposal for a project and get feedback from your team using Google Docs. The people you share the draft with can add comments and suggest inline edits. You can then respond to comments and obtain the necessary approvals. In the revision history, there’s an audit trail to see who made which changes and you can revert to a previous version at any time.
Brainstorm in real time about budgets & strategies
After you confirm your project budget, get your team involved by collaborating in a Google Meet video meeting. Share a link in the meeting to your budget spreadsheets in Google Sheets that everyone can edit and use to brainstorm. Then, during the call, start strategizing together and writing down ideas so everyone is on the same page.
Create financial statements & budgets with templates
Create financial statements and balance the books with a Sheets template from Xero Accounting Software. Use a template from Intuit Quickbooks to track your annual income and expenses.
Get templates now: Google Sheets template gallery
Build financial models to assess projects
To find out if your proposed project is worthwhile, create financial models using Sheets. Calculate internal rate of return (IRR), return on investment (ROI), and net present value (NPV). See the impact of what-if scenarios by adjusting key inputs in your model. Show when costs approach budget limitations using conditional formatting colors. Then, share the spreadsheet with your team to get their feedback.
Learn how at the Google Docs Editors Help Center
Show fluctuations using pivot tables or waterfall charts
See how your company’s profit changes quarterly from year to year with a waterfall chart. Or, group total sales from different regions so you can see a combined subtotal in a pivot table.
Organize financial information with functions
Sheets makes it easy to bring order and meaning to financial data. Move financial data from several spreadsheets into a single spreadsheet with the IMPORTRANGE function. Add stock prices to visualize trends with the GOOGLEFINANCE function.
Share & manage file access for cross-functional teams
Finance teams often work cross-functionally with other departments, such as marketing and sales. Keeping everyone in the loop can be a daunting task, whether you’re hosting an internal discussion with staff members or communicating between different departments. Google Groups makes it easy to communicate quickly with everyone at once. You can also limit how confidential or sensitive project information is shared by only adding certain people to a group. After adding email accounts to a group, you can send an email.
Conduct internal surveys & analyze results
If your finance department is providing services to another group, you can measure the quality of those services with an internal survey. Or, help prioritize projects by sending stakeholders a survey to collect financial data. You can also streamline your operations using internal surveys to identify redundant processes or procedures that have marginal value. Use Google Forms to build and send your survey. Then, quickly analyze the responses captured in Sheets to inform team decisions.
Create presentations for proposals & planning
When beginning a project, craft a visually compelling proposal with Google Vids and Slides. Share the presentation with your team so everyone can add their feedback.
Learn how:
Host real-time metrics & data visualizations on a website
When working cross-functionally, team members often need key metrics on topics, such as budgets, ROI, and bottom lines. Create an internal team website in Google Sites to host this data as well as links to important documents. Then, use permissions and Groups to control access to sensitive information.
Use generative AI at work
If your organization supports it, you can use the artificial intelligence add-on, Gemini for Google Workspace. Use Gemini directly in Google Workspace apps like Docs, Sheets, Slides, Meet, Vids, and Gmail, to help you write, visualize, organize, and connect. You can also use Gemini as a standalone experience at gemini.google.com.
Learn how