<img height="1" width="1" style="display:none;" alt="" src="https://www.facebook.com/tr?id=880824774066981&amp;ev=PageView&amp;noscript=1">
Blog Home > Data and Tech > 10 AI Prompts To Get You Started in Vena Copilot for FP&A

10 AI Prompts To Get You Started in Vena Copilot for FP&A

Table of Contents

“Vena Copilot is like having an additional financial analyst on my team.”  

That’s what Vena customer Andrew McFarlane, Finance Manager for education SaaS company Kuali Inc., had to tell us after implementing our complete planning AI assistant, Vena Copilot for FP&A (Vena Copilot). As a one-person finance team, Andrew has used Vena Copilot to help answer the many queries he receives from across the business, while still freeing himself up for higher-value work.  

“It's helpful if someone comes to me with a question,” Andrew says. “I can almost copy and paste their question into Vena Copilot and it provides an answer for me that I can then send right back to them without having to open multiple files.” 

But notice how Andrew said he can “almost” cut and paste the questions coming from throughout his business. Almost” is the key word there. Because, as with most generative AI tools, the way you prompt Vena Copilot is going to go a long way in getting the answers you’re looking for. 

In this blog, I’ll go over some best practices to consider as you write prompts in Vena Copilot for your FP&A use cases. Then I’ll give you examples of ten successful Vena Copilot prompts to get you started. 

Key Takeaways

  • A complete planning assistant, Vena Copilot acts as an extension of your FP&A team, to answer questions from across the business. 

  • Think of Vena Copilot as a personal financial assistant for everyone in your business. 

  • Well-crafted AI prompts will help you get the most out of Vena Copilot. Take into consideration your goal, context and expectations, and include specificity such as dates.  

  • The ten prompts we’ve provided can help you get started as you look for answers related to revenue, operating expenses and profitability. 

How To Craft a Successful Prompt in Vena Copilot 

When it comes to generative AI, your best outputs will come from well-crafted prompts. Thankfully, if you know how to speak to a human—and ask for exactly what you want—you’re one step closer to understanding how to talk to an AI tool like Vena Copilot. 

But just because you're asking your question in a conversational tone doesn't mean your prompt should be sloppy or ill-informed. In the case of Microsoft Copilot, for instance, Microsoft guides their users to consider four parts to every prompt: goal, context, expectations and source. Since Vena is always the source for Vena Copilot, we only have three such considerations: 

  • Your goal: What do you want to do, exactly? 

  • The context: Why do you need this answer, and who is involved? 

  • Your expectations: How can Vena Copilot best fulfill the request? 

To achieve the best results, you’ll want to include at least two of these three aspects in every Vena Copilot prompt. This will help ensure the AI understands what you need and how to answer that request. But that’s only the start to creating a prompt that works. Specificity is also critical. 

Just think of the questions you’d ask your FP&A team—or at least the questions you’d ask if you wanted a detailed, well-thought-out answer. “What’s up with our business this year?” would probably earn you a blank look, wouldn’t it? Well, it’s also just as likely to get an error message from Vena Copilot, telling you your question is too ambiguous.  

Rather, the more specific the question, the better. Try to reference members (the data in your hierarchy within Vena) by name as much as possible and specify the month and year you’re asking about. 

For custom queries or calculations unique to your business, you may need to train Vena Copilot on how to find the answers you’re looking for (which you can do easily by adding to your saved Rules within Vena Copilot), but for more general queries like those below, that isn’t necessary. 

With that in mind, let’s look at some useful Vena Copilot prompts and why they work. 

10 Vena Copilot Prompts To Get You Started  

Vena Copilot empowers teams across your business by answering questions around any data that lives in your Vena database. And three of the most common areas of focus for teams querying Vena Copilot are revenue, operating expenses and profitability—so let’s look at some sample AI prompts for each of those FP&A categories. 

Vena Copilot Prompts on Revenue 

Everyone from your finance and operations teams to your sales and marketing teams are likely to come to you with questions about revenue. After all, it’s something everyone in the organization is invested in. Here are some sample Vena Copilot prompts related to revenue to get you, and those teams, started. 

"Which entity is driving my revenue growth in Q2 2024 compared to 2023?" 

This question could come from the FP&A team, an executive or anywhere else in the business. But it’s most likely to come during one of two main times: when monthly results are finalized and when forecasts and budgets are done. By referencing a historical comparison, you can see which areas of the business are growing, staying stagnant or falling behind. 

"In which months are our sales expected to grow the most in 2024?" 

For most businesses, sales are cyclical—which means there are always going to be months that see better results than others. It helps to understand what those trends look like as you budget or forecast for the months ahead. An AI prompt like this—whether it’s coming from FP&A, marketing or sales teams—can offer data on historical trends to help inform how you’re thinking of the future. 

"How much growth did we plan for in 2024?" 

