BookKeeper Agent Reports & Analytics Walkthrough
1 / 10
B
Product Demo

BookKeeper Agent
Reports & Analytics

A complete walkthrough of the reporting suite — real-time dashboard KPIs, interactive charts, filterable analytics, the Profit & Loss statement, and a tamper-proof audit trail.

◈ Dashboard — June 2025
Revenue · This Month
$8,900
Expenses · This Month
$4,400
Net Income
$4,50050.6%
Outstanding Invoices
$12,5502 overdue

Expense Breakdown

Payroll
$1,820
Software
$740
Marketing
$620
Travel
$480
Office
$340

Recent Activity

↑
Apex Dynamics
Jun 3
+$2,670
↓
Payroll May
Jun 2
−$1,820
↑
Meridian Group
Jun 2
+$2,225
↓
SaaS Subscriptions
Jun 1
−$740
↑
Blue Horizon Tech
Jun 1
+$1,780
↓
Ad Campaign
May 31
−$620
↑
Sunrise Retail
May 30
+$1,425
↓
Office Supplies
May 29
−$340
01
Live Dashboard
Your Business Health at a Glance
The Dashboard is the first screen you see after login — a real-time summary of your business's financial position for any period you choose.
◆
Period-aware KPIs — revenue, expenses, net income, and outstanding invoices all update instantly when you switch between week, month, year, or a custom date range.
◆
Profit margin indicator — the Net Income card shows your margin percentage so you can judge profitability without opening a separate report.
◆
Expense breakdown — a live horizontal bar chart breaks down spending by category, making it immediately obvious where money is going.
◆
Recent activity feed — the last eight transactions appear chronologically so you can spot any unexpected entries the moment you open the app.
Period Filter
Week
Month
Year
Custom

Period Comparison

Metric Year (Before) Month (After)
Revenue $47,500 $8,900
Expenses $25,400 $4,400
Net Income $22,100 $4,500

Custom Range Example

From
2025-03-01
To
2025-05-31
Q1–Q2 Custom Result (3 months)
Revenue
$26,700
Expenses
$12,900
Net Income
$13,800
02
Period Selector
Filter Every Report by Any Time Range
A single global period selector at the top of the app controls every chart, metric, and report simultaneously — no need to set filters on each screen individually.
◆
Four preset modes — This Week, This Month, This Year, and Custom. Switch between them with a single click and every number on every screen updates instantly.
◆
Custom date range — pick any start and end date to analyse a specific quarter, campaign period, or fiscal year that doesn't align with calendar months.
◆
Global scope — the period filter applies to the Dashboard, Charts, Financial Summary, and Reports simultaneously. One selection, consistent data everywhere.
◆
Comparison-ready — switching periods side-by-side makes it easy to compare performance across different timeframes without exporting to a spreadsheet.
◈ Financial Summary — June 2025 ↓ Export PDF
Gross Revenue
$8,900
Tax Collected
$556.25
Net Revenue
$8,343.75
Total Expenses
$4,400
Net Income
$3,943.75
Outstanding AR
$12,550

Profit & Loss Statement

