Posted inUS_1

How To Download Bank Statements Into Excel?

No Comments

Downloading bank statements into Excel can significantly streamline your financial analysis and reporting. At bankprofits.net, we provide expert insights and tools to help you efficiently manage your financial data, empowering you to make informed decisions. This detailed guide provides comprehensive solutions for turning your bank statements into actionable Excel data, helping you gain a clearer picture of your financial health and boost bank profits. Stay tuned to discover the process and learn about the advantageous services available at bankprofits.net to streamline your financial workflows.

1. What Are The Benefits Of Downloading Bank Statements Into Excel?

Yes, downloading bank statements into Excel offers numerous benefits for financial analysis, reporting, and reconciliation. Excel’s robust features allow you to customize data views, perform calculations, and create insightful charts, providing a significant advantage in managing and understanding your finances.

  • Improved Data Analysis: Excel’s powerful features make analyzing financial data easier and more effective. You can sort, filter, and perform calculations to understand your spending habits and cash flow better.
  • Customizable Reporting: Excel enables you to create custom reports tailored to your specific needs. This level of customization is invaluable for financial planning, budgeting, and tracking key performance indicators (KPIs).
  • Efficient Reconciliation: Importing bank statements into Excel streamlines the reconciliation process. You can quickly match transactions with your internal records, identify discrepancies, and ensure accurate financial reporting.
  • Enhanced Data Visualization: With Excel, you can create charts and graphs to visualize your financial data. Visual representations make it easier to spot trends, patterns, and anomalies, helping you make informed decisions.
  • Time Savings: Automating data entry by downloading and importing bank statements saves time and reduces the risk of manual errors. This efficiency allows you to focus on strategic tasks rather than data management.
  • Better Financial Control: By centralizing your financial data in Excel, you gain better control over your finances. This comprehensive view helps you track your income, expenses, and investments, enabling you to make informed financial decisions.

2. What Are The Common File Formats For Bank Statements?

The answer is, Bank statements are commonly available in PDF, CSV, and other digital formats. Understanding these formats is crucial for efficiently importing your data into Excel.

  • PDF (Portable Document Format):
    • Description: A widely used format for documents that preserves formatting and is easily viewable across different devices.
    • Pros: Maintains the original layout and is universally accessible.
    • Cons: Requires conversion to a spreadsheet-compatible format like CSV or Excel.
  • CSV (Comma-Separated Values):
    • Description: A simple text format where values are separated by commas, making it easy to import into spreadsheets.
    • Pros: Highly compatible with Excel and other data analysis tools.
    • Cons: Does not retain formatting and may require some data cleaning.
  • Excel (XLSX):
    • Description: Microsoft Excel’s native format, offering a structured way to store data in rows and columns.
    • Pros: Retains formatting, formulas, and supports multiple sheets.
    • Cons: May not be as universally compatible as CSV.
  • OFX (Open Financial Exchange):
    • Description: A format specifically designed for exchanging financial data between institutions and software.
    • Pros: Secure and efficient for transferring banking information.
    • Cons: Requires specialized software or plugins to process.
  • QIF (Quicken Interchange Format):
    • Description: An older format used primarily by Quicken for importing financial data.
    • Pros: Compatible with various financial software.
    • Cons: Less secure and less versatile than newer formats like OFX.
  • TXT (Text File):
    • Description: A basic text format that stores data without formatting.
    • Pros: Simple and universally readable.
    • Cons: Requires significant data cleaning and formatting to be useful in Excel.

3. How To Download Bank Statements As CSV Files?

Downloading bank statements as CSV files is a straightforward process that simplifies importing your financial data into Excel. Most banks offer this option directly from their online banking platforms.

  1. Log into Your Online Banking Account:
    • Go to your bank’s website and enter your username and password to access your account.
  2. Navigate to the Statements or Account History Section:
    • Look for a tab or link labeled “Statements,” “Account History,” or something similar. The exact wording may vary depending on your bank.
  3. Select the Account and Date Range:
    • Choose the specific account you want to download the statement for (e.g., checking, savings, credit card). Then, specify the date range for the transactions you need.
  4. Choose CSV as the Download Format:
    • Most banks provide a dropdown menu or a list of available file formats. Select “CSV” (Comma-Separated Values) as your preferred format.
  5. Download the File:
    • Click the “Download,” “Export,” or similar button to start the download process. The file will typically be saved to your computer’s default download folder.
  6. Open the CSV File in Excel:
    • Launch Microsoft Excel and open the downloaded CSV file. Excel will automatically parse the data into columns based on the commas in the file.

