Creating Reports
Profit and Loss Report
Overview
The Profit & Loss (or Income Statement) summarizes a Business’s revenue and expenses over a specific period. It calculates net income (profit or loss) by subtracting total expenses from total revenue.
Key components:
- Revenue – Money earned from Business operations.
- Cost of Goods Sold (COGS) – Direct costs of producing goods or services.
- Gross Profit – Revenue minus COGS.
- Operating Expenses – Costs of running the Business (e.g., salaries, rent, utilities).
- Net Income – The final profit or loss after all expenses are deducted.
A Profit & Loss Report helps Businesses assess profitability and track financial performance over time.
How to Generate a Profit and Loss Report
- Call the Retrieve the Profit and Loss Report endpoint with:
- Business ID
- Start Date
- End Date
- Use the returned data to structure the report as follows:
-
Revenue
- Sales Revenue
- Other Revenue ledgers
- Total Revenue
-
Cost of Goods Sold
- Cost of goods sold
- Other COGS ledgers
- Total COGS
-
Gross Profit
-
Operating Expenses
- Display all relevant Operating Expense ledgers
- Total Operating Expenses
-
Operating Profit
-
Other Incomes and Expenses
- Other income (e.g., investment earnings)
- Other expenses (e.g., loan interest payments)
-
Net Profit
-
P&L Best Practices
- Filter by date range – Use a date picker with standard periods like months, quarters, and years to give users control.
- Hide zero-value Ledgers – The API returns all Ledgers, including those with a balance of $0. Hiding these improves clarity.
- Enable drill-down into ledgers – Users may want to inspect specific ledgers. Use the Ledger Statement report to provide detailed transaction data.
Questions? Reach out via our Contact form.