CategoryAmount% Rev
REVENUE
Apex Dynamics$2,67030%
Meridian Group$2,22525%
Blue Horizon Tech$1,78020%
Sunrise Retail$1,42516%
Crestwood Partners$8009%
Total Revenue$8,900100%
(Less) Sales Tax($556.25)6.25%
Net Revenue$8,343.7593.75%
EXPENSES
Payroll$1,82020.4%
Software$7408.3%
Marketing$6207.0%
Travel$4805.4%
Office$3403.8%
Professional$4004.5%
Total Expenses$4,40049.4%
NET INCOME$3,943.7544.3%
03
Financial Summary
Your Complete Profit & Loss, Instantly
The Financial Summary page generates a full P&L statement for the selected period — no accountant needed to see exactly where every dollar came from and where it went.
◆
Six headline metrics — gross revenue, tax collected, net revenue, total expenses, net income, and outstanding accounts receivable are all visible above the report in large, colour-coded cards.
◆
Revenue by client — every income source is listed with its dollar amount and percentage share of total revenue, so you know which clients drive the most value.
◆
Full expense breakdown — every spending category appears as its own line, with a percentage of gross revenue so you can benchmark cost ratios at a glance.
◆
Export to PDF or XLSX — generate a formatted PDF report or an Excel workbook of the full P&L with one click — ready to share with your accountant, bank, or investors.
6-Month Income vs Expenses Trend
6.8k
4.2k
Jan
7.5k
3.8k
Feb
8.2k
5.1k
Mar
9.6k
4.7k
Apr
8.9k
4.4k
May
6.5k
3.2k
Jun
Income
Expenses
Best Month
Apr $9.6k
Avg Income
$7,917
Avg Expenses
$4,233
04
Trend Analysis
Six Months of Performance, Side by Side
The 6-Month Trend chart shows income and expenses as paired bars for each month — making seasonal patterns, growth trends, and cost spikes immediately visible without any analysis work.
◆
Paired bar format — income and expense bars sit side-by-side for each month, making it immediately clear whether a given month was profitable and by how much.
◆
Rolling window — the chart always shows the most recent six months, auto-advancing each month so the view stays current without any manual configuration.
◆
Value labels — the exact dollar amount appears above each bar so you can read precise figures without needing to hover or click.
◆
Trend visibility — rising income bars alongside stable expense bars signal healthy growth; a narrowing gap between the two is an early warning sign to investigate.
◈ Charts & Analytics
Chart View
Expenses by Category
Income by Client
Income vs Expenses ●
Monthly Trend
Chart Type
Pie
Donut
Bar ●
Line
Gross Revenue
$47,500
Tax
$2,969
Net Revenue
$44,531
Expenses
$25,400
Net Income
$19,131
Margin
40.3%

Client Filter

Select All Clear All
Apex Dynamics Meridian Group Blue Horizon Tech Sunrise Retail Crestwood Partners
05
Charts & Analytics
Four Views. Four Chart Types. One Screen.
The Charts & Analytics module is the most flexible reporting tool in the app — mix and match any of four chart views with four rendering styles, and slice the data with interactive filter chips.
◆
Four chart views — Expenses by Category, Income by Client, Income vs Expenses, and Monthly Trend. Each view reconfigures the entire chart and its associated filter options automatically.
◆
Four chart types — switch between Pie, Donut, Bar, and Line charts for any view. The type that best communicates the pattern for your audience is always one click away.
◆
Interactive filter chips — toggle individual categories or clients on and off using the chip panel. The chart and summary metrics update live with every toggle, with Select All / Clear All shortcuts.
◆
Period-aware — the Charts page respects the same global period selector as every other screen, so the data always matches what you see on the Dashboard and Reports pages.
Expenses by Category — Pie Chart
Filtered Total
$25,400
Transactions
47
Categories
6 / 6
$25,400 Total
Payroll43%
Software17%
Marketing14%
Office11%
Travel9%
Professional6%

Category Filter

