Getting Started

Understanding the Dashboard in Simple Books

Learn how the Simple Books Dashboard calculates invoice, bill and overdue figures, charts, alerts and recent activity, and how they differ from accounting reports.

12 minute read Last updated

Introduction

The Dashboard is the operational overview shown when you open Simple Books. It brings together selected invoice, bill, client, customer, expense and mileage data so you can see amounts still outstanding, items needing attention, recent records and broad monthly patterns.

This guide explains the Dashboard exactly as it is currently implemented. Its figures are management prompts based on saved transaction records. They are not accounting balances and should not be treated as a replacement for the Trial Balance, General Ledger, Profit & Loss or Balance Sheet.

What the Dashboard is for

Use the Dashboard to answer practical questions such as: how much do customers currently owe, how much is still owed on supplier bills, are any invoices or bills past their due dates, and which records were most recently active?

The page contains a Getting Started checklist, four calculated KPI cards, a concise Business Health panel, two charts, a Next Actions area and Recent Activity. Selecting the Outstanding invoices or Overdue items cards opens Invoices, while Unpaid bills and Net position open Bills. Trial Balance and Balance Sheet remain available from Accounting navigation rather than appearing as Dashboard shortcut cards.

The Business Health panel uses the same deterministic score and status as Business Insights. Starter shows only high-level snapshot signals; Pro and Demo can also show up to three concise signals backed by existing forecast and obligation calculations. The panel never shows the full score breakdown, trends, recommendations or methodology. Select View Business Insights for the complete experience available to your plan.

The Dashboard has no date-range, customer, supplier, project or status filters. It loads its figures once when the page opens.

Dashboard KPIs

Outstanding invoices

Outstanding invoices adds the full Total of every saved invoice whose status is not exactly Paid. In normal use this means Unpaid invoices, including those whose due dates have passed. The figure includes VAT where VAT forms part of the invoice total. It is not restricted to the current month.

Paid invoices

The current Dashboard does not display a separate Paid invoices KPI. Paid invoices are excluded from Outstanding invoices, overdue checks and the receivables ageing chart. They remain included in the Income vs Bills chart because that chart adds all saved invoice totals regardless of status.

Overdue invoices and Overdue items

The current card is labelled Overdue items, not Overdue invoices. It shows a count, not a money value, and combines overdue invoices with overdue supplier bills. An invoice or bill is overdue when its status is not exactly Paid, it has a valid due date, and that date is earlier than today. A due date of today is not overdue.

There is no separate Overdue invoices KPI. The overdue-invoice count and value are shown in Next Actions when at least one invoice needs chasing.

Unpaid bills

The current bills KPI is labelled Unpaid bills. It adds the full Total of every saved bill whose status is not exactly Paid, including overdue bills. The value includes VAT where VAT forms part of the bill total and covers all dates.

Net position

Net position is Outstanding invoices minus Unpaid bills. It compares gross operational totals. A positive amount means the outstanding invoice total is greater than the unpaid bill total; a negative amount means unpaid bills are greater. It is not a bank balance, cash forecast, profit figure or accounting Balance Sheet position.

Expenses this month and Mileage this month

The current Dashboard does not display separate Expenses this month or Mileage this month KPIs. Expenses and mileage claims do not contribute to Outstanding invoices, Unpaid bills, Net position, Overdue items or either chart. They can appear in Recent Activity using the saved expense gross amount or mileage amount.

Income vs Bills Difference

The current page does not show Income vs Bills Difference as a KPI card. Difference is the third series in the Income vs Bills chart. For each month it is all invoice totals minus all bill totals for that month. It includes Paid and Unpaid records and excludes expenses and mileage.

Dashboard charts

Income vs Bills

The Income vs Bills line chart groups records by month and plots three series:

  • Invoices: the full totals of all saved invoices in the month, regardless of Paid or Unpaid status.
  • Bills: the full totals of all saved bills in the month, regardless of Paid or Unpaid status.
  • Difference: Invoices minus Bills for that month.

Invoices are grouped using invoice date, falling back to created date. Bills use bill date, falling back to due date and then created date. Months with activity are shown in chronological order. The chart uses gross totals, including VAT where present. It does not include expenses, mileage, projects or payment dates, and its Difference line is not accounting profit.

Outstanding Receivables Ageing

