Detailed Income Statement Report in TOPS [ONE]

 Description 

A Detailed Income Statement is a listing of the income less expenses to yield the net income
of the community for an accounting period. The report shows the current month and YTD total, compared to the budget. Only GL accounts that both have a balances and are in the Income or Expense account range, will display on this report.

You can view this report on screen, or you can export it to print it. This guide will also give you instructions on how to schedule the report to be emailed to a recipient automatically. 

Detailed Income Statement VS Detailed Income Statement by Range 

The Income Statement groups accounts by account type: Income and Expense. For example, all accounts designated as income will be grouped and totaled.

The Income Statement by Range also groups accounts by type, but goes further by displaying the different account ranges for each account type. For example, if there are two account ranges that designated as income, they will both show on separately under assets on the report.

How to Generate/Export

1) Click Reports and select Standard. Select your report 

2) Edit the Start Date, Sort, Cost Center settings.

Start Date - Start of the date range for which balances are displayed

End Date - End date for the date range for which balances are displayed. 

Sort - Arrange the report by your preference

C

ost Center - Select a specific cost center for this range (overrides the cost center selection in the options panel)

Consolidate Cost Centers- Consolidate cost centers rolls the amounts up to the account level

3) Edit your Export Parameters

Export Orientation   Portrait/Landscape   

Export Font Size        Large/Small 

Show Run Date/Time   This feature is on by default. Disabling will remove the timestamp on the top right of the exported report 

Show account Number  This feature is on by default. Disabling will remove the account numbers, and only leaving the account name. 

Header Row Border  This feature is on by default. 

1st Column Border 

Banded Rows (Shading) 

Gridlines 

Export Format 

If you made any changes, click  to see the changes in the balance sheet on screen or before exporting.

Once you're finished, click 

This will download the exported report to your default download folder.

How to schedule Reports  

1) Click  Schedule. This will display the scheduling options.

2) Schedule -Will let you email reports at a scheduled time, or as a one-time email. 

Job Name - Name that can easily identify the job 

Frequency- How often you want the reports to automatically be sent. (Once, monthly, quarterly, etc.)

Permitted Days-pick which day you want the reports to run, if you don't want the report to run on a specific day, deselect those days.

Start Date- Select the day you want to start the scheduled reports

End Date- Select the date you want the scheduled reports to end. 

End Time- Select the time you want the reports to stop running. 

Recipient- Type in the email where you want the reports sent

3) Click Schedule at the bottom of the screen

You can go to Automation to see this scheduled job.