Procedure documentationExporting Bank Accounts

Prerequisites

  • You use Microsoft Office 2010 or higher that contains Microsoft Excel.

  • You have enabled the Developer tab in Microsoft Excel

    To do so, in your Microsoft Excel, go to Start of the navigation path File Next navigation step Options Next navigation step Customize Ribbon Next navigation step Customize the Ribbon End of the navigation path, select the Developer checkbox and choose OK.

Procedure

  1. In the Manage Bank Accounts app, choose Import and Export Bank Accounts.

  2. To export the bank accounts, choose Export Bank Accounts to an XML File.

  3. Save the file Bank_Accounts.xml.

    The file contains all the existing bank account master data in your system in XML format. If you like, you can directly make changes to the XML file.

  4. To edit your file in spreadsheet format, choose Download XML Spreadsheet Template.

  5. Save and open the file XML_SpreadSheet_Template.xml.

  6. On the Developer tab, choose Import and then select the file Bank_Accounts.xml.

    You can now view and make changes to your bank account in spreadsheet format.

More Information

Importing Bank Accounts