Skip to main content

Sub Ledgers

Sub Ledgers

This feature allows you to flag Transactions as 'belonging' to different Sub Ledgers. Essentially, it provides an extra level of analysis for S/L, P/L, N/L, SOP and POP transactions.

Note that Sub Ledgers have no effect on how transactions are posted and processed and that the Sub Ledger audit number is in addition to the standard audit number.

Setting up Sub Ledgers:

You can set a permanent default Sub Ledger in Global Options, but this can be overridden for a session, see below.

You can set Sub Ledger to be a Compulsory Entry Fieldin Transactions tab card.

Selecting Sub Ledgers for use:

When entering transactions, a Sub Ledger button on the Header window displays a list window showing the Sub Ledgers available for that ledger.

This applies to all S/L, P/L, N/L, SOP and POP transactions.

This list window also allows you to set a default Sub Ledger for the current session by clicking on the default icon.

How Sub Ledgers are used:

When a Sub Ledger is selected, the system will apply the Transaction Audit number and the Sub Ledger Audit number for that Sub Ledger to the current transaction. These numbers will be applied at the point that the Transaction is saved in order to avoid duplication of numbers. You will receive a message after you have selected to save the Transaction showing the reference number.

Although you will no longer be prompted to enter an Invoice/Credit Note number, you may choose not to use the Sub Ledger default and to type in your own reference number. If you do, then you will not receive the message as above and the Transaction number set against the Sub Ledger will not be incremented, although the Audit number will be.

When printing S/L, P/L, N/L, SOP or POP Transaction reports:

You can use the Simple Search to limit the report to transactions for a specific Sub Ledger.

You can sort and subtotal transaction reports by Sub Ledger.

Please be aware that the Sub Ledger identifier will not be printed on the report.

Bank Sub Ledgers:

Bank type sub ledgers work in a slightly different way. When setting up a Bank type Sub Ledger, a Bank Nominal Code, Account No. and Sort Code should also be entered.

They are only used when the Cash Book System option Do Not Show Sub Ledger is selected for cash book entry and apply only to Cash Book Statements.

When using a Belgian unlock code, they are also used for BACS Export.

With Do Not Show Sub Ledger set, when a Cash Book Statement is entered:

The system will look for a Bank type Sub Ledger with a Bank Nominal Account Code that matches the Bank Account selected on the main Cash Book window.

When it finds one it will apply it to the current transaction.

If there are none, then no Sub Ledger will be applied.

If more than one is found, then the system will use the first found and ignore any others.

Bank type Sub Ledgers will be applied as described above whether or not Sub Ledger is set as a Compulsory Entry Field in Transactions tab.

Did this answer your question?