4. What Is The Step-By-Step Guide To Converting PDF Bank Statements To Excel?

Yes, converting PDF bank statements to Excel involves several steps. This guide will walk you through the process, ensuring you can efficiently analyze your financial data.

  1. Choose a Conversion Method:
    • Online Converters: Use online tools like Smallpdf, Zamzar, or Online2PDF. These are convenient for occasional use.
    • Desktop Software: Install software like Adobe Acrobat Pro, Nitro PDF, or Able2Extract Professional for more frequent and advanced conversions.
    • Excel Power Query: Utilize Excel’s built-in Power Query feature (available in Excel 2010 and later) for direct PDF import.
  2. Convert PDF to Excel:
    • Using Online Converters:
      1. Go to your chosen online converter website.
      2. Upload your PDF bank statement.
      3. Select “Excel” or “CSV” as the output format.
      4. Click “Convert” and download the converted file.
    • Using Desktop Software:
      1. Open your PDF bank statement in the software.
      2. Select the “Convert to Excel” or similar option.
      3. Adjust settings as needed (e.g., page range, output format).
      4. Click “Convert” and save the Excel file.
    • Using Excel Power Query:
      1. Open Excel and go to the “Data” tab.
      2. Click “Get Data” > “From File” > “From PDF.”
      3. Select your PDF bank statement and click “Import.”
      4. In the Navigator window, choose the table containing your data and click “Transform Data.”
  3. Clean and Format the Data:
    • Remove Unnecessary Rows and Columns: Delete any headers, footers, or irrelevant information.
    • Split Columns: Use Excel’s “Text to Columns” feature (Data > Text to Columns) to separate combined data into individual columns.
    • Format Dates and Numbers: Ensure dates and numbers are correctly formatted for calculations.
    • Correct Data Types: Change the data type of each column to match the content (e.g., date, text, currency).
  4. Verify the Data:
    • Check for Errors: Review the data for any conversion errors or inconsistencies.
    • Compare with Original: Cross-reference the converted data with your original bank statement to ensure accuracy.
  5. Save Your Excel File:
    • Save the file in the desired Excel format (.xlsx or .xls).

4.1. How to Use Power Query to Import Data from PDF Files Directly?

Yes, Power Query in Excel can directly import data from PDF files, eliminating the need for intermediate conversion. Here’s how to do it.

  1. Open Excel and Access Power Query:

    • Open Microsoft Excel.
    • Go to the “Data” tab on the ribbon.
    • Click on “Get Data” in the “Get & Transform Data” group.
    • Select “From File” and then “From PDF.”

  2. Select and Import the PDF File:

    • Browse to the location of your PDF bank statement.
    • Select the file and click “Import.”

  3. Navigate and Transform Data:

    • A “Navigator” window will appear, showing the tables and pages in the PDF.
    • Select the table that contains your bank statement data.
    • Click on “Transform Data” to open the Power Query Editor.

    *Source: https://www.excel-university.com/import-pdf-data-into-excel-with-power-query/

  4. Clean and Shape the Data:

    • Remove Unnecessary Rows: Use “Remove Rows” to delete headers, footers, or blank rows.
    • Promote Headers: If the first row contains column headers, click “Use First Row as Headers.”
    • Adjust Data Types: Change the data type of each column (e.g., date, text, currency) by clicking the icon next to the column name.
    • Filter Data: Use the “Filter” option to remove irrelevant transactions or rows.
    • Rename Columns: Double-click on column headers to rename them for clarity.

  5. Load the Data into Excel:

    • Click “Close & Load” to load the transformed data into an Excel worksheet.

  6. Refresh the Data:

    • To update the data, right-click on the table in Excel and select “Refresh.”

5. How Do I Clean Up Bank Activity Data In Excel Using Power Query?

