Reports · Lumen Studio

Reports

Financial Statements

Profit & Loss Revenue minus expenses: your profit and loss for any period.

Profit & Loss Detail Every line item behind every P&L figure. Click any line to open it.

Profit & Loss Comparison This period beside the one before it or a year earlier, with the change.

Balance Sheet What you own and owe on a given date.

Balance Sheet Summary Top-level totals only, sub-accounts folded into their parent.

Balance Sheet Comparison The sheet on a date beside the sheet a month or a year earlier.

Statement of Cash Flows Where cash came from and where it went.

Liquidity Ratios Working capital, current and quick ratios and debt-to-equity, against a month and a year ago.

Budget vs. Actuals What you planned against what actually happened, month by month.

Cash Flow Forecast Money due in and out week by week, from open invoices and bills.

Accounts Receivable

A/R Aging Who owes you, how overdue, by customer, current through 90+ days, and every open invoice behind it.

Customer Balance Summary What each customer owes, one row each.

Customer Balance Detail Every invoice per customer and what's still open: the aging drill-down.

Open Invoices Every invoice with a balance still due.

Invoice List Every invoice in the period: amount, received, still open, and its status.

Invoices and Received Payments Each invoice with the payments applied to it, one beneath the other.

Collections Who is overdue, how much after credits, and how to reach them.

Unbilled Work by Job Job costs and billable hours you haven't invoiced on yet.

Sales & Products

Sales by Customer Total invoiced and open balance per customer, ranked.

Sales by Customer Detail Every line sold to each customer: the date, the document, the product.

Sales by Product/Service Units, revenue, COGS, and margin per product or service.

Sales by Product/Service Detail Every sale of each product or service: the date, the customer, the document.

Taxable Sales Summary Sales split taxable vs exempt, with the tax you collected.

Undeposited Funds Detail Customer payments received and held, not yet deposited to the bank.

Deposit Detail Every deposit into each bank account, with what it was made up of.

Inventory Reports Stock on hand, value, and movement.

Physical Inventory Worksheet A count sheet: every stock item, what the book says, and room to write what the shelf says.

Stock by Vendor What to reorder, grouped by the supplier you’d ring.

Assembly Shortage Which assemblies can’t be built, and the component that stops them.

Accounts Payable

A/P Aging Who you owe, how overdue, by vendor, current through 90+ days.

Vendor Balance Summary What you owe each vendor, one row each.

Vendor Balance Detail Every bill per vendor and what's still open.

Unpaid Bills Every bill you haven't settled yet.

Bills and Applied Payments Each bill with the payments applied to it, one beneath the other.

Bill Payment List Every bill payment: what it came out of and the bills it settled.

Unpaid Bills by Job For each job, which bills are still outstanding.

Open Purchase Orders What is still on order, from the lines not yet received.

Spending & Vendors

Purchases by Product/Service What you bought of each product, from whom, and what it cost.

Vendor Concentration How much you spend with each vendor, and how much of it sits with the top few.

Purchases by Vendor Detail Every line bought from each vendor: the date, the bill, what it was for.

Check Detail Every payment out of each bank account, with what it was split across.

1099 Summary Contractor totals for the year, and who still needs a W-9.

Jobs & Classes

P&L by Job Income, cost and margin for each job.

Job Profitability Each job broken down by cost code.

Job Budget vs Actual Cost-code budgets against what has actually been spent.

P&L by Class Revenue, cost and profit per class, and what isn't tagged.

Balance Sheet by Class The balance sheet split by class, with what isn’t classed shown.

Time

Time by Job Hours per job: worked, billable, invoiced, and the gap between them.

Time by Name The same, per person, employees and subcontractors together.

Time by Service Which kinds of work the hours went on.

Time by Customer Hours per customer, across all of their jobs.

Ledger & Audit

Trial Balance Every account's debit and credit balance: the ledger's backbone.

Working Trial Balance Beginning, activity, adjustments and ending per account: the year-end workpaper.

General Ledger Every posting in every account, in date order.

Transaction Detail by Account One account at a time: every posting to it, with a running balance.

Journal Every transaction as debits and credits, in date order.

Transaction List by Date Every transaction in the period, one row each, oldest first.

Transaction List with Splits The same list with every line of every transaction shown.

Audit Trail A record of every change made to your books.

Exceptions to Closing Date Anything changed or posted into a closed period after it was closed.

Reconciliation Reports Every finished statement reconciliation, with its cleared items.

Missing Checks Gaps and duplicates in each bank account’s check numbers.

Tax

Income Tax Summary Your year mapped to the lines of the return, ready for your preparer.

Deductions Deductible spending by category, and what it saves you.