With the new year beginning and accounting teams working busily to close the prior year financials one of the biggest errors we see is offsetting journal entries stuck on your A/P Aging report. If you are posting offsetting journals that post to your Accounts Payable transaction without first adding an “A/P Clearing Vendor” you might be asking how to clean up your reporting. Below we will walk you step by step on how to clear up your A/P Aging and remove these transactions entirely.
Tags: NetSuite, ERP, Reporting, NetSuite How To's, Accounting, Financial, General Ledger, GL, Accounting Periods, Transactions, Journal Entry, Transaction Lines, Financial Report, Accounts Payable, AP Aging
In NetSuite manually creating statistical journal entries is like manually creating general financial journals with the exception that you do not provide financial specific data. Instead, you areutilizing the unit of measures we previously set up to allocate fees such as monthly rent per department or shipping cost by items sold. When manually creating statistical journals, you are also given the opportunity to make an absolute balance for multiple statistical accounts at the same time.
NetSuite offers Statistical Accounts as part of their Advanced Financial module and these accounts enable you to track non-monetary data that you can use in reports and income statements. Users who utilize this function are often being asked to provide cost and revenue allocation, financial reporting using ratios and managing period close activities. Users can manually make statistical journal entries or autogenerate them through a saved search run by a statistical schedule. Users can also run record an absolute value when they manually create statistical journals, enabling them to capture periodic reporting such as office space by department or headcount by department.
What better way to automate paperwork than to send and receive documents electronically. NetSuite already has the ability to electronically send PDF versions of Sales Order or Purchase Orders or Custom Forms. DocuSign brings another level of automation. Now, with DocuSign, you can efficiently send, track, sign, and save documents for approval, eliminating the back and forth emails or scanning in manual signatures. You can see a quick demo of the SuiteApp in one of our Short N Suite Videos - https://www.youtube.com/watch?v=rPff5VLTgY0.
A large part of warehouse management is cycle counting inventory and consolidating inventory to a single area or bin. If you are using Advanced Bin / Numbered Inventory Management feature in NetSuite one function, you’ll have access to is Bin Transfers. This process allows you to move inventory from one bin to another without creating financial impacts.
Have you ever noticed that your Balanced Sheet and Income Statement have different month end balances?
Have you noticed small increments of one or two pennies in your A/R Aging report? Do you have some bad debt that you need to write off your books due to unresponsive clients? The following process will walk you through how to enter a Journal and process the customer payment to remove these from your Accounts Receivable reporting.
Have you ever found yourself scrolling page after page after page to find the one transaction record you know is in Related Record or under the customer sales tab? You might benefit from adding filters to your view to easily reduce the transactions that populate and really dig into the data you’re searching for.
Are you in need of identifying consumer buying patterns and want to quickly view which product is over or under performing? Merchandise Hierarchy helps achieve this plus provides a quick view of your products while allowing for category changes during different time periods. This can be a great tool if you are continuously launching new limited release collections or have multiple seasonal offerings.