Transaction import v1 workflow

Assumptions

For v1 transaction import, the following scenarios are based on the assumption the products will send the querystring parameters as stated in the integration document.

Contents

• Scenario 1 Successful file upload (CSV file with debit and credit amounts)
• Scenario 2 Successful file upload (CSV file with dDebit and credit amounts - overlapping dates)
• Scenario 3 Successful file upload (CSV file with only debit amounts)
• Scenario 4 Successful file upload (CSV file with debit amounts - flip signs → debit to credit)
• Scenario 5 Successful file upload (CSV file with credit amounts - flip signs → credit to debit)
• Scenario 6 Cancel file import

Scenario 1

Successful file upload (CSV file with debit and credit amounts)

1. Select file type (required).

2. Select the file that will be used for import (required).

   

3. Select the order of dates displayed in the file uploaded in previous step (required).

4. Add comments (required). The regex used to validate special characters that are not allowed is:

   /(?=.*^[\w])(?!.*[÷$%^&*()_+|~={}[\]:;<>@#\r\n])/

5. Upload file button will be enabled only when all the selections and conditions are met.

6. Click on Upload file.

   

7. System will now upload the file and backend APIs will validate the file content. If there are any errors or issues with file or selected options (like file type or date format), the appropriate error will be shown to the user.

   

8. After the file is uploaded without errors, users needs to verify the type of transaction displayed from the uploaded file.

   

9. Users need to make their selection for the Verify button be enabled and proceed.

   <img src=”../images/scenario1-5.png” width=”700px” alt=”Image displaying a transaction from the selected file for the user to determine whether it’s money in or out of the account. Money into the account is selected. />

10. Review transactions will be displayed with all the data from the uploaded file. All the transactions, bank account details, bank details, transaction date ranges will be displayed.
11. Transactions without minus(-) will be displayed as type Money in (Credit)

12. Transactions with minus(-) will be displayed as type Money out (Debit)

    

13. User can review 1 last time before importing transactions. When reviewed, user needs select the Import transactions button.
14. System will now start and process the import.
15. File import is done successfully.
16. User will be routed back to the product page.

Scenario 2

Successful file upload (CSV file with debit and credit amounts - overlapping dates)_

1. Select file type (required).

2. Select the file that will be used for import (required).

   

3. Select the order of dates displayed in the file uploaded in previous step (required).

4. Add comments (required). The regex used to validate special characters that are not allowed is:

   /(?=.*^[\w])(?!.*[÷$%^&*()_+|~={}[\]:;<>@#\r\n])/

5. Upload file button will be enabled only when all the selections and conditions are met.

6. Click on Upload file.

   

7. System will now upload the file and backend APIs will validate the file content. If there are any errors or issues with file or selected options (like file type or date format), the appropriate error will be shown to the user.

   

8. After the file is uploaded without errors, users needs to verify the type of transaction displayed from the uploaded file.

   

9. Users need to make their selection for the Verify button be enabled and proceed.

   

10. Review transactions will be displayed with with all the data from the uploaded file. All the transactions, bank account details, bank details, transaction date ranges will be displayed.
11. Transactions without minus(-) will be displayed as type Money in (Credit)

12. Transactions with minus(-) will be displayed as type Money out (Debit)

    

13. User can review 1 last time before importing transactions. When reviewed, user needs to select the Import transactions button.
14. System will now start and process the import.
15. File import is done successfully.
16. User will be routed back to the product page.

Scenario 3

Successful file upload (CSV file with only debit amounts)

1. Select file type (required).

2. Select the file that will be used for import (required).

   

3. Select the order of dates displayed in the file uploaded in previous step (required).

4. Add comments (required). The regex used to validate special characters that are not allowed is:

   /(?=.*^[\w])(?!.*[÷$%^&*()_+|~={}[\]:;<>@#\r\n])/

5. Upload file button will be enabled only when all the selections and conditions are met.

6. Click on Upload file.

   

7. System will now upload the file and backend APIs will validate the file content. If there are any errors or issues with file or selected options (like file type or date format), the appropriate error will be shown to the user.

   

8. After the file is uploaded without errors, users needs to verify the type of transaction displayed from the uploaded file.

   

9. Users need to make their selection for the Verify button be enabled and proceed.

   

10. Review transactions will be displayed with with all the data from the uploaded file. All the transactions, bank account details, bank details, transaction date ranges will be displayed.
11. Transactions without minus(-) will be displayed as type Money in (Credit)

12. Transactions with minus(-) will be displayed as type Money out (Debit)

    

13. User can review 1 last time before importing transactions. When reviewed, user needs to select the Import transactions button.
14. The system will now start and process the import.
15. File import is done successfully.
16. User will be routed back to the product page.

Scenario 4

Successful file upload (CSV file with debit amounts - flip signs → debit to credit)

File content:

1. Select file type (required).

2. Select the file that will be used for import (required).

   

3. Select the order of dates displayed in the file uploaded in previous step (required).

4. Add comments (required). The regex used to validate special characters that are not allowed is:

   /(?=.*^[\w])(?!.*[÷$%^&*()_+|~={}[\]:;<>@#\r\n])/

5. Upload file button will be enabled only when all the selections and conditions are met.

6. Click on Upload file.

   

7. System will now upload the file and backend APIs will validate the file content. If there are any errors or issues with file or selected options (like file type or date format), the appropriate error will be shown to the user.

   

8. After the file is uploaded without errors, users needs to verify the type of transaction displayed from the uploaded file.

   

9. In this scenario, the selected file contains only Debit transactions (Money out of the account), but will go ahead and verify/select Money into the account for the displayed transaction.

   

10. Review transactions will be displayed with with all the data from the uploaded file. All the transactions, bank account details, bank details, transaction date ranges will be displayed.
11. The transaction type will be flipped from what it is in the imported file. Debit transactions are now converted to Credit transactions.

12. Transactions without minus(-) will be displayed as type Money in (Credit).

    

13. User can review 1 last time before importing transactions. When reviewed, user needs to select the Import transactions button.
14. The system will now start and process the import.
15. File import is done successfully.
16. User will be routed back to the product page.

Scenario 5

Successful file upload (CSV file with credit amounts - flip signs → credit to debit)

File content:

1. Select file type (required).

2. Select the file that will be used for import (required).

   

3. Select the order of dates displayed in the file uploaded in previous step (required).

4. Add comments (required). The regex used to validate special characters that are not allowed is:

   /(?=.*^[\w])(?!.*[÷$%^&*()_+|~={}[\]:;<>@#\r\n])/

5. Upload file button will be enabled only when all the selections and conditions are met.

6. Click on Upload file.

   

7. System will now upload the file and backend APIs will validate the file content. If there are any errors or issues with file or selected options (like file type or date format), the appropriate error will be shown to the user.

   

8. After the file is uploaded without errors, users needs to verify the type of transaction displayed from the uploaded file.

   

9. In this scenario, the selected file contains only credit transactions (Money into the account), but will go ahead and verify/select Money out of the account for the displayed transaction

   

10. Review transactions will be displayed with with all the data from the uploaded file. All the transactions, bank account details, bank details, transaction date ranges will be displayed.
11. The transaction type will be flipped from what it is in the imported file. Credit transactions are now converted to Debit transactions. (Money in → Money out)

12. Transactions with minus(-) will be displayed as type Money out(Debit)

    

13. User can review 1 last time before importing transactions. When reviewed, user needs to select the Import transactions button.
14. The system will now start and process the import.
15. File import is done successfully.
16. User will be routed back to the product page.

Scenario 6

Cancel file import

1. Select file type (required).

2. Select the file that will be used for import (required).

   

3. Select the order of dates displayed in the file uploaded in previous step (required).

4. Add comments (required). The regex used to validate special characters that are not allowed is:

   /(?=.*^[\w])(?!.*[÷$%^&*()_+|~={}[\]:;<>@#\r\n])/

5. Upload file button will be enabled only when all the selections and conditions are met.

6. Click on Upload file.

   

7. System will now upload the file and backend APIs will validate the file content. If there are any errors or issues with file or selected options (like file type or date format), the appropriate error will be shown to the user.

   

8. After the file is uploaded without errors, users needs to verify the type of transaction displayed from the uploaded file.

   

9. If the user wants to cancel file import, they can select the Cancel import button. A cancellation dialogue will be displayed for the user to confirm.

   

10. Selecting Cancel import inside the dialogue will confirm the cancellation and the system will cancel the import process.
11. File import is cancelled successfully.
12. User will be routed back to the product page.