-
Bank Statements were reconciled but there are additional transactions with differences
Bank Statements were reconciled but it brought transactions after there were changes made on some transactions that were reconsiled before. The client wants to clear those Journals/Transactions for corrections without Reconciling them or seeing them again which caused a difference.
-
Bank Recs - mass update cleared flag and cleared date on transactions
We did a csv update to journals to add a comment on the header of the journals - it was a non posting impact However this resulted in the cleared flags beign CLEARED and the date cleared being removed. Need to urgently get this info restored - i have the info that it needs to be! Any thoughts or suggestions!
-
NetSuite Admin Tip | Increase Number of Transactions Showing in Match Bank Data Page
Reconciling multiple transactions can quickly become tedious when you have to click through page after page. To make this process more efficient, NetSuite administrators can increase the number of transactions displayed on the Match Bank Data page. To do this, we can follow the steps below: 1. Navigate to Setup > Company >…
-
Nordea Bank Statement downloads for auto bank reconciliation
We use the auto bank rec functionality whereby transactions from out banks auto feed in via the Saltedge solution in Netsuite. This works great for our HSBC accounts. We have some Nordea bank accounts we wish to use in this way. When we authenticate via the Nordea app to set up we just time out. Nordea are saying its an…
-
Bank Reconciliation Format CSV
Hi all 1. My laptop has a semicolon setup, but in bank reconciliation when uploading it always fails, so I have to use my friend's laptop which has a comma format 2. My netsuite uses DD/MM/YYYY format but when uploading it has to use MM/DD/YYYY 3. What I want to ask is, can points 1 and 2 be changed according to each…
-
Bank Reconciliation Reports are showing wrong sign for the reconciled amounts > causing Difference.
I’ve noticed there’s an issue with the Reconciliation Summary screen in NetSuite which is affecting some of the bank accounts. If we look at GL 200003 for example, when I have gone back and re-reconciled the account for December 2022, there were 2 receipts and then one suppler payment with a net income of £28,245.58. This…
-
Deposit in Transit at time of implementation
We are in the process of implementing and going live on NetSuite. At our cutover date, we had several deposits in transit. These were credit card transactions that we recorded in our old GL in June, but did not show up on our bank statement until July. So when we load our July bank transactions, there is nothing in…
-
Bank/Account Reconciliations - SQL query
We are an organization that has 100s of bank accounts. We are frustrated that we cant simply select a range of bank accounts and say print the bank rec. We have to do these one at a time. I am trying to find out if we can do anything via SQL but cant work out what table this information is stored in. I know there is…
-
How to Auto-match bank reconciliation multiple lines transactions in the imported bank data?
Hi All Is it possible to auto-match bank reconciliation if there is multiple imported lines transactions in the imported bank data but only single transaction in the Account transactions? Is there a way to auto select All records under imported bank data? Kedalene Chong
-
Is it possible to remove "To be Generated" in Bank Reconciliation?
Hi All To Be Generated" feature is always being matched with incorrect transactions or even unknown transactions, is it possible to turn off this To be Generated function in Bank Reconciliation? Kedalene Chong