Clear All
Payroll Software Marketing Office Travel Professional
06
Expense Analysis
See Where Every Dollar Is Spent
The Expenses by Category view renders your spending breakdown as a pie, donut, bar, or line chart — giving you a visual distribution of costs that a table alone cannot communicate.
◆
Colour-coded categories — each expense category has a consistent colour across all charts, tables, and the dashboard — so Payroll is always the same shade whether you're reading a bar or a pie.
◆
Proportion at a glance — the pie and donut charts make it instantly obvious when one category is dominating spending, such as payroll consuming over 40% of operating costs.
◆
Filterable — deselect any category chip to remove it from the chart and recalculate the totals for the remaining categories. Useful for isolating controllable costs from fixed overheads.
◆
Switch chart type freely — the same category data renders as a pie for presentations, a bar for precise comparison, or a line for spotting month-to-month category trends.
Audit Log ↓ Export XLSX
Timestamp Action Entity User Role
Jun 3, 2025 09:14 INVOICE_CREATED INV-2025-007 sarah.m admin
Jun 3, 2025 09:12 CLIENT_CREATED Northbridge Consulting sarah.m admin
Jun 2, 2025 16:45 INVOICE_PAID INV-2025-004 sarah.m admin
Jun 2, 2025 11:30 EXPENSE_DELETED Office Supplies $89.50 j.okafor user
Jun 1, 2025 14:22 INCOME_CREATED Apex Dynamics $2,670 sarah.m admin
May 31, 2025 17:05 USER_UPDATED p.nair role→user sarah.m admin
May 30, 2025 10:18 EXPENSE_CREATED Payroll May $1,820 sarah.m admin
May 29, 2025 08:55 INVOICE_OVERDUE INV-2025-003 $2,700 system —
Immutable: Audit entries are write-only and cannot be edited or deleted from within the application. The trail is always honest.
07
Audit Log
A Complete Record of Every Change
The Audit Log records every create, update, delete, and status-change event in the application — who did it, when, and what changed. It is your compliance paper trail, built automatically.
◆
Every action logged — creating or deleting an expense, raising an invoice, editing a client, changing a user role, and marking a payment received are all captured with no manual effort required.
◆
Who and when — every entry records the username, role, and exact timestamp of the user who performed the action, making it straightforward to investigate any discrepancy.
◆
Immutable trail — audit entries are write-only. They cannot be edited or deleted from within the application, preserving an honest record even if the underlying data is later changed.
◆
XLSX export — export the complete audit history to a spreadsheet at any time for external review, compliance submissions, or archiving with your year-end financial documents.
Export Options
📄
Financial Summary PDF
Formatted report with company logo, P&L table, period header, and signature line — ready to send to investors, lenders, or your accountant.
↓ Export PDF
📊
Full Data Export
Complete workbook with separate sheets for Expenses, Income, Invoices, Clients, and Audit Log — opens in Excel, Google Sheets, or LibreOffice.
↓ Export XLSX

Additional Exports

📋
Audit Log — CSV
Export the audit trail separately for compliance submissions or regulatory filings without bundling the full financial workbook.
↓ CSV
Period-matched: All exports reflect the currently selected period filter. Switch to the fiscal year view, click Export, and the output covers exactly that year.

XLSX Workbook Structure

Sheet 1: Expenses Sheet 2: Income Sheet 3: Invoices Sheet 4: Clients Sheet 5: Audit Log
08
Data Export
Your Reports, Your Format
Every report and data set in BookKeeper Agent can be exported at any time — no internet connection required, no cloud service involved. Your data stays under your control from generation to delivery.
◆
PDF Financial Summary — generates a formatted, print-ready PDF of your P&L report for the selected period, complete with your company logo and contact details from the Admin profile.
◆
Full XLSX workbook — exports all data across five sheets (Expenses, Income, Invoices, Clients, Audit Log) into a single Excel-compatible file for accountant handover or offline analysis.
◆
Audit Log export — the audit trail can be exported separately as a CSV for compliance submissions or regulatory filings without bundling the full financial workbook.
◆
Period-matched — all exports reflect the currently selected period filter. Switch to the fiscal year view, click Export, and the output covers exactly that year — no date configuration needed.
◈

Insight at Every Level.
With Zero Compromise.

BookKeeper Agent's reporting suite gives small businesses the same analytical depth as enterprise accounting software — running entirely offline, with full data ownership.

✓Live Dashboard — real-time KPIs for any period, updated on every transaction
✓Period Selector — week, month, year, or any custom date range, globally applied
✓6-Month Trend — paired income vs expense bars for instant trend reading
✓Four Chart Views — expenses, income, comparison, and rolling monthly trend
✓Four Chart Types — pie, donut, bar, and line — switch in one click
✓Interactive Filters — toggle categories and clients, live chart recalculation
✓Profit & Loss Statement — complete P&L with client and category breakdown
✓Audit Log — immutable, exportable record of every change
BookKeeper Agent by ATECH Software LLC  ·  atechsoftware.net