3942102 Green Ribbon

Yes, you are correct that it is populated, 99% of ours are blank because emails usually are assigned to a contact as we deal with people within a company. Okay - doesnt help you though. But as a start maybe at least populate it with the main billing contact.

Not sure if its related. But in setup/accounting lists - on the payment methods - I had to reset all the methods to point to the right account... this seemed to have been wiped after the release 2008.1 upgrade.

You maybe missing something. If its the ACH credit method you should be able to do for sales tax what we do for payroll. http://www.skyytek.com/Info/October-07 - it was posted on our newsletter as a quick tip. I would have thought the sales tax agencies would have a similar method.

Cat is correct. There is a procedure - as in write check against the credit card liability account. In my opinion not refined enough - but works for us - must admit.

was this a QB conversion ?. one of the many gotcha's with it. We stopped authorizing QB conversions at skyytek about 3 years ago. Its actually our #2 reason for re-implementations - normally about 6mths - 12mths later.

or check that the beginning balance of the account is not zero either.

When you open the Bank Rec's, it brings you to the last account you reconciled and either held or saved. There is no actual default view that I am aware of. yes. a bit of a pain. should default to the bank account in your profile unless you specify another bank account.

Should be okay. However, there are instances when it isnt. For example when the merchant discount fees are taken at transaction source - that can be a reconciliation nightmare since the monies hitting your bank will not equal the amount in the system. In this case adjustments have to be made. A better way of doing it is to…

FYI.. It used to be that by editing a transaction in a prior reconciled period would throw your current period out. They changed that in r11 and confine reconciled balances to specific periods now. I dont like it - but thats what happened. There is a thread about this somewhere on this forum.

Have your merchant take the fees separate to the transaction. Otherwise it would be impossible to reconcile. They wont like that request - but will probably do it if you strong arm them enough.

We received a duplicate customer payment and posted it using: Transactions> Customers> Record Customer Deposits. Now 3 months later the customer has found their error and is asking for a return of the funds. How do we issue the return check and apply Customer Deposit against it? If we don't apply the Customer Deposit to…

I am running into problems with bank recs. What was once a rock solid check and balance process in prior iterations of the software has been compromised. I have completed a June reconciliation for an account that has little activity in it. In v10 once you hit Save (hard save) not the Hold (soft save) button, it would clear…

Ray- I am pretty sure it did. Most other accounting software follows this convention. Otherwise the point of the reconciliation is diminished. It forces you to take action since action is required. There is never an excuse to allow an unreconciled difference. It's like allowing an unbalanced accounting entry. Never ever…

I just want to make sure that we don't end up with one thread where a bunch of similar, but different issues get lumped together so people get confused. Probably the main question is whether you have 1)cleared transactions that were previously just lumped into the reconciled balance, but not associated with a statement, or…

The only way we're going to get to the bottom of this is to investigate your situations individually, so please file a case and we will do just that. I am working closely with support and QA to separate instances where reconcilation/clearing data requires user 'cleanup' from actual issues that need a development…

Looks like Ray has encounted an issue, because the transactions are not cleared. QA is investigating. If anyone else runs into this with the v11 update - old reconciled transactions appear again in the reconcilation page, but they are NOT cleared, please reference issue # 107709 and it will help us diagnose it more…

My reconciliation report was 25 pages long and included items from as far back as 2005. I now unreconciled items as far back as 2003. I NEVER cleared items from the register. I ALWAYS used the reconciliation screens. I KNOW I've balanced every item before. I'm not "confused" between cleared and reconciled items. And it…

Unfortunately, since no invoice was involved.... we have an unapplied customer deposit. Which will stay arround forever even if we send a check to the customer. Kent If you took the money then thats how it should remain ?. no ?. Ledger-wise I think this is what happened - and correct me if I am wrong. Payment from Customer…

Ray- Point taken. However I would hold the rec until the timing difference is resolved. Personal preference on my part. Calendars don't always rule my life. Otherwise I would take the forced adjustment and reverse when the solution is clear. Let's not fight among ourselves. NetSuite should be the attention of our focus.…

Tom - I am not sure on point 1 it acutally asked you to journal - I think it was a warning. But regardless - I have been through hell and back with this stuff. I dont get it either - especially when something somewhere messed with my transactions and un-reconciled them !!. We have always been spot on. I would be curious as…

If you haven't already, please file cases with the steps to reproduce, so we can get this in the queue to fix. Best regards, Malin Huffman Senior Product Manager NetSuite, Inc. I did mention to someone at netsuite (when we first went on r11) - maybe you malin - that this is very confusing. Suddenly everything that was…

Your suggestion of overapplying the deposit.... the Deposit Application of a "Customer Deposit" does not allow over payment - higher than the invoice amount. We are still stuck. You have to increase (of course) the orignal invoice with a item pointing to a suspense account. Sorry - didnt really explain myself properly. But…

Malin- With all due respect, you have significantly weakened a key accounting control that previously existed with the bank reconciliation process that existed prior to v11. Here are a number of reasons why: 1) If you hit "save" with an unreconciled difference it forced a general ledger entry. That was a key control that…

If you enter a Start Date in the Reconcile Bank (or Credit Card) Statement webform, the older Unreconciled, Cleared transactions will go away in the webform view, and just the ones from the date you enter and forward remain, which will make you think that the change can be circumvented. However, when you print the…

Go to your reconciliation page. The old transactions appearing - does the Cleared column say 'Yes' ? If so, you need to do a little correction to get rid of them - the easiest thing is to create a dummy reconciliation. The enhancements in v11 should not have changed the actual cleared/reconciled status of any transactions…

Hi Malin, the problem is not only with old, *un*reconciled transactions. We know for sure that all transactions in our bank and CC accounts *were* reconciled, beginning from the date in 2002 when we subscribed to NetSuite. But now, 4 years later, some of the 2002 transactions are appearing again. Like Ray, I was able to…

Ray, Any word on this? The help menu says that if you click off all of the cleared but unreconciled items that they should net to zero and you can continue on. Mine don't net to zero... Scott Okay. Here's the scoop. We had many of our transactions that seemed to have become "unreconciled" with no explanation. It had to be…

This worked for us, hopefully it will for you too. Transactions - Bank - Reconcile Bank Statement (everything shows up from the beginning of time) NOW click on "Date" at the top of the listing to reorganize everything. TUH-DUH! Suddenly everything is now reconciled like it should be. Hope this works for everyone else. Yer.…

I managed to get this to work on our credit card reconciliation. probably more luck than judgement. But not on our bank accounts - any of them. Something is sadly wrong here. Please fix.

How do we reconcile the deposits from credit card processors against individual transactions? Netsuite deposits each one individually into the bank account as cash, but in reality, they are really deposited as a batch? We need to batch transactions to match the deposit that was actually deposited into the bank. What is the…