Guys, when I am matching bank data with an uploade...
# accountingi
Ibiaçu Caetano
04/29/2020, 5:26 PMGuys, when I am matching bank data with an uploaded bank statement file, can I only do it against bank transactions in Netsuite?
a
Andrea Rivetti
04/30/2020, 12:36 PMNo, it's related to all "eligible" GL lines regardless to the type of the transactions.
Andrea Rivetti
04/30/2020, 12:39 PMOf course have no sense to reconcile an invoice from a reconciliation perspective. What you are looking for is generating credits before reconciling it. So basically AR Payments creation. You should AWAYS use transfer (or clearing) account performing reconciliation. SO you should always have a payment in your system which "presume" you will receive money in a specific bank in a specific date. It seems that your side "reconciliation" is oversimplified regarding the regulation and impacts it should have...
e
eriks
05/13/2020, 6:53 AMIbiacu - are you thinking of a way to basically upload your bank statement file for a time period that auto-match against open invoices and vendor bills, where then NetSuite would auto-create the payment records where there is a match and set the invoies and bills as payed?
i
Ibiaçu Caetano
05/15/2020, 1:29 PMThat is exactly it Eriks
Ibiaçu Caetano
05/15/2020, 1:31 PMIf I already have a payment coming from the bank statement, I don't understand why I have to go and create a payment in Netsuite to then match the bank statement against it
Ibiaçu Caetano
05/15/2020, 1:31 PMSounds counterproductive
Ibiaçu Caetano
05/15/2020, 1:32 PMWhat I'd expect is simply apply the bank statement items against transactions in NS
3 Views