netsuite seems to say that it can do one bank transation to many GL transactions on the bank match through reconciliation rules. how come it doesn't work when i run it?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the issue you're facing is related to the way NetSuite handles bank reconciliation. NetSuite's Intelligent Transaction Matching for Bank Data is designed to match "many" transactions in a bank clearing account, which are then moved with a single transfer to create the "one" on the bank. This process results in one transaction that is sent to the bank, but two transactions in NetSuite with different transaction numbers/IDs. However, it's important to note that this process can lead to some complications. For instance, there can be process issues if people ignore alerts on the account not being cleared down, or if they treat it as a cash in transit account, or hide reconciling items in there. Also, when a new starter begins, the process can become more complex. As for your question about why you have to create a payment in NetSuite to match the bank statement against it, it's because the system is designed to "presume" you will receive money in a specific bank on a specific date. This is part of the reconciliation process and is not meant to be counterproductive, but rather to ensure accuracy and compliance with regulations. Remember, this process is not applicable to all transaction types. It's generally applicable only to certain transaction types like Deposit, Check, Credit Card Charge/Refund, Journal, Customer Payments, but not to Bill Payments. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******