Accounting, the close and reports in ERPNext

Everything up to here produced entries. This station verifies they are correct, and closes the month so that nobody returns to change a figure after a decision has been built on it.

It is also the station that separates someone who uses the system from someone who is trusted with it. Entering documents is a skill learned in a week; closing a month correctly is a skill people are hired for.

Start at the bank, and nowhere else

The ordering is deliberate, and the reason fits in a sentence: the bank statement is the only figure in your books written by an outside party. Everything else was written by your own team, so it inherits your team’s mistakes.

Which makes bank reconciliation not a routine item at the bottom of a list but the fixed point everything else is measured against. Hence first, not last.

ERPNext provides a tool that imports the statement, matches its lines against your entries automatically where it can, and leaves you what it could not match. All the value is in what did not match, because every unmatched line carries a diagnosis:

What did not match	What it means	What you do
A bank line with no entry	Cash moved and was not recorded	Record it — bank charges, a direct collection, a deduction
An entry with no bank line	A cheque issued and not yet presented	Leave it outstanding, and watch its age
A difference in amount	An entry error, an exchange difference, or a transfer fee	Correct the source, not the reconciliation
A line duplicated on both sides	A double entry	Cancel the surplus with a document, never by deleting

The non-negotiable rule: do not close a month with one unexplained bank line in it. A single unknown line today is ten of them three months from now, and by then it is a file nobody opens.

The intermediate accounts, each naming its own problem

This is the shortest section on the path and the most useful at work. Three accounts, each of which should approach zero at month end, and whose remaining balance tells you precisely what did not complete.

Account	Fills at	Empties at	A remaining balance means
Goods received not invoiced	The purchase receipt	The supplier invoice	Goods received whose invoices never arrived
Delivered not invoiced	The delivery note	The sales invoice	Goods delivered and never billed — revenue never recorded
Cash in transit	A transfer out of a till or account	Its arrival at the destination	Money that left and did not arrive

Read the second row again. Revenue never recorded is not a technical remark; it is goods the company handed over and never asked anyone to pay for. Whoever inspects that account monthly finds forgotten invoices in it regularly, and whoever does not inspect it never finds them at all.

That skill — reading an intermediate account balance and naming the problem before you open a report — is the fastest way to distinguish yourself in an interview.

The close checklist

In a deliberate order. Each item assumes the one before it:

1. Reconcile every bank account, with not one unknown line remaining.
2. Agree the stock account balance to the valuation report, as at station six.
3. Review the three intermediate accounts, explaining every remaining balance in a sentence.
4. Review receivables and payables ageing, looking for old balances with no movement on them.
5. Inspect the month’s manual journals. Every manual journal is an exception, and every exception has a written reason — and a manual journal on a stock or receivables account is treated as an alarm rather than a line item.
6. Confirm every document is submitted and nothing was left in draft. A draft has no entry, so it is a movement that happened in reality and is absent from the books.
7. Review the tax report and agree it to the return before filing.
8. Freeze the period. That item is the difference between a close and a claim of one.

Freezing, and the two tools for it

ERPNext offers more than one way to stop a closed period being disturbed:

A freeze date — refuses any entry dated before it, with the exception granted to a named role. That is the everyday tool, and the one used after every monthly close.

A period closing entry — carries income statement balances into retained earnings at the end of the fiscal year. That is an annual procedure, not a monthly one, and it should never be confused with the first.

The verdict: a month with no freeze date is not closed. Any user remains able to add a backdated entry, an income statement already presented to management changes, and nobody knows it changed. The consequence is not merely accounting: a report shown to a board and then silently altered costs the whole system its credibility.

The three statements, and what to read in each

The trial balance. The first thing opened. Total debits always equal total credits — which proves balance, not correctness. A wrong entry in the right account balances perfectly. What you are looking for here is anomalous balances: a supplier with a debit balance, or an expense account with a credit one.

The income statement. Not read from net profit. Read from gross margin percentage, because it is the only number that tells you something changed in the operation. Net profit moves for ten reasons, most of them outside operations; margin percentage moves only for a real one — a selling price, a purchase cost, or a delivery and an invoice whose timings separated as at station five.

The balance sheet. Four figures read before any others: cash, receivables, inventory and payables. Those four describe working capital, which is the company’s ability to survive next month — closer to a management decision than any other number on the statement.

Reports you build yourself

ERPNext lets you build reports from inside the interface with no code: pick fields, group, filter, and save the view for reuse every month.

That is not a minor feature for a learner; it is the cheapest substitute for customisation. Most of what reaches developers under the heading “we need a new report” is answered by a grouping on an existing one, and that is the first rule at station nine.

So build three reports now and save them: sales per customer per month, stock valuation per warehouse, and receivables ageing. All three are asked for at every company, and someone who builds them in ten minutes saves their project a week.

The acceptance test for this station

1. Run a full bank reconciliation against a statement containing at least one line with no matching entry.
2. Open the three intermediate accounts and explain each balance in a single sentence.
3. Close a month against the checklist above, then set the freeze date, try to post an entry before it, and read the refusal.
4. Read gross margin percentage for two consecutive months and explain the difference by one specific cause.
5. Build and save the three reports above, then export one of them. The close checklist you wrote is a portfolio piece.

Close logic independent of any product is set out in the ledger and the close. What this product ships as ready financial reporting, and what remains yours to build, is detailed in the ERPNext guide.

What comes next

You know your books are correct. The next station asks an entirely different question: are they acceptable to the tax authority in your country? — with a direct answer on who ships e-invoicing for ERPNext and who does not, and why document cancellation collides with the invoice requirement.