Yes, cleaning up bank activity data in Excel using Power Query is crucial for accurate analysis. Power Query’s tools can transform raw data into a structured, usable format.

  1. Import Your Data into Power Query:

    • Open Excel and go to the “Data” tab.
    • Click “Get Data” > “From File” > “From CSV” or “From PDF,” depending on your file type.
    • Select your bank statement file and click “Import.”

  2. Open Power Query Editor:

    • In the Navigator window, select the data you want to import and click “Transform Data” to open the Power Query Editor.

  3. Remove Unnecessary Rows:

    • Remove Top Rows: Click “Remove Rows” > “Remove Top Rows.” Enter the number of rows to remove (e.g., headers or titles).

    • Remove Bottom Rows: Click “Remove Rows” > “Remove Bottom Rows.” Enter the number of rows to remove (e.g., footers or summaries).

    • Remove Blank Rows: Click “Remove Rows” > “Remove Blank Rows.”

  4. Promote Headers:

    • If the first row contains column headers, click “Use First Row as Headers” in the “Transform” tab.

  5. Rename Columns:

    • Double-click on a column header to rename it. Use descriptive names like “Date,” “Description,” “Amount,” and “Category.”

  6. Adjust Data Types:

    • Click the icon next to the column name to change the data type. Ensure “Date” columns are set to “Date,” “Amount” columns are set to “Currency” or “Decimal Number,” and “Description” columns are set to “Text.”

  7. Split Columns:

    • If a column contains combined data (e.g., date and time), select the column and click “Split Column” > “By Delimiter.” Choose the appropriate delimiter (e.g., space) and split into separate columns.

  8. Filter Data:

    • Use the filter option to remove irrelevant transactions or rows based on specific criteria. Click the dropdown arrow in the column header and select the desired filters.

  9. Add Conditional Columns:

    • Click “Add Column” > “Conditional Column” to create new columns based on conditions. This is useful for categorizing transactions.
    • For example, to categorize transactions as “Income” or “Expense,” create a new column named “Category.” Set the condition to check if the “Amount” column is greater than 0, then assign “Income”; otherwise, assign “Expense.”

  10. Replace Values:

    • Select a column and click “Replace Values” in the “Transform” tab to replace specific text or characters. This is useful for standardizing descriptions or removing unwanted characters.

  11. Group By:

    • Use the “Group By” feature to summarize data. For example, group by “Category” to see total income and expenses.

  12. Close and Load:

    • Click “Close & Load” to load the transformed data into an Excel worksheet.

6. How Can I Categorize Bank Transactions In Excel?

Yes, categorizing bank transactions in Excel is essential for effective financial analysis. There are several methods to categorize your transactions, depending on your needs and the complexity of your data.

  1. Manual Categorization:

    • Add a Category Column: Insert a new column in your Excel sheet and label it “Category.”
    • Assign Categories: Manually review each transaction and enter a category (e.g., “Groceries,” “Utilities,” “Rent,” “Income”).
    • Pros: Simple and requires no advanced Excel skills.
    • Cons: Time-consuming and prone to errors, especially with large datasets.

  2. Using Excel Formulas:

    • IF Statements: Use IF formulas to assign categories based on transaction descriptions. For example: 
      =IF(ISNUMBER(SEARCH("Walmart",B2)),"Groceries",IF(ISNUMBER(SEARCH("Netflix",B2)),"Entertainment","Other"))

      This formula checks if the description in cell B2 contains “Walmart” or “Netflix” and assigns the corresponding category.

    • VLOOKUP: Create a category lookup table and use VLOOKUP to assign categories based on transaction descriptions.
      1. Create a new sheet with two columns: “Description Keywords” and “Category.”
      2. List keywords in the “Description Keywords” column (e.g., “Walmart,” “Netflix”) and their corresponding categories in the “Category” column.
      3. Use the following formula in your main data sheet: 
        =VLOOKUP("*"&B2&"*",Sheet2!A:B,2,FALSE)

        Replace Sheet2!A:B with the range of your lookup table.

    • Pros: More efficient than manual categorization and reduces errors.
    • Cons: Requires some Excel formula knowledge and can be complex for intricate categorization.

  3. Using Power Query:

    • Conditional Columns: Use Power Query to create conditional columns that assign categories based on transaction descriptions.

      1. Import your data into Power Query (Data > Get Data).
      2. In the Power Query Editor, click “Add Column” > “Conditional Column.”
      3. Define your conditions and corresponding categories. For example:
        • If “Description” contains “Walmart,” then Category = “Groceries.”
        • If “Description” contains “Netflix,” then Category = “Entertainment.”
        • Else Category = “Other.”
      4. Click “OK” and load the data back into Excel.

    • Pros: Highly flexible and efficient for large datasets.

    • Cons: Requires familiarity with Power Query.

  4. Using Pivot Tables:

    • Create a Pivot Table: Use pivot tables to summarize your transactions by category.
      1. Select your data and click “Insert” > “PivotTable.”
      2. Drag the “Category” field to the “Rows” area and the “Amount” field to the “Values” area.
    • Pros: Provides a dynamic summary of your categorized data.
    • Cons: Requires data to be categorized first.

