Access Expense supports Sage 50 exports out of the box. For other Sage packages, you can create a custom export using the Header Sequence field to obtain the reference.
If you need the Reference in your report, select Header Sequence as one of the columns for your custom export. Add the letters EXP in front of each sequence number to get the Reference.
To do this quickly in Excel, use the formula:
=CONCATENATE("EXP",[CELL REF])
=CONCATENATE(“EXP”,[CELL REF])
Replace [CELL REF] with the cell reference containing the Header Sequence number.