Money
Month end
One period, one screen: what was issued, what was received, what the tax adds up to, what the bank cannot explain, and whether any number is missing.
The month-end pack is the answer to what your accountant asks for. It covers one calendar month and pulls the whole picture into one pass, so the lines add up to each other rather than being fetched separately seconds apart and disagreeing.
What is in it
- Documents issued
- Every sales invoice and credit note in the period, with the counterparty, their tax identifier, the net, the tax and the gross.
- Documents received
- The same for bills, with the supplier's own number and whether the document is on file.
- The tax summary
- Grouped by rate. Zero-rated turnover is kept as its own group rather than dropped, because its presence is a box on the return — and a reverse-charged rate is kept apart from the same rate charged, because they are different declarations.
- Bank movements
- Every movement in the period, and how many are still unexplained, per currency and per direction.
- Numbering gaps
- Any number in a sequence that no document carries.
A gap in the numbering means something, which is why it is checked
A number is only ever taken when a document is issued, so a hole means a document was removed or moved — worth explaining before somebody outside the organisation finds it. Numbers issued before you moved onto this product are excluded, and voided documents keep their number, so neither reads as a gap.
Exporting it
The pack downloads as CSV, written to be opened in a spreadsheet: a byte-order mark so accented names survive, and the line endings Excel expects.
Cells that a spreadsheet would treat as a formula are defused
A supplier name beginning with =, +, - or @ is a known way to run a command on the machine of whoever opens the file — which here is your accountant. Every cell is written so a spreadsheet reads it as text.
What it does not do
It does not file anything, compute a liability, or produce a return. It assembles the evidence and the arithmetic that assembling it by hand produced, and hands them over in one file. The return is still your accountant's — what has gone is the afternoon spent building the inputs from six statements and two folders.
Where your accountant works in Xero or Zoho Books, the documents can reach them without any export at all — issued invoices file themselves and the payments they record come back. This pack is what they get either way, and it is the whole of a period rather than a stream of documents.