Client Books

Answering "how is this client doing?" usually means logging into their accounting software and hunting for the right organisation. Connect a client's books to Sodium and their profit and loss, balance sheet, who owes them, who they owe, and the invoices and bills behind both sit on the Books tab of their client record, next to their services, tasks and documents.

Xero
QuickBooks
FreeAgent
Sage

At a glance

  • Connect a client's Xero, QuickBooks, FreeAgent or Sage through OAuth - no shared logins
  • Profit and loss for any date range you choose
  • Balance sheet as at any date, in the platform's own groupings
  • Aged debtors by customer, then every sales invoice with what is still outstanding
  • Aged creditors by supplier, then every bill with what is still to pay
  • Bank accounts with balances, and the full chart of accounts, searchable by code or name
  • Read live from the client's books every time - read-only, never cached

Connect a Client's Accounting Software

On the Books tab, Sodium asks where the client does their accounting and offers the accounting platforms it supports - Xero, QuickBooks, FreeAgent and Sage. Pick one and you connect through secure OAuth; no API keys and no shared logins.

If your practice already has a connection to that platform, Sodium lists the organisations it can see and you simply choose the client's. If they sit under a different login, sign in with those credentials instead.

From there the numbers are simply there - a client's profit and loss summary, read from their books rather than retyped into Sodium:

The profit and loss summary on the Books tab: income minus expenses giving operating profit, less drawings and adjustments, then retained profit plus the amount brought forward giving the amount carried forward

P&L, Balance Sheet, Sales, Purchases and More

Once connected, the Books tab reads directly from the client's accounting software:

  • P&L - a profit and loss report for any date range you choose, so you can see how the client is trading before a meeting or a piece of work.
  • Balance Sheet - the client's position as at any date you pick, in the platform's own groupings of assets, liabilities and equity. The date shown is the one the platform actually ran the report to - Xero rounds to the end of the month asked for - so nobody reads figures as at a day they were never stated for.
  • Bank - each account with its name, account number, currency and balance.
  • Sales - who owes the client money, then the invoices behind it.
  • Purchases - who the client owes, then the bills behind it.
  • Chart of Accounts - the full nominal ledger with code, name and account type, searchable by code or name.

P&L and Balance Sheet appear on the platforms that publish those reports - today Xero, QuickBooks and FreeAgent. Sage's API exposes neither, so on a Sage connection those two tabs are simply not there and Bank leads instead. Sales and Purchases work the same on all four platforms.

How the profit and loss is drawn follows the platform too. Xero and QuickBooks return a sectioned report; FreeAgent returns a summary, which Sodium lays out as the sum it actually is.

The Books tab on a client record showing P&L, Balance Sheet, Bank, Sales, Purchases and Chart of Accounts sub-tabs, with the bank accounts, currencies and balances of a connected Xero organisation listed

Sales: Aged Debtors, Then Invoices

The Sales tab opens on the question that usually matters most - how much is the client owed, and how old is it? Two headline figures show what is outstanding and how much of it is overdue, and a single bar splits the total across Current, 1-30, 31-60, 61-90 and over 90 days, shading darker the older the debt.

Beneath that, every customer with a balance is listed across the same age bands with a total, largest first, so the one or two accounts worth chasing stand out straight away. Debt is aged from each invoice's due date, and a client trading in more than one currency gets a separate breakdown for each.

Under the debtors sits the full list of sales invoices - number, customer, date, due date, status, total and outstanding amount - filterable by status and date range, with each invoice linking straight through to it in the client's accounting software.

Purchases: Aged Creditors, Then Bills

Purchases is the mirror image. Aged creditors come first: what the client owes, how much of it is overdue, and which suppliers it is owed to, broken down across the same age bands.

Then the bills themselves - supplier reference, supplier, date, due date, status, total and what is still to pay - with the same status and date filters. Useful when a cash flow conversation turns to what is going out as well as what is coming in.

Read-Only, and Always Current

Nothing is copied into Sodium and kept in a stale cache - each tab queries the client's accounting software when you open it, so what you see is what is in their books right now. Client Books is read-only: Sodium never writes to or changes the client's accounting records.

It is a different job from client billing, which is about the invoices your practice raises for your own fees. Client Books is about their numbers, not yours.

And if the question is not what the numbers say but how far to trust them, Bookkeeping Health sits on the same tab — a quality score for the books themselves, read from Xenon Connect.

Where It Helps

Having the books one click from the client record removes a lot of small interruptions:

  • Check trading before a year-end meeting or a planning call, without opening another application.
  • Answer a balance sheet question - what the client holds, what they owe - as at the date the question is actually about, rather than waiting on an export.
  • Look up a nominal code while preparing a task rather than asking the client for it.
  • Spot a client with a debtor problem - or a pile of overdue bills - before it turns into a cash flow conversation.
  • See whether an invoice or bill the client has queried is still outstanding on their side.
  • Give a team member the financial context for a client they have not worked on before, without handing out logins to the accounting platform.