Top
Top
  1. Workamajig
  2. Roles
  3. Everyone
  4. In-Depth Workamajig Guides for Everyone
  5. Standard Reports
  6. Financial Reports

Menu

    Articles in this section

    See more

    Corporate profit & loss [in-depth guide]

    Run Report | Search Criteria | Display Options | Report Options | External Reports | Resources

    The corporate P&L reporting screen allows you to run your financial statements in a number of different ways in order to give you better insight into your financial position. It's designed to show the income statement for the company overall and/or GL company, office, GL class and department levels.

    You can run the report using several different modes. The first three use built-in layouts to make it quick and easy to get standard financial layouts. The fourth allows for total customization of the columns to be used.

    Run Report

    blobid1.png

    Run Report - Runs the report with the below search criteria specified. NOTE: You can adjust columns and add more layouts after running the report.

    More - Shows options for using Global Lists: Scheduled Reports.

    Search Criteria

    blobid0.png

    Company - Filters down to show only the GL COmp[amnies selcted.

    Office

    CLass

    Department

    Display Options

    blobid2.png

    Basis - Accrual, Cash. NOTE: When selecting Cash, a legacy checkbox appears for users who used Cash Basis in Workamajig prior to 2009. In general, never check this option.

    Hide 0 Amounts - Show/Hide account row when the balance result is 0.

    Hide Subaccounts - Show/Hide Sub Accounts. When hidden, only the top level roll-up accounts will remain.

    Show Summary Acct Subtotals -Show/Hide the amounts for each roll-up account.

    Show GL Account Numbers - Shows/Hides the GL Account Number next to each row of the results.

    Show EBITDA - Calculates the results of EBITDA into the amounts.

    • EBITDA stands for "Earnings Before Interest, Taxes, Depreciation, and Amortization". In Workamajig, this translates to "Net Income + Interest + Taxes + Depreciation + Amortization".
    • To designate EBITDA accounts, go to GL accounts. Check the box for "EBITDA Account" in the account details as needed.
    • blobid0.png

    % Column Based on - Revenue, AGI.

    Report Options

    blobid3.png

    One Report Per

    • Lets you select from All, Company, Office, GL Class, Department. NOTE: Some features listed will require additional setup.

    Single Range

    • Date range - This prints the financials for a specific time period, typically the current month or last month.
    • One Column Per - Optionally, you can show the year to date as an additional column or you can select to subdivide the columns based on either GL company, office or department.
    • YTD - Only appears when One Column Per All is selected.
    • Revaluation Rates - Only appears if you use Multi-Currency.

    Comparative

    • This view allows you to view two time periods next to each other as well as the difference between these periods.

    1 Year Monthly

    • Year
    • Starting Month
    • Number of Months

    Budget Comparison

    • This view lets you run the report for either a specific month or year and pick a specific budget to run a comparison against.

    Custom Layouts

    This gives you control over what date ranges to display in the columns as well as comparing budgets to actuals and include formulas for column-to-column calculations. For more on this feature, please refer to the Corporate Profit and Loss Layouts guide.

    External Reports

    Google Financial Link

    blobid4.png

    Allows you to pull the reports data into a Google Spreadsheet for more custom manipulation. For more on this feature, please refer to the Google financials and Google financial - cell style guides.

    Excel Financials

    While not listed on Run Report screen, you can create your own statement using Excel Financials.

    NOTE: This feature only works with the Windows OS.

    Resources

    Related articles