--- title: "Excel finance data: free practice file with tasks and answers | PracticeExcel" description: "A free finance file with a year of bank transactions for a small firm. With 14 tasks on income, expenses, results, SUMIFS by month and percentages, and answers." canonical_url: "https://practiceexcelonline.com/learn/excel-finance-practice-data" meta: "og:description": "A free finance file with a year of bank transactions for a small firm. With 14 tasks on income, expenses, results, SUMIFS by month and percentages, and answers." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgZmluYW5jZSBkYXRhOiBmcmVlIHByYWN0aWNlIGZpbGUgd2l0aCB0YXNrcyBhbmQgYW5zd2Vycw%2Cdescription_~QSBmcmVlIGZpbmFuY2UgZmlsZSB3aXRoIGEgeWVhciBvZiBiYW5rIHRyYW5zYWN0aW9ucyBmb3IgYSBzbWFsbCBmaXJtLiBXaXRoIDE0IHRhc2tzIG9uIGluY29tZSwgZXhwZW5zZXMsIHJlc3VsdHMsIFNVTUlGUyBieSBtb250aCBhbmQgcGVyY2VudGFnZXMsIGFuZCBhbnN3ZXJzLg%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1maW5hbmNlLXByYWN0aWNlLWRhdGEi%2Cs_ag1dgFGoc143g5lw.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "Excel finance data: free practice file with tasks and answers | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgZmluYW5jZSBkYXRhOiBmcmVlIHByYWN0aWNlIGZpbGUgd2l0aCB0YXNrcyBhbmQgYW5zd2Vycw%2Cdescription_~QSBmcmVlIGZpbmFuY2UgZmlsZSB3aXRoIGEgeWVhciBvZiBiYW5rIHRyYW5zYWN0aW9ucyBmb3IgYSBzbWFsbCBmaXJtLiBXaXRoIDE0IHRhc2tzIG9uIGluY29tZSwgZXhwZW5zZXMsIHJlc3VsdHMsIFNVTUlGUyBieSBtb250aCBhbmQgcGVyY2VudGFnZXMsIGFuZCBhbnN3ZXJzLg%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1maW5hbmNlLXByYWN0aWNlLWRhdGEi%2Cs_ag1dgFGoc143g5lw.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **Excel finance data: free practice file with tasks and answers** A free finance file with a year of bank transactions for a small firm. With 14 tasks on income, expenses, results, SUMIFS by month and percentages, and answers. By Nicolaj, founder of PracticeExcel · Updated November 12, 2026 · 11 min read Finance work in Excel starts with a list of transactions. Before anyone builds a budget, a forecast or a dashboard, somebody has to answer the simple questions from the bank statement: how much came in, how much went out, what did we spend on rent and what is left at the end of the year? Here is a year of transactions you can practice those questions on, with an answer key. The file is the business bank account of a small consulting firm in 2025: 188 entries with date, voucher number, description, category and amount. Income is positive and expenses are negative, just as they come out of a bank. That one detail decides how you write most of the formulas. Solve the tasks in the file first, then check your answers on this page. ## Finance data: a year of bank transactions **Free with an account** ### **Finance data for Excel practice** A year of bank transactions for a small firm: 188 entries with date, voucher, description, category and amount. For SUMIF, SUMIFS and percentages. **What's in the file** - **Transactions:** 188 bank transactions from 2025 with date, voucher number, description, category and amount. [**Create a free account to download**](https://practiceexcelonline.com/signup?next=/learn/excel-finance-practice-data%23download-transactions) [Already have an account? Log in](https://practiceexcelonline.com/login?next=/learn/excel-finance-practice-data%23download-transactions) Excel file (.xlsx). It also opens in Google Sheets. The account is free and also saves your progress in the exercises. The **Transactions** sheet has one row per entry and five columns: | **Column** | **Contents** | **Example** | | --- | --- | --- | | A Date | The date of the entry in 2025 | Mar 3, 2025 | | B Voucher | A running number from 1 to 188 | 42 | | C Description | What the entry is, like Invoice 1017 or Rent, March | Rent, March | | D Category | Sales, Rent, Salaries, Software, Bank fees, Marketing, Travel or Office | Rent | | E Amount | Positive for income, negative for expenses | -18,500 | Every income entry is a paid invoice in the Sales category. Everything else is an expense: rent on the first weekday of each month, salaries on the last, two software subscriptions, bank fees, and a scattering of marketing, travel and office costs through the year. The entries are sorted by date, and the voucher numbers follow that order. ## Signs matter The single most important thing in a transaction list is the sign. Because expenses are negative, `**=SUM(E2:E189)**` gives the result for the year directly: income minus expenses, with no extra work. It also means the total expenses come out as a negative number. That is correct, but it surprises people the first time. When you present the numbers, you usually want expenses as positive numbers. Wrap them in ABS, or multiply by -1. Do that in the summary, not in the data. If you flip the signs in the data, every formula that relies on them breaks. ## Read the account before you calculate Spend two minutes with the data before you write a formula. Click the filter button on **Category** and look at the list: eight categories, each spelled one way. Filter on Rent and you should see twelve rows, one per month. Filter on Salaries and you should see twelve more. If a month is missing, or there are thirteen, you want to know that before you report a total. Then look at the amounts. Sort a copy by **Amount** and glance at both ends. The largest invoices are at the bottom and the largest costs at the top. Anything that looks odd, like a rent payment twice the usual size, is worth a question to whoever made the file. In a real account, that is how you find double payments and missing refunds. Finally, check that the dates cover the year. `**=MIN(A2:A189)**` and `**=MAX(A2:A189)**` give the first and last date. Format both cells as dates. An account that starts in February is missing a month, and every total for the year will be too low. ## How to use the file Open the file and go to the **Tasks** sheet. Each task has a number, a question and an empty cell for your answer. Write your formulas on the **Transactions** sheet, in an empty column to the right of the data, and type the result next to the task. Then compare it with the answer on this page. The data runs from row 2 to row 189. The answers use exact ranges like E2:E189. Save a copy before you sort or delete anything, because the answers only match the data as it is in the file. Use the filter buttons to check an answer by eye: filter on Rent, select the **Amount** column and read the sum on the status bar. ## How to approach a task Most finance questions come down to three choices. Make them before you type: 1. **Which sign?** Income, expenses or both. That decides whether the criterion is ">0", "<0" or no criterion at all. 2. **Which rows?** A category, a period, or both. Each one becomes a pair of a range and a criterion in SUMIFS. 3. **Which form?** A total, a count, an average or a share. A share needs two totals and a division, and usually a ROUND. Then do a rough check. Rent for the year should be twelve times the monthly rent. Sales in one quarter should be somewhere near a quarter of the income for the year. Expenses in one month should be close to a twelfth of the yearly expenses, unless that month had something special in it. An answer that is ten times too big or has the wrong sign is almost always a range or a criterion, not the math. ## Formula tasks on the finance data The tasks start with the three numbers every set of accounts begins with, then go into categories, periods and percentages. They are in the same order as in the file. ### **Formulas on the finance data** The tasks use the file Finance data for Excel practice. **Get the file** 1. **1\.** What is the total income for the year?
**Show the answer** **$2,386,000** Formula:=SUMIF(E2:E189,">0")
2. **2\.** What are the total expenses for the year?
**Show the answer** **$-1,458,748** Formula:=SUMIF(E2:E189,"<0")
3. **3\.** What is the result for the year, income minus expenses?
**Show the answer** **$927,252** Formula:=SUM(E2:E189)
4. **4\.** How much was spent on rent in total?
**Show the answer** **$-222,000** Formula:=SUMIF(D2:D189,"Rent",E2:E189)
5. **5\.** What were the sales in the first quarter?
**Show the answer** **$755,000** Formula:=SUMIFS(E2:E189,D2:D189,"Sales",A2:A189,">="&DATE(2025,1,1),A2:A189,"<"&DATE(2025,4,1))
6. **6\.** What were the total expenses in March?
**Show the answer** **$-120,984** Formula:=SUMIFS(E2:E189,E2:E189,"<0",A2:A189,">="&DATE(2025,3,1),A2:A189,"<"&DATE(2025,4,1))
7. **7\.** What is the largest single expense?
**Show the answer** **$-98,000** Formula:=MIN(E2:E189)
8. **8\.** What is the largest single invoice?
**Show the answer** **$59,250** Formula:=MAX(E2:E189)
9. **9\.** How many invoices were paid during the year?
**Show the answer** **80** Formula:=COUNTIF(D2:D189,"Sales")
10. **10\.** What is the average invoice? Round to a whole number.
**Show the answer** **$29,825** Formula:=ROUND(AVERAGEIF(D2:D189,"Sales",E2:E189),0)
11. **11\.** What share of all expenses goes to salaries? Round to three decimals.
**Show the answer** **74.9%** Formula:=ROUND(SUMIF(D2:D189,"Salaries",E2:E189)/SUMIF(E2:E189,"<0"),3)
12. **12\.** What is the profit margin, the result as a share of income? Round to three decimals.
**Show the answer** **38.9%** Formula:=ROUND(SUM(E2:E189)/SUMIF(E2:E189,">0"),3)
13. **13\.** By how much did travel costs change from the first half of the year to the second? Round to three decimals.
**Show the answer** **50%** Formula:=ROUND(SUMIFS(E2:E189,D2:D189,"Travel",A2:A189,">="&DATE(2025,7,1))/SUMIFS(E2:E189,D2:D189,"Travel",A2:A189,"<"&DATE(2025,7,1))-1,3)
14. **14\.** What does voucher 150 say in the Description column?
**Show the answer** **Invoice 1068** Formula:=XLOOKUP(150,B2:B189,C2:C189)
### Income, expenses and result SUMIF can add up a column based on a condition on the same column. Leave out the third argument, and it adds up the cells it checks: `**=SUMIF(E2:E189,">0")**` That is every positive amount, so all the income. Swap the criterion for "<0" and you get all the expenses, as a negative number. The result for the year is just `**=SUM(E2:E189)**`, and it should equal the income plus the expenses. Check that it does. Practice the number condition in [**SUMIF with a number condition**](https://practiceexcelonline.com/practice/sumif/sumif-greater-than). ### Totals per category The rent for the year is a SUMIF with a text criterion on the category column: `**=SUMIF(D2:D189,"Rent",E2:E189)**` Here the third argument is needed, because you check one column and add up another. The answer is negative, because rent is an expense. Twelve months of the same rent should give twelve times the monthly amount, which makes this a nice one to check by head. Practice it in [**SUMIF with a text criterion**](https://practiceexcelonline.com/practice/sumif/sumif-text-criteria). ### A category in a period Sales in the first quarter is two kinds of condition at once: the category and a date range. SUMIFS takes the range to add up first, then pairs of range and criterion: `**=SUMIFS(E2:E189,D2:D189,"Sales",A2:A189,">="&DATE(2025,1,1),A2:A189,"<"&DATE(2025,4,1))**` The two date conditions catch every date from Jan 1 up to, but not including, Apr 1. Using "less than the first of the next period" means you never have to remember how many days a month has. The same structure gives the expenses in March: swap the category condition for E2:E189 with "<0", and move the dates. Practice it in [**SUMIFS with two conditions**](https://practiceexcelonline.com/practice/sumifs/sumifs-two-conditions). ### The largest entries Because expenses are negative, the largest expense is the smallest number. `**=MIN(E2:E189)**` finds it, and `**=MAX(E2:E189)**` finds the largest invoice. It looks backwards the first time, so say it out loud: the biggest cost is the most negative number. Practice MAX in [**Find the best month with MAX**](https://practiceexcelonline.com/practice/minmax/max-function). To see what the largest expense was, look up the amount and return the description: `**=XLOOKUP(MIN(E2:E189),E2:E189,C2:C189)**`. If two entries share the same amount, XLOOKUP returns the first one. ### Count and average invoices `**=COUNTIF(D2:D189,"Sales")**` counts the invoices, and AVERAGEIF gives the average invoice: `**=ROUND(AVERAGEIF(D2:D189,"Sales",E2:E189),0)**` Compare the average with the largest invoice. When the largest is twice the average, a single customer can make or break a month, and that is worth knowing. ### Shares and margins The share of all expenses that goes to salaries is the salaries divided by the total expenses: `**=ROUND(SUMIF(D2:D189,"Salaries",E2:E189)/SUMIF(E2:E189,"<0"),3)**` Both numbers are negative, so the result is positive. Format the cell as a percentage. In a consulting firm, salaries are by far the biggest cost, and this number shows how much room the rest of the budget has. The profit margin is the result as a share of income: `**=ROUND(SUM(E2:E189)/SUMIF(E2:E189,">0"),3)**` The guide to [**calculating percentages in Excel**](https://practiceexcelonline.com/learn/calculate-percentage-excel) has more on shares and how to format them. ### Change from one period to another Percent change is new divided by old, minus one. For travel costs from the first half of the year to the second: `**=ROUND(SUMIFS(E2:E189,D2:D189,"Travel",A2:A189,">="&DATE(2025,7,1))/SUMIFS(E2:E189,D2:D189,"Travel",A2:A189,"<"&DATE(2025,7,1))-1,3)**` The formula is long, but it is just two SUMIFS. The first takes travel from Jul 1 onward, the second travel before Jul 1. Both are negative, so the signs cancel out. A positive answer means travel costs went up. Practice the idea in [**Percent change from last year**](https://practiceexcelonline.com/practice/percentages/percent-change). ### Look up a voucher An accountant who asks about voucher 150 wants the entry behind it. The voucher number is unique, so XLOOKUP finds it: `**=XLOOKUP(150,B2:B189,C2:C189)**` Swap C2:C189 for E2:E189 to get the amount, or for A2:A189 to get the date. Format that cell as a date, or you see the serial number Excel stores dates as. ## Build a monthly overview Once you have solved the tasks, pull the year together in a small overview with one row per month. Type the first day of each month in column G, from Jan 1, 2025 in G2 to Dec 1, 2025 in G13. Next to it, add up the income for the month: `**=SUMIFS($E$2:$E$189,$E$2:$E$189,">0",$A$2:$A$189,">="&G2,$A$2:$A$189,"<"&EDATE(G2,1))**` EDATE returns the same day one month later, so the formula takes every positive amount from the first of the month up to the first of the next. Make a copy with "<0" for the expenses, and a third column that adds the two for the result. Fill all three down and add a total row. The totals should match the income, expenses and result for the year. Add a column for the cumulative result, with `**=J2**` in the first row and `**=K2+J3**` in the next, filled down. It shows how the year built up month by month, and it makes a good line chart. The guide to [**Excel charts**](https://practiceexcelonline.com/learn/excel-charts) shows how. That overview is the backbone of most monthly reports. A [**pivot table**](https://practiceexcelonline.com/learn/pivot-tables) with the date grouped by month gives you the same numbers in a few clicks, but building it once with formulas teaches you what the pivot table does. ## A summary per category The monthly overview shows the year over time. A summary per category shows where the money goes. Type the eight categories in column M, from M2 to M9, and add up each one next to it: `**=SUMIF($D$2:$D$189,M2,$E$2:$E$189)**` Lock the ranges with $ so they stay put when you fill down, while M2 moves to the next category. Add a column with each category's share of the total expenses, and sort the summary from the largest cost to the smallest. Leave Sales out of the share, or it comes out negative and makes no sense. The sum of the eight rows should equal the result for the year. If it doesn't, a category in the data is spelled differently from the one in your list. That check takes ten seconds and catches the most common mistake in category summaries. ## Bank account or accounts? A bank account is not the same as the books. This file shows money in and money out on the day it moved. Real accounts also deal with sales tax, invoices sent but not yet paid, costs that belong to another year, and equipment written off over several years. The result here is closer to the cash flow for the year than to the profit an accountant would report. That doesn't make the practice less useful. The formulas are the same, and most small businesses look at exactly this kind of list every week: what came in, what went out and how much is left. The guide to [**Excel for finance**](https://practiceexcelonline.com/learn/excel-for-finance) covers the step from here to budgets, loans and investments. ## Practice without an answer key - **Make a budget.** Type a budget for each category in a small table, then add the actual numbers next to it with SUMIF and the difference in a third column. Practice the idea in [**What is left after the bills**](https://practiceexcelonline.com/practice/budget-in-excel/monthly-budget-left-over). - **Show expenses as positive numbers** in your overview with ABS, without changing the data. - **Find the busiest month for sales** by sorting your monthly overview, or with INDEX and MATCH on the income column. - **Add a running balance.** Assume an opening balance of 250,000 in a cell of its own and add each amount to the balance above it. Check that the last balance equals the opening balance plus the result. - **Color the negative months** in the cumulative result with conditional formatting. - **Build a pivot table** with categories in rows, months in columns and the sum of **Amount** as values. ## When an answer doesn't match - **A sign the wrong way.** Expenses are negative. A positive expense total means you used ">0", or flipped the sign somewhere. - **The share of a negative number.** Divide expenses by expenses and income by income. Mixing them gives a negative share. - **Dates as text in the criterion.** ">=3/1/2025" can mean January 3 on another computer. Use DATE. - **A period that leaks.** "<=" with the last day of the month misses entries with a time in them, and an end date one month too late doubles a month. Use "<" and the first of the next month. - **Rounding too early.** Round the final result, not the totals inside it. ## Finance data and Excel tests Transaction lists like this one are a favorite in Excel tests for jobs in accounting, finance and controlling. The tasks are almost always the same: income and expenses, a category total, a month, a share, a change from one period to another. What separates a good answer from a quick one is checking: does the result equal income plus expenses, does the monthly overview add up to the year? More in the guide to [**Excel for job interviews**](https://practiceexcelonline.com/learn/excel-for-job-interviews), and the wider picture in [**Excel for finance**](https://practiceexcelonline.com/learn/excel-for-finance). ## Finance data in Google Sheets The file works in Google Sheets. Upload it to Google Drive and open it with Google Sheets. SUMIF, SUMIFS, EDATE and XLOOKUP work the same way, and the currency format comes along. See the differences in [**Google Sheets vs. Excel**](https://practiceexcelonline.com/learn/google-sheets-vs-excel). ## More practice data This file is one of several free datasets with tasks and answers: - [**Sales and employee data**](https://practiceexcelonline.com/learn/excel-practice-data): 240 orders and 60 employees, for SUMIF, COUNTIFS, averages and dates. - [**Inventory data**](https://practiceexcelonline.com/learn/excel-inventory-data): 80 products with stock and prices, for XLOOKUP and SUMPRODUCT. - [**Customer data**](https://practiceexcelonline.com/learn/excel-customer-data): 150 customers, for lookups, text functions and counting with two conditions. - [**Messy data**](https://practiceexcelonline.com/learn/excel-data-cleaning-practice): 60 orders full of extra spaces, text numbers and duplicates, for cleanup practice. ## In short A transaction list with income as positive and expenses as negative numbers answers a lot with a little. SUMIF with ">0" and "<0" splits income from expenses, SUM gives the result, SUMIFS cuts by category and period, and a division gives shares, margins and changes. Mind the signs, use DATE in date conditions and check that the parts add up to the whole. To drill one formula at a time on a small sheet, start with the exercises below. They check your answer right away and show a hint when the formula is wrong. The first exercise in each topic is free. ![Nicolaj](https://practiceexcelonline.com/authors/nicolaj.webp) **About the author** ## **Nicolaj**, founder of PracticeExcel I'm a software developer, and I built PracticeExcel from scratch, including the spreadsheet itself and the engine that calculates the formulas. To make that work, I had to understand every function down to the details: how VLOOKUP behaves when a code has one space too many, why a date is really a number, and when ROUND gives a different answer than the number format. [More about Nicolaj](https://practiceexcelonline.com/about#nicolaj) ## **Practice what this guide covers** Graded exercises in a real grid, in the order the guide uses them. - [**SUMIF with a text criterion**SUMIF →](https://practiceexcelonline.com/practice/sumif/sumif-text-criteria) - [**SUMIF with a number condition**SUMIF →](https://practiceexcelonline.com/practice/sumif/sumif-greater-than) - [**SUMIFS with two conditions**SUMIFS →](https://practiceexcelonline.com/practice/sumifs/sumifs-two-conditions) - [**Percent change from last year**Percentages →](https://practiceexcelonline.com/practice/percentages/percent-change) - [**Find the best month with MAX**MIN, MAX and LARGE →](https://practiceexcelonline.com/practice/minmax/max-function) - [**What is left after the bills**Budget →](https://practiceexcelonline.com/practice/budget-in-excel/monthly-budget-left-over) ### **Function pages** - [**SUMIF**](https://practiceexcelonline.com/functions/sumif) - [**SUMIFS**](https://practiceexcelonline.com/functions/sumifs) - [**SUM**](https://practiceexcelonline.com/functions/sum) - [**MIN**](https://practiceexcelonline.com/functions/min) - [**MAX**](https://practiceexcelonline.com/functions/max) - [**COUNTIF**](https://practiceexcelonline.com/functions/countif) - [**AVERAGEIF**](https://practiceexcelonline.com/functions/averageif) - [**ROUND**](https://practiceexcelonline.com/functions/round) - [**XLOOKUP**](https://practiceexcelonline.com/functions/xlookup) ## **Questions**
### Where can I find finance data to practice Excel? This page has a free file with a year of bank transactions for a small consulting firm, 188 entries with date, voucher number, description, category and amount. The file has a sheet of 14 tasks, and the answers are on this page.
### Which Excel functions do I need for finance data? SUMIF with ">0" and "<0" for income and expenses, SUM for the result, SUMIFS for a category in a period, MIN and MAX for the largest entries, AVERAGEIF for the average invoice and ROUND for shares and percentages.
### How do I separate income and expenses in Excel? When income is positive and expenses are negative in the same column, SUMIF with the criterion ">0" adds up the income and "<0" adds up the expenses. SUM of the whole column gives the result.
### Are the files free? Yes. The columns, tasks and answers are on this page. You download the file itself with a free PracticeExcel account, which also saves your progress in the exercises.
### Does the finance file work in Google Sheets? Yes. Upload it to Google Drive and open it with Google Sheets. Every task can be solved with the same formulas.
## **More guides** - [**Excel practice data: free datasets with tasks and answers**Two free Excel files to practice on: 240 sales orders and 60 employees. With 29 tasks on SUMIF, COUNTIF, lookups and dates, and answers you can check.](https://practiceexcelonline.com/learn/excel-practice-data) - [**Excel inventory data: free practice file with tasks and answers**A free inventory file with 80 products to practice on: stock, reorder points, cost and price. With 12 tasks on XLOOKUP, SUMPRODUCT and COUNTIFS, and the answers.](https://practiceexcelonline.com/learn/excel-inventory-data) - [**Excel customer data: free practice file with tasks and answers**A free customer list with 150 customers to practice on: names, emails, cities, orders and spend. With 13 tasks on COUNTIFS, XLOOKUP, text functions and dates.](https://practiceexcelonline.com/learn/excel-customer-data) - [**Excel data cleaning practice: a messy file with tasks and answers**A free messy Excel file to practice cleanup on: extra spaces, wrong case, text numbers, text dates, mixed phone formats and duplicates. With 14 tasks and answers.](https://practiceexcelonline.com/learn/excel-data-cleaning-practice) - [**Excel for finance and accounting: the skills you actually use**The Excel skills finance and accounting teams use every day, from SUMIFS on a ledger and budget variances to rounding, month-end dates, PMT, NPV and check totals.](https://practiceexcelonline.com/learn/excel-for-finance) ```json {"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#webpage","dateModified":"2026-11-12","datePublished":"2026-11-12","description":"A free finance file with a year of bank transactions for a small firm. With 14 tasks on income, expenses, results, SUMIFS by month and percentages, and answers.","name":"Excel finance data: free practice file with tasks and answers","url":"https://practiceexcelonline.com/learn/excel-finance-practice-data","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#/schema/question/1"},{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#/schema/question/2"},{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#/schema/question/3"},{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#/schema/question/4"},{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/learn/excel-finance-practice-data"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel guides","item":"https://practiceexcelonline.com/learn","position":2},{"@type":"ListItem","name":"Excel finance data: free practice file with tasks and answers","position":3}]},{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#article","@type":"Article","dateModified":"2026-11-12","datePublished":"2026-11-12","description":"A free finance file with a year of bank transactions for a small firm. With 14 tasks on income, expenses, results, SUMIFS by month and percentages, and answers.","headline":"Excel finance data: free practice file with tasks and answers","inLanguage":"en-US","thumbnailUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgZmluYW5jZSBkYXRhOiBmcmVlIHByYWN0aWNlIGZpbGUgd2l0aCB0YXNrcyBhbmQgYW5zd2Vycw%2Cdescription_~QSBmcmVlIGZpbmFuY2UgZmlsZSB3aXRoIGEgeWVhciBvZiBiYW5rIHRyYW5zYWN0aW9ucyBmb3IgYSBzbWFsbCBmaXJtLiBXaXRoIDE0IHRhc2tzIG9uIGluY29tZSwgZXhwZW5zZXMsIHJlc3VsdHMsIFNVTUlGUyBieSBtb250aCBhbmQgcGVyY2VudGFnZXMsIGFuZCBhbnN3ZXJzLg%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1maW5hbmNlLXByYWN0aWNlLWRhdGEi%2Cs_ag1dgFGoc143g5lw.png","author":{"@id":"https://practiceexcelonline.com/#/schema/person/1"},"image":{"@id":"https://practiceexcelonline.com/#/schema/image/1"},"isPartOf":{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#webpage"},"mainEntityOfPage":{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#webpage"},"publisher":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Where can I find finance data to practice Excel?","acceptedAnswer":{"@type":"Answer","text":"This page has a free file with a year of bank transactions for a small consulting firm, 188 entries with date, voucher number, description, category and amount. The file has a sheet of 14 tasks, and the answers are on this page."}},{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Which Excel functions do I need for finance data?","acceptedAnswer":{"@type":"Answer","text":"SUMIF with \">0\" and \"\u003C0\" for income and expenses, SUM for the result, SUMIFS for a category in a period, MIN and MAX for the largest entries, AVERAGEIF for the average invoice and ROUND for shares and percentages."}},{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I separate income and expenses in Excel?","acceptedAnswer":{"@type":"Answer","text":"When income is positive and expenses are negative in the same column, SUMIF with the criterion \">0\" adds up the income and \"\u003C0\" adds up the expenses. SUM of the whole column gives the result."}},{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"Are the files free?","acceptedAnswer":{"@type":"Answer","text":"Yes. The columns, tasks and answers are on this page. You download the file itself with a free PracticeExcel account, which also saves your progress in the exercises."}},{"@id":"https://practiceexcelonline.com/learn/excel-finance-practice-data#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"Does the finance file work in Google Sheets?","acceptedAnswer":{"@type":"Answer","text":"Yes. Upload it to Google Drive and open it with Google Sheets. Every task can be solved with the same formulas."}},{"@id":"https://practiceexcelonline.com/#/schema/person/1","@type":"Person","description":"I'm a software developer, and I built PracticeExcel from scratch, including the spreadsheet itself and the engine that calculates the formulas. To make that work, I had to understand every function down to the details: how VLOOKUP behaves when a code has one space too many, why a date is really a number, and when ROUND gives a different answer than the number format.","jobTitle":"founder of PracticeExcel","name":"Nicolaj","url":"https://practiceexcelonline.com/about#nicolaj","image":{"@id":"https://practiceexcelonline.com/#/schema/image/2"}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgZmluYW5jZSBkYXRhOiBmcmVlIHByYWN0aWNlIGZpbGUgd2l0aCB0YXNrcyBhbmQgYW5zd2Vycw%2Cdescription_~QSBmcmVlIGZpbmFuY2UgZmlsZSB3aXRoIGEgeWVhciBvZiBiYW5rIHRyYW5zYWN0aW9ucyBmb3IgYSBzbWFsbCBmaXJtLiBXaXRoIDE0IHRhc2tzIG9uIGluY29tZSwgZXhwZW5zZXMsIHJlc3VsdHMsIFNVTUlGUyBieSBtb250aCBhbmQgcGVyY2VudGFnZXMsIGFuZCBhbnN3ZXJzLg%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1maW5hbmNlLXByYWN0aWNlLWRhdGEi%2Cs_ag1dgFGoc143g5lw.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgZmluYW5jZSBkYXRhOiBmcmVlIHByYWN0aWNlIGZpbGUgd2l0aCB0YXNrcyBhbmQgYW5zd2Vycw%2Cdescription_~QSBmcmVlIGZpbmFuY2UgZmlsZSB3aXRoIGEgeWVhciBvZiBiYW5rIHRyYW5zYWN0aW9ucyBmb3IgYSBzbWFsbCBmaXJtLiBXaXRoIDE0IHRhc2tzIG9uIGluY29tZSwgZXhwZW5zZXMsIHJlc3VsdHMsIFNVTUlGUyBieSBtb250aCBhbmQgcGVyY2VudGFnZXMsIGFuZCBhbnN3ZXJzLg%2Ceyebrow_Excel%2Bguides%2Csite_practiceexcel%2Cp_Ii9sZWFybi9leGNlbC1maW5hbmNlLXByYWN0aWNlLWRhdGEi%2Cs_ag1dgFGoc143g5lw.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/2","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/authors/nicolaj.webp","inLanguage":"en-US","url":"https://practiceexcelonline.com/authors/nicolaj.webp"}]} ``` ## Sitemap See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.