Streamlining Financial Management with Empress Bank Statement Import

Product Support
1

Introduction

The Bank Statement Import feature in Empress is designed to streamline your financial management processes by allowing you to import bank statements directly into your Empress system. This feature eliminates the need for manual entry, thereby saving time and reducing the risk of errors.

What Does the Bank Statement Import Feature Do?

The Bank Statement Import feature enables you to:

  • Import bank statements from your preferred file format or directly from Google Sheets.
  • Preview imported data before finalizing the import process.
  • Track the import status and view any import errors or warnings.

How to Use the Bank Statement Import Feature

Step 1: Accessing the Feature

To access this feature, navigate to Empress > Accounts > Bank Statement Import.

Step 2: Importing a Bank Statement

You can import a bank statement in two ways:

  • Upload a file: Click on the “Import File” button and select the bank statement file from your device.
  • Use Google Sheets: Paste the publicly accessible URL of your Google Sheets document in the “Import from Google Sheets” field and click “Refresh Google Sheet.”

Note: Google Sheet should have a column for “Bank Account” for successful import.

Step 3: Previewing the Import

After uploading a file or refreshing a Google Sheet, a preview of the import will appear in the “Import Preview” section. Review this to ensure that all data is correct.

Step 4: Finalizing the Import

Once you’ve reviewed the preview, click “Submit After Import” to finalize the import process. If there are any issues, they will appear in the “Import Warnings” section.

User Roles and Permissions

This feature is accessible to users with the “System Manager” role. These users have the permissions to create, delete, export, print, read, report, share, and write within this feature.

Conclusion

The Bank Statement Import feature is a powerful tool for businesses to streamline their financial processes. By allowing for direct import of bank statements, it reduces manual work, increases efficiency, and minimizes errors.

For further assistance or more information, please refer to our user guides or contact our support team.