Skip to content

The Accounting page

Who can do this

View Invoices to open the page. Each action needs its own right — see Who can do what.

Click Accounting in the sidebar. It lists every quote, invoice and credit note in the account, newest first.

Once your books are on

When your books are set up, tabs appear across the top of Accounting: Sales (this list), Bank accounts, Journals, Chart of accounts, Trial balance and Reports (which opens your Books dashboard on the Reports page). Without books (never set up, or turned off), the page is just this list. The books' own settings are in Settings › Books.

The Accounting page: All, Invoices, Quotes and Recurring Setup tabs, a search box and filter, and a table of documents with Number, Client, Date, Status, Total, Created By and Recon columns

Across the top:

  • All, Invoices, Quotes and Credit notes narrow the list.
  • Payments lists every payment and refund in the account, newest first, with Edit, Remove and Refund on each. It shows only for someone who sees every client. See Payments.
  • Recurring Setup shows recurring billing.
  • Search number, client or reference… finds a document by its number or its Reference (such as its number in your old system), or a client. A document with a Reference shows it as Ref: under its number. Searching a document's exact number (1024 or INV1024) or Reference also finds it when it's void.
  • New makes a quote or invoice: choose Quote or Invoice, pick the client, and their Accounting tab opens with it ready to fill in, on your default layout for it.
  • Send statements emails statements to the clients who owe you. See Send statements to many clients.

Totals

Under the toolbar, a strip adds up everything that matches your filters and search, not just the rows on screen:

  • Invoiced and Owed on invoices, and Overdue (how much and how many). Click Overdue to show only the overdue invoices.
  • Quoted, on the All and Quotes views.
  • Credited, with the credit still unused.
  • How many void documents aren't shown. Click it to show them.

Each row

Click a row to open the document right there in the list, as it shows on the client's Accounting tab: see Change a document in the list. Click the row again to close it. At the end of each row:

Icon What it does
Send by email Opens the email composer on the client, with the PDF attached and the client's contacts who get invoices filled in.
Record payment Records money the client paid, any amount. It opens with what the invoice still owes filled in, so marking it paid is one click and Save. See Payments.
⋯ Everything else. Right-click the row to open the same menu.
In the menu What it does
Send by email and Record payment The same as the icons.
Apply credit On an invoice that still owes: uses the client's credit on it. Greyed out when the client has no credit. See Apply credit.
Mark unpaid On an invoice paid in full: removes its payment. See Remove a payment.
PDF Opens the PDF.
Open the client Opens the client's panel on the Accounting tab, with the document open.
Credit note Makes a credit note.
Write off Writes off the balance as a bad debt.
Paid short Settles the difference when a client paid a little less, such as a bank fee.
Refund Records money paid back for the sale. Needs Refund and remove payments. See Refund a sale.
Void Voids an unpaid document that isn't reconciled. See Void an invoice.

On a credit note the menu has PDF, and Void while none of it is used. On a write-off or short payment it reads Undo (void it): it voids the credit note, and the invoice owes again.

Anything you don't have the right for, or that can't be done yet, is greyed out: point at it to see why.

Change a document in the list

A row opens its document in the list itself, exactly as it shows on the client's Accounting tab, so there's no need to open the client to change it:

  • Each line's Account (with your books on) or Code: click it to change it, even on a paid or reconciled invoice.
  • Your Quote & Invoice Fields, and each line's Line Fields: click an answer to change it.
  • Edit line items, in the document's own ⋯: changes the lines, dates, layout, Reference or tax. See Change one for what can be changed when.
  • Send, Record payment and Charge saved card, above its lines.
  • Its payments and credits, under its lines: see Payments.

The document's ⋯ has everything its client's tab offers, such as Duplicate and Convert to invoice. What you change shows in the list's row as soon as it's saved, and a duplicate appears in the list as a row of its own. On a credit note, Credit for opens the invoice it credits.

Columns

Click a column's name at the top of the table to sort by it; click again to reverse, and a third time to go back to newest first. Client, Status, Paid, Credit left, Created By, Recon and Reference don't sort. A column of one of your Quote & Invoice Fields sorts by what you see in it — a number or an amount as a number, a choice by its name, a person by their name — with documents that hold nothing in it last.

