Profit and Loss

Profit and Loss refers to a financial statement that summarizes the revenues, costs, and expenses incurred during a specified period

API Upload

The type parameter is p_and_l for the Upload endpoint.

Field Descriptions:

The model automatically detects data such as:

Fields	Type	Description
id	String	Row number
description	String	Description of line items
value	Object	Monthly values for a specific year. Json of `Year Month: amount`
total	Number	Total value across all months
row_type	String	Type of transaction (e.g., transaction_line)
coa_category	String	Chart of Accounts (COA) as per below table
coa_subcategory1	String	First subcategory of the COA
coa_subcategory2	String	Second subcategory of the COA
category	String	General category (e.g., income, expense) that is present in raw file
subcategory1	String	First general subcategory
subcategory2	String	Second general subcategory
subcategory3	String	Third general

COA Categories For CRE

COA_Category	COA_Subcategory1	COA_Subcategory2
Expense	Other Expense	Other expenses
Expenses	General And Administrative	Advertising And Marketing
Expenses	General And Administrative	Leasing
Expenses	Excluded Expenses	Excluded Expenses
Expenses	General And Administrative	Travel Or Meals And Entertainment
Expenses	General And Administrative	Office Expenses
Expenses	General And Administrative	Interest Paid
Expenses	General And Administrative	Managment Fees
Expenses	General And Administrative	Other Taxes Or Assmnts
Expenses	General And Administrative	Office Expenses
Expenses	General And Administrative	Insurance
Expenses	Payroll And Benefits	Salaries
Expenses	Payroll And Benefits	Payroll Taxes And Benefits
Expenses	Professional Fees	Professional Fees
Expenses	Rental Expenses	Rent
Expenses	Repairs And Maintainance	Building Repairs And Maintainance
Expenses	Repairs And Maintainance	Cleaning Or Turnover
Expenses	Repairs And Maintainance	Landscaping And Grounds
Expenses	Utilities	Energy
Expenses	Utilities	Fuel Or Gas
Expenses	Utilities	Trash Removal
Expenses	Utilities	Water And Sewer
Expenses	Utilities	Cabel And Internet
Expenses	Utilities	General Utilities
Income	Rental Income	Commercial Income
Income	Excluded Income	Excluded Income
Income	Concessions	Concessions
Income	Laundry Or Vending Income	Laundry Or Vending Income
Income	Other Income	Other Income
Income	Sales	Sales Of Product
Income	Sales	Sales Tax And Ammonts
Income	Vacancy And Collection Loss	Vacancy
Income	Vacancy And Collection Loss	Bad Debts
Total	Total	Total
Net Operating Income	Net Operating Income	Net Operating Income

COA Categories For Business

COA_Category	COA_Subcategory1	COA_Subcategory2
Expenses	Cost Of Sales	Labour
Expenses	Cost Of Sales	Manufacturing Distribution
Expenses	Cost Of Sales	Materials
Expenses	Cost Of Sales	Other Cost Of Sales
Expenses	Non Operating Expenses	Interests Paid
Expenses	Non Operating Expenses	Other Non Operating Expenses
Expenses	Non Operating Expenses	Professional Fees
Expenses	Operating Expenses	Allowances and Benefits
Expenses	Operating Expenses	Amortization
Expenses	Operating Expenses	Bank Charges
Expenses	Operating Expenses	Building Rent Lease
Expenses	Operating Expenses	Contract Services
Expenses	Operating Expenses	Cost Of Good sold
Expenses	Operating Expenses	Customer Aquisition Cost
Expenses	Operating Expenses	Depreciation Depletion
Expenses	Operating Expenses	Employee Stock Compensation
Expenses	Operating Expenses	Employee Wages
Expenses	Operating Expenses	Entertainment
Expenses	Operating Expenses	General And Administration Cost
Expenses	Operating Expenses	Insurance
Expenses	Operating Expenses	License Or Permits
Expenses	Operating Expenses	Marketing
Expenses	Operating Expenses	Other Operating Expenses
Expenses	Operating Expenses	Repairs Maintenance
Expenses	Operating Expenses	Research And Development
Expenses	Operating Expenses	Salaries
Expenses	Operating Expenses	Software
Expenses	Operating Expenses	Subscription Fees
Expenses	Operating Expenses	Taxes
Expenses	Operating Expenses	Travel
Expenses	Operating Expenses	Utilities
Income	Non Operating Income	Interest
Income	Non Operating Income	Other Non Operating Income
Income	Operating Income	General Services
Income	Operating Income	Non Recurring Income
Income	Operating Income	Products Merchandise
Income	Operating Income	Recurring Income
Total	Total	Total

Coverage

Majority of English language profit and loss

Version

1.0.0

Sample

Sample JSON Output

{
     "data": [
            {
                "id": "0",
                "description": "Company Revenue",
                "value": {
                    "March 2022": 0.0,
                    "February 2022": 0.0,
                    "January 2022": 500000.0
                },
                "total": 500000.0,
                "row_type": "transaction_line",
                "coa_category": "Income",
                "coa_subcategory1": "Non Operating Income",
                "coa_subcategory2": "Other Non Operating Income",
                "category": "income",
                "subcategory1": "",
                "subcategory2": "",
                "subcategory3": ""
            },
            {
                "id": "1",
                "description": "Total Income",
                "value": {
                    "March 2022": 0.0,
                    "February 2022": 0.0,
                    "January 2022": 500000.0
                },
                "total": 500000.0,
                "row_type": "total_line",
                "coa_category": "Total",
                "coa_subcategory1": "Total",
                "coa_subcategory2": "Total",
                "category": "income",
                "subcategory1": "",
                "subcategory2": "",
                "subcategory3": ""
            }
        ]
    }