Overview
This article explains how to interpret, customize, and export your Profit & Loss (Income Statement) after it has been generated from your bank statements.
Once your report is available, you can:
Change how data is displayed
Drill down into transactions (General Ledger)
Export your report for external use
How is your P&L generated?
Your Profit & Loss statement is generated through the following flow:
Upload Bank Statements → Automatic Categorized Transactions → Chart of Accounts GL Postings → Profit & Loss Report
This means your report is only as accurate as the bank data you upload and how it is categorized.
ℹ️ Note: All values in your report are fully traceable back to individual transactions.
Step 1: Change how your report is viewed
You can adjust how your Profit & Loss data is displayed to better understand performance over time.
Report Display
The available view options include:
Total View: Shows the total amount for each category.
Monthly View: Breaks down your financial performance month by month.
Quarterly View: Groups your financial performance into quarters.
Yearly View: Shows full-year performance overview.
Hide zero balances
You can toggle Hide Zero Balances to remove accounts with no transactions or activity.
Step 2: Drill down into your report (General Ledger)
You can click on any account category in your Profit & Loss report to view the General Ledger (GL). This shows the detailed transactions that make up that value.
For example, select the Sales Revenue account. This opens the General Ledger for Sales Revenue.
What you will see in the GL
Each entry includes:
Transaction date
Transaction title
Description (narration)
Transaction type
Amount, etc.
Filtering and searching the GL
You can also filter and search the General Ledger for any account by:
Selecting a date range
Using preset periods (e.g., tax year, year-to-date, all time)
Searching for specific transactions or keywords
ℹ️ Note: This helps you narrow down results and focus on specific transaction activity within an account.
Why drill-down is important
Drill-down helps you:
Verify how totals are calculated
Trace figures back to bank transactions
Investigate unexpected values
Understand what drives revenue or expenses
ℹ️ Note: Every figure in your Profit & Loss report can be traced back to its source transaction.
Step 3: Export your Profit & Loss report
You can export your report for external accounting, reporting, or auditing purposes.
How to export your report
Go to your Profit & Loss report
Click the Export button
A confirmation pop-up will appear
Click Export to confirm
Once confirmed, your Profit & Loss report will be automatically downloaded to your device as an Excel file.
Frequently Asked Questions
1. How can I see the transactions behind a number in my report?
Click on any category or account (for example, Sales Revenue) in your Profit & Loss report.
This will open a detailed view showing all the transactions that make up that amount.
ℹ️ Note: This helps you verify the transactions that make up the account in your report.
2. Why am I seeing zero values in some categories?
If a category shows no values, it usually means no transactions have been recorded or assigned to that account.
To fix this:
Go to the Transactions table
Find the relevant transactions from your bank statement
Recategorize the transaction to your preferred category
ℹ️ Note: Once transactions are properly categorized, the values will automatically appear in your Profit & Loss report.
3. Why does my report look different when I change the view?
Changing the view (Total, Monthly, Quarterly, Yearly) only changes how the data is displayed.
The underlying data remains the same.
4. Why are some transactions missing when I check a category?
Check:
The selected date range
Whether the transactions fall within that period
If all bank statements have been uploaded
5. Can I download my Profit & Loss report?
Yes. Click the Export button to download your report as an Excel file.