Choose the columns

Anyone with Manage Users can choose the columns, for everyone in the account. Hover over a column's name and click ⋮:

  • Add Column Left or Add Column Right adds a column beside it: Reference, a column you took off, or any of your Quote & Invoice Fields.
  • Rename Column gives it another name at the top of the table. Rename it to nothing to get its own name back.
  • Remove Column takes it off the list. Nothing on your documents changes, and you can add it back.

Drag a column by the grip under its name to move it. The Quotes & Invoices card on Reports shows the same columns.

Some columns show only where they mean something: Due isn't on the Credit notes view, Paid and Balance are only on invoices, Credit left is only on the Credit notes view, and Recon is hidden while your books are on. A Quote & Invoice Field's column shows only on the views of the documents the field is on.

Date
A quote's date is the day it was made. An invoice's is its invoice date — for a converted quote, the day it became an invoice, not the day it was quoted.
Due
When an invoice is due, set by your payment terms or picked on the invoice. An invoice with no due date is due 7 days after its date. An overdue invoice shows how many days late it is. On the Quotes view this column is Valid until.
Status
Paid, Part Paid or Unpaid, with the day it was paid in full, and Void for a void document. Use Record payment on the row to record money, and Mark unpaid in its menu to take a payment off. A reconciled invoice is locked until you untick Recon. See Payments.
Paid and Balance
What has been paid on an invoice, and what it still owes. On the Credit notes view, Credit left shows what each credit note still has to use.
Recon
Without your books: tick Recon once you've matched the payment in your bank. Paid invoices only. The day it was reconciled shows next to the tick. With your books on, this column is hidden: invoices are reconciled by matching their payments to your bank lines in Bank reconciliation.
Convert to Invoice
Under a quote's number. See Turn a quote into an invoice.

A document whose client was deleted stays in the list, marked Client deleted: its money is still on your books.

Filters

Click the filter icon.

The Filters window: Payment Status, Reconciliation, Created By, Date Created and Date Paid for quotes and invoices, then filters on the client — Client Added, Status, Manager, Origin — and on its custom fields

Filter on the documents — Type, Payment Status, Reconciliation (without your books), Created By, Amount, Date (the date in the Date column), Date Paid, Date reconciled (without your books) — or on their clients, including your custom fields. Filters you set show as chips above the list, and stay set the next time you come back.

Type has All, Invoices, Quotes and Credit notes. It is the same choice as the buttons above the list, so picking one changes the other; on the Quotes & Invoices card on Reports, which has no such buttons, Type is where you choose. To see every invoice still owed money, pick Invoices and, under Payment Status, Unpaid or part paid.

Payment Status has All, Paid, Part paid, Unpaid or part paid, Overdue and Void. Void documents are left out of every choice but Void.

Find a document by its amount

