RE: I am running a GL report and wanted to know if I could add a “external id” as a column
This can be done, but not out of the box. I would recommend creating a custom external id field on your transaction/entity records that is automatically populated from the source external id field value. This can be achieved with a simple script or workflow.
I hope this helps!