INPUT HAS BALANCES AND TRANSACTIONS

Input has balances and transactions, same number of columns, with Open and Close on the same rows

File Type: .csv
Data Input: - Generic. Duco will identify the structure and data types based on transactions and balances in their own columns
Map & Transform - Transactions: - Map the transaction fields as necessary
Filter Rules - Transactions: - Filter(s) needed on the Inputs used in Map & Transform to filter out all the Balance rows to avoid any errors in Cash submissions
Map & Transform - Balances: - Map both the Opening and Closing balance columns to the respective Opening and Closing Balance fixed schema in Map & Transform
- Map the Account, Currency, Opening Balance Date and Closing Balance Date fields as needed
- Duco will convert the supplied data into separate Opening and Closing balance records for consumption in a Cash process
Filter Rules - Balances: - Filter(s) needed on the Inputs used in Map & Transform Balances to filter out all the Transaction rows to avoid any errors in Cash submissions
Submissions Routing: - File containing the balances and transactions routed to the required data input. Balances and Transactions loaded appropriately based on the filter rules

Input has balances and transactions, same number of columns, with Open and Close on separate rows



File Type: .csv
Data Input: - Generic. Duco will identify the structure and data types based on transactions and balances in their own columns
Map & Transform - Transactions: - Map the transaction fields as necessary
Filter Rules - Transactions: - Filter(s) needed on the Inputs used in Map & Transform to filter out all the Balance rows to avoid any errors in Cash submissions
Map & Transform - Balances: - Using 'If something then something' NRL map opening balance row to the Opening Balance column and the closing balance row to Closing Balance column
- Map the Account, Currency, Opening Balance Date and Closing Balance Date fields as needed
- Duco will convert the supplied data into separate Opening and Closing balance records for consumption in a Cash process
Filter Rules - Balances: - Filter(s) needed on the Inputs used in Map & Transform Balances to filter out all the Transaction rows to avoid any errors in Cash submissions
Submissions Routing: - File containing the balances and transactions routed to the required data input. Balances and Transactions loaded appropriately based on the filter rules

Input has balances and transactions, different number of columns, with Open and Close on the same row

File Type: .csv
Data Input: - Generic. Duco may identify structure either based on just the transactions or mix of transactions and balances
- If Duco identifies file contents based on just the transactions and these columns are also used for balances with a different data type, then you will likely need to change the Input data type of all fields to 'text' to accommodate both data types

Map & Transform - Transactions: - Map the transaction fields as necessary
- You may want to use NRL to set Date and Amounts to specific format if the data input type for these fields is set to text
Filter Rules - Transactions: - Filter(s) needed on the Inputs used in Map & Transform to filter out all the Balance rows to avoid any errors in Cash submissions
Map & Transform - Balances: - Map both the Opening and Closing balance columns to the respective Opening and Closing Balance fixed schema in Map & Transform
- Map the Account, Currency, Opening Balance Date and Closing Balance Date fields as needed
- Duco will convert the supplied data into separate Opening and Closing balance records for consumption in a Cash process
Filter Rules - Balances: - Filter(s) needed on the Inputs used in Map & Transform Balances to filter out all the Transaction rows to avoid any errors in Cash submissions
Submissions Routing: - File containing the balances and transactions routed to the required data input. Balances and Transactions loaded appropriately based on the filter rules

Input has balances and transactions, different number of columns, with Open and Close on separate rows

File Type: .csv
Data Input: - Generic. Duco may identify structure either based on just the transactions or mix of transactions and balances
- If Duco identifies file contents based on just the transactions and these columns are also used for balances with a different data type, then you will likely need to change the Input data type of all fields to 'text' to accommodate both data types

Map & Transform - Transactions: - Map the transaction fields as necessary
- You may want to use NRL to set Date and Amounts to specific format if the data input type for these fields is set to text
Filter Rules - Transactions: - Filter(s) needed on the Inputs used in Map & Transform to filter out all the Balance rows to avoid any errors in Cash submissions
Map & Transform - Balances:  - Using 'If something then something' NRL map opening balance row to the Opening Balance column and the closing balance row to Closing Balance column
- Map the Account, Currency, Opening Balance Date and Closing Balance Date fields as needed
- Duco will convert the supplied data into separate Opening and Closing balance records for consumption in a Cash process
Filter Rules - Balances: - Filter(s) needed on the Inputs used in Map & Transform Balances to filter out all the Transaction rows to avoid any errors in Cash submissions
Submissions Routing: - File containing the balances and transactions routed to the required data input. Balances and Transactions loaded appropriately based on the filter rules