[dale1946]

I followed the instructions (both options) in Answer ID: 23921 which was last modified this month; however, I must be missing something. When I run the report, it does start with the requested period; however, the amount is a net of the transactions for the period; not a balance sheet as an accountant defines a balance sheet. What am I missing or is it working as intended? I am new with NetSuite, help would be appreciated.
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC]

Hmm, I’m not an accountant so don’t know what you mean by “a balance sheet as an accountant defines a balance sheet”. Can you elaborate on that? Also, Answer 23921 seems to refer to Yammer so I’m guessing there’s a typo in there.

Otherwise, what I can say is that a balance sheet in NS is a running total of everything from your start of fiscal year to wherever you wish. Income Statements can have specific start-end ranges, ignoring anything prior to the start and beyond the end, but a balance sheet posts the ongoing value of accounts.

If you wish to see the incurred GL Impacts of balance-sheet type accounts within a specific time range, looking at the specific ledgers, or running saved searches, is probably a better bet. You could also look at the Balance Sheet Detail report and kind of ignore the opening balances, though the ending balance will include it.

[dale1946]

Yes – I can’t type either – it is 23931. Balance Sheet to an accountant is the summary (total) of all activity from day 1 to end of accounting period selected. The problem with the report is it does not include transactions prior to the months you are wanting to print. I think you answered my question when you stated “a balance sheet in NS is a running total of everything from your start of fiscal year to wherever you wish”. The report I am running is exactly what you stated. Needless to say as an accountant, I can’t agree with their logic but it is what it is. Thanks for your reply.

[Kouji]

Hello Dale,

Based on what I understand from your concern, you would like to see your Balance Sheet on a per Period basis. Kindly do this:Run your Balance Sheet by going to Financial>Reports>Balance Sheet
Set the END OF footer filter to “This Period”
Set the COLUMN footer filter to “Accounting Period” (you can also choose Accounting Quarter or Accounting Year)
Click Refresh
The Balance Sheet will now show you your financial position as of every Period. If you want the balances as of specific periods only, export the report to Excel® and delete the unwanted columns.

The SuiteAnswers article 23931 will allow you to run a Balance Sheet like an Income Statement – showing you balances on inclusive dates rather than “as of” dates.

I hope this helps.

Thank you.

[dale1946]

The above does not provide the same balances as when I run each month separately. This could be due to out of period dates. Still trying to cleanup old data and will try solution above when more data is cleaned up.

[carl.billings]

I create comparative balance sheets using the customization to view the columns and select the periods to view relative to the report date. For instance the default would be current month with each column to the left being a distinct period before the current. for dynamic viewing you can have last period and period before last. anything beyond that and its hard coded selctions

[mlumangaya]

Hi Dale,

Without making use of the Filters Tab, you can also achieve your desired result by manipulating the Amount column of the Balance Sheet Report.

Please try the following steps:

– Navigate to Reports>Financial>Balance Sheet>Customize Summary

– Under the Edit Columns tab, click on the ‘Amount’ column.

– Set the following column details:

a. Alternate Period Range Type = Relative to Today’s Date

b. Cumulative Value = F

c. Alternate Period Range = Custom

d. Periods = Highlight the beginning Period till the As of Period that you desire.

Note: Remember to consider the fact that if you highlight a Fiscal Year option, it will include all months within the Fiscal Year regardless of the Period selection you assign.

[Author]

Posts