Tag: income statement

Editing P&L format

Requirement: Need a help in customizing P&L report which shows the classes and subclasses across the top. How do i go ahead and customize the report or is it even doable. I have never done this before and any help would be appreciated Solution: on your report footer, you can try selecting Class (Hierarchy) on… Continue reading Editing P&L format

Creating a Class-wise Profit and Loss Report in QuickBooks

To generate a class-wise Profit and Loss report in QuickBooks, follow these steps: Access Reports: Navigate to the “Reports” section in QuickBooks. Customize the Report: Click the “Customise” button located at the top right corner of the screen. Set Up Columns: In the “Rows/Columns” section, find the “Columns” field. Select “Classes” from the drop-down menu.… Continue reading Creating a Class-wise Profit and Loss Report in QuickBooks

Rearrange class columns depending on recent activity

Is it possible to rearrange the classes columns in an income statement depending on activity or recent date with activity? On the image above, I chose the Class as a column. What we need is to have the classes in order depending on which has recent activity. Right now, it is showing in alphabetical order.… Continue reading Rearrange class columns depending on recent activity

Generating a Workbook for Standard Income Statement Report in NetSuite

Go to the Analytics menu. Create a new Dataset for Transaction by clicking on New Dataset button. 3. Select Transaction dataset and add the following criteria and columns: Criteria: Account Type: Income, Cost of Goods Sold, Expense, Other Income, Other Expense Posting is True Columns: Account Type(Transaction Line: Account: Type) Location(Transaction Line: Location) Class(Transaction Line:… Continue reading Generating a Workbook for Standard Income Statement Report in NetSuite

PART 4 – The Core 3 Financial Statements Compared

  Balance Sheet Income Statement Statement of Cash Flow Purpose Net Worth Profitability Liquidity & Solvency Reporting Period As of Point in Time For the Period Ended For the Period Ended Elements – Assets– Liabilities– Equity – Revenue– Gains– Expenses– Losses– Net Income – Beginning Cash Balance– Sources of Cash– Uses of Cash– Ending Cash… Continue reading PART 4 – The Core 3 Financial Statements Compared

Replicate Income statement in Saved Search

Scenario Replicate Income statement in Saved search Solution Go to Lists > Search > Saved Searches > New Select Transaction Click Criteria tab Filter: Add the following: Posting Mark Yes Click Set Account Type Select Cost of Goods Sold, Income, Expense, Other Expense, Other Income Click Set Filter: Add Accounting Periods Fields…  Select Start Date Start Date: Select Within From: Set the Start Date of the Accounting Period To: Set the Last Date of the Accounting Period… Continue reading Replicate Income statement in Saved Search

Not Showing some Journal Entry lines on applying Customer filter in Income Statement

When applying a customer filter to the income statement, some journal lines are not showing in the income statement. Also, some accounts are showing 0 expenses even if there are entries for that account in the journal entry. This is because, in the journal entry lines, we can enter not only customers but vendors as… Continue reading Not Showing some Journal Entry lines on applying Customer filter in Income Statement