Most have a hard time finding this at the Account level, and it can lead to inaccurate reporting, even if users find this. Would it make sense to have a section on the Form 1099-Misc, at link below https://system.netsuite.com/app/accounting/reports/NLPrint1099s.nl?mode=frame which showed all the Accounts, and the person…

If you currently have a CPA that has little to no knowledge of NetSuite, and wish to keep that relationship, here is another option. We provide accounting and bookkeeping services throughout the USA and Canada, focusing on companies that run NetSuite. Many CPAs may not wish to learn NS for just one client, so we've…

If you go to Setup>Customization - Transaction forms a) pick the invoice where you'd like to add the balance due field b) edit it by going to Printing Fields, Footer and checking Amount Paid and Amount Due boxes. You may need to modify the transaction layout, depending on your form, etc.

To make the search even more "management by exception", you could edit the same search to send an Alert (email). Go to the Alert tab in the search and check the Update box. This will send an email / alert to you or anyone else each time a transaction is entered that meet your criteria. In other words, if the alert is set…

Looks like you are wishing to see what each Fund Center (or Profit Center) is doing, so I'd suggest instead of complicating the Chart of Accounts, you may consider splitting each of the funds (or Fundraising Event) into a Department or Class segmentation. With this structure, you'll be able to run a normal "Income…

Posted earlier: " Our Controller loves to close accounting periods within a day or two after the end of the month. " Per the phrase above, here we go again, letting the accountant's run the company. I'm an accountant (CFO / Controller / VP Finance - whatever title you like), and fully believe the Controller / Accountant…

Do you need some help with these questions / account setup? If so, please let us know.

Nicole, I am an accountant, working with companies on NS in multiple states. I'll also contact you offline.

Mark, An idea for entering Expense Bills is to go to Home>Settings>Set Preferences and under the Transactions tab, check off Auto Fill Transactions. Then, when you go to Enter Bills and enter Vendor name, it loads last bill automatically. This can save you time in going to history and copying bill.

It may work well to just add new Memorized Transactions for the ones that don't work, then delete the old ones that don't work, and monitor all the memorized transactions for a while, to see if they are posting correctly, on the correct dates, etc. This may save you some time and frustration in researching what went wrong.

Depending on a) your setup configuration, b) access rights and c) "blessing" of the accounting dept to not always use consecutive invoice numbering you could edit the invoice and insert the invoice number of your choice (to match the one on the proforma invoice - customized sales order), if the number has not been used…

Since there are some variables, it may be easier to discuss and resolve via a web meeting. Please feel free to contact me. All the best, Barry Boese, Certified Management Accountant [EMAIL="bboese@baacoffice.com"]bboese@baacoffice.com[/EMAIL] www.baacoffice.com 1-877-285-6535 x 3

Our company provides value added bookkeeping (and accounting) services to companies (most are in the USA, and in many different states, so location is not an issue) on NetSuite, and we have worked with NetSuite systems since June 2000. We offer a free web discovery meeting to review your bookkeeping and accounting needs,…

Our company provides value added bookkeeping (and accounting) services to companies (most are in the USA, and in many different states including Florida, so location is not necessarily an issue) on NetSuite, and we have worked with NetSuite systems since June 2000. We offer a free web discovery meeting to review your…

B. in the post below is a good workaround when we are working with customers that need "multi-company" functionality. I heard that NetSuite is developing multi-company functionality, and it may be available in version 11.5. Could NetSuite confirm when (which quarter) multi company functionality will be available? Thanks,…

Understandably, the USA version of NS will likely always have more functionality / features than the UK (and Canadian and others) version. I previously had difficulty understanding this too (like you and others), however we all work in businesses / organizations, and the primary focus is typically on the highest revenue…

We have had similar issues with some of our customers too. You could also check to see if your A/R Aging Summary and A/P Aging Summary reports match the Accounts Receivable and Accounts Payable amounts on the balance sheet. There are a few other ways to resolve this, including dating the balance sheet and income statements…

We have worked with other companies that have partially migrated to NetSuite, and then after the fact, wished to have accurate financial statements in NS. This can be a complex exercise, and we offer a free discovery web meeting to review your NS system, and to offer advice on what to do, and how to proceed with bringing…

Some options to resolve could include: a) ask your vendors / sub contractors to submit bills sooner, and then they can be backdated into the proper month - i.e. bill received Dec 5, for Nov services, would be posted in NS on 11/30/2006 b) post estimated Bill in NS, with 11/30/2006 date, and then when official bill is…

In addition to completing those reconciliations, you should review how any historical transactions that you need to enter will affect your financial statements / tax returns. Barry Boese, Certified Management Accountant [EMAIL="bboese@baacoffice.com"]bboese@baacoffice.com[/EMAIL] www.baacoffice.com 1-877-285-6535 x 3

Our company provides value added accounting and bookkeeping services to companies (most are in the USA, and in many different states, so location is not an issue) on NetSuite, and we have worked with NetSuite systems since June 2000. We offer a free web discovery meeting to review your accounting and bookkeeping needs, and…

Another option is to go to Setup > Accounting: Setup Accounting and to the Accounts tab and check "Expand Account Lists" and click Save. Then, when under Enter Bills or other screens, the Account list will show all accounts, so you can pick any account, or for the example below, you can add a new account under Fixed…

"Journal Approval" shows up under Transactions tab when customizing under Manage Roles. If you apply this to a custom Accountant Reviewer role, that may work. It also depends on whether the user has a supervisor or not, and other setup areas that may not easily be covered here. Hope this works, if not, you may wish to…

To overcome check # issue, you can go to Transactions>Other:Make Journal Entries, and enter transaction there (i.e. Debit Expense Account, under Name insert Vendor, Credit Bank Account), and then memorize it. Barry Boese [EMAIL="bboese@baacoffice.com"]bboese@baacoffice.com[/EMAIL]

Another option is to start with a General Ledger report, then Customize it to filter on Transaction Type Long Name:Expense Report, you'll be able to set the date range when viewing the report, plus you could sort the report by the Name column to show totals by Employee. Please note that the total of this customized report…

Hi Brett, Deleting would affect the previous year end financial reports, so it's not the best option. If that supplier bill payment: 1) does not need to be processed again, I would recommend entering a Journal Entry (JE) to debit the bank account and credit the original Account where the Bill was posted. In the Name field,…

Hi Brad, We have staff with significant NetSuite experience, and we could discuss options with you during a free web discovery meeting. Please contact me directly if you are interested.

We find the solution noted below works well - to create a Sales Order form that shows Invoice instead of Sales Order, since this does not create an accounting transaction. Then, when funds are received a customer deposit is created, and when an Invoice is created from the Sales Order, the deposit is applied to the invoice.…

See Customer Profitability report which can then be customized with % profit column, etc. Much care and attention to details is needed for this report to be as accurate as possible, including solid accounting processes which track all the costs associated with each customer. The Revenue column is normally quite straight…

Hi Natalie, You can customize the report and add another Transaction Total (Revenue) column, and then, for example, set the Alternate Date Range type to relative to today's date and then Alternate Date Range to last year. You can then customize the first built in Transaction Total (Revenue) column to similar parameters,…