Under Amount, pick Total (the document's total, with tax) or Balance due (what is still owed on it), then type a From and a To. Both amounts are included, so to find an invoice for exactly 10,000, type 10000 in both. With only From, you see documents for at least that amount; with only To, at most. Balance due finds invoices only: quotes and credit notes don't owe anything. If From is more than To, the window says so and the list ignores the amounts until you fix them.

The search box doesn't look at amounts: a number you type there finds a document by its number, such as INV10000.

You can also filter by the documents' own quote and invoice fields, and by their lines: a line field (a department, a job type), a line's Item code, or words in a line's Description. A date field offers the same ranges as the Date filter. Line filters work line by line:

  • Only include filters all have to match the same line. "Region is North" with "Item code is SERVICE" finds the documents with a North service line.
  • Leave out means no line matches it. "Leave out item code DEPOSIT" hides every document with a deposit line.

The list shows each matching document whole, and the counts and totals above it are of those documents. Selecting everything and acting on it, or Export, uses the same filters. You can only filter by a field you're allowed to see.

If the list can't load, it says so with Try again, rather than showing an empty list.

Many at once

Tick the boxes at the start of the rows — or the box in the header for everything the list holds — and a bar appears at the bottom.

Two documents selected: the bar says 2 records selected, with Bulk Actions open — Convert to invoice, Mark as paid, Mark as reconciled, Remove reconciled, and Void locked — and an Export CSV button

Bulk action What it does
Convert to invoice Asks for one invoice date and, if you want, one due date, then turns the selected quotes into invoices. A quote made after that invoice date is dated the day it was made. With no due date, each invoice is due by your payment terms. Void quotes are skipped. Automations that react to it run, such as one that creates the invoice in Xero.
Mark as paid Asks for one paid date, how it was paid and, if you like, a reference, then records a payment for what each invoice still owes. Part-paid invoices are paid off. Quotes and invoices already paid in full are skipped.
Edit selected Sets one or more things on every selected document at once: reconciled, due date, layout, or any of your custom fields. See Bulk edit below.
Void Voids the selected documents. Type void to confirm. Documents with money on them (paid, part paid, or with credit applied) and reconciled documents are skipped.

A message says how many were changed and how many were skipped. When some were skipped, See which lists each one with the reason, for example QU1024 is void, so it can't be made an invoice, an invoice in a locked period, or a quote line that needs an account once your books are on. Refusals stay on screen until you close them.

Bulk edit

Bulk Actions → Edit selected changes the selected documents the way you would change each one yourself, all at once. Pick what to change, give each its new value, and save. You can change up to 30 things in one go:

What you can set What happens
Reconciled Yes marks paid invoices reconciled; No takes the mark off. Quotes, credit notes and invoices that aren't paid in full are skipped. Once your books are on, invoices are reconciled in Bank reconciliation instead, so only No works. Needs Reconcile Invoices.
Due date The new due date on each invoice. Quotes and credit notes are skipped, and so is an invoice whose invoice date is after the new due date.
Layout The layout set each quote and invoice prints with. Credit notes are skipped.
A document field The value of one of your quote and invoice fields, such as a PO number. Leave it blank to clear it.
A line field The value of one of your line fields, set on every line of each selected document. Leave it blank to clear it on every line.

Everything but Reconciled needs Edit Invoices. A field above your Custom Field Edit Level can't be picked.

Some documents can't take some changes, and those are skipped — the rest of the change still happens:

  • Void documents are never changed.
  • Paid, part-paid and reconciled invoices, and invoices in a locked period, keep their due date and layout: those are locked, just as when you open one. Their custom fields can still be changed.
  • A field that isn't on that kind of document is skipped for it — for example a PO Number field that is only on quotes and invoices isn't set on credit notes.
  • A document that already has every value you picked is left as it is.

So one document can be both changed and listed under See which: an invoice that is paid gets its new PO number but keeps its due date.

Each document that changed gets the same note on its client as when you edit it yourself, saying what changed from what to what. Anyone who has that document open is told someone else changed it when they save. And automations that react to a quote or invoice being edited run for each one, as they would for one edit. Reconciling alone writes no note and runs no automation, as ticking Recon never has.

Export

Export CSV in the bar saves the selected documents — or everything the list holds, with the header box ticked — to a CSV file. Exporting needs Export Invoices.

It's a standard comma-separated file, one row per document, oldest first, that opens in Excel, Google Sheets or Numbers. The columns are:

Type, Number, Reference, Client ID, Client Name, Date, Due Date, Subtotal, Tax, Total, Amount Paid, Amount Credited, Balance Due, Payment Status, Date Paid, Reconciled, Date Reconciled and Credit Note For.

  • Dates are YYYY-MM-DD, in your business's timezone.
  • Payment Status is Unpaid, Part Paid, Paid, Credited or Void; for a credit note Unused, Part Used or Used.
  • Credit notes are negative, so a column's total is what you invoiced less what you credited. Credit Note For names the invoice a credit note was made from.

Built a spreadsheet on the old export?

Before November 2026 the export used semicolons and other columns. A spreadsheet, macro or import that reads the old file needs updating to these columns.

To take everything out of BaseCloud, payments and books included, see Leaving BaseCloud.