Based on your issue noted below, and possibly other year end financial statement issues, you may want to consider a free web discovery meeting with us. We could then review your specific issue noted below, plus other year end processes and reporting issues that may also require some fine-tuning, prior to finalizing an…

There may be a past reconciliation that was put on hold (and not saved) and does not show in reconciliation history, and this can unbalance the books. Also, when looking at the register, if it says "Reconcile" in the reconcile date field, for older transactions, those can cause issues too. Please contact me offline for a…

Hi Kathie, When you add a new Account under Lists>Accounts, the Type field determines where the Account will reside on either the standard Balance Sheet or Income Statement (Profit and Loss), so no customizing is required for new Accounts. In many cases, customizing financial statement layouts is not needed, as the…

Any updates on this issue?

Another option is to: a) Accept Customer Payment for the full amount of the invoice, and toggle to Undeposited Funds b) Make Deposit and check off Payment, then on the Cash Back tab one or more discount lines can be added and coded to the applicable account. The above saves the steps of creating other transactions, and may…

If you go to Home>Settings>Set Preferences>Reporting/Search and change Report by Period to Never (if you have Accounting Periods turned on), do you still have a difference? If that does not work, you could contact me for a free web meeting where I could view this issue in your NS account and look for a resolution.

You may want to look at Account Groupings to see if this can solve your issue. For example, if you have a Rent account, it could be edited to be a SubAccount of Property Expenses, and you can use several layers of subaccounts to come up with a summarized or detailed Management Account (including Balance Sheet, Income…

We have clients that have work in progress and use completed or other contract accounting processes. If you'd like to discuss further, please contact me directly.

You may be able to reconcile the transactions you already have in that bank account, and then enter new transactions into the proper Credit Card account, and it may work, and not cost you as much time as moving each and every transaction over. Contact me directly if you'd like to discuss and clarify this further.

Instead of using Journal Entries, I'd suggest using the built in Bill Credit process in NS, so that in the Ref No field you can refer to what the credit is for, and therefore a JE is not required.

Another option to get the AR and AP reports to match to the GL or to the amount shown in the KPIs, is to: a) go to Set Preferences b) go to Reporting / Searching tab c) set Report by Period to Never This will also allow for running reports on a weekly or daily basis, which is difficult to do on an accounting period…

I may be able to sort those out for you, and I'll plan to contact you or feel free to contact me per details below - I'm on Eastern time but can also be available outside normal 9am-5pm work day.

Some companies that have partially implemented NetSuite have another option noted below, which may or may not be appropriate. There is more to it than this, however to keep this short, a company could pick a date, such as March 1, 2009, and begin to enter transactions and have a "clean" system from March 1st onwards. Then,…

If my suggestion below does not fix your issue below, please contact me directly for further help on this.

This may help: Try this: a) go to Home>Set Preferences>Reporting/Search b) if you have Accounting Periods turned on, a Report by Period field should show on this screen. c) this may be set to Financials Only or All Reports. Change this user preference to Never If this does not help, please provide more details. By the way,…

The post below is related to your question, and can be found at: https://usergroup.netsuite.com/users/showthread.php?t=17&highlight=bboese+vendor You could do the following: a) Enter Bill and Pay Bill (or Write Check) to supplier for the advance amount (i.e $50,000), and code to Cost of Goods Sold or another COGS or…

Not sure what size company you are working with, but in many situations, we advise companies on NetSuite to "dump" Quickbooks as soon as possible, as most, if not all, of the functionality of QB can be found in NS. Then, there is no need for exporting / importing / synchronizing / reconciling between 2 systems, etc which…

Has anyone found a way to set default account for Cash Refunds (and other processes), or are we waiting for Enhancement 29757 to go through? If so, please vote at link below: https://system.netsuite.com/app/site/hosting/scriptlet.nl?script=customscript_enh_vote_suitelet&deploy=customdeploy_enh_vote_suitelet&l=T&issue=414771

Hi Lorna, [LEFT]There is a little known secret of how to get the Budget information to show. [/LEFT] [LEFT]a) go to Home>Settings>Set Preferences[/LEFT] [LEFT]b) go to the Reporting / Search tab and revise Report by Period to Financials Only (it may be set to Never when you look)[/LEFT] [LEFT]c) save the change…

If you still need some assistance to resolve this, please contact me directly.

Nick - I'll be in touch with you regarding this.

Try this, as appended below, and further discussion at: https://usergroup.netsuite.com/users/showthread.php?t=10333&highlight=preference+balanc e Quote: Originally Posted by bboese Try this: a) go to Home>Set Preferences>Reporting/Search b) if you have Accounting Periods turned on, a Report by Period field should show on…

You may want to try this: a) after you've set up drop ship item in normal way b) go to the Accounts list, pick out the account(s) that are Expenses, where you want to change them to COGS c) click edit at one of the accounts, and change Type from Expense to COGS and change to COGS in Income Statement pulldown list and save…

Makes me wonder if all my "workarounds" or issues are necessary or true when I hear that some people have the right answers and others do not. If you are interested, I'd like to review your workarounds and issues and provide my thoughts and comments. Please contact me directly for more details.

Post #3 at the link below may help to resolve this for you: https://usergroup.netsuite.com/users/showthread.php?t=1878

The advice in the following link may help: https://usergroup.netsuite.com/users/showthread.php?t=9536&highlight=nsf

If you are interested, contact us for a free web meeting where we can help you with this issue.

See if this may work / help you with this reporting issue: Try this: a) go to Home>Set Preferences>Reporting/Search b) if you have Accounting Periods turned on, a Report by Period field should show on this screen. c) this may be set to Financials Only or All Reports. Change this user preference to Never If this does not…

Thanks for your great comments and advice, Brad, Ray and Long.

Courtney, If you send an email directly to me, with dates / times that work best for you to have a free web discovery meeting, I'll review this with you and seek a resolution. If you have other accounting related issues, we can also review those during the meeting too.