Hi Kate,

In Sage 50 Accounts, each journal credit (JC) and journal debit (JD) is a separate transaction. They therefore have a separate number, even if they form part of the same journal.

For example, a journal can be made up of five transactions, three JDs and two JCs, totalling the same amount. However, each of these five transactions will have their own unique transaction number.

You can run the Day Books: Nominal Ledger report to see exactly which journals have been posted and which transactions make up these journals. This report is held in Nominal codes > Reports > Day books.

Hi Kate, though you may no longer need the solution 6 years later but I found the way to match these JC/JC transactions:

The easiest way is to keep same ref number for regular transaction journals  Accruals and prepayments for example and so on

or use extra ref to categorise further

"mark these transactions" with something unique, applicable for these types of journals each line ACCR  PREP  HREXP  WAGES  FUND01

you can do it when either typing journal in manually or loading bulk import. It will be easy to filter both sides together in the future.

Regarding past years analysis ...

If you can create custom report or connect Sage 50 to Excel or Power BI (Power Query ODBC connection)

Tables AUDIT_SPLIT and AUDIT_JOURNAL have field called RECORD_CREATE_DATE

It records date and time of created transaction to a second

Pull data out, use  dd-mm-yyyy hh:mm removing seconds, you can map pretty much all the other side of JD/JC leaving only few to map manually.

Hope it helps