--- title: "Legacy Manage CSV Bank Activity Mapping" slug: "legacy-manage-csv-bank-activity-mapping" description: "View, edit, and delete saved CSV column mappings for bank activity imports in the legacy experience." updated: 2025-10-18T02:19:54Z published: 2025-10-23T11:00:22Z canonical: "docs.restaurant365.com/legacy-manage-csv-bank-activity-mapping" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt > Use this file to discover all available pages before exploring further. # Legacy Manage CSV Bank Activity Mapping [Importing CSV bank files](/doc/docs/import-csv-bank-activity) requires mapping of bank data to R365 [Bank Activity](/doc/docs/bank-activity-import-overview) columns. Once saved, users can view, edit, or delete saved mappings in the [CSV Map Fields Window](/doc/docs/csv-map-fields-window). The import process must be completed to edit saved mappings. --- ## Security To view, edit, or delete saved CSV mappings, users must have the following permission: Banking → Bank Activity → Process Bank Activity --- ## View Saved Mappings A file must be imported to open the [CSV Map Fields window](/doc/docs/csv-map-fields-window) and view saved mappings. *Click steps to expand for additional information and images.* ****1) Download** bank activity from the bank website.** Users can download bank transactions from their desired bank account and date range. Example Screenshot: ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-AKE0KDF2.png) ****2)** In the **accounting** application, under **Banking**, select **Get Bank Activity**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-8BQXDXE9.png) The [Bank Activity page](/doc/docs/bank-activity-page) will open. ****3)** Click **Upload a File** in the top ribbon.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-N55PMD1G.png) ****4)** Select the **Bank Account** to upload transactions to.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-DHCCC3N3.png) ****5)** Select the **CSV File Type**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-CBOADJNN.png) ****6)** Click **Select Files** to open the files explorer.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-TRYN6CCC.png) ****7)** Navigate to the folder the bank activity was downloaded to.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-743PT51X.png) ****8)** Find and select the downloaded **bank file.**** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-LJGDZ4CR.png) The [Map Fields window](/doc/docs/csv-map-fields-window) will open. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-I289BUIK.png) ****9)** Click the **Saved Mapping** dropdown to view all saved mappings.** Selecting a saved mapping will display the saved fields. From there mappings can be edited and saved. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-IL2XEQ76.png) ## Edit Saved Mappings A file must be imported to open the [CSV Map Fields window](/doc/docs/csv-map-fields-window) and edit saved mappings. *Click steps to expand for additional information and images.* ****1) Download** bank activity from the bank website.** Users can download bank transactions from their desired bank account and date range. Example Screenshot: ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-54WLWWI0.png) ****2)** In the **Accounting** application, under **Banking**, select **Get Bank Activity**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-RK79G2JX.png) The [Bank Activity page](/doc/docs/bank-activity-page) will open. ****3)** Click **Upload a File** in the top ribbon.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-N55PMD1G.png) ****4)** Select the **Bank Account** to upload transactions to.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-HV0HGPVJ.png) ****5)** Select the **CSV File Type**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-CBOADJNN.png) ****6)** Click **Select Files** to open the files explorer.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-TRYN6CCC.png) ****7)** Navigate to the folder the bank activity was downloaded to.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-743PT51X.png) ****8)** Find and select the downloaded **bank file.**** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-LJGDZ4CR.png) The [Map Fields window](/doc/docs/csv-map-fields-window) will open. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-I289BUIK.png) ****9)** Select the **Saved Mapping** from the dropdown menu.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-1SRGVPJ4.png) ****10)** Edit the desired [fields](/doc/docs/csv-map-fields-window).** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-07MYSFGA.png) > [!NOTE] > The Name field accepts a maximum of 200 characters. Exceeding this limit may result in an import error. > [!NOTE] > The Comment field accepts a maximum of 300 (excluding spaces). > > If spaces are included in the CSV file, the system will still accept a total of 300 characters but will automatically remove the spaces during the import. > > Exceeding this limit may result in an import error. ****11)** Click the checkbox to **Save mapping for future CSV imports.**** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-C0DCB1Z9.png) ****12)** Enter the name of the previously saved mapping to override the old mapping.** Ensure the entered name matches the previously saved mapping name exactly. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-VB9BL72C.png) ****13)** Click **Save Mapping & Import .**** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-WW8MYHHC.png) The updated mapping will override the previous mapping. --- ## Delete Saved Mappings A file **must be** imported to open the [CSV Map Fields window](/doc/docs/csv-map-fields-window) and delete saved mappings. *Click steps to expand for additional information and images.* ****1) Download** bank activity from the bank website.** Users can download bank transactions from their desired bank account and date range. Example Screenshot: ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-N7UZ9YO0.png) ****2)** In the **Accounting** application, under **Banking**, select **Get Bank Activity**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-O2KO59N5.png) The [Bank Activity page](/doc/docs/bank-activity-page) will open. ****3)** Click **Upload a File** in the top ribbon.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-N55PMD1G.png) ****4)** Select the **Bank Account** to upload transactions to.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-ZLHH7KNY.png) ****5)** Select the **CSV File Type**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-CBOADJNN.png) ****6)** Click **Select Files** to open the files explorer.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-TRYN6CCC.png) ****7)** Navigate to the folder the bank activity was downloaded to.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-743PT51X.png) ****8)** Find and select the downloaded **bank file.**** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-LJGDZ4CR.png) The [Map Fields window](/doc/docs/csv-map-fields-window) will open. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-I289BUIK.png) ****9)** Click the **Saved Mapping** dropdown to view all saved mappings.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-IL2XEQ76.png) ****10)** Click the **trashcan button** next to the mappings to be deleted.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-KG3O0Z08.png) ****11)** Click **delete** in the confirmation window.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-G5VQP5EL.png)