Skip to content
Training manualAccounting and reports

Chart of accounts and journal entries

The account tree everything posts to, and the manual entries for what nothing else covers.

Every sale, purchase, expense, handover and payment in Exceed Store becomes a balanced double-entry posting automatically. The chart of accounts is where those postings land — assets, liabilities, equity, income and expenses — and it comes ready to use. Manual journal entries exist for the few things nothing else generates: depreciation, accruals, a correction. Most businesses post fewer than ten a month.

Chart of accounts and journal entries
  1. Open Accounting → Chart of Accounts. The default tree covers a trading business; add accounts under the right parent when you need finer detail, or import a whole chart from Excel if you are moving from another system.

  2. Accounts marked as system accounts — cash till, bank, receivables, sales, cost of goods — are the ones automatic postings use. Rename them if you like; do not delete them.

  3. A custom account's code and type can be changed until the first journal line is posted to it; after that they are shown read-only with the reason. Changing the type also needs the account to have no sub-accounts, and the parent must be of the new type. A custom account can be deleted (with the Delete permission) only when it has no journal lines at all, no sub-accounts, and is not linked to a payment method, expense category or wastage reason — otherwise the message lists every reason. A deleted account's code can be reused for a new account, as long as nothing still points at the deleted one.

  4. Accounting → Journal Entries lists every posting, automatic and manual. Open one to see its lines and the document that produced it.

    Chart of accounts and journal entries — 4
  5. To post manually, choose New, enter the date and a description, then debit and credit lines. The entry will not save until it balances.

    Chart of accounts and journal entries — 5
  6. Accounting → Account Statement shows one account over a period with every line and a running balance — the detail behind any figure in the trial balance. Cancelled entries — the old posting of a deleted or edited document and its reversal — are left out, opening balance included; they still appear, marked Cancelled, in the journal entries list. Editing, deleting or cancelling a document reverses its old entry on that entry's own date, so a document dated in a locked month or a closed year can't be edited, deleted or cancelled until the month is unlocked or the year reopened; the message names the month.

  7. The Account Statement has a Note column with the note written on the source document (receipt, expense or supplier payment voucher, journal voucher description, order note, return reason). Export to Excel (for users with export permission) gives the same filters, the opening and closing balance and every line, uncapped.

    Chart of accounts and journal entries — 7
  8. The Account Statement's memo column is gone (it repeated the code and the note). Each line's code cell shows the document type in small grey text above the code (Receipt voucher, Expense voucher, Journal voucher...), and Note holds what the user wrote; on a manual journal voucher that includes the line's own memo. The Columns button chooses which of date, document type, code, note, debit and credit show; the balance always shows. The choice is saved per user and applies to the screen, print and Excel export (where the document type is its own column). The customer and supplier statements work the same way, with their amounts split into debit and credit, and a supplier payment names what it was paid from.

  9. A manual journal voucher can be edited in place (Edit on its page, same number, recorded in the audit log) as long as its month is open; a locked month or a cancelled voucher is refused. Deleting a voucher no longer erases it: it is cancelled by a mirror entry dated the same day, both stay in the journal marked Cancelled, and statements ignore them (a locked month refuses the delete). Reverse entry on the journal is for manual vouchers and the company's opening-balance entry only; an entry posted automatically by a document (a sale, purchase, voucher, return, stock count, year closing...) is corrected from that document, and a year closing by reopening the year. A voucher can't use an account that is deleted or inactive. If an old entry still sits on an account deleted earlier, the statements show it under that account marked (deleted) so the books still balance.

  10. A manual journal voucher line on the customers (receivables, 1100 and its sub-accounts) or suppliers (payables, 2000 and its sub-accounts) account must name the customer or supplier it belongs to: the voucher form shows a Customer or Supplier picker on such a line, and saving is refused without it. A customer or supplier can't be set on any other account. The amount counts in that customer's or supplier's balance (a debit on receivables raises what the customer owes, a credit lowers it; the reverse for suppliers), shows in their statement as a Journal voucher row linking to the voucher, and keeps the customers' total equal to the receivables account. Reversing, editing or deleting the voucher updates the balance. Old voucher lines with no customer or supplier stay as they are, but such a voucher can't be saved again until the line names one. A customer can't be deleted while their balance is not zero, and a supplier with such a line can't be deleted.

Good practice

  • On a manual voucher, a line on the customers or suppliers account must say which customer or supplier it is for. The amount then counts in that customer's or supplier's balance, in their statement and in their credit limit.
  • A voucher in a locked month or a closed year cannot be edited, reversed or deleted. Unlock the month first, then make the change.
  • If you work in one branch only and post a manual voucher, you are taken back to the list with a confirmation. The voucher belongs to the whole company, not to your branch.
  • A cancelled entry (an entry and the reversal that cancels it) is not counted in any report. If the opening-balance entry is cancelled, you can post it again.
  • Rounding Differences (5040): a purchase document's total and the stock value its lines record can differ by fractions of a fils. Inventory (1200) is posted at the stock value so it always equals the stock report, the payable stays at the invoice total, and the fraction goes to Rounding Differences. Older documents keep their old figures until they are edited.
  • Enter opening balances as one journal entry dated the day before you started, then let everything else post itself. Stock entered as items' opening quantities is already in Inventory — don't state it again.