The Outstanding Receivables Ageing bar chart groups outstanding invoice value into Not yet due, 0–30 days, 31–60 days and 61+ days. It includes invoice statuses Unpaid, Outstanding and Overdue without regard to capitalisation; a missing status is treated as Unpaid. Paid invoices and unsupported status values are excluded.

Age is measured from the due date to today. A due date after today goes into Not yet due. An invoice due today and invoices up to 30 days overdue go into 0–30 days. If no due date exists, the ageing calculation falls back to invoice date. Invalid dates are ignored. Each bucket uses the invoice’s full total, including VAT.

Both charts are rebuilt from the records loaded when the Dashboard opens. They do not update live while the page remains open in another tab.

Recent activity

Recent Activity combines invoices, bills, clients or customers, and the shared expense/mileage collection. It sorts them by the date chosen for each record and displays the five most recent items.

  • Invoices: show invoice number or client, gross total, status and invoice date, falling back to created date and then due date.
  • Bills: show bill number or supplier, gross total, status and bill date, falling back to due date and then created date.
  • Clients or customers: show the name and status but no amount. If at least one client record exists, the customer collection is not added separately.
  • Expenses and mileage: are both labelled Expense. The amount uses gross expense value first, then the mileage amount. Their ordering date uses updated date before transaction date or created date, so editing one can move it up the list.

Recent Activity is a display list, not an audit log. It shows at most five current records and does not preserve a history of every edit or status change.

Dashboard reminders and alerts

The Getting Started checklist tracks five setup conditions: a profile with full name, business name and email; default payment terms; at least one client or customer; at least one invoice; and a first backup recorded as downloaded in the browser. Completed items are hidden. When all five are complete, the card shows Setup complete.

Next Actions currently creates up to two reminders:

  • Overdue invoices to chase: appears when one or more non-Paid invoices have due dates earlier than today. It shows their count and combined gross total, with a link to Invoices.
  • Bills need attention: combines non-Paid bills already overdue with non-Paid bills due from today through seven days from today. It shows the relevant counts and combined gross total, with a link to Bills.

If neither reminder applies, the page says You’re all caught up. These are fixed date-and-status checks. They do not judge whether an invoice should be disputed, whether a bill has been scheduled for payment or whether a transaction’s accounting treatment is correct.

How dashboard figures are calculated

  • Outstanding invoices = sum of invoice Total where status is not exactly Paid.
  • Unpaid bills = sum of bill Total where status is not exactly Paid.
  • Net position = Outstanding invoices − Unpaid bills.
  • Overdue items = count of overdue non-Paid invoices + count of overdue non-Paid bills.
  • Monthly chart Difference = all invoice totals in the month − all bill totals in the month.

The four calculated cards also show trend badges. These compare the current month with the previous month, not the all-time card total. Outstanding uses non-Paid invoices grouped by invoice activity date; Unpaid bills uses non-Paid bills grouped by bill activity date; Net position subtracts those two monthly values; and Overdue items compares records by the month of their due dates.

If the current and previous values are equal, the badge says No change. If the previous value is zero and the current value differs, the change is shown as 100%. The arrow shows whether the numeric value increased or decreased; it is not an accounting assessment of whether that movement is favourable.

When signed in, the Dashboard attempts to load invoices, bills, clients, customers and expenses from the user’s Firestore collections. If an individual load fails, the error is written to the browser console and that collection retains its locally loaded fallback. The current Dashboard does not show a visible incomplete-data warning, so refresh or check the underlying page if a figure looks unexpected.

When dashboard values update

Saving, editing, deleting or changing the status of a source record can change the next Dashboard calculation. However, the Dashboard loads data once rather than listening for live changes. If it is already open, refresh it; otherwise open it again after saving the source record.

  • Saving or editing an invoice can change Outstanding invoices, Net position, Overdue items, both charts, alerts and Recent Activity.
  • Saving or editing a bill can change Unpaid bills, Net position, Overdue items, the Income vs Bills chart, alerts and Recent Activity.
  • Saving or editing an expense or mileage claim can change Recent Activity only on the current Dashboard.
  • Marking an invoice or bill Paid removes it from outstanding or unpaid calculations, overdue checks and related alerts on the next load, but it remains in the Income vs Bills chart.

Charts are therefore updated from saved records on the next Dashboard load, not immediately in an already open page. Project allocation does not change any Dashboard calculation because the Dashboard has no project filter.

Why dashboard totals may differ from accounting reports

The Dashboard reads operational source records. Its monetary cards and charts use invoice and bill Totals, which are gross values including VAT where present. Payment status and due dates control several Dashboard figures. Expenses and mileage are omitted from its KPI and chart calculations.