This prompt offers teams a deeper understanding of the business goals for the year, letting you compare those goals to how you’re doing so far. This can help you understand how well you’re meeting those growth goals and where you might need to make changes to catch up. 

Vena Copilot Prompts on Operating Expenses

Every department in your business has an operating expenses budget or target. Which means that, even more so than revenue, they’re all likely to have questions about operating expenses. Here are some examples of the types of Vena Copilot prompts you could use to answer their questions faster, or they could use to self-serve. 

"What is the seasonality in my operating expenses for 2023?" 

Like revenue, operating expenses aren't always flat throughout the year—they go up and down throughout the months. Understanding when expenses were accrued in past years can help you forecast better when they’re likely to be accrued this year as well—so you can plan toward your target more effectively. 

"Which of my operating expense categories were biggest in 2023?" 

This kind of prompt helps you determine where your business is spending its money—whether it’s on salaries, advertising, promotions or something else entirely. Identifying your biggest expense categories helps you budget better and find areas where cuts can be made. 

"Which department spent the most in 2024?" 

Similarly, this prompt gives you a sense of how your expenses are distributed and which departments are racking up the most expenses. This allows you to set your budgets in a more equitable way for the year ahead and/or determine where cuts can be made or more value achieved.  

Vena Copilot Prompts on Profitability 

Profitability is usually more the focus of the FP&A team, rather than other departments throughout the business. That makes these example AI prompts most useful for FP&A specifically. You might find them helpful as you plan for the months and years ahead and analyze your past and future successes. 

"What is my gross margin compared to my plan for March in 2024?" 

Profitability can be nuanced, and by asking Vena Copilot for specific data such as gross margin, finance teams can begin to understand how expenses and revenue are influencing profit—and how to account for that in their plan going forward.  

"What is my year-over-year growth in profitability for June in 2024?" 

By offering insights on how growth occurred in the past, these kinds of AI prompts for FP&A can help finance teams create budgets and determine growth goals for the months and years ahead. Vena Copilot is pre-trained to define profitability as net income, but if your organization measures profitability in a different way, you can set this as a rule in your Vena Copilot instance. 

"How many months were we profitable in 2023?"

This prompt again can help pinpoint the seasonality of your business—that is, the months in which the business does well and when it’s less profitable. With that knowledge at your fingertips, you can begin to plan out your resource needs and spending. 

Getting Creative With Vena Copilot

Beyond answering questions about your business's data, Vena Copilot can also help you with asking questions. Here's an example.

 "Ask me 5 complicated questions about my Q2 2024 revenue variance as if I was in a board meeting"

Asking a question like the one you see above really flips the traditional roles around, where the AI model is creating questions for you to ask.

Coming full circle, you can then ask those questions to Vena Copilot to help your FP&A team pressure test their financial reporting. Playing with the tool to see how well it responds to your most challenging questions can reveal a lot about the model’s ability to comprehend your business.

Get Started Now 

By applying these well-crafted AI prompts, Vena Copilot can empower anyone across your business to access insights and detailed answers quickly—without putting extra burden on your FP&A team. And now that you know how to craft a successful prompt, there’s nothing stopping you from getting the most out of your virtual complete planning assistant.  

So good luck as you enable your entire organization and expand the capabilities of your FP&A team with Vena Copilot. 

Learn more about Vena Copilot for FP&A

copilot-cta-image

See Vena Copilot in Action

Request a demo to see how Vena Copilot can unlock your FP&A team's productivity.

Schedule Demo

About the Author

Anton Medvedev, Senior Product Manager, Vena

Anton Medvedev is a Senior Product Manager at Vena and has an extensive background at the intersection of finance and technology. He began his career working in Electronics manufacturing where he rose to the rank of Controller, driving various digital transformation initiatives. Anton has held a number of roles at Vena, including implementations consulting. Before his time as a Product Manager for Vena Copilot, he worked on Vena Insights and Preconfigured Solutions. Anton has CPA and CFA designations and is passionate about evolving the role of finance with new and exciting technologies.

Read More

How To Supercharge Productivity in FP&A With Vena Copilot

Learn how Vena Copilot, your Complete Planning AI assistant, helps your FP&A team complete work that used to take hours in just minutes.

Illustration of AI brain in centre of the frame, with bar charts going up in the left background, and bar charts going down in the right background.
The Definitive Guide to AI in FP&A: Benefits, Use Cases and Risks Explained

Experts in finance, business and technology weigh in on the potential use cases of AI in FP&A and the benefits and risks that come along with it.

An illustration of a brain surrounded by an Excel grid, Excel functions and various charts
How To Use AI for Financial Modeling and Forecasting

Learn the benefits of using AI for financial modeling and forecasting and see examples of how to do it, so you can get insights from financial data faster.

Shot of a group of university students working on computers in the library at campus
Customer Stories - Kuali

By providing faster answers to questions from stakeholders across the business, Vena Copilot frees up Kuali's one-person finance team to take on higher-value tasks.