7. How Do I Analyze Bank Statement Data For Financial Insights?

Yes, analyzing bank statement data is crucial for gaining valuable financial insights. By using Excel’s analytical tools, you can uncover patterns, trends, and anomalies that help you make informed decisions.

  1. Set Up Your Data:
    • Import and Clean Data: Import your bank statement data into Excel and clean it using Power Query or manual methods. Ensure columns are correctly labeled and data types are accurate.
    • Categorize Transactions: Categorize your transactions into meaningful categories (e.g., Income, Groceries, Utilities, Entertainment).
  2. Use Pivot Tables:
    • Create a Pivot Table: Select your data range and click “Insert” > “PivotTable.”
    • Summarize Data: Drag the “Category” field to the “Rows” area and the “Amount” field to the “Values” area. This will create a summary of your spending by category.
    • Add Filters: Use the “Filters” area to filter data by date range, transaction type, or other criteria.
    • Pros: Provides a dynamic summary of your data and allows for easy manipulation and analysis.
  3. Create Charts and Graphs:
    • Select Data: Select the data you want to visualize (e.g., category totals from a pivot table).
    • Insert a Chart: Click “Insert” and choose a chart type (e.g., bar chart, pie chart, line chart).
    • Customize Your Chart: Add titles, labels, and adjust formatting to make the chart clear and informative.
    • Pros: Visual representations make it easier to identify trends and patterns.
  4. Calculate Key Metrics:
    • Total Income and Expenses: Use the SUM function to calculate total income and expenses.
    • Net Cash Flow: Calculate net cash flow by subtracting total expenses from total income.
    • Average Spending: Calculate average spending per category or time period using the AVERAGE function.
    • Pros: Provides a quantitative view of your financial performance.
  5. Trend Analysis:
    • Time Series Analysis: Use line charts to visualize trends over time. Plot income and expenses over months or years to identify patterns.
    • Moving Averages: Calculate moving averages to smooth out fluctuations and highlight long-term trends.
    • Pros: Helps you understand how your financial situation changes over time.
  6. Variance Analysis:
    • Budget vs. Actual: Compare your actual spending to your budget to identify variances.
    • Calculate Variances: Subtract budgeted amounts from actual amounts to calculate variances.
    • Investigate Significant Variances: Focus on significant variances to understand why they occurred and take corrective action.
    • Pros: Helps you stay on track with your financial goals and identify areas where you may be overspending.
  7. Ratio Analysis:
    • Savings Rate: Calculate your savings rate by dividing total savings by total income.
    • Debt-to-Income Ratio: Calculate your debt-to-income ratio by dividing total debt payments by total income.
    • Pros: Provides insights into your financial health and stability.
  8. Conditional Formatting:
    • Highlight Key Data: Use conditional formatting to highlight key data points, such as large transactions or over-budget spending.
    • Set Rules: Create rules based on specific criteria (e.g., highlight amounts greater than $1000, highlight categories where spending exceeds budget).
    • Pros: Draws attention to important information and makes it easier to spot anomalies.

8. What Excel Functions Are Most Useful For Analyzing Bank Statements?