The Trial Balance, General Ledger, Profit & Loss and Balance Sheet read accounting journals. Profit & Loss uses net Sales Revenue and expense account postings, separates VAT into balance-sheet accounts, and includes posted bills, expenses and mileage for the selected period. The Balance Sheet shows receivables, payables, VAT accounts and current-year result from those journals.

Current payment-status actions do not post Bank entries or clear the journal balances. This creates another important difference: marking an invoice Paid removes it from the Dashboard’s Outstanding invoices figure, but the existing sales journal still debits Trade Receivables. Similarly, marking a bill Paid removes it from Unpaid bills while its journal still credits Trade Payables. Read What is double-entry bookkeeping? for the exact current postings.

A saved operational record can also remain on the Dashboard if its ledger posting failed, while it is absent from accounting reports. Conversely, current delete workflows can remove a source record from the Dashboard without reversing its existing journal. Always investigate differences at source-record and journal level.

Worked examples

Operational overview with invoices and bills

A design business has three invoices: £120 Unpaid and not yet due, £240 Paid, and £60 Unpaid and overdue. It also has a £90 Unpaid bill due in five days, a £30 Paid bill and a £50 Unpaid overdue bill.

  • Outstanding invoices: £120 + £60 = £180.
  • Unpaid bills: £90 + £50 = £140.
  • Net position: £180 − £140 = £40.
  • Overdue items: one overdue invoice + one overdue bill = 2.
  • Overdue invoice reminder value: £60.
  • Bills needing attention: £90 due soon + £50 overdue = £140.

If all six records have transaction dates in the same month, the Income vs Bills chart shows Invoices of £420, Bills of £170 and Difference of £250. Paid records remain in this chart. A £36 expense and a £22 mileage claim do not change those figures, although either may appear in Recent Activity.

Gross Difference versus accounting profit

A VAT-registered consultant raises one £120 invoice made up of £100 net plus £20 VAT and enters one £60 supplier bill made up of £50 net plus £10 VAT. The chart Difference is £120 − £60 = £60 because it uses gross totals. Ignoring other entries, Profit & Loss uses £100 Sales Revenue less £50 expense, giving £50. The £10 difference comes from the separate VAT postings, not an error in either calculation.

Marking an invoice Paid

An overdue £300 invoice is marked Paid. After the Dashboard is refreshed, Outstanding invoices falls by £300, Net position falls by £300, Overdue items falls by one, the chase reminder no longer includes it and the ageing chart excludes it. The Income vs Bills chart is unchanged because it includes invoices of every status. The current accounting journal is also unchanged because the status action does not post a receipt to Bank.

Common mistakes and misunderstandings

  • Treating Net position as cash or profit. It is gross non-Paid invoice totals minus gross non-Paid bill totals.
  • Reading Overdue items as overdue invoices only. The card combines invoice and bill counts.
  • Expecting separate Paid invoices, Expenses this month or Mileage this month KPIs. The current Dashboard does not display them.
  • Calling chart Difference profit. It includes VAT, includes every payment status and omits expenses and mileage.
  • Expecting a Paid invoice or bill to disappear from the monthly chart. Status does not filter that chart.
  • Assuming due today means overdue. Overdue checks require the due date to be earlier than today.
  • Expecting charts to change live in an open tab. Reopen or refresh the Dashboard after saving or editing records.
  • Assuming Recent Activity is a full history. It contains at most five current records and is not an audit log.
  • Looking for separate mileage activity. Mileage records are currently labelled Expense in Recent Activity.
  • Comparing gross Dashboard totals directly with net Profit & Loss figures. The data sources, VAT treatment and included transaction types differ.
  • Ignoring possible load gaps. Collection failures are logged to the console without a visible incomplete-data warning.

Summary

The current Simple Books Dashboard provides four calculated KPIs: gross Outstanding invoices, gross Unpaid bills, their Net position and a combined count of Overdue items. Its Income vs Bills chart compares all gross invoice and bill totals by month, while Outstanding Receivables Ageing groups supported outstanding invoice values by due-date age.

Use Next Actions for overdue invoices and bills due or overdue, and Recent Activity for the latest five invoice, bill, client/customer and expense/mileage records. Refresh the page after changing source records. For accounting balances and performance, use the journal-based reports and investigate any difference rather than treating Dashboard Difference or Net position as profit.