[bearclaire1]

Hi,

Can someone please advise how I go about having a TB that I can see the monthly movements, along with account balance?

I am struggling to customise the Tb or even the general ledger report.

Many thanks

Claire
This is a cached copy. Click here to see the original post.

[felix.guinet]

RE: Trial Balance by Month

Hi bearclaire1,

NetSuite gives you a filter called “As of” in the footer of the Trial Balance Report.

When selecting a period in this filter, you then need to click the Refresh button (also in the footer).

Cheers

[bearclaire1]

Hi Felix,

This only shows the balance as of that date and not the period movements. In order for me to do this currently I have to run the TB twice (current month and previous month) and deduct.

I was hoping there was an automated way of showing this?

Thanks

Claire

[trimblee]

RE: Trial Balance by Month

I don’t think it’s supported. NetSuite can do P&Ls by period, but not balance sheets, or trial balances. Some of the system calculated accounts (e.g. retained earnings) cause problems. You can force the system to run a balance sheet by period, but some accounts will be way off; I don’t think there’s a way to force it to run the trial balance.

There is however a help article on building a financial report that shows account movements (but not balances). I haven’t tried it though.

Evan

[Kouji]

RE: Trial Balance by Month

Hello Claire,

You may try the following:

– Navigate to Reports > New Financial Report.

– Click any Standard Income Statement Layout (depends upon the availability due to NetSuite editions).

– Under the Edit Layout section, on the Add Row/Section… drop-down field, select Add Financial Section.

– In the New Section Row pop-up, Select Create New Section radio button and click OK.

– Delete other sections in this particular order (assuming a Standard Income Statement Layout(US).- Net Income.- Other Income and Expenses.- Ordinary Income and Expenses.- On the right hand side of your screen, set the following:- Header Label = Put any label you prefer.- Display = Expanded.- Group By = Account.- Show Hierarchy = Unchecked.- Section tab.- Filter = Account Type.- Description = (All Account Types except Bank).- On the Add Row/Section… drop-down field, select Add Financial Section.

– In the New Section Row pop-up, Select Create New Section radio button and click OK.

– Header Label = Put any label you prefer.

– Display = Expanded.

– Group By = Account.

– Show Hierarchy = Unchecked

– Section tab.- Filter = Account Type.- Description = (Bank Account Types).- Format Tab>Account Row Format segment.- Check the Reverse Sign box.- On the Add Row/Section… drop-down field, select Add Formula Row.

– Add up the two Financial Rows we have created.

– Go to Edit Columns.- Click on the Amount column.- Uncheck the Add Grand Total box.- Click Save.

[bearclaire1]

RE: Trial Balance by Month

That worked great to show only period movements. Thanks.

Claire

Originally posted by Kouji

View Post

Hello Claire,

You may try the following:

– Navigate to Reports > New Financial Report.

– Click any Standard Income Statement Layout (depends upon the availability due to NetSuite editions).

– Under the Edit Layout section, on the Add Row/Section… drop-down field, select Add Financial Section.

– In the New Section Row pop-up, Select Create New Section radio button and click OK.

– Delete other sections in this particular order (assuming a Standard Income Statement Layout(US).- Net Income.- Other Income and Expenses.- Ordinary Income and Expenses.- On the right hand side of your screen, set the following:- Header Label = Put any label you prefer.- Display = Expanded.- Group By = Account.- Show Hierarchy = Unchecked.- Section tab.- Filter = Account Type.- Description = (All Account Types except Bank).- On the Add Row/Section… drop-down field, select Add Financial Section.

– In the New Section Row pop-up, Select Create New Section radio button and click OK.

– Header Label = Put any label you prefer.

– Display = Expanded.

– Group By = Account.

– Show Hierarchy = Unchecked

– Section tab.- Filter = Account Type.- Description = (Bank Account Types).- Format Tab>Account Row Format segment.- Check the Reverse Sign box.- On the Add Row/Section… drop-down field, select Add Formula Row.

– Add up the two Financial Rows we have created.

– Go to Edit Columns.- Click on the Amount column.- Uncheck the Add Grand Total box.- Click Save.

[Author]

Posts