Yes, several Excel functions are particularly useful for analyzing bank statements. Mastering these functions can significantly enhance your ability to extract meaningful insights from your financial data.

  1. SUM:
    • Purpose: Calculates the sum of a range of values.
    • Usage: =SUM(A1:A100) to calculate the total of values in cells A1 to A100.
    • Example: Calculate total income or total expenses from your bank statement.
  2. AVERAGE:
    • Purpose: Calculates the average of a range of values.
    • Usage: =AVERAGE(A1:A100) to calculate the average of values in cells A1 to A100.
    • Example: Calculate average monthly spending on groceries.
  3. COUNT:
    • Purpose: Counts the number of cells in a range that contain numbers.
    • Usage: =COUNT(A1:A100) to count the number of cells with numbers in the range A1 to A100.
    • Example: Count the number of transactions in a specific month.
  4. COUNTA:
    • Purpose: Counts the number of cells in a range that are not empty.
    • Usage: =COUNTA(A1:A100) to count the number of non-empty cells in the range A1 to A100.
    • Example: Count the total number of transactions in your bank statement.
  5. COUNTIF:
    • Purpose: Counts the number of cells within a range that meet a given criterion.
    • Usage: =COUNTIF(B1:B100,"Groceries") to count the number of transactions categorized as “Groceries” in the range B1 to B100.
    • Example: Count the number of transactions in a specific category.
  6. SUMIF:
    • Purpose: Sums the values in a range that meet a given criterion.
    • Usage: =SUMIF(B1:B100,"Groceries",A1:A100) to sum the amounts in the range A1 to A100 where the corresponding category in B1 to B100 is “Groceries.”
    • Example: Calculate total spending in a specific category.
  7. IF:
    • Purpose: Performs a logical test and returns one value if the test is true and another value if the test is false.
    • Usage: =IF(A1>0,"Income","Expense") to classify a transaction as “Income” if the amount in cell A1 is greater than 0, and “Expense” otherwise.
    • Example: Classify transactions as income or expense based on the amount.
  8. AND:
    • Purpose: Returns TRUE if all its arguments are TRUE.
    • Usage: =AND(A1>0,B1="Groceries") to check if the amount in cell A1 is greater than 0 and the category in cell B1 is “Groceries.”
    • Example: Combine multiple conditions for more complex logic.
  9. OR:
    • Purpose: Returns TRUE if any argument is TRUE.
    • Usage: =OR(B1="Groceries",B1="Restaurants") to check if the category in cell B1 is either “Groceries” or “Restaurants.”
    • Example: Check if a transaction falls into one of several categories.
  10. VLOOKUP:
    • Purpose: Looks for a value in the first column of a table and returns a value in the same row from a specified column.
    • Usage: =VLOOKUP(B1,Sheet2!A1:B100,2,FALSE) to look up the value in cell B1 in the table on Sheet2 (range A1:B100) and return the value from the second column.
    • Example: Automatically categorize transactions based on keywords in the description.
  11. SEARCH:
    • Purpose: Finds the starting position of one text string within another text string.
    • Usage: =SEARCH("Walmart",B1) to find the starting position of “Walmart” in the text in cell B1.
    • Example: Identify transactions from specific merchants.
  12. ISNUMBER:
    • Purpose: Checks whether a value is a number.
    • Usage: =ISNUMBER(A1) to check if the value in cell A1 is a number.
    • Example: Verify that amounts are correctly formatted as numbers.
  13. LEFT, RIGHT, MID:
    • Purpose: Extracts a specified number of characters from the start, end, or middle of a text string.
    • Usage:
      • =LEFT(A1,5) to extract the first 5 characters from the text in cell A1.
      • =RIGHT(A1,5) to extract the last 5 characters from the text in cell A1.
      • =MID(A1,2,5) to extract 5 characters from the text in cell A1, starting from the second character.
    • Example: Extract specific information from transaction descriptions.
  14. DATE:
    • Purpose: Returns the serial number that represents a particular date.
    • Usage: =DATE(2024,1,1) to return the date January 1, 2024.
    • Example: Create a date from separate year, month, and day values.
  15. YEAR, MONTH, DAY:
    • Purpose: Returns the year, month, or day of a date.
    • Usage:
      • =YEAR(A1) to return the year of the date in cell A1.
      • =MONTH(A1) to return the month of the date in cell A1.
      • =DAY(A1) to return the day of the date in cell A1.
    • Example: Extract date components for analysis.

9. How Can I Automate The Process Of Downloading And Importing Bank Statements?

