How Numbers Are Calculated

This page explains how Argo Books arrives at every dollar figure you see (revenue, profit, tax, refunds) in plain language. If a number on your dashboard surprises you, this is the page to check.

Quick answers

Question Answer
Does tax count as revenue? Yes. "Total Revenue" includes it (gross). Profit excludes it.
Does shipping the customer paid me count as profit? Yes. Record what you paid the courier as an Expense to balance it out.
Why does the dashboard show $0 even though I have unpaid invoices? The dashboard shows money you've actually collected. Unpaid invoices appear in "Outstanding Invoices" instead.
Why is my Net Profit smaller than my Total Revenue minus Expenses? Profit excludes sales tax (it's not yours to keep). See Net Profit below.
How are refunds handled? Subtracted from revenue on the day the refund was issued. See Refunds below.
Why doesn't my per-product revenue add up to Total Revenue? Refunds aren't split per product, and un-itemised sales aren't counted. See Sales by product below.
Why does a transaction show "Pending" instead of an amount? Its exchange rate isn't available yet, so it counts as zero until it is. See Currency display below.

Total Revenue

Total Revenue is the full amount your customers paid you, including sales tax, shipping, and any fees. It matches the invoice totals you sent out.

What's in:

  • The item or service amount the customer was charged
  • Sales tax you collected
  • Shipping the customer paid
  • Any custom fees you added (rush delivery, setup fee, etc.)

What's out:

  • Discounts (already subtracted before the total)
  • Refunds you've issued (subtracted from the day the refund was sent)
  • Unpaid invoices (the dashboard only counts money you've actually received)
  • Security deposits (see below)
Security deposits: a deposit is added to the invoice total so the customer is charged it, but it isn't taxed and isn't treated as money you've earned. It's a refundable hold. If a customer forfeits their deposit and you get to keep it, record that as revenue separately so it counts.

Net Profit

Net Profit answers a different question: how much did the business actually keep? So it deliberately excludes anything that isn't yours to keep.

The formula:

Net Profit = Revenue (excluding sales tax) − Expenses − Refunds

The key thing to know: sales tax is not part of profit. When a customer pays you $11 on a $10 sale with 10% sales tax, you collected $11 but only $10 is yours: the $1 is owed to the government. Argo Books treats that $1 as a liability, not as profit.

Shipping the customer paid is in. If they paid you $8 for shipping, that's $8 in your pocket. If you then paid a courier $8 to actually ship the item, you'll record that as an Expense and it cancels out. Net effect on profit: zero. If you charged $8 but only paid $5 to ship, you keep $3 in margin.

Tip: If your profit looks higher than expected, double-check that you've recorded the shipping cost you paid (carrier invoices) as Expenses. The customer's payment is automatically in revenue; the carrier payment is not automatically in expenses, so you have to add it.

Refunds

A refund reduces your numbers on the day the refund was issued, not the day of the original payment. Same-day refund nets out to zero on that day; a refund issued a week later leaves the original day's revenue intact and shows a negative on the refund's day.

How refunds affect each number:

  • Total Revenue: reduced by the full refund amount.
  • Net Profit: reduced by the refund amount minus the tax portion of that refund. The tax portion was never profit on the way in (it was always owed to the government), so it doesn't reduce profit on the way out either.
  • Invoice status: flips to "Refunded" when the refund covers the full invoice value, or "Partially Refunded" if only part was returned (or if you paid, refunded, and paid again).

If you pay a customer, get refunded, then pay them again, the invoice stays "Partially Refunded" so the refund history is still visible alongside the new payment.

Tax

Argo Books tracks two tax numbers:

  • Tax Collected: the sales tax you charged customers on your invoices.
  • Tax Paid: the sales tax you paid suppliers on your expenses (when you record it).

Argo Books does not subtract one from the other for you. It reports the tax you collected, and shows the tax you paid separately. In many places the tax you paid suppliers can be deducted from the tax you owe, but the rules vary and the decision is yours, so Argo Books leaves that step to you or your advisor rather than guessing.

Argo Books also does not file or remit tax. It gives you the figures to hand to your accountant or filing service.

Cash basis (Dashboard) vs. accrual (Reports)

This is the single biggest source of "why does the dashboard say X but the Revenue page says Y?" confusion. The two views answer different questions:

Surface What it counts Use it for
Dashboard, Analytics, charts Cash basis: only invoices the customer has actually paid. "How is my business doing right now? What's in the bank?"
Revenue page (list view) All revenue rows you've recorded, paid or not. Reviewing or editing individual records.
Outstanding Invoices stat card Only invoices that haven't been paid. Following up on what customers owe you.
Reports (Income Statement, Balance Sheet) Accrual basis: all invoiced revenue, paid or not. Filing taxes, sharing with an accountant, year-end reviews.
Why the difference? Cash basis answers "did money actually arrive?" Accrual basis answers "did I do the work that earned the money?" Both are valid views; small businesses usually want the cash-basis dashboard for day-to-day decisions and the accrual report for taxes and accountants.

Inventory on the Balance Sheet

The Balance Sheet lists your stock on hand as a current asset. It values each item at its current unit cost (Argo Books doesn't keep a history of past costs) and works out how much stock you held as of the report date from your recorded stock movements.

Buying stock is still recorded as an expense when you purchase it, so adding inventory here doesn't change your profit. Only the Balance Sheet treats unsold stock as something you own.

Sales by product

The Products tab in Analytics and the "Sales by Product" report both break your sales down per product. Two things about these figures surprise people, so they're worth knowing up front.

They show revenue, not profit. Argo Books deliberately doesn't calculate profit per product, because it can't do it honestly. Working out profit on a product needs a reliable cost for that exact product, and there often isn't one: the cost you enter is an optional default, stock is treated as an expense when you buy it rather than matched to the sale, and anything you assemble yourself (a pizza made from flour and cheese) has no purchase cost of its own. Rather than show you a margin that might be wrong, these screens show what's always true: what each product sold for, and how many units moved.

They won't exactly match your Total Revenue. Two differences pull in opposite directions:

  • Refunds aren't broken down per product. A refund is recorded against the invoice as a whole, not against a particular line, so there's no reliable way to know which product it concerned. Per-product revenue therefore reads slightly high for anything that was later refunded.
  • Sales with no line items are excluded. If a sale was recorded as a lump sum without itemising it, there's no product to attribute it to, so it doesn't appear here at all. That pulls the total the other way.

The Analytics tab counts only sales you've been paid for, like the rest of the dashboard. The report version counts all invoiced sales, like the Income Statement.

Things that don't affect your numbers

  • Returns and losses: customer-returned items and lost or damaged stock have their own charts, but they don't feed revenue, profit or expenses. If you refunded the customer, it's that refund that moves your numbers.
  • Bank matching: ticking off bank statement lines against your records is a checking tool. It marks records as matched and nothing else, so it never changes any figure.

Currency display

Argo Books stores every amount internally in US dollars so that businesses dealing in multiple currencies (e.g., invoicing some customers in EUR and others in USD) still get one consistent set of totals. The display currency is whatever you picked in Settings.

  • Stat cards, charts, totals: shown in your display currency.
  • Invoices and customer emails: shown in the currency the invoice was issued in, which is what your customer expects to see.
  • Spreadsheet exports of transactions: the original currency you entered, so the export is faithful to the source.

Why a transaction sometimes shows "Pending" instead of an amount

Every amount is converted using the exchange rate for that transaction's own date. Argo Books never substitutes a different day's rate, because that would quietly change what your books say.

This is unrelated to the Pending invoice status further down the page, which simply means an invoice is ready but hasn't been sent.

If the rate for a transaction's date isn't available yet, the transaction is saved and shown with a Pending marker in place of the converted figure. That happens when you were offline when you entered it, or when the transaction is dated in the future and the rate doesn't exist yet.

While a transaction is pending, it counts as zero in your totals. That's deliberate: including it at the wrong rate would make every total slightly wrong in a way you'd never spot. Argo Books fetches the correct rate automatically once it can, and the transaction joins your totals at that point with no action needed from you.

If a total looks too low: check whether any transactions in that period show Pending. Connecting to the internet and reopening the company is usually enough to resolve them. Future-dated transactions stay pending until their date arrives, which is expected.

Invoice status meanings

The status badge on each invoice is computed from the payment history:

  • Draft: being prepared, never sent.
  • Pending: ready but not sent yet.
  • Sent: sent to the customer, awaiting payment.
  • Viewed: the customer opened it on the payment portal.
  • Partial: the customer paid part of the invoice; some is still owed.
  • Paid: the customer paid the full amount.
  • Overdue: past the due date and not fully paid.
  • Cancelled: voided by you.
  • Refunded: the customer was paid fully, then fully refunded.
  • Partially Refunded: the customer was paid fully, then refunded part of it, or paid, refunded, then paid again so the refund history stays visible.

Example

Let's walk through a simple $110 sale:

  • Product/service: $100.
  • Tax at 10%: +$10.
  • Invoice total the customer pays: $110.

If the customer pays the invoice in full, Argo Books shows:

  • Total Revenue stat card: $110 (gross, what they paid you).
  • Net Profit (assuming no expenses): $100 (revenue minus the $10 tax you owe the government)
  • Tax Collected: $10.

When you open the refund modal, you choose exactly what to refund; you don't have to give the whole invoice back. Each line item on the invoice is a separate checkbox. Tax, fees, and security deposits each get their own row too.

What you see depends on how much you refunded:

Full refund ($110), where you ticked everything:

  • Revenue page: the sale's Total column shows $0; status badge becomes Refunded.
  • Payments page: the original $110 payment plus a separate −$110 refund row.
  • Dashboard: Total Revenue $0, Net Profit $0.

Partial refund ($40), where you only refunded one item:

  • Revenue page: the sale's Total column shows $70 ($110 minus $40); status badge becomes Partially Refunded.
  • Payments page: the original $110 payment plus a −$40 refund row.
  • Dashboard: Total Revenue $70. Net Profit drops by the pre-tax portion of the refund (the tax portion was never profit on the way in, so it doesn't reduce profit on the way out either).
Esc