Yes, automating the process of downloading and importing bank statements can save significant time and reduce manual effort.

  1. Use Financial Management Software:
    • Software Options: Consider using financial management software like QuickBooks, Xero, or Mint. These platforms can automatically download bank transactions and import them into your accounting system.
    • Setup: Link your bank accounts to the software and configure automatic transaction downloads.
    • Pros: Streamlines the entire process and often includes advanced features like transaction categorization and reporting.
  2. Excel Power Query with Web Queries:
    • Web Queries: If your bank provides a web-based interface with accessible data, you can use Excel’s Power Query to create web queries that automatically pull data from the website.
    • Setup:
      1. Go to “Data” > “Get Data” > “From Web.”
      2. Enter the URL of the webpage containing your bank statement data.
      3. Follow the prompts to select the table or data you want to import.
      4. Set up a refresh schedule to automatically update the data.
    • Pros: Automates data extraction from websites.
    • Cons: Requires technical knowledge and may not work with all websites due to security restrictions.
  3. Third-Party Automation Tools:
    • Tools: Explore third-party automation tools like Zapier or IFTTT (If This Then That). These platforms can connect to your bank’s API (if available) and automatically download statements to a cloud storage service or directly into Excel.
    • Setup:
      1. Create an account on the automation platform.
      2. Connect your bank account (if supported) and your Excel or cloud storage account.
      3. Create a “Zap” or “Applet” to automatically download statements based on a schedule or trigger.
    • Pros: Flexible and can connect to a wide range of services.
    • Cons: May require technical knowledge and depends on the availability of APIs.
  4. Robotic Process Automation (RPA):
    • RPA Software: Use RPA software like UiPath or Automation Anywhere to create bots that mimic human actions to download and import bank statements.
    • Setup:
      1. Design a bot to log into your online banking account.
      2. Navigate to the statements section.
      3. Download the statements in the desired format (CSV, Excel).
      4. Import the data into Excel and perform any necessary cleaning or formatting.
      5. Schedule the bot to run automatically at specified intervals.
    • Pros: Highly customizable and can handle complex tasks.
    • Cons: Requires advanced technical skills and can be expensive to implement.
  5. Custom Scripting:
    • Scripting Languages: Use scripting languages like Python or VBA (Visual Basic for Applications) to write custom scripts that automate the download and import process.
    • Setup:
      1. Write a script to log into your online banking account using web scraping libraries (e.g., Selenium, Beautiful Soup).
      2. Navigate to the statements section.
      3. Download the statements.
      4. Import the data into Excel using libraries like Pandas (for Python) or VBA.
      5. Schedule the script to run automatically using task scheduling tools.
    • Pros: Highly flexible and can be tailored to your specific needs.
    • Cons: Requires advanced programming skills and may be challenging to maintain.
  6. Bank APIs:
    • API Access: Check if your bank offers an API (Application Programming Interface) that allows you to programmatically access your account data.
    • Setup:
      1. Obtain API credentials from your bank.
      2. Write a script or use a tool to connect to the API and retrieve your bank statement data.
      3. Import the data into Excel.
      4. Schedule the script to run automatically.
    • Pros: Secure and efficient way to access bank data.
    • Cons: Requires technical knowledge and depends on the availability of APIs.

10. What Are Some Tips For Ensuring Data Accuracy When Downloading Bank Statements?

Yes, ensuring data accuracy when downloading bank statements is crucial for reliable financial analysis.

  1. Verify the Source:
    • Official Bank Website: Always download bank statements directly from your bank’s official website or mobile app.
    • Avoid Third-Party Sites: Be cautious of third-party websites offering bank statement downloads, as they may not be secure.
  2. Check File Integrity:
    • File Size: Compare the file size of the downloaded statement with previous statements to ensure it is within a reasonable range.
    • File Format: Ensure the file is in the expected format (e.g., PDF, CSV, XLSX).
  3. Review Date Ranges:
    • Correct Dates: Double-check that the date range selected for the download is correct and includes all the transactions you need.
    • Avoid Overlapping Dates: Ensure there are no overlapping dates between different statements to prevent duplicate entries.
  4. Inspect the Downloaded Data:
    • Open Immediately: Open the downloaded file immediately after downloading to inspect the data.
    • Check for Missing Data: Look for any missing transactions or incomplete information.
  5. Compare with Previous Statements:
    • Cross-Reference: Compare the downloaded statement with previous statements to ensure consistency and identify any discrepancies.
    • Look for Anomalies: Check for unusual or unexpected transactions.
  6. **